Star Schema

In the star schema design, a single object (the fact table) sits in the middle and is radically connected to other surrounding objects (dimension lookup tables) like a star. Each dimension is represented as a single table. The primary key in each dimension table is related to a foreign key in the fact table.Star SchemaAll measures in the fact table are related to all the dimensions that fact table is related to. In other words, they all have the same level of granularity.A star schema can be simple or complex. A simple star consists of one fact table; a complex star can have more than one fact table.Let's look at an example: Assume our data warehouse keeps store sales data, and the different ...

What is Dimension data model?

What is data?Let us begin our discussion by defining what is data. Data are values of qualitative or quantitative variables, belonging to a set of items. Simply put, it's an attribute or property or characteristics of an object. Point to note here is, data can be both qualitative (brown eye color) and quantitative (20cm long).A common way of representing or displaying a set of correlated data is through table type structures comprised of rows and columns. In such structures, the columns of the table generally signify attributes or characteristics or features and the rows (tuple) signify a set of co-related features belonging to one single item.While speaking about data, it is important to un ...

Learn data warehouse - step by step

This series on Data Warehousing aims to help people get a good high-level understanding of what it takes to implement a successful data warehouse.- Concepts:    What is data warehousing?    Dimensional Data Model    Star Schema    Snowflake Schema    Slowly Changing Dimension    Conceptual Data Model    Logical Data Model    Physical Data Model    Conceptual, Logical, and Physical Data Model    Data Integrity    What is OLAP    MOLAP, ROLAP, and HOLAP    Bill Inmon vs. Ralph Kimball- Tools:  &nb ...

SAP NetWeaver BW, Powered by SAP HANA

SAP HANA is a high-performance analytic appliance that provides SAP software components optimized on hardware from SAP’s leading hardware partners.
HANA’s in-memory computing engine enables organizations to effectively analyze business operations based on very large volumes of detailed real-time data, without affecting backend enterprise applications or databases.
There is great deal of confusion on SAP HANA and its impact on SAP products. The confusion is more on SAP BW, Since this is an area where rapid changes are happening due to business objects and SAP HANA.
By the second half of 2011, SAP customers all over the world can start  to migrate to HA ...

Browse by Category more

Popular Topics

Star Schema

Star Schema

on 02/21/2014 - 05:17 pm


What is Dimension data model?

on 02/21/2014 - 01:17 pm


Learn data warehouse - step by step

on 02/21/2014 - 12:59 pm

Recent Members

Hemanshu Gondaliya

Member Since: 02/19/2018

Nora Jones

Member Since: 02/15/2018

Ashutosh Sureka

Member Since: 02/14/2018

Chintra Kamaraj

Member Since: 02/14/2018

Shivani Joshi

Member Since: 02/12/2018