Data warehouse stores information of various types and from various sources. Why is Metadata Necessary in a Data Warehouse?Ī data warehouse refers to a large repository of data that can be processed or analyzed for various purposes. This directory helps the decision support system to locate the contents of a data warehouse. As such, metadata acts as the central nervous system for a data warehouse Building and processing of data warehouse generate metadata and that metadata may then be used by a different method for processing.Metadata acts as a glue that links all parts of a data warehouse.Metadata acts as a roadmap and a dictionary to the data warehouse.Metadata plays a number of roles in a data warehouse For a data warehouse, Metadata acts as a dictionary as well as a roadmap to the various modules of that data warehouse.For any relational schema in a relational database, its metadata would store the relationships between the various tables and their types as well as individual metadata about each table as well.For any table in a relational database, its metadata would store the table name, column names, and their types along with information about their primary keys, foreign keys, and so on.Example of Metadata in DBMSĪ few examples of metadata in DBMS include: Information like size, encoding, author, date, etc is all descriptive metadata. Descriptive Metadataĭescriptive Metadata stores descriptive information on any file, folder, image, video etc. It represents the data that is used by executive-level managers to perform any task. Operational Metadata stores information about data that is currently under any operation. Information like ownership, Policies of handling data, business rules and regulations etc are stored as business metadata Business Metadataīusiness metadata contains information about a particular business and the way that business may handle the data in the database. table names, table sizes, data types, values, attributes, primary keys, foreign keys,e tc. Technical Metadata stores information about the way in which data is stored in the Database, i.e. There are four types of metadata in DBMS, namely : Technical Metadata Metadata is the value that leads us to the actual data and is an acronym for the detailed data in a database. Metadata in a relational DBMS stores data about Constraints, Table Relationships, Data Types, Columns, Tables, and so on. It describes the context and information about data, the way that data is stored and the various relations among data. Metadata in DBMS is characterized as data about data. In a database, metadata stores all information about the schema itself, the columns, rows, and relations are stored within the metadata of the database. For example, in images, metadata stores the size, encoding, date of modification, etc. The term metadata is used for different types of data in different contexts. Metadata, in simple terms, refers to data about data. What does being meta mean? In popular culture, especially in art and media, the term 'meta' is used to characterize something that is characteristically self-referential.

Define meta level