- The physical data model defines concepts to implement the logical data model
- It considers aspects of efficiency and fault-tolerance
- Why learning physical data model concepts?
- To be able to choose between DBMS brand names
- To be able to use DBMS facilities for performance tuning
- For example, if a query is running slow,
- one may create an index to speed it up
- For example, if loading of a large number of tuples takes for ever
- one may drop indices on the table before the inserts
- and recreate index after inserts are done
|
Última modificación: Thursday, 24 de November de 2005, 06:43