Printer Friendly
Dictionary, Encyclopedia and Thesaurus - The Free Dictionary
3,906,683,748 visitors served.
forum Join the Word of the Day Mailing List For webmasters
?
Dictionary/
thesaurus
Medical
dictionary
Legal
dictionary
Financial
dictionary
Acronyms
 
Idioms
Encyclopedia
Wikipedia
encyclopedia
?

star schema

   Also found in: Wikipedia 0.01 sec.
star schema
A data warehouse design that enhances the performance of multidimensional queries on traditional relational databases. One fact table is surrounded by a series of related tables. Data are joined from one of the points to the center, providing a so-called "star query." See OLAP.


Want to thank TFD for its existence? Tell a friend about us, add a link to this page, add the site to iGoogle, or visit the webmaster's page for free fun content.
?Page tools
Printer friendly
Cite / link
Feedback
Mentioned in?  References in periodicals archive?   Encyclopedia browser?   Full browser?
No references found
 
As example, the original data is shown in Table 1, and the corresponding star schema is shown in Table 2.
0, utilizing computing standards and conventions including eXtensible markup language (XML) and star schemas.
We believe that a combination of the data-modeling techniques found in the two architectural approaches works best, ERD or normalization techniques for the data warehouse, and the star schema data model for multidimensional data marts.
 
 
 
Encyclopedia
?

Terms of Use | Privacy policy | Feedback | Advertise with Us | Copyright © 2012 Farlex, Inc.
Disclaimer
All content on this website, including dictionary, thesaurus, literature, geography, and other reference data is for informational purposes only. This information should not be considered complete, up to date, and is not intended to be used in place of a visit, consultation, or advice of a legal, medical, or any other professional.