CN107491494A - A kind of field storage method and system applied to soil environment monitoring system - Google Patents

A kind of field storage method and system applied to soil environment monitoring system Download PDF

Info

Publication number
CN107491494A
CN107491494A CN201710605803.3A CN201710605803A CN107491494A CN 107491494 A CN107491494 A CN 107491494A CN 201710605803 A CN201710605803 A CN 201710605803A CN 107491494 A CN107491494 A CN 107491494A
Authority
CN
China
Prior art keywords
field
dynamic
environment monitoring
monitoring system
soil environment
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
Application number
CN201710605803.3A
Other languages
Chinese (zh)
Inventor
谢志宜
陈丹青
张金区
肖娟
罗小玲
郭庆荣
张雅静
梁耀杰
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
GUANGDONG PROVINCE ENVIRONMENTAL MONITORING CENTER
Original Assignee
GUANGDONG PROVINCE ENVIRONMENTAL MONITORING CENTER
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by GUANGDONG PROVINCE ENVIRONMENTAL MONITORING CENTER filed Critical GUANGDONG PROVINCE ENVIRONMENTAL MONITORING CENTER
Priority to CN201710605803.3A priority Critical patent/CN107491494A/en
Publication of CN107491494A publication Critical patent/CN107491494A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22Indexing; Data structures therefor; Storage structures

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Software Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The invention discloses a kind of field storage method and system applied to soil environment monitoring system, the system includes acquisition module, enquiry module, display module and memory module.This method includes:According to the title of acquisition, search inquiry goes out from Lax entropy table matches corresponding dynamic field with the title;According to the type of the dynamic field inquired, the information data input frame that display is corresponding with the type of dynamic field on page control is made;It will be stored from the information data that described information data input frame inputs in the form of JSON character strings into extended field.By using the present invention, dynamic carries out increasing and deleting for field, operating flexibility and to be applicable compatibility high, and can also improve search efficiency.The present invention can be widely applied in soil environment monitoring system database as a kind of field storage method applied to soil environment monitoring system and system.

Description

