Getting Started with Oracle

I. Databases (database, DB)

Database Management System, DBMS

Database administrator (db Administrator, DBA)

Database systems (DB system, DBS)

Ii. several common databases

Oracle Oralce, thedatabase leader in the market, the programmer's girlfriends in the friend.

IBM DB2, adhering to the IBM has always been tough character, rough more than the details. The function of the giant ox, use up, everyone curse.

MS Sql/server , limited by the performance of the Windows platform, is difficult to develop in the enterprise

Sybase Sybase,

IBM Informix,

MySQL, often in the old cat inadvertently stole the market.
Access

Three, relationship: the whole two-dimensional table

Relationship Name: Table name

Tuples: Row data (record)

Properties: Column data (Field/component)

Property name: Column name (field name)

Primary key: The only attribute group (keyword) that determines the tuple

Domain: The value range of a property

Relationship pattern: Relationship name (attribute list)

such as: Student (school number, name, gender, department, age, birthplace)

Constraints

Domain Integrity constraints

Entity integrity constraints

Referential integrity constraints

Four, e-r model

E-r model three elements: entities, relationships, attributes

Inter-Entity Connectivity 1:1 1:n n:m

v. Features of Oracle   

Global, cross-platform database supports multi-user, high-performance transactional processing powerful security control and integrity control supports distributed databases and distributed processing

Getting Started with Oracle