 |
Database Indexing – an Introduction
Author: Stephen J. Richards  | Posted: 17-09-2007 | Comments: 0 | Views: 72 | Rating: (58)  (?) 
Databases are excellent data storage and retrieval tools, ranging from simplistic tables of information to complex, intricate collections of multiple linked databases. A database is created and named based on the particulars of its application, and stores data in tables consisting of an organized collection of rows and columns. Data may be manually entered into databases, but is more commonly written dynamically into databases by web sites or by connected software applications. Companies often maintain constantly growing databases containing data such as client information, financial figures and performance analyses, for instance, and the ever expanding nature of such databases warrants techniques for streamlining the process of locating specific pieces of information within them. Indexing allows for the rapid retrieval of specified data by queries, and is therefore a powerful tool for databases containing hundreds or even millions of records.
At initial set up, the creator of a database typically defines the primary key, which is a column within which the data in each row is unique. For example, a column containing client last names would not be identified as the primary key, as multiple entries may have the same name. However, a column containing unique client ID numbers could be designated as the primary key. When the primary key is defined, an index is actually created. When data from the column defined as the primary key is requested in the form of a query, the database automatically utilizes this index to quickly locate the requested data. However, the primary key is likely not the only column that will need to be searched for data. For queries that will be used frequently, an index can be added to the appropriate column to speed up the process of data selection. Indexes speed up the process of retrieval while lessening the workload the server must endure to perform the search.
Much like the way the index of a book makes finding a topic easier, database indexes make locating a queried piece of data easier. Instead of flipping through and reading each individual page of a book to locate a topic, you can refer to the book’s index and know where to look right away. Likewise, instead of a query asking each record in a database if it contains the information being sought, it can be directed by an index to the appropriate data.
Effective use of indexes requires establishing a balance between an efficient number of indexes and too many. Since indexes take up space, using too many can counteract the purpose by slowing the database down. Indexes may be unnecessary for smaller databases, where the queries can locate data quickly and easily. But indexes are dynamic and powerful tools for optimizing the performance of large databases.
Rate this Article:
Current: 0 / 5 stars - 0 vote(s).
Article Source: http://www.articlesbase.com/databases-articles/database-indexing-an-introduction-215589.html
|
Submitting articles has become one of the most popular means of generating quality backlinks and targeted traffic to your website. Join us today - It's Free! |
|
Related Articles
Challenges to Data Retention
By: Stephen J. Richards | 12/09/2007 | Data Recovery
Instead of moving emails, documents and other business records onto tape, companies may be advised to store data on disk systems for longer periods of time. Coupled with the right archiving software, disk systems can reduce data retention, reproduction and management.
Got a Question? Ask.
Ask the community a question about this article:
Q&A Powered by: 
Latest Databases Articles
Database Management Services
By: Smit Mathur | 24/07/2008
Undoubtedly a comprehensive term, Database Management Services comprise of inclusive range of activities entailing handling database, keeping it up 24 by 7 on an optimum server and ensuring dynamism and accessibility with state-of-the-art upkeep of the database.
Eliminating the Standard Textbook With Xml Content Servers
By: 10x Marketing | 18/07/2008
The Internet, the accessibility to computers and changes in the publishing industry, new resources for accessing information at universities is in high demand. With the aid of XML content servers , students and professors are finally getting access to great information at an affordable price.
How to Effectively Convert Document Into Another Format
By: Aditya patel | 10/07/2008
An effective document conversion service is very important part in a successful advance marketing business. You should focus on improving conversions at all levels of the business.
The Wide Area Network and Client Server Applications
By: Kh Atiar Rahman | 22/06/2008
Infrastructure servers provide support for wide area network (WAN) communications. This support typically includes support for a subset of IBM System Network Architecture (SNA), asynchronous protocols, X.25, ISDN, TCP/IP, OSI, and LAN-to-LAN NetBIOS communication protocols. In the Novell NetWare implementation, Gateway Communications provides a leading communications product. In the LAN Server and LAN Manager environments, OS/2 communications server products are available from IBM and DCA. In th
Geolocation in a Nutshell
By: Christopher Parker | 19/06/2008
Learn about Geolocation, pros, cons, and how it effects your internet experience.
Databases and Maintaining Their Uptime
By: Stephen J. Richards | 19/06/2008
Databases provide a convenient means of storing vast amounts of information, allowing the information to be sorted, searched, viewed, and manipulated according to the business needs and
goals. A computer database relies upon software to organize the
storage of data.
Migrating From Microsoft Access to Mysql
By: Intelligent Converters | 16/06/2008
This article discovers common techniques of migrating MS Access data to MySQL server and possible issues during the conversion process.
Decode Function
By: sailaja | 06/06/2008
DECODE Function helps a lot in projects.
More from Stephen J. Richards
Outsourcing Technical Support
By: Stephen J. Richards | 22/07/2008 | Software
Technology, we all have to have it to run our businesses more efficiently. Although technology has allowed us significant increases in productivity and efficiency, they have not come without cost. The level of sophistication necessary to resolve technical issues has also increased; therefore, when a problem occurs, end users generally are not able to fix it themselves and must turn to professional support for help.
Databases and Maintaining Their Uptime
By: Stephen J. Richards | 19/06/2008 | Databases
Databases provide a convenient means of storing vast amounts of information, allowing the information to be sorted, searched, viewed, and manipulated according to the business needs and
goals. A computer database relies upon software to organize the
storage of data.
Centralizing Data Storage
By: Stephen J. Richards | 06/05/2008 | Computers
Management of business data is becoming ever more complex and important with increasing pressures of security, regulatory compliance, and corporate governance. Technology is allowing businesses to create and store exponentially more data.
Greening Up Your it Department
By: Stephen J. Richards | 18/04/2008 | Computers
We all want to improve our environment, and especially now, we want to be more conscientious of how our actions affect our planet. Taking simple steps in your place of business is no different than making steps at home.
How and Why Databases are Reorganized
By: Stephen J. Richards | 07/02/2008 | Computers
Administration of IMS full function and Fast Path databases can have
a significant impact on the overall performance and usability of critical business applications.
Outsourcing and Archiving your Data
By: Stephen J. Richards | 16/01/2008 | Data Recovery
Whether a company relies heavily on database activity for critical everyday business operations or only for select requirements, the loss of data due to technological failure can have far reaching negative implications.
Backing Up your Computer Verses Archiving
By: Stephen J. Richards | 16/01/2008 | Data Recovery
The concepts of backing up a computer and archiving documents often get confused.
Redundant Internet Access for Businesses
By: Stephen J. Richards | 17/09/2007 | Information Technology
Businesses are increasingly reliant on internet availability for their critical business operations and revenue generation. Today, many businesses rely solely on the internet for their mere existence, making internet availability a critical element of their business strategy.
|
|
Computers 
