databases
Download
Skip this Video
Download Presentation
Databases

Loading in 2 Seconds...

play fullscreen
1 / 18

Databases - PowerPoint PPT Presentation


  • 250 Views
  • Uploaded on

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.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Databases' - KeelyKia


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
purpose of the database
Purpose of the Database
  • Managing Web Content
  • Executing Transactions
commercial dbms
Commercial DBMS
  • Oracle
  • Access
  • Microsoft SQL Server
  • DB2
  • Sybase
    • Buyers Guide
    • http://www.dbmsmag.com/pcdbms.html#P1107
oracle
Oracle
  • http://www.oracle.com/start/portals/intro.html?src=201777&Act=67
access
Access
  • http://www.microsoft.com/office/access/default.htm
microsoft sql server
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
Sybase
  • Scalability
  • http://www.sybase.com/products/databaseservers
open source dbms
Open Source DBMS
  • MySQL
  • PostgreSQL
  • InterBase
  • db.linux = Centura
  • http://www.codecatalog.com/
mysql
MySQL
  • Launched January 1998
  • Primarily for managing web content
  • Transaction processing by end 2001
  • Up to 10,000 records
postgresql
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
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
db.linux
  • Centura Software-Open Source
  • http://www.dbstar.org/
sql92
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
slide16
SQL
  • http://www.sql.org
  • http://www.dbasupport.com/
tutorials
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/
ad