Home arrow MySQL arrow Page 2 - Introduction to Databases

The Big Picture - 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

Before we get into the nitty-gritty of what MySQL is and isn’t, let’s take a little time out to answer a basic question: What’s a database, anyhow?

A database, fundamentally, is a collection of data organized and classified according to some criteria. The traditional analogy is that of a filing cabinet organized into drawers (see the following illustration), with each drawer holding files related to a particular subject; these files may be further classified according to a particular set of criteria (alphabetically, by color, by numeric code, and so on). This organization of information into drawers and files makes it easy to retrieve specific bits of information quickly— to lay your hands on a particular piece of information, you pull open the appropriate drawer and select the file(s) matching your criteria.

Databases - How they work

An electronic database helps you organize information and provides the tools necessary to access specific bits of it quickly and efficiently. The drawers that contain the files are referred to in database parlance as tables, the files themselves are called records, the act of pulling out information is referred to as a query, and the resulting data is referred to as a result set. The following illustration shows how you query the database (here, a filing cabinet) to retrieve information. You’ll be seeing a lot of these terms in this book, and you’ll get used to them gradually, so don’t worry if they seem a little foreign at the moment.

Databases - How They Work

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: