CN115712622B - Electric power transaction data processing method, system, computer device and storage medium - Google Patents
Electric power transaction data processing method, system, computer device and storage medium Download PDFInfo
- Publication number
- CN115712622B CN115712622B CN202211454249.0A CN202211454249A CN115712622B CN 115712622 B CN115712622 B CN 115712622B CN 202211454249 A CN202211454249 A CN 202211454249A CN 115712622 B CN115712622 B CN 115712622B
- Authority
- CN
- China
- Prior art keywords
- data
- power transaction
- electric power
- transaction data
- main
- 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.)
- Active
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention belongs to the field of power system automation, and discloses a power transaction data processing method, a system, computer equipment and a storage medium, which comprises the steps of writing main identification data and characteristic identification data of power transaction data to be stored and power transaction data to be stored into a sub-table of a distributed memory bank as a transaction data record domain value, a main identification domain value and a characteristic identification domain value in a group of record data, realizing the storage of the power transaction data, and acquiring first target record data in a main table of a real-time bank according to the main identification data of the power transaction data to be accessed; acquiring first target record data in a sub-table of a distributed memory base according to main body identification data and feature identification data of electric power transaction data to be accessed; and reading the electric power transaction data according to the first target record data in the main table and the first target record data in the sub-table. The problem that the real-time library cannot realize flexible storage and access of multi-section power transaction data is solved.
Description
Technical Field
The invention belongs to the field of power system automation, and relates to a power transaction data processing method, a power transaction data processing system, computer equipment and a storage medium.
Background
For a long time, the regulation and control service of the power system is mainly provided with technical support by a regulation and control platform. The commercial library of the regulation and control platform stores full data, the real-time library is used as a basic core component of the regulation and control platform, the commercial library data is downloaded to a local memory for storage access, efficient real-time access of the regulation and control application data is achieved, and meanwhile flexible picture configuration display based on the real-time library data is achieved by means of a regulation and control platform configuration editing function. However, the regulation and control platform is mainly designed for the traditional regulation and control type service single-section characteristic data, namely, only one set of application data exists in the same model main body under a certain application, the multi-section data formed by the model main body under different dimensional parameters such as time and transaction sequences are applied to the electric power spot market type, the real-time library cannot realize simultaneous storage and access of multiple sets of data, and the regulation and control platform cannot effectively support storage and access of electric power transaction data.
For the storage and access of electric power transaction data, the conventional processing mode at present is to download inquired application data to a real-time library by modifying the download of the real-time library under the condition that the real-time library can only store single-section data, increasing time and transaction sequence parameters during the download, access the data of the real-time library in the transaction clearing calculation process, and store the transaction result of the current real-time library into a commercial relational database as a transaction result or case data after the clearing calculation is finished.
However, the spot transaction mode is different from the scheduling service of the planning mode, and when editing certain section data, the spot transaction mode needs to refer to other section data, and only the commercial library is directly accessed through the program customization interface or data of a designated time or transaction sequence is downloaded to the real-time library for viewing. The former needs to customize a program customization interface, the picture advantage of flexible configuration of a regulation and control platform is lost, time is spent on developing an application interface, in addition, the access efficiency of directly accessing a commercial library for data display is low, if other section data are downloaded again, the previously adjusted data must be stored in the commercial library, otherwise, the data are lost, so that the downloading and the storage are required for multiple times, the processing efficiency is reduced, and the comparison among different section data is difficult to realize.
Disclosure of Invention
The present invention is directed to overcome the above-mentioned shortcomings of the prior art, and provides a method, a system, a computer device and a storage medium for processing electric power transaction data.
In order to achieve the purpose, the invention adopts the following technical scheme to realize the purpose:
in a first aspect of the present invention, a method for processing power transaction data is provided, including: acquiring electric power transaction data to be stored, main body identification data of the electric power transaction data to be stored and characteristic identification data of the electric power transaction data to be stored; respectively writing the electric power transaction data to be stored, the main body identification data of the electric power transaction data to be stored and the characteristic identification data of the electric power transaction data to be stored into a sub-table of a distributed memory bank as a transaction data record domain value, a main body identification domain value and a characteristic identification domain value in a group of record data; acquiring and analyzing access information of the electric power transaction data to obtain main identification data of the electric power transaction data to be accessed and characteristic identification data of the electric power transaction data to be accessed; acquiring first target record data in a main table of a real-time library according to main body identification data of electric power transaction data to be accessed; the first target record data in the main table is record data of which the main identification domain value is the same as the main identification data of the electric power transaction data to be accessed in each record data in the main table; acquiring first target record data in a sub-table of a distributed memory bank according to main body identification data of the electric power transaction data to be accessed and characteristic identification data of the electric power transaction data to be accessed; the first target record data of the sub-table is record data, wherein a main identification domain value of each record data in the sub-table is the same as the main identification data of the electric power transaction data to be accessed, and a characteristic identification domain value of each record data is the same as the characteristic identification data of the electric power transaction data to be accessed; and obtaining the electric power transaction data to be accessed based on preset main key domain configuration information according to the first target record data in the main table and the first target record data in the sub-table.
Optionally, the feature identification data includes one or both of: time identification data and transaction sequence identification data.
Optionally, the obtaining the to-be-accessed electric power transaction data according to the first target record data in the main table and the first target record data in the sub-table based on the preset main key domain configuration information includes: obtaining a main key domain of the recorded data in the main table and a main key domain of the recorded data in the sub table based on preset main key domain configuration information; extracting a primary key domain value of first target record data in the primary table according to a primary key domain of the record data in the primary table to obtain first extraction information; extracting a main key domain value of first target record data in the sub-table according to the main key domain of the record data in the sub-table to obtain second extraction information; and combining the first extraction information and the second extraction information to obtain the electric power transaction data to be accessed.
Optionally, the method further includes: acquiring configuration information modification information of a main key domain; and modifying the preset primary key domain configuration information according to the primary key domain configuration information modification information.
Optionally, the method further includes: acquiring main body identification data and model information data of each currently applied model main body in a commercial library; traversing each currently applied model main body: and respectively writing the main body identification data and the model information data of the current model main body into a main table of the real-time library as a main body identification field value and a model information field value in a group of record data.
Optionally, the method further includes: acquiring main body identification data of the electric power transaction data to be issued and characteristic identification data of the electric power transaction data to be issued; acquiring second target record data in a main table of a real-time base according to main body identification data of the electric power transaction data to be issued; the second target record data in the main table is record data of which the main body identification domain value is the same as the main body identification data of the electric power transaction data to be issued in each record data in the main table; acquiring second target record data in a sub-table of the distributed memory base according to the main body identification data of the electric power transaction data to be issued and the characteristic identification data of the electric power transaction data to be issued; the second target record data of the sub-table is record data, wherein the main body identification domain value of each record data of the sub-table is the same as the main body identification data of the electric power transaction data to be issued, and the characteristic identification domain value of each record data of the sub-table is the same as the characteristic identification data of the electric power transaction data to be issued; and obtaining electric power transaction data to be issued and storing the electric power transaction data to be issued into a transaction result table of the commercial library based on preset main key domain configuration information according to the second target record data in the main table and the second target record data in the sub-table.
Optionally, the method further includes: acquiring main body identification data of case power transaction data to be stored and characteristic identification data of the case power transaction data to be stored; acquiring third target record data in a main table of a real-time base according to main body identification data of case power transaction data to be stored; the third target record data in the main table is record data of which the main identification domain value is the same as the main identification data of the case power transaction data to be stored in each record data in the main table; acquiring third target record data in a sub-table of a distributed memory base according to main body identification data of case power transaction data to be stored and characteristic identification data of the case power transaction data to be stored; the third target record data of the sub-table is record data, in each record data of the sub-table, of which the main identification domain value is the same as the main identification data of the case electric power transaction data to be stored and the characteristic identification domain value is the same as the characteristic identification data of the case electric power transaction data to be stored; obtaining case electric power transaction data to be stored based on preset main key domain configuration information according to third target record data in the main table and third target record data in the sub-table; and generating case identification data of the case power transaction data to be stored, and storing the case power transaction data to be stored and the case identification data of the case power transaction data to be stored into a case result table of a commercial library.
In a second aspect of the present invention, there is provided a power transaction data processing system, including: the first data acquisition module is used for acquiring the electric power transaction data to be stored, the main body identification data of the electric power transaction data to be stored and the characteristic identification data of the electric power transaction data to be stored; the data writing module is used for respectively writing the electric power transaction data to be stored, the main body identification data of the electric power transaction data to be stored and the characteristic identification data of the electric power transaction data to be stored into a sub-table of the distributed memory bank as a transaction data record threshold value, a main body identification threshold value and a characteristic identification threshold value in a group of record data; the second data acquisition module is used for acquiring and analyzing the access information of the electric power transaction data to obtain main identification data of the electric power transaction data to be accessed and characteristic identification data of the electric power transaction data to be accessed; the first retrieval module is used for acquiring first target record data in a main table of a real-time base according to main body identification data of the electric power transaction data to be accessed; the first target record data in the main table is record data of which the main body identification domain value is the same as the main body identification data of the electric power transaction data to be accessed in each record data in the main table; the second retrieval module is used for acquiring first target record data in a sub-table of the distributed memory bank according to the main body identification data of the electric power transaction data to be accessed and the characteristic identification data of the electric power transaction data to be accessed; the first target record data of the sub-table is record data, in each record data of the sub-table, of which the main identification domain value is the same as the main identification data of the electric power transaction data to be accessed and the characteristic identification domain value is the same as the characteristic identification data of the electric power transaction data to be accessed; and the data reading module is used for obtaining the electric power transaction data to be accessed based on preset main key domain configuration information according to the first target record data in the main table and the first target record data in the sub-table.
In a third aspect of the present invention, there is provided a computer device comprising a memory, a processor and a computer program stored in the memory and executable on the processor, wherein the processor implements the steps of the power transaction data processing method when executing the computer program.
In a fourth aspect of the present invention, a computer-readable storage medium is provided, which stores a computer program, and the computer program, when executed by a processor, implements the steps of the above-mentioned power transaction data processing method.
Compared with the prior art, the invention has the following beneficial effects:
the electric power transaction data processing method introduces the distributed memory banks, stores multi-section electric power transaction data through the sub-tables of the distributed memory banks, and fully utilizes the characteristic that the storage capacity of the distributed memory banks is transversely expandable to realize the rapid storage of the multi-section electric power transaction data. Meanwhile, based on the mixed main sub-table storage structure of the main table of the real-time library and the sub-tables of the distributed memory banks, on the premise of not accessing the commercial library, flexible reading of any single-section electric power transaction data can be achieved only by accessing the real-time library and the distributed memory banks, the form of the electric power transaction data is consistent with that of the existing access data of the regulation and control platform, further, the configuration editing picture data service calling difference of the regulation and control platform is effectively shielded, the configuration editing picture advantages of the regulation and control platform are reserved, and a development interface does not need to be customized.
Drawings
Fig. 1 is a flowchart of a power transaction data processing method according to an embodiment of the present invention.
Fig. 2 is a block diagram of a power transaction data processing system according to an embodiment of the invention.
Detailed Description
In order to make the technical solutions of the present invention better understood, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
It should be noted that the terms "first," "second," and the like in the description and claims of the present invention and in the drawings described above are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used is interchangeable under appropriate circumstances such that the embodiments of the invention described herein are capable of operation in other sequences than those illustrated or 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.
First, related terms involved in the embodiments of the present invention are described:
real-time library: a regulation and control platform is a local memory database.
Distributed memory banks: a database based on distributed memory storage is somewhat inferior in performance but has better lateral expansion capability than a real-time library.
Commercial libraries: the regulation and control platform adopts a commercial library to store all data of the application, including model information data and all application data of all model main bodies.
Single section data: after a certain application table is downloaded from a commercial library to a real-time library, only one set of application data is stored and accessed by the same model main body in the table in the real-time library at any time.
Multi-section data: after a table is loaded from a commercial library into a memory library, the same model entity in the table can store and access multiple sets of application data at any time in the memory library.
Subject identification data: a model principal, such as a market member, a generator set, a trading unit, etc., is identified.
Time identification data: the transaction time is identified, such as a day in the spot-time transaction, a time point in the real-time spot-time transaction, etc.
Transaction sequence identification data: to identify a certain transaction of the electricity transaction operator organisation.
Case identification data: when a certain case is marked, for example, the clearing calculation can be carried out according to different input conditions when the transaction is cleared, the calculation result can be stored as a case each time, and different cases can be compared and analyzed.
The invention is described in further detail below with reference to the accompanying drawings:
referring to fig. 1, in an embodiment of the present invention, a distributed memory bank is introduced on the basis of a real-time bank, and the real-time bank and the distributed memory bank are associated with each other through main body identification data to form a mixed main sub-table storage structure, so as to implement flexible storage and access of multi-section data of an electric power transaction.
Specifically, the electric power transaction data processing method comprises the following steps:
s1: the method comprises the steps of obtaining electric power transaction data to be stored, main body identification data of the electric power transaction data to be stored and feature identification data of the electric power transaction data to be stored.
S2: and respectively writing the electric power transaction data to be stored, the main body identification data of the electric power transaction data to be stored and the characteristic identification data of the electric power transaction data to be stored into the sub-table of the distributed memory bank as a transaction data record domain value, a main body identification domain value and a characteristic identification domain value in a group of record data.
S3: and acquiring and analyzing the access information of the electric power transaction data to obtain main identification data of the electric power transaction data to be accessed and characteristic identification data of the electric power transaction data to be accessed.
S4: acquiring first target record data in a main table of a real-time library according to main body identification data of electric power transaction data to be accessed; the first target record data in the main table is record data, of all record data in the main table, of which the main identification domain value is the same as the main identification data of the electric power transaction data to be accessed.
S5: acquiring first target record data in a sub-table of a distributed memory base according to main body identification data of the electric power transaction data to be accessed and characteristic identification data of the electric power transaction data to be accessed; the first target record data of the sub-table is record data, in each record data of the sub-table, a main identification domain value is the same as main identification data of the electric power transaction data to be accessed, and a characteristic identification domain value is the same as characteristic identification data of the electric power transaction data to be accessed.
S6: and obtaining the electric power transaction data to be accessed based on preset main key domain configuration information according to the first target record data in the main table and the first target record data in the sub-table.
Specifically, the electric power transaction data processing method is realized by depending on the main table of the real-time base and the sub-tables of the distributed memory base when being implemented. The data structure of the record data of the main table at least includes a main body identification field and a model information field, and of course, other customized fields may also be included, and except that the main body identification field value cannot be null, the values of other fields may be null. The data structure of the record data of the sub-table at least comprises a main body identification field, a characteristic identification field and a transaction data record field.
And constructing a main table by using the real-time library, and storing the model information data downloaded from the commercial relational library. The real-time library mainly stores model information of each applied model main body, the record number is relatively fixed, a main table of the real-time library can download and add record data to data of a commercial library when application initialization is carried out, and one model main body corresponds to one group of record data, so that model information data of a single section are stored in the main table.
The method comprises the steps of utilizing a distributed memory bank to construct a sub-table, storing electric power transaction data to be stored, wherein the electric power transaction data are generated by application operation, recording data of the sub-table of the distributed memory bank are written into data with specified feature identifications by an application, and when the data are written, different feature identifications correspond to different recording data, so that multi-section electric power transaction data are stored in the sub-table.
The main table and the sub tables are related through a main body identification domain value corresponding to a multi-section form of the electric power transaction data, and the recorded data between the main table and the sub tables are in a one-to-many relation. That is, there is only one set of record data in the main table per model body under any application; and the group number of the recorded data of each model main body in the sub-table is the total number of the characteristic identifications, so that the mixed storage of the multi-section electric power transaction data in the main table and the sub-table is realized.
The primary key domain configuration information is used to define which domains in the primary and sub tables are primary key domains, thereby determining that data is read only from the primary key domains of the primary and sub tables at the time of subsequent data reading.
Based on the configuration, when the electric power transaction data is stored and read, the electric power transaction data can be flexibly accessed by accessing the corresponding data of the feature identifier according to different feature identifiers without accessing the commercial database and only by accessing the main table in the real-time database and the sub-tables in the distributed memory database.
In summary, the electric power transaction data processing method of the present invention introduces the distributed memory banks, stores the electric power transaction data with multiple sections through the sub-tables of the distributed memory banks, and makes full use of the characteristic that the storage capacity of the distributed memory banks is laterally expandable, thereby implementing fast storage of the electric power transaction data with multiple sections. Meanwhile, based on the mixed main sub-table storage structure of the main table of the real-time library and the sub-tables of the distributed memory banks, on the premise of not accessing the commercial library, flexible reading of any single-section electric power transaction data can be achieved only by accessing the real-time library and the distributed memory banks, the form of the electric power transaction data is consistent with that of the existing access data of the regulation and control platform, further, the configuration editing picture data service calling difference of the regulation and control platform is effectively shielded, the configuration editing picture advantages of the regulation and control platform are reserved, and a development interface does not need to be customized.
In one possible embodiment, the feature identification data includes one or both of: time identification data and transaction sequence identification data.
Specifically, based on the nature of the power transaction data, the present embodiment considers two characteristics, i.e., time and transaction sequence, such as the number of transactions, but of course, other characteristics may be set based on actual needs.
In a possible implementation manner, the obtaining the to-be-accessed electric power transaction data based on the preset primary key domain configuration information according to the first target record data in the primary table and the first target record data in the sub-table includes: obtaining a main key domain of the recorded data in the main table and a main key domain of the recorded data in the sub table based on preset main key domain configuration information; extracting a primary key domain value of first target record data in the primary table according to a primary key domain of the record data in the primary table to obtain first extraction information; extracting a main key domain value of first target record data in the sub-table according to the main key domain of the record data in the sub-table to obtain second extraction information; and combining the first extraction information and the second extraction information to obtain the electric power transaction data to be accessed.
In this embodiment, the primary key domain configuration information may be preset in a manner of a primary key domain configuration table. For example, the main body identification field and the model information field in the main table may be configured as the main key field of the main table, and the transaction data record field, the main body identification field, and the feature identification field in the sub table may be configured as the main key field of the sub table. And, when data is read, it is defined that data is read only from the corresponding primary key field regardless of whether the data is recorded in the primary table or the data is recorded in the secondary table. For example, for record data in the main table, a subject identification field value and a model information field value are read, and for record data in the sub table, a transaction data record field value, a subject identification field value, and a feature identification field value are read.
In one possible embodiment, the power transaction data processing method further includes: acquiring configuration information modification information of a main key domain; and modifying the preset primary key domain configuration information according to the primary key domain configuration information modification information.
Specifically, for different data access requirements, corresponding data may be selectively read from the main table or the sub table, and in this case, the preset main key domain configuration information is modified through the main key domain configuration information modification information, so that a domain in which data needs to be read can be set as the main key domain in the corresponding table, and correct reading of the data is achieved.
In one possible embodiment, the power transaction data processing method further includes: acquiring main body identification data and model information data of each currently applied model main body in a commercial library; traversing each currently applied model main body: and respectively writing the main body identification data and the model information data of the current model main body into a main table of the real-time library as a main body identification field value and a model information field value in a group of record data.
Specifically, this step is an initialization process, when the application is initialized and started, the main body identification data and the model information data of each currently applied model main body in the commercial library are downloaded to the real-time library, and then stored according to the structure of the main table in the real-time library, that is, the main body identification data and the model information data of the model main body are written into the main table of the real-time library as the main body identification field value and the model information field value in a set of record data, respectively.
In one possible embodiment, the power transaction data processing method further includes: acquiring main body identification data of the electric power transaction data to be issued and characteristic identification data of the electric power transaction data to be issued; acquiring second target record data in a main table of a real-time base according to main body identification data of the electric power transaction data to be issued; the second target record data in the main table is record data of which the main body identification domain value is the same as the main body identification data of the electric power transaction data to be issued in each record data in the main table; acquiring second target record data in a sub-table of the distributed memory base according to the main body identification data of the electric power transaction data to be issued and the characteristic identification data of the electric power transaction data to be issued; the second target record data of the sub-table is record data, in each record data of the sub-table, of which the main body identification domain value is the same as the main body identification data of the electric power transaction data to be issued and the characteristic identification domain value is the same as the characteristic identification data of the electric power transaction data to be issued; and obtaining electric power transaction data to be issued and storing the electric power transaction data to be issued into a transaction result table of the commercial library based on preset main key domain configuration information according to the second target record data in the main table and the second target record data in the sub-table.
Specifically, when the data release is needed after the electric power transaction is completed, corresponding electric power transaction data to be released is extracted from the mixed main and sub table storage structure based on the main body identification data and the characteristic identification data of the electric power transaction data to be released, and then the electric power transaction data to be released is stored in a transaction result table of a commercial library, so that the stable storage and the subsequent external release of the data are facilitated.
In addition, in the commercial library, in addition to storing the transaction result table, some transaction cases are also generally stored for performing comparative analysis between cases for subsequent transaction analysis and other work.
Based on this, in one possible implementation, the electric power transaction data processing method further includes: acquiring main body identification data of case power transaction data to be stored and characteristic identification data of the case power transaction data to be stored; acquiring third target record data in a main table of a real-time base according to main body identification data of case power transaction data to be stored; the third target record data in the main table is record data of which the main identification domain value is the same as the main identification data of the case power transaction data to be stored in each record data in the main table; acquiring third target record data in a sub-table of a distributed memory base according to main body identification data of case power transaction data to be stored and characteristic identification data of the case power transaction data to be stored; the third target record data of the sub-table is record data, in each record data of the sub-table, of which the main identification domain value is the same as the main identification data of the case electric power transaction data to be stored and the characteristic identification domain value is the same as the characteristic identification data of the case electric power transaction data to be stored; obtaining the electric power transaction data of the case to be stored based on preset primary key domain configuration information according to the third target record data in the primary table and the third target record data in the sub-table; and generating case identification data of the case power transaction data to be stored, and storing the case power transaction data to be stored and the case identification data of the case power transaction data to be stored into a case result table of a commercial library.
The following are embodiments of the apparatus of the present invention that may be used to perform embodiments of the method of the present invention. For details not disclosed in the device embodiments, reference is made to the method embodiments of the invention.
Referring to fig. 2, in a further embodiment of the present invention, an electric power transaction data processing system is provided, which can be used for implementing the electric power transaction data processing method described above, and specifically, the electric power transaction data processing system includes a first data obtaining module, a data writing module, a second data obtaining module, a first retrieving module, a second retrieving module, and a data reading module.
The first data acquisition module is used for acquiring the electric power transaction data to be stored, main identification data of the electric power transaction data to be stored and characteristic identification data of the electric power transaction data to be stored; the data writing module is used for writing the electric power transaction data to be stored, the main body identification data of the electric power transaction data to be stored and the characteristic identification data of the electric power transaction data to be stored into a sub-table of the distributed memory bank as a transaction data record domain value, a main body identification domain value and a characteristic identification domain value in a group of record data respectively; the second data acquisition module is used for acquiring and analyzing the access information of the electric power transaction data to obtain main identification data of the electric power transaction data to be accessed and characteristic identification data of the electric power transaction data to be accessed; the first retrieval module is used for acquiring first target record data in a main table of a real-time library according to main body identification data of the electric power transaction data to be accessed; the first target record data in the main table is record data of which the main body identification domain value is the same as the main body identification data of the electric power transaction data to be accessed in each record data in the main table; the second retrieval module is used for acquiring first target record data in a sub-table of the distributed memory bank according to the main body identification data of the electric power transaction data to be accessed and the characteristic identification data of the electric power transaction data to be accessed; the first target record data of the sub-table is record data, in each record data of the sub-table, of which the main identification domain value is the same as the main identification data of the electric power transaction data to be accessed and the characteristic identification domain value is the same as the characteristic identification data of the electric power transaction data to be accessed; the data reading module is used for obtaining electric power transaction data to be accessed based on preset main key domain configuration information according to the first target record data in the main table and the first target record data in the sub-table.
In one possible embodiment, the feature identification data includes one or both of: time identification data and transaction sequence identification data.
In a possible implementation manner, the data reading module is specifically configured to: obtaining a main key domain of the recorded data in the main table and a main key domain of the recorded data in the sub table based on preset main key domain configuration information; extracting a primary key domain value of first target record data in the primary table according to a primary key domain of the record data in the primary table to obtain first extraction information; extracting a main key domain value of first target record data in the sub-table according to the main key domain of the record data in the sub-table to obtain second extraction information; and combining the first extraction information and the second extraction information to obtain the electric power transaction data to be accessed.
In a possible implementation manner, the power transaction data processing system further comprises a configuration information modification module, configured to obtain primary key domain configuration information modification information; and modifying the preset primary key domain configuration information according to the primary key domain configuration information modification information.
In a possible implementation manner, the electric power transaction data processing system further includes a main table initialization module, configured to obtain main body identification data and model information data of each model main body currently applied in the commercial library; traversing each currently applied model main body: and respectively writing the main body identification data and the model information data of the current model main body into a main table of the real-time library as a main body identification field value and a model information field value in a group of record data.
In a possible implementation manner, the electric power transaction data processing system further includes a result processing module, configured to obtain main body identification data of the electric power transaction data to be issued and feature identification data of the electric power transaction data to be issued; acquiring second target record data in a main table of a real-time base according to main body identification data of the electric power transaction data to be issued; the second target record data in the main table is record data of which the main body identification domain value is the same as the main body identification data of the electric power transaction data to be issued in each record data in the main table; acquiring second target record data in a sub-table of the distributed memory base according to the main body identification data of the electric power transaction data to be issued and the characteristic identification data of the electric power transaction data to be issued; the second target record data of the sub-table is record data, in each record data of the sub-table, of which the main body identification domain value is the same as the main body identification data of the electric power transaction data to be issued and the characteristic identification domain value is the same as the characteristic identification data of the electric power transaction data to be issued; and obtaining electric power transaction data to be issued and storing the electric power transaction data to be issued into a transaction result table of the commercial library based on preset main key domain configuration information according to the second target record data in the main table and the second target record data in the sub-table.
In a possible implementation manner, the electric power transaction data processing system further comprises a case processing module, configured to obtain subject identification data of the case electric power transaction data to be stored and feature identification data of the case electric power transaction data to be stored; acquiring third target record data in a main table of a real-time base according to main body identification data of case power transaction data to be stored; the third target record data in the main table is record data of which the main identification domain value is the same as the main identification data of the case power transaction data to be stored in each record data in the main table; acquiring third target record data in a sub-table of a distributed memory base according to main body identification data of case power transaction data to be stored and characteristic identification data of the case power transaction data to be stored; the third target record data of the sub-table is record data, in each record data of the sub-table, of which the main identification domain value is the same as the main identification data of the case electric power transaction data to be stored and the characteristic identification domain value is the same as the characteristic identification data of the case electric power transaction data to be stored; obtaining case electric power transaction data to be stored based on preset main key domain configuration information according to third target record data in the main table and third target record data in the sub-table; and generating case identification data of the case power transaction data to be stored, and storing the case power transaction data to be stored and the case identification data of the case power transaction data to be stored into a case result table of a commercial library.
All relevant contents of each step related to the embodiment of the power transaction data processing method can be referred to the functional description of the functional module corresponding to the power transaction data processing system in the embodiment of the present invention, and are not described herein again. The division of the modules in the embodiments of the present invention is schematic, and only one logical function division is provided, and in actual implementation, there may be another division manner, and in addition, each functional module in each embodiment of the present invention may be integrated in one processor, or may exist alone physically, or two or more modules are integrated in one module. The integrated module can be realized in a hardware mode, and can also be realized in a software functional module mode.
In yet another embodiment of the present invention, a computer device is provided that includes a processor and a memory for storing a computer program comprising program instructions, the processor for executing the program instructions stored by the computer storage medium. The Processor may be a Central Processing Unit (CPU), or may be other general purpose Processor, a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), a Field-Programmable gate array (FPGA) or other Programmable logic device, discrete gate or transistor logic device, discrete hardware component, etc., which is a computing core and a control core of the terminal, and is specifically adapted to load and execute one or more instructions in a computer storage medium to implement a corresponding method flow or a corresponding function; the processor according to the embodiment of the present invention may be used for the operation of the power transaction data processing method according to the above embodiment.
In still another embodiment of the present invention, the present invention further provides a storage medium, specifically a computer-readable storage medium, which is a memory device in a computer device, for storing a program and data. It is understood that the computer readable storage medium herein can include both built-in storage media in the computer device and, of course, extended storage media supported by the computer device. The computer-readable storage medium provides a storage space storing an operating system of the terminal. Also, one or more instructions, which may be one or more computer programs (including program code), are stored in the memory space and are adapted to be loaded and executed by the processor. It should be noted that the computer-readable storage medium may be a high-speed RAM memory, or may be a non-volatile memory (non-volatile memory), such as at least one disk memory. One or more instructions stored in the computer-readable storage medium may be loaded and executed by the processor to implement the corresponding steps of the data processing method related to power transaction in the above-described embodiments.
As will be appreciated by one skilled in the art, embodiments of the present invention may be provided as a method, system, or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present invention is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems) and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
Finally, it should be noted that: the above embodiments are only for illustrating the technical solutions of the present invention and not for limiting the same, and although the present invention is described in detail with reference to the above embodiments, those of ordinary skill in the art should understand that: modifications and equivalents may be made to the embodiments of the invention without departing from the spirit and scope of the invention, which is to be covered by the claims.
Claims (10)
1. A power transaction data processing method is characterized by comprising the following steps:
acquiring electric power transaction data to be stored, main body identification data of the electric power transaction data to be stored and characteristic identification data of the electric power transaction data to be stored;
respectively writing the electric power transaction data to be stored, the main body identification data of the electric power transaction data to be stored and the characteristic identification data of the electric power transaction data to be stored into a sub-table of a distributed memory bank as a transaction data record domain value, a main body identification domain value and a characteristic identification domain value in a group of record data;
acquiring and analyzing access information of the electric power transaction data to obtain main identification data of the electric power transaction data to be accessed and characteristic identification data of the electric power transaction data to be accessed;
acquiring first target record data in a main table of a real-time library according to main body identification data of electric power transaction data to be accessed; the first target record data in the main table is record data of which the main body identification domain value is the same as the main body identification data of the electric power transaction data to be accessed in each record data in the main table;
acquiring first target record data in a sub-table of a distributed memory base according to main body identification data of the electric power transaction data to be accessed and characteristic identification data of the electric power transaction data to be accessed; the first target record data of the sub-table is record data, in each record data of the sub-table, of which the main identification domain value is the same as the main identification data of the electric power transaction data to be accessed and the characteristic identification domain value is the same as the characteristic identification data of the electric power transaction data to be accessed;
and obtaining the electric power transaction data to be accessed based on preset primary key domain configuration information according to the first target record data in the primary table and the first target record data in the sub-table.
2. The power transaction data processing method of claim 1, wherein the feature identification data comprises one or both of: time identification data and transaction sequence identification data.
3. The electric power transaction data processing method according to claim 1, wherein the obtaining the electric power transaction data to be accessed based on the preset primary key domain configuration information according to the first target record data in the primary table and the first target record data in the sub-table comprises:
obtaining a main key domain of the recorded data in the main table and a main key domain of the recorded data in the sub table based on preset main key domain configuration information;
extracting a primary key domain value of first target record data in the primary table according to a primary key domain of the record data in the primary table to obtain first extraction information;
extracting a main key domain value of first target record data in the sub-table according to the main key domain of the record data in the sub-table to obtain second extraction information;
and combining the first extraction information and the second extraction information to obtain the electric power transaction data to be accessed.
4. The electric power transaction data processing method according to claim 1, further comprising:
acquiring configuration information modification information of a main key domain;
and modifying the preset primary key domain configuration information according to the primary key domain configuration information modification information.
5. The electric power transaction data processing method according to claim 1, further comprising:
acquiring main body identification data and model information data of each currently applied model main body in a commercial library;
traversing each currently applied model main body: and respectively writing the main body identification data and the model information data of the current model main body into a main table of the real-time library as a main body identification field value and a model information field value in a group of record data.
6. The electric power transaction data processing method according to claim 1, further comprising:
acquiring main body identification data of the electric power transaction data to be issued and characteristic identification data of the electric power transaction data to be issued;
acquiring second target record data in a main table of a real-time base according to main body identification data of the electric power transaction data to be issued; the second target record data in the main table is record data of which the main body identification domain value is the same as the main body identification data of the electric power transaction data to be issued in each record data in the main table;
acquiring second target record data in a sub-table of the distributed memory base according to the main body identification data of the electric power transaction data to be issued and the characteristic identification data of the electric power transaction data to be issued; the second target record data of the sub-table is record data, in each record data of the sub-table, of which the main body identification domain value is the same as the main body identification data of the electric power transaction data to be issued and the characteristic identification domain value is the same as the characteristic identification data of the electric power transaction data to be issued;
and obtaining electric power transaction data to be issued and storing the electric power transaction data to be issued into a transaction result table of the commercial library based on preset main key domain configuration information according to the second target record data in the main table and the second target record data in the sub-table.
7. The electric power transaction data processing method according to claim 1, further comprising:
acquiring main body identification data of case power transaction data to be stored and characteristic identification data of the case power transaction data to be stored;
acquiring third target record data in a main table of a real-time base according to main body identification data of case power transaction data to be stored; the third target record data in the main table is record data of which the main identification domain value is the same as the main identification data of the case power transaction data to be stored in each record data in the main table;
acquiring third target record data in a sub-table of a distributed memory base according to main body identification data of case power transaction data to be stored and characteristic identification data of the case power transaction data to be stored; the third target record data of the sub-table is record data, in each record data of the sub-table, of which the main identification domain value is the same as the main identification data of the case electric power transaction data to be stored and the characteristic identification domain value is the same as the characteristic identification data of the case electric power transaction data to be stored;
obtaining case electric power transaction data to be stored based on preset main key domain configuration information according to third target record data in the main table and third target record data in the sub-table;
and generating case identification data of the case power transaction data to be stored, and storing the case power transaction data to be stored and the case identification data of the case power transaction data to be stored into a case result table of a commercial library.
8. A power transaction data processing system, comprising:
the first data acquisition module is used for acquiring the electric power transaction data to be stored, the main body identification data of the electric power transaction data to be stored and the characteristic identification data of the electric power transaction data to be stored;
the data writing module is used for writing the electric power transaction data to be stored, the main body identification data of the electric power transaction data to be stored and the characteristic identification data of the electric power transaction data to be stored into the sub-tables of the distributed memory bank respectively as a transaction data record domain value, a main body identification domain value and a characteristic identification domain value in a group of record data;
the second data acquisition module is used for acquiring and analyzing the access information of the electric power transaction data to obtain main identification data of the electric power transaction data to be accessed and characteristic identification data of the electric power transaction data to be accessed;
the first retrieval module is used for acquiring first target record data in a main table of a real-time library according to main body identification data of the electric power transaction data to be accessed; the first target record data in the main table is record data of which the main body identification domain value is the same as the main body identification data of the electric power transaction data to be accessed in each record data in the main table;
the second retrieval module is used for acquiring first target record data in a sub-table of the distributed memory bank according to the main body identification data of the electric power transaction data to be accessed and the characteristic identification data of the electric power transaction data to be accessed; the first target record data of the sub-table is record data, wherein a main identification domain value of each record data in the sub-table is the same as the main identification data of the electric power transaction data to be accessed, and a characteristic identification domain value of each record data is the same as the characteristic identification data of the electric power transaction data to be accessed;
and the data reading module is used for obtaining the electric power transaction data to be accessed based on preset main key domain configuration information according to the first target record data in the main table and the first target record data in the sub-table.
9. A computer device comprising a memory, a processor and a computer program stored in the memory and executable on the processor, characterized in that the processor implements the steps of the power transaction data processing method according to any one of claims 1 to 7 when executing the computer program.
10. A computer-readable storage medium storing a computer program, wherein the computer program, when executed by a processor, implements the steps of the power transaction data processing method according to any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211454249.0A CN115712622B (en) | 2022-11-21 | 2022-11-21 | Electric power transaction data processing method, system, computer device and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211454249.0A CN115712622B (en) | 2022-11-21 | 2022-11-21 | Electric power transaction data processing method, system, computer device and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN115712622A CN115712622A (en) | 2023-02-24 |
| CN115712622B true CN115712622B (en) | 2023-03-28 |
Family
ID=85233932
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202211454249.0A Active CN115712622B (en) | 2022-11-21 | 2022-11-21 | Electric power transaction data processing method, system, computer device and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115712622B (en) |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2017173842A1 (en) * | 2016-04-05 | 2017-10-12 | 国电南瑞科技股份有限公司 | Method of partitioning and storing real-time distributed database in memory in energy management system |
| CN109918442A (en) * | 2019-01-24 | 2019-06-21 | 中国联合网络通信集团有限公司 | A kind of processing method and processing device of data |
Family Cites Families (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20120158650A1 (en) * | 2010-12-16 | 2012-06-21 | Sybase, Inc. | Distributed data cache database architecture |
| CN102737033B (en) * | 2011-03-31 | 2015-02-04 | 国际商业机器公司 | Data processing equipment and data processing method thereof |
| US9183271B2 (en) * | 2012-12-04 | 2015-11-10 | Pivotal Software, Inc. | Big-fast data connector between in-memory database system and data warehouse system |
| US11347705B2 (en) * | 2019-04-02 | 2022-05-31 | Sap Se | Supporting scalable distributed secondary index using replication engine for high-performance distributed database systems |
-
2022
- 2022-11-21 CN CN202211454249.0A patent/CN115712622B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2017173842A1 (en) * | 2016-04-05 | 2017-10-12 | 国电南瑞科技股份有限公司 | Method of partitioning and storing real-time distributed database in memory in energy management system |
| CN109918442A (en) * | 2019-01-24 | 2019-06-21 | 中国联合网络通信集团有限公司 | A kind of processing method and processing device of data |
Also Published As
| Publication number | Publication date |
|---|---|
| CN115712622A (en) | 2023-02-24 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9619512B2 (en) | Memory searching system and method, real-time searching system and method, and computer storage medium | |
| US11934371B2 (en) | Data processing method and apparatus, and computer-readable storage medium | |
| TW392113B (en) | File management method | |
| CN109821242A (en) | Map visualization edit methods and its system | |
| CN104714957A (en) | List structure changing method and device | |
| CN106802928B (en) | Power grid historical data management method and system | |
| CN110134646B (en) | Knowledge platform service data storage and integration method and system | |
| CN113641651A (en) | Business data management method, system and computer storage medium | |
| CN115712622B (en) | Electric power transaction data processing method, system, computer device and storage medium | |
| CN102906740B (en) | The method and system of packed data record and process packed data record | |
| CN109189343B (en) | Metadata disk-dropping method, device, equipment and computer-readable storage medium | |
| CN109032940B (en) | Test scene input method, device, equipment and storage medium | |
| CN113420097B (en) | Data analysis method, device, storage medium and server | |
| CN112632266B (en) | Data writing method and device, computer equipment and readable storage medium | |
| CN114297236A (en) | Data blood relationship analysis method, terminal equipment and storage medium | |
| CN110764777A (en) | ELF file generation method, ELF file, equipment and storage medium | |
| CN109379412A (en) | A kind of method and apparatus for deleting cloud host | |
| CN116893854B (en) | Method, device, equipment and storage medium for detecting conflict of instruction resources | |
| CN112035482B (en) | Service table partitioning method and device | |
| US8516415B1 (en) | Method and system for the condensed macro library creation | |
| CN118012847A (en) | Meta-model-based data model version management method, device, equipment and medium | |
| JP3120493B2 (en) | Data processing device | |
| CN117056343A (en) | Multi-source data management method and system in power grid field and electronic equipment | |
| CN117910955A (en) | Call management method, device, electronic equipment and storage medium | |
| CN112559331A (en) | Test method and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |