CN1341901A - Agricultural ecological multi-dimensional data management technique - Google Patents
Agricultural ecological multi-dimensional data management technique Download PDFInfo
- Publication number
- CN1341901A CN1341901A CN 01108005 CN01108005A CN1341901A CN 1341901 A CN1341901 A CN 1341901A CN 01108005 CN01108005 CN 01108005 CN 01108005 A CN01108005 A CN 01108005A CN 1341901 A CN1341901 A CN 1341901A
- Authority
- CN
- China
- Prior art keywords
- data
- field
- relation
- soil
- many
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Recently, most domestic agriculture ecology databases are decentralized data table built based on one-dimensional table of common commercial database. It not only can not manage the data in different type such as the data of map, graphicas, image, and document, but also it can not manage the multi-dimensional data that relates to time and space. The said drawback causes inconvenient to retrieve information. the key of the invention is that data with various types are built into data document according to field and type of application. The multi-dimensional relationship and querying relationship between time, space and special topic of agriculture ecology database and visualized display interface are built by using OLE field, men field and long binary field of existent commercial database to store graphics, image, and long text.
Description
The present invention relates to the management of agricultural ecological multi-dimensional data, belong to agricultural and computer realm.
The Agro-ecology data not only contain time dependent information, and contain regional spatial information.Being used for the Agro-ecology data should comprise: come from landform, landforms, soil, the soil utilization of map or remotely-sensed data, vector or the raster data of vegetation; The climatic statistics and the socioeconomic statistics data that come from statistics network; Also should comprise the field inspection test figure.So that it is according to the experience and the data of open-air long-term observation testing site, qualitative or carry out quantitatively that GIS is regional to be analyzed.Domestic most of Agro-ecology databases are to be based upon the data form that disperses on the general commercial data base one-dimensional form basis at present, can not manage data of different types, as map, figure, image, document data, can not manage relate to the time, the multidimensional data in space, bring inconvenience for further information extraction.
The objective of the invention is to: (1) is set up a kind of method and is enabled Relational Data Base Management various types of data (map, image, field inspection experiment, relation data form, figure, text) by general merchandiseization; (2) organize data structure according to various space distribution relations and hierarchical relationship in the agroecology; (3), can obtain the place data query according to thematic classification, data acquisition time and data for the user provides a good user interface.
The present invention includes vector or the raster data of gathering the landform come from map or remotely-sensed data, landforms, soil, soil utilization, vegetation; The climatic statistics and the socioeconomic statistics data that come from statistics network; Come from the field inspection test figure, data of different types is set up data file according to range of application and type; Set up the space distribution relation and the query relation of agricultural ecological multi-dimensional data; Set up the visualized data display interface of Query Result.Its key is data of different types is set up data file according to range of application and type; Utilize OLE field, mem field and longbinary field store figure, image and the long text of existing merchandising database; Set up the time, space of Agro-ecology data, the multi-dimensional relation and the query relation of special topic; Set up the visualization display interface of Query Result.Different types of data is categorized as thematic map data (map or remotely-sensed data), related table (field inspection data) and text data, and adopt different storages and inquiry mode, MS ACCESS database provides the mem field that is used to store the OLE field of figure, image and link Excel form and stores long text, and oracle database is then finished above-mentioned functions with Long binary field; The form that the data set that contains free and spatial characteristics in the multidimensional data connects each other with 3 data is represented the distributed in three dimensions relation, data acquisition time is pressed in design, data take place and special topic inquiry number to represent the distributed in three dimensions relation, data acquisition time is pressed in design, data are taked place and thematic data query function, and with the relation of the multi-to-multi between them, by designing a form in the middle of two many-to-many relationships, many-to-many relationship is converted to the relation of many-one and one-to-many; Use the Oracle/Access database software according to The above results, obtain the query interface of setting up by user's mode of thinking.The classification of different types of data, at first extract the public information of data as data general-purpose information, design one " data set essential information ", extract the metadata of thematic map data, field inspection data and document data then respectively, form different grouped data forms, " data set essential information " is connected by data set identification " data set-ID " with " grouped data form ".
The embodiment that will provide by accompanying drawing below, details are as follows just to realize method of the present invention:
Fig. 1 is the different types of data management structure;
Fig. 2-5 is the tissue and the classification of different types of data;
Fig. 6-8 is the soil nutrient data of description time and three-dimensional spatial distribution;
Fig. 9-10 is time enquiry form relation;
Figure 11-13 is space querying form relation;
Figure 14-16 is thematic classification enquiry form relation;
Figure 17 is the multidimensional data Managed Solution;
Figure 18 is thematic query case;
Figure 19 is an Agro-ecology data base querying interface example;
Figure 20 is a soil species query interface example.
1. the administrative skill of different types of data
Data type is categorized as thematic map data (map or remotely-sensed data), related table (field inspection data) and text data, adopts different storage and inquiry mode.MS ACCESS database provides the mem field that is used to store the OLE field of figure, image and link Excel form and stores long text, and oracle database is then finished above-mentioned functions with Long binary field.
Thematic map data: because the restriction of database software itself, can not occupy the map or the remotely-sensed data of a large amount of storage spaces with existing machine handing, but its metadata of design inquiry (comprises engineer's scale, projection, explanation, compressed image), the user is by query metadata and browse compressed image, understands the feature of data.By the access explanation of data, or the acquisition data set is pointed in the html link.The view data that is used to browse realizes by Windows OLE fields function link gif file or jpg file.
Related table: observation experiment data great majority are made up of the relation data form.The metadata of observation experiment data should comprise the observation title, data type, sample frequency, research purpose, test design and method, test apparatus etc.The user at first understands research purpose and the experimental technique that forms data before obtaining data, observation data realizes by Windows OLE fields function link excel spreadsheet lattice.
Text or management data: text data is from important document files, and for example achievement illustrates, Chinese and English brief introduction, relevant testing station district figure, staff list etc.Whether its metadata should comprise: title, summary, deliver or win a prize, deliver (winning a prize) date, periodical etc.Text data stores with the mem field in database.
At first extract the data public information as data general-purpose information.Design a form " data set essential information ", its field comprises: dataset name, source, data set type, data zero-time, ED time, the supplier of data, data provide tissue, digitizing state etc.Then, extract the metadata of map datum, field inspection data and document data respectively, form different grouped data forms: " thematic map ", " observation data ", " text data ".Because may there be a plurality of data subsets in a data set, " data set essential information " is connected by data set identification " data set-ID " with " grouped data form ", and its pass is the logical relation (see figure 1) of one-to-many.
2. multidimensional data management
1) space distribution relation
Comprise that the data set of envirment factor such as field inspection test, ecological monitoring, agricultural microclimate and socioeconomic statistics all contains the feature of space distribution, only describes the essence that can not reflect spontaneous phenomenon with single relation data form respectively.For example, at different time different location different depth of soil nutrient being measured is exactly to comprise time domain and three-dimensional information.May gather a plurality of places in the sampling time section, the three unities has been gathered the sample of different depth again.Design following three forms (wherein Fig. 6 is temporal information, and Fig. 7 is a location information, and Fig. 8 is the soil profile depth information).
Shown in Fig. 6,7,8, a sampling time may relate to a plurality of collecting locations, and time and collecting location are the relation of one-to-many; A collecting location has different sampling depths again, and sampling position and sampling depth also are the relations of one-to-many.
2) multi-dimensional query of time, space, thematic classification relation
Consider that the general inquiry of user needs, design is pressed data acquisition time, data acquisition place, is reached the function of thematic data query.
In the essential information form of data set, increase data zero-time and end of data set time.Set up zero-time and concluding time during inquiry.When the zero-time section＞=data zero-time of inquiry, and the concluding time＜=ED is during the time, can be met the Query Result (seeing Fig. 9 data acquisition essential information, Figure 10 query time section) of time querying condition.
The Agro-ecology data also relate to the spatial data category, and each data set may contain a plurality of data acquisitions place, and certain place may relate to a plurality of data sets.Represent its complicated distribution relation (Figure 11 data essential information, Figure 12 locality indexes, Figure 13 place) with the form that following three data connect each other.For example, data set 1 soil space database may relate to ground such as place Xin Zhuan, the cardinal principles of righteousness, mat lotus root canal; Place Xin Zhuan also is associated with data set 2: the socioeconomic statistics data.
In like manner, a data set may belong to a plurality of thematic scopes, and a thematic speech may include a plurality of data sets.For example, field inspection " water regime is to the influence of material migration and plant growth in the rice soil " data set may belong to " soil ", " agroecology " two thematic scopes; " soil " can have a plurality of data sets to quote as a thematic keyword.Data set and thematic keyword are similarly the relation of multi-to-multi.Because user inquiring needs, data set and data acquisition place, thematic mode are the logical relation of multi-to-multi.And realization multi-to-multi Boolean query is realized very difficulty of inquiry for a relational database.The method that solves this contradiction is: design a form in the middle of two many-many relationships, many-to-many relationship is converted to the relation of many-one and one-to-many.For example, for the data that solve and the relation of thematic keyword multi-to-multi, at first the general information of data set is set up form " data set essential information ", the special topic key word information is set up form and " special topic " form, it is made up of two fields " data set-ID " and " special topic-ID ", describes the relation of one-to-many between the two or multi-to-multi.
For example, data set " water regime is to the influence of material migration and plant growth in the rice soil " can belong to classification " soil " and classification " agricultural ecological " two thematic scopes; " soil " can be used for data set 1 " soil space database ", data set 7 " soil fertility monitoring " and data set 8 " water regime is to the influence of material migration and plant growth in the rice soil " (Figure 14,15,16) as a thematic keyword.
In sum, in order to realize, to consider Agro-ecology data and time, space, thematic mutual relationship and create multidimensional data Managed Solution such as Figure 17 by time, place and thematic multi-dimensional query management data.
3) realization of fast query
Inquiry is a data acquisition treated, that people are concerned about.Frequent data definition to be processed is inquiry, but the reduced data work of treatment.The user needn't improve the performance of entire database each time at the basic enterprising line retrieval of raw data.In order to realize at first, connecting a plurality of forms, set up the fast query view by SQL statement to intersecting the form fast query.For example, for above-mentioned table 14,15,16 described special topic inquiries, can set up a following fast query of SQL statement that connects three forms in advance.
SELECT?DISTINCTROW?CATOLORY.Catolory_Name，DATASET.DATASET_ID，DATASET.DATASET_TITLE，DATASET.DATASET_TYPE，DATASET.START_TIME，DATASET.END_TIME，FROM?CATOLORY?INNER?JOIN?(DATASET?INNER?JOIN[Catelory?Usage]ON?DATASET.DATASET_ID＝[Catelory?Usage].DATASET_ID)ONCATOLORY.CATOLORY_ID＝[Catelory?Usage].CATOLORY_ID；
The fast query of setting up is as follows: special topic name data set-ID dataset name data class zero-time concluding time forms title Catolory-Name DATASET-ID DATASET-TITLE type TEPE START-TIME END-TIME FORM-NAME soil 1 soil space database GIs data 1,985 1985 Fchemiphyll
Station, storehouse soil 4 Changshu soil fertility text 1,990 1992 Ftxt
Monitoring soil 8 water regimes are to paddy rice text 1,989 1992 Ftxt
The material migration reaches in the soil
Plant growth influence soil 9 Chinese Academy of Sciences's Changshu maps 1,995 1995
The Agro-ecology station and
2 space system GIS data 1,970 1992 Feconmcl of social economy of neighboring region pedological map social economy
Counting is according to conventional meteorological observation 3 conventional meteorological statistics numerical table lattice 1,949 1980 Fclmt in Kuku
According to the storehouse
After fast query is set up, can create the forms that carry out interactive operation with the user, operate accordingly according to the information and executing that the user provides.Thematic title can be designed to the drop-down list combo box, when using window interfaces to inquire about, as long as selected thematic title equals the special topic name (Catolory name) in the fast query, the data set that then satisfies condition is selected, and directly shows on query interface.For example when drop-down list box selects special topic to be " soil ", below forms, demonstrate 5 data sets that satisfy this condition on the scroll bar, directly show the information (seeing Figure 18 special topic query case) of article one " soil space database " on the query interface.
Use the Oracle/Access database software according to above-mentioned technology, set up Changshu Agro-ecology Database Systems.11 data sets and corresponding data word bank have been collected and have set up.They are: soil space database (GIS database); Social economy's spatial statistics database (GIS database); Conventional meteorological statistics database (statistics); Agricultural microclimate observation data storehouse (observation experiment data); Soil fertility monitoring data (observation experiment data); Environmental pollution database (statistics); Rice wheat two ripe farmland ecosystem Carbon cycle (field test data); Agro-ecology station basic management information (text, form, figure); Agricultural environment spatial analysis shape library (figure).
The user when seeking data, at first thinking be his desired data be when, the place is collected, and belongs to what special topic scope.According to user's needs, design three basic query functions: time inquiry, place inquiry, special topic inquiry (seeing Figure 19 Agro-ecology data base querying interface example).
That is: select a time period, check where what thematic data, be collected if being present in the database; Select a special topic, check the acquisition time and the place that belong to this thematic data collection.With inquiry soil database is example, and query script is described.At first, set about from the special topic inquiry, searching keyword " soil ", it is relevant with " soil " to retrieve 5 data sets.Select data set 1 " Changshu City's soil space database ".Can learn that from the general information of data set be somebody's turn to do the soil survey information second time data from China: Changshu soil will, data acquisition time are 1985.Secondly, select summary to show.Summary has been described engineer's scale, projection, the graph code of pedological map and has been browsed figure.If the user is interested in these data, then open the data set word bank, inquire about or browse (seeing Figure 18).Changshu City's soil database is based on Changshu City's soil survey information, and selecting soil species is elementary cell, is representative with the representative section data of this soil species.Usually, the user wishes to select a soil species, understands its space distribution, categorical attribute, view, reaches physicochemical property.On query interface, design soil species and selected window, after a specific soil species is selected, database will show information such as the categorical attribute, space distribution image, landform, soil utilization, description of profile of this soil species at the main window of screen, show the different levels soil physico-chemical characteristic (seeing Figure 20 soil species query interface example) of this section at subwindow.
The agricultural ecological multi-dimensional data management technique that the present invention relates to can be managed map or remotely-sensed data, statistics and field inspection test figure, satisfies the needs of the management and the inquiry of numerous types of data and multidimensional data.The user inquiring interface of setting up according to user's mode of thinking has solved user oriented use problem preferably.
Claims (3)
1. agricultural ecological multi-dimensional data management technique comprises that collection comes from vector or the raster data of the landform of map or remotely-sensed data, landforms, soil, soil utilization, vegetation; The climatic statistics and the socioeconomic statistics data that come from statistics network; Come from the field inspection test figure, it is characterized in that
A. data of different types is set up data file according to range of application and type, utilize OLE field, mem field and longbinary field store figure, image and the long text of existing merchandising database, the various data of organization and administration;
B. set up the time, space of Agro-ecology data, the multi-dimensional relation and the query relation of special topic;
C. set up the visualization display interface of Query Result.
2. agricultural ecological multi-dimensional data management technique according to claim 1, it is characterized in that different types of data is categorized as thematic map data (map or remotely-sensed data), related table (field inspection data) and text data, and adopt different storages and inquiry mode, MS ACCESS database provides the mem field that is used to store the OLE field of figure, image and link Excel form and stores long text, and oracle database is then finished above-mentioned functions with Long binary field; The data set that contains free and spatial characteristics in the multidimensional data is represented the distributed in three dimensions relation with 3 data forms that connect each other, data acquisition time is pressed in design, data are taked place and thematic data query function, and with the relation of the multi-to-multi between them, by designing a form in the middle of two many-to-many relationships, many-to-many relationship is converted to the relation of many-one and one-to-many; Use the Oracle/Access database software according to The above results, obtain the query interface of setting up by user's mode of thinking.
3. agricultural ecological multi-dimensional data management technique according to claim 2, it is characterized in that the classification of different types of data, at first extract the public information of data as data general-purpose information, design one " data set essential information ", extract the metadata of thematic map data, field inspection data and document data then respectively, form different grouped data forms, " data set essential information " is connected by data set identification " data set-ID " with " grouped data form ".
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 01108005 CN1341901A (en) | 2001-01-04 | 2001-01-04 | Agricultural ecological multi-dimensional data management technique |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 01108005 CN1341901A (en) | 2001-01-04 | 2001-01-04 | Agricultural ecological multi-dimensional data management technique |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN1341901A true CN1341901A (en) | 2002-03-27 |
Family
ID=4656895
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN 01108005 Pending CN1341901A (en) | 2001-01-04 | 2001-01-04 | Agricultural ecological multi-dimensional data management technique |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN1341901A (en) |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN100440212C (en) * | 2004-10-14 | 2008-12-03 | 国际商业机器公司 | Methods and apparatus for processing a database query |
| WO2009070933A1 (en) * | 2007-12-06 | 2009-06-11 | Cham Ping Lam | Method and device for establishing relational table database |
| CN1794279B (en) * | 2005-12-29 | 2012-03-21 | 江苏省农业科学院 | Remote sensing estimation method for pest pesticide of crop rotation |
| CN102411635A (en) * | 2011-12-27 | 2012-04-11 | 北京人大金仓信息技术股份有限公司 | Method for realizing linked presentation of database forms and maps |
| CN107958085A (en) * | 2017-12-18 | 2018-04-24 | 中国农业科学院农业资源与农业区划研究所 | A kind of agricultural resource multi-source Spatial Data shared platform and its querying method |
| CN108595560A (en) * | 2018-04-12 | 2018-09-28 | 北京建筑大学 | The methods of exhibiting and system of geographic information data |
| WO2021032146A1 (en) * | 2019-08-22 | 2021-02-25 | 中兴通讯股份有限公司 | Metadata management method and apparatus, device, and storage medium |
| CN113918572A (en) * | 2021-10-29 | 2022-01-11 | 中国农业科学院农业资源与农业区划研究所 | Method for automatically matching and correcting agricultural statistical data based on administrative division boundary |
-
2001
- 2001-01-04 CN CN 01108005 patent/CN1341901A/en active Pending
Cited By (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN100440212C (en) * | 2004-10-14 | 2008-12-03 | 国际商业机器公司 | Methods and apparatus for processing a database query |
| CN1794279B (en) * | 2005-12-29 | 2012-03-21 | 江苏省农业科学院 | Remote sensing estimation method for pest pesticide of crop rotation |
| WO2009070933A1 (en) * | 2007-12-06 | 2009-06-11 | Cham Ping Lam | Method and device for establishing relational table database |
| CN101606151B (en) * | 2007-12-06 | 2015-09-02 | 林浔屏 | The method and apparatus of opening relationships type table database |
| CN102411635A (en) * | 2011-12-27 | 2012-04-11 | 北京人大金仓信息技术股份有限公司 | Method for realizing linked presentation of database forms and maps |
| CN102411635B (en) * | 2011-12-27 | 2016-02-10 | 北京人大金仓信息技术股份有限公司 | A kind of fulfillment database form and map link the method represented |
| CN107958085A (en) * | 2017-12-18 | 2018-04-24 | 中国农业科学院农业资源与农业区划研究所 | A kind of agricultural resource multi-source Spatial Data shared platform and its querying method |
| CN108595560A (en) * | 2018-04-12 | 2018-09-28 | 北京建筑大学 | The methods of exhibiting and system of geographic information data |
| WO2021032146A1 (en) * | 2019-08-22 | 2021-02-25 | 中兴通讯股份有限公司 | Metadata management method and apparatus, device, and storage medium |
| CN113918572A (en) * | 2021-10-29 | 2022-01-11 | 中国农业科学院农业资源与农业区划研究所 | Method for automatically matching and correcting agricultural statistical data based on administrative division boundary |
| CN113918572B (en) * | 2021-10-29 | 2022-06-07 | 中国农业科学院农业资源与农业区划研究所 | Method for automatically matching and correcting agricultural statistical data based on administrative division boundary |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Wu et al. | Research issues in data warehousing | |
| Lopez et al. | Spatiotemporal aggregate computation: A survey | |
| Cheng et al. | Efficient indexing methods for probabilistic threshold queries over uncertain data | |
| US7133876B2 (en) | Dwarf cube architecture for reducing storage sizes of multidimensional data | |
| Koperski | A progressive refinement approach to spatial data mining | |
| Abel | SIRO-DBMS SIRO-DBMS: a database tool-kit for geographical information systems | |
| Abdelguerfi et al. | The 2-3TR-tree, a trajectory-oriented index structure for fully evolving valid-time spatio-temporal datasets | |
| Xin et al. | Computing iceberg cubes by top-down and bottom-up integration: The starcubing approach | |
| Baumann et al. | Spatio-temporal retrieval with RasDaMan | |
| Dasgupta et al. | Leveraging count information in sampling hidden databases | |
| CN1341901A (en) | Agricultural ecological multi-dimensional data management technique | |
| Geffner et al. | Browsing large digital library collections using classification hierarchies | |
| May et al. | Spatial subgroup discovery applied to the analysis of vegetation data | |
| Ramsak et al. | Interactive ROLAP on large datasets: a case study with UB-trees | |
| Chen et al. | The chunk-locality index: An efficient query method for climate datasets | |
| Larson et al. | The Sequoia 2000 electronic repository | |
| Azevedo et al. | Approximate Spatial Query Processing using Raster Signatures. | |
| Ibrahim et al. | Efficient processing of spatial selection and join operations using SB/sup+/-tree | |
| JáJá et al. | Temporal Range Exploration of Large Scale Multidimensional Time Series Data. | |
| Zhao et al. | Data cleaning technology in agricultural monitoring information | |
| Sanver et al. | Multiresolution data aggregation for analytical exploration of large relational data | |
| Işık | Fuzzy spatial data cube construction and its use in association rule mining | |
| Noh | Literature Review on Temporal, Spatial, and Spatiotermpoal Data Models | |
| Otair | Enhancement First Depth Search and Best First Search Using Ranges within R-Tree | |
| Peluso et al. | Utilising the Western Australian soil profile database for research and land management |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C06 | Publication | ||
| PB01 | Publication | ||
| C12 | Rejection of a patent application after its publication | ||
| RJ01 | Rejection of invention patent application after publication |