Oracle Database 01 study notes

2011-09-01  来源:本站原创  分类:Database  人气:87 

1 relational database

Relational database refers to a number of related tables and other database objects of a collection, this three-part definition of the meaning expressed.

a. In a relational database, information is stored in a two-dimensional sheets, a relational database contains multiple tables, each table contains rows (records) and columns (fields)

b. between tables are interrelated, this correlation is reflected in the gradual and foreign key relationships to achieve the reference

c. database includes not only tables, but also includes other database objects, such as views, indexes, stored procedures, etc.

2 key words in the database

Primary Key: The table refers to a column that uniquely identifies the value of a row, Unique & Not Null, can be formed by one or more columns

Foreign key: refers to the table with another table containing the corresponding primary key columns can be formed by one or more columns

Public key: If two tables have the same column, then the column is a public key of these two tables, if the public key is one of the table's primary key, then the public key in another table as foreign key

3. Relational database ensures data integrity and security of data storage

相关文章
  • Oracle Database 01 study notes 2011-09-01

    1 relational database Relational database refers to a number of related tables and other database objects of a collection, this three-part definition of the meaning expressed. a. In a relational database, information is stored in a two-dimensional sh

  • Oracle Database 02 study notes 2011-09-01

    1.SQL language classification a. Data Query Language (Select statement): used to retrieve data, functions and syntax more complex, but also the most widely used b. Data manipulation language (DML): used to change the database data, including the Inse

  • Oracle Database 03 study notes 2011-09-01

    1 2 using basic functions Date function ADD_MONTH (date, i): Returns the date d plus i months after the results, i may be fractional, but the database will be converted to an integer, truncating the decimal part of the LAST_DAT (date): Returns the da

  • Oracle.PowerDesigner.PlSql study notes 2010-12-28

    Oracle, PowerDesigner, PlSql study notes

  • Study Notes Oracle Database 01 2010-05-04

    One of Oracle Study Notes 1. Relational database Relational database which refers to the relevant tables and other database objects in the collection, this definition the meaning of the expression of the three parts. a. In the relational database, in

  • Oracle PL / SQL study notes 01 2010-05-05

    Chapter PL / SQL Introduction 1. Why use PL / SQL PL / SQL and SQL combined with tight, both use the same data type. PL / SQL to use less code and have the speed of execution PL / SQL simplifying application logic to the database layer of the transfe

  • Oracle set of study notes 2010-08-04

    Associative array: One-dimensional, no boundaries, with elements of the sparse set, only the PL / SQL available. Referred to as the index in oracle 8i table, 9i later changed to an associative array. Nested table: One-dimensional, no boundaries, with

  • Oracle performance tuning study notes (b) - ORACLE performance tuning often view the analysis 2011-09-10

    Recommended Books :oracle database 10g performance tuning tips& Techniques you performance tools dba_tables: dba_tab_columns: dba_clusters: dba_indexes: dba_ind_columns: index_stats: index_histogram: dba_tab_histograms: Execution statistics to use :d

  • Oracle performance tuning study notes (c) - knowledge of database configuration and IO 2011-09-16

    Oracle IO architecture Oracle 11g supported file systems: 1 file system (NAS, SAN, normal file system) 2 bare equipment 3.ASM Oracle processes and file CKPT, LGWR, ARCn, SERVER both read and write control file. Performance guide 1 to maintain a relat

  • ORACLE MODEL clause Study Notes 2010-09-13

    ORACLE 10G of the new MODEL clause can be used for calculations between the lines. MODEL clause to allow access to an array of elements such as access to records as a column. This provides, such as spreadsheet calculations like computing power. 1, MO

  • oracle sql optimization study notes 2011-07-19

    select statements to avoid using the '*', this method is very inefficient, in the oracle * resolution process will convert all the column names, this is normally the object to query the database data dictionary to complete, more time consuming. Reduc

  • Oracle performance tuning study notes (b) - ---- Oracle SQL TRACE and TKPROF to use 2011-08-30

    Oracle SQL TRACE And using TKPROF After the start sql trace information collected includes 1. Resolution Executive . Returns the number of data 2.cpu And the time the command 3. Physical read and logical read the number of 4. The number of records pr

  • Oracle performance tuning study notes --- the role of tuning, the standard level 2011-09-15

    1. The role of application designer application developer database administrator system administrator Application level: Database layer SQL statements: Memory, database structure, SQL statements, the operating system level: IO Swap parameters 2 diffe

  • Oracle performance tuning study notes (b) - diagnostic and tuning tools 2011-09-16

    Background process trace file: alert log file: View questions 1 describes the memory errors and block corruption errors (2) Monitoring data manipulation 3 view non-default initialization parameters to view storage dump show parameter dump; backgroup_

  • Oracle performance tuning study notes (b) - DBA tools 2011-09-16

    DBA Tools 1 to develop their own toolkit (2) using the oracle supplied package 3. Regular performance checks 4 track to solve the problem using OEM 5. The use of OEM Timing of application tasks to perform various management tasks automatically resolv

  • Oracle performance tuning study notes (E) - buffer Cache tuning C 2011-09-16

    Oracle Wait Interface inspection bottleneck causes v $ session_wait v $ session_event v $ system_event Case of need to increase the cache size 1. Any event wait. 2.SQL statement optimization 3 pages of serious operating system for 4 low hit rate Open

  • Oracle performance tuning study notes (k) - SQL statement optimization 2011-09-16

    SQL SQL statements to optimize resource-intensive methods to determine 1.OEM 2.Statspack 3.Explain Plan 4.SQL Trace and TKPROF 5.AutoTrace Optimizer optimizer model two kinds: Rules-based RBO: (not recommended) 1 rule in the data dictionary Based on

  • Oracle performance tuning study notes (12) - Statistics Management B 2011-09-16

    Histograms: the distribution of information that describes the column. 1 If the data distribution is uneven. 2 collection methods: dbms_stats.gather_table_stats. 3. View information dbms_histograms, dba_tab_histograms select * from jobs where job_sta

  • Oracle performance tuning study notes (XVI) --- use materialized views 2011-09-16

    Materialized views using materialized view license privileges. grant create any masterialized view to scott; Create materialized view create materialized view mv as select * from scott.emp; Materialized views in the rowid and the rowid in the table c

  • Oracle PL / SQL study notes 2010-11-11

    Experience writing stored procedures and optimization measures | 2010 to talk about new technology optimization Baidu website 2010-09-25 A, PL / SQL tranches defined syntax: DECLARE / * Definition section - define constants, variables, complex data t