CN111782703A - Method and system for automatically managing and displaying incidence relation between irrigation area object data - Google Patents
Method and system for automatically managing and displaying incidence relation between irrigation area object data Download PDFInfo
- Publication number
- CN111782703A CN111782703A CN202010654175.XA CN202010654175A CN111782703A CN 111782703 A CN111782703 A CN 111782703A CN 202010654175 A CN202010654175 A CN 202010654175A CN 111782703 A CN111782703 A CN 111782703A
- Authority
- CN
- China
- Prior art keywords
- data
- query
- service
- metadata
- displaying
- 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.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 50
- 238000003973 irrigation Methods 0.000 title claims abstract description 45
- 230000002262 irrigation Effects 0.000 title claims abstract description 45
- 238000007792 addition Methods 0.000 claims abstract description 3
- 238000012217 deletion Methods 0.000 claims abstract description 3
- 230000037430 deletion Effects 0.000 claims abstract description 3
- 238000012986 modification Methods 0.000 claims abstract description 3
- 230000004048 modification Effects 0.000 claims abstract description 3
- 230000008569 process Effects 0.000 claims description 10
- 238000007726 management method Methods 0.000 claims description 5
- 238000013523 data management Methods 0.000 claims description 4
- 238000011161 development Methods 0.000 abstract description 3
- 230000000875 corresponding effect Effects 0.000 description 19
- 238000010586 diagram Methods 0.000 description 8
- 230000006870 function Effects 0.000 description 3
- 238000012423 maintenance Methods 0.000 description 3
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000004590 computer program Methods 0.000 description 1
- 230000002596 correlated effect Effects 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 239000000284 extract Substances 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 238000012544 monitoring process Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000005457 optimization Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- XLYOFNOQVPJJNP-UHFFFAOYSA-N water Substances O XLYOFNOQVPJJNP-UHFFFAOYSA-N 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2457—Query processing with adaptation to user needs
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to a method for automatically managing and displaying incidence relation between irrigation area object data, which comprises the following steps: initializing metadata of a service table metadata table and field metadata of a service field metadata table in an irrigation area system database; at a service system server, establishing an addition, deletion and modification operation of an interceptor on service data for automatically intercepting the service data, dynamically maintaining the association relationship of each item of data in an irrigation area, and recording the association relationship to a data association relationship table in a database; calling a public query interface to query target data of a database, and extracting data object data according to a service table metadata table and a data service table to a front-end detail page for display; and inquiring data associated with the currently displayed object in the data association relation table according to the currently displayed object, and extracting the association relation data to display on a front-end association relation page. The method has the advantages of greatly saving code amount, improving development efficiency and saving cost.
Description
Technical Field
The invention belongs to the field of irrigation district management systems, and particularly relates to a method and a system for automatically managing and displaying an association relation of an irrigation district object data piece.
Background
In the software development process, the method for solving the association information among various types of object data is generally realized by carrying out personalized coding on the known relationship. The common method is to build tables in a database, associate the tables in a main foreign key mode, encode the tables according to the association relationship, and perform personalized display in a front-end function page. In a software project, personalized coding is needed for displaying the relationship between any objects. In a water conservancy industry system software project, a large number of data objects such as reservoirs, irrigation areas, channels, canal heads, gates, monitoring stations and the like exist, the objects are classified in a large number, the objects are correlated with one another, the relationship is disordered, a large number of personalized codes are required to be written and much time and labor are required to justify and correctly display the correlation between the objects, and the realized functions are not flexible enough and difficult to expand. Therefore, the method for realizing the automatic management and display of the incidence relation among the object data has great significance for the optimization and improvement of the irrigation area system.
Disclosure of Invention
Aiming at the technical problems, the invention adopts a method for automatically managing and displaying the incidence relation between the irrigation area object data, and has the advantages of greatly saving the code amount, improving the development efficiency and saving the cost.
In order to achieve the purpose, the technical scheme adopted by the invention is a method for automatically managing and displaying the incidence relation between irrigation area object data, which comprises the following steps
Initializing metadata of a service table metadata table and field metadata of a service field metadata table in an irrigation area system database;
at a service system server, establishing an addition, deletion and modification operation of an interceptor on service data for automatically intercepting the service data, dynamically maintaining the association relationship of each item of data in an irrigation area, and recording the association relationship to a data association relationship table in a database;
calling a public query interface to query target data of a database, and extracting data object data according to a service table metadata table and a data service table to a front-end detail page for display; and inquiring data associated with the currently displayed object in the data association relation table according to the currently displayed object, and extracting the association relation data to display on a front-end association relation page.
Further, the creating interceptor automatically intercepts the operations of adding, deleting and modifying the business data, dynamically maintains the association relationship of the data, and records the association relationship to the data association relationship table in the database, and specifically includes the following steps:
the interceptor intercepts the operations of adding, modifying and deleting the service data to obtain a data object;
according to the table name corresponding to the data object, searching metadata information corresponding to the field;
finding a field with a field is _ fk value of '1' in the service field metadata table, and taking out the attribute value corresponding to the data object to obtain associated data uuid;
storing the data object uuid and the associated data uuid into a data association relation table of the data object;
when the operation is stored, the operation of deleting and inserting is executed.
Further, the method for querying database data by calling the public query interface includes:
the incidence relation query method comprises the following steps: searching a relevant data set according to the data object uuid;
the metadata query method comprises the following steps: according to the table name query data table and the field metadata, executing database query;
the data detail query method comprises the following steps: and executing database query according to the query service data.
In an improved technical scheme, the front-end detail page displays the query field names, the corresponding data details and the associated data by calling a server-end query interface according to the transmitted uuid to perform query and dynamically returning the data.
Further, the front-end detail page query process and result display include:
inquiring the table name of the data according to the uuid;
according to the table name, inquiring the table and the field metadata;
querying data details according to uuid and table name;
inquiring the upward related data, the downward related data uuid and the table name of the data according to the uuid;
inquiring the details of the associated data, a corresponding table and field metadata according to the uuid of the associated data and the name of the data table;
the data return front-end data detail page displays data names and corresponding contents according to metadata;
and displaying the upward correlation data and the downward correlation data according to the correlation relationship, and displaying the correlation data relationship through a table or a graph.
In another improved technical solution, the front-end association relation page display process includes:
displaying the central data of the page as current data, and displaying the upper and lower association relation of the associated data through the arrow direction; clicking the intermediate data, and displaying the details;
the data pointed by the arrow from the current data is downward associated data, the associated data types and the number of the associated types are displayed, the associated data types are clicked, and specific associated data are displayed in an expanded mode;
clicking specific associated data and displaying the details of the data;
the arrow points to the current data to be upward associated data;
and switching the central data, clicking the associated data after checking, selecting the associated data as the central data, and graphically displaying the associated data.
On the other hand, the invention also discloses a system for automatically managing and displaying the incidence relation between the irrigation area object data, which comprises
The system comprises a database module, a data management module and a data management module, wherein the database module is configured to support database tables of various items of data of an irrigation area system, and each database table comprises a data association relation table, a service table source data table, a service field metadata table and a data service table;
the interceptor module is used for automatically intercepting the operation of adding, deleting and modifying the business data by the business data, dynamically maintaining the incidence relation of each item of data in the irrigation area and recording the incidence relation to a data incidence relation table in the database module;
the public query interface module is used for providing query entries for the data association relation table, the service table source data table, the service field metadata table and the data service table;
and the display module is used for displaying an object detail page and an association relation page according to the front-end display interface of each object data and the association relation of the object data in the irrigation area.
Further, the interceptor module comprises
The acquisition unit is used for intercepting the operations of adding, modifying and deleting various data of the irrigation area to acquire a data object;
the searching unit is used for searching the metadata information corresponding to the field according to the table name corresponding to the data object;
the association unit is used for finding a field with a field is _ fk value of '1' in the service field metadata table, and taking out the attribute value corresponding to the data object to obtain association data uuid;
and the storage unit is used for storing the data object uuid and the associated data uuid into the object data association relation table, and during storage, the operation of deleting and inserting is executed.
Further, the common query interface module comprises
The incidence relation query unit is used for searching the incidence data set according to the data object uuid;
the metadata query unit is used for querying the data table according to the table name and executing database query according to the field metadata;
and the data detail query unit is used for executing database query according to the query service data.
The invention relates to a method for automatically managing and displaying the incidence relation between object data of an irrigation area, which automatically intercepts the operation of increasing, deleting and modifying business data by adding a java interceptor and realizes the instant dynamic maintenance of the incidence relation between the data. The method also realizes the automatic management and display of the incidence relation among the object data by calling the common query interface to query the data of the data incidence relation table, the service metadata table and the like in a plurality of ways such as incidence relation, metadata and the like, and can clearly display the specified object and the incidence relation among the objects associated with the specified object even when the number of the associated objects is large, thereby improving the development efficiency; the specified object can be conveniently checked in multiple dimensions by the user through the detail page and the associated data graph display, and the data display efficiency is further improved.
Drawings
In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the drawings needed to be used in the description of the embodiments will be briefly introduced below, and it is apparent that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art that other drawings can be obtained based on these drawings without inventive efforts.
FIG. 1 is a schematic diagram of a method for automatically managing and displaying an association relationship between irrigation area object data;
FIG. 2 is a schematic flow chart of data relationship maintenance performed by an interceptor;
FIG. 3 is a flow chart of a method for automatically managing and displaying the association relationship between the irrigation area object data;
FIG. 4 is a schematic flow chart of a front end detail page presentation query;
FIG. 5 is a schematic diagram of an embodiment of a front end detail page presentation;
FIG. 6 is a diagram illustrating a conventional incidence relation list;
FIG. 7 is a schematic diagram of an embodiment of a front-end association data page display;
FIG. 8 is an overall framework diagram of a system for automatically managing and displaying the association relationship between irrigation area object data;
fig. 9 is a system structure diagram for automatically managing and displaying the association relationship between the irrigation area object data.
Detailed Description
In order to make the purpose, technical solution and beneficial effects of the present application more clear and more obvious, the present application is further described in detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the present application and are not intended to limit the present application.
The following describes an embodiment of a method for automatically managing and displaying an association relationship between irrigation area object data according to the present invention with reference to the accompanying drawings. The method comprises two aspects of maintaining the data relationship and displaying the data relationship, as shown in fig. 1, and specifically comprises the following steps:
100. and initializing the metadata of a service table metadata table and the field metadata of a service field metadata table in the irrigated area system database.
The irrigation area system database in the embodiment includes a data association relation table, a service table metadata table, a service field metadata table and a data service table; the design for each table is shown in tables 1-4 below.
TABLE 1 data Association Table
Table 2 service table metadata table
Table 3 service field metadata table
200. And at the service system server side, creating the operation of adding, deleting and modifying the service data automatically intercepted by the java interceptor, dynamically maintaining the association relationship of each item of data in the irrigation area, and recording the association relationship to a data association relationship table in the database.
In the step, a java interceptor is added in a server-side program to intercept the operations of adding, modifying and deleting data by a java side, and the data maintenance of the object data association relation is executed. As shown in fig. 2, the interceptor process includes the following steps:
201. the interceptor intercepts the operations of adding, modifying and deleting the service data to obtain a data object;
202. according to the table name corresponding to the data object, searching metadata information corresponding to the field;
203. finding a field with a field is _ fk value of '1' in the service field metadata table, and taking out the attribute value corresponding to the data object to obtain associated data uuid;
204. storing the data object uuid and the associated data uuid into a data association relation table of the data object; when the operation is stored, the operation of deleting and inserting is executed.
300. Calling a public query interface to query target data of a database, and extracting data object data according to a service table metadata table and a data service table to a front-end detail page for display; and inquiring data associated with the currently displayed object in the data association relation table according to the currently displayed object, and extracting the association relation data to display on a front-end association relation page.
It should be noted that, in step 300, the front-end detail page and the front-end association relation page are switched through data objects, so that the associated data can be viewed, and the diversity of data display is realized, so that the data can be viewed in a better combination.
Fig. 3 shows a data flow and operational flow diagram for the above method. The associated data is usually data with flowing directionality, wherein black arrows represent data flow direction, gray represents operation, for example, when data query is performed through a public query interface, the server extracts data from the database, data object data flow direction shows a front-end detail page, and associated relation data flow shows a front-end associated relation page; and the display page is switched between the front-end detail page and the front-end association relation page through operation.
In other examples, the common query interface supports a plurality of query modes including data details, association relations, metadata, and the like to satisfy query presentation requirements of all the data details and association relations, as follows:
specifically, the method for querying database data by calling a public query interface includes:
the incidence relation query method comprises the following steps: searching a relevant data set according to the data object uuid; example codes are as follows:
the metadata query method comprises the following steps: according to the table name query data table and the field metadata, executing database query; example codes are as follows:
the data detail query method comprises the following steps: executing database query according to the query service data; example codes are as follows:
302. and the front-end detail page displays the query field name, the corresponding data detail and the associated data according to the transmitted uuid calling the query interface of the server end to query and dynamically returning the data.
The detail page is a public component, and the field name and the corresponding content of the detail page are dynamically displayed according to the data uuid; as shown in fig. 4, the front-end detail page query process and result display include:
inquiring the table name of the data according to the uuid;
according to the table name, inquiring the table and the field metadata;
querying data details according to uuid and table name;
inquiring the upward related data, the downward related data uuid and the table name of the data according to the uuid;
inquiring the details of the associated data, a corresponding table and field metadata according to the uuid of the associated data and the name of the data table;
the data return front-end data detail page displays data names and corresponding contents according to metadata;
and displaying the upward correlation data and the downward correlation data according to the correlation relationship, and displaying the correlation data relationship through a table or a graph.
In one example, a prototype is shown in fig. 5 according to the details of the irrigation area data, the correspondence table and the metadata information of the field. In FIG. 5, the field names are taken from the data table and field metadata names.
FIG. 6 illustrates a conventional incidence relation list that does not allow intuitive multi-dimensional data presentation; FIG. 7 is a diagram showing the image display of the association data of the irrigation area, and the front-end association relation page display process includes:
displaying the central data of the page as current data, and displaying the upper and lower association relation of the associated data through the arrow direction; clicking on the intermediate data displays the details.
The data pointed by the arrow from the current data is downward associated data, the associated data types and the number of the associated types are displayed, the associated data types are clicked, and specific associated data are displayed in an expanded mode; such as the gate clicking gate in the figure, the specific associated data under the gate classification is expanded.
And clicking specific associated data to display the details of the data.
The arrow points to the current data to be upward associated data; such as the ship-driving irrigation area management treatment in the figure.
And switching the central data, clicking the associated data after checking, selecting the associated data as the central data, and graphically displaying the associated data.
On the other hand, the invention also provides an implementation mode of the system for automatically managing and displaying the incidence relation between the irrigation area object data, and as shown in fig. 8, the overall framework of the system comprises a data layer, a service layer and a display layer. In the system functional architecture, as shown in fig. 9, the system correspondingly includes a database module, an interceptor module, a public query interface module, and a presentation module.
The database module is configured to support database tables of various items of data of the irrigation area system, and the database tables comprise a data association relation table, a service table source data table, a service field metadata table and a data service table;
the interceptor module is used for automatically intercepting the operation of adding, deleting and modifying the business data by the business data, dynamically maintaining the incidence relation of each item of data in the irrigation area and recording the incidence relation to a data incidence relation table in the database module;
the public query interface module provides query entries for the data association relation table, the service table source data table, the service field metadata table and the data service table;
the display module is used for displaying an object detail page and an association relation page according to a front-end display interface of each object data and the association relation of the object data in the irrigation area.
Wherein the interceptor module comprises
The acquisition unit is used for intercepting the operations of adding, modifying and deleting various data of the irrigation area to acquire a data object;
the searching unit is used for searching the metadata information corresponding to the field according to the table name corresponding to the data object;
the association unit is used for finding a field with a field is _ fk value of '1' in the service field metadata table, and taking out the attribute value corresponding to the data object to obtain association data uuid;
and the storage unit is used for storing the data object uuid and the associated data uuid into the object data association relation table, and during storage, the operation of deleting and inserting is executed.
The common query interface module comprises
The incidence relation query unit is used for searching the incidence data set according to the data object uuid;
the metadata query unit is used for querying the data table according to the table name and executing database query according to the field metadata;
and the data detail query unit is used for executing database query according to the query service data.
The system for automatically managing and displaying the incidence relation between the slow irrigation zone object data provided by the embodiment of the invention can realize the method embodiment provided above, and for the specific function realization, reference is made to the description in the method embodiment, and no further description is given here.
It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by a computer program, which can be stored in a computer-readable storage medium, and when executed, can include the processes of the embodiments of the methods described above. The storage medium may be a magnetic disk, an optical disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), or the like.
The above description is only for the specific embodiment of the present invention, but the scope of the present invention is not limited thereto, and any changes or substitutions that can be easily conceived by those skilled in the art within the technical scope of the present invention are included in the scope of the present invention. Therefore, the protection scope of the present invention shall be subject to the protection scope of the claims.
Claims (9)
1. A method for automatically managing and displaying the association relationship between object data in irrigation areas is characterized by comprising
Initializing metadata of a service table metadata table and field metadata of a service field metadata table in an irrigation area system database;
at a service system server, establishing an addition, deletion and modification operation of an interceptor on service data for automatically intercepting the service data, dynamically maintaining the association relationship of each item of data in an irrigation area, and recording the association relationship to a data association relationship table in a database;
calling a public query interface to query target data of a database, and extracting data object data according to a service table metadata table and a data service table to a front-end detail page for display; and inquiring data associated with the currently displayed object in the data association relation table according to the currently displayed object, and extracting the association relation data to display on a front-end association relation page.
2. The method according to claim 1, wherein the creating interceptor automatically intercepts business data for operations of adding, deleting and modifying, dynamically maintains the association relationship of the data, and records the association relationship to a data association relationship table in a database, and the method specifically comprises the following steps:
the interceptor intercepts the operations of adding, modifying and deleting the service data to obtain a data object;
according to the table name corresponding to the data object, searching metadata information corresponding to the field;
finding a field with a field is _ fk value of '1' in the service field metadata table, and taking out the attribute value corresponding to the data object to obtain associated data uuid;
storing the data object uuid and the associated data uuid into a data association relation table of the data object;
when the operation is stored, the operation of deleting and inserting is executed.
3. The method for automatically managing and displaying the incidence relation of the irrigated area object data element according to claim 1, wherein the method for calling the public query interface to query the database data comprises the following steps:
the incidence relation query method comprises the following steps: searching a relevant data set according to the data object uuid;
the metadata query method comprises the following steps: according to the table name query data table and the field metadata, executing database query;
the data detail query method comprises the following steps: and executing database query according to the query service data.
4. The method for automatically managing and displaying the association relationship of the data pieces of the irrigation area object as claimed in claim 1, wherein the front-end detail page displays the query field name, the corresponding data details and the associated data by calling a server-end query interface according to the incoming uuid to query and dynamically returning the data.
5. The method for automatically managing and displaying the incidence relation of the irrigated area object data element as claimed in claim 4, wherein the front end detail page query process and result display comprises:
inquiring the table name of the data according to the uuid;
according to the table name, inquiring the table and the field metadata;
querying data details according to uuid and table name;
inquiring the upward related data, the downward related data uuid and the table name of the data according to the uuid;
inquiring the details of the associated data, a corresponding table and field metadata according to the uuid of the associated data and the name of the data table;
the data return front-end data detail page displays data names and corresponding contents according to metadata;
and displaying the upward correlation data and the downward correlation data according to the correlation relationship, and displaying the correlation data relationship through a table or a graph.
6. The method for automatically managing and displaying the incidence relation of the irrigated area object data element as claimed in claim 1, wherein the front-end incidence relation page display process comprises:
displaying the central data of the page as current data, and displaying the upper and lower association relation of the associated data through the arrow direction; clicking the intermediate data, and displaying the details;
the data pointed by the arrow from the current data is downward associated data, the associated data types and the number of the associated types are displayed, the associated data types are clicked, and specific associated data are displayed in an expanded mode;
clicking specific associated data and displaying the details of the data;
the arrow points to the current data to be upward associated data;
and switching the central data, clicking the associated data after checking, selecting the associated data as the central data, and graphically displaying the associated data.
7. A system for automatically managing and displaying incidence relation between object data of irrigation district is characterized in that the system comprises
The system comprises a database module, a data management module and a data management module, wherein the database module is configured to support database tables of various items of data of an irrigation area system, and each database table comprises a data association relation table, a service table source data table, a service field metadata table and a data service table;
the interceptor module is used for automatically intercepting the operation of adding, deleting and modifying the business data by the business data, dynamically maintaining the incidence relation of each item of data in the irrigation area and recording the incidence relation to a data incidence relation table in the database module;
the public query interface module is used for providing query entries for the data association relation table, the service table source data table, the service field metadata table and the data service table;
and the display module is used for displaying an object detail page and an association relation page according to the front-end display interface of each object data and the association relation of the object data in the irrigation area.
8. The system for automated management and presentation of associations between irrigated area object data as claimed in claim 7, wherein said interceptor module comprises
The acquisition unit is used for intercepting the operations of adding, modifying and deleting various data of the irrigation area to acquire a data object;
the searching unit is used for searching the metadata information corresponding to the field according to the table name corresponding to the data object;
the association unit is used for finding a field with a field is _ fk value of '1' in the service field metadata table, and taking out the attribute value corresponding to the data object to obtain association data uuid;
and the storage unit is used for storing the data object uuid and the associated data uuid into the object data association relation table, and during storage, the operation of deleting and inserting is executed.
9. The system for automatically managing and displaying relationships between data of irrigation areas object as claimed in claim 7, wherein said common query interface module includes
The incidence relation query unit is used for searching the incidence data set according to the data object uuid;
the metadata query unit is used for querying the data table according to the table name and executing database query according to the field metadata;
and the data detail query unit is used for executing database query according to the query service data.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010654175.XA CN111782703B (en) | 2020-07-07 | 2020-07-07 | Method and system for automatically managing and displaying association relation between irrigation area object data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010654175.XA CN111782703B (en) | 2020-07-07 | 2020-07-07 | Method and system for automatically managing and displaying association relation between irrigation area object data |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111782703A true CN111782703A (en) | 2020-10-16 |
| CN111782703B CN111782703B (en) | 2024-02-27 |
Family
ID=72758516
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010654175.XA Active CN111782703B (en) | 2020-07-07 | 2020-07-07 | Method and system for automatically managing and displaying association relation between irrigation area object data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111782703B (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112364096A (en) * | 2021-01-13 | 2021-02-12 | 天云融创数据科技（北京）有限公司 | High-dimensional metadata management system and method based on complex network |
| CN113626505A (en) * | 2021-08-02 | 2021-11-09 | 浪潮软件股份有限公司 | Query display method and system for relational database |
| CN115983616A (en) * | 2023-03-21 | 2023-04-18 | 济南丽阳神州智能科技有限公司 | Business process mining method and device based on management system |
| CN116303458A (en) * | 2023-03-17 | 2023-06-23 | 北京信源电子信息技术有限公司 | Management method for data objects in handle system |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040177093A1 (en) * | 2003-03-06 | 2004-09-09 | Ward Mullins | Displayable presentation page and SQL searchable relational data source implementation of a system, method and software for creating or maintaining distributed transparent persistence of complex data objects and their data relationships |
| US20050222931A1 (en) * | 2003-08-27 | 2005-10-06 | Ascential Software Corporation | Real time data integration services for financial information data integration |
| US20070118648A1 (en) * | 2005-10-28 | 2007-05-24 | Accenture S.P.A. | Service broker integration layer for supporting telecommunication client service requests |
| US20110320432A1 (en) * | 2010-06-29 | 2011-12-29 | International Business Machines Corporation | Managing Parameters in Filter Expressions |
| CN106874388A (en) * | 2017-01-11 | 2017-06-20 | 中科院微电子研究所昆山分所 | A kind of heterogeneous system data cascade operation method for auto constructing based on relevant database |
| US20180137184A1 (en) * | 2016-11-15 | 2018-05-17 | Spirent Communications, Inc. | Sql interceptor for use with third party data analytics packages |
| CN110399423A (en) * | 2019-07-24 | 2019-11-01 | 北京明略软件系统有限公司 | Processing method and processing device, storage medium and the electronic device of metadata genetic connection |
| CN110609737A (en) * | 2019-08-14 | 2019-12-24 | 平安科技（深圳）有限公司 | Associated data query method and device, computer equipment and storage medium |
-
2020
- 2020-07-07 CN CN202010654175.XA patent/CN111782703B/en active Active
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040177093A1 (en) * | 2003-03-06 | 2004-09-09 | Ward Mullins | Displayable presentation page and SQL searchable relational data source implementation of a system, method and software for creating or maintaining distributed transparent persistence of complex data objects and their data relationships |
| US20050222931A1 (en) * | 2003-08-27 | 2005-10-06 | Ascential Software Corporation | Real time data integration services for financial information data integration |
| US20070118648A1 (en) * | 2005-10-28 | 2007-05-24 | Accenture S.P.A. | Service broker integration layer for supporting telecommunication client service requests |
| US20110320432A1 (en) * | 2010-06-29 | 2011-12-29 | International Business Machines Corporation | Managing Parameters in Filter Expressions |
| US20180137184A1 (en) * | 2016-11-15 | 2018-05-17 | Spirent Communications, Inc. | Sql interceptor for use with third party data analytics packages |
| CN106874388A (en) * | 2017-01-11 | 2017-06-20 | 中科院微电子研究所昆山分所 | A kind of heterogeneous system data cascade operation method for auto constructing based on relevant database |
| CN110399423A (en) * | 2019-07-24 | 2019-11-01 | 北京明略软件系统有限公司 | Processing method and processing device, storage medium and the electronic device of metadata genetic connection |
| CN110609737A (en) * | 2019-08-14 | 2019-12-24 | 平安科技（深圳）有限公司 | Associated data query method and device, computer equipment and storage medium |
Non-Patent Citations (2)
| Title |
|---|
| 史湘琨;刘子亭;: "基于WebOS技术的灌区信息管理系统开发应用", 中国农村水利水电, no. 09 * |
| 范会联;: "基于JSF与EJB3的Web信息系统设计", 计算机系统应用, no. 01 * |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112364096A (en) * | 2021-01-13 | 2021-02-12 | 天云融创数据科技（北京）有限公司 | High-dimensional metadata management system and method based on complex network |
| CN112364096B (en) * | 2021-01-13 | 2021-07-06 | 天云融创数据科技（北京）有限公司 | High-dimensional metadata management system and method based on complex network |
| CN113626505A (en) * | 2021-08-02 | 2021-11-09 | 浪潮软件股份有限公司 | Query display method and system for relational database |
| CN116303458A (en) * | 2023-03-17 | 2023-06-23 | 北京信源电子信息技术有限公司 | Management method for data objects in handle system |
| CN116303458B (en) * | 2023-03-17 | 2023-10-13 | 北京信源电子信息技术有限公司 | Management method for data objects in handle system |
| CN115983616A (en) * | 2023-03-21 | 2023-04-18 | 济南丽阳神州智能科技有限公司 | Business process mining method and device based on management system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111782703B (en) | 2024-02-27 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111782703A (en) | Method and system for automatically managing and displaying incidence relation between irrigation area object data | |
| CN107247808B (en) | Distributed NewSQL database system and picture data query method | |
| JP5008878B2 (en) | Mapping file system models to database objects | |
| CN102541529B (en) | A kind of query page generating device and method | |
| CN102270225B (en) | Data change daily record method for supervising and data change daily record supervising device | |
| CN101510209B (en) | Method, system and server for implementing real time search | |
| CN106407360B (en) | Data processing method and device | |
| CN111506559A (en) | Data storage method and device, electronic equipment and storage medium | |
| CN110134681B (en) | Data storage and query method and device, computer equipment and storage medium | |
| CN111506621A (en) | Data statistical method and device | |
| CN103455335A (en) | Multilevel classification Web implementation method | |
| CN110851663B (en) | Method and device for managing metadata | |
| CN104462161A (en) | Structural data query method based on distributed database | |
| CN102779138A (en) | Hard disk access method of real time data | |
| CN111382155A (en) | Data processing method of data warehouse, electronic equipment and medium | |
| CN111026756A (en) | Method for dynamically generating form and associated query | |
| CN105354283A (en) | Resource searching method and apparatus | |
| CN101710322A (en) | Method and system for associating information | |
| CN111241065A (en) | Security multi-compatibility lightweight database adaptation development and operation device supporting domestic database | |
| CN102799423A (en) | Method and device for implementing dynamic method in JSF (java service face) | |
| CN109697234B (en) | Multi-attribute information query method, device, server and medium for entity | |
| CN114840608B (en) | Distributed data access method, device and storage medium | |
| CN116049193A (en) | Data storage method and device | |
| CN102546961A (en) | Contact lookup method and mobile terminal | |
| CN116414854A (en) | Data asset query method, device, computer 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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |