What is a star schema?

A star schema is a way of organising analytical data. At the centre sits a fact table holding the measurable events — sales, transactions, shipments — usually as numeric measures plus foreign keys. Radiating out from it are dimension tables that describe those facts: a date dimension, a product dimension, a customer dimension, a store dimension, and so on. Drawn out, the fact table in the middle with dimensions around it looks like a star. It's popular because it's efficient for reporting and relatively intuitive for analysts to join.

The practical hurdle is that you still have to know the schema — which table is the fact, which keys join to which dimensions, and what each cryptic column means — before you can write a correct query.

iDBQuery removes that hurdle:

• It introspects your schema automatically, mapping the tables, keys and relationships without you diagramming them.
• A semantic layer captures what obscure table and column names actually mean, so the model understands your star schema (or any other design) in business terms.
• You just ask. iDBQuery works out the necessary joins between fact and dimension tables, writes the SQL, and returns a cited answer.

Whether your data is in a textbook star schema, a snowflake, or a messy real-world hybrid, iDBQuery figures out the structure for you — so understanding the schema stops being a prerequisite for getting answers.