CN114428716A - Method and system for testing real-time database capacity, electronic equipment and storage medium - Google Patents

Abstract

The invention relates to a method, a system, electronic equipment and a storage medium for testing the capability of a real-time database, wherein the method comprises the following steps: calling real-time data from a real-time database and acquiring the data and data volume of the real-time data; calling historical data from a real-time database and acquiring data and data volume of the historical data; acquiring data and data volume of first data from a relational database according to a field corresponding to real-time data, and acquiring data and data volume of second data according to a field corresponding to historical data; determining the acquisition capacity of the real-time database by comparing the data and the data volume of the real-time data with the data and the data volume of the first data; and determining the storage capacity of the real-time database by comparing the data and the data amount of the historical data with the data and the data amount of the second data. The data and data volume in the real-time database and the relational database are compared to determine the acquisition capacity and the storage capacity of the real-time database, so that the problem that the acquisition capacity and the storage capacity of the real-time database cannot be determined is solved.

Description

Test method, system, electronic device and storage medium for real-time database capability

technical field

The invention relates to the technical field of computer software, in particular to a testing method, system, electronic device and storage medium for the capability of a real-time database.

Background technique

At present, the test of the real-time database acquisition function generally adopts the traditional method. The data is collected by connecting the collector software to the data simulator or the controller device, and then the data is uploaded and saved to the real-time database, and then the real-time data is queried and archived. The historical data is checked manually for correctness and completeness. However, because it is difficult to manually obtain the data of the collected data source for comparison, this method is difficult to determine the correctness and integrity of the collected data of the real-time database, and it is impossible to determine the collection capability and data storage capability of the real-time database.

The above-mentioned drawbacks are what those skilled in the art desire to overcome.

SUMMARY OF THE INVENTION

(1) Technical problems to be solved

In order to solve the above problems of the prior art, the present invention provides a method, system, electronic device and storage medium for testing the capability of a real-time database, aiming to solve the problem that the acquisition capability and data storage capability of the real-time database cannot be determined in the prior art. question.

(2) Technical solutions

In order to solve the above problems, in a first aspect, the present invention provides a method for testing real-time database capabilities, the method comprising:

Call the real-time data from the real-time database and obtain the data and data volume of the real-time data;

Call historical data from the real-time database and obtain the data and data volume of the historical data;

The data volume of the first data is obtained from the relational database according to the field corresponding to the real-time data, and the data volume of the second data is obtained according to the field corresponding to the historical data;

Determine the acquisition capability of the real-time database by comparing the data and data volume of the real-time data with the data and data volume of the first data;

The storage capacity of the real-time database is determined by comparing the data and data volume of the historical data with the data and data volume of the second data.

In an exemplary embodiment of the present invention, it also includes:

Obtain the test data source of real-time data and historical data through simulator simulation;

Collect the test data source simulated by the simulator through the collector software and push it to the real-time database to obtain real-time data and historical data;

The simulated test data source is written into the relational database, and stored as corresponding first data and second data according to structured fields.

In an exemplary embodiment of the present invention, the test data source for obtaining real-time data and historical data through simulator simulation further includes:

The data of the real-time data and the data of the historical data generated by the simulator are counted by the counter.

In an exemplary embodiment of the present invention, the test data source for obtaining real-time data and historical data through simulator simulation further includes:

The simulator simulates and simulates according to the business characteristics of the real-time database and the basic requirements of automated testing, and obtains the test data source;

The parameters in the test data source include at least one of data type, change period, waveform, and amplitude.

In an exemplary embodiment of the present invention, determining the acquisition capability of the real-time database by comparing the data and data volume of the real-time data with the data and data volume of the first data includes:

If the data volume of the real-time data is less than the data volume of the first data, it is determined that the acquisition capability of the real-time database is insufficient; and/or

If there is a difference in content between the data of the real-time data and the data of the first data, it is determined that the acquisition capability of the real-time database is insufficient.

In an exemplary embodiment of the present invention, the determining the storage capacity of the real-time database by comparing the data volume of the historical data and the data volume of the second data includes:

If the data volume of the historical data is smaller than the data volume of the second data, it is determined that the storage capacity of the real-time database is insufficient; and/or

If the data of the historical data and the data of the second data are different in content, it is determined that the storage capacity of the real-time database is insufficient.

In an exemplary embodiment of the present invention, it also includes:

