With the development of the digital city,data and data analysis have become more and more important.The database is the foundation of data analysis.In this paper,the software system of the urban land planning database...With the development of the digital city,data and data analysis have become more and more important.The database is the foundation of data analysis.In this paper,the software system of the urban land planning database of Shanghai in China is developed based on MySQL.The conceptual model of the urban land planning database is proposed,and the entities,attributes and connections of this model are discussed.Then the E-R conceptual model is transformed into a logical structure,which is supported by the relational databasemanagement system(DBMS).Based on the conceptual and logical structures,by using Spring Boot as the back-end framework and using MySQL and Java API as the development tools,a platformwith datamanagement,information sharing,map assistance and other functions is established.The functionalmodules in this platformare designed.The results of J Meter test show that the DBMS can add,store and retrieve information data stably,and it has the advantages of fast response and low error rate.The software system of the urban land planning database developed in this paper can improve the efficiency of storing and managing land data,eliminating redundant data and sharing data.展开更多
The investigation of the tendency of climate change and its effects on ecology, economy and sociology is essential for long term policy making. The long-term measurement of the physical and chemical properties of the ...The investigation of the tendency of climate change and its effects on ecology, economy and sociology is essential for long term policy making. The long-term measurement of the physical and chemical properties of the atmosphere with state-of-the-arts instruments provides high-quality data for these studies. The evaluated data are stored in really special file structures and formats that cannot be inserted in one common database. Moreover, the observed data usually available in ASCII format and the users sometimes need to convert them in other format. The file conversion is usually time consuming procedure and can contribute to the uncertainties. MeteoRead is a client database software that imports the observed atmospheric data e.g. wind direction, wind speed, aerosol particle concentration etc. and makes them available in different file formats, which are most commonly used in climate research. This Java<sup>TM</sup> based program applies the Structured Query Language (SQL) functions such as table creation on a database server, data or figures insertion into the table and data selection via Graphical User Interface. The selected data can be stored in NetCDF, HDF5, DataBase or TXT file formats and the figures can be available in PNG, JPG, JPNG, PDF or GIF file formats. The program was tested on Linux and Windows platforms with different Java<sup>TM</sup> Development Kit. The MeteoRead is planned to be developed to visualizing the annual, seasonal, monthly, daily or hourly average value of the selected data and to use the functionality of the SQL database to calculate various mathematical and statistical correlations.展开更多
SQL是一种数据库查询和程序设计语言,用于存取数据以及查询、更新和管理关系数据库系统。MySQL是开放源码软件,具有体积小、速度快的特点。Navicat for MySQL是一套管理和开发MySQL的理想解决方案,支持单一程序,可连接到MySQL。文章通...SQL是一种数据库查询和程序设计语言,用于存取数据以及查询、更新和管理关系数据库系统。MySQL是开放源码软件,具有体积小、速度快的特点。Navicat for MySQL是一套管理和开发MySQL的理想解决方案,支持单一程序,可连接到MySQL。文章通过一个详细的案例介绍了SQL查询语言在Navicat for MySQL平台中的基础性应用,并进行了相关的分析。展开更多
Aim： To improve workflow and usability by introduction of a new electronic patient record （EPR） and database. Methods： Establishment of an EPR based on open source technology （MySQL database and PI-IP scripting l...Aim： To improve workflow and usability by introduction of a new electronic patient record （EPR） and database. Methods： Establishment of an EPR based on open source technology （MySQL database and PI-IP scripting language） in a tertiary care andrology center at a university clinic. Workflow analysis, a benchmark comparing the two systems and a survey for usability and ergonomics were carried out. Results： Workflow optimizations （electronic ordering of laboratory analysis, elimination of transcription steps and automated referral letters） and the decrease in time required for data entry per patient to 71% ± 27%, P 〈 0.05, lead to a workload reduction. The benchmark showed a significant performance increase （highest with starting the respective system： 1.3 ± 0.2 s vs. 11.1 ± 0.2 s, mean ± SD）. In the survey, users rated the new system at least two ranks higher over its predecessor （P 〈 0.01） in all sub-areas. Conclusion： With further improvements, today＇s EPR can evolve to substitute paper records, saving time （and possibly costs）, supporting user satisfaction and expanding the basis for scientific evaluation when more data is electronically available. Newly introduced systems should be versatile, adaptable for users, and workflow-oriented to yield the highest benefit. If ready-made software is purchased, customization should be implemented during rollout. （Asian J Andro12006 Mar; 8： 235-241）展开更多
基金funded by Start-Up Funds for Scientific Research of Shenzhen University,Grant No.000002112313.
文摘With the development of the digital city,data and data analysis have become more and more important.The database is the foundation of data analysis.In this paper,the software system of the urban land planning database of Shanghai in China is developed based on MySQL.The conceptual model of the urban land planning database is proposed,and the entities,attributes and connections of this model are discussed.Then the E-R conceptual model is transformed into a logical structure,which is supported by the relational databasemanagement system(DBMS).Based on the conceptual and logical structures,by using Spring Boot as the back-end framework and using MySQL and Java API as the development tools,a platformwith datamanagement,information sharing,map assistance and other functions is established.The functionalmodules in this platformare designed.The results of J Meter test show that the DBMS can add,store and retrieve information data stably,and it has the advantages of fast response and low error rate.The software system of the urban land planning database developed in this paper can improve the efficiency of storing and managing land data,eliminating redundant data and sharing data.
文摘The investigation of the tendency of climate change and its effects on ecology, economy and sociology is essential for long term policy making. The long-term measurement of the physical and chemical properties of the atmosphere with state-of-the-arts instruments provides high-quality data for these studies. The evaluated data are stored in really special file structures and formats that cannot be inserted in one common database. Moreover, the observed data usually available in ASCII format and the users sometimes need to convert them in other format. The file conversion is usually time consuming procedure and can contribute to the uncertainties. MeteoRead is a client database software that imports the observed atmospheric data e.g. wind direction, wind speed, aerosol particle concentration etc. and makes them available in different file formats, which are most commonly used in climate research. This Java<sup>TM</sup> based program applies the Structured Query Language (SQL) functions such as table creation on a database server, data or figures insertion into the table and data selection via Graphical User Interface. The selected data can be stored in NetCDF, HDF5, DataBase or TXT file formats and the figures can be available in PNG, JPG, JPNG, PDF or GIF file formats. The program was tested on Linux and Windows platforms with different Java<sup>TM</sup> Development Kit. The MeteoRead is planned to be developed to visualizing the annual, seasonal, monthly, daily or hourly average value of the selected data and to use the functionality of the SQL database to calculate various mathematical and statistical correlations.
文摘SQL是一种数据库查询和程序设计语言,用于存取数据以及查询、更新和管理关系数据库系统。MySQL是开放源码软件,具有体积小、速度快的特点。Navicat for MySQL是一套管理和开发MySQL的理想解决方案,支持单一程序,可连接到MySQL。文章通过一个详细的案例介绍了SQL查询语言在Navicat for MySQL平台中的基础性应用,并进行了相关的分析。
文摘Aim： To improve workflow and usability by introduction of a new electronic patient record （EPR） and database. Methods： Establishment of an EPR based on open source technology （MySQL database and PI-IP scripting language） in a tertiary care andrology center at a university clinic. Workflow analysis, a benchmark comparing the two systems and a survey for usability and ergonomics were carried out. Results： Workflow optimizations （electronic ordering of laboratory analysis, elimination of transcription steps and automated referral letters） and the decrease in time required for data entry per patient to 71% ± 27%, P 〈 0.05, lead to a workload reduction. The benchmark showed a significant performance increase （highest with starting the respective system： 1.3 ± 0.2 s vs. 11.1 ± 0.2 s, mean ± SD）. In the survey, users rated the new system at least two ranks higher over its predecessor （P 〈 0.01） in all sub-areas. Conclusion： With further improvements, today＇s EPR can evolve to substitute paper records, saving time （and possibly costs）, supporting user satisfaction and expanding the basis for scientific evaluation when more data is electronically available. Newly introduced systems should be versatile, adaptable for users, and workflow-oriented to yield the highest benefit. If ready-made software is purchased, customization should be implemented during rollout. （Asian J Andro12006 Mar; 8： 235-241）
