Once a lesser-known category of software, databases have become a more and more important part of technical communication practice. Today databases often drive documentation collections, including content management systems and wikis. The most sophisticated databases tend to employ the SQL language.
With many database vendor products in the market and data intensive applications using them, it is often required to port the application to use the data or, migrate the data so that the application can use it. Migration of data is therefore one of the realities of the IT Industry. Some of the author's previous articles on migration can be found at the link.
The notion of an integrated project database (IPDB) has existed for decades. Over that time many projects have been undertaken to develop the technologies and frameworks required to implement an IPDB. Also over that time, there has been promotion of the benefits and impacts that IPDB systems will have on the industry. As there are still no industrially stable IPDB systems in existence, the industry's perception of what they are and what they can do has diverged from many of the original presentations. It is also clear that researchers and de-velopers involved in IPDB development have many different ideas about what constitutes an IPDB and what is, or is not, possible to create. This paper aims to describe misconceptions which are growing up around IPDB systems, and presents the authors' view of reality (informed by the opinions of the UK network of experts in ob-jects and integration (URL-1 1999) which was run by the DETR).
MobiLink is a technology that can help multiple databases synchronized, a key requirement for mobile access to data. The article shows you how to create a model that can be deployed to access data on a SLQ 2005 Server remotely with a SQL Anyhwhere database. A forth coming article descibes the deployment details.
MySQL is old news ...or is it? In this fast-paced expose, Blane looks at where MySQL is now, and what's planned in Versions 4.1 and 5 - including the exciting developments of MySQL Cluster and Stored Procedures!
Narrative Enquiry: A Way to Get Organizations (and the People in Them) Talking and Acting Differently: An Account of Methods of Intervention to Enquire into Conditions Surrounding Records Management and Filing to Catalyze Change
Narrative enquiry: A way to get organizations (and the people in them) talking and acting differently: An account of methods of intervention to enquire into conditions surrounding records management and filing to catalyze change
CVS, part of the glue that holds open source development together, is showing its age. Many competitors have emerged recently, fixing misfeatures and adding new ideas. Shlomi Fish explores several current open source version control systems that may be better than CVS for your needs.
The performance of spatial queries depends mainly on the underlying index structure used to handle them. R-tree, a well-known spatial index structure, suffers largely from high overlap and high coverage resulting mainly from splitting the overflowed nodes. Assigning the remaining entries to the underflow node in order to meet the R-tree minimum fill constraint (
Unlike most of the other projects in this book, NoSQL is not a tool, but an ecosystem composed of several complimentary and competing tools. The tools branded with the NoSQL monicker provide an alternative to SQL-based relational database systems for storing data. To understand NoSQL, we have to understand the space of available tools, and see how the design of each one explores the space of data storage possibilities.
As a measure of information shared between two fuzzy pattern vectors, the fuzzy information proximity measure (FIPM) plays an important part in fuzzy pattern recognition, fuzzy clustering analysis and fuzzy approximate reasoning. In this paper, two novel FIPMs are set up. Firstly, an axiom theory about the FIPM is given, and different expressions of the FIPM are discussed. A new FIPM is then proposed based on the axiom theory of the FIPM and the concept of fuzzy subsethood function. Two concepts based on the idea of Shannon information entropy, fuzzy joint entropy (FJE) and fuzzy conditional entropy (FCE), are proposed and the basic properties of FJE and FCE are given and proved. Finally, classical similarity measures such as dissimilarity measure (DM) and similarity measure (SM) are studied, and two new measures, fuzzy absolute information measure (FAIM) and fuzzy relative information measure (FRIM), are set up, which can be used as measures of the proximity between fuzzy sets A and B.
MySQL combined with PHP is a powerful tool. However, most beginners won’t know where to start, on how to extract the data from their databases, or what have you. There is just about 50 MySQL functions in PHP, all used to help you accomplish what you need with PHP. However, you’re probably not going to use them all, and below I’ll explain the key features.
Can you trust the leading open-source database engines, PostgreSQL and MySQL, to deliver the performance and features that the Oracles, SQL Servers, and DB2s of the world do? Not just yet, but they could offer enough to meet your needs. Find out how they stack up against each other, as well as against the commercial alternatives.
The process of programmatically creating the SQL Server Reporting Services (SSRS) tabular report is described. You will be creating a very simple report using the provided code. The approach is to introduce the programming by creating the three parts of a report: connection, dataset, and layout. Excerpt from the book, "Learning SQL Server 2008 Reporting Services.'
Many organisations are attempting to clarify the relationship between the corporate intranet, and their document/records management system. While this is a broader issue of information management with an organisation, there are some short-term activities that can be taken to create a working relationship between these two platforms. This briefing outlines a simple scenario in which the intranet helps staff find key corporate information, while the documents accessed are stored in the document/records management system.
This hands-on tutorial should help you in understanding the interface available for querying MS SQL Server 2005 databases. Some of the major features will be discussed as related to their use rather than going into a lot of details. Querying the database is one of the most basic activities that is routinely and frequently performed.
Many articles have been written on what is probably the single most ubiquitous interface element within Web applications today: the form. Forms justifiably get a lot of attention because their design is critical to successfully gathering input from users. Registration forms are the gatekeepers to community membership. Checkout forms are how eCommerce vendors close deals. But what goes in must eventually come out, and the information users provide to Web applications often makes its way back to users in the form of tabular data.
Some types of searching operations stand apart from others in that they represent a different way of thinking about searching. Perhaps you're displaying a result set one page at a time. Half of that problem is to identify (search for) the entire set of records that you want to display. The other half of that problem is to repeatedly search for the next page to display as a user cycles through the records on a display. Your first thought may not be to think of pagination as a searching problem, but it can be thought of that way, and it can be solved that way; that is the type of searching solution this chapter is all about.
A function is a special type of command word in the SQL99 command set. In effect, functions are one-word commands that return a single value. The value of a function can be determined by input parameters, as with a function that averages a list of database values. But many functions do not use any type of input parameter.
Beginners Guide to SQL Server Integration Services Using Visual Studio 2005 provides you with the basic knowledge that you should have before you move on to more advanced ETL [Extraction, Transformation, and Loading]. The book will also provide you with a comprehensive description of the many designer windows that you may encounter while working with the designer. This guide provides the building blocks describing each block by way of an example as well as describing the nuts and bolts that bind the blocks. A majority of SSIS tasks are covered in this book and they are described fully in the summary of table contents section. You start building packages right from Chapter 2 and continue on to Chapter 20 gathering and building upon your knowledge in each step.
Even if the vast number of end users leads to high calculation loads outside the database, you can generally throw hardware at the application load (the load outside the database, that is), hanging as many application servers as necessary off the single central database.
Case study describing the realignment of the Business Information Service (BIS) in ABN AMRO. Explains the reasons for change and the plans to incorporate the concept of continuous improvement, helping to ensure the service constantly evolves to meet demands of the organization. Includes a description of the bank and its operations and explains the role of the BIS within it. Explains how the service will be realigned to embrace the principles of continuous improvement, covering changes in both the Research and Support Services sections, and outlines how these changes will be achieved. Concludes that to make a difference, such change must be a constant.
Whether you want to build your own forum, publish the messages from a mailing list on your Website, or write your own CMS: there will be a moment that you'll want to store hierarchical data in a database. And, unless you're using a XML-like database, tables aren't hierarchical; they're just a flat list. You'll have to find a way to translate the hierarchy in a flat file.
To perform complex tasks, workplace computer users have to know how to control their programs and adapt program capabilities to the needs of their job goals and methods. I inquired into the instructional information that will help users learn such adaptive computing for complex data processing tasks by interviewing twelve experienced database users and analyzing twenty-five exchanges between experts and users on a database helpline network. Findings show that instructions may help users emulate expert approaches to adaptive computing for complex tasks by providing enough substantial technical information to help clarify task problems, goals, methods and analogies and presenting it in the form of rules of thumb, general procedures, and task-to-program explanations.