SQL Server History 1 st Generation 2 nd

SQL Server History 1 st Generation 2 nd Generation SQL Server 6. 0/6. 5 l l l SQL Server 7. 0 Differentiation from Sybase SQL Server Windows integration First to include Replication Cross-release objectives • • l l l Re-architecture of relational server Extensive auto resource management First to include OLAP & ETL 3 rd Generation SQL Server 2000 l l Reliability & Security Integrated Business Intelligence Performance, scalability focus XML support First to include Notification First to include Data Mining & Reporting • • SQL Server 2005 l l l High availability Security Developer productivity Native XML First to include Enterprise ETL & Deep Data Mining Lowest TCO Automatic Tuning

강력하고 통합된 데이터 플랫폼 사용자 중심의 그래 픽한 인터페이스 제 공 Portal 기반의 분석시스 템 구현가능 Database Engine Database Maintenance § Service Broker § Backup and Restore Enhancements § HTTP Access § Checksum Integrity Checks § Database Tuning Advisor § Dedicated Administrator Connection § Enhanced Read ahead & scan § Dynamic Configuration AWE § Indexes with Included Columns § Highly-available Upgrade § Multiple Active Result Sets § Online Index Operations § Persisted Computed Columns § Online Restore § Try/Catch in T-SQL statements Management Tools Enterprise § Common Table Expressions § MDX & XML/A Query Editor ETL § Server Events § Maintenance Plan Designer § Snapshot Isolation Level § Source Control Support § Partitioning § Profiler access to non-sa § Synonyms § SQLCMD Command Line Tool § Dynamic Management Views § Database Mail. NET Framework Performance Tuning OLAP 를 통 § Common Language Runtime Integration § Profiling Analysis Services OLAP 및 한 분석 데이 § CLR-based Types, Functions, & Triggers § Exportable Showplan & Deadlocks Data Mining § SQL Server. NET Data Provider § Profiler Enhancements 터를 Data Types § New Trace Events 엔진 Web이나 § CLR-based Data Types Full-text Search Portal을 통해 § VARCHAR(MAX), VARBINARY(MAX) § Backup/Restore includes FT catalogs 사용자 중심 § XML Datatype § Multi-instance service Database Failure and Redundancy SQL Client. NET Data Provider 의 인터페이 § Fail-over Clustering (up to 8 node) § Server Cursor Support 스를제공하도 § Database Mirroring § Multiple Active Result Sets 록 개발가능 § Database Snapshots Security § Enhanced Multi-instance Support § Catalog and meta-data security XML § Password policy enforcement § New XML data type § Fine Grain Administration Rights 알림 솔루션 § XML Indexes § Separation of Users and Schema § XQUERY Support § Surface Area Configuration 프레임워크 § XML Schema (XSD) support Notification Services § FOR XML PATH § Embed NS in existing application § XML Data Manipulation Language § User-defined match logic § SQLXML 4. 0 § Analysis Services Event Provider RDBMS엔진 3 rd party OLAP 툴 & OLAP client 툴 과 함께 분석 시스 템 구현가능 Replication § Seamless DDL replication § Merge Web Sync § Oracle Publication § Peer to Peer Transactional replication § Merge replication perf and scalability § New monitor and improved UI Analysis Services and Data Mining § Analysis Management Objects § Windows Integrated Backup and Restore § Web Service/XML for Analysis § Integration Services and DM Integration § Eight new Data Mining algorithms § Auto Packaging and Deployment 관리 툴 § Migration Wizard Integration Services § New high performance architecture § Visual design and debugging environment § Extensible with custom code and scripts § XML task and data source § SAP connectivity § Integrated data cleansing & text mining § Slowly changing dimension wizard § Improved flow control § Integration with other BI products Reporting Services § Report Builder § Analysis Services Query Designer OLAP/DBMS § Enhanced Expression Editor § Multi-valued Parameters 리포팅 툴 § Date Picker § Sharepoint Web Parts § Floating Headers § Custom Report Items § XML Data Provider 복제 서비스

Oracle에 대한 오해 Me, Too!

전세계 Relational DBMS 시장 점유율 OS 플랫폼별 점유율 (Non-Mainframe DB) 시장 점유율 및 성장율 (Non-Mainframe DB) 2004 Other 11% +3% SQL Server 26% Unix/Linux 49% IBM 20% Oracle 43% +2% Other 12% IBM 22% Windows 51% +18% 2003 Windows Database Market 업계에서 가 장 높은 성 장율 SQL Server 24% 전체 RDBMS OS 플 랫폼에서 Windows 가 51% 점유율 차 지 (2003년에는 48% 점유) +15% Other 8% IBM 16% Oracle 25% Oracle 42% Source: Gartner, 2005 SQL Server 51% Windows 기반 RDBMS Vendor중 에서 MS가 과반수 점유율 로 선두적 위치