Within a preset period, determine whether the acquisition capability and storage capability of the real-time database are based on the data and data volume of the real-time data, the data and data volume of the first data, the data and data volume of the historical data, and the data and data volume of the second data. meets the.

In a second aspect, the present invention also provides a test system for real-time database capabilities, the system comprising:

The real-time data module is used to call the real-time data from the real-time database and obtain the data and data volume of the real-time data;

The historical data module is used to call historical data from the real-time database and obtain the data and data volume of the historical data;

a relational data module, configured to obtain the data volume of the first data from the relational database according to the field corresponding to the real-time data, and obtain the data volume of the second data according to the field corresponding to the historical data;

The acquisition and test module is used to determine the acquisition capability of the real-time database by comparing the data and data volume of the real-time data with the data and data volume of the first data;

The storage test module is used to determine the storage capacity of the real-time database by comparing the data and data volume of the historical data with the data and data volume of the second data.

In a third aspect, the present invention also provides an electronic device, comprising:

processor;

A memory storing method steps for the processor to control as described above.

In a fourth aspect, the present invention further provides a storage medium on which computer-executable instructions are stored, characterized in that, when the executable instructions are executed by a processor, the above-mentioned method steps are implemented.

(3) Beneficial effects

The beneficial effects of the present invention are as follows: the method, system, electronic device and storage medium for testing the capability of a real-time database provided by the embodiment of the present invention, through the statistical relational database structured data, and with the real-time data and historical data stored in the real-time database Whether the data and data volume of the data are consistent can easily verify the real-time data acquisition and storage capabilities, and verify the correctness and integrity of the real-time database acquisition data.

Description of drawings

1 is a flowchart of a method for testing a real-time database capability provided by an embodiment of the present invention;

2 is a schematic diagram of a data flow process for testing real-time database capabilities in an embodiment of the present invention;

3 is an exemplary diagram of a relational database in an embodiment of the present invention;

4 is a schematic structural diagram of a testing system for a real-time database capability provided by another embodiment of the present invention;

FIG. 5 is a schematic diagram of the internal structure of a computer system of an electronic device according to still another embodiment of the present invention.

Detailed ways

In order to better explain the present invention and facilitate understanding, the present invention will be described in detail below with reference to the accompanying drawings and through specific embodiments.

It should be noted that all directional indications (such as up, down, left, right, front, back, etc.) in the embodiments of the present invention are only used to explain the relationship between various components under a certain posture (as shown in the accompanying drawings). The relative positional relationship, the movement situation, etc., if the specific posture changes, the directional indication also changes accordingly.

In addition, descriptions such as "first", "second", etc. in the present invention are only for descriptive purposes, and should not be construed as indicating or implying their relative importance or implicitly indicating the amount of data of the indicated technical features. Thus, a feature delimited with "first", "second" may expressly or implicitly include at least one of that feature. In the description of the present invention, "plurality" means at least two, such as two, three, etc., unless otherwise expressly and specifically defined.

The terms involved in the embodiments of the present invention are explained as follows:

Real Time Data Base (RTDB) is a branch of database system development. It is generated by database technology combined with real-time processing technology. It can directly collect and obtain various data in the process of enterprise operation in real time and convert it into data Effective public information for various businesses.

Automated testing is a process of converting human-driven testing behavior into machine execution.

The collector software is the software that collects and uploads the data of the controller, PLC, OPC and other equipment to the industrial real-time database.

The simulator refers to the generation of certain regular time series data through software simulation, such as sine wave, square wave, triangle wave, random number, etc.

A relational database refers to a database that uses a relational model to organize data. It stores data in the form of rows and columns so that users can understand it. The series of rows and columns in a relational database are called tables, and a group of tables constitute a database.

1 is a flowchart of a method for testing real-time database capabilities provided by an embodiment of the present invention, as shown in FIG. 1 , and specifically includes the following steps:

As shown in Figure 1, in step S110, call the real-time data from the real-time database and obtain the data and data volume of the real-time data;

As shown in Figure 1, in step S120, call historical data from the real-time database and obtain the data and data volume of the historical data;

As shown in Figure 1, in step S130, the data volume of the first data is obtained from the relational database according to the field corresponding to the real-time data, and the data volume of the second data is obtained according to the field corresponding to the historical data;