A kind of field storage method and system applied to soil environment monitoring system
Technical field
The present invention relates to data storage processing technology, more particularly to one kind is suitable for soil environment monitoring system database Extendible adaptive field storage method and system.
Background technology
Technology word is explained
JSON:JavaScript Object Notation, JS object tags, it is a kind of data exchange lattice of lightweight Formula.
For the database purchase of conventional soil environmental monitoring system, it is the item number made a report on based on existing national requirements Measure to design storage field, so as to realize the preservation of corresponding information.However, the storage field of the design is changeless, when Need to increase other monitoring projects according to actual conditions, when carrying out other field data storages, then be only capable of entering system again Row modification, and the modification process of system is extremely complex, so can not only greatly increase workload and the work of designer Burden, and also result in operating efficiency, operate the problems such as convenient flexibility is low.Although in addition, at present existed system can between Connect the dynamic increase for realizing monitoring project and delete, but its search efficiency is low, causes the interactive experience of operator low.
The content of the invention
In order to solve the above-mentioned technical problem, it is an object of the invention to provide one kind to be applied to soil environment monitoring system data Extendible adaptive field storage method in storehouse;It is a further object of the present invention to provide one kind to be applied to soil environment monitoring system Extendible adaptive field storage system in system database.
The technical solution adopted in the present invention is:A kind of field storage method applied to soil environment monitoring system, should Method comprises the step of:
Obtain title;
According to the title of acquisition, from Lax entropy table search inquiry go out match with the title it is corresponding Dynamic field, wherein, the dynamic field is stored with required increased attribute item;
According to the type of the dynamic field inquired, the letter that display is corresponding with the type of dynamic field on page control is made Cease data input frame;
It will be stored from the information data that described information data input frame inputs in the form of JSON character strings to extended field In.
Further, the title according to acquisition, search inquiry goes out and the list name from Lax entropy table Title match corresponding to dynamic field the step for before be provided with dynamic field be arranged on this in Lax entropy table Step.
Further, described the step for being arranged on dynamic field in Lax entropy table, it includes:
The field of addition instruction and required addition is obtained using visualization interface, is then instructed, will obtained according to addition The field obtained is stored into the dynamic field memory block of Lax entropy table as dynamic field.
Further, described the step for being arranged on dynamic field in Lax entropy table, it also includes:
The field of deletion instruction and required deletion is obtained using visualization interface, then, is instructed according to deleting, triggering From the dynamic field memory block of Lax entropy table, corresponding dynamic field is deleted.
Further, the information that the attribute item is included has Property Name, memory length and data type.
Another technical scheme of the present invention is:A kind of field applied to soil environment monitoring system stores system System, the system include:
Acquisition module, for obtaining title;
Enquiry module, for the title according to acquisition, search inquiry goes out and the form from Lax entropy table Title matches corresponding dynamic field, wherein, the dynamic field is stored with required increased attribute item;
Display module, for the type according to the dynamic field inquired, make display and dynamic field on page control The corresponding information data input frame of type;
Memory module, for will be deposited from the information data that described information data input frame inputs in the form of JSON character strings Storage is into extended field.
Further, it is provided with before the enquiry module for dynamic field to be arranged on into matching somebody with somebody in Lax entropy table Put module.
Further, the configuration module includes addition configuration submodule, and the addition configuration submodule is used for using visual Change interface to obtain the field of addition instruction and required addition, then instructed according to addition, using the field of acquisition as dynamic Field is stored into the dynamic field memory block of Lax entropy table.
Further, for the configuration module also including deletion configuration submodule, the configuration submodule of deleting can for utilizing The field of deletion instruction and required deletion is obtained depending on changing interface, then, instructs, is triggered from Lax entropy according to deleting In the dynamic field memory block of table, corresponding dynamic field is deleted.
Further, the information that the attribute item is included has Property Name, memory length and data type.
The beneficial effects of the invention are as follows:The method of the present invention stores required increased attribute item by designing dynamic field Information, so when needing to carry out project data storage for extra monitoring project, just it can be filled out according to needed for the monitoring project The title of report, search inquiry goes out from Lax entropy table matches corresponding dynamic field with the title, so Afterwards according to the type of the dynamic field inquired, the information data that display is corresponding with the type of dynamic field on page control is made Input frame, so as to allow staff finally will according to the input of shown information data input frame progress respective item data Stored from the information data of information data input frame input in the form of JSON character strings into extended field.As can be seen here, lead to Cross and use the inventive method, can flexibly increase other required monitoring projects, so as to carry out the dynamic memory of respective item data, Operation ease and application compatibility are greatly improved, and the Information Number that will be inputted from described information data input frame The form of JSON character strings is stored to extended field, so when showing these data storages, it is only necessary to from extended field according to this Middle extraction information, attribute display is pressed after carrying out JSON conversions, substantially increases search efficiency.
The present invention another beneficial effect be:The system of the present invention stores required increased category by designing dynamic field Property item information, so when needing to carry out project data storage for extra monitoring project, just can utilize enquiry module according to The title made a report on needed for the monitoring project, search inquiry goes out from Lax entropy table matches pair with the title The dynamic field answered, then display module display and dynamic word on page control are made according to the type of the dynamic field inquired The corresponding information data input frame of type of section, so as to allow staff to carry out phase according to shown information data input frame The input of project data is answered, last memory module is by the information data inputted from information data input frame with the shape of JSON character strings Formula is stored into extended field.As can be seen here, by using present system, other extra required monitoring items can flexibly be increased Mesh and the dynamic memory for carrying out respective item data, operation ease and application compatibility are greatly improved, and will Stored in the form of JSON character strings to extended field from the information data of described information data input frame input, so shown During these data storages, it is only necessary to information is extracted from extended field, attribute display is pressed after carrying out JSON conversions, carries significantly High search efficiency.
Brief description of the drawings
Fig. 1 is a kind of step flow chart of field storage method applied to soil environment monitoring system of the invention;
Fig. 2 is a kind of structural frames schematic diagram of field storage system applied to soil environment monitoring system of the invention;
Fig. 3 is an a kind of specific embodiment step of field storage method applied to soil environment monitoring system of the invention Flow chart.
Embodiment
As shown in figure 1, a kind of field storage method applied to soil environment monitoring system, the step of this method includes Have:
Obtain title;
According to the title of acquisition, from Lax entropy table search inquiry go out match with the title it is corresponding Dynamic field, wherein, the dynamic field is stored with required increased attribute item;
According to the type of the dynamic field inquired, the letter that display is corresponding with the type of dynamic field on page control is made Cease data input frame;
It will be stored from the information data that described information data input frame inputs in the form of JSON character strings to extended field In.
As shown in Fig. 2 a kind of field storage system applied to soil environment monitoring system, the system includes:
Acquisition module 201, for obtaining title;
Enquiry module 202, for the title according to acquisition, search inquiry goes out and the table from Lax entropy table Lattice title matches corresponding dynamic field, wherein, the dynamic field is stored with required increased attribute item;
Display module 203, for the type according to the dynamic field inquired, make display and dynamic field on page control The corresponding information data input frame of type;
Memory module 204, for the information data that will be inputted from described information data input frame with the shape of JSON character strings Formula is stored into extended field.Wherein, the acquisition module, enquiry module, display module and memory module can be program module, Or hardware device module carrys out the time.
Further it is specifically described with reference to following specific embodiment to be done to the above method and system.
In order to meet extra items data storage requirement caused by extra monitoring project, the present invention devises one kind will be dynamic State field is arranged in Lax entropy table, to realize the scheme of extra items data dynamic memory.
In the present embodiment, soil environment monitoring system database using the soil texture, soil types, soil color this three Individual static fields describe soil information, and subsequently because management is needed, it is necessary to increase soil parent rock type, parent soil material type The two fields describe soil information, that is, need to carry out soil parent rock type, parent soil material type the two fields corresponding Information data storing, now, as shown in figure 3, the dynamic field storage method specific steps of the present invention include:
S101, dynamic field is arranged in Lax entropy table;
The step S101 has been specifically included:
S1011, using visualization interface provide field increase window, make staff will need increased field input to The window simultaneously confirms to add, and so as to acquire the field of addition instruction and required addition, (soil parent rock type and soil are female Matter type), then instructed according to addition, stored the field of acquisition as dynamic field to the dynamic word of Lax entropy table In section memory block;I.e. described dynamic field is required increased attribute item;
S102, in dynamic field storing process is realized, the title made a report on needed for acquisition;
S103, the title according to acquisition, search inquiry goes out and the title phase from Lax entropy table With corresponding dynamic field, i.e. soil parent rock type and parent soil material type the two dynamic fields;
S104, the type according to the dynamic field inquired, make display on page control relative with the type of dynamic field The information data input frame answered, such staff just can carry out respective item data according to shown information data input frame Information inputs;
S105, it will be stored from the information data that described information data input frame inputs in the form of JSON character strings to extension In field, when so subsequently needing to carry out the information data query display of dynamic field, it is only necessary to letter is carried out from extended field Breath extraction, and carry out after JSON conversions by attribute display.
For above-mentioned dynamic field, its attribute item information included has Property Name, memory length and data type; In addition, during the follow-up management, during without some projects being monitored and stored with corresponding project information data, then may be used Dynamic field is deleted according to actual conditions, described the step for deleting dynamic field, it is specifically included:
Field is provided using visualization interface and deletes window, makes staff input the dynamic field for needing to delete to this Window simultaneously confirms to delete, and so as to acquire the dynamic field for deleting instruction and required deletion, then, is instructed according to deleting, Triggering deletes corresponding dynamic field from the dynamic field memory block of Lax entropy table.It can not only so meet not With the actual demand of enterprise's different user, and the required memory headroom of database can also be saved.
Obtained by above-mentioned, had the advantages of method and system of the invention:
1st, it is actually needed by using the present invention, energy fundamental difference to carry out the addition of corresponding dynamic field and deletion, Operating flexibility is high, and is applicable compatibility by force, disclosure satisfy that the actual demand of different enterprises, disparity items;
When the 2nd, increasing new project data information storage, without remodify becoming to system, design is greatlyd save The workload and work load of personnel, improve operating efficiency;
3rd, on the basis of the dynamic for realizing monitoring project increases and deleted, it is possible to increase search efficiency, so as to make work The operating interactive experience sense of personnel is further enhanced.
Above is the preferable implementation to the present invention is illustrated, but the invention is not limited to the implementation Example, those skilled in the art can also make a variety of equivalent variations on the premise of without prejudice to spirit of the invention or replace Change, these equivalent deformations or replacement are all contained in the application claim limited range.

