Abstract
Bitmap indexes are best suited for data warehouse or decision support systems (DSS). Common to the data warehouse is the star schema, in which a central fact table contains all the detailed information for a particular subject such as customer revenue, and number of related dimension tables containing associated reference type data on a particular dimension such as time or geography. In a star schema, the dimension tables are the parent and the central fact table is the child table. See Figure 3-1 for a sample data model of a simple star schema.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2012 Darl Kuhn, Sam R. Alapati, and Bill Padfield
About this chapter
Cite this chapter
Kuhn, D., Alapati, S.R., Padfield, B. (2012). Bitmap Indexes. In: Expert Indexing in Oracle Database 11g. Apress. https://doi.org/10.1007/978-1-4302-3736-5_3
Download citation
DOI: https://doi.org/10.1007/978-1-4302-3736-5_3
Publisher Name: Apress
Print ISBN: 978-1-4302-3735-8
Online ISBN: 978-1-4302-3736-5
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books