Data calculation method, device, computer storage medium and electronic device

Abstract

The present invention provides a data calculation method, device, computer storage medium and electronic device. The data calculation method includes: collecting data from a device system API interface and storing data; establishing a database according to the stored data; establishing neo4j nodes and tags through a database interface; establishing neo4j relationships through a database interface; designing node formulas and performing calculations. According to the data calculation method of an embodiment of the present invention, by using a neo4j graph database and through the association of graph nodes, the structured data relationship is converted into an unstructured one, the graph characteristics are used to present the data networking, and the fixed calculation of the data formula is converted into the dynamic configuration of the formula. The data calculation method well solves the problem that traditional databases cannot handle complex data relationships.

Description

Technical Field

[0001] The present invention relates to the technical field of data computing, data storage, etc. based on the data center field, and more specifically, to a data computing method, device, computer storage medium and electronic equipment. Background Art

[0002] MySQL database is a relational database management system that converts real objects into model objects based on scenario requirements, stores data in different tables in a specific structured manner, supports large databases and data warehouses with 50 million records, and is widely used in the industry due to its open source, free, cross-platform, and standard SQL data language.

[0003] However, when using the MySQL database of the prior art, if MySQL needs to express some complex relationships during query, it is bound to construct many table connections, thus forming many complex operations. In the query, due to the Cartesian product principle, a large amount of data is often involved in the screening, most of which have nothing to do with the result, and some may just be used to find its name through the ID. As the amount of data grows, even if a small part of the data is queried, the query will become slower and slower, and the performance will decline day by day, making it unbearable. The calculation of energy consumption capacity can only be analyzed through a fixed set of formula operations, and it is impossible to intelligently configure the formula to generate dynamic results. Summary of the invention

[0004] In view of this, the present invention provides a data calculation method, device, computer storage medium and electronic device, wherein the data calculation method can effectively process complex data relationships.

[0005] In order to solve the above technical problems, the present invention adopts the following technical solutions:

[0006] The data calculation method according to the first aspect of the present invention includes:

[0007] Collect and store data from the device system API interface;

[0008] Establishing a database based on the stored data;

[0009] Create neo4j nodes and labels through the database interface;

[0010] Establish neo4j relationships through database interfaces;

[0011] Design node formulas and perform calculations.

[0012] According to one embodiment of the present invention, establishing a database according to the stored data includes:

[0013] Establish the neo4j database service, start the service, and enter the neo4j visual management interface;

[0014] Integrate the Spring Data Neo4j framework into the original Java project and use the repository data warehouse interface to connect to the neo4j database.

[0015] According to an embodiment of the present invention, the neo4j node includes one or more of a device, a spatial relationship, a logical relationship and a hierarchical relationship.

[0016] According to one embodiment of the present invention, each of the neo4j nodes stores node attributes.

[0017] According to an embodiment of the present invention, the establishing of the neo4j relationship through the database interface includes: connecting the device, the spatial relationship, the logical relationship and the hierarchical relationship through lines.

[0018] According to one embodiment of the present invention, the type of each neo4j relationship is a containment relationship, an association relationship or a custom relationship.

[0019] According to one embodiment of the present invention, the designing node formula and performing calculations include:

[0020] Design node formulas, dynamically store formula nodes through database interfaces, and connect formula nodes to corresponding device nodes, spatial relationship nodes, logical relationship nodes, and hierarchical relationship nodes based on business relationships.

[0021] According to one embodiment of the present invention, the method further includes:

[0022] On the application background configuration interface, a user-configurable calculator is implemented to provide a saving entry for neo4j relationships.

[0023] According to one embodiment of the present invention, the method further includes:

[0024] On the user interface, query conditions of multiple dimensions such as device nodes, spatial relationship nodes, logical relationship nodes, and hierarchical relationship nodes are provided. The neo4j database is called through the data warehouse interface, and the corresponding data is returned to the Java background code to calculate the results according to the corresponding nodes.

[0025] A data computing device according to an embodiment of the second aspect of the present invention includes:

[0026] An acquisition module, which is used to acquire data information from a device system API interface;

[0027] A storage module, the storage module is used to store the acquired data information;

[0028] A calculation module, wherein the calculation module is used to perform data calculation on the stored data information.