Claims (10)

  1. A kind of 1. field storage method applied to soil environment monitoring system, it is characterised in that:This method comprises the step of:
    Obtain title;
    According to the title of acquisition, from Lax entropy table search inquiry go out match with the title it is corresponding dynamic State field, wherein, the dynamic field is stored with required increased attribute item;
    According to the type of the dynamic field inquired, the Information Number that display is corresponding with the type of dynamic field on page control is made According to input frame;
    It will be stored from the information data that described information data input frame inputs in the form of JSON character strings into extended field.
  2. A kind of 2. field storage method applied to soil environment monitoring system according to claim 1, it is characterised in that:Institute The title according to acquisition is stated, search inquiry goes out from Lax entropy table matches corresponding dynamic with the title The step for dynamic field is arranged in Lax entropy table is provided with before the step for field.
  3. A kind of 3. field storage method applied to soil environment monitoring system according to claim 2, it is characterised in that:Institute The step for being arranged on dynamic field in Lax entropy table is stated, it includes:
    The field of addition instruction and required addition is obtained using visualization interface, is then instructed according to addition, by acquisition Field is stored into the dynamic field memory block of Lax entropy table as dynamic field.
  4. A kind of 4. field storage method applied to soil environment monitoring system according to claim 3, it is characterised in that:Institute The step for being arranged on dynamic field in Lax entropy table is stated, it also includes:
    The field of deletion instruction and required deletion is obtained using visualization interface, then, instructs, is triggered from word according to deleting In the dynamic field memory block of segment description information table, corresponding dynamic field is deleted.
  5. 5. according to a kind of any one of claim 1-4 field storage methods applied to soil environment monitoring system, it is special Sign is:The information that the attribute item is included has Property Name, memory length and data type.
  6. A kind of 6. field storage system applied to soil environment monitoring system, it is characterised in that:The system includes:
    Acquisition module, for obtaining title;
    Enquiry module, for the title according to acquisition, search inquiry goes out and the title from Lax entropy table Match corresponding dynamic field, wherein, the dynamic field is stored with required increased attribute item;
    Display module, for the type according to the dynamic field inquired, make display and the type of dynamic field on page control Corresponding information data input frame;
    Memory module, for will be stored from the information data that described information data input frame inputs in the form of JSON character strings to In extended field.
  7. A kind of 7. field storage system applied to soil environment monitoring system according to claim 6, it is characterised in that:Institute Be provided with the configuration module for dynamic field being arranged in Lax entropy table before stating enquiry module.
  8. A kind of 8. field storage system applied to soil environment monitoring system according to claim 7, it is characterised in that:Institute Stating configuration module includes addition configuration submodule, and the addition configuration submodule is used to obtain addition refer to using visualization interface Order and the field of required addition, then instruct according to addition, are stored the field of acquisition as dynamic field to field description In the dynamic field memory block of information table.
  9. A kind of 9. field storage system applied to soil environment monitoring system according to claim 8, it is characterised in that:Institute Stating configuration module also includes deleting configuration submodule, and the configuration submodule of deleting is used to delete to obtain using visualization interface Instruction and the field of required deletion, then, instruct, triggered from the dynamic field memory block of Lax entropy table according to deleting In, delete corresponding dynamic field.
  10. 10. according to a kind of any one of claim 6-9 field storage systems applied to soil environment monitoring system, it is special Sign is:The information that the attribute item is included has Property Name, memory length and data type.
