Data access method and device, terminal equipment and storage medium

By combining the in-memory database with the basic database and separating data from different accounting periods, the problem that a single database is easily squeezed by other tasks during data access is solved, and more efficient and stable data access is achieved.

CN119670128AInactive Publication Date: 2025-03-21BEIJING CAPITAL INFORMATION TECH CO LTD
View PDF 4 Cites 0 Cited by

Patent Information

Application Number
CN202510167710.1
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2025-02-17
Publication Date
2025-03-21
Estimated Expiration
Not applicable · inactive patent

AI Technical Summary

Technical Problem

In the prior art, data storage and access can be realized through a single database, which can easily be squeezed out by other tasks, resulting in long data access time and low efficiency.

Method used

The method of combining in-memory databases and basic databases is used to separate data from different accounting periods to avoid mutual interference between different databases and prevent data access requests from being squeezed by other request tasks.

Benefits of technology

Under the limited software platform construction costs, request delays are reduced and data access processing efficiency and stability are improved.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN119670128A_ABST
    Figure CN119670128A_ABST
Patent Text Reader

Abstract

The invention provides a data access method and device, terminal equipment and a storage medium, and is suitable for the technical field of data processing, and the method comprises the following steps: obtaining data access request information; determining account period information of data to be accessed according to the data access request information; judging whether the account period information of the to-be-accessed data is within a preset account period range or not; if yes, taking the memory database as a data access range; if not, taking the basic database as a data access range; and accessing to-be-accessed data according to the data access request information and the data access range. According to the method and the device, under the condition of limited software platform construction cost, the memory database and the basic database are used for separating the data of different account periods, so that the data access efficiency is improved, and mutual interference among different databases is avoided.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present application belongs to the field of data processing technology, and in particular, relates to a data access method, apparatus, terminal device and storage medium. Background Art

[0002] The current data communication industry is developing rapidly, and the demand for data query and access is increasing day by day. The data access system currently used in the industry is directly rooted in a single existing database.

[0003] Telecom operators usually use various types of database systems to manage and analyze large amounts of user data, network data, and service data. These database systems support different functional requirements, including but not limited to billing management, customer service, network monitoring, and data analysis. These database systems include relational database management systems (RDBMS), NoSQL databases, MongoDB, etc.

[0004] When using a single existing database during data access, resource usage is sometimes high and sometimes low, and when other request tasks conflict with data access requests in time, the access time for data is greatly prolonged, reducing the user's data access service experience. Summary of the invention

[0005] In view of this, the embodiments of the present application provide a data access method, apparatus, terminal device and storage medium, aiming to solve the problem in the prior art that data storage and access are achieved through a single database, which is easily squeezed out by other tasks, resulting in long data access time and low efficiency.

[0006] A first aspect of an embodiment of the present application provides a data access method, including: Get data access request information; Determining the account period information of the data to be accessed according to the data access request information; Determining whether the account period information of the data to be accessed is within a preset account period range; If yes, the in-memory database is used as the data access scope; If not, the basic database is used as the data access scope; The data to be accessed is accessed according to the data access request information and the data access scope.

[0007] A second aspect of an embodiment of the present application provides a data access device, including: A data access request information acquisition module, used to acquire data access request information; A module for determining the account period information of the data to be accessed, used for determining the account period information of the data to be accessed according to the data access request information; The account period information judgment module of the data to be accessed is used to judge whether the account period information of the data to be accessed is within the preset account period range; If yes, the in-memory database is used as the data access scope; If not, the underlying database is used as the data access scope; and The data access module is used to access the data to be accessed according to the data access request information and the data access scope.

[0008] A third aspect of an embodiment of the present application provides a terminal device, which includes a memory and a processor, wherein the memory stores a computer program that can be executed on the processor, and when the processor executes the computer program, the steps of the data access method described in any one of the first aspects above are implemented.

[0009] A fourth aspect of an embodiment of the present application provides a computer-readable storage medium, comprising: storing a computer program, characterized in that when the computer program is executed by a processor, the steps of the data access method as described in any one of the first aspects above are implemented.

[0010] Compared with the prior art, the embodiments of the present application have the following beneficial effects: under the condition of limited software platform construction cost, by combining the in-memory database with the basic database, data of different account periods are separated, mutual interference between different databases is avoided, and most data access requests are prevented from being occupied by other request tasks, thereby reducing request delays and improving the processing efficiency and stability of data access. BRIEF DESCRIPTION OF THE DRAWINGS

