872663
Description
Mind Map by adamelvin786, updated more than 1 year ago
|
Created by adamelvin786
over 10 years ago
|
|
Object-relational database
- Features
- Advantages
- Ease of use
- Flexibility
- Precision
- Security
- Data Independence
- Data Manipulation Language
- Ease of use
- Disadvantages
- machine performance
- Schema Changes
- Language Dependence
- Lack of Ad-Hoc Queries
- machine performance
- Advantages
- object types
- model real-world entities
- Object Columns
- An object column is a column in a table that is defined using an object type.
- An object column is a column in a table that is defined using an object type.
- Object Tables
- object table is a table in which each row contains one object of a given object type.
- object table is a table in which each row contains one object of a given object type.
- model real-world entities
- NULL
- atomic NULL
- object can be atomically NULL
- cannot be updated
- cannot be updated
- object can be atomically NULL
- NULL attributes
- object can have attributes that are NULL
- Updates on its individual attributes
- Must use cascade clause
- Must use cascade clause
- Updates on its individual attributes
- object can have attributes that are NULL
- atomic NULL
- collection types
- VARRAY
- variable sized array which has ordered set of data elements of the same type.
- variable sized array which has ordered set of data elements of the same type.
- Nested tables
- Tables are ordered set of elements of the same data type
- Tables are ordered set of elements of the same data type
- VARRAY
Want to create your own Mind Maps for free with GoConqr? Learn more.