CN201710605803.3A 2017-07-24 2017-07-24 A kind of field storage method and system applied to soil environment monitoring system Pending CN107491494A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201710605803.3A CN107491494A (en) 2017-07-24 2017-07-24 A kind of field storage method and system applied to soil environment monitoring system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201710605803.3A CN107491494A (en) 2017-07-24 2017-07-24 A kind of field storage method and system applied to soil environment monitoring system

Publications (1)

Publication Number Publication Date
CN107491494A true CN107491494A (en) 2017-12-19

Family

ID=60644784

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201710605803.3A Pending CN107491494A (en) 2017-07-24 2017-07-24 A kind of field storage method and system applied to soil environment monitoring system

Country Status (1)

Country Link
CN (1) CN107491494A (en)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109413030A (en) * 2018-08-31 2019-03-01 湖北海纳天鹰科技发展有限公司 A kind of enviromental protection instrument templating service system construction method and device based on json
CN111259201A (en) * 2018-12-03 2020-06-09 北京嘀嘀无限科技发展有限公司 Data maintenance method and system

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102346785A (en) * 2011-11-15 2012-02-08 北京创腾科技有限公司 Method and device for directly self-defining field of database
CN102779040A (en) * 2012-06-21 2012-11-14 东莞市微模式软件有限公司 Method and device for generating user-defined form
CN103218707A (en) * 2013-04-10 2013-07-24 沈阳昭软软件有限公司 Method for achieving dynamic form in workflow system
CN103294796A (en) * 2013-05-24 2013-09-11 上海申腾信息技术有限公司 XML (extensive markup language) parsing method and implementation method of custom XML structural forms in medical records
CN105912723A (en) * 2016-05-09 2016-08-31 统通信(苏州)有限公司 Storage method of custom field

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102346785A (en) * 2011-11-15 2012-02-08 北京创腾科技有限公司 Method and device for directly self-defining field of database
CN102779040A (en) * 2012-06-21 2012-11-14 东莞市微模式软件有限公司 Method and device for generating user-defined form
CN103218707A (en) * 2013-04-10 2013-07-24 沈阳昭软软件有限公司 Method for achieving dynamic form in workflow system
CN103294796A (en) * 2013-05-24 2013-09-11 上海申腾信息技术有限公司 XML (extensive markup language) parsing method and implementation method of custom XML structural forms in medical records
CN105912723A (en) * 2016-05-09 2016-08-31 统通信(苏州)有限公司 Storage method of custom field

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109413030A (en) * 2018-08-31 2019-03-01 湖北海纳天鹰科技发展有限公司 A kind of enviromental protection instrument templating service system construction method and device based on json
CN111259201A (en) * 2018-12-03 2020-06-09 北京嘀嘀无限科技发展有限公司 Data maintenance method and system
CN111259201B (en) * 2018-12-03 2023-08-18 北京嘀嘀无限科技发展有限公司 Data maintenance method and system

