CN111782673A - Data processing method and device, computing equipment and medium - Google Patents
Data processing method and device, computing equipment and medium Download PDFInfo
- Publication number
- CN111782673A CN111782673A CN202010671902.3A CN202010671902A CN111782673A CN 111782673 A CN111782673 A CN 111782673A CN 202010671902 A CN202010671902 A CN 202010671902A CN 111782673 A CN111782673 A CN 111782673A
- Authority
- CN
- China
- Prior art keywords
- configuration item
- configuration
- editing
- module
- graph database
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
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/23—Updating
- G06F16/235—Update request formulation
-
- 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/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- 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/90—Details of database functions independent of the retrieved data types
- G06F16/901—Indexing; Data structures therefor; Storage structures
- G06F16/9024—Graphs; Linked lists
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Mathematical Physics (AREA)
- Computing Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present disclosure provides a method of processing data. The method comprises the steps of obtaining a configuration item data set in a relational database, wherein the configuration item data set comprises a plurality of configuration items and relations among the configuration items, and the configuration item data set is used for recording software and/or hardware information of a target system; and receiving an editing instruction aiming at the configuration item or the relationship, and updating data in a graph database according to the editing instruction, wherein the graph database is created based on the configuration item data set, and the graph database is used for representing software and/or hardware information of the target system in a graph mode. The disclosure also provides a data processing device, a computing device and a computer readable storage medium.
Description
Technical Field
The present disclosure relates to the field of computer technologies, and in particular, to a data processing method, apparatus, computing device, and medium.
Background
Current configuration management systems use relational databases (e.g., MySQL databases) to store various software and hardware information. The relational database stores data by a two-dimensional table (hereinafter referred to as a table). In the configuration management system, each piece of software and hardware information is stored in a corresponding table in a relational database, and the interdependent relationship between each piece of configuration item information is stored in an association table in the relational database. For this storage manner, when the configuration management system queries a certain configuration item in the relational database, a large number of cross-table join (join) queries need to be performed, and the query efficiency is low. With the popularization of the automation technology in the operation and maintenance field, the quantity of configuration item information shows exponential level increase, so that the execution efficiency of the query of the configuration management system is lower, and the interaction real-time performance between the configuration management system and the downstream application is lower.
Disclosure of Invention
One aspect of the present disclosure provides a data processing method, including: acquiring a configuration item data set in a relational database, wherein the configuration item data set comprises a plurality of configuration items and relations among the plurality of configuration items, and the configuration item data set is used for recording software and/or hardware information of a target system; and receiving an editing instruction aiming at the configuration item or the relation, and updating data in a graph database according to the editing instruction, wherein the graph database is created based on the configuration item data set and is used for representing software and/or hardware information of the target system in a graph mode.
Optionally, the configuration item comprises at least one parameter; the graph database is created by: generating a node corresponding to each configuration item in the configuration item data set, and configuring the attribute of the node according to the parameter of the configuration item; and configuring the connection relation among the nodes according to the relation among the configuration items.
Optionally, the updating data in the graph database according to the editing instruction includes: acquiring the type of the editing instruction and a configuration item or relationship aimed at by the editing instruction; and editing nodes corresponding to the configuration items or connection relations corresponding to the relations in the graph database according to the type of the editing instruction and the configuration items or relations aimed at by the editing instruction.
Optionally, the method further comprises: generating a visual page according to the graph database; and displaying the visual page.
Another aspect of the present disclosure provides an apparatus for processing data, including: the system comprises a first acquisition module, a second acquisition module and a third acquisition module, wherein the first acquisition module is used for acquiring a configuration item data set in a relational database, and the configuration item data set is used for recording software and/or hardware information of a target system; and the updating module is used for updating data in a graph database according to the editing instruction under the condition that the editing instruction aiming at the configuration item data set occurs, wherein the graph database is created based on the configuration item data set and is used for representing software and/or hardware information of the target system in a graph form.
Optionally, the configuration item dataset comprises a plurality of configuration items, parameters of each of the plurality of configuration items and relationships between the plurality of configuration items; the apparatus further comprises an editing module, the editing module comprising: the first configuration submodule is used for generating a node corresponding to each configuration item in the plurality of configuration items and configuring the attribute of the node according to the parameter of the configuration item; and the second configuration submodule is used for configuring the connection relation among the plurality of nodes according to the relation among the plurality of configuration items.
Optionally, the update module includes: the second obtaining sub-module is used for obtaining the type of the editing instruction and the configuration item data set for which the editing instruction is directed; and the editing submodule is used for editing the nodes corresponding to the configuration item data sets in the graph database according to the type of the editing instruction and the configuration item data sets aimed at by the editing instruction.
Optionally, the apparatus further includes: the generating module is used for generating a visual page according to the graph database; and the display module is used for displaying the visual page.
Another aspect of the disclosure provides a computing device comprising: one or more processors; storage means for storing one or more programs, wherein the one or more programs, when executed by the one or more processors, cause the one or more processors to implement the method as described above.
Another aspect of the present disclosure provides a computer-readable storage medium storing computer-executable instructions for implementing the method as described above when executed.
Another aspect of the disclosure provides a computer program comprising computer executable instructions for implementing the method as described above when executed.
According to the embodiment of the disclosure, in the case of an editing instruction for the configuration item data set, the data in the graph database is updated according to the editing instruction, so that the data editing content made by the editing instruction is synchronously updated to the graph database while the relational database is edited, so that the graph database and the relational database keep data synchronization. When data is inquired subsequently, the inquiry can be carried out through the graph database, and the query performance is better because the graph database does not need cross-table query, so that the problem of lower query efficiency of the relational database is solved.
Drawings
For a more complete understanding of the present disclosure and the advantages thereof, reference is now made to the following descriptions taken in conjunction with the accompanying drawings, in which:
fig. 1 schematically shows a method of processing data and a system architecture of a processing apparatus of data according to an embodiment of the present disclosure;
FIG. 2 schematically shows a flow chart of a method of processing data according to an embodiment of the present disclosure;
FIG. 3 is a diagram schematically illustrating relationships between configuration items;
FIG. 4 schematically shows a flow chart of a method of creating a graph database of data according to an embodiment of the disclosure;
FIG. 5 schematically illustrates a flow diagram for updating data in a graph database according to editing instructions, according to an embodiment of the disclosure;
FIG. 6 schematically shows a flow chart of a method of processing data according to another embodiment of the present disclosure;
FIG. 7 schematically illustrates a schematic view of a visualization page;
FIG. 8 schematically shows a block diagram of a processing device of data according to an embodiment of the present disclosure;
fig. 9 schematically shows a block diagram of a processing device of data according to an embodiment of the present disclosure;
FIG. 10 schematically shows a block diagram of a processing device of data according to an embodiment of the present disclosure; and
FIG. 11 schematically illustrates a block diagram of a computer system suitable for implementing the above-described method according to an embodiment of the present disclosure.
Detailed Description
Hereinafter, embodiments of the present disclosure will be described with reference to the accompanying drawings. It should be understood that the description is illustrative only and is not intended to limit the scope of the present disclosure. In the following detailed description, for purposes of explanation, numerous specific details are set forth in order to provide a thorough understanding of the embodiments of the disclosure. It may be evident, however, that one or more embodiments may be practiced without these specific details. Moreover, in the following description, descriptions of well-known structures and techniques are omitted so as to not unnecessarily obscure the concepts of the present disclosure.
The terminology used herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the disclosure. The terms "comprises," "comprising," and the like, as used herein, specify the presence of stated features, steps, operations, and/or components, but do not preclude the presence or addition of one or more other features, steps, operations, or components.
All terms (including technical and scientific terms) used herein have the same meaning as commonly understood by one of ordinary skill in the art unless otherwise defined. It is noted that the terms used herein should be interpreted as having a meaning that is consistent with the context of this specification and should not be interpreted in an idealized or overly formal sense.
Where a convention analogous to "at least one of A, B and C, etc." is used, in general such a construction is intended in the sense one having skill in the art would understand the convention (e.g., "a system having at least one of A, B and C" would include but not be limited to systems that have a alone, B alone, C alone, a and B together, a and C together, B and C together, and/or A, B, C together, etc.). Where a convention analogous to "A, B or at least one of C, etc." is used, in general such a construction is intended in the sense one having skill in the art would understand the convention (e.g., "a system having at least one of A, B or C" would include but not be limited to systems that have a alone, B alone, C alone, a and B together, a and C together, B and C together, and/or A, B, C together, etc.).
Some block diagrams and/or flow diagrams are shown in the figures. It will be understood that some blocks of the block diagrams and/or flowchart illustrations, or combinations thereof, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, or other programmable data processing apparatus, such that the instructions, which execute via the processor, create means for implementing the functions/acts specified in the block diagrams and/or flowchart block or blocks. The techniques of this disclosure may be implemented in hardware and/or software (including firmware, microcode, etc.). In addition, the techniques of this disclosure may take the form of a computer program product on a computer-readable storage medium having instructions stored thereon for use by or in connection with an instruction execution system.
The embodiment of the disclosure provides a data processing method and a data processing device capable of applying the method. The method comprises the steps of obtaining a configuration item data set in a relational database, wherein the configuration item data set is used for recording software and/or hardware information of a target system; and updating data in a graph database according to the editing instruction in the case of the editing instruction for the configuration item data set, wherein the graph database is created based on the configuration item data set, and the graph database is used for representing software and/or hardware information of the target system in the form of a graph.
Fig. 1 schematically shows a processing method of data and a system architecture of a processing apparatus of data according to an embodiment of the present disclosure. It should be noted that fig. 1 is only an example of a scenario in which the embodiments of the present disclosure may be applied to help those skilled in the art understand the technical content of the present disclosure, but does not mean that the embodiments of the present disclosure may not be applied to other devices, systems, environments or scenarios.
As shown in FIG. 1, system architecture 100 includes a configuration management system 110 and a graph database 120.
Therein, the configuration management system 110 includes a relational database 111. The configuration management system 110 may be used to manage various pieces of configuration data of the target system and provide a query interface for a user to query the configuration data. The target system may be, for example, various electronic systems, such as a production system, an operation and maintenance system, an environmental system, and the like. The relational database 111 may be, for example, a MySQL database, and the relational database 111 may be used to store configuration data.
The map database 120 may be, for example, a Neo4j database, and the map database 120 may be used to convert and store the configuration data stored in the relational database 111 into a graph form. When receiving an edit instruction for the configuration data in the relational database 111, the map database 120 performs data update on the data stored therein according to the edit instruction, so as to ensure that the configuration data in the two databases are synchronized.
Fig. 2 schematically shows a flow chart of a method of processing data according to an embodiment of the present disclosure.
As shown in fig. 2, the method includes operations S210 to S220.
More specifically, in operation S210, a configuration item data set in a relational database is acquired.
According to embodiments of the present disclosure, the target system may be, for example, various electronic systems, such as a production system, an operation and maintenance system, an environmental system, and the like. The target system may include a variety of devices such as storage devices, server devices, room environment devices, hardware assets, hard disks, and the like. The configuration item data set can be used for recording various software and hardware basic information such as power, network, equipment, system, application and the like in a production, operation and maintenance environment, and can provide basic data for management application and modules.
According to an embodiment of the present disclosure, the configuration items may include, for example, types of an application class, a device class, an open system class, a parameter class, and a network class. The application class configuration item may include parameters such as an application, an application version, application maintenance information, and an application node. The device class configuration items may include, for example, parameters of a storage device, a server device, a room environment device, a hardware asset, a hard disk, and the like. The open system class configuration items may include, for example, parameters of the open system. The parameter class configuration items may include, for example, parameters of service, system software, high availability, and the like. The network class configuration items may include, for example, parameters such as IP address, VLAN, private line, network port, network device, and the like
According to an embodiment of the present disclosure, a configuration item dataset may include, for example, a plurality of configuration items and relationships between the plurality of configuration items. Among them, the relationships between configuration items may include one-to-one, one-to-many, and many-to-many relationships. Fig. 3 schematically illustrates the relationship between configuration items, as shown in fig. 3, the server device and the hardware asset are in a one-to-one relationship, the application and the application node are in a one-to-many relationship, that is, one application may correspond to n application nodes, and the system node and the IP information are in a many-to-many relationship, that is, n system nodes may correspond to n IP information, where n is a positive integer.
According to embodiments of the present disclosure, a relational database may include table data objects, and tables may be utilized to store configuration items and relationships between configuration items. Exemplarily, in the present embodiment, the relational database may be, for example, a MySQL database.
In operation S220, an editing instruction for the configuration item or the relationship is received, and data in the graph database is updated according to the editing instruction.
According to embodiments of the present disclosure, a graph database may be created based on a configuration item dataset, the graph database being used to represent software and/or hardware information of a target system in the form of a graph.
According to embodiments of the present disclosure, the graph database may be, for example, a Neo4j database.
According to the embodiment of the disclosure, in the case of an editing instruction for the configuration item data set, the data in the graph database is updated according to the editing instruction, so that the data editing content made by the editing instruction is synchronously updated to the graph database while the relational database is edited, so that the graph database and the relational database keep data synchronization. When data is inquired subsequently, the inquiry can be carried out through the graph database, and the query performance is better because the graph database does not need cross-table query, so that the problem of lower query efficiency of the relational database is solved.
The method of creating a graph database is further described below.
FIG. 4 schematically shows a flow chart of a method of creating a graph database of data according to an embodiment of the disclosure. As shown in FIG. 4, a method of creating a graph database may include operations S410-S430, for example.
More specifically, in operation S410, a configuration item data set in a relational database is obtained.
According to embodiments of the present disclosure, the configuration item data set may be read from historical data already in the relational database.
In operation S420, for each configuration item in the configuration item data set, a node corresponding to the configuration item is generated, and an attribute of the node is configured according to a parameter of the configuration item.
According to embodiments of the present disclosure, a graph database may include three elements, nodes, relationships, and attributes. Nodes corresponding to the configuration items can be generated according to each configuration item, so that the configuration items can be abstracted into the nodes. For configuration items with parameters, after a node corresponding to a configuration item is generated, the attribute of the node can be configured according to the parameters of the configuration item, so that the parameters are abstracted into the attribute of the node.
In operation S430, connection relationships between the plurality of nodes are configured according to relationships between the plurality of configuration items.
According to the embodiment of the present disclosure, the relationship between the configuration items may be abstracted as a connection line between nodes corresponding to the configuration items, the connection line is also referred to as an edge, and the connection relationship between the nodes is represented by the edge.
According to the embodiment of the disclosure, taking the relational database as a MySQL database and the graph database as a Neo4j database as an example, the tables of the respective storage configuration item data sets in the MySQL database may be exported as corresponding cSv files, and then these csv files may be imported using a Neo4j import tool owned by Neo4j to create corresponding nodes, attributes and relationships.
Based on the graph database created in operations S410-S420, operation S220 is further described below.
FIG. 5 schematically illustrates a flow diagram for updating data in a graph database according to editing instructions, according to an embodiment of the disclosure. As shown in fig. 5, operation S220 may include, for example, operations S510 to S520.
More specifically, in operation S510, the type of the editing instruction and the configuration item or relationship to which the editing instruction is directed are acquired.
According to an embodiment of the present disclosure, the editing instruction may include, for example, an SQL (Structured Query language) statement for instructing addition, modification, and deletion operations on data in the database. The editing instructions can be classified into, for example, three types of an addition instruction, a modification instruction, and a deletion instruction according to the operation indicated by the editing instructions. According to an embodiment of the present disclosure, a table is used in a relational database to store configuration items and relationships between the configuration items. Therefore, the table to which the new addition operation is directed can be determined by parsing the editing instruction, and then the configuration item or relationship to which the editing instruction is directed can be acquired by reading the data in the table.
In operation S520, a node in the graph database corresponding to the configuration item dataset is edited according to the type of the editing instruction and the configuration item dataset to which the editing instruction is directed.
According to the embodiment of the disclosure, in the case that the edit instruction is a new addition instruction, if the new addition instruction is directed to a configuration item, nodes are newly built in the graph database according to the configuration item, and the attributes of the nodes and the connection relationship between the nodes are configured. And if the relationship is aimed at according to the new adding instruction, adding the connection relationship between the nodes in the graph database according to the relationship.
And under the condition that the editing instruction is a modification instruction, if the newly added instruction is directed at the configuration item, deleting the node corresponding to the configuration item in the graph database and the connection relation between the node and other nodes, then reestablishing the node corresponding to the configuration item in the graph database according to the modified configuration item, and configuring the attribute of the node and the connection relation between the nodes. And if the relationship is aimed at according to the new instruction, deleting the connection relationship between the nodes corresponding to the configuration items in the graph database.
And if the editing instruction is a deletion instruction, deleting nodes or connection relations among nodes corresponding to the configuration items or relations corresponding to the deletion instruction in the graph database. According to the embodiment of the disclosure, in the case of an editing instruction for the configuration item data set, the data in the graph database is updated according to the editing instruction, so that the data editing content made by the editing instruction is synchronously updated to the graph database while the relational database is edited, so that the graph database and the relational database keep data synchronization. When data is inquired subsequently, the inquiry can be carried out through the graph database, and the query performance is better because the graph database does not need cross-table query, so that the problem of lower query efficiency of the relational database is solved.
Fig. 6 schematically shows a flow chart of a method of processing data according to another embodiment of the present disclosure.
As shown in fig. 6, the method may further include operations S630 to S640, in addition to operations S210 to S220.
More specifically, in operation S630, a visualization page is generated according to the graph database.
In operation S640, the visualization page is presented.
According to the embodiment of the disclosure, a visual component can be obtained by decompressing the Neo4j-browser-3.2.20.jar file, and then the visual page is provided through the visual component. The visualization page is shown, for example, in fig. 7. The circles represent nodes, the connecting lines between the circles represent relationships between the nodes, and the characters on the connecting lines are annotations of the relationships. For each node, a show field may be set, which is shown near the node, e.g., 1, 0, Linux, etc. inside the circle in fig. 7. The number of nodes in the graph can be displayed on the top of the visualization page. For example, CMDB _ sysnod _ INFO _ USE (4), CMDB _ apppair _ INFO _ USE (5), CMDB _ DEVPART _ INFO (4), CMDB _ SERVERDEV _ INFO _ USE (4), CMDB _ sysnod _ DEVPART _ REL (4), CMDB _ apppair _ REL _ USE (5), CMDB _ DEVPART _ SERVERDEV _ REL _ USE (4) in fig. 7, wherein an english part is an identifier of a node and a number part is the number of the node.
According to another embodiment of the present disclosure, the query statement in the management system corresponding to the relational database may also be converted into a query language of Neo4j, for example, CQL (Cypher query language), so that when a user queries data on a foreground page, the user may perform a corresponding data query operation based on the query language of Neo4 j.
Fig. 8 schematically shows a block diagram of a processing device of data according to an embodiment of the present disclosure.
As shown in fig. 8, the data processing apparatus 800 may include a first obtaining module 810 and an updating module 820. The processing means 800 of this data may perform the methods described above with reference to fig. 2 to 6.
Specifically, the first obtaining module 810 may be configured to obtain a configuration item data set in a relational database, where the configuration item data set includes a plurality of configuration items and relationships between the plurality of configuration items, and the configuration item data set is used to record software and/or hardware information of a target system.
An update module 820 may be configured to receive editing instructions for the configuration items or relationships, and update data in a graph database according to the editing instructions, wherein the graph database is created based on the configuration item data sets, and the graph database is used for representing software and/or hardware information of the target system in a graph form.
Fig. 9 schematically shows a block diagram of a processing device of data according to an embodiment of the present disclosure.
As shown in fig. 9, the data processing apparatus 900 may further include an editing module 930 in addition to the first obtaining module 810 and the updating module 820.
According to an embodiment of the present disclosure, the editing module 930 may include: the first configuration submodule is used for generating a node corresponding to each configuration item in the configuration item data set and configuring the attribute of the node according to the parameter of the configuration item; and the second configuration submodule is used for configuring the connection relation among the nodes according to the relation among the plurality of configuration items.
According to an embodiment of the disclosure, the update module 820 may include: the second obtaining sub-module is used for obtaining the type of the editing instruction and the configuration item or relationship corresponding to the editing instruction; and the editing submodule is used for editing the nodes corresponding to the configuration items or the connection relations corresponding to the relations in the graph database according to the type of the editing instruction and the configuration items or the relations corresponding to the editing instruction.
Fig. 10 schematically shows a block diagram of a processing device of data according to an embodiment of the present disclosure.
As shown in fig. 10, the data processing apparatus 1000 may further include a generation module 1040 and a presentation module 1050 in addition to the first obtaining module 810, the updating module 820 and the editing module 930.
The generating module 1040 is configured to generate a visualization page according to the graph database.
And a display module 1050 for displaying the visual page.
Any number of modules, sub-modules, units, sub-units, or at least part of the functionality of any number thereof according to embodiments of the present disclosure may be implemented in one module. Any one or more of the modules, sub-modules, units, and sub-units according to the embodiments of the present disclosure may be implemented by being split into a plurality of modules. Any one or more of the modules, sub-modules, units, sub-units according to embodiments of the present disclosure may be implemented at least in part as a hardware circuit, such as a Field Programmable Gate Array (FPGA), a Programmable Logic Array (PLA), a system on a chip, a system on a substrate, a system on a package, an Application Specific Integrated Circuit (ASIC), or may be implemented in any other reasonable manner of hardware or firmware by integrating or packaging a circuit, or in any one of or a suitable combination of software, hardware, and firmware implementations. Alternatively, one or more of the modules, sub-modules, units, sub-units according to embodiments of the disclosure may be at least partially implemented as a computer program module, which when executed may perform the corresponding functions.
For example, any of the first obtaining module 810, the updating module 820, the editing module 930, the generating module 1040, and the presenting module 1050 may be combined into one module to be implemented, or any one of them may be split into a plurality of modules. Alternatively, at least part of the functionality of one or more of these modules may be combined with at least part of the functionality of the other modules and implemented in one module. According to an embodiment of the disclosure, at least one of the first obtaining module 810, the updating module 820, the editing module 930, the generating module 1040 and the displaying module 1050 may be implemented at least partially as a hardware circuit, such as a Field Programmable Gate Array (FPGA), a Programmable Logic Array (PLA), a system on a chip, a system on a substrate, a system on a package, an Application Specific Integrated Circuit (ASIC), or may be implemented by hardware or firmware in any other reasonable manner of integrating or packaging a circuit, or implemented by any one of three implementations of software, hardware and firmware, or implemented by a suitable combination of any of them. Alternatively, at least one of the first obtaining module 810, the updating module 820, the editing module 930, the generating module 1040 and the presenting module 1050 may be at least partially implemented as a computer program module, which when executed, may perform a corresponding function.
FIG. 11 schematically illustrates a block diagram of a computer system suitable for implementing the above-described method according to an embodiment of the present disclosure. The computer system illustrated in FIG. 11 is only one example and should not impose any limitations on the scope of use or functionality of embodiments of the disclosure.
As shown in fig. 11, computer system 1100 includes a processor 1110 and a computer-readable storage medium 1120. The computer system 1100 may perform a method according to an embodiment of the disclosure.
In particular, processor 1110 may include, for example, a general purpose microprocessor, an instruction set processor and/or related chip set and/or a special purpose microprocessor (e.g., an Application Specific Integrated Circuit (ASIC)), and/or the like. The processor 1110 may also include onboard memory for caching purposes. Processor 1110 may be a single processing unit or multiple processing units for performing different actions of a method flow according to embodiments of the disclosure.
Computer-readable storage medium 1120, for example, may be a non-volatile computer-readable storage medium, specific examples including, but not limited to: magnetic storage devices, such as magnetic tape or Hard Disk Drives (HDDs); optical storage devices, such as compact disks (CD-ROMs); a memory, such as a Random Access Memory (RAM) or a flash memory; and so on.
The computer-readable storage medium 1120 may include a computer program 1121, and the computer program 1121 may include code/computer-executable instructions that, when executed by the processor 1110, cause the processor 1110 to perform a method according to an embodiment of the present disclosure, or any variation thereof.
The computer programs 1121 can be configured to have, for example, computer program code including computer program modules. For example, in an example embodiment, code in computer program 1121 may include one or more program modules, including, for example, 1121A, 1121B, … …. It should be noted that the division and number of modules are not fixed, and those skilled in the art may use suitable program modules or program module combinations according to actual situations, so that the processor 1110 may execute the method according to the embodiment of the present disclosure or any variation thereof when the program modules are executed by the processor 1110.
According to an embodiment of the present invention, at least one of the first obtaining module 810, the updating module 820, the editing module 930, the generating module 1040 and the presentation module 1050 may be implemented as a computer program module described with reference to fig. 11, which, when executed by the processor 1110, may implement the corresponding operations described above.
The present disclosure also provides a computer-readable storage medium, which may be contained in the apparatus/device/system described in the above embodiments; or may exist separately and not be assembled into the device/apparatus/system. The computer-readable storage medium carries one or more programs which, when executed, implement the method according to an embodiment of the disclosure.
According to embodiments of the present disclosure, the computer-readable storage medium may be a non-volatile computer-readable storage medium, which may include, for example but is not limited to: a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the present disclosure, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device.
The flowchart and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present disclosure. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams or flowchart illustration, and combinations of blocks in the block diagrams or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
Those skilled in the art will appreciate that various combinations and/or combinations of features recited in the various embodiments and/or claims of the present disclosure can be made, even if such combinations or combinations are not expressly recited in the present disclosure. In particular, various combinations and/or combinations of the features recited in the various embodiments and/or claims of the present disclosure may be made without departing from the spirit or teaching of the present disclosure. All such combinations and/or associations are within the scope of the present disclosure.
While the disclosure has been shown and described with reference to certain exemplary embodiments thereof, it will be understood by those skilled in the art that various changes in form and details may be made therein without departing from the spirit and scope of the disclosure as defined by the appended claims and their equivalents. Accordingly, the scope of the present disclosure should not be limited to the above-described embodiments, but should be defined not only by the appended claims, but also by equivalents thereof.
Claims (10)
1. A method of processing data, comprising:
acquiring a configuration item data set in a relational database, wherein the configuration item data set comprises a plurality of configuration items and relations among the plurality of configuration items, and the configuration item data set is used for recording software and/or hardware information of a target system; and
receiving an editing instruction aiming at the configuration item or the relation, and updating data in a graph database according to the editing instruction, wherein the graph database is created based on the configuration item data set and is used for representing software and/or hardware information of the target system in a graph mode.
2. The method of claim 1, wherein the configuration item comprises at least one parameter;
the graph database is created by:
generating a node corresponding to each configuration item in the configuration item data set, and configuring the attribute of the node according to the parameter of the configuration item; and
and configuring the connection relation among the nodes according to the relation among the configuration items.
3. The method of claim 2, wherein said updating data in a graph database according to said editing instructions comprises:
acquiring the type of the editing instruction and a configuration item or relationship aimed at by the editing instruction; and
and editing nodes corresponding to the configuration items or connection relations corresponding to the relations in the graph database according to the type of the editing instruction and the configuration items or relations corresponding to the editing instruction.
4. The method of any of claims 1 to 3, further comprising:
generating a visual page according to the graph database; and
and displaying the visual page.
5. An apparatus for processing data, comprising:
the system comprises a first acquisition module, a second acquisition module and a third acquisition module, wherein the first acquisition module is used for acquiring a configuration item data set in a relational database, the configuration item data set comprises a plurality of configuration items and relations among the plurality of configuration items, and the configuration item data set is used for recording software and/or hardware information of a target system; and
and the updating module is used for receiving an editing instruction aiming at the configuration item or the relation and updating data in a graph database according to the editing instruction, wherein the graph database is created based on the configuration item data set and is used for representing software and/or hardware information of the target system in a graph form.
6. The apparatus of claim 5, wherein the configuration item comprises at least one parameter;
the apparatus further comprises an editing module, the editing module comprising:
the first configuration submodule is used for generating a node corresponding to each configuration item in the configuration item data set and configuring the attribute of the node according to the parameter of the configuration item; and
and the second configuration submodule is used for configuring the connection relation among the plurality of nodes according to the relation among the plurality of configuration items.
7. The apparatus of claim 6, wherein the update module comprises:
the second obtaining sub-module is used for obtaining the type of the editing instruction and the configuration item or the relationship corresponding to the editing instruction; and
and the editing sub-module is used for editing the nodes corresponding to the configuration items or the connection relations corresponding to the relations in the graph database according to the type of the editing instruction and the configuration items or the relations corresponding to the editing instruction.
8. The apparatus of any of claims 5 to 7, further comprising:
the generating module is used for generating a visual page according to the graph database; and
and the display module is used for displaying the visual page.
9. A computing device, comprising:
one or more processors;
a memory for storing one or more computer programs,
wherein the one or more computer programs, when executed by the one or more processors, cause the one or more processors to implement the method of any of claims 1 to 4.
10. A computer readable storage medium having stored thereon executable instructions which, when executed by a processor, cause the processor to carry out the method of any one of claims 1 to 4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010671902.3A CN111782673A (en) | 2020-07-13 | 2020-07-13 | Data processing method and device, computing equipment and medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010671902.3A CN111782673A (en) | 2020-07-13 | 2020-07-13 | Data processing method and device, computing equipment and medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111782673A true CN111782673A (en) | 2020-10-16 |
Family
ID=72767297
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010671902.3A Pending CN111782673A (en) | 2020-07-13 | 2020-07-13 | Data processing method and device, computing equipment and medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111782673A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113297181A (en) * | 2021-06-11 | 2021-08-24 | 建信金融科技有限责任公司 | Configuration item management database, data processing method and device |
| CN116821156A (en) * | 2023-06-27 | 2023-09-29 | 上海螣龙科技有限公司 | Network asset data storage, query and visualization method, device and medium |
| CN116991892A (en) * | 2023-07-08 | 2023-11-03 | 上海螣龙科技有限公司 | Network asset data query method, system, equipment and storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20090327630A1 (en) * | 2008-06-30 | 2009-12-31 | International Business Machines Corporation | Software configuration item back-up facility |
| CN104123369A (en) * | 2014-07-24 | 2014-10-29 | 中国移动通信集团广东有限公司 | CMDB system based on graphic data base and implementation method |
| CN108121718A (en) * | 2016-11-28 | 2018-06-05 | 北京国双科技有限公司 | A kind of data processing method and synchronizer |
| CN109634976A (en) * | 2018-12-12 | 2019-04-16 | 泰康保险集团股份有限公司 | O&M method, apparatus, system and the readable storage medium storing program for executing of non-relational database |
-
2020
- 2020-07-13 CN CN202010671902.3A patent/CN111782673A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20090327630A1 (en) * | 2008-06-30 | 2009-12-31 | International Business Machines Corporation | Software configuration item back-up facility |
| CN104123369A (en) * | 2014-07-24 | 2014-10-29 | 中国移动通信集团广东有限公司 | CMDB system based on graphic data base and implementation method |
| CN108121718A (en) * | 2016-11-28 | 2018-06-05 | 北京国双科技有限公司 | A kind of data processing method and synchronizer |
| CN109634976A (en) * | 2018-12-12 | 2019-04-16 | 泰康保险集团股份有限公司 | O&M method, apparatus, system and the readable storage medium storing program for executing of non-relational database |
Non-Patent Citations (1)
| Title |
|---|
| 张华杰;: "基于关系型数据库的数据管理与分析", 信息与电脑(理论版), no. 05 * |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113297181A (en) * | 2021-06-11 | 2021-08-24 | 建信金融科技有限责任公司 | Configuration item management database, data processing method and device |
| CN116821156A (en) * | 2023-06-27 | 2023-09-29 | 上海螣龙科技有限公司 | Network asset data storage, query and visualization method, device and medium |
| CN116991892A (en) * | 2023-07-08 | 2023-11-03 | 上海螣龙科技有限公司 | Network asset data query method, system, equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111782673A (en) | Data processing method and device, computing equipment and medium | |
| US9542469B2 (en) | Data warehouse data model adapters | |
| AU2019226217A1 (en) | Configuration of a digital twin for a building or other facility via bim data extraction and asset register mapping | |
| US10915532B2 (en) | Supporting a join operation against multiple NoSQL databases | |
| US20120072449A1 (en) | Object instance versioning | |
| US9201700B2 (en) | Provisioning computer resources on a network | |
| US10621003B2 (en) | Workflow handling in a multi-tenant cloud environment | |
| JP7141270B2 (en) | Database search system and method | |
| US11126503B2 (en) | Pre-filtering of join execution over multi-column range summaries and other synopses | |
| CN106547646B (en) | Data backup and recovery method and data backup and recovery device | |
| CN105373376A (en) | Method and apparatus for configuring a software application | |
| US8694525B2 (en) | Systems and methods for performing index joins using auto generative queries | |
| US10394844B2 (en) | Integrating co-deployed databases for data analytics | |
| US10984190B2 (en) | Atom-based sensible synchronization for information indexing | |
| US9330372B2 (en) | Generating an improved development infrastructure | |
| US9779118B2 (en) | Live database schema tree change | |
| US8650534B2 (en) | Metaobject enhancement objects | |
| US11250002B2 (en) | Result set output criteria | |
| US9465658B1 (en) | Task distribution over a heterogeneous environment through task and consumer categories | |
| US11487824B2 (en) | Automated database query filtering for spatial joins | |
| CN104050264A (en) | Method and device for generating SQL statement | |
| CN111831696A (en) | Asset information storage method and system based on graph theory | |
| US20190147082A1 (en) | Reporting and data governance management | |
| US20140129965A1 (en) | Guided activity with user's defined steps | |
| US20140067445A1 (en) | Storage medium storing analysis program, analysis method and analysis apparatus |
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 |