An Indoor Air Quality Long-term Monitoring Data MySQL Database For Chinese Buildings

Researchers who are devoted to study residential indoor air quality in China mainland always have difficulties in making groundbreaking scientific discoveries.The main reason lies in there is still not a database where tremendous amount of a long-term monitoring time-series data(LMTD)are well managed,precision-guaranteed and researcher-oriented.In order to tackle this problem,a LMTD MySQL database with data management,data preprocessing and graphic user interface(GUI)is specially developed.The quality and accuracy of LMTD in MySQL database is the most significant factor of our research.Therefore,LMTD preprocessing plays the central role of the paper.In the research,we have found and invented a bunch of algorithms to filter LMTD outliers and eliminate LMTD deviations,as well as the benchmarks validating the effectiveness of regarding methods.LMTD from Xinjiang and Tianjin districts manifests the success of abovementioned approaches.And variation by benchmarks also indicates that the most effective algorithm is suit for specific LMTD from different district,household and time.Thus,we further propose algorithm selecting mechanisms to maximize the effectiveness of LMTD preprocessing based on the benchmarks,and the mechanisms are translated into PHP programs embedded into process of fetching data.With these preprocessed LMTD,researchers in our project have found several discoveries from this database.