Similar Documents

Publication Publication Date Title
US9466138B2 (en) Attribute-based stacking for diagrams
US11204732B2 (en) Historian interface system
CN104699748B (en) It is a kind of to show the method and its system for being not fixed row report
EP2990965A1 (en) Versatile data model
CN103136791B (en) Data correlation method and device thereof for aircraft digital maintenance application
CN105930390A (en) Relation-type database expansion method and relation-type database expansion system
CN107491494A (en) A kind of field storage method and system applied to soil environment monitoring system
CN108073688A (en) A kind of method and device of Data Migration
CN105096369A (en) WEB-based engineering information visualizing system
CN106844669A (en) Big data visual analyzing display frame construction method and visual analyzing display frame
CN107092655A (en) Circularly exhibiting method and system for organizing figure in Android widescreen equipment
CN109766373A (en) Electric network data methods of exhibiting and computer readable storage medium
Babaie-Kafaki et al. Two hybrid nonlinear conjugate gradient methods based on a modified secant equation
US20090164432A1 (en) System and method for generating a product report
CN110175026B (en) Webpage visual editing method, device and storage medium
CN108959356A (en) A kind of intelligence adapted TV university Data application system Data Mart method for building up
CN106802928A (en) Power network historical data management method and its system
EP2037343A1 (en) Production management system, production management method, and storage medium containing production program for executing the production management method
CN103809915B (en) The reading/writing method of a kind of disk file and device
JP6540116B2 (en) Electronic whiteboard system, electronic whiteboard search result display method and program thereof
CN103544338A (en) Method for technique information modeling for issuing three-dimensional assembling instruction
CN111026916A (en) Text description conversion method and device, electronic equipment and storage medium
CN106354846A (en) Intelligent news manuscript selection method and system based on big data
CN104866508B (en) The method and apparatus of file is managed under cloud environment
CN113190718A (en) Data processing method and device for graph database, electronic equipment and storage medium

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
RJ01 Rejection of invention patent application after publication
RJ01 Rejection of invention patent application after publication

Application publication date: 20171219