[0011] In order to more clearly illustrate the technical solutions in the embodiments of the present application, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative labor.

[0012] Figure 1 It is a schematic diagram of the implementation flow of the data access method provided in the embodiment of the present application; Figure 2 It is a schematic diagram of the implementation flow of the data access method provided in the embodiment of the present application; Figure 3 It is a schematic diagram of the implementation flow of the data access method provided in the embodiment of the present application; Figure 4 It is a schematic diagram of the implementation flow of the data access method provided in the embodiment of the present application; Figure 5 is a structural diagram of a data access device provided in an embodiment of the present application; Figure 6 It is a schematic diagram of a terminal device provided in an embodiment of the present application. DETAILED DESCRIPTION

[0013] In the following description, specific details such as specific system structures, technologies, etc. are provided for the purpose of illustration rather than limitation, so as to provide a thorough understanding of the embodiments of the present application. However, it should be clear to those skilled in the art that the present application may also be implemented in other embodiments without these specific details. In other cases, detailed descriptions of well-known systems, devices, circuits, and methods are omitted to prevent unnecessary details from obstructing the description of the present application.

[0014] In order to illustrate the technical solution described in this application, a specific embodiment is provided below for illustration.

[0015] Figure 1 The following is a flowchart of the implementation of the data access method provided in the first embodiment of the present application, which is described in detail as follows: Step S101, obtaining data access request information.

[0016] In this embodiment, the data access request information may be generated by the client, and may be generated instantly based on the user's operation, and is used to characterize the user's data access needs, which may include partial information of the data to be accessed, such as the account period information and data type information of the data to be accessed.

[0017] Step S102: determining the account period information of the data to be accessed according to the data access request information.

[0018] In this embodiment, the account period information of the data to be accessed may be obtained by extracting the account period information in the data access request information.

[0019] Step S103, determining whether the account period information of the data to be accessed is within a preset account period range; if so, taking the memory database as the data access range; if not, taking the basic database as the data access range.

[0020] In this embodiment, it can be a hybrid structure of a memory database and a basic database implemented by combining a memory file system and SQLite technology. The preset account period range can be set manually, or it can be determined based on the account period information of all past access requests. It can be understood that the account period of most of the data to be accessed is within a week after it is generated, so the account period range can be set to within a week, and the data information with an account period within a week is stored in the memory database. When the user initiates a data access request, when it is determined that the time interval between the account period of the data to be accessed and the initiation of the data access request is within a week, the data can be queried and accessed through the memory database, and the data access retrieval range is determined in the memory database, and there is no need to access the basic database; when it is determined that the time interval between the account period of the data to be accessed and the initiation of the data access request is not within a week, the memory database cannot meet the data access requirements, and the data can be queried and accessed through the basic database, and the data access retrieval range is determined in the basic database.

[0021] Step S104: access the data to be accessed according to the data access request information and the data access scope.

[0022] In this embodiment, a corresponding SQL statement may be generated according to the data access request information first, and then the SQL statement is executed to perform a search within the data access range, thereby implementing an access operation on the data to be accessed.

[0023] The data access method provided in the embodiment of the present application can combine the in-memory database with the basic database by adding only one additional server under the condition of limited software platform construction cost, separate the data of different account periods, avoid mutual interference between different databases, and prevent most data access requests from being occupied by other request tasks, thereby reducing request delays and improving the processing efficiency and stability of data access.

[0024] Figure 2 The flowchart of the implementation of the data access method provided in the second embodiment of the present application is shown. The difference between the second embodiment and the first embodiment is that the step S103 specifically includes: Step S201: Generate a data query statement according to the data access request information.

[0025] In this embodiment, the data access requirements and the type of SQL operation to be performed, such as querying data, inserting data, updating data, deleting data, etc., can be determined based on the data access request information, so as to write a specific SQL statement, i.e., a data query statement, according to the specific SQL operation type.

[0026] Step S202: obtaining a plurality of data query range connection information according to the data query statement and the data access range.

[0027] In this embodiment, a connection with the database may be established first, and information such as the address, port number, database name, user name, etc. of the database server may be determined through data query statements and data access scopes, and data query scope connection information may be constructed through the above information to characterize the connection information between the application and the database.

[0028] Step S203: Generate data query cursor information according to the plurality of data query range connection information.

[0029] In this embodiment, data query cursor information may be created based on the address, port number, database name, user name, etc. of the database server in the data query range connection information. For example, in the pymysql library of python, data query cursor information may be created by the cursor method.

