DATA BASE

1
DATA BASE
??? ???(???????) ???(??????)
???(???????)
2
?? ???

• ???? ??? ??
• ?? ???? ??
• SAM(Sequencial Access Method) ??
• ISAM(Indexed Sequencial Access Method) ??

3
?? ???? ???

• ????? ??? ???? ??.
• ??? ??? ??? ? ?? ??? ?.
• ??? ??? ?? ??.
• ??? ??? ???.
• ?? ??? ??? ???? ??.
• ??? ?? ???? ???? ??.

4
??? ???? ??

• ??? ???? ?? ?????.
• ??? ???? ????? ??.
• ??? ???? ?? ?????.
• ??? ???? ???????.

5
??????? ??

• ???? ??? ??
• ???? ??? ??
• ???? ???? ?? ? ??
• ???? ???? ??? ? ??
• ???? ??? ???? ??
• ???? ????

6
?????? ?? ???

• DBMS? ??
• DBMS? ??
• ??? ??? ??
• ???, ?????, ???
• ??? ?? ??
• ?? ??? ???, ?? ??? ???
• ?? ??? ??
• ????? DBMS ???, ?? DBMS ???

7
??? ??? ???

• ??? ??? ??? (DBA)
• ?? ?????
• ?? ???

8
??? ???

• ???? ?? ??
• ???? ??? ??
• ???? ??? ????????
• ??? DBMS? ???

9
??? ???

• ??? 8
• ??? 8i
• ??? 9i

10
??? ?? ????

• http//www.oracle.com/kr
• http//www.oramag.com
• http//dblab.changwon.ac.kr/oracle

11
MY SQL

• ? ? ?
• ?????? 97

12
? ?

• Mysql??
• Mysql ??
• Mysql?.??
• Mysql ?? ?? ??
• Mysql ????
• Mysql ?? ??

13
1.Mysql ??

• T.c.X. ? ?? ??? MySQL SQL(Structured Query
  Language) ?????? ?? ?? ??
• MySQL? TcX ???? ????? ??? ???? ????
• ? ?? ?? ????? ???? SQL ?? ?? ??? DB??? ????
  ?????.  
• TcX??? MySQL? 1996?? ??? ??? ?? 500?? ??? ?? ??
  500? ??? ???? (100 ?? ??? ??) ?? ??? ??
• ??? ?? MySQL3.23 ?? 4.0
• ?? ?? ?? MySQL5.0

14
Mysql 3.1xx ? ??

• -?? ? ? ?? ??
• Sub select
• SELECT INTO TABLE
• TRANSACTION
• STORED PROCEURE
• TRIGGER

15
Mysql 3.23.xx? ??

• ???? ??(BDB(Berkeley DB)? InnoDB ???? ??)
• ???(Foreign key)??( InnoDB? ?? ???? ??-(3.23.44
  ))

16
MySQL 4.1?? ?? ??? ???

• ??? ??(?? lock?? DBMS???? ??? ???)
• ????
• MyISAM??? Foreign key ?? (??? InnoDB??? ???)
• ???? ?? ??

17
Mysql ? ?? ????

• Expanded support for subqueries (4.1.xx)
• GIS (Geometrical data)(4.1.xx)
• Multi-master replication(4.1xx)
• Stored procedures and triggers(5.0.xx)
• Views(5.1.xx)

18
Mysql ? ??

• MySQL Standard(??????,InnoDB??)
• MySQL Max(BDB-Berkely DB), commit, rollback,
  crash recovery ,row-level locking)
• MySQL Pro(???)
• MySQL Classic(???)InnoDB ???? ?? ??)

19
2. Mysql ??

• ??? ???.
• ??? ???? ??.(Unix ,Linux ,Windows)
• ???? ?????? ??(??? ??5??? ??? ??? ???)
• ?? thread? ??? Multi thread ?????? cpu? ?? ?? ??
  ?? ???.
• ???? ????? ??

20
3.Mysql ??

• ???? ? ??? ??? ??
• ????(http//www.mysql.com/information/benchmarks.h
  tml)
• ??? ??? error message??
• ??? API ??
• ??? OS ??

21
???? ??? ?? ?? ?????? ??? ?? Oracle9i? MySQL ??
??? ?? Nile ??????? 8?? ?? ?? ??
???????." eweek? ????
22
3-1.Mysql ??

• ??? ????.
• ??? ?? ??? ????.
• ?? SELECT?? ???? ???.
• Rollback? ?? ???? ??? ??.
• ???, ?(View) ??? ??.

23
4. Mysql ? ?? ?? ??

• ?? OSAIX 4.x, BSDI 2.x, BSDI 3.0, 3.1? 4.x, DEC
  UNIX 4.x, Linux 2.0, Solaris 2.5, 2.6 ? 2.7,
  SunOS 4.x, Win95, Win98? NT ,2000 ,xp? ?? ?? os
  ??
• ?? API C, C, Java, Perl, PHP, Python, TCL
• Linux Mysql PHP ?? ??
• Open Source ??? ?? ??? ??(yahoo? DB? ?? Mysql ?
  ??)

24
????

• MySql advanced class (???(?)/??? ?)
• ??? ?? ??(???)
• ??? ??? ????(???)
• http//www.mysql.com
• http//database.sarang.net/
• http//www.linuxchannel.net/
• http//tunelinux.pe.kr/
• http//kldp.org/
• http//www.koreaphp.co.kr

25
MS - SQL Server 2000

• ? ? ?
• ???? ??? 97

