What is Data Scheme? - Data warehousing
What is Data Scheme? Data Scheme is a diagrammatic representation that illustrates data structures and data relationships to each other in the relational database within the data warehouse.
The data structures have their names defined with their data types.
Data Schemes are handy guides for database and data warehouse implementation.
The Data Scheme may or may not represent the real lay out of the database but just a structural representation of the physical database.
Data Schemes are useful in troubleshooting databases.
|
What is Bi-directional Extract? - Data warehousingIn hierarchical, networked or relational databases, the data can be extracted, cleansed and transferred in two directions. The ability of a system to do this is refered to as bidirectional extracts.....