Conceptual model for a data warehouse on the web
Rajesh V. Nikam, Shailaja C. Shirwaikar, Vilas S. Kharat · 2016
All organizations big or small need to manage their data effectively, both the structured data stored in operational databases and the unstructured data that is spread out across documents. As the data size grows, it becomes essential to move the data to a warehouse so that data is available for adhoc queries and analysis. This data repository of both useful data and documents along with meta data need to be moved to the Web so that the data is easily accessible to all the stakeholders. This warehouse on the web can be constructed using Resource Oriented architecture that has the good properties of addressability, statelessness, scalability, connectedness and simple unified interface. Every physical or conceptual object that is part of an organization leaves an information footprint in form of unstructured or semi structured documents and data that are captured in a set of attributes. The relevant attributes of objects and their relationships with other objects exhibit a conceptual hierarchy that can be best modeled by resources on the web. This paper presents a Conceptual Model for constructing a Data Warehouse on the web server for storage, versioning, metadata, retrieval and adhoc queries. It will hold the documents generated, received, modified by the organization and the related data. A framework is designed with a simplified interface that can be used to construct, view and interrogate such a data warehouse.