개발자 관점 l 개발 생산성 극대화 l Visual Studio와의 통합 l Stored procedures, triggers, & functions in T-SQL, C++, C#, or VB … l 통합된 디버깅 환경 (T-SQL and. NET) : Set breakpoints anywhere, inspect anything VB, C#, … VS. NET Project SQL Queries: select sum(tax(sal, state)) from Emp where county = ‘King’ Build Assembly: “Tax. Lib. dll” SQL Data Definition: create assembly … create function … create procedure … create trigger … create type … Runtime hosted inside SQL (in-proc) SQL Server SQL Engine CLR Hosting Layer SQL OS Windows

Total Cost $ 288 K-384 K Multi-core $ 331 K High Availability $192 K (Clustering, Mirroring, Replication 등) Business Intelligence Manageability $165. 5 K $ 25 K (Included) $25 K Base Product 40 K 25 K 10 g DB 2

IT Governance 강화 (ROI/ROA) “given the same strategic objectives, organizations with a good IT Governance have on average 30% higher ROI/ROA than companies without any Governance”. Peter Weill in: IT Governance Peter Weill is the director of the Center for Information Systems Research (CISR) and a senior research assistant at Massachusetts Institute of Technology's Sloan School of Management.

SQL Server 2000 vs. 2005 37% better performance, 17% lower cost vs. SQL Server 2000 (scale-up on 64 -P Itanium) 162% better performance, 54% lower cost vs. SQL Server 2000 (scale-up on 16 -P Itanium) TPC-C results referenced above are HP Integrity Superdome running SQL Server 2005, 1, 082, 203 tpm. C, 5. 38 $/tpm. C, available 12/7/05; and HP Integrity Superdome running SQL Server 2000, 786, 646 tpm. C, 6. 49 $/tpm. C, available 10/23/03. TPC-H results referenced above are HP Integrity rx 8620 running SQL Server 2005, 13, 637 Qph. H@1000 GB, 54 $/Qph. H@1000 GB, available 12/7/05; and Unisys ES 7000 Aries 420 Enterprise Server running SQL Server 2000, 5, 199 Qph. H@1000 GB, 119 $/Qph. H@1000 GB, available 10/15/03.

Oracle 10 g vs. SQL Server 2005 7% better performance, 37% lower cost vs. Oracle (scale-up on 64 -P Itanium) 30% better performance, 7% lower cost vs. Oracle (best price / performance) TPC-C results referenced above are HP Integrity Superdome running SQL Server 2005, 1, 082, 203 tpm. C, 5. 38 $/tpm. C, available 12/7/05, and HP Integrity Superdome running Oracle 10 g, 1, 008, 144 tpm. C, 8. 33 $/tpm. C, available 4/14/04. TPC-H results referenced above are Unisys ES 7000 Orion 440 Enterprise running SQL Server 2005, 21, 505. 7 Qph. H@1000 GB, 41. 93 $/Qph. H@1000 GB, available 12/7/05; and Bull Nova. Scale 5160 running Oracle 10 g R 2 Enterprise, 15, 069 Qph. H@1000 GB, 44. 32 $/Qph. H@1000 GB, available 12/20/05. Results as of 6/30/05. .

마이그레이션 프레임워크 PL/SQL, Package, Stored Procedures and Triggers Data Transformation Client Applications Database Administration SQL Server Database Oracle Database UNIX Platform Data Type and Object Definitions Windows Platform 오라클 마이그레이션 프레임워크는 현재 사용하고 있는 Database인 오라클과 이와 관련된 어플리케이션을 체계적인 방법으로 분석한 뒤, 최적의 방법으로 마 이그레이션 하는 방법을 제공합니다.

오라클 마이그레이션 개념도 Network Architecture Database Architecture

마이그레이션시 고려해야 할 사항 l 주요 컴포넌트 l 데이터베이스 l Schema (tables, indexes, constraints and views) l PL/SQL (packages, stored procedures, triggers, cursors and functions) l Abstract Data Types (objects and collections) l Users and Rules l Data Transformation l 사용자 어플리케이션 l ODBC and JDBC clients l OCI and Embedded SQL Clients l Oracle Forms l Developer 2000 Apps l 관리 및 운영 l 유지보수 작업을 위한 Shell Scripts l HA/DR l 기타 고려 사항 l 아키텍쳐, 작업범위, 문법 등

