Prepare
Practice
Interview
Aptitude
Reasoning
English
GD
Placement papers
HR
Current affairs
Engineering
MCA
MBA
Online test
Login
Online Practice Test
>
Data Warehousing 3
« Previous
Next »
The star schema is most like a
Options
- hierarchical database.
- object-oriented database.
- relational database.
- O/R database.
CORRECT ANSWER : relational database.
Discussion Board
Star schema
The star schema is most like a relational database. The star schema is the simplest style of data mart schema and is the approach most widely used to develop data warehouses and dimensional data marts. The star schema consists of one or more fact tables referencing any number of dimension tables. The star schema is an important special case of the snowflake schema, and is more effective for handling simpler queries. Star schema has structure like star. It has one fact table surrounded by multiple dimension tables connected with that fact table.
Prajakta Pandit 03-21-2017 12:13 AM
« Previous
Next »
Write your comments
*
*
Email must be in the form someone@domain.com
*
*
Enter the code shown above:
Please enter the code shown above
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
Related Content
Business intelligence (15)
Cognos (15)
Cognos (15)
Analysis services (15)
Business object (15)
OLAP (15)
ReportNet (15)
Microstrategy (15)
Websphere (15)
Solaris (15)
SAS (15)
Weblogic (15)
Data mining (49)
Data mining (15)
Web mining (16)
Data Warehousing (30)
Data Warehousing (48)
Data Warehousing (20)
Advertisement
▲