 |
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.
|
 |