Home arrow MySQL arrow Page 5 - Introduction to Databases

...And the Little Database that Could - 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

MySQL is a high-performance, multi-threaded, multi-user RDBMS built around a client-server architecture. Designed specifically for speed and stability, it has, over the last few years, become one of the most popular RDBMS for database-driven software applications, both on and off the web. Today, more than 4 million web sites create, use, and deploy MySQL-based applications; that number rises daily (as stated on the official MySQL web site, at http://www.mysql.com/).

The MySQL RDBMS consists of the following two components:

  • Server-side tools These include the MySQL database server, which is the core software engine responsible for creating and managing databases, executing queries and returning query results, and maintaining security, together with additional tools to manage multiple MySQL servers, optimize and repair MySQL tables, and create bug reports.

  • Client-side tools These include a command-line MySQL client, tools to manage MySQL user permissions, and utilities to import and export MySQL databases. Also included are command-line tools to view and copy MySQL databases and tables, maintain tables, and retrieve server status information. These components are discussed in detail in subsequent chapters of this book.

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: