Transcription of 今さら聞けない!? Oracle入門～概要編～
1 <Insert Picture Here> !? oracle OracleDirect Seminar Copyright 2011, oracle . All rights <Insert Picture Here>Agenda OracleDatabase oracle Database oracle Database oracle Database oracle Database Copyright 2011, oracle . All rights <Insert Picture Here>Agenda OracleDatabase oracle Database oracle Database oracle Database oracle Database Copyright 2011, oracle . All rights reserved. Relational Database Management System RDBMS 2 SQL RDBMS oracle SQL Server Microsoft Access Microsoft DB2 IBM PostgreSQL( )4 OracleDatabase Relational Database Management System RDBMS RDBMS Direct Seminar oracle 2011, oracle .
2 All rights Oracle4 Oracle5 Oracle6 Oracle7 DB Oracle8 DMLAQO racle8i / Java/XML Oracle9iRealApplicationClustersData GuardXML DB9iOLAPO racle 10gGrid ControlTransparentData EncryptionAutomaticStorageManagementADDM O racle 11gExadataReal Application TestingAdvanced Compression 84 85 88 92 97 99 01 04 07 09 RDBMS 1979 oracle 2 IT Giga Bytes/RAIDTeraBytes/Storage Area NetworkExaBytes Enterprise ASP R1 2007 10 R2 2009 11 Oracle2 79 Copyright 2011, oracle . All rights oracle Database oracle Database / Direct Seminar oracle 2011, oracle .
3 All rights <Insert Picture Here>Agenda OracleDatabase oracle Database oracle Database oracle Database oracle Database Copyright 2011, oracle . All rights SQL RDBMS RDBMS RDBMS SQL / Copyright 2011, oracle . All rights oracle Database oracle oracle oracle Database oracle oracle Database oracle Direct Seminar !? oracle 2011, oracle . All rights <Insert Picture Here>Agenda OracleDatabase oracle Database oracle Database oracle Database oracle Database Copyright 2011, oracle .
4 All rights oracle Database Database 2. 3. Copyright 2011, oracle . All rights OracleDatabase 12 oracle Database ORCL oracle Database oracle oracle Universal Installer OUI oracle Database SID Database Configuration Assistant DBCA orcl Direct Seminar !? oracle Database 11g 3. 1. Copyright 2011, oracle . All rights OracleDatabase 13 oracle Database sales oracle Database hr oracle Database SID=sales SID=hr 2. 3. 1. Copyright 2011, oracle . All rights connect / oracle Database SYS SYSTEM 3.
5 1. 2. Copyright 2011, oracle . All rights / 1 SALES SALES HR HR 3. 1. 2. Copyright 2011, oracle . All rights reserved. CONNECT DBA CREATE TABLE CREATE VIEW SELECT UPDAT 16 SALES HR HR HR EMP SELECT UPDATE DEPT SALES EMP SELECT UPDATE Direct Seminar oracle Database 11g 1. 2. Copyright 2011, oracle .
6 All rights HR SALES 1. 2. 3. Copyright 2011, oracle . All rights 100 CUST_IDCUST_NAMECUST_ADDRESS100 101 102 ORD_IDORD_DATECUST_ID100002010-04-011001 00012010-04-01102100022010-04-0210110003 2010-04-02200100042010-04-05100 ORDERS CUSTOMERS 1. 2. 3. Copyright 2011, oracle . All rights #* * * #* * #* * * #* * * Direct Seminar !? 2. 3. Copyright 2011, oracle . All rights CREATE TABLE CREATE TABLE orders(ord_idnumber(6) constraint ord_id_pkPRIMARY KEY,ord_datedate constraint ord_date_nnNOT NULL,cust_idnumber(4) constraint cust_id_fkREFERENCES customers(cust_id))TABLESPACE users; ord_id (Primary Key) ord_date (Not Null) cust_id (Foreign Key) NUMBER VARCHAR2 DATE1.
7 2. 3. Copyright 2011, oracle . All rights 100 300 100 200 300 400 100 ROWID101 ROWID102 ROWID 198 ROWID199 ROWID ROWID Direct Seminar 200 ROWID201 ROWID202 ROWID 298 ROWID299 ROWIDCUST_IDCUST_NAMECUST_ADDRESS100 101 102 498 499 CUSTOMERS 300 ROWID301 ROWID302 ROWID 398 ROWID 399 ROWID400 ROWID401 ROWID402 ROWID 498 ROWID 499 ROWID 1. 2. 3. Copyright 2011, oracle . All rights CREATE VIEW cust_sumAS SELECT cust_name, prod_id CREATE VIEW sales_sumAS SELECT prod_id, number 1.
8 2. 3. Copyright 2011, oracle . All rights 1. 2. 3. Copyright 2011, oracle . All rights PL/SQL PL/SQL SQL oracle Database PL/SQL STOCK BEGIN END STOCK STOCK 1. 2. 3. Copyright 2011, oracle . All rights STOCK 1. 2. 3. Copyright 2011, oracle . All rights USER_TABLES ALL_TABLES DBA_TABLES DBA_USERS USER_TABLESALL_TABLESDBA_TABLESDBA_USERS oracle Database > SELECT table_name2 > FROM user_tables;TABLE_NAME------------------ -------PRODUCTSCUSTOMERSORDERSORDER_DETA ILS 1.
9 2. 3. Copyright 2011, oracle . All rights <Insert Picture Here>Agenda OracleDatabase oracle Database oracle Database oracle Database oracle Database Copyright 2011, oracle . All rights real ApplicationClusters oracle real Application Clusters oracle Database RAC Active-Active 1 RAC Direct Seminar !! RAC 2011, oracle . All rights real ApplicationClusters HA(Active-Standby RAC(Active-Active Copyright 2011, oracle . All rights reserved.))
10 real Application Clusters HA(Active-Standby RAC(Active-Active 30 Copyright 2011, oracle . All rights oracle Data Guard DataGuard Direct Seminar !! DataGuard 2011, oracle . All rights oracle Data Guard REDO Copyright 2011, oracle . All rights <Insert Picture Here>Agenda OracleDatabase oracle Database oracle Database oracle Database oracle Database Copyright 2011, oracle . All rights reserved.))
