Metadata represents the information about data to be stored in Data Warehouses. It is a mandatory element of Data Warehouse to build an efficient Data Warehouse. Metadata helps in data integration, lineage, data quality and populating transformed data into data warehouse. Spatial data warehouses are based on spatial data mostly collected from Geographical Information Systems (GIS) and the trans...

This paper proposes the design of Star Schema of a Data Warehouse and conversion to its equivalent Graph based Multi Dimensional Data Model (GMDDM Model). Design of Star Schema facilitates in constructing Graph based Multi Dimensional Data Model. The GMDDM model defines a set of graph based constructs that are used to specify the conceptual level design of Data Warehouse. Data warehouse represe...

The aim is to study the data warehouse specific security needs which means focusing on the long life cycle of the data and the data security and privacy issues. These requirements needs to be fulfilled despite of the unpredictable future uses of the data. The basic assumption is that data warehouse server is running on the dedicated server, and the basic information system security is properly ...

The increasing demands for interactive response time from the users makes query performance one of the central problems of Data warehouse systems today. Performance is an important quality aspect of Data warehouse systems. Predicting the performance of Data warehouse systems during early design stages of their development is significant. Software Performance Engineering(SPE) promotes the idea t...

Poor quality of data in a warehouse adversely impacts the usability of the warehouse and managing data quality in a warehouse is very important. In this article we describe a framework for managing data quality in a data warehouse. This framework is of interest to both academics and practitioners as it offers an intuitive approach for not just managing data quality in a data warehouse but also ...

The data warehouse is not a new practice in the IT world, all the domains which have data can make a decision system, data warehouse, to exploit well the generated knowledge we have to maintain the good conditions to have a good decision making. By the application of the best practice of ITIL, we limit the risks and the malfunction of a data warehouse, and by the addition of a layer which treat...