[0029] According to an embodiment of the present invention, the calculation module includes a calculation unit, and the calculation unit is used to perform data calculation on the stored data information.

[0030] The computer storage medium according to the third aspect of the present invention includes one or more computer instructions, and the one or more computer instructions implement the method described in the above embodiment when executed.

[0031] An electronic device according to an embodiment of the fourth aspect of the present invention includes a memory and a processor, wherein the memory is used to store one or more computer instructions; the processor is used to call and execute the one or more computer instructions, thereby implementing the method described in the above embodiments.

[0032] The beneficial effects of the above technical solution of the present invention are as follows:

[0033] According to the data calculation method of the embodiment of the present invention, by using the neo4j graph database and through the association of graph nodes, the structured data relationship is converted into an unstructured one, the graph characteristics are used to present the data networking, and the fixed calculation of the data formula is converted into the dynamic configuration of the formula. This data calculation method effectively solves the problem that traditional databases cannot handle complex data relationships. BRIEF DESCRIPTION OF THE DRAWINGS

[0034] Figure 1 is a flow chart of a data calculation method according to an embodiment of the present invention;

[0035] Figure 2 A schematic diagram of data center park management according to an embodiment of the present invention;

[0036] Figure 3 A schematic diagram of a neo4j graph database according to an embodiment of the present invention;

[0037] Figure 4 is a schematic diagram of a data computing device according to an embodiment of the present invention;

[0038] Figure 5 Schematic diagram of an electronic device according to an embodiment of the present invention.

[0039] Reference numerals:

[0040] Data calculation method 100;

[0041] Data Center Campus Management 101;

[0042] neo4j graph database 102;

[0043] Data computing device 200;

[0044] Acquisition module 201;

[0045] Storage module 202;

[0046] Calculation module 203; Calculation unit 2031;

[0047] Electronic device 300;

[0048] Memory 310; operating system 311; application program 312;

[0049] Processor 320 ; network interface 330 ; input device 340 ; hard disk 350 ; display device 360 ​​. DETAILED DESCRIPTION

[0050] In order to make the purpose, technical solution and advantages of the embodiment of the present invention clearer, the technical solution of the embodiment of the present invention will be clearly and completely described below in conjunction with the drawings of the embodiment of the present invention. Obviously, the described embodiment is a part of the embodiment of the present invention, not all of the embodiments. Based on the described embodiment of the present invention, all other embodiments obtained by ordinary technicians in this field belong to the scope of protection of the present invention.

[0051] Unless otherwise defined, the technical terms or scientific terms used in the present invention shall have the usual meanings understood by persons with ordinary skills in the field to which the present invention belongs. The words "first", "second" and similar words used in the present invention do not indicate any order, quantity or importance, but are only used to distinguish different components. Words such as "connected" or "connected" are not limited to physical or mechanical connections, but may include electrical connections, whether direct or indirect. "Up", "down", "left", "right" and the like are only used to indicate relative positional relationships. When the absolute position of the object being described changes, the relative positional relationship also changes accordingly.

[0052] The following first describes in detail the data calculation method 100 according to an embodiment of the present invention with reference to the accompanying drawings.

[0053] like Figure 1 As shown, the data calculation method 100 according to an embodiment of the present invention includes: collecting and storing data from the device system API interface; establishing a database based on the stored data; establishing neo4j nodes and labels through the database interface; establishing neo4j relationships through the database interface; designing node formulas and performing calculations.

[0054] In other words, the main process of the data calculation method 100 according to the embodiment of the present invention is as follows: first, data can be collected through the device system API interface of the data center device, and the collected data can be stored. Then a database can be established based on the stored data. The database can use the neo4j graph database 102 to store data in the form of a graph. The stored data can be formed into connected data, which can better describe the data relationship. Then neo4j nodes and labels can be established through the database interface and neo4j relationships can be established through the database interface. The user-defined nodes and relationships can be stored in a graph from the bottom layer through the neo4j graph database 102 technology, and the relationship between two nodes can be found efficiently starting from a certain node through the relationship between nodes. Finally, a node formula can be designed and calculated. By designing a new type of node formula, this formula can be similar to the addition, subtraction, multiplication and division of a calculator. Formula nodes can be dynamically stored through the data warehouse interface, and the structured data relationship is converted into an unstructured one. The dynamic data storage and the connection relationship between the data center equipment are convenient for dynamic formula calculation.

