1 / 18

Databases

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#P1107. Oracle.

KeelyKia
Download Presentation

Databases

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Databases

  2. Purpose of the Database • Managing Web Content • Executing Transactions

  3. Database Management Systems (DBMS) • Commercial • Open Source

  4. Commercial DBMS • Oracle • Access • Microsoft SQL Server • DB2 • Sybase • Buyers Guide • http://www.dbmsmag.com/pcdbms.html#P1107

  5. Oracle • http://www.oracle.com/start/portals/intro.html?src=201777&Act=67

  6. Access • http://www.microsoft.com/office/access/default.htm

  7. 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.

  8. Sybase • Scalability • http://www.sybase.com/products/databaseservers

  9. Open Source DBMS • MySQL • PostgreSQL • InterBase • db.linux = Centura • http://www.codecatalog.com/

  10. MySQL • Launched January 1998 • Primarily for managing web content • Transaction processing by end 2001 • Up to 10,000 records

  11. 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

  12. 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

  13. db.linux • Centura Software-Open Source • http://www.dbstar.org/

  14. 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

  15. SQL • http://www.sql.org • http://www.dbasupport.com/

  16. Tutorials • http://searchdatabase.techtarget.com/bestWebLinks/0,289521,sid13_tax281630,00.html • http://www.builder.com/Programming/ChoosingWebDB/ • CIA-Handbook • http://www.dcs.napier.ac.uk/~andrew/sql/

More Related