DBMS : Past, Present, and the Future hjk@oopsla.snu.ac.kr
1 Table of Contents
2 DBMS?
3 DBMS Architecture naive users naive users programmers application casual users casual users administrator database application programs system system calls calls query query database scheme data data manipulation language pre-compiler query processor query data data definition language compiler application programs object object database manager DBMS manager file file Disk storage
4 Table of Contents
5 DBMS
6 Network DB Example Lowery Maple Queens Hodges SideHill Brooklyn Shiver North Bronx 900 556 647 647 801?
7 sum:=0 Network DB query example get first customer where customer.name= Shiver and customer.city = Bronx ; while DB_status = 0 do begin sum:=sum+customer.amount; get next customer where customer.name = Shiver and customer.city = Bronx ; end print(sum);
8
9 DBMS name street city amount Lowerly Maple Queens 900 Shiver North Bronx 556 Shiver North Bronx 647 Hodges SideHill Brooklyn 801 Hodges SideHill Brooklyn 647 Select sum(amount) from customer where customer.name = Shiver and customer.city= Bronx ;
10 RDBMS
11 RDBMS R&D
12 DB
13 (OO) DBMS
14 OODBMS?
15 interface Customer { attribute string name; DBMS IDL relationship Set<Deposit> deposit inverse Deposit::owned_by; } interface Branch { attribute string street; attribute string city; relationship Set<Deposit> belong inverse Deposit::branch; } interface Deposit { relationship Customer owned_by inverse Customer::branch; relationship Branch branch inverse Branch::belong; float balance; }
16 OO DBMS OQL query select sum(customer.deposit.balance) from Customer customer where customer.name = Shiver and customer.deposit.branch.city = Bronx ;
17 OODBMS
18 (OR) DBMS
19 ORDBMS name Lowerly Shiver Shiver Hodges Hodges Branch(street, city) {Maple, Queens} {North, Bronx} {North, Bronx} {SideHill, Brooklyn} {SideHill, Brooklyn} amount 900 556 647 801 647
20 ORDBMS
21 ORDBMS
22 ORDBMS Feature Informix IBM DB2 Oracle8 UDT O O O Strong typing O O O Data replication X X O UDF O O O Func. overloading O O O Func. resolution O O O
23 ORDBMS Feature Informix IBM DB2 Oracle8 LOB O O O External data O O O Integrated searchable content O O O 3GL/4GL O/X O/O O/O OO language O O X Predefined extensions O O O
24 ORDBMS Feature Informix IBM DB2 Oracle8 Platforms Unix from DG, DEC, HP, IMB, NCR, Sequent, SGI, and Sun Solaris; Windows NT Unix from HP, IBM, and Sun Solaris; Windows NT; OS/2; Unix from DEC, IBM, HP, Sequent, and Sun Solaris; Windows NT
25 Table of Contents
26 1999 Database Market Share 42.4% Source: IDC, June 2000 20.4% 7.8% 5.9% 3.9% Oracle IBM Microsoft Informix Sybase
27 1999 Database Market -Worldwide(includes Non-RDBMS) 3.0% 4.3% 3.3% 16.0% 31.1% 13.1% 29.9% Source : Dataquest DBMS Market Share Numbers, May 2000
28 1999 UNIX RDBMS Market 3% 6% 10.0% 6% 12% 63.0% Source : Dataquest DBMS Market Share Numbers, May 2000
29 1999 NT RDBMS Market 0.7% 3.0% 15.0% 40.0% 35.0% Source : Dataquest DBMS Market Share Numbers, May 2000
30 Example : Oracle8i Transaction Processing Secure Parallel Internet Extensible Distributed Warehousing Decision Support Object Component
31 Example: Oracle8i Oracle8i Oracle8i Oracle8i Oracle8i Oracle8i
32 Table of Contents
33 Current Database Issues
34 Asilomar Report: DBMS research trend(1)
35 Asilomar Report: DBMS research trend(2)
36 The Grand Challenge!!!
37 Bio Technology Data
38 XML?
39 HTML & XML <tr> <td> <font color= red > </font> </td> <td> </td> </tr> <tr> <td> <b> </b> </td> <person> <name> </name> <city> </city> </person>
40 Basic Representation Bib <Bib> </Bib> <paper id= o2 references= o3 > <author>abiteboul </author> </paper> <book id= o3 > <author> Hull </author> <title> Foundations of Data Bases </title> <publisher> Addison Wesley </publisher> </book> author Abiteboul paper book reference 2 3 author Hull 1 title publisher 4 5 6 7 Foundations Addison Of DataBasesWesley XML data OEM Model
41 Why XML?
What are XML for? 42 XML XML?
43 Database Data Warehouse Knowledge Discovery Processing: Data mining useful, interesting hidden information
44 Data Warehouse(1)
45 Data Warehouse(2) Sales Volumes Jan time Feb Product Mar Wong Dewitt A B Stonebreaker Sales person C
46 Data Mining(1)?
47 Data Mining(2)
48 Security and Directory(1) Privacy of Communications Sensitive Data Storage Granular Access Control Is an order read or modified in transit? Network encryption Is your credit card # stored in clear? Encryption of stored data Can a customer see only her own order? Virtual Private Database
49 Security and Directory(2) Know your Users Scalability Ease of Use Who is accessing the data from the web? Strong authentication Can you support 100,000s of users? Directory integration Is it easy to use for users & administrators? Schema-independent users
50 High Availability(1) Computer A Computer B Node A in a cluster fails, users are migrated Computer A Computer B
51 High Availability(2) Orders Orders Orders Queries/Inserts/Updates/Deletes Parallel Recovery from Failure Partition Unavailable
52 Manageability OLTP User DSS User Batch Process ing Database Resource Manager OLTP updates and queries: high priority DSS queries: medium priority Batch: low priority
53 Table of Contents
54 Key Focus Areas for Oracle9i Availability Scalability & Performance Security Development Platform Manageability Windows 2000 Integration Internet Content Management B2C and B2B ebusiness Packaged Applications Business Intelligence
55 Oracle 9i Breakthrough Features Oracle9i Real Application Clusters transparent scalability Oracle9i Data Guard zero data loss disaster protection Self-tuning, Self-managing Database increase DBA productivity Built-in in OLAP, Data-mining, ETL Services Business Intelligence on an Internet Scale Real-Time Personalization The only real-time recommendation engine