Database

							Databases
Purpose of the Database
   Managing Web Content
   Executing Transactions
Database Management
Systems (DBMS)
   Commercial
   Open Source
Commercial DBMS
   Oracle
   Access
   Microsoft SQL Server
   DB2
   Sybase
       Buyers Guide
       http://www.dbmsmag.com/pcdbms.html#P
        1107
Oracle
   http://www.oracle.com/start/p
    ortals/intro.html?src=201777&
    Act=67
Access
   http://www.microsoft.com/office/access
    /default.htm
     Microsoft SQL Server
   http://www.microsoft.com/sql/
   Open Database Connectivity (ODBC) is a
    widely accepted application programming
    interface (API) for database access. It is
    based on the Call-Level Interface (CLI)
    specifications from X/Open and ISO/IEC for
    database APIs and uses Structured Query
    Language (SQL) as its database access
    language.
Sybase
   Scalability
   http://www.sybase.com/products/datab
    aseservers
Open Source DBMS
   MySQL
   PostgreSQL
   InterBase
   db.linux = Centura



   http://www.codecatalog.com/
MySQL
   Launched January 1998
   Primarily for managing web content
   Transaction processing by end 2001
   Up to 10,000 records
PostgreSQL
   Michael Stonebreaker UC Berkeley
   Great scalability
   Runs on large number of platforms
   Image of the DB is dumped to text file
   Backup and Recovery Features missing
   No Journaling-automated recovery
   No Replication-update of remote copies
InterBase
   A mature relational system, InterBase, is
    already in use by such large commercial
    customers as Bear Stearns, Boeing, The
    Money Store, Motorola and Nokia.
   InterBase, has backup and recovery
    mechanisms that function much like the
    automated processes of commercial
    database systems. But its replication is
    supplied via a third-party add-on engine from
    Synectics Software, a South African firm.
   InterBase is entry level SQL-92 compliant
db.linux
   Centura Software-Open Source
   http://www.dbstar.org/
SQL92
   the latest standard for accessing data in
    relational databases;
   compliance is gauged in three stages:
    entry level, intermediate and high level.
   Entry level achieved by commercial
    DBMS
   Nobody is fullySQL92 compliant
SQL
   http://www.sql.org
   http://www.dbasupport.com/
Tutorials
   http://searchdatabase.techtarget.com/b
    estWebLinks/0,289521,sid13_tax28163
    0,00.html
   http://www.builder.com/Programming/
    ChoosingWebDB/
   CIA-Handbook
   http://www.dcs.napier.ac.uk/~andrew/s
    ql/