As shown in Figure 1, in step S140, the acquisition capability of the real-time database is determined by comparing the data and data volume of the real-time data with the data and data volume of the first data;

As shown in FIG. 1, in step S150, the storage capacity of the real-time database is determined by comparing the data and data volume of the historical data with the data and data volume of the second data.

Based on the method provided by the above embodiment, the ability to collect real-time data can be easily verified by counting the structured data in the relational database and comparing it with the real-time data and historical data stored in the real-time database and the data and the amount of data. and storage capacity to verify the correctness and integrity of the collected data in the real-time database.

The method shown in Figure 1 is described in detail as follows:

In step S110, the real-time data is called from the real-time database and the data and data amount of the real-time data are acquired.

In step S120, the historical data is called from the real-time database and the data and data amount of the historical data are acquired.

The step S110 and the step S120 are not limited in sequence, and they can be executed separately and sequentially, or can be executed simultaneously.

In an exemplary embodiment of the present invention, before step S110 and/or step S120, it further includes: a preprocessing step, which specifically includes the following preprocessing steps:

The test data source of real-time data and historical data is obtained through the simulation simulation of the simulator;

Collect the simulated test data source through the collector software and push it to the real-time database to obtain real-time data and historical data;

The simulated test data source is written into the relational database, and stored as corresponding first data and second data according to structured fields.

In this step, while pushing the simulated test data source to the real-time database, it can also be written to the relational database.

In an exemplary embodiment of the present invention, the test data source for obtaining real-time data and historical data by simulating the simulator further includes:

The data of the real-time data and the data of the historical data generated by the simulator are counted by the counter.

In an exemplary embodiment of the present invention, the test data source for obtaining real-time data and historical data through simulator simulation further includes:

The simulator simulates according to the business characteristics of the real-time database and the basic requirements of automated testing, and obtains the test data source.

The real-time database includes real-time data and historical data, and the parameters in the test data source of real-time data and/or historical data include at least one of data type, change period, waveform, and amplitude. It can be said that the real-time database is an in-memory snapshot database, which reflects second-level changes such as timestamps, values, and quality of real-time production data. The user can query the real-time data value (value, timestamp, quality) of the production real-time data from the real-time database.

Through the above preprocessing steps, due to the uncertainty of the data of ordinary data simulator or controller equipment (do not know what the data source data is, generally only know its waveform and data type), the verification of real-time database data is more troublesome It can collect and push super-second data to the real-time database collector software through the data simulator (referred to as the simulator in this article), and store the tag data at the same time. It is extremely convenient for testers to compare the data collected by the real-time database with the data of the relational database, and efficiently verify the acquisition and data storage capabilities of the real-time database.

In step S130, the data volume of the first data is obtained from the relational database according to the field corresponding to the real-time data, and the data volume of the second data is obtained according to the field corresponding to the historical data.

In relational databases, data tables are designed according to the relationship between various entities, including fields composed of keywords such as time and name. Therefore, when reading data from a relational database, it can be read according to fields.

In step S140, the acquisition capability of the real-time database is determined by comparing the data and data volume of the real-time data with the data and data volume of the first data.

In an exemplary embodiment of the present invention, determining the acquisition capability of the real-time database by comparing the data volume of the real-time data and the data volume of the first data in this step includes: if the data volume of the real-time data is smaller than the data volume of the first data , it is determined that the acquisition capability of the real-time database is insufficient; and/or if the data of the real-time data and the data of the first data are different in content, it is determined that the acquisition capability of the real-time database is insufficient.

However, if the data volume of the real-time data is not less than the data volume of the first data and the data content is consistent, it is determined that the real-time database has sufficient collection capability.

In step S150, the storage capacity of the real-time database is determined by comparing the data volume of the historical data and the data volume of the second data.

In an exemplary embodiment of the present invention, determining the storage capacity of the real-time database by comparing the data volume of the historical data and the data volume of the second data in this step includes: if the data volume of the historical data is smaller than the data volume of the second data , it is determined that the storage capacity of the real-time database is insufficient; and/or if there is a difference in content between the data of the historical data and the data of the second data, it is determined that the storage capacity of the real-time database is insufficient.

However, if the data volume of the historical data is not less than the data volume of the second data and the data content is consistent, it is determined that the storage capacity of the real-time database is sufficient.