[0030] Step S204: access the data to be accessed according to the data query statement and the data query cursor information.

[0031] In this embodiment, the data query cursor information can be used as a medium to send the data query statement to the server where the database is located, thereby implementing the access operation for the data to be accessed.

[0032] The data access method provided in the embodiment of the present application generates a specific data query statement based on data access request information, and then establishes a communication connection with a specific data access scope through the data query statement. While meeting the access requirements for various complex data, it imposes certain constraints on the access operation to ensure the security and reliability of the data access process.

[0033] Figure 3 The flowchart of the implementation of the data access method provided in the third embodiment of the present application is shown. The difference between the third embodiment and the first embodiment is that after the step S104, the method further includes: Step S301, obtaining multiple operation data information.

[0034] In this embodiment, the operation data information may include business domain data information, operation domain data information, and management domain data information. Among them, the business domain data information may include traffic data information and voice data information; the operation domain data information may include hypertext transfer protocol record information and domain name record information; and the management domain data information may include location information. The operation data information may be collected by telecommunications operators.

[0035] Step S302, processing the plurality of operation data information to generate a plurality of account period operation data.

[0036] In this embodiment, the operational data information can be processed and summarized at the ODS layer (operational data), DW (data warehouse), and DM (data mart), while supporting daily operational analysis data statistics tasks and generating multiple account period operational data.

[0037] Step S303, writing the account period operation data into the basic database.

[0038] In this embodiment, all account period operation data are written into a basic database for storage and backup of all data.

[0039] Step S304, extracting the operating account period information of the account period operating data.

[0040] In this embodiment, the operating account period information of all account period operating data is extracted, and the account period operating data is filtered according to the operating account period information, and the data with a relatively recent account period is filtered out and stored in the memory database for quick access by users.

[0041] Step S305, determining whether the operation account period information is within a preset account period range; if so, writing the operation account period information into the memory database; if not, not writing the operation account period information into the memory database.

[0042] In this embodiment, when the operating account period information is within the preset account period range, the operating data is stored in the memory database to facilitate quick access by users; when the operating account period information is not within the preset account period range, the operating data is not stored in the memory database. When the user needs to access it, it is accessed through the basic database.

[0043] The data access method provided in the embodiment of the present application can improve the data access speed in most scenarios by using the in-memory database, under the premise of limited software system construction costs, by only adding one additional server. At the same time, the business data of different account periods are stored and accessed separately, which to a certain extent isolates the direct connection between the underlying data processing system and the upper-level application system, avoids mutual interference between different tasks, and improves the security and stability of each working system.

[0044] Figure 4 The flowchart of the data access method provided in the fourth embodiment of the present application is shown. The difference between the fourth embodiment and the third embodiment is that the step S302 specifically includes: Step S401, performing data cleaning and format conversion processing on the plurality of operation data information to obtain operation data list information.

[0045] In this embodiment, data cleaning is performed on multiple operational data information, which may include processing missing values, abnormal values, null values, etc., to ensure the integrity and accuracy of the data. Format conversion processing may include data type conversion, encoding conversion, etc. The data that has undergone data cleaning and format conversion processing may be loaded into a list at the ODS layer to generate operational data list information.

[0046] Step S402: performing data integration processing on the operation data list information according to preset data source information to obtain operation data integration information.

[0047] In this embodiment, the preset data source information may be generated based on the collected external data. The data integration processing of the operation data list information may be to supplement the external data with the operation data list information and determine the subject domain, dimension, etc. of the business data to facilitate further processing.

[0048] Step S403: convert the operation data integration information according to preset data conversion rules to obtain operation data conversion information.

[0049] In this embodiment, the preset data conversion rules may be calculation of derived indicators, data aggregation processing, etc. The converted data is the operational data conversion information, which is used for subsequent further screening operations.

[0050] Step S404, screening and processing the operation data conversion information to generate a plurality of account period operation data.

[0051] In this embodiment, relevant data may be screened out from the DW layer according to a specific topic or analysis requirement, and extracted to the DW layer for calculation, and the screened data is account period operation data.

[0052] The data access method provided in the embodiment of the present application uniformly processes data from different data sources through rapid data cleaning and transformation operations, reduces data access delays caused by data complexity, retains data details, facilitates data tracing, and ensures security and reliability during data access.

