Star Schema

A star schema is a way to organize data in a database to make analysis and reporting easier. It consists of a central table called the "fact table," which stores key data about a specific subject—like sales or transactions. Around it are smaller tables called "dimension tables" that hold detailed information related to the facts, such as products, customers, or dates. These dimension tables connect directly to the fact table, forming a star-like pattern. This structure simplifies querying large datasets, improves performance, and helps users understand relationships quickly.