 |
| Advanced Relational Database Modeling. |
1. What does it mean by De-normalization?
Most often the opposite of normalization, more commonly used in data warehouse are reporting environments.
2. Shortly describe about materialized view.
A physically preconstructed view of data containing data copied into the materialized view
3. Shortly describe about index-organized table.
Build a table in the sorted order of an index, typically using a BTree index.
4. Shortly describe about temporary table.
Temporary tables can be used on a temporary basis, either for a connected session or for a period or for a period of time.
5. What does it mean by class in terms of object database model?
An object methodology term for the equivalent of a table in a relational database.
6. What does it mean by object in terms object database model?
An object is a generic term applied to anything tangible, such as a table in a relational database.
7. What does it mean by attribute in terms object database model?
The equivalent of a relational database field, used more often to describe a similar low-level structure in object structure.
8. What does it mean by method in terms of object database model?
The equivalent to a relational database stored procedure, except that it executes on the data contents of an object, within the bounds of the object.
9. What are the tricks of denormalization?
Tricks of denormalization are given below,
i. Separate active and inactive data
ii. Copy fields between tables
iii. Summary fields in parent tables
iv. Separate heavily and lightly accessed data
0 Comments