Colossal Data Warehouse

Abstract

Data Warehouse is a subject-oriented, integrated, non-volatile, time variant collection of data in support of management's decision. Data Warehouse provides instant access to historical data, which is very useful to forecast the trend that is not possible in mainframes (because they don't have the abi lity to do real-time analysis). The application COW is developed, providing sufficient data for allowing decisions to be made in a more timely fashion, enhancing the competitiveness and cost structure of the corporation. Colossal Data Warehouse as its name depict possesses the ability to store enormous amount of data. The key strategy used for the development of CDW is its dual storage that can be made on both hard disk and compact discs. The potential database chosen and developed for CDW is ISP Billing System. This database is developed using Oracle 9i Database Management System. Features like portability, reliability, and reduced use of resources in terms of system, bandwidth, end-users and market enhance the vision of this application. A Distributed Database approach is a very major constituent of this application as two types of data retrieval can be expected in general. One is for query/transaction processing, which is fulfilled by the use of Production Database. The second approach for data retrieval can be for the purpose of analysis that is fulfilled from the Historical Database. CDW is a client/server application design i.e. based on two tiers. The application Colossal Data Warehouse is completely a new idea and is ~esigned in such a way as to facilitate end-user browsing and execution of queries, both from a performance perspective and ease of understanding. For this purpose the application's front end is designed using Developer Forms 6i. This Project report guides you through the path carved for achieving such an application that requires a Jot more than just an effort.