MS-SQL SERVER 대비 기능

Size: px

Start display at page:

Download "MS-SQL SERVER 대비 기능"

진운 기
5 years ago
Views:

2 Business!

3 ORACLE MS - SQL

4 ORACLE MS - SQL

5 Clustering A-Z A-F G-L M-R S-Z T-Z

6 Microsoft EE : Works for benchmarks only CREATE VIEW Customers AS SELECT * FROM Server1.TableOwner.Customers_33 UNION ALL SELECT * FROM Server2.CompanyDatabase.TableOwner.Customers_66 UNION ALL SELECT * FROM Server3.CompanyDatabase.TableOwner.Customers_77 UNION ALL : : A-E F-K L-P Q-S T-Z

7 Real Application Clusters Interconnect Hub Switch Fabric Storage Area Network Cache Fusion Shared Cache

8 Real Application Clusters node

9 Data level! ORACLE MS SQL

10 Flash Back Query

11 ***,, critical

12 Oracle Database Oracle10g Database Common Criteria EAL Security Profiles - Virtual Private Database(EE) Fine-grained access control Secure access to data Out-of-the-box security policy Options Oracle Advanced Security FIPS Level2 - ( ) - (PKI ) - (Kerberos, RADIUS) - - LDAP Oracle Label Security Virtual Private Database - - Access Control Policy

13 ORACLE MS SQL

14 Transaction ORACLE MS SQL ORACLE MS SQL

15 Data Mining ORACLE MS SQL 5

16 Manageability ORACLE MS SQL Wizard

17 & ORACLE MS SQL

18 Oracle 10g : SQL Tuning Advisor

19 Table Partitioning ORACLE MS SQL SQL SQL

20 Table partitioning CREATE CREATE TABLE TABLE ( month_id month_id NUMBER, NUMBER, product_id NUMBER, NUMBER, sales sales NUMBER NUMBER ) PARTITION BY BY RANGE RANGE (month_id) ( partition values values less less than(199201) tablespace T1, T1, partition values values less less than(199301) tablespace T2, T2, partition values values less less than(maxvalue) tablespace T8); T8); CREATE CREATE TABLE TABLE dept dept (deptno (deptnonumber, deptname deptnamevarchar(32)) STORAGE STORAGE (INITIAL (INITIAL 10K) 10K) PARTITION BY BY HASH(deptno) (PARTITION p1 p1 TABLESPACE ts1, ts1, PARTITION p2 p2 TABLESPACE ts2, ts2, PARTITION p3 p3 TABLESPACE ts1, ts1, PARTITION p4 p4 TABLESPACE ts3); ts3);

21 Table partitioning CREATE CREATE TABLE TABLE ( month_id month_id NUMBER, NUMBER, product_id NUMBER, NUMBER, sales sales NUMBER NUMBER ) PARTITION BY BY RANGE RANGE (month_id) SUBPARTITION BY BY HASH HASH (product_id) SUBPARTITIONS 8 STORE STORE IN IN (T1,T2,T3,T4,T5,T6,T7,T8) ( partition values values less less than(199201), partition values values less less than(199301), partition values values less less than(maxvalue));

22 Table partitioning CREATE CREATE TABLE TABLE sales_by_region (item# (item# INTEGER, INTEGER, qty qty INTEGER, INTEGER, store_name store_name VARCHAR(30), state_code state_code VARCHAR(2), sale_date sale_date DATE) DATE) STORAGE(INITIAL 10K 10K NEXT NEXT 20K) 20K) TABLESPACE tbs5 tbs5 PARTITION BY BY LIST LIST (state_code) (( PARTITION region_east region_east VALUES VALUES ('MA','NY','CT','NH','ME','MD','VA','PA','NJ') STORAGE STORAGE (INITIAL (INITIAL 20K 20K NEXT NEXT 40K 40K PCTINCREASE 50) 50) TABLESPACE tbs8, tbs8, PARTITION region_west VALUES VALUES ('CA','AZ','NM','OR','WA','UT','NV','CO') PCTFREE PCTFREE NOLOGGING, PARTITION region_south VALUES VALUES ('TX','KY','TN','LA','MS','AR','AL','GA'), PARTITION region_central VALUES VALUES ('OH','ND','SD','MO','IL','MI','IA'), PARTITION region_null region_null VALUES VALUES (NULL), (NULL), PARTITION region_unknown VALUES VALUES (DEFAULT) (DEFAULT)););

23 Oracle MS-SQL Redo log Multiplexing Self Managing(Auto) Log file Member - redo log crash Memory,Storage (10g New Feature) Crashpoint-time recovery? Bitmap index Multi-Version read consistency (DSS ) Application Code B*tree index (Runtime process overhead )

목 차

목 차 Oracle 9i Admim 1. Oracle RDBMS 1.1 (System Global Area:SGA) 1.1.1 (Shared Pool) 1.1.2 (Database Buffer Cache) 1.1.3 (Redo Log Buffer) 1.1.4 Java Pool Large Pool 1.2 Program Global Area (PGA) 1.3 Oracle