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.