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.展开更多
随着大数据时代的发展,海量的地理空间数据的存储和检索成为当前GIS系统需要解决的一个关键问题。空间数据访问引擎作为客户端与数据服务器之间的中间桥梁,提供了空间数据的存取通道。对此,本文设计实现了基于MySQL数据库的矢量数据访...随着大数据时代的发展,海量的地理空间数据的存储和检索成为当前GIS系统需要解决的一个关键问题。空间数据访问引擎作为客户端与数据服务器之间的中间桥梁,提供了空间数据的存取通道。对此,本文设计实现了基于MySQL数据库的矢量数据访问引擎(Vector Spatial Data Engine, VSDE),可应用于常规非拓扑矢量数据格式在MySQL关系型数据库中的存储和检索。并以Shapefile数据格式为例进行了实验,成功地验证了实验方案的可行性。该系统能成功地嵌入小型GIS系统中,可用于非拓扑矢量空间数据的定制化管理。展开更多
My SQL数据库是开放性跨平台的一种开源型关系数据库,是将事物及其相关数据以二维表的形式进行相关数据信息描述,同时My SQL提供完整约束条件操作,从而保证数据安性。论文以高校科研管理平台的相关数据信息为数据基础,开发和研究相关数...My SQL数据库是开放性跨平台的一种开源型关系数据库,是将事物及其相关数据以二维表的形式进行相关数据信息描述,同时My SQL提供完整约束条件操作,从而保证数据安性。论文以高校科研管理平台的相关数据信息为数据基础,开发和研究相关数据表之间和数据与数据之间的结构关系。展开更多
文摘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.
文摘随着大数据时代的发展,海量的地理空间数据的存储和检索成为当前GIS系统需要解决的一个关键问题。空间数据访问引擎作为客户端与数据服务器之间的中间桥梁,提供了空间数据的存取通道。对此,本文设计实现了基于MySQL数据库的矢量数据访问引擎(Vector Spatial Data Engine, VSDE),可应用于常规非拓扑矢量数据格式在MySQL关系型数据库中的存储和检索。并以Shapefile数据格式为例进行了实验,成功地验证了实验方案的可行性。该系统能成功地嵌入小型GIS系统中,可用于非拓扑矢量空间数据的定制化管理。
