Getting Started with Oracle

1. Base of the database: DB, DBMS, DBA, DBS. The application interacts directly with Oracle, which contains two parts of DB and DBMS.

2. The early database model is: Hierarchical && Mesh-type relational database--Object relational database system (ORDBMS).

3. The current popular large relational database systems are: Oracle and SQL Server. The client manipulates the Oracle database through the SQL language (SQL Directive).

4. The history of development, the beginning of the use of the database, reach the effect: first, different applications, to achieve the sharing of data. Second, the database is application-oriented and not program-oriented.

5. Map the real-world transactions into data in the database. The process is called data modeling. Data modeling realizes the mapping of the real-world abstraction into the conceptual world. In the process of data modeling, pay attention to three points: data structure, operation, integrity constraints.

6.e-r diagram: Entities, relationships, attributes. The relationship between the student and the curriculum is ' elective course '. The relationships are categorized as: 1:n, N:1, and N-C.

7.ORACLE Company, Oracle Corporation. Oracle has large memory overhead and is cumbersome to unload.

8.ORACLE Storage: Physical storage structure and logical storage structure. Oracle focuses on the management of databases and is suitable for the management and application of large databases. The SQL language is still used when executing. The concepts involved are: tables, views, triggers, constraints, indexes, sequences, synonyms, stored procedures, functions, triggers, packages, users, permissions, roles, quotas, scenarios (database contents).

9.

Getting Started with Oracle