The
astronomically large amounts of data, that we have to cope with today
and even more in the future, cannot be managed and used without
databases, structured collections of data.
What databases should we build up first ?
Every person got a personal list of priorities.
Most likely most people will start with their current occupations. The occupational documentation with the top10000 comes first.
Parts of every documentation of an occupation are:
1 The Table of Contents
2 The Index of Keywords
3 List of Pictures
4 List of Tables
5 List of Examples
6 List of Lists
7 The Top10000
6.0 Lists of data sources
6.1 Lists of books, that contain first essential books of
the occupation, second recommended books, third useful books:
the top10, the top20, the top50, the top100, the top200,
the top500, the top1000, the top2000, the top5000.
6.2 Lists of programmes, that contain first essential programmes
of the occupation, second recommended programmes, third useful
programmes:
the top10, the top20, the top50, the top100, the top200,
the top500, the top1000, the top2000, the top5000.
6.3 Lists of datasets, that contain first essential datasets
of the occupation, second recommended datasets, third useful
datasets:
the top10, the top20, the top50, the top100, the top200,
the top500, the top1000, the top2000, the top5000.
MySQL
If we assume that MySQL is the best for everyone on the planet, then we
may realise that we are not yet where we want to be in the future: the
age of personal databases is not here yet.
The products of the future must be so powerful, that databases will be
so easy to create, maintain, update and use, that everyone can build up
and use databases in every household.
As soon as we start becomming interested in a field like databases, we have to go along the ways we are used to:
1. We have to collect data from the main sources, like
MySQL.com.
2. we have to get manuals from companies, via internet or mail,
3. we have to buy books,
4. we have to get programmes, free or bought,
5. we have to work through all data, tutorials, examples, case studies, real applications,
6. we have to install in our own rooms client computers with client
software and server computers with server software. This way we can
play in the try dock for a while.
7. we have to rent sites from hosters with MySQL behind the
sites,
8. we must design, build up sites with databases feeding the web pages,
9. There is no end for employing databases.
For books in Germany we have the source No 1:
amazon
Out of the 54 books in the English books section,
keyword mysql, I got my favorites:
1 MySQL PHP Database Applications, Nov 2003,
Jay Greenspan, Brad Bulger, 768 pages, Wiley, 57,96 Euro
2 MySQL Cookbook, Oct 2002,
Paul Du Bois, 1008 pages, O'Reilly, 48,94 Euro
3 MySQL , Feb 2003,
Paul DuBois, 850 pages, New Riders, 56,41 Euro
4 PHP MySQL Web Development, Feb 2003,
Luke Welling, Laura Thomson, 912 pages,
Sams, 48,97 Euro
5 Web Database Applications PHP MySQL, Mar 2002
H.E. Williams, David Lane, 594 pages, O'Reilly, 44,04 Euro
6 Open Source LAMP, Dez 2002
James Lee, Brent Ware, 656 pages,
Addisson-Wesley, 44,08 Euro
7 PHP, MySQL, Apache 24 hours, Dez 2002,
Julie Meloni, 528 pages, Sams, 29,38 Euro
Sum: 329,78 Euro
May the databases you create
become successful and prosperous.
|
Every citizen,
who is able to do so,
should build up databases.
Building up databases should become an activity, that is in society
widely approved, highly valued and enjoyed like holidays and
other activities we do with pleasure.
You may rephrase "doing business with you" into :
It is a pleasure doing databases with you !
The completed databases may become a prosperous business as well.
MySQL
You have to see:
http://www.mysql.com/
From the download of MySQL Reference Manual version 4.0.12, from
the table of contents, I made this summary for myself and you:
MySQL toc table of contents summary page 1
1 General Information
2 MySQL Installation
3 Tutorial Introduction
4 Database Administration
5 MySQL Optimisation
6 MySQL Language Reference
7 MySQL Table Types
8 MySQL APIs
9 Extending MySQL
A Problems and Common Errors
B Contributed Programs
C Credits
D MySQL Change History
E Porting to Other Systems
F Environment Variables
G MySQL Regular Expressions
H GNU General Public License
I GNU Lesser General Public License
SQL command, type and function index
Concept Index
1 General Information
1.1 About This Manual
1.2 What Is MySQL?
1.3 What Is MySQL AB?
1.4 MySQL Support and Licensing
1.5 MySQL 4.x In A Nutshell
1.6 MySQL Information Sources
1.7 How Standards-compatible Is MySQL?
1.8 MySQL and The Future (The TODO)
1.9 How MySQL Compares to Other Databases
2 MySQL Installation
2.1 Quick Standard Installation of MySQL
2.2 General Installation Issues
2.3 Installing a MySQL Source Distribution
2.4 Post-installation Setup and Testing
2.5 Upgrading/Downgrading MySQL
2.6 Operating System Specific Notes
2.7 Perl Installation Comments
MySQL toc table of contents summary page 2
1 General Information
2 MySQL Installation
3 Tutorial Introduction
4 Database Administration
5 MySQL Optimisation
6 MySQL Language Reference
7 MySQL Table Types
8 MySQL APIs
9 Extending MySQL
A Problems and Common Errors
B Contributed Programs
C Credits
D MySQL Change History
E Porting to Other Systems
F Environment Variables
G MySQL Regular Expressions
H GNU General Public License
I GNU Lesser General Public License
SQL command, type and function index
Concept Index
3 Tutorial Introduction
3.1 Connecting to and Disconnecting from the Server
3.2 Entering Queries
3.3 Creating and Using a Database
3.4 Getting Information About Databases and Tables
3.5 Examples of Common Queries
3.6 Using mysql in Batch Mode
3.7 Queries from Twin Project
3.8 Using MySQL with Apache
4 Database Administration
4.1 Configuring MySQL
4.2 General Security Issues and the MySQL Access Privilege System
4.3 MySQL User Account Management
4.4 Disaster Prevention and Recovery
4.5 Database Administration Language Reference
4.6 MySQL Localisation and International Usage
4.7 MySQL Server-Side Scripts and Utilities
4.8 MySQL Client-Side Scripts and Utilities
4.9 The MySQL Log Files
4.10 Replication in MySQL
MySQL toc table of contents summary page 3
1 General Information
2 MySQL Installation
3 Tutorial Introduction
4 Database Administration
5 MySQL Optimisation
6 MySQL Language Reference
7 MySQL Table Types
8 MySQL APIs
9 Extending MySQL
A Problems and Common Errors
B Contributed Programs
C Credits
D MySQL Change History
E Porting to Other Systems
F Environment Variables
G MySQL Regular Expressions
H GNU General Public License
I GNU Lesser General Public License
SQL command, type and function index
Concept Index
5 MySQL Optimisation
5.1 Optimisation Overview
5.2 Optimising SELECTs and Other Queries
5.3 Locking Issues
5.4 Optimising Database Structure
5.5 Optimising the MySQL Server
5.6 Disk Issues
6 MySQL Language Reference
6.1 Language Structure
6.2 Column Types
6.3 Functions for Use in SELECT and WHERE Clauses
6.4 Data Manipulation: SELECT, INSERT, UPDATE, DELETE
6.5 Data Definition: CREATE, DROP, ALTER
6.6 Basic MySQL User Utility Commands
6.7 MySQL Transactional and Locking Commands
6.8 MySQL Full-text Search
6.9 MySQL Query Cache
MySQL toc table of contents summary page 4
1 General Information
2 MySQL Installation
3 Tutorial Introduction
4 Database Administration
5 MySQL Optimisation
6 MySQL Language Reference
7 MySQL Table Types
8 MySQL APIs
9 Extending MySQL
A Problems and Common Errors
B Contributed Programs
C Credits
D MySQL Change History
E Porting to Other Systems
F Environment Variables
G MySQL Regular Expressions
H GNU General Public License
I GNU Lesser General Public License
SQL command, type and function index
Concept Index
7 MySQL Table Types
7.1 MyISAM Tables
7.2 MERGE Tables
7.3 ISAM Tables
7.4 HEAP Tables
7.5 InnoDB Tables
7.6 BDB or BerkeleyDB Tables
8 MySQL APIs
8.1 MySQL PHP API
8.2 MySQL Perl API
8.3 MySQL ODBC Support
8.4 MySQL C API
8.5 MySQL C++ APIs
8.6 MySQL Java Connectivity (JDBC)
8.7 MySQL Python APIs
8.8 MySQL Tcl APIs
8.9 MySQL Eiffel wrapper
MySQL toc table of contents summary page 5
1 General Information
2 MySQL Installation
3 Tutorial Introduction
4 Database Administration
5 MySQL Optimisation
6 MySQL Language Reference
7 MySQL Table Types
8 MySQL APIs
9 Extending MySQL
A Problems and Common Errors
B Contributed Programs
C Credits
D MySQL Change History
E Porting to Other Systems
F Environment Variables
G MySQL Regular Expressions
H GNU General Public License
I GNU Lesser General Public License
SQL command, type and function index
Concept Index
9 Extending MySQL
9.1 MySQL Internals
9.2 Adding New Functions to MySQL
9.3 Adding New Procedures to MySQL
A Problems and Common Errors
A.1 How to Determine What Is Causing Problems
A.2 Common Errors When Using MySQL
A.3 Installation Related Issues
A.4 Administration Related Issues
A.5 Query Related Issues
A.6 Table Definition Related Issues
E Porting to Other Systems
E.1 Debugging a MySQL server
E.2 Debugging a MySQL client
E.3 The DBUG Package
E.4 Locking methods
E.5 Comments about RTS threads
E.6 Differences between different thread packages
The age of the personal computer is here now, but the age of the personal databases is not here yet.
In the future there will be databases in every home, in every household, in every room.
One or a few harddisks will hold the client and the server with all the data.
|