Traditional enterprise data warehouse, an integral part of decision support systems (DSS), provides a variety of granularity data to satisfy requirements of different users. It is estimated that about 80% of the information stored in data warehouse is geo-spatial related. However, traditional data warehouse cannot efficiently process spatial data. With the increasing amount of spatial data stor...

To appreciate the wealth of information a data warehouse has to offer, you need to understand how to communicate with it. Information is typically accessed using an SQL query. The statement responsible for querying the many tables and returning the requested results in a data warehouse environment is the SELECT statement. It is an indispensable piece of the data retrieval process. This paper lo...

This paper seeks to build a data warehouse for the central region directorate of Ghana Education Service (GES). The project deployed top-down approach by relying on hub and spoke architecture based Joint Application Development (JAD) session organized elicit user requirements. Again, dependent marts, as well star schema, were chosen due their uniqueness appropriateness project. There were, howe...

Problem statement: The Data Warehouse is a database dedicated to the storage of all data used in the decision analysis, it meets the customer requirements, to ensure, in time, that a data warehouse complies with the rules of construction and manages the evolutions necessary of the information system (IS). Results: According to the studies carried out, we see that a system based on a data wareho...

Data warehouse [2,4,5,6] is an integrated repository derived from multiple source (operational and legacy) databases. The data warehouse is created by either replicating the different source data or transforming them to new representation. This process involves reading, cleaning, aggregating and storing the data in the warehouse model. The software tools are used to access the warehouse for str...