Business!
ORACLE MS - SQL
ORACLE MS - SQL
Clustering A-Z A-F G-L M-R S-Z T-Z
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
Real Application Clusters Interconnect Hub Switch Fabric Storage Area Network Cache Fusion Shared Cache
Real Application Clusters node
Data level! ORACLE MS SQL
Flash Back Query
***,, critical
Oracle Database Oracle10g Database Common Criteria EAL4 - - - 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 140-1 Level2 - ( ) - (PKI ) - (Kerberos, RADIUS) - - LDAP Oracle Label Security Virtual Private Database - - Access Control Policy
ORACLE MS SQL
Transaction ORACLE MS SQL ORACLE MS SQL
Data Mining ORACLE MS SQL 5
Manageability ORACLE MS SQL Wizard
& ORACLE MS SQL
Oracle 10g : SQL Tuning Advisor
Table Partitioning ORACLE MS SQL SQL SQL
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 91 91 values values less less than(199201) tablespace T1, T1, partition 92 92 values values less less than(199301) tablespace T2, T2,...... partition 98 98 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);
Table partitioning 91 92.. 98 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 91 91 values values less less than(199201), partition 92 92 values values less less than(199301),...... partition 98 98 values values less less than(maxvalue));
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 25 25 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)););
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 )