[0053] Corresponding to the method of the above embodiment, Figure 5 A structural block diagram of a data access device provided in an embodiment of the present application is shown. For ease of explanation, only the parts related to the embodiment of the present application are shown. Figure 5 The exemplary data access device may be an execution subject of the data access method provided in the aforementioned first embodiment.

[0054] Reference Figure 5 , the data access device comprises: A data access request information acquisition module 510, used to acquire data access request information; The account period information determination module 520 for data to be accessed is used to determine the account period information for data to be accessed according to the data access request information; The account period information determination module 530 for the data to be accessed is used to determine whether the account period information for the data to be accessed is within a preset account period range; If yes, the in-memory database is used as the data access scope; If not, the underlying database is used as the data access scope; and The data access module 540 is used to access the data to be accessed according to the data access request information and the data access scope.

[0055] The process of each module in the data access device provided in the embodiment of the present application realizing its own function can be specifically referred to the aforementioned Figure 1 The description of the first embodiment is not repeated here.

[0056] The data access module 540 includes: A data query statement generating unit, used to generate a data query statement according to the data access request information; A data query range connection information determination unit, configured to obtain a plurality of data query range connection information according to the data query statement and the data access range; A data query cursor information generating unit, configured to generate data query cursor information according to the plurality of data query range connection information; and The data access unit is used to access the data to be accessed according to the data query statement and the data query cursor information.

[0057] The process of each unit in the ocean subsurface temperature information calculation module 540 provided in the embodiment of the present application realizing its own function can be specifically referred to the aforementioned Figure 2 The description of the second embodiment is not repeated here.

[0058] It should be understood that the size of the serial numbers of the steps in the above embodiments does not mean the order of execution. The execution order of each process should be determined by its function and internal logic, and should not constitute any limitation on the implementation process of the embodiments of the present application.

[0059] It should be understood that when used in the present specification and the appended claims, the term "comprising" indicates the presence of described features, wholes, steps, operations, elements and / or components, but does not exclude the presence or addition of one or more other features, wholes, steps, operations, elements, components and / or combinations thereof.

[0060] It should also be understood that the term “and / or” used in the specification and appended claims refers to any and all possible combinations of one or more of the associated listed items, and includes these combinations.

[0061] As used in the specification and appended claims of this application, the term "if" can be interpreted as "when" or "uponce" or "in response to determining" or "in response to detecting", depending on the context. Similarly, the phrase "if it is determined" or "if [described condition or event] is detected" can be interpreted as meaning "uponce it is determined" or "in response to determining" or "uponce [described condition or event] is detected" or "in response to detecting [described condition or event]", depending on the context.

[0062] In addition, in the description of the present specification and the appended claims, the terms "first", "second", "third", etc. are only used to distinguish descriptions, and cannot be understood as indicating or suggesting relative importance. It should also be understood that although the terms "first", "second", etc. are used to describe various elements in some embodiments of the present application in the text, these elements should not be limited by these terms. These terms are only used to distinguish one element from another element. For example, the first table can be named as the second table, and similarly, the second table can be named as the first table without departing from the scope of the various described embodiments. The first table and the second table are both tables, but they are not the same table.

[0063] References to "one embodiment" or "some embodiments" etc. described in the specification of this application mean that one or more embodiments of the present application include specific features, structures or characteristics described in conjunction with the embodiment. Therefore, the statements "in one embodiment", "in some embodiments", "in some other embodiments", "in some other embodiments", etc. that appear in different places in this specification do not necessarily refer to the same embodiment, but mean "one or more but not all embodiments", unless otherwise specifically emphasized in other ways. The terms "including", "comprising", "having" and their variations all mean "including but not limited to", unless otherwise specifically emphasized in other ways.

[0064] The data access method provided in the embodiments of the present application can be applied to terminal devices such as mobile phones, tablet computers, wearable devices, vehicle-mounted devices, augmented reality (AR) / virtual reality (VR) devices, laptop computers, ultra-mobile personal computers (UMPC), netbooks, personal digital assistants (PDA), etc. The embodiments of the present application do not impose any restrictions on the specific types of terminal devices.

[0065] For example, the terminal device can be a station (STAION, ST) in a WLAN, a cellular phone, a cordless phone, a Session Initiation Protocol (SIP) phone, a Wireless Local Loop (WLL) station, a Personal Digital Assistant (PDA) device, a handheld device with wireless communication function, a computing device or other processing device connected to a wireless modem, a vehicle-mounted device, a vehicle networking terminal, a computer, a laptop computer, a handheld communication device, a handheld computing device, a satellite wireless device, a wireless modem card, a TV set top box (STB), a customer premises equipment (CPE) and / or other devices for communicating on a wireless system and a next-generation communication system, such as a mobile terminal in a 5G network or a mobile terminal in a future evolved Public Land Mobile Network (PLMN) network, etc.