26
Agenda

• Windows DNA? Dot.NET
• SQL SERVER Evolution
• About SQL 2000
• SQL 2000??? XML??

27
Windows DNA (Distributed interNet
Architecture)

• Windows DNA ? Microsoft? ??? ???? ?????? ? ???
• Windows DNA? ???, enterprise-ready ? ??
• ????? ???? ?? ??? architecture? ????.? This is
  n-Tier Computing

Internet or Intranet
Web Service (Windows NT With IIS 4)
COM And MSMQ
Client(IE)
DataBase Server (SQL Server or Oracle)
28
Windows DNA 2000Next Generation Web Application
Platform
Application LogicTier
Client Tier
DataTier
Application Services IIS/ASP, COM/MTS,
MSMQ. ADO/OLE DB Data Access, Active Directory,
XML, Commerce
Data Access andStorage
ASP/COM Application
Browser
SQL Server
Rich Client
Devices
Internet (TCP/IP, HTTP, HTML, XML)
29
Move to .NET(dot net)

1. Any time, Any place, Any Device
2. .NET?- ?? ????? ???? ??? ?
   ???? ? ? ??- ??(open)? ??? ????? ????.- smart
   client? device? ???? ?? ??? ???? ???
   ????.- Leverage globally available Web services
3. XML,SOAP(Simple Object Access Protocol),C
4. .NET Enterprise Servers(Base service for .NET)

30
.NET Enterprise Servers
Based on Windows 2000

• SQL Server 2000 ?????? ???
• Exchange Server 2000 Messaging Collaboration
• Commerce Server 2000 eCommerce
• Application Center 2000 Component Load
  Balacing and Distribution
• BizTalk Server 2000 XML, BizTalk framework?
  ???? ?? B2B ???? ??
• Internet Security Acceleration Server 2000
  Firewall and Software Caching
• Host Integration Server 2000 IBM mainframe? ??
• UNIX??? ???? ?? ???? ?? ??

31
SQL Server Evolution(from 7)
?? (Yukon)
2000? 10? ??? XML??? ??? ???????????
????, ??? ??? ??? ??? WinCE version
available 100 ???
1998? 12? ?? ???? ?? English query, DTS
Easy to use
2002?
32
About SQL Server 2000

• Scalability From Hand to Data Center
• Manageability ???? ?? ??? ?? ??
• Reliability 0? ??? down time
• Performance ???? ???? Database Server
• Internet Ready Internet Wizard and XML
  Features
• Data Warehouse ??? OLAP Service and
• Data Mining Tools

So Why use SQL Server 2000?
33
SQL Server 2000 Scalabilty(???)

• ??? SQL Server 2000 ???- SQL Server for Windows
  CE(for PDA)- SQL Server 2000 Personal
  Edition(for Windows 9x)- SQL Server 2000
  Standard Edition
• (for Windows 2000 Professional or higher)- SQL
  Server 2000 Enterprise Edition
• (from Windows 2000 Server to Data Center
  Server)
• 2. Support Distributed Partitioned View
  (Scale-Up, Out)
• 3. SMP(Symmetric Multi Processing) 32CPU
• 4. Multi instance and support SAN
• (System Area Networking)

34
SQL Server 2000 Reliability(???)
? ? ?? ?? ?? ?? ?? ?? ?? ??
?????? ?????? -?? ???? ?? ?? ?? ?? ??
?? ?? ?? ?? N/A N/A
?? ?? ?? (?? ??) ?? ?? ??
?? ?? ?? ?? ( ?? ??) ?? ?? ??
35
SQL Server 2000 Performance(??)

• TPC-C ???? ?? (Performance, Price)
• TPC-W ???? ?? (Performance)
• Indexed views(???? ?)
• 4. Distributed Partitioned Views(?? ??? ?)

36
SQL Server 2000 Internet Ready

• ???? ???? XML ??
• URL Query ( http//IISServer/VirtualRoot?sql
  SELECT FROM Customers FOR XML AUTO )
• 3. Web Assistant Wizard
• 4. Cubes(??)? ?? HTTP ??

37
SQL Server 2000 Internet Ready
38
SQL 2000??? XML??

• HTTP ????? URL? ???? ?? SQL?? ??? ??
• XML???? SELECT? ???? ?? ?? FOR XML ?? ?? ??
• System Stored procedure? ?? XML???? ??? ??
• Batch ??? sqlsqlsynk ??? ?? ?????
• XML???? ?? SQL?? OLE DB provider ??

39
MS-SQL ? XML
????? ???? ??????
40
SQLServer2000 Edition? ???? ????
?? ?? Enterprise Edition Standard Edition Personal Edition Developer Edition Desktop Engine SQL Server CE
WindWindows 2000 DataCenter ?? ?? ?? ?? ?? N/A
Windows 2000 Advanced Server ?? ?? ?? ?? ?? N/A
Windows 2000 Server ?? ?? ?? ?? ?? N/A
Windows 2000 Professional N/A N/A ?? ?? ?? N/A
Windows NT4.0 Server,Enterprise Edition ?? ?? ?? ?? ?? N/A
Windows NT 4.0 Server ?? ?? ?? ?? ?? N/A
Windows NT 4.0 Workstation N/A N/A ?? ?? ?? N/A
Windows 98 N/A N/A ?? N/A ?? N/A
Windows CE N/A N/A N/A N/A N/A ??
41
SQL Server 2000 ??

• Standard/ Personal
• ????? / ? ????
• ?? ???? ??
• NT Only mode