[0055] It should be noted that the data calculation method 100 of the embodiment of the present invention can be applied to the business scenario of data center operation and maintenance management. Specifically, data center park management 101 can be used as an example. Figure 2 As shown, in accordance with the design requirements of the third normal form of relational database, entities and relationships can be separated, and the following tables can be established: equipment table (basic information table); spatial relationship table (tree-shaped hierarchy, from large to small, they are park, machine building, floor, machine room); equipment and spatial relationship association table (multiple devices correspond to one space); logical relationship table (tree-shaped hierarchy, from large to small, they are infrastructure, electrical system, subsystem, submodule); equipment and logical relationship association table (multiple devices correspond to multiple types); hierarchical relationship table (tree-shaped hierarchy, refers to the relationship between devices, and it is necessary to consider the traversal of parent-child, same-level, and subordinate nodes); equipment and hierarchical relationship association table (multiple devices correspond to multiple nodes); other business associations, equipment measurement point data (one device corresponds to multiple measurement points), equipment extended attribute table, etc.

[0056] For data center campus management 101, the neo4j graph database 102 technology is used to store user-defined nodes and relationships in a graph from the bottom layer, so as to efficiently find the connection between two nodes starting from a certain node through the relationship between nodes. Figure 3 As shown in the figure, we can know that: a graph records nodes and relationships; relationships can be used to associate two nodes; nodes and relationships can have their own attributes; and nodes can be given multiple labels.

[0057] Therefore, according to the data calculation method 100 of the embodiment of the present invention, by using the neo4j graph database 102 and through the association of graph nodes, the structured data relationship is converted into an unstructured one, and the graph characteristics are used to present the data networking, and the fixed calculation of the data formula is converted into the dynamic configuration of the formula. The data calculation method 100 well solves the problem that traditional databases cannot handle complex data relationships.

[0058] According to an embodiment of the present invention, a database is established based on the stored data, including: establishing a neo4j database service, starting the service, entering the neo4j visual management interface, integrating the Spring Data Neo4j framework in the original Java project, and connecting the neo4j database using the repository data warehouse interface.

[0059] That is to say, the process of establishing a database based on the stored data can be mainly composed of the following two steps. For the relationship management of data center equipment, you can first establish a neo4j database service, start the service, and enter the neo4j visual management interface. Then you can integrate the Spring Data Neo4j framework into the original Java project and use the repository data warehouse interface to connect to the neo4j database.

[0060] In some specific embodiments of the present invention, a neo4j node may include one or more of a device, a spatial relationship, a logical relationship, and a hierarchical relationship. Each neo4j node stores node attributes.

[0061] In other words, Figure 2 and Figure 3 As shown in the figure, you can create neo4j nodes and corresponding labels through the data warehouse interface, and define devices, spatial relationships, logical relationships, and hierarchical relationships as neo4j nodes. Each neo4j node can store its own attributes, such as a device node, a label is defined as a device, and each device can be stored as a node.

[0062] According to an embodiment of the present invention, establishing a neo4j relationship through a database interface includes: connecting devices, spatial relationships, logical relationships and hierarchical relationships through lines. The type of each neo4j relationship is a containment relationship, an association relationship or a custom relationship.

[0063] That is to say, neo4j relationships can be established through the data warehouse interface, and devices, spatial relationships, logical relationships, and hierarchical relationships can be connected through lines. The type of each neo4j relationship can be has, relate, or other custom relationships, etc.

[0064] In some specific embodiments of the present invention, node formulas are designed and calculations are performed, including: designing node formulas, dynamically storing formula nodes through a database interface, and connecting formula nodes to corresponding device nodes, spatial relationship nodes, logical relationship nodes, and hierarchical relationship nodes based on business relationships.

[0065] In other words, in order to avoid the fixation of the calculation formula for energy consumption capacity data, a new type of node formula can be designed. This formula can be similar to the addition, subtraction, multiplication and division of a calculator. The formula nodes can be dynamically stored through the data warehouse interface, and the formula nodes can be connected to the corresponding device nodes, spatial relationship nodes, logical relationship nodes, and hierarchical relationship nodes according to business relationships.

