Synonyms
Join index; Join indices; Star index
Definition
A star index is a collection of join indices, one for every foreign key join in a star or snowflake schema.
Key Points
A common structure for a data warehouse is a fact table consisting of several dimension fields and several measure fields. To reduce storage costs, the fact table is often normalized into a star or a snowflake schema. Since most queries reference both the (normalized) fact tables and the dimension tables, creating a star index can be an effective way to accelerate data warehouse queries. The Red Brick data warehouse system has implemented star indices.
Cross-References
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsAuthor information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Section Editor information
Rights and permissions
Copyright information
© 2018 Springer Science+Business Media, LLC, part of Springer Nature
About this entry
Cite this entry
Johnson, T. (2018). Star Index. In: Liu, L., Özsu, M.T. (eds) Encyclopedia of Database Systems. Springer, New York, NY. https://doi.org/10.1007/978-1-4614-8265-9_891
Download citation
DOI: https://doi.org/10.1007/978-1-4614-8265-9_891
Published:
Publisher Name: Springer, New York, NY
Print ISBN: 978-1-4614-8266-6
Online ISBN: 978-1-4614-8265-9
eBook Packages: Computer ScienceReference Module Computer Science and Engineering