Tata Kelola Database Perguruan Tinggi Yang Optimal Dengan数据仓库
Tata Kelola Database Perguruan Tinggi Yang Optimal Dengan Data Warehouse
摘要：
新的高等教育机构的出现创造了高等教育市场的竞争，而数据仓库可以作为提高高等教育市场竞争力的有效技术工具。数据仓库在短时间内为机构的高层管理人员生成可靠的报告，以便更快更好地做出决策，不仅是增加学生的入学人数，而且还可以为机构找到特殊的非常规资金。效率比较基于OLTP数据库和数据仓库上处理的记录的长度和数量、处理的总字节、处理的表的数量、运行查询的时间和产生的记录。通过百分比增长公式计算效率百分比，平均效率百分比为461.801.04%，表明使用数据仓库比使用OLTP数据库更强大和高效。数据仓库是基于超立方体的数据仓库模型，超立方体是由有限的高需求的报告，通常被高层管理人员使用。在每个事实和维度表中，将插入表示加载建设性合并的字段，其中ETL（提取，转换和加载）过程基于旧文件和新文件运行。
英文摘要：
The emergence of new higher education institutions has created the competition in higher education market, and data warehouse can be used as an effective technology tools for increasing competitiveness in the higher education market. Data warehouse produce reliable reports for the institution's high-level management in short time for faster and better decision making, not only on increasing the admission number of students, but also on the possibility to find extraordinary, unconventional funds for the institution. Efficiency comparison was based on length and amount of processed records, total processed byte, amount of processed tables, time to run query and produced record on OLTP database and data warehouse. Efficiency percentages was measured by the formula for percentage increasing and the average efficiency percentage of 461.801,04% shows that using data warehouse is more powerful and efficient rather than using OLTP database. Data warehouse was modeled based on hypercube which is created by limited high demand reports which usually used by high level management. In every table of fact and dimension fields will be inserted which represent the loading constructive merge where the ETL (Extraction, Transformation and Loading) process is run based on the old and new files.
机构、总结、中文摘要均由AI分析而来，可能存在错误，请以论文正文为准。
