Databases are valuable resources that enable a myriad of business tools and practices, such as customer relationship management, efficiency analyses and projection reports, to name a few. Still, many people have difficulty conceptualizing what exactly a database is. A database is an organized collection of often vast amounts of related information that can be readily accessed and used as input to a range of applications that may present new or deeper insight into the business or enable new competitive advantages. In one sense databases can be likened to spreadsheets, containing fields and records of related but separate information that can be accessed for analysis. In fact databases and spreadsheets can in some cases be used in lieu of one other, but spreadsheets mainly answer inquiries about numerical data while databases are likely to contain more complex items such as images, dates, links, text, and numbers. The range of information that can be contained within and accessed by databases makes them indispensable for business data retention, compilation and interpretation.
To understand a database, first understanding some basic database related terminology is helpful. A field is a single aspect of the data contained within the database, while a record is the collection of data for one item in the database. Assume we are creating an employee information database that will contain employee names, addresses and telephone numbers. The employee name ‘Rebecca Smith’ could theoretically be contained within a field, while Rebecca’s name, address and telephone number would constitute one complete record. The single collection of all of the employees’ contact information represents a table, and multiple tables may be linked to other related tables, creating a relational database.
Planning is an important stage in database development to ensure that necessary information can easily be retrieved and utilized. Assume our employee information database above contains the first and last name of each employee in a field designated for employee name, with the complete address stored in the address field. Now suppose we need to create an alphabetical list of all employees by last name who live within ten miles of the office. For a well planned database, this would be a basic task. But for this example, how could the database distinguish between first name and last name, and how would it interpret the jumble of information we call ‘address’? It wouldn’t, which is what makes database planning so important. By anticipating how information would need to be retrieved in the future, we could have eliminated this problem by structuring separate fields for first name, last name, street address, city, state and zip code.
Databases do not only store information, they typically provide an interface through which users can collect and analyze information with ease. Most databases provide users with a means of establishing the data structure, form tools for easy data entry, a query engine which allows us to request information from the database and a report function for outputting the results of queries.
For businesses, information is power. Databases give companies unprecedented means of retrieving and analyzing important data that allows them to continuously improve and streamline processes for increased efficiency and ultimately, increased profitability.
Got a Question? Ask.
Ask the community a question about this article:
Frequently Asked Questions
What do new owners think of the new Apple 3G ...
By: SusieQ | 11-07-2008
What do new owners think of the new Apple 3G IPhone in terms of ease of use and quality?
Tmobile Sidekick Help
By: Raz Bby | 04-07-2008
Do I have to buy a phone at whole price or do i pay after the instant rebate?
Tech vs A&M
By: Deb | 30-06-2008
The classes at Texas Tech and A&M don't match on the Texas Common Course Numbering System (Political Science, Calculus, Chemistry). If I want to transer to A&M, will the courses I took transfer from Tech or do I have to start over?
FTL Gluons
By: Pedr ap Gwilym | 29-06-2008
Gluons exist otherwise everything would fall appart as it were. Gluons exist ONLY at FTL.
Glass Wings - StarTrek Transparent Aluminium?
By: Pedr ap Gwilym | 29-06-2008
Would you be able to see through this? Transparently, of course!
How do I enter an AOL confirmation code on my computer?
By: Cozyc62 | 28-06-2008
How do I enter an AOL confirmation code on my computer?
Q&A Powered by:
Latest Databases Articles
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.
Database Deployment: Synchronizing Database Structures
By: Perpetuum Software Team | 28/05/2008
Manually synchronizing new revisions of database structures with an already running system can be a nightmare. Learn about the tools you need to easily synchronize database structures.
More from Stephen J. Richards
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.
Database Indexing – an Introduction
By: Stephen J. Richards | 17/09/2007 | Databases
Much like the way the index of a book makes finding a topic easier, database indexes make locating a queried piece of data easier. Indexes may be unnecessary for smaller databases, where the queries can locate data quickly and easily.
Computers 
