{"id":23545,"date":"2013-05-14T10:49:29","date_gmt":"2013-05-14T05:19:29","guid":{"rendered":"http:\/\/vskills.in\/certification\/tutorial\/?p=23545"},"modified":"2024-04-12T14:17:19","modified_gmt":"2024-04-12T08:47:19","slug":"dimensional-modeling-and-metadata","status":"publish","type":"page","link":"https:\/\/www.vskills.in\/certification\/tutorial\/dimensional-modeling-and-metadata\/","title":{"rendered":"Business Intelligence Tutorial | Dimensional modeling and metadata"},"content":{"rendered":"\n

Go back to Tutorial<\/a><\/p>\n\n\n

\n
Free Business Intelligence Practice Tests - BI ETL<\/strong><\/a><\/pre>\n
In simplest language, metadata is referred as \u201cData About Data\u201d. The metadata is of two type, first Structural Metadata and another one is Descriptive Metadata. The term \u201cData about Data\u201d in not applied in case of structural metadata. As the Structural Metadata hold specification about structure and design of data. At this movement it, doesn\u2019t contain any data.<\/p>\n
On the other hand the Descriptive Metadata contains the information about the data present in the database or simply in application. The descriptive metadata contain the useful information about the data present in the database or data warehouse. For this reason it is known as \u201cdata about data\u201d or sometime also referred as \u201ccontent about content\u201d.<\/p>\n
Dimensional Modeling (DM) is used to design a data warehouse. In simple terms Dimensional Modeling is used to support end-user queries. DM is not only applied to relational databases but can also apply to non-relational databases. The DM use the two main concept first one is \u201cFACT\u201d and other one is \u201cDimensions\u201d. Fact also refers as Measures which are typically numeric values. Dimensions are refers context, which are group of descriptor which defines facts. Every Phase of Dimensional Modeling results in some metadata which can be used to identify what exactly present in data warehouse.<\/p>\n
In dimensional modeling, the facts are encapsulated with star-like structure of dimensions. There are four step used to build DM based data warehouse.<\/p>\n