Open Data Combined Design and Application of Data Warehouse - Food and Drug Cases
| Autor: | CHIA WEI CHANG, 張家維 |
|---|---|
| Rok vydání: | 2016 |
| Druh dokumentu: | 學位論文 ; thesis |
| Popis: | 104 After having serial food safety problems in recent years, people focus more on the resources, combination, and possible violation of food safety regulations, which, furthermore, leads to a rising need for an Open Date of food and drugs. Most of the current open data for certain food and drug exist in separated and single files, and seldom are they integrated together. That means there is no integrated platform for searching these open data for food and drugs effectively. Therefore, this research aims to integrate all the open data of food and drugs into a Data Warehouse (DW), for solving the problem that people can only get information from separated files. People will be able to access the entire database and to have a more clear idea of the current condition of food and drugs. By doing so, problematic products can be prevented from being bought and the quality of food and drug will be raised. With the techniques of extraction, transform, and loading ETL, this research has designed a data warehouse system for food and drug after integrating the Open Data of food and drugs belonging to government into the DW (data warehouse), built an Internet Information Service(IIS), and combined the application of statistics report. This system allows users to get all the information of food and drugs that open to the public. Besides basic searching functions, the system at the same time provides mixing and multi-dimensional searching functions. The searching results are also available to be exported into Excel spreadsheets for further usages for more people and business groups. |
| Databáze: | Networked Digital Library of Theses & Dissertations |
| Externí odkaz: |
|