TERMIUM Plus®
The Government of Canada’s terminology and linguistic data bank.
STAR SCHEMA [2 records]
Record 1 - internal organization data 2016-01-08
Record 1, English
Record 1, Subject field(s)
- Data Banks and Databases
- Information Processing (Informatics)
Record 1, Main entry term, English
- snowflake schema
1, record 1, English, snowflake%20schema
correct
Record 1, Abbreviations, English
Record 1, Synonyms, English
Record 1, Textual support, English
Record number: 1, Textual support number: 1 CONT
A snowflake schema has a fact table, as does a star schema. Snowflake schemas, however, contain several dimension tables for each dimension … 2, record 1, English, - snowflake%20schema
Record 1, Key term(s)
- snow flake schema
Record 1, French
Record 1, Domaine(s)
- Banques et bases de données
- Traitement de l'information (Informatique)
Record 1, Main entry term, French
- schéma en flocon de neige
1, record 1, French, sch%C3%A9ma%20en%20flocon%20de%20neige
correct, masculine noun
Record 1, Abbreviations, French
Record 1, Synonyms, French
Record 1, Textual support, French
Record number: 1, Textual support number: 1 CONT
Le deuxième est le schéma en flocon de neige; il correspond à un schéma en étoile dans lequel les dimensions ont été normalisées. 2, record 1, French, - sch%C3%A9ma%20en%20flocon%20de%20neige
Record 1, Spanish
Record 1, Textual support, Spanish
Record 2 - internal organization data 2016-01-08
Record 2, English
Record 2, Subject field(s)
- Data Banks and Databases
- Information Processing (Informatics)
Record 2, Main entry term, English
- star schema
1, record 2, English, star%20schema
correct
Record 2, Abbreviations, English
Record 2, Synonyms, English
Record 2, Textual support, English
Record number: 2, Textual support number: 1 CONT
A star schema is composed of one or more central fact tables, a set of dimension tables, and the joins that relate the dimension tables to the fact tables. 2, record 2, English, - star%20schema
Record 2, French
Record 2, Domaine(s)
- Banques et bases de données
- Traitement de l'information (Informatique)
Record 2, Main entry term, French
- schéma en étoile
1, record 2, French, sch%C3%A9ma%20en%20%C3%A9toile
correct, masculine noun
Record 2, Abbreviations, French
Record 2, Synonyms, French
Record 2, Textual support, French
Record number: 2, Textual support number: 1 CONT
Le schéma en étoile, qui constitue le schéma conceptuel de base pour un entrepôt de données, se compose classiquement d'une table des faits centrale et d'un ensemble de tables de dimension. 2, record 2, French, - sch%C3%A9ma%20en%20%C3%A9toile
Record 2, Spanish
Record 2, Textual support, Spanish
Copyright notice for the TERMIUM Plus® data bank
© Public Services and Procurement Canada, 2025
TERMIUM Plus®, the Government of Canada's terminology and linguistic data bank
A product of the Translation Bureau
Features
Language Portal of Canada
Access a collection of Canadian resources on all aspects of English and French, including quizzes.
Writing tools
The Language Portal’s writing tools have a new look! Easy to consult, they give you access to a wealth of information that will help you write better in English and French.
Glossaries and vocabularies
Access Translation Bureau glossaries and vocabularies.
- Date Modified: