Saved Bookmarks
| 1. |
Explain Star Schema.? |
|
Answer» It is a traditional database schema with a central table. Satellite TABLES map ID’s to physical name or description and can be CONNECTED to the central fact table using the ID fields; these tables are known as lookup tables, and are principally useful in real-time applications, as they save a LOT of memory. Sometimes star schemas INVOLVE several layers of summarization to recover INFORMATION faster. It is a traditional database schema with a central table. Satellite tables map ID’s to physical name or description and can be connected to the central fact table using the ID fields; these tables are known as lookup tables, and are principally useful in real-time applications, as they save a lot of memory. Sometimes star schemas involve several layers of summarization to recover information faster. |
|