[0066] According to an embodiment of the present invention, the data calculation method 100 further includes: implementing a user-configurable calculator on the interface configured by the application background, providing a save entry for the neo4j relationship. On the user operation interface, providing query conditions of multiple dimensions of device nodes, spatial relationship nodes, logical relationship nodes, and hierarchical relationship nodes, calling the neo4j database through the data warehouse interface, and returning corresponding data to the Java background code to calculate the result according to the corresponding node.

[0067] That is to say, the data calculation method 100 may also include the following two processes: first, a user-configurable calculator may be implemented on the interface configured by the application background, and a saving entry for the neo4j relationship may be provided. Then, query conditions of multiple dimensions such as device nodes, spatial relationship nodes, logical relationship nodes, and hierarchical relationship nodes may be provided on the user operation interface, and the neo4j database may be called through the data warehouse interface, and the relevant nodes may be traversed from these dimensions, and the relevant data may be returned to the Java background code to directly calculate the results.

[0068] In summary, according to the data calculation method 100 of the embodiment of the present invention, by using the neo4j graph database 102 and through the association of graph nodes, the structured data relationship is converted into an unstructured one, and the graph characteristics are used to present the data networking, and the fixed calculation of the data formula is transformed into the dynamic configuration of the formula. The data calculation method 100 well solves the problem that traditional databases cannot handle complex data relationships.

[0069] The data computing device 200 according to the second aspect of the embodiment of the present invention includes an acquisition module 201 , a storage module 202 and a computing module 203 .

[0070] Specifically, Figure 4 As shown, the acquisition module 201 is used to acquire data information from the device system API interface, the storage module 202 is used to store the acquired data information, and the calculation module 203 is used to perform data calculation on the stored data information.

[0071] That is to say, the data computing device 200 is mainly composed of an acquisition module 201, a storage module 202 and a computing module 203. Among them, the acquisition module 201 can be used to acquire data information from the device system API interface, and the storage module 202 can be used to store the acquired data information. A database can be established based on the stored data information. The database can use the neo4j graph database 102 to store data in the form of a graph. The stored data can be formed into connected data, which can better describe the data relationship. The computing module 203 can be used to perform data calculation on the stored data information. It can be calculated by designing a node formula. By designing a new type of node formula, this formula can be similar to the addition, subtraction, multiplication and division of a calculator. The formula nodes can be dynamically stored through the data warehouse interface, and the structured data relationship is converted into an unstructured one. The dynamic data storage and the connection relationship between the data center equipment are convenient for dynamic formula calculation.

[0072] According to an embodiment of the present invention, the calculation module 203 includes a calculation unit 2031, and the calculation unit 2031 is used to perform data calculation on the stored data information.

[0073] In other words, the calculation module 203 may include a calculation unit 2031, and the calculation unit 2031 may be used to perform data calculation on the stored data information.

[0074] In addition, an embodiment of the present invention further provides a computer storage medium, wherein the computer storage medium includes one or more computer instructions, and the one or more computer instructions implement any of the above-mentioned data processing methods when executed.

[0075] That is, the computer storage medium stores a computer program, and when the computer program is executed by the processor 320, the processor 320 executes any of the above-mentioned data processing methods.

[0076] like Figure 5 As shown, an embodiment of the present invention further provides an electronic device 300, including a memory 310 and a processor 320, wherein the memory 310 is used to store one or more computer instructions, and the processor 320 is used to call and execute the one or more computer instructions, so as to implement any of the methods described above.

[0077] That is, the electronic device 300 includes: a processor 320 and a memory 310, wherein the memory 310 stores computer program instructions, wherein when the computer program instructions are executed by the processor 320, the processor 320 executes any of the above methods.

[0078] Furthermore, if Figure 5As shown, the electronic device 300 further includes a network interface 330 , an input device 340 , a hard disk 350 , and a display device 360 ​​.

[0079] The above-mentioned interfaces and devices can be interconnected through a bus architecture. The bus architecture can be a bus and bridge that can include any number of interconnected buses. Specifically, one or more central processing units (CPUs) represented by the processor 320 and various circuits of one or more memories 310 represented by the memory 310 are connected together. The bus architecture can also connect various other circuits such as peripheral devices, voltage regulators, and power management circuits together. It can be understood that the bus architecture is used to achieve connection and communication between these components. In addition to the data bus, the bus architecture also includes a power bus, a control bus, and a status signal bus, which are all well known in the art, so they will not be described in detail herein.