In an exemplary embodiment of the present invention, in addition to the above steps, the method may further include: verifying whether the capabilities of the real-time database and the relational database match, that is, within a preset period, according to the data and The data volume, the data and data statistics of the first data, the data and the data volume of the historical data, and the data and data volume of the second data determine whether the acquisition capability and storage capability of the real-time database match. For example, according to the comparison between the data volume of the real-time data in the real-time database and the data and data volume of the first data in the relational database, it is judged whether the acquisition capability of the real-time database conforms to that of the real-time database. 2. Compare the data and data volume of the data to judge whether the storage capacity of the real-time database conforms. It is necessary to further compare the acquisition capacity and storage capacity of the real-time database, and make adjustments according to the comparison results, so as to avoid the mismatch between the acquisition and storage capacity of the real-time database, resulting in data leakage.

2 is a schematic diagram of a data flow process for testing real-time database capabilities in an embodiment of the present invention. As shown in FIG. 2, first, according to the business characteristics of real-time database and the basic requirements of automated testing, a data simulator tool is used to simulate and simulate different changes. Data, simulator super-second data, and use counter to record the amount of data generated by the simulator, collect and push real-time database through collector software, and synchronously write data to relational database. Then, call the real-time data query interface and historical data query interface of real-time data, and compare and analyze the data stored in the relational database to verify whether the data collection and storage of the real-time database is correct. If the data in the relational database is less or the data content is different, it means that the real-time database collection capability is insufficient. If the historical data queried in the real-time database is less than that in the relational database or the data content is different, it means that the real-time database has historical storage. The ability is insufficient. When the real-time data and historical data in the real-time database are consistent with the data in the relational database, it proves that the acquisition and storage capabilities of the real-time database are consistent with the current acquisition cycle and other conditions. Therefore, the test conclusion shown in Figure 2 includes the acquisition capability and storage capability of the real-time database, and whether the acquisition capability and storage capability conform.

FIG. 3 is an example diagram of a relational database in an embodiment of the present invention, as shown in FIG. 3 , including ID, tag name, parameter value, quality code, and time stamp.

The method shown in Figure 1 can achieve the following effects:

1) The simulator can be configured with parameters such as data type, change period, waveform, amplitude, etc., which can realize the diversity of test data, and meet the requirements of the collector software. In various types of databases, it is easy to detect;

2) Counting the data in the relational database, comparing whether the data stored in the real-time database is consistent, it is convenient to verify the acquisition capability and storage capability of the real-time database, and verify the correctness and integrity of the real-time database acquisition data.

3) Realize fast and accurate processing of data in relational databases, and compare and verify whether the historical data query interface (maximum value, minimum value, integral value, average value, etc.) provided by the real-time database is correct.

In summary, the above method solves the problem of avoiding the uncertainty of data source data and difficult to realize automatic data verification in the process of traditional real-time database functional testing. It can not only improve the accuracy and effectiveness of the test, but also reduce the number of tests. The workload of personnel and the cost of testing software and hardware can effectively improve the quality of software products.

Corresponding to the above method, FIG. 4 is a schematic diagram of a testing system for a real-time database capability in another embodiment of the present invention. As shown in FIG. 4 , the system 200 includes: a real-time data module 210 and a historical data module 220 , relational data module 230 , acquisition test module 240 and storage test module 250 .

Wherein, the real-time data module 210 is used to call real-time data from the real-time database and obtain the data and data volume of the real-time data; the historical data module 220 is used to call the historical data from the real-time database and obtain the data and data volume of the historical data; the relational data module 230 uses In order to obtain the data volume of the first data according to the field corresponding to the real-time data from the relational database, and obtain the data volume of the second data according to the field corresponding to the historical data; The data and data volume of the first data determine the acquisition capability of the real-time database; the storage test module 250 is used to determine the storage capability of the real-time database by comparing the data and data volume of the historical data with the data and data volume of the second data.

For the functions and effects of each unit in the system, reference may be made to the relevant descriptions in the foregoing method embodiments, which will not be repeated here.

In another aspect, the present disclosure also provides an electronic device, including a processor and a memory, where the memory stores operation instructions for the processor to control the following method:

Call the real-time data from the real-time database and obtain the data and data volume of the real-time data;

Call historical data from the real-time database and obtain the data and data volume of the historical data;

The data volume of the first data is obtained from the relational database according to the field corresponding to the real-time data, and the data volume of the second data is obtained according to the field corresponding to the historical data;

