Based On The Entrance Examination Of The Data Warehouse Decision Support System

With the rapid development of database technology and wide application of data management system,more and more data is accumulated by all kind of agencies,there has important information behind the surging in the number of data, people hope to analyze these data in higher level in order to use these data for decision support better. However, database's support for analysis has not been satisfied, it is essential to extract analysis's data from transaction environment, integrate and reorganize according to decision support system, establish a separate environment of analysis, format a new data Storage and organizational technology, which is the data warehouse.Data warehouse is a better support for enterprises or organizations to decide analysis, subject-oriented, integrated, non-renewable, changing the data collection with time. OLAP-based data warehouse is designed to support the complex analysis of the operation of emerging software technologies, it aims on-line data access and analysis requirements of specific issues, by the support of the multi-dimensional data model and a variety of angles of observations Fast, consistent and stable interactive data access, allowing decision makers to manage and analyze data deeply. DSS system Using data warehousing, OLAP and data mining technology in the implementation of capacity has greatly improved efficiency, can provide enterprises with subject-oriented quality information for decision-making so that it can use the information formulate effective strategic decision-making.While studying and researching data warehouse and OLAP technology, I plan, design, and develop an entrance examination decision support system. The system bases on existing Internet taking college entrance examination system, use large capacity database to establish a department-level data warehouse by transformation and abstract, according to the need of decision and management, orient all kind of themes and implement on-line analysis, we do some sense attempt and research in providing efficient and accurate for entrance examination decision.