[0066] As an example but not limitation, when the terminal device is a wearable device, the wearable device can also be a general term for wearable devices that are intelligently designed and developed using wearable technology for daily wear, such as glasses, gloves, watches, clothing and shoes. A wearable device is a portable device that is worn directly on the body or integrated into the user's clothes or accessories. Wearable devices are not just hardware devices, but also achieve powerful functions through software support, data interaction, and cloud interaction. Broadly speaking, wearable smart devices include those that are fully functional, large in size, and can achieve complete or partial functions without relying on smartphones, such as smart watches or smart glasses, as well as those that only focus on a certain type of application function and need to be used in conjunction with other devices such as smartphones, such as various smart bracelets and smart jewelry for vital sign monitoring.

[0067] Figure 6Schematic diagram of the structure of a terminal device provided by an embodiment of the present application. Figure 6 As shown, the terminal device 6 of this embodiment includes: at least one processor 60 ( Figure 6 Only one is shown in the figure), a memory 61, in which a computer program 62 that can be run on the processor 60 is stored. When the processor 60 executes the computer program 62, the steps in the above-mentioned data access method embodiments are implemented, such as Figure 1 Alternatively, when the processor 60 executes the computer program 62, the functions of each module / unit in the above-mentioned device embodiments are realized, for example Figure 5 Functions of modules 510 to 540 are shown.

[0068] The terminal device 6 may be a computing device such as a desktop computer, a notebook, a PDA, or a cloud server. The terminal device may include, but is not limited to, a processor 60 and a memory 61. Those skilled in the art will appreciate that Figure 6 It is only an example of the terminal device 6 and does not constitute a limitation of the terminal device 6. It may include more or fewer components than shown in the figure, or a combination of certain components, or different components. For example, the terminal device may also include an input sending device, a network access device, a bus, etc.