Determine the acquisition capability of the real-time database by comparing the data and data volume of the real-time data with the data and data volume of the first data;

The storage capacity of the real-time database is determined by comparing the data and data volume of the historical data with the data and data volume of the second data.

Referring next to FIG. 5 , it shows a schematic structural diagram of a computer system 400 suitable for implementing the electronic device of the embodiment of the present application. The electronic device shown in FIG. 5 is only an example, and should not impose any limitations on the functions and scope of use of the embodiments of the present application.

As shown in FIG. 5, the computer system 400 includes a central processing unit (CPU) 401, which can be loaded into a random access memory (RAM) 403 according to a program stored in a read only memory (ROM) 402 or a program from a storage section 407 Instead, various appropriate actions and processes are performed. In the RAM 403, various programs and data necessary for the operation of the system 400 are also stored. The CPU 401 , the ROM 402 , and the RAM 403 are connected to each other through a bus 404 . An input/output (I/O) interface 405 is also connected to bus 404 .

The following components are connected to the I/O interface 405: an input section 406 including a keyboard, a mouse, etc.; an output section 407 including a cathode ray tube (CRT), a liquid crystal display (LCD), etc., and a speaker, etc.; a storage section 408 including a hard disk, etc. ; and a communication section 409 including a network interface card such as a LAN card, a modem, and the like. The communication section 409 performs communication processing via a network such as the Internet. A drive 410 is also connected to the I/O interface 405 as needed. A removable medium 411, such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, etc., is mounted on the drive 410 as needed so that a computer program read therefrom is installed into the storage section 408 as needed.

In particular, according to embodiments of the present disclosure, the processes described above with reference to the flowcharts may be implemented as computer software programs. For example, embodiments of the present disclosure include a computer program product comprising a computer program carried on a computer-readable medium, the computer program containing program code for performing the method illustrated in the flowchart. In such an embodiment, the computer program may be downloaded and installed from the network via the communication portion 409 and/or installed from the removable medium 411 . When the computer program is executed by the central processing unit (CPU) 401, the above-described functions defined in the system of the present application are executed.

It should be noted that the storage medium shown in this application may be a computer-readable signal medium or a computer-readable medium, or any combination of the above two. The computer readable medium can be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus or device, or a combination of any of the above. More specific examples of computer readable media may include, but are not limited to, electrical connections having one or more wires, portable computer disks, hard disks, random access memory (RAM), read only memory (ROM), erasable programmable Read only memory (EPROM or flash memory), fiber optics, portable compact disk read only memory (CD-ROM), optical storage devices, magnetic storage devices, or any suitable combination of the foregoing. In this application, a computer-readable medium may be any tangible medium that contains or stores a program that can be used by or in conjunction with an instruction execution system, apparatus, or device. In this application, however, a computer-readable signal medium may include a data signal propagated in baseband or as part of a carrier wave, carrying computer-readable program code therein. Such propagated data signals may take a variety of forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination of the foregoing. A computer-readable signal medium can also be any computer-readable medium other than a computer-readable medium that can transmit, propagate, or transport the program for use by or in connection with the instruction execution system, apparatus, or device. Program code embodied on a computer readable medium may be transmitted using any suitable medium including, but not limited to, wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.

The flowchart and block diagrams in the Figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present application. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code that contains one or more logical functions for implementing the specified functions executable instructions. It should also be noted that, in some alternative implementations, the functions noted in the blocks may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It is also noted that each block of the block diagrams or flowchart illustrations, and combinations of blocks in the block diagrams or flowchart illustrations, can be implemented in special purpose hardware-based systems that perform the specified functions or operations, or can be implemented using A combination of dedicated hardware and computer instructions is implemented.

The units involved in the embodiments of the present application may be implemented in a software manner, and may also be implemented in a hardware manner. The described units can also be provided in the processor, wherein the names of these units in some cases do not constitute a limitation of the units themselves.

On the other hand, the present disclosure also provides a storage medium, which may be included in the electronic device described in the above embodiments, or may exist alone without being assembled into the electronic device. The above-mentioned storage medium carries one or more programs, and when the above-mentioned one or more programs are executed by an electronic device, the electronic device includes the following method steps:

Call the real-time data from the real-time database and obtain the data and data volume of the real-time data;

Call historical data from the real-time database and obtain the data and data volume of the historical data;

