Qualitative model to enhance quality of metadata for data warehouse
- PDF / 2,192,469 Bytes
- 12 Pages / 595.276 x 790.866 pts Page_size
- 107 Downloads / 245 Views
ORIGINAL RESEARCH
Qualitative model to enhance quality of metadata for data warehouse Vinay Gautam1
Received: 29 July 2017 / Accepted: 16 July 2018 Bharati Vidyapeeth’s Institute of Computer Applications and Management 2018
Abstract A metadata quality directly impact on the decision making. Therefore, the metadata is enhanced with semantics to improve quality of metadata but no formal representation is laid down. Here in this work, the formal representation of metadata is proposed to enhance the quality of information required for decision making. Therefore, in this paper three formal models are defined to properly manage metadata with different types of operation and to provide qualitative information to user. First is to define the metadata. Second is to describe metadata development process. Third model is used to formally describe the complete process of metadata management. All three models are used to properly representation and management of metadata.
configuration specifications etc., which is used by the developer and technical people. Business Metadata contains the information for end user. In [1] metadata is extended with semantics to provide extra information to user. But still the metadata is lacking with framework for representation. Few organizations started to use standard meta-model for defining metadata and its management. Models are Common Warehouse Model and Open Information Model are proposed in [2, 3] for formally defining and its management. Still no model properly defines, develop and manage metadata to enhance quality of information. Therefore, this paper proposed three models for formally representing, developing and managing metadata to provide quality information to users.
Keywords Metadata quality Metadata management Data warehouse
1.1 Related work
1 Introduction The metadata is data about data, captures all the information necessary to analyze, design, build, use and interpret the data warehouse contents. This data can be used by decision makers to improve decision making quality. Therefore quality of metadata is required to be maintained as per warehouse definition. The metadata has two categories of data—technical metadata and business metadata. The technical metadata includes schema definitions and & Vinay Gautam [email protected] 1
Thapar Institute of Engineering and Technology, Patiala 147003, India
Metadata is a promising driver for quality decision making. The standard metadata is managed by the metadata repository [2] where the metadata is properly defined and structured. As brought out above, the metadata is of two types: business metadata and technical metadata. The business metadata is defined to support end-user. Few examples of usage metadata are mentioned in [4–6]. The business metadata is used to provide flexibility to data mart deployment from data warehouse [4]. The business metadata is used to integrate data warehouse and enterprise goals by building a model to provide links between enterprise goals and data warehouse [5]. Temporal object oriented busi
Data Loading...