[0069] The processor 60 may be a central processing unit (CPU), or other general-purpose processors, digital signal processors (DSP), application-specific integrated circuits (ASIC), field-programmable gate arrays (FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. A general-purpose processor may be a microprocessor or any conventional processor, etc.

[0070] In some embodiments, the memory 61 may be an internal storage unit of the terminal device 6, such as a hard disk or memory of the terminal device 6. The memory 61 may also be an external storage device of the terminal device 6, such as a plug-in hard disk, a smart media card (SMC), a secure digital (SD) card, a flash card, etc. equipped on the terminal device 6. Further, the memory 61 may also include both an internal storage unit and an external storage device of the terminal device 6. The memory 61 is used to store an operating system, an application program, a boot loader (BootLoader), data, and other programs, such as the program code of the computer program, etc. The memory 61 may also be used to temporarily store data that has been sent or is to be sent.

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

[0072] An embodiment of the present application also provides a terminal device, which includes at least one memory, at least one processor, and a computer program stored in the at least one memory and executable on the at least one processor, wherein when the processor executes the computer program, the terminal device implements the steps in any of the above-mentioned method embodiments.

[0073] An embodiment of the present application further provides a computer-readable storage medium, wherein the computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the steps in the above-mentioned method embodiments can be implemented.

[0074] An embodiment of the present application provides a computer program product. When the computer program product is run on a terminal device, the terminal device can implement the steps in the above-mentioned method embodiments when executing the computer program product.

[0075] If the integrated module / unit is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the present application implements all or part of the processes in the above-mentioned embodiment method, and can also be completed by instructing the relevant hardware through a computer program. The computer program can be stored in a computer-readable storage medium, and the computer program can implement the steps of the above-mentioned various method embodiments when executed by the processor. Among them, the computer program includes computer program code, and the computer program code can be in source code form, object code form, executable file or some intermediate form. The computer-readable medium may include: any entity or device that can carry the computer program code, recording medium, U disk, mobile hard disk, disk, optical disk, computer memory, read-only memory (ROM), random access memory (RAM), electrical carrier signal, telecommunication signal and software distribution medium, etc.

[0076] In the above embodiments, the description of each embodiment has its own emphasis. For parts that are not described or recorded in detail in a certain embodiment, reference can be made to the relevant descriptions of other embodiments.

[0077] Those of ordinary skill in the art will appreciate that the units and algorithm steps of each example described in conjunction with the embodiments disclosed herein can be implemented in electronic hardware, or a combination of computer software and electronic hardware. Whether these functions are performed in hardware or software depends on the specific application and design constraints of the technical solution. Professional and technical personnel can use different methods to implement the described functions for each specific application, but such implementation should not be considered to be beyond the scope of this application.

[0078] The units described as separate components may or may not be physically separated, and the components shown as units may or may not be physical units, that is, they may be located in one place or distributed on multiple network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.

[0079] The embodiments described above are only used to illustrate the technical solutions of the present application, rather than to limit them. Although the present application has been described in detail with reference to the aforementioned embodiments, a person skilled in the art should understand that the technical solutions described in the aforementioned embodiments may still be modified, or some of the technical features may be replaced by equivalents. Such modifications or replacements do not deviate the essence of the corresponding technical solutions from the spirit and scope of the technical solutions of the embodiments of the present application, and should all be included in the protection scope of the present application.

Claims

1. A data access method, characterized in that: include: Get data access request information; Determining the account period information of the data to be accessed according to the data access request information; Determining whether the account period information of the data to be accessed is within a preset account period range; If yes, the in-memory database is used as the data access scope; If not, the basic database is used as the data access scope; The data to be accessed is accessed according to the data access request information and the data access scope.

2. The data access method according to claim 1, characterized in that: The step of accessing the data to be accessed according to the data access request information and the data access scope specifically includes: Generate a data query statement according to the data access request information; According to the data query statement and the data access scope, multiple data query scope connection information is obtained; Generate data query cursor information according to the plurality of data query range connection information; The data to be accessed is accessed according to the data query statement and the data query cursor information.

3. The data access method according to claim 1, characterized in that: After the step of accessing the data to be accessed according to the data access request information and the data access scope, the method further includes: Obtain multiple operational data information; Processing the plurality of operation data information to generate a plurality of account period operation data; Writing the account period operation data into the basic database; Extracting the operating account period information of the account period operating data; When the operation account period information is within a preset account period range, the operation account period information is written into the memory database.

4. The data access method according to claim 3, characterized in that: The step of processing the plurality of operation data information to generate a plurality of account period operation data specifically includes: Performing data cleaning and format conversion processing on the plurality of operation data information to obtain operation data list information; According to the preset data source information, data integration processing is performed on the operation data list information to obtain operation data integration information; According to the preset data conversion rules, the operation data integration information is converted to obtain operation data conversion information; The operation data conversion information is screened and processed to generate a plurality of account period operation data.

5. The data access method according to claim 3, characterized in that: The operation data information includes business domain data information, operation domain data information and management domain data information.

6. The data access method according to claim 5, characterized in that: The business domain data information includes flow data information and voice data information; the operation domain data information includes hypertext transfer protocol record information and domain name record information; and the management domain data information includes location information.

7. A data access device, characterized in that: include: A data access request information acquisition module, used to acquire data access request information; A module for determining the account period information of the data to be accessed, used for determining the account period information of the data to be accessed according to the data access request information; The account period information judgment module of the data to be accessed is used to judge whether the account period information of the data to be accessed is within the preset account period range; If yes, the in-memory database is used as the data access scope; If not, the basic database is used as the data access scope; as well as The data access module is used to access the data to be accessed according to the data access request information and the data access scope.

8. The data access device according to claim 7, characterized in that: The data access module includes: A data query statement generating unit, used to generate a data query statement according to the data access request information; A data query range connection information determination unit, configured to obtain a plurality of data query range connection information according to the data query statement and the data access range; A data query cursor information generating unit, configured to generate data query cursor information according to a plurality of data query range connection information; and The data access unit is used to access the data to be accessed according to the data query statement and the data query cursor information.

9. A terminal device, characterized in that: The terminal device includes a memory and a processor, wherein the memory stores a computer program that can be run on the processor, and when the processor executes the computer program, the steps of the method according to any one of claims 1 to 6 are implemented.

10. A computer-readable storage medium storing a computer program, characterized in that: When the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 6 are implemented.

Citation Information

Patent Citations

  • Hierarchical storage method based on time series data cold and hot classification

    CN108268217A

  • Data query method, device and equipment and storage medium

    CN110119402A

  • File access request processing method, electronic equipment and computer program product

    CN114528260A

  • Method and system for performing nested vernier query by using vernier expression

    CN118410061A