100 likes | 113 Views
Oracle remains the leading player in the multibillion-dollar database software market, fending off pressure from IBM and Microsoft. This article provides a historical overview of DBMS architectures and compares Oracle and SQL Server, highlighting their strengths and differences.
E N D
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 A history of DBMS architectures: • Mainframe DBMSs • Personal DBMSs • Client/Server DBMSs
terminal terminal terminal Mainframe DBMSs DBMS DB mainframe
Personal DBMSs DBMS Interface1 DB Engine1 DB1 workstation DBMS Interface3 DB Engine3 DBMS Interface2 DB3 workstation DB Engine2 DB2 workstation
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
Client/Server DBMSs DBMS client1 workstation DBMS Server Network DBMS client2 DB workstation server DBMS client3 workstation
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.
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.
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