Databases
Download
1 / 18

database - PowerPoint PPT Presentation


  • 241 Views
  • Updated 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 'database' - 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 l.jpg
Purpose of the Database

  • Managing Web Content

  • Executing Transactions


Database management systems dbms l.jpg
Database Management Systems (DBMS)

  • Commercial

  • Open Source


Commercial dbms l.jpg
Commercial DBMS

  • Oracle

  • Access

  • Microsoft SQL Server

  • DB2

  • Sybase

    • Buyers Guide

    • http://www.dbmsmag.com/pcdbms.html#P1107


Oracle l.jpg
Oracle

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


Access l.jpg
Access

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


Microsoft sql server l.jpg
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 l.jpg
Sybase

  • Scalability

  • http://www.sybase.com/products/databaseservers


Open source dbms l.jpg
Open Source DBMS

  • MySQL

  • PostgreSQL

  • InterBase

  • db.linux = Centura

  • http://www.codecatalog.com/


Mysql l.jpg
MySQL

  • Launched January 1998

  • Primarily for managing web content

  • Transaction processing by end 2001

  • Up to 10,000 records


Postgresql l.jpg
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 l.jpg
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 l.jpg
db.linux

  • Centura Software-Open Source

  • http://www.dbstar.org/


Sql92 l.jpg
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 l.jpg
SQL

  • http://www.sql.org

  • http://www.dbasupport.com/


Tutorials l.jpg
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