Research on the Application of Data Warehouse in Teaching Management System
Zhao Yuan
Abstract
Zhao Yuan
Abstract
Proposes a solution that is based on data warehouse,takes data warehouse and OLAP as the tool to design teaching management system and gives the system structure.Then presents the detailed design of the data warehouse,especialy the fact table,the dementinal table and the multidimensional data mode.Constructes the warehouse by SQL Sever 2000.Provides new way of how to use all the data to serve teaching,management and decision support.
A significance statement is not available in the OpenAlex record.
A contribution statement is not available in the OpenAlex record.
Method details are not available in the OpenAlex metadata.
Findings are not separately available in the OpenAlex metadata.
Limitations are not available in the OpenAlex metadata.
Application details are not available in the OpenAlex metadata.
Proposes a solution that is based on data warehouse,takes data warehouse and OLAP as the tool to design teaching management system and gives the system structure.Then presents the detailed design of the data warehouse,especialy the fact table,the dementinal table and the multidimensional data mode.Constructes the warehouse by SQL Sever 2000.Provides new way of how to use all the data to serve teaching,management and decision support.
Key concepts: Data warehouse, Computer science, Online analytical processing, Dimensional modeling, Table (database), SQL, Database, Warehouse