An Optimized algorithm to select the appropriate Schema in Data Warehouses

The successful organization is the result of the successful decisions made by the top management. These are the collaborated decisions and require a lump sum data or the consolidated view of organization, which is provided by data warehousing system. These systems are used as an organization repository to support strategic decision making. Data schema represents the arrangement of fact table and dimension tables and the relations between them. In data warehouse development, selecting a right and appropriate has an important Impact on performance and usability of the designed data warehouse. One of the problems that exist in data warehouse development is lack of a comprehensive and sound selection framework to appropriate schema for the data warehouse at hand by considering application domain research work, presents a stepwise algorithm for schema selection, which solves the problem of choosing right schema for a data warehouse. The main selection criteria are query type, attribute type, dimension table type and existence of index. Authors also tried to described efficient way of answering queries that are coming from multiple classes of users.