1 / 10

DBMS Architectures

Oracle is clinging to the top spot in the multibillion-dollar database software market, despite mounting pressure from IBM and Microsoft, according to preliminary 2002 market share numbers released Monday. - M. LaMonica, cnet.com, March 2003. DBMS Architectures.

Download Presentation

DBMS Architectures

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. Oracle is clinging to the top spot in the multibillion-dollar database software market, despite mounting pressure from IBM and Microsoft, according to preliminary 2002 market share numbers released Monday. - M. LaMonica, cnet.com, March 2003

  2. DBMS Architectures A history of DBMS architectures: • Mainframe DBMSs • Personal DBMSs • Client/Server DBMSs

  3. terminal terminal terminal Mainframe DBMSs DBMS DB mainframe

  4. Personal DBMSs DBMS Interface1 DB Engine1 DB1 workstation DBMS Interface3 DB Engine3 DBMS Interface2 DB3 workstation DB Engine2 DB2 workstation

  5. Microsoft Access/Jet • Access is designed as a personal DBMS: • It has a useful interface but a limited engine. • It doesn’t support enterprise applications. Access Interface1 Jet Engine1 Jet DB1 workstation

  6. Client/Server DBMSs DBMS client1 workstation DBMS Server Network DBMS client2 DB workstation server DBMS client3 workstation

  7. MS Access interface SQL Server client VB Appli- cation workstation workstation workstation SQL Server DB server Microsoft SQL Server • MS SQL Server is designed for client/server applications.

  8. MS Access interface VB Appli- cation workstation workstation MSDE DB server Microsoft SQL Server Desktop Engine (MSDE) • MSDE is SQL Server compatible. • It is distributed with MS applications.

  9. A Comparison

  10. Comparing Oracle and SQL Server • SQL Server • Cheaper • Easier to install • Faster on Microsoft platforms • Oracle 9i • Multi-platform support • More powerful 3rd generation language • More performance tuning Images from Microsoft and Oracle, July, 2003

More Related