Client Application 마이그레이션 Oracle Library and interfaces 파악 Oracle Access를 위해 사용하는 Library • Embedded SQL (Pro. C) • OCI • ODBC • Developer 2000 and Oracle Forms • JDBC, JAVAJ, and JAVA Stored Procedures • Web. DB • Rogue Wave DBTools BC 최적의 SQL Library and interfaces 도출 및 변환 D LE , O DB O T, . NE O AD , JD C B

DB Administration 마이그레이션 Backup and Recovery l. Online backup l. Backup granularity l. Recovery granularity l. Differential backups l. Full logging mode l. Minimal logging mode l. Parallelism Availability l. Shared database failover l. Shared disk failover l. Standby database l. Online index maintenance Replication l. Snapshot replication – full refresh l. Snapshot replication – fast refresh l. Updateable snapshots/masters l. Synchronous (2 pc) updates l. Asynchronous updates l. Complex snapshots – query based Tools l. DBA console l. Database agent l. Bulk data loading utility l. Bulk data unloading utility l. Schema unloading utility l. Index tuning tool l. SQL plan analysis tool l. Workload tracing tools l. Database consistency checking

SQL Server Migration Assistant (SSMA) for Oracle Migration Analyzer Assess the Migration Project 마이그레이션 프로젝트의 복잡성 평가 Schema Migrator Migrate Schema & Business Logic Data Migrator 데이터베이스 변환 실행 및 크로스플랫폼 데이터 베이스 개발자를 위한 강력한 IDE 제공 Migration Tester Migrate Data 마이그레이션 프로세스에 대한 자동 검증 기 능 제공 Test the Converted DB Convert the Application • Free download • 자동화된 마이그레이션 프로세스 제공 (수 작업 비율을 최대 80% 줄일 수 있음) Test, Integrate & Deploy

결론 - 고객이 얻는 비즈니스 가치 Database Engine § Service Broker § HTTP Access § Database Tuning Advisor § Enhanced Read ahead & scan § Indexes with Included Columns § Multiple Active Result Sets § Persisted Computed Columns § Try/Catch in T-SQL statements § Common Table Expressions § Server Events § Snapshot Isolation Level § Partitioning § Synonyms § Dynamic Management Views. NET Framework § Common Language Runtime Integration § CLR-based Types, Functions, & Triggers § SQL Server. NET Data Provider Data Types § CLR-based Data Types § VARCHAR(MAX), VARBINARY(MAX) § XML Datatype Database Failure and Redundancy § Fail-over Clustering (up to 8 node) § Database Mirroring § Database Snapshots § Enhanced Multi-instance Support XML § New XML data type § XML Indexes § XQUERY Support § XML Schema (XSD) support § FOR XML PATH § XML Data Manipulation Language § SQLXML 4. 0 Easy! Database Maintenance § Backup and Restore Enhancements § Checksum Integrity Checks § Dedicated Administrator Connection § Dynamic Configuration AWE § Highly-available Upgrade § Online Index Operations § Online Restore Management Tools § MDX & XML/A Query Editor § Maintenance Plan Designer § Source Control Support § Profiler access to non-sa § SQLCMD Command Line Tool § Database Mail Performance Tuning § Profiling Analysis Services § Exportable Showplan & Deadlocks § Profiler Enhancements § New Trace Events Full-text Search § Backup/Restore includes FT catalogs § Multi-instance service SQL Client. NET Data Provider § Server Cursor Support § Multiple Active Result Sets Security § Catalog and meta-data security § Password policy enforcement § Fine Grain Administration Rights § Separation of Users and Schema § Surface Area Configuration Notification Services § Embed NS in existing application § User-defined match logic § Analysis Services Event Provider 클 오라 레이션 그 마이 Satisfaction! TCO! 관리 비용 개발 스) 비 (서 기능 SW 비용 Replication § Seamless DDL replication § Merge Web Sync § Oracle Publication § Peer to Peer Transactional replication § Merge replication perf and scalability § New monitor and improved UI Analysis Services and Data Mining § Analysis Management Objects § Windows Integrated Backup and Restore § Web Service/XML for Analysis § Integration Services and DM Integration § Eight new Data Mining algorithms § Auto Packaging and Deployment § Migration Wizard Integration Services § New high performance architecture § Visual design and debugging environment § Extensible with custom code and scripts § XML task and data source § SAP connectivity § Integrated data cleansing & text mining § Slowly changing dimension wizard § Improved flow control § Integration with other BI products Reporting Services § Report Builder § Analysis Services Query Designer § Enhanced Expression Editor § Multi-valued Parameters § Date Picker § Sharepoint Web Parts § Floating Headers § Custom Report Items § XML Data Provider 관리 성 정 안 성능 H 용 비 W