The data volume of the first data is obtained from the relational database according to the field corresponding to the real-time data, and the data volume of the second data is obtained according to the field corresponding to the historical data;

Determine the acquisition capability of the real-time database by comparing the data and data volume of the real-time data with the data and data volume of the first data;

The storage capacity of the real-time database is determined by comparing the data and data volume of the historical data with the data and data volume of the second data.

It should be understood that the above description of the specific embodiments of the present invention is only to illustrate the technical route and characteristics of the present invention, and its purpose is to enable those skilled in the art to understand the content of the present invention and implement it accordingly, but the present invention Not limited to the specific embodiments described above. Any changes or modifications made within the scope of the claims of the present invention should be covered within the protection scope of the present invention.

Claims (10)

1. A method for testing the capability of a real-time database, the method comprising:

calling real-time data from a real-time database and acquiring the data and data volume of the real-time data;

calling historical data from a real-time database and acquiring data and data volume of the historical data;

acquiring data and data volume of first data from a relational database according to a field corresponding to real-time data, and acquiring data and data volume of second data according to a field corresponding to historical data;

determining the acquisition capacity of the real-time database by comparing the data and the data volume of the real-time data with the data and the data volume of the first data;

and determining the storage capacity of the real-time database by comparing the data and the data amount of the historical data with the data and the data amount of the second data.

2. The method for testing the capability of a real-time database according to claim 1, further comprising:

a test data source of real-time data and historical data is obtained through simulation of a simulator;

acquiring a simulated test data source through collector software and pushing the acquired test data source to a real-time database to obtain real-time data and historical data;

and writing the simulated test data source into the relational database, and storing the simulated test data source into corresponding first data and second data according to the structured field.

3. The method for testing the capability of the real-time database according to claim 2, wherein the test data source for obtaining the real-time data and the historical data through the simulator simulation further comprises:

and counting the data of the real-time data simulated by the simulator and the data of the historical data by using a counter.

4. The method for testing the capability of the real-time database according to claim 2, wherein the test data source for obtaining the real-time data and the historical data through the simulator simulation further comprises:

the simulator simulates according to the service characteristics of the real-time database and the basic requirements of automatic testing to obtain a testing data source;

wherein the parameters in the test data source include at least one of data type, period of variation, waveform, and amplitude.

5. The method for testing real-time database capacity according to claim 1, wherein the determining the collection capacity of the real-time database by comparing the data and the data amount of the real-time data with the data and the data amount of the first data comprises:

if the data volume of the real-time data is smaller than that of the first data, determining that the acquisition capacity of the real-time database is insufficient; and/or

And if the data of the real-time data is different from the data of the first data in content, determining that the acquisition capacity of the real-time database is insufficient.

6. The method for testing real-time database capacity according to claim 1, wherein the determining the storage capacity of the real-time database by comparing the data and the data amount of the historical data with the data and the data amount of the second data comprises:

if the data volume of the historical data is smaller than that of the second data, determining that the storage capacity of the real-time database is insufficient; and/or

If the data of the historical data and the data of the second data are different in content, the storage capacity of the real-time database is determined to be insufficient.

7. The method for testing the capability of a real-time database according to any one of claims 1-6, further comprising:

and in a preset period, determining whether the acquisition capacity and the storage capacity of the real-time database are in accordance according to the data and the data volume of the real-time data, the data and the data volume of the first data, the data and the data volume of the historical data and the data volume of the second data.

8. A system for testing real-time database capabilities, the system comprising:

the real-time data module is used for calling real-time data from the real-time database and acquiring data and system data volume of the real-time data;

the historical data module is used for calling historical data from the real-time database and acquiring the data and the data volume of the historical data;

the relational data module is used for acquiring the data volume of the first data from the relational database according to the field corresponding to the real-time data and acquiring the data volume of the second data according to the field corresponding to the historical data;

the acquisition testing module is used for determining the acquisition capacity of the real-time database by comparing the data and the data volume of the real-time data with the data and the data volume of the first data;

and the storage testing module is used for determining the storage capacity of the real-time database by comparing the data and the data volume of the historical data with the data and the data volume of the second data.

9. An electronic device, comprising:

a processor;

memory storing instructions for the processor to control the method steps according to any one of claims 1-7.

10. A storage medium having stored thereon computer-executable instructions, which when executed by a processor, implement the method steps according to any one of claims 1-7.

Images