in Data Science by
star schema model

1 Answer

0 votes

It is a traditional database schema with a central table. Satellite tables map IDs to physical names or descriptions 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.

Related questions

0 votes
asked Dec 27, 2019 in Data Science by sharadyadav1986
0 votes
asked Mar 24, 2020 in SAP by AdilsonLima
+1 vote
asked Apr 5 in Data Science by Robin