adspace


----------------Diff b/w Dimensional modeling and
Relational modeling?

Answer Posted / Saurabh Chandra

Dimensional modeling and relational modeling are two different approaches for organizing data in a database. Here's how they differ:nn1. Schemas: Relational databases use a flat schema with no predefined structure, allowing any type of data to be stored together without constraints. In dimensional modeling, data is organized into tables with a specific structure, including fact tables and dimension tables.nn2. Grain: The grain in relational databases refers to the smallest level at which a data entity can be represented. It does not have a fixed definition and may vary depending on the specific use case. In dimensional modeling, the grain is fixed for each fact table and represents the lowest level of detail.nn3. Data Types: Relational databases support all types of data, including structured and unstructured data. Dimensional models primarily focus on supporting data needed for OLAP (Online Analytical Processing) operations, which often include numeric data and date/time attributes.nn4. Query Optimization: Relational databases prioritize fast response times for complex queries using query optimization techniques such as indexing, partitioning, and joins. Dimensional models use pre-aggregated data and materialized views to optimize query performance.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com

2218


hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com

2438


Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin

2180


i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..

2777


what are the dimensions that you have in your current project?list them?

2098


hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.

2071


Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks

2101


what are the names of the reports that you prepared?

1207


What r the names of the reports that you prepared?

1036


faq's on cognos

4116


can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance

2311


hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..

1966


hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com

2001