[0080] The network interface 330 can be connected to a network (such as the Internet, a local area network, etc.), obtain relevant data from the network, and save it in the hard disk 350.

[0081] The input device 340 can receive various instructions input by the operator and send them to the processor 320 for execution. The input device 340 can include a keyboard or a pointing device (for example, a mouse, a trackball, a touch pad or a touch screen, etc.).

[0082] The display device 360 ​​can display the result obtained by the processor 320 executing the instruction.

[0083] The memory 310 is used to store programs and data necessary for the operation of the operating system 311, as well as data such as intermediate results during the calculation process of the processor 320.

[0084] It is understood that the memory 310 in the embodiment of the present invention may be a volatile memory or a non-volatile memory, or may include both volatile and non-volatile memories. Among them, the non-volatile memory may be a read-only memory (ROM), a programmable read-only memory (PROM), an erasable programmable read-only memory (EPROM), an electrically erasable programmable read-only memory (EEPROM), or a flash memory. The volatile memory may be a random access memory (RAM), which is used as an external cache. The memory 310 of the apparatus and method described herein is intended to include, but is not limited to, these and any other suitable types of memory 310.

[0085] In some implementations, the memory 310 stores the following elements, executable modules or data structures, or a subset thereof, or an extended set thereof: an operating system 311 and application programs 312 .

[0086] The operating system 311 includes various system programs, such as a framework layer, a core library layer, a driver layer, etc., which are used to implement various basic services and process hardware-based tasks. The application 312 includes various application programs 312, such as a browser, etc., which are used to implement various application services. The program for implementing the method of the embodiment of the present invention can be included in the application 312.

[0087] The processor 320, when calling and executing the application 312 and data stored in the memory 310, specifically, the program or instructions stored in the application 312, can collect and store data from the device system API interface, establish a database based on the stored data, establish neo4j nodes and labels through the database interface, and establish neo4j relationships through the database interface, and finally design node formulas and perform calculations.

[0088] The method disclosed in the above embodiment of the present invention can be applied to the processor 320, or implemented by the processor 320. The processor 320 may be an integrated circuit chip with signal processing capabilities. In the implementation process, each step of the above method can be completed by the hardware integrated logic circuit in the processor 320 or the instruction in the form of software. The above processor 320 can be a general processor, a digital signal processor (DSP), an application-specific integrated circuit (ASIC), a field-programmable gate array (FPGA) or other programmable logic devices, discrete gates or transistor logic devices, discrete hardware components, and can implement or execute the methods, steps and logic block diagrams disclosed in the embodiments of the present invention. The general processor 320 can be a microprocessor or the processor 320 can also be any conventional processor. The steps of the method disclosed in the embodiment of the present invention can be directly embodied as a hardware decoding processor 320 to execute, or it can be executed by a combination of hardware and software modules in the decoding processor. The software module can be located in a mature storage medium in the field such as a random access memory, a flash memory, a read-only memory, a programmable read-only memory or an electrically erasable programmable memory, a register, etc. The storage medium is located in the memory 310, and the processor 320 reads the information in the memory 310 and completes the steps of the above method in combination with its hardware.

[0089] It is understood that the embodiments described herein can be implemented in hardware, software, firmware, middleware, microcode or a combination thereof. For hardware implementation, the processing unit can be implemented in one or more application specific integrated circuits (ASICs), digital signal processors (DSPs), digital signal processing devices (DSPDs), programmable logic devices (PLDs), field programmable gate arrays (FPGAs), general purpose processors, controllers, microcontrollers, microprocessors, other electronic units for performing the functions described in the present application or a combination thereof.

[0090] For software implementation, the techniques described herein may be implemented by modules (e.g., procedures, functions, etc.) that perform the functions described herein. The software codes may be stored in the memory 310 and executed by the processor 320. The memory 310 may be implemented in the processor 320 or external to the processor 320.

[0091] Specifically, the processor 320 is further configured to read the computer program and execute any of the above methods.

[0092] In the several embodiments provided in the present application, it should be understood that the disclosed methods and devices can be implemented in other ways. For example, the device embodiments described above are only schematic. For example, the division of the units is only a logical function division. There may be other division methods in actual implementation, such as multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be through some interfaces, indirect coupling or communication connection of devices or units, which can be electrical, mechanical or other forms.

[0093] In addition, each functional unit in each embodiment of the present invention may be integrated into one processing unit, or each unit may be physically included separately, or two or more units may be integrated into one unit. The above-mentioned integrated unit may be implemented in the form of hardware or in the form of hardware plus software functional units.

[0094] The above-mentioned integrated unit implemented in the form of a software functional unit can be stored in a computer-readable storage medium. The above-mentioned software functional unit is stored in a storage medium, including a number of instructions for a computer device (which can be a personal computer, a server, or a network device, etc.) to perform some steps of the sending and receiving method described in each embodiment of the present invention. The aforementioned storage medium includes: U disk, mobile hard disk, read-only memory (Read-Only Memory, referred to as ROM), random access memory (Random Access Memory, referred to as RAM), disk or optical disk and other media that can store program codes.

[0095] In the description of this specification, the description with reference to the terms "one embodiment", "some embodiments", "illustrative embodiments", "preferred embodiments", "specific implementation", or "preferred implementation" etc. means that the specific features, structures, materials or characteristics described in conjunction with the embodiment or example are included in at least one embodiment or example of the present invention. In this specification, the schematic representation of the above terms does not necessarily refer to the same embodiment or example. Moreover, the specific features, structures, materials or characteristics described may be combined in any one or more embodiments or examples in a suitable manner.

[0096] The above is a preferred embodiment of the present invention. It should be pointed out that for ordinary technicians in this technical field, several improvements and modifications can be made without departing from the principles of the present invention. These improvements and modifications should also be regarded as the scope of protection of the present invention.

Claims

1. A data calculation method, characterized in that: The method comprises: Collect and store data from the device system API interface; Establishing a database based on the stored data; Create neo4j nodes and labels through the database interface; Establish neo4j relationships through database interfaces; Design node formulas and perform calculations; The step of establishing a database according to the stored data comprises: Establish the neo4j database service, start the service, and enter the neo4j visual management interface; Integrate the Spring Data Neo4j framework into the original Java project and use the repository data warehouse interface to connect to the neo4j database; The neo4j node includes one or more of a device, a spatial relationship, a logical relationship, and a hierarchical relationship; The establishing of the neo4j relationship through the database interface includes: connecting the device, the spatial relationship, the logical relationship and the hierarchical relationship through a connection line; The type of the neo4j relationship is a containment relationship, an association relationship or a custom relationship; The design node formula and calculation include: Design node formulas, dynamically store formula nodes through database interfaces, and connect formula nodes to corresponding device nodes, spatial relationship nodes, logical relationship nodes, and hierarchical relationship nodes based on business relationships.

2. The data calculation method according to claim 1, characterized in that: Each of the neo4j nodes stores node attributes.

3. The data calculation method according to claim 1, characterized in that: The method further comprises: On the application background configuration interface, a user-configurable calculator is implemented to provide a saving entry for neo4j relationships.

4. The data calculation method according to claim 3, characterized in that: The method further comprises: On the user interface, query conditions of multiple dimensions such as device nodes, spatial relationship nodes, logical relationship nodes, and hierarchical relationship nodes are provided. The neo4j database is called through the data warehouse interface, and the corresponding data is returned to the Java background code to calculate the results according to the corresponding nodes.

5. A data computing device applied to the method of claim 1, characterized in that: include: An acquisition module, which is used to acquire data information from a device system API interface; A storage module, the storage module is used to store the acquired data information; A calculation module, wherein the calculation module is used to perform data calculation on the stored data information.

6. The data computing device according to claim 5, characterized in that: The calculation module includes a calculation unit, and the calculation unit is used to perform data calculation on the stored data information.

7. A computer storage medium, characterized in that: The method comprises one or more computer instructions, which implement the method according to any one of claims 1 to 4 when executed.

8. An electronic device, comprising a memory and a processor, characterized in that: The memory is used to store one or more computer instructions; The processor is used to call and execute the one or more computer instructions, so as to implement the method according to any one of claims 1 to 4.

Images