CN111177120A - Data management method and device - Google Patents
Data management method and device Download PDFInfo
- Publication number
- CN111177120A CN111177120A CN201911346509.0A CN201911346509A CN111177120A CN 111177120 A CN111177120 A CN 111177120A CN 201911346509 A CN201911346509 A CN 201911346509A CN 111177120 A CN111177120 A CN 111177120A
- Authority
- CN
- China
- Prior art keywords
- data
- node
- target
- user
- target node
- 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
- 238000000034 method Methods 0.000 title claims abstract description 40
- 238000013523 data management Methods 0.000 title claims abstract description 35
- 238000012216 screening Methods 0.000 claims description 30
- 238000004590 computer program Methods 0.000 claims description 9
- 238000012800 visualization Methods 0.000 abstract description 5
- 238000007726 management method Methods 0.000 abstract description 4
- 230000002285 radioactive effect Effects 0.000 abstract description 2
- 239000000820 nonprescription drug Substances 0.000 description 8
- 239000003814 drug Substances 0.000 description 5
- 230000008569 process Effects 0.000 description 5
- 229940079593 drug Drugs 0.000 description 4
- 230000009471 action Effects 0.000 description 3
- 239000000955 prescription drug Substances 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 238000001647 drug administration Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000013439 planning Methods 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/21—Design, administration or maintenance of 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/242—Query formulation
- G06F16/2433—Query languages
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Mathematical Physics (AREA)
- Computational Linguistics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present disclosure provides a data management method and apparatus, the data management method including: when a selection instruction of a user for a target node is received, acquiring first data corresponding to the target node; when an instruction of a user for inserting a target child node into a target node is received, connecting the target node with the target child node; and acquiring second data corresponding to the target child node according to the connection attribute set by the user. When the data asset visualization is carried out, different tree-shaped catalogues can be generated and displayed corresponding to different themes, so that the visualization of data asset management is realized, and the classification of the data assets can be flexibly customized. Meanwhile, the method can fully integrate the imagination of human into the human, visualize the data assets in a radioactive thinking mode and display the data assets in a graphic mode.
Description
Technical Field
The present disclosure relates to the field of computer technologies, and in particular, to a data management method and apparatus.
Background
Currently, most enterprises and public institutions have established relatively sophisticated basic informatization systems such as CRM (Customer relationship management), ERP (Enterprise Resource planning system), OA (Office Automation or automated Office), and the like. These systems generally: and finally, adding, modifying, deleting and the like are carried out on the database through the operation of business personnel or users. But most of the visualization of the data assets is displayed in a data asset directory mode.
In the prior art, a bar frame is preset in the method for displaying the data assets in a directory mode, so that the thinking mode of a user is solidified, and a view without predefinition cannot be displayed.
Disclosure of Invention
To solve or at least alleviate at least one of the above technical problems, the present disclosure provides a data management method and apparatus.
In a first aspect, the present disclosure provides a data management method, including:
when a selection instruction of a user for a target node is received, acquiring first data corresponding to the target node;
when an instruction of a user for inserting a target child node into a target node is received, connecting the target node with the target child node;
and acquiring second data corresponding to the target child node according to the connection attribute set by the user.
Optionally, the obtaining of the first data corresponding to the target node includes:
constructing a Structured Query Language (SQL) statement to perform data screening to obtain first data from a pre-established database;
the acquiring second data corresponding to the target child node according to the connection attribute set by the user includes:
and constructing an SQL statement to perform data screening according to the connection attribute set by the user to obtain second data from the first data.
Optionally, the obtaining of the first data corresponding to the target node includes:
constructing a Structured Query Language (SQL) statement to perform data screening to acquire first data from node data corresponding to a previous node leading out the target node;
the acquiring second data corresponding to the target child node according to the connection attribute set by the user includes:
and constructing an SQL statement to perform data screening according to the connection attribute set by the user to obtain second data from the first data.
Optionally, the data management method further includes:
when a selection instruction of a user for a target node is received, displaying the target node;
when an instruction of inserting a target child node into a target node by a user is received, the target child node and the connection between the target node and the target child node are displayed.
In a second aspect, the present disclosure provides a data management apparatus comprising: a first acquisition module, a node connection module, and a second acquisition module, wherein,
the first acquisition module is used for acquiring first data corresponding to a target node when a selection instruction of a user on the target node is received;
the node connection module is used for connecting the target node with the target child node when receiving an instruction of inserting the target child node into the target node from a user;
and the second acquisition module is used for acquiring second data corresponding to the target child node according to the connection attribute set by the user.
Optionally, the first obtaining module is specifically configured to construct a structured query language SQL statement to perform data screening, and obtain first data from a pre-established database;
the second obtaining module is specifically configured to construct an SQL statement to perform data screening according to the connection attribute set by the user, so as to obtain second data from the first data.
Optionally, the first obtaining module is specifically configured to construct a structured query language SQL statement to perform data screening, and obtain first data from node data corresponding to a previous node from which the target node is derived;
the second obtaining module is specifically configured to construct an SQL statement to perform data screening according to the connection attribute set by the user, so as to obtain second data from the first data.
Optionally, the data management apparatus further includes: a first display module and a second display module, wherein,
the first display module is used for displaying the target node when a selection instruction of a user on the target node is received;
and the second display module is used for displaying the target child node and the connection between the target node and the target child node when receiving an instruction of inserting the target child node into the target node from a user.
In a third aspect, the present disclosure provides a computer-readable storage medium storing a computer program which, when executed by a processor, implements the data management method of any one of the first aspects.
In a fourth aspect, the present disclosure provides a computing device comprising a memory storing a computer program and a processor implementing the data management method of any one of the first aspects when the processor executes the computer program.
Compared with the prior art, the method has the following beneficial effects:
when the data asset visualization is carried out, different tree-shaped catalogues can be generated and displayed corresponding to different themes, so that the visualization of data asset management is realized, and the classification of the data assets can be flexibly customized. Meanwhile, the method can fully integrate the imagination of human into the human, visualize the data assets in a radioactive thinking mode and display the data assets in a graphic mode.
Drawings
In order to more clearly illustrate the embodiments of the present disclosure or the technical solutions in the prior art, the drawings needed to be used in the description of the embodiments or the prior art will be briefly introduced below, and it is obvious that the drawings in the following description are some embodiments of the present disclosure, and other drawings can be obtained by those skilled in the art without creative efforts.
Fig. 1 is a schematic flow chart of a data management method according to an embodiment of the present disclosure;
FIG. 2 is a data management view of a drug topic provided by an embodiment of the present disclosure;
FIG. 3 is a view of another drug-based data management provided by an embodiment of the present disclosure;
fig. 4 is a block diagram of a data management apparatus according to an embodiment of the present disclosure.
Detailed Description
To make the objects, technical solutions and advantages of the embodiments of the present disclosure more clear, the technical solutions in the embodiments of the present disclosure will be described clearly and completely with reference to the drawings in the embodiments of the present disclosure, and it is obvious that the described embodiments are some embodiments of the present disclosure, rather than all embodiments, and all other embodiments obtained by a person of ordinary skill in the art without creative efforts based on the embodiments of the present disclosure belong to the protection scope of the present disclosure.
As shown in fig. 1, an embodiment of the present disclosure provides a data management method, which may include the following steps:
when a selection instruction of a user for a target node is received, acquiring first data corresponding to the target node;
when an instruction of a user for inserting a target child node into a target node is received, connecting the target node with the target child node;
and acquiring second data corresponding to the target child node according to the connection attribute set by the user.
It is noted that in various embodiments, two nodes may be parents of each other. For example, node a and node B, in one embodiment node a is the target node and node B is the target child node, that is, node B is inserted into node a, node a is the parent node of node B, and node B is the child node of node a; in another embodiment, node B is the target node and node A is the target child node, i.e., node A is inserted at node B, which is the parent node of node A and node A is the child node of node B.
In an embodiment of the present disclosure, the acquiring first data corresponding to the target node includes:
constructing a Structured Query Language (SQL) statement to perform data screening to obtain first data from a pre-established database;
the acquiring second data corresponding to the target child node according to the connection attribute set by the user includes:
and constructing an SQL statement to perform data screening according to the connection attribute set by the user to obtain second data from the first data.
It should be noted that, when the target node of the selected user is used as the start node, the first data corresponding to the node may be obtained from the pre-established database by constructing an SQL statement to perform data screening. The pre-established database may be the entire data collected by the user. And for other inserted non-start nodes, screening and obtaining corresponding data on the basis of the data of the previous node.
In an embodiment of the present disclosure, the acquiring first data corresponding to the target node includes:
constructing a Structured Query Language (SQL) statement to perform data screening to acquire first data from node data corresponding to a previous node leading out the target node;
the acquiring second data corresponding to the target child node according to the connection attribute set by the user includes:
and constructing an SQL statement to perform data screening according to the connection attribute set by the user to obtain second data from the first data.
It should be noted that, when the target node of the selected user is a non-start node, that is, when a new node is inserted based on the previous node, the method for obtaining the first data corresponding to the node is the same as that for other inserted nodes, and the first data is obtained by screening based on the data of the previous node. And other inserted non-start nodes are screened on the basis of the data of the previous node to obtain corresponding data.
In one embodiment of the present disclosure, the data management method further includes:
when a selection instruction of a user for a target node is received, displaying the target node;
when an instruction of inserting a target child node into a target node by a user is received, the target child node and the connection between the target node and the target child node are displayed.
In the embodiment, the operation process, the operation result and the like of the user are visually displayed, so that the operation flow and the difficulty level are simplified, and the operation experience of the user is improved. The user can create different nodes and associated views formed by hierarchically connecting the different nodes according to the requirement of the user.
The method of the present disclosure is described in detail below with reference to fig. 2-3, taking drug administration as an example.
As shown in fig. 2 and 3, both take medicine as the start node, and then select different child nodes for data screening and management. In fig. 2, a drug is taken as an initial node, and then an over-the-counter drug and a prescription drug are inserted into the initial node, where the data corresponding to the over-the-counter drug and the prescription drug are obtained by screening from the data corresponding to the drug, and similarly, the class a over-the-counter drug and the class b over-the-counter drug are sub-nodes of the over-the-counter drug, and the data of the class a over-the-counter drug and the class b over-the-counter drug are obtained by screening from the data of the over-the-counter drug. And direct association of the parent nodes and the child nodes is realized through SQL query statements among the parent nodes and the child nodes, and an association view is displayed. The data in the figures are not explained here one by one because the principle is the same.
As shown in fig. 4, the present disclosure also provides a data management apparatus including: a first acquisition module, a node connection module, and a second acquisition module, wherein,
the first acquisition module is used for acquiring first data corresponding to a target node when a selection instruction of a user on the target node is received;
the node connection module is used for connecting the target node with the target child node when receiving an instruction of inserting the target child node into the target node from a user;
and the second acquisition module is used for acquiring second data corresponding to the target child node according to the connection attribute set by the user.
In an embodiment of the present disclosure, the first obtaining module is specifically configured to construct a structured query language SQL statement to perform data screening, and obtain first data from a pre-established database;
the second obtaining module is specifically configured to construct an SQL statement to perform data screening according to the connection attribute set by the user, so as to obtain second data from the first data.
In an embodiment of the present disclosure, the first obtaining module is specifically configured to construct a structured query language SQL statement to perform data screening, and obtain first data from node data corresponding to a previous node from which the target node is derived;
the second obtaining module is specifically configured to construct an SQL statement to perform data screening according to the connection attribute set by the user, so as to obtain second data from the first data.
In one embodiment of the present disclosure, the data management apparatus further includes: a first display module and a second display module, wherein,
the first display module is used for displaying the target node when a selection instruction of a user on the target node is received;
and the second display module is used for displaying the target child node and the connection between the target node and the target child node when receiving an instruction of inserting the target child node into the target node from a user.
The present disclosure also provides a computer-readable storage medium storing a computer program which, when executed by a processor, implements the data management method of any one of the present disclosure.
The present disclosure also provides a computing device comprising a memory and a processor, the memory storing a computer program, the processor implementing the data management method of any one of the present disclosure when executing the computer program.
For the information interaction, execution process, and other contents between the modules in the apparatus, the specific contents may refer to the description in the embodiment of the method of the present disclosure because the same concept is based on the embodiment of the method of the present disclosure, and are not described herein again.
It is noted that, herein, relational terms such as first and second, and the like may be used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising a" does not exclude the presence of other similar elements in a process, method, article, or apparatus that comprises the element.
Those of ordinary skill in the art will understand that: all or part of the steps for realizing the method embodiments can be completed by hardware related to program instructions, the program can be stored in a computer readable storage medium, and the program executes the steps comprising the method embodiments when executed; and the aforementioned storage medium includes: various media that can store program codes, such as ROM, RAM, magnetic or optical disks.
Finally, it is to be noted that: the above description is only a preferred embodiment of the present disclosure, which is only used to illustrate the technical solutions of the present disclosure, and is not used to limit the protection scope of the present disclosure. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present disclosure are included in the scope of protection of the present disclosure.
Claims (10)
1. A data management method, characterized in that the data management method comprises:
when a selection instruction of a user for a target node is received, acquiring first data corresponding to the target node;
when an instruction of a user for inserting a target child node into a target node is received, connecting the target node with the target child node;
and acquiring second data corresponding to the target child node according to the connection attribute set by the user.
2. The data management method according to claim 1,
the acquiring first data corresponding to the target node includes:
constructing a Structured Query Language (SQL) statement to perform data screening to obtain first data from a pre-established database;
the acquiring second data corresponding to the target child node according to the connection attribute set by the user includes:
and constructing an SQL statement to perform data screening according to the connection attribute set by the user to obtain second data from the first data.
3. The data management method according to claim 1,
the acquiring first data corresponding to the target node includes:
constructing a Structured Query Language (SQL) statement to perform data screening to acquire first data from node data corresponding to a previous node leading out the target node;
the acquiring second data corresponding to the target child node according to the connection attribute set by the user includes:
and constructing an SQL statement to perform data screening according to the connection attribute set by the user to obtain second data from the first data.
4. The data management method of claim 1, further comprising:
when a selection instruction of a user for a target node is received, displaying the target node;
when an instruction of inserting a target child node into a target node by a user is received, the target child node and the connection between the target node and the target child node are displayed.
5. A data management apparatus, characterized in that the data management apparatus comprises: a first acquisition module, a node connection module, and a second acquisition module, wherein,
the first acquisition module is used for acquiring first data corresponding to a target node when a selection instruction of a user on the target node is received;
the node connection module is used for connecting the target node with the target child node when receiving an instruction of inserting the target child node into the target node from a user;
and the second acquisition module is used for acquiring second data corresponding to the target child node according to the connection attribute set by the user.
6. The data management apparatus according to claim 5,
the first acquisition module is specifically used for constructing a Structured Query Language (SQL) statement to perform data screening to acquire first data from a pre-established database;
the second obtaining module is specifically configured to construct an SQL statement to perform data screening according to the connection attribute set by the user, so as to obtain second data from the first data.
7. The data management apparatus according to claim 5,
the first obtaining module is specifically used for constructing a Structured Query Language (SQL) statement to perform data screening to obtain first data from node data corresponding to a previous node leading out the target node;
the second obtaining module is specifically configured to construct an SQL statement to perform data screening according to the connection attribute set by the user, so as to obtain second data from the first data.
8. The data management apparatus according to claim 5, wherein the data management apparatus further comprises: a first display module and a second display module, wherein,
the first display module is used for displaying the target node when a selection instruction of a user on the target node is received;
and the second display module is used for displaying the target child node and the connection between the target node and the target child node when receiving an instruction of inserting the target child node into the target node from a user.
9. A computer-readable storage medium, characterized in that the computer-readable storage medium stores a computer program which, when executed by a processor, implements the data management method of any one of claims 1 to 4.
10. A computing device comprising a memory and a processor, wherein the memory stores a computer program and the processor implements the data management method of any one of claims 1 to 4 when executing the computer program.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911346509.0A CN111177120A (en) | 2019-12-24 | 2019-12-24 | Data management method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911346509.0A CN111177120A (en) | 2019-12-24 | 2019-12-24 | Data management method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111177120A true CN111177120A (en) | 2020-05-19 |
Family
ID=70657411
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911346509.0A Pending CN111177120A (en) | 2019-12-24 | 2019-12-24 | Data management method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111177120A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111818305A (en) * | 2020-07-09 | 2020-10-23 | 杭州海康威视数字技术股份有限公司 | Distributed system, service control method and device |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CA2427700A1 (en) * | 2003-05-01 | 2004-11-01 | Bruno Braen | Visual interface for object-oriented programming |
| US20160063063A1 (en) * | 2014-09-02 | 2016-03-03 | Salesforce.Com, Inc. | Database query system |
| US20180067986A1 (en) * | 2016-09-04 | 2018-03-08 | Eclinicalworks, Llc | Database model with improved storage and search string generation techniques |
| CN109388791A (en) * | 2018-09-28 | 2019-02-26 | 中国平安财产保险股份有限公司 | Chart Dynamic Display method, apparatus, computer equipment and storage medium |
| CN110222319A (en) * | 2019-06-19 | 2019-09-10 | 北京百度网讯科技有限公司 | Method and apparatus for mining data |
-
2019
- 2019-12-24 CN CN201911346509.0A patent/CN111177120A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CA2427700A1 (en) * | 2003-05-01 | 2004-11-01 | Bruno Braen | Visual interface for object-oriented programming |
| US20160063063A1 (en) * | 2014-09-02 | 2016-03-03 | Salesforce.Com, Inc. | Database query system |
| US20180067986A1 (en) * | 2016-09-04 | 2018-03-08 | Eclinicalworks, Llc | Database model with improved storage and search string generation techniques |
| CN109388791A (en) * | 2018-09-28 | 2019-02-26 | 中国平安财产保险股份有限公司 | Chart Dynamic Display method, apparatus, computer equipment and storage medium |
| CN110222319A (en) * | 2019-06-19 | 2019-09-10 | 北京百度网讯科技有限公司 | Method and apparatus for mining data |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111818305A (en) * | 2020-07-09 | 2020-10-23 | 杭州海康威视数字技术股份有限公司 | Distributed system, service control method and device |
| CN111818305B (en) * | 2020-07-09 | 2021-12-10 | 杭州海康威视数字技术股份有限公司 | Distributed system, service control method and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20240078229A1 (en) | Generating, accessing, and displaying lineage metadata | |
| US8756567B2 (en) | Profile based version comparison | |
| KR101644418B1 (en) | Visualizing relationships between data elements and graphical representations of data element attributes | |
| US10185478B2 (en) | Creating a filter for filtering a list of objects | |
| US8341191B2 (en) | Methods and structures for utilizing reusable custom-defined nestable compound data types to permit product variations within an existing taxonomy | |
| US20110154253A1 (en) | Process field extensibility for business objects | |
| US8924848B2 (en) | Synchronizing a user interface area | |
| US8706783B2 (en) | Storing hierarchical table as a markup language file | |
| US8682936B2 (en) | Inherited entity storage model | |
| US20150293947A1 (en) | Validating relationships between entities in a data model | |
| US20130346426A1 (en) | Tracking an ancestry of metadata | |
| US20150058363A1 (en) | Cloud-based enterprise content management system | |
| US8626773B2 (en) | Aligning records for visual comparison | |
| US20150007129A1 (en) | Script execution framework | |
| US9875288B2 (en) | Recursive filter algorithms on hierarchical data models described for the use by the attribute value derivation | |
| CN111930965B (en) | Method and system for constructing ontology structure of knowledge graph | |
| CN111177120A (en) | Data management method and device | |
| US10140385B2 (en) | Configuring a presentation of data based on a context | |
| US11062326B2 (en) | Compliance management techniques | |
| US11734243B2 (en) | Sparse mapping of hierarchical subset | |
| US9183231B2 (en) | Interactive table to present multi-level relationships between data items | |
| US20120310655A1 (en) | Executing a business process in a business reporting manager | |
| Strohmeier et al. | Designing an architecture description language for nontechnical actors and purposes (NOTE-ADL) | |
| US10387835B2 (en) | Visually representing information related to an application | |
| CN113934801A (en) | Data blood relationship processing method and device and electronic equipment |
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 |