Home arrow MySQL arrow Page 3 - Introduction to Databases

Database Management Systems - MySQL

Today, Vikram shows us the basics of a database and are introduced to concepts like Database Management Systems and Relational Database Management Systems. We are also given a thorough overview of MySQL and its features. This excerpt comes from chapter one of MySQL: The Complete Reference, by Vikram Vaswani (McGraw-Hill/Osborne, ISBN 0-07-222477-0, 2004).

TABLE OF CONTENTS:
  1. Introduction to Databases
  2. The Big Picture
  3. Database Management Systems
  4. The Challenge
  5. ...And the Little Database that Could
  6. History and Evolution
  7. Features
  8. More Features
  9. Even More Features
  10. Applications
  11. Summary
By: McGraw-Hill/Osborne
Rating: starstarstarstarstar / 61
February 23, 2004

print this article
SEARCH DEV SHED

TOOLS YOU CAN USE

advertisement

Although you can use a database to organize both small and large amounts of information, its true power becomes apparent when you need to manage a substantial volume of data. If, for example, you have a small amount of data to deal with, you can easily manipulate and search it manually; however, as the volume of information increases, performing a manual search becomes both tedious and costly. Consider a filing cabinet containing 20 files versus one containing 20 million filesólocating a single file in the first cabinet takes a matter of minutes, whereas locating a single file in the second cabinet is well nigh impossible (given efficiency constraints).

In such situations, an electronic database management system (DBMS) can substantially simplify your work. Not only does such a system take up less physical space than its traditional paper-based counterpart, but it also comes with tools that assist you in organizing your data and simplifying information retrieval and modification. Built-in indexing makes it possible to locate information rapidly and efficiently, while automated processes ensure that data is always stored and cross-referenced in a consistent, error-free manner. A database also offers portability and compatibility (once the data is organized and stored in a database, it can be extracted and displayed in any manner you choose), and it provides a centralized storage location for important information.

A relational database management system (RDBMS) takes things one step further by creating relationships among the tables that make up a database. These relationships can then be used to combine data from multiple tables in various ways, allowing a user to view the same data from various perspectives and then use this enhanced vision to make better (read: more efficient and cost-effective) business decisions. By creating links among related pieces of information, an RDBMS thus not only makes it possible to store information more efficiently (by removing redundancies and repetition), but it also brings to the fore hitherto undiscovered relationships among disparate segments of data and permits efficient exploitation of those relationships.

Remember: this is chapter one of MySQL: The Complete Reference, by Vikram Vaswani (McGraw-Hill/Osborne, ISBN 0-07-222477-0, 2004). Vikram is the founder of Melonfire, and has had numerous articles featured on Dev Shed.
Buy this book now.



 
 
>>> More MySQL Articles          >>> More By McGraw-Hill/Osborne
 

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort
   

MYSQL ARTICLES

- Oracle Unveils MySQL 5.6
- MySQL Vulnerabilities Threaten Databases
- MySQL Cloud Options Expand with Google Cloud...
- MySQL 5.6 Prepped to Handle Demanding Web Use
- ScaleBase Service Virtualizes MySQL Databases
- Oracle Unveils MySQL Conversion Tools
- Akiban Opens Database Software for MySQL Use...
- Oracle Fixes MySQL Bug
- MySQL Databases Vulnerable to Password Hack
- MySQL: Overview of the ALTER TABLE Statement
- MySQL: How to Use the GRANT Statement
- MySQL: Creating, Listing, and Removing Datab...
- MySQL: Create, Show, and Describe Database T...
- MySQL Data and Table Types
- McAfee Releases Audit Plugin for MySQL Users

Developer Shed Affiliates

 


Dev Shed Tutorial Topics: