CN116028517A - Fusion database system and electronic equipment - Google Patents
Fusion database system and electronic equipment Download PDFInfo
- Publication number
- CN116028517A CN116028517A CN202310097378.7A CN202310097378A CN116028517A CN 116028517 A CN116028517 A CN 116028517A CN 202310097378 A CN202310097378 A CN 202310097378A CN 116028517 A CN116028517 A CN 116028517A
- Authority
- CN
- China
- Prior art keywords
- real
- data
- database
- time
- data table
- 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
- 230000004927 fusion Effects 0.000 title claims abstract description 56
- 238000012423 maintenance Methods 0.000 claims abstract description 89
- 238000004590 computer program Methods 0.000 claims description 16
- 238000010276 construction Methods 0.000 claims description 6
- 238000003672 processing method Methods 0.000 claims description 6
- 238000012544 monitoring process Methods 0.000 description 17
- 238000000034 method Methods 0.000 description 16
- 238000007726 management method Methods 0.000 description 12
- 238000010586 diagram Methods 0.000 description 11
- 238000004891 communication Methods 0.000 description 9
- 230000006870 function Effects 0.000 description 7
- 230000008569 process Effects 0.000 description 6
- 238000012545 processing Methods 0.000 description 6
- 230000003993 interaction Effects 0.000 description 4
- 238000012986 modification Methods 0.000 description 3
- 230000004048 modification Effects 0.000 description 3
- 230000003287 optical effect Effects 0.000 description 3
- 230000008859 change Effects 0.000 description 2
- 238000013461 design Methods 0.000 description 2
- 238000007499 fusion processing Methods 0.000 description 2
- 230000001360 synchronised effect Effects 0.000 description 2
- 238000013459 approach Methods 0.000 description 1
- 238000003491 array Methods 0.000 description 1
- 238000013473 artificial intelligence Methods 0.000 description 1
- 238000012550 audit Methods 0.000 description 1
- 230000001413 cellular effect Effects 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000012217 deletion Methods 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000010354 integration Effects 0.000 description 1
- 239000004973 liquid crystal related substance Substances 0.000 description 1
- 238000010801 machine learning Methods 0.000 description 1
- 239000013307 optical fiber Substances 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
- 230000001953 sensory effect Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a fusion database system and electronic equipment. The system comprises a real-time database, a relational database and a data maintenance module; the data maintenance module is used for receiving the real-time data to be updated and the relation data to be updated, sending the real-time data to be updated to the real-time database, and sending the relation data to be updated containing the relation corresponding to the number information to the relation database; the real-time database is used for updating the real-time data table according to the real-time data to be updated, generating a new real-time data table, and synchronizing the number information in the new real-time data table into the relational database; and the relational database is used for updating the number information into the relational data table when the number information is received, and updating the relational data to be updated into the relational data table according to the corresponding relation and the number information in the relational data to be updated after the relational data to be updated is received. According to the technical scheme provided by the embodiment of the invention, the fusion degree of different databases is improved through the same number information.
Description
Technical Field
The present invention relates to the field of database technologies, and in particular, to a fusion database system and an electronic device.
Background
Along with the integration of industrialization and informatization, many demands for integrating data in an industrial real-time monitoring system and an information management system are generated in the industrial field, namely, demands for integrating a real-time database in the industrial real-time monitoring system and a relational database in the information management system.
In the prior art, one method for carrying out data fusion processing is to carry out manual inquiry on an industrial real-time monitoring system and an information management system respectively, and then fusion is carried out on the inquiry; another method is to realize data fusion by developing an interface of data interaction between an industrial real-time monitoring system and an information management system; yet another approach is to modify its corresponding real-time database to add corresponding management information based on an industrial real-time monitoring system.
However, the essence of the data fusion processing by manual inquiry is that the information on one system is manually input in the other system, the whole data processing mode is complicated, and the manual dependency is higher; when the data interaction interface is developed to realize data fusion, because the industrial real-time monitoring system and the information management system are usually dominant by different manufacturers, different periods or different departments, the coordination is difficult in the technical angle and the non-technical angle, the data structure design is difficult to fuse, and the practicability is low; because the real-time database corresponding to the industrial real-time monitoring system has the characteristics of multiple data points, frequent reading and writing and high real-time requirement, if the real-time database is modified based on the industrial real-time monitoring system, the terminal of the industrial real-time monitoring system can be enabled to be long in time, the modification of the table structure is difficult to be frequently carried out along with the continuous change of management requirements, and the requirements of continuous stable and reliable operation in the industrial real-time monitoring system are contradicted with scattered and changeable information in the information management system, so that the stability of the whole operation is affected.
Disclosure of Invention
The invention provides a fusion database system and electronic equipment, which realize unified maintenance of real-time information and management information under the condition of ensuring the operation of an industrial real-time monitoring system, ensure the operation stability of the system and improve the fusion degree of data in different databases.
In a first aspect, an embodiment of the present invention provides a fusion database system, including a real-time database, a relational database, and a data maintenance module; the real-time data table in the real-time database is consistent with the relationship data table in the relationship database in structure, and the relationship data table is an expansion table of the real-time data table;
the data maintenance module is used for receiving the real-time data to be updated and sending the real-time data to be updated to the real-time database;
the real-time database is used for updating the real-time data table according to the data to be updated in real time, generating a new real-time data table, synchronizing the number information in the new real-time data table into the relational database, and feeding back the new real-time data table to the data maintenance module;
the data maintenance module is also used for receiving the relation data to be updated, determining the corresponding relation between the relation data to be updated and the number information in the new real-time data table, and sending the relation data to be updated containing the corresponding relation to the relation database;
the relational database is used for updating the number information into the relational data table when the number information is received;
and the relational database is also used for updating the relational data to be updated into the relational data table according to the corresponding relation and the number information in the relational data to be updated after the relational data to be updated is received.
In a second aspect, an embodiment of the present invention further provides an electronic device, including:
at least one processor; and
a memory communicatively coupled to the at least one processor; wherein,,
the memory stores a computer program executable by the at least one processor to enable the at least one processor to perform the data processing method corresponding to the fusion database system of any one of the embodiments of the present invention.
The embodiment of the invention provides a fusion database system and electronic equipment, wherein the fusion database system comprises a real-time database, a relational database and a data maintenance module; the real-time data table in the real-time database is consistent with the relationship data table in the relationship database in structure, and the relationship data table is an expansion table of the real-time data table; the data maintenance module is used for receiving the real-time data to be updated and sending the real-time data to be updated to the real-time database; the real-time database is used for updating the real-time data table according to the data to be updated in real time, generating a new real-time data table, synchronizing the number information in the new real-time data table into the relational database, and feeding back the new real-time data table to the data maintenance module; the data maintenance module is also used for receiving the relation data to be updated, determining the corresponding relation between the relation data to be updated and the number information in the new real-time data table, and sending the relation data to be updated containing the corresponding relation to the relation database; the relational database is used for updating the number information into the relational data table when the number information is received; and the relational database is also used for updating the relational data to be updated into the relational data table according to the corresponding relation and the number information in the relational data to be updated after the relational data to be updated is received. By adopting the technical scheme, aiming at the real-time database and the relational database in the fusion database, the data table with the consistent structure is designed, the two databases are related through the same number information in the mode of firstly carrying out real-time database and then relational database during data maintenance, so that the unified maintenance of the two databases in the fusion database system is realized.
It should be understood that the description in this section is not intended to identify key or critical features of the embodiments of the invention or to delineate the scope of the invention. Other features of the present invention will become apparent from the description that follows.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings required for the description of the embodiments will be briefly described below, and it is apparent that the drawings in the following description are only some embodiments of the present invention, and other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
Fig. 1 is a schematic structural diagram of a fusion database system according to a first embodiment of the present invention;
fig. 2 is a schematic structural diagram of a fusion database system according to a second embodiment of the present invention;
FIG. 3 is a diagram illustrating a structure of another fusion database system according to a second embodiment of the present invention;
FIG. 4 is a diagram illustrating a structure of another fusion database system according to a second embodiment of the present invention;
fig. 5 is a schematic structural diagram of an electronic device according to a third embodiment of the present invention.
Detailed Description
In order that those skilled in the art will better understand the present invention, a technical solution in the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in which it is apparent that the described embodiments are only some embodiments of the present invention, not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the present invention without making any inventive effort, shall fall within the scope of the present invention.
It should be noted that the terms "first," "second," and the like in the description and the claims of the present invention and the above figures are used for distinguishing between similar objects and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used may be interchanged where appropriate such that the embodiments of the invention described herein may be implemented in sequences other than those illustrated or otherwise described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
Example 1
Fig. 1 is a schematic structural diagram of a fusion database system according to a first embodiment of the present invention, where the fusion database system is applicable to an industrial monitoring scenario, and the fusion database system 1 includes a real-time database 10, a relational database 11, and a data maintenance module 12; the real-time data table in the real-time database 10 is consistent with the relational data table in the relational database 11 in structure, and the relational data table is an extension table of the real-time data table.
The data maintenance module 12 is configured to receive the real-time data to be updated and send the real-time data to be updated to the real-time database 10;
the real-time database 10 is used for updating the real-time data table according to the data to be updated in real time, generating a new real-time data table, synchronizing the number information in the new real-time data table into the relational database 11, and feeding back the new real-time data table to the data maintenance module 12;
the data maintenance module 12 is further configured to receive the relationship data to be updated, determine a correspondence between the relationship data to be updated and the number information in the new real-time data table, and send the relationship data to be updated including the correspondence to the relationship database 11;
a relational database 11 for updating the number information into a relational data table when the number information is received;
the relational database 11 is further configured to update the relational data to be updated into the relational data table according to the corresponding relationship and the number information in the relational data to be updated after the relational data to be updated is received.
In this embodiment, the real-time database 10 is specifically understood as a database used in an industrial monitoring scene to store data information that needs to be monitored in real time by different entity devices in the scene. Alternatively, the real-time database may specifically be a database based on profile properties implemented by memory. The real-time data table is specifically understood as a network virtual table in the real-time database for storing data, wherein the network virtual table may comprise at least one preset real-time field type, and the real-time field type is specifically understood as a type for indicating recorded data. By way of example, the types of real-time fields that may be stored in the real-time data table may include information such as real-time power, real-time voltage, and real-time temperature collected in an industrial monitoring scenario, which embodiments of the present invention are not limited in this respect. The relational database 11 may be specifically understood as a database for storing management attribute data information corresponding to different entity devices in an industrial monitoring scene, where the management attribute data information has a corresponding relationship with real-time monitoring data information in a real-time database. A relational data table is specifically understood as a network virtual table in a relational database for storing data, where at least one preset relational field type may be included. The type of the relationship field that may be stored in the relationship data table may include information such as a device number, a manufacturer, and a factory number of the entity device, which is not limited in the embodiment of the present invention. Further, because the relationship data table is consistent with the real-time data table in structure, and the corresponding information of the relationship data table is information corresponding to the real-time data information in the real-time data table and used for indicating the identity of the entity equipment for collecting the real-time data information, the relationship data table can be considered as the extension information of the real-time data table stored in the relationship data table, and the relationship data table can also be considered as the extension table of the real-time data table, and the relationship data table and the real-time data table are combined to form complete data information containing the identity information of the entity equipment and the real-time data information in the industrial monitoring scene.
In this embodiment, the data maintenance module 12 is specifically understood as a module for receiving data to be updated and performing data update maintenance on the real-time database 10 and the relational database 11 in the fusion database system 1 according to the type of the data to be updated. Optionally, the data maintenance module 12 may change the communication manner with the real-time database 10 and the relational database 11 when performing different tasks, and may also maintain long connection with the real-time database 10 and the relational database 11, which is not limited in the embodiment of the present invention. Real-time data to be updated is specifically understood as data of the real-time field type that needs to be maintained into the converged data system. The number information is specifically understood as a number which is automatically generated by the real-time database according to the order of storing the number information in the real-time data table. The relationship data to be updated may be understood as data of the relationship field type, which needs to be maintained in the converged data system.
Specifically, after the fusion database system 1 is put into use, the data maintenance module 12 will be ready to receive the data to be updated, which is given from the outside, for the fusion database system 1, and for the sequence of the maintenance of the data in the fusion database system 1, the update of the real-time database 10 is preferably completed, and then the update of the relational database 11 is completed, that is, the update of the relational database 11 is realized based on the records existing in the real-time database 10. When the data maintenance module 12 receives the data to be updated in real time, the data to be updated in real time is sent to the real-time database 10, the distinction between the data to be updated in real time and the existing real-time data table is compared, if the distinction is located in the real-time data field of the existing real-time data table, the real-time data field is correspondingly modified, if the data to be updated in real time includes the data newly added to the real-time data table or includes the deletion of the original data in the real-time data table, the number information in the real-time data table is adjusted based on the data to be updated, and the data information corresponding to the number information is adjusted. After all data in the data to be updated in real time are updated into the real-time data table, a new real-time data table is generated, the number information in the new real-time data table is synchronized into the relational database 11 by the real-time database 10, and the number update of the relational data table in the relational database 11 is completed first, so that the relational database 11 can update the relational data fields based on the number information later. Meanwhile, the real-time database 10 also needs to feed back a new real-time data table to the data maintenance module 12, so that when the data maintenance module 12 receives the data to be updated, the corresponding relation between the data to be updated and the number information in the new real-time data table can be clarified, and further, because the number information in the real-time data table and the number information in the relation data table are synchronous, the data maintenance module 12 can send the data to be updated containing the corresponding relation to the relation database 11, so that the relation database can determine the number of the relation data to be updated in the relation data table according to the corresponding relation, and update the corresponding relation data to be updated to the relation data table.
The embodiment of the invention provides a fusion database system, which comprises a real-time database, a relational database and a data maintenance module; the real-time data table in the real-time database is consistent with the relationship data table in the relationship database in structure, and the relationship data table is an expansion table of the real-time data table; the data maintenance module is used for receiving the real-time data to be updated and sending the real-time data to be updated to the real-time database; the real-time database is used for updating the real-time data table according to the data to be updated in real time, generating a new real-time data table, synchronizing the number information in the new real-time data table into the relational database, and feeding back the new real-time data table to the data maintenance module; the data maintenance module is also used for receiving the relation data to be updated, determining the corresponding relation between the relation data to be updated and the number information in the new real-time data table, and sending the relation data to be updated containing the corresponding relation to the relation database; the relational database is used for updating the number information into the relational data table when the number information is received; and the relational database is also used for updating the relational data to be updated into the relational data table according to the corresponding relation and the number information in the relational data to be updated after the relational data to be updated is received. By adopting the technical scheme, aiming at the real-time database and the relational database in the fusion database, the data table with the consistent structure is designed, the two databases are related through the same number information in the mode of firstly carrying out real-time database and then relational database during data maintenance, so that the unified maintenance of the two databases in the fusion database system is realized.
Example two
Fig. 2 is a schematic structural diagram of a fusion database system according to a second embodiment of the present invention, and the technical solution of the embodiment of the present invention is further refined based on the above technical solution, which specifies a data maintenance mode of the data maintenance module 12 for the real-time database 10 and the relational database 11. Wherein the real-time database 10 comprises a maintenance database sub-database 101 and an operation database sub-database 102.
The maintenance sub-database 101 is configured to update the real-time data table according to the real-time data to be updated, generate a real-time data table to be issued, and send the real-time data table to be issued to the operation sub-database 102 when receiving an issue command;
the operation sub-database 102 is configured to store the real-time data table to be distributed as a new real-time data table after receiving the real-time data table to be distributed, synchronize the number information in the new real-time data table to the relational database 11, and feed back the new real-time data table to the data maintenance module 12.
The data maintenance module 12 is further configured to: and displaying the real-time data table at the current moment before receiving the real-time data to be updated or the relation data to be updated.
The data maintenance module 12 is specifically configured to: the real-time data to be updated is received and sent to the maintenance sub-database 101.
The data maintenance module 12 is specifically configured to: the new real-time data table fed back by the operation sub-database 102 is received, and the new real-time data table is updated to the real-time data table at the current moment.
The relational database 11 is specifically configured to: after receiving the relationship data to be updated, determining relationship data corresponding to each numbered information in the relationship data to be updated according to the corresponding relationship and the numbered information in the relationship data to be updated; and updating each relationship data to the relationship data table according to the relationship field type and the number information of each relationship data.
Further, the real-time data table at the current time shown by the data maintenance module 12 is in a read-only format before receiving the data to be updated.
In this embodiment, the maintenance sub-database 101 may be specifically understood as a database in which the real-time database 10 stores a total amount of real-time field type data for preliminarily updating the real-time data table in the data maintenance process, or may be understood as a real-time data table determined in the data maintenance process in the maintenance sub-database 101, which is a "draft" version data table. The real-time data table to be published can be specifically understood as a real-time data table generated by the maintenance sub database 101 after completing the update of the real-time data to be updated received once. The issue command is specifically understood to be a control command given from the outside to determine that no problem exists in the real-time data table to be issued and that the issue command can be issued. The running sub-database 102 may be specifically understood as a database in which real-time field type data that can be directly accessed by the outside is stored in the real-time database 10, or may be understood as a real-time data table determined in the data maintenance process in the running sub-database 102, which is a "published" version of the data table.
Specifically, the data maintenance module 12 externally displays the real-time data table at the current time, so that a user can clearly determine the data storage condition in the fusion database system at the current time, and after receiving the data to be updated in real time, the data maintenance module 12 can consider that the data maintenance module 12 needs to perform maintenance on the real-time data table first for the real-time database 10, and at this time, the data maintenance module 12 sends the data to be updated in real time to the maintenance sub-database 101. The maintenance sub-database 101 compares the difference between the real-time data to be updated and the stored data in the own real-time data table, and for the real-time data to be updated which does not exist in the maintenance sub-database 101, the corresponding real-time data to be updated is inserted into the real-time data table in the maintenance sub-database 101 and is given with corresponding number information, and for the real-time data to be updated which already exists in the maintenance sub-database 101, the data corresponding to the number information in the maintenance sub-database 101 is updated by the corresponding real-time data to be updated, and after all the real-time data to be updated have been maintained in the maintenance sub-database 101, the real-time data table of the maintenance sub-database 101 is determined as the real-time data table to be issued. When the maintenance sub-database 101 receives an issue command given from the outside, the real-time data table to be issued can be considered to be issued, and at this time, the maintenance sub-database 101 migrates the data in the real-time data table to be issued into the operation sub-database 102, so that the operation sub-database 102 stores the real-time data table to be issued as a new real-time data table, and at this time, the maintenance for the real-time database 10 can be considered to be completed. To further complete maintenance of the relational database 11 in the fusion database system 1 and construct an association relationship between the real-time database 10 and the relational database 11, the operation of synchronizing the number information in the new real-time data table to the relational database 11 is completed by the operation sub-database 102, so that the relational database 11 completes updating of the number information in the relational data table. The running sub-database 102 also feeds back a new real-time data table to the data maintenance module 12 to update the real-time data table at the current time displayed by the data maintenance module 12, so that the user can determine that the updating operation on the relational database needs to be performed by taking the real-time data table as a reference. It should be clear that the data maintenance module 12 will present the new real-time data table in read-only format that completes the maintenance.
When the data maintenance module 12 receives the relationship to-be-updated data for updating the relationship database 11, the number information corresponding to the relationship to-be-updated data is determined according to the displayed new real-time data table, that is, the corresponding relationship between the relationship to-be-updated data and the number information in the new real-time data table can be determined, and at this time, the relationship to-be-updated data containing the corresponding relationship is sent to the relationship database 11 by the data maintenance module 12. After the relational database 11 receives the data to be updated, the number information to be updated in the relational data table and the relational data corresponding to the number information in the data to be updated are determined according to the corresponding relation contained in the data to be updated, and because the relational data table can comprise a plurality of relational field types, the relational field types corresponding to the relational data can be determined at the moment, so that the position of the relational data in the relational data table can be determined according to the number information and the relational field types at the same time, and the relational data can be updated to the corresponding determined position, so that the updating of the relational data table can be completed.
Further, fig. 3 is a schematic diagram of another configuration example of a fusion database system according to the second embodiment of the present invention, which is further optimized based on the foregoing embodiments. As shown in fig. 3, the fusion database system 1 further includes: a data query module 13.
The data query module 13 is configured to receive a data query instruction, generate a structured data query statement corresponding to the data query instruction, and determine a relational data field from the relational database 11 through the structured data query statement;
the data query module 13 is further configured to determine a real-time data field corresponding to the number information in the real-time database 10 according to the number information corresponding to the relationship data field, splice the real-time data field and the relationship data field, and generate and display query data corresponding to the data query instruction.
In this embodiment, the data query module 13 may be specifically understood as a module for receiving a data query instruction given by a user or other channels, extracting corresponding data fields from different databases of the fusion database system 1 according to the data query instruction, and providing the data fields after they are spliced completely.
Specifically, because the real-time database 10 in the fusion database system 1 is a memory database with a cross-section property, although the read-write performance is good, a strong structured statement query function is not generally supported, but the relational database 11 has a strong structured statement query function, because the data corresponding to the relational database 11 in the real-time database 10 in the fusion database system 1 is associated through the same serial number information, when the data query module 13 receives a data query instruction, a corresponding structured data query statement can be generated based on the data query instruction, the relational database 11 with the structured statement query function is preferentially searched through the structured data query statement, the relational data field corresponding to the structured data query statement in the relational data table of the relational database 11 can be determined, the serial number information corresponding to the relational data field in the relational data table can be determined, and the real-time data field corresponding to the serial number information in the real-time database 10 can be considered as the data desired to be queried by the data query instruction, and the real-time data table and the relational data table can be considered as the data table corresponding to the relational data field, and the relational data table can be expanded based on the obtained by the data query structure, and the obtained data table is spliced, and the data table can be obtained after the data structure is displayed by the data query module is spliced, and the obtained by the data query module is completed.
In the embodiment of the invention, based on the association relation of the same number information between the real-time database and the relational database, the structured query function of the relational database is fully utilized, the rapid and complete query of the data in the fusion database system is realized, and the query efficiency and the practicability of the fusion database system are improved.
Further, fig. 4 is a diagram illustrating a structure of another fusion database system according to the second embodiment of the present invention, which is further optimized based on the above embodiments. As shown in fig. 4, the fusion database system 1 further includes: a data table construction module 14;
a data table construction module 14, configured to construct an initial real-time data table in the real-time database 10, and construct an initial relationship data table in the relationship database 11, where the initial relationship data table is consistent with the initial real-time data table;
the initial real-time data table comprises at least one preset real-time field type, and the initial relation data table comprises at least one preset relation field type.
In this embodiment, the initial real-time data table is specifically understood as a data table in which only the real-time field type is specified and real-time data writing has not been performed yet. An initial relational data table is specifically understood as a data table in which only the type of relational field is specified and in which relational data has not yet been written.
Specifically, when a data table needs to be added to each database in the fusion database system 1, an initial real-time data table and an initial relationship data table with the same structure can be respectively constructed for the real-time database 10 and the relationship database 11 through the data table construction module 14, at least one preset real-time field type is set for the initial real-time data table according to the actual working scene requirement, at least one preset relationship field type is set for the initial relationship data table, and the fusion database system 1 after the data table construction is put into use is maintained for the real-time database 10 and the relationship database 11 through the data maintenance module 12.
In the embodiment of the invention, the real-time database is divided into the maintenance sub-database and the operation sub-database, the real-time data table maintenance is performed in the maintenance sub-database, and the data maintenance of the real-time database is realized in a mode of releasing the maintained data into the operation sub-database, so that the accuracy is higher when the batch data maintenance is performed. When the data query task is executed, the structured query function of the relational database and the serial number information associated with the two databases are used for realizing the rapid and complete query of the data in the fusion database system, so that the query efficiency and the practicability of the fusion database system are improved, the advantages of different databases in the fusion database system can be integrated when different tasks are executed, and the database fusion effect is improved.
Example III
Fig. 5 is a schematic structural diagram of an electronic device according to a third embodiment of the present invention. Electronic device 20 is intended to represent various forms of digital computers, such as laptops, desktops, workstations, personal digital assistants, servers, blade servers, mainframes, and other appropriate computers. Electronic device 20 may also represent various forms of mobile equipment, such as personal digital assistants, cellular telephones, smartphones, wearable devices (e.g., helmets, eyeglasses, watches, etc.), and other similar computing equipment. The components shown herein, their connections and relationships, and their functions, are meant to be exemplary only, and are not meant to limit implementations of the inventions described and/or claimed herein.
As shown in fig. 5, the electronic device 20 includes at least one processor 21, and a memory, such as a Read Only Memory (ROM) 22, a Random Access Memory (RAM) 23, etc., communicatively connected to the at least one processor 21, wherein the memory stores a computer program executable by the at least one processor, and the processor 21 can perform various suitable actions and processes according to the computer program stored in the Read Only Memory (ROM) 22 or the computer program loaded from the storage unit 28 into the Random Access Memory (RAM) 23. In the RAM 23, various programs and data required for the operation of the electronic device 20 may also be stored. The processor 21, the ROM 22 and the RAM 23 are connected to each other via a bus 24. An input/output (I/O) interface 25 is also connected to bus 24.
Various components in the electronic device 20 are connected to the I/O interface 25, including: an input unit 26 such as a keyboard, a mouse, etc.; an output unit 27 such as various types of displays, speakers, and the like; a storage unit 28 such as a magnetic disk, an optical disk, or the like; and a communication unit 29 such as a network card, modem, wireless communication transceiver, etc. The communication unit 29 allows the electronic device 20 to exchange information/data with other devices via a computer network, such as the internet, and/or various telecommunication networks.
The processor 21 may be a variety of general and/or special purpose processing components having processing and computing capabilities. Some examples of processor 21 include, but are not limited to, a Central Processing Unit (CPU), a Graphics Processing Unit (GPU), various specialized Artificial Intelligence (AI) computing chips, various processors running machine learning model algorithms, digital Signal Processors (DSPs), and any suitable processor, controller, microcontroller, etc. The processor 21 performs the various methods and processes described above, such as the data processing method corresponding to the fusion database system.
In some embodiments, the corresponding data processing method of the fusion database system may be implemented as a computer program tangibly embodied on a computer-readable storage medium, such as a storage unit. In some embodiments, part or all of the computer program may be loaded and/or installed onto the data manipulation audit system via the ROM and/or the communication unit. When the computer program is loaded into RAM and executed by a processor, one or more steps of the data processing method corresponding to the fusion database system described above may be performed. Alternatively, in other embodiments, the processor may be configured to perform the corresponding data processing method of the fusion database system in any other suitable manner (e.g., by means of firmware).
Various implementations of the systems and techniques described here above may be implemented in digital electronic circuitry, integrated circuit systems, field Programmable Gate Arrays (FPGAs), application Specific Integrated Circuits (ASICs), application Specific Standard Products (ASSPs), systems On Chip (SOCs), load programmable logic devices (CPLDs), computer hardware, firmware, software, and/or combinations thereof. These various embodiments may include: implemented in one or more computer programs, the one or more computer programs may be executed and/or interpreted on a programmable system including at least one programmable processor, which may be a special purpose or general-purpose programmable processor, that may receive data and instructions from, and transmit data and instructions to, a storage system, at least one input device, and at least one output device.
A computer program for carrying out methods of the present invention may be written in any combination of one or more programming languages. These computer programs may be provided to a processor of a general purpose computer, special purpose computer, or other programmable data processing apparatus, such that the computer programs, when executed by the processor, cause the functions/acts specified in the flowchart and/or block diagram block or blocks to be implemented. The computer program may execute entirely on the machine, partly on the machine, as a stand-alone software package, partly on the machine and partly on a remote machine or entirely on the remote machine or server.
In the context of the present invention, a computer-readable storage medium may be a tangible medium that can contain, or store a computer program for use by or in connection with an instruction execution system, apparatus, or device. The computer readable storage medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any suitable combination of the foregoing. Alternatively, the computer readable storage medium may be a machine readable signal medium. More specific examples of a machine-readable storage medium would include an electrical connection based on one or more wires, 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), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.
To provide for interaction with a user, the systems and techniques described here can be implemented on an electronic device having: a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to a user; and a keyboard and a pointing device (e.g., a mouse or a trackball) through which a user can provide input to the electronic device. Other kinds of devices may also be used to provide for interaction with a user; for example, feedback provided to the user may be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user may be received in any form, including acoustic input, speech input, or tactile input.
The systems and techniques described here can be implemented in a computing system that includes a background component (e.g., as a data server), or that includes a middleware component (e.g., an application server), or that includes a front-end component (e.g., a user computer having a graphical user interface or a web browser through which a user can interact with an implementation of the systems and techniques described here), or any combination of such background, middleware, or front-end components. The components of the system can be interconnected by any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include: local Area Networks (LANs), wide Area Networks (WANs), blockchain networks, and the internet.
The computing system may include clients and servers. The client and server are typically remote from each other and typically interact through a communication network. The relationship of client and server arises by virtue of computer programs running on the respective computers and having a client-server relationship to each other. The server can be a cloud server, also called a cloud computing server or a cloud host, and is a host product in a cloud computing service system, so that the defects of high management difficulty and weak service expansibility in the traditional physical hosts and VPS service are overcome.
It should be appreciated that various forms of the flows shown above may be used to reorder, add, or delete steps. For example, the steps described in the present invention may be performed in parallel, sequentially, or in a different order, so long as the desired results of the technical solution of the present invention are achieved, and the present invention is not limited herein.
The above embodiments do not limit the scope of the present invention. It will be apparent to those skilled in the art that various modifications, combinations, sub-combinations and alternatives are possible, depending on design requirements and other factors. Any modifications, equivalent substitutions and improvements made within the spirit and principles of the present invention should be included in the scope of the present invention.
Claims (10)
1. The fusion database system is characterized by comprising a real-time database, a relational database and a data maintenance module; the real-time data table in the real-time database is consistent with the relationship data table in the relationship database in structure, and the relationship data table is an extension table of the real-time data table;
the data maintenance module is used for receiving the real-time data to be updated and sending the real-time data to be updated to the real-time database;
the real-time database is used for updating the real-time data table according to the real-time data to be updated, generating a new real-time data table, synchronizing the number information in the new real-time data table into the relational database, and feeding back the new real-time data table to the data maintenance module;
the data maintenance module is further configured to receive relationship data to be updated, determine a corresponding relationship between the relationship data to be updated and the number information in the new real-time data table, and send the relationship data to be updated including the corresponding relationship to the relationship database;
the relational database is used for updating the number information into the relational data table when the number information is received;
and the relational database is also used for updating the relational data to be updated into the relational data table according to the corresponding relation and the number information in the relational data to be updated after the relational data to be updated is received.
2. The system of claim 1, wherein the real-time database comprises a maintenance sub-database and a run sub-database;
the maintenance sub-database is used for updating the real-time data table according to the real-time data to be updated, generating a real-time data table to be issued, and sending the real-time data table to be issued to the operation sub-database when receiving an issue instruction;
the operation sub-database is used for storing the real-time data table to be distributed as a new real-time data table after receiving the real-time data table to be distributed, synchronizing the number information in the new real-time data table into the relational database and feeding back the new real-time data table to the data maintenance module.
3. The system of claim 2, wherein the data maintenance module is further configured to:
and displaying a real-time data table at the current moment before receiving the real-time data to be updated or the relation data to be updated.
4. The system according to claim 2, wherein the data maintenance module is specifically configured to:
and receiving the real-time data to be updated and sending the real-time data to be updated to the maintenance sub-database.
5. A system according to claim 3, characterized in that the data maintenance module is specifically configured to:
and receiving a new real-time data table fed back by the operation sub-database, and updating the new real-time data table into the real-time data table at the current moment.
6. A system according to claim 3, wherein the real-time data table at the current time presented by the data maintenance module is in a read-only format prior to the receiving of the data to be updated.
7. The system according to claim 1, characterized in that the relational database is specifically configured to:
after the relationship data to be updated are received, determining relationship data corresponding to each numbered information in the relationship data to be updated according to the corresponding relationship in the relationship data to be updated and the numbered information;
and updating each relation data to the relation data table according to the relation field type and the number information of each relation data.
8. The system of claim 1, wherein the fusion database system further comprises: a data query module;
the data query module is used for receiving a data query instruction, generating a structured data query statement corresponding to the data query instruction, and determining a relational data field from the relational database through the structured data query statement;
the data query module is further configured to determine a real-time data field corresponding to the number information in the real-time database according to the number information corresponding to the relationship data field, splice the real-time data field with the relationship data field, and generate and display query data corresponding to the data query instruction.
9. The system of claim 1, wherein the fusion database system further comprises: a data table construction module;
the data table construction module is used for constructing an initial real-time data table in the real-time database and constructing an initial relation data table with the structure consistent with that of the initial real-time data table in the relation database;
the initial real-time data table comprises at least one preset real-time field type, and the initial relation data table comprises at least one preset relation field type.
10. An electronic device, the electronic device comprising:
at least one processor; and
a memory communicatively coupled to the at least one processor; wherein,,
the memory stores a computer program executable by the at least one processor to enable the at least one processor to perform the data processing method corresponding to the fusion database system of any one of claims 1-9.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310097378.7A CN116028517A (en) | 2023-02-07 | 2023-02-07 | Fusion database system and electronic equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310097378.7A CN116028517A (en) | 2023-02-07 | 2023-02-07 | Fusion database system and electronic equipment |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN116028517A true CN116028517A (en) | 2023-04-28 |
Family
ID=86073803
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202310097378.7A Pending CN116028517A (en) | 2023-02-07 | 2023-02-07 | Fusion database system and electronic equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN116028517A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117633059A (en) * | 2024-01-25 | 2024-03-01 | 广东广宇科技发展有限公司 | Data query method based on distributed database |
-
2023
- 2023-02-07 CN CN202310097378.7A patent/CN116028517A/en active Pending
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117633059A (en) * | 2024-01-25 | 2024-03-01 | 广东广宇科技发展有限公司 | Data query method based on distributed database |
| CN117633059B (en) * | 2024-01-25 | 2024-04-09 | 广东广宇科技发展有限公司 | Data query method based on distributed database |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112528067A (en) | Graph database storage method, graph database reading method, graph database storage device, graph database reading device and graph database reading equipment | |
| CN115408546A (en) | Time sequence data management method, device, equipment and storage medium | |
| CN116028517A (en) | Fusion database system and electronic equipment | |
| CN114064925A (en) | Knowledge graph construction method, data query method, device, equipment and medium | |
| CN115905322A (en) | Service processing method and device, electronic equipment and storage medium | |
| CN115329150A (en) | Method and device for generating search condition tree, electronic equipment and storage medium | |
| CN114168119B (en) | Code file editing method, device, electronic equipment and storage medium | |
| CN116226150A (en) | Data processing method, device, equipment and medium based on distributed database | |
| CN112887426B (en) | Information stream pushing method and device, electronic equipment and storage medium | |
| CN115454971A (en) | Data migration method and device, electronic equipment and storage medium | |
| CN114328739A (en) | Data synchronization method, data reading method, data synchronization device, data reading device, electronic equipment, storage medium and product | |
| CN113609145B (en) | Database processing method, device, electronic equipment, storage medium and product | |
| CN115687282A (en) | File synchronization method and device, electronic equipment and storage medium | |
| CN113569144B (en) | Method, device, equipment, storage medium and program product for searching promotion content | |
| CN113515504B (en) | Data management method, device, electronic equipment and storage medium | |
| CN117331994A (en) | Real-time processing method and device for data, electronic equipment and storage medium | |
| CN114942955A (en) | Data export method, device, export node, medium and system | |
| CN115203246A (en) | Linked list query method and device, electronic equipment and storage medium | |
| CN113850271A (en) | Online feature library construction method and device and electronic equipment | |
| CN117519680A (en) | File management page display method, device, equipment and storage medium | |
| CN115687529A (en) | Data synchronization method and device, electronic equipment and storage medium | |
| KR101482587B1 (en) | Information Providing Apparatus and Method using Entity Reference Path of Building and Infrastructure Information | |
| CN117609055A (en) | Data management method, device, electronic equipment and storage medium | |
| CN115454977A (en) | Data migration method, device, equipment and storage medium | |
| CN115495528A (en) | Distributed database statement execution method, device, equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |