CN109800229B - Data access method and related equipment - Google Patents
Data access method and related equipment Download PDFInfo
- Publication number
- CN109800229B CN109800229B CN201811640258.2A CN201811640258A CN109800229B CN 109800229 B CN109800229 B CN 109800229B CN 201811640258 A CN201811640258 A CN 201811640258A CN 109800229 B CN109800229 B CN 109800229B
- Authority
- CN
- China
- Prior art keywords
- data
- main program
- configuration
- data table
- database
- 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)
- Information Transfer Between Computers (AREA)
- Telephonic Communication Services (AREA)
Abstract
The embodiment of the application discloses a data access method and related equipment, wherein the method comprises the following steps: the main program receives data request information aiming at the database and sent by a service system; determining a first data table which needs to be accessed by the service system at present according to the data request information; judging whether the memory configuration of the main program comprises the table type of the first data table; if not, interacting with a configuration center to update the memory configuration, so that the memory configuration comprises the table type of the first data table; and executing the data request information configuration operation aiming at the first data table in the database. By implementing the embodiment of the application, the data table and the table structure can be automatically modified when the service changes, a new data storage and retrieval system does not need to be redesigned, and the data access, modification and storage efficiency is improved.
Description
Technical Field
The present application relates to the technical field of servers, and in particular, to a data access method and related devices.
Background
In the single application mode, the data storage and retrieval system usually reserves all data tables in advance, and then each service module reads and writes the database, and all projects are not interfered with each other. With the development of internet technology, the current business is more and more abundant, when different projects are docked, if the interactive interface field of the data storage and retrieval system is modified, the table structure in the database needs to be modified again; meanwhile, with the increase of the butt-joint service, the number of the data storage and retrieval systems needing to be maintained is gradually increased, and the maintenance cost is gradually increased.
Disclosure of Invention
The embodiment of the application provides a data access method and related equipment, so that the efficiency of a data access process is improved.
In a first aspect, an embodiment of the present application provides a data access method, which is applied to a data storage and retrieval system, where the data storage and retrieval system may be in communication connection with a service system; the data storage and retrieval system comprises a main program, a configuration center and a database, and the method comprises the following steps:
the main program receives data request information aiming at the database and sent by the service system;
the main program determines a first data table which needs to be accessed by the service system currently according to the data request information;
the main program judges whether the memory configuration of the main program comprises the table type of the first data table or not;
if not, the main program interacts with the configuration center to update the memory configuration, so that the memory configuration comprises the table type of the first data table;
and the main program executes the operation configured in the data request information aiming at the first data table in the database.
In a second aspect, an embodiment of the present application provides a data storage and retrieval system, including: the system comprises a main program, a configuration center and a database, wherein the data storage and retrieval system can be in communication connection with a service system, and comprises:
the main program is used for receiving data request information aiming at the database sent by the service system; determining a first data table which needs to be accessed by the service system at present according to the data request information; judging whether the memory configuration of the main program comprises the table type of the first data table or not; if not, interacting with the configuration center to update the memory configuration;
the database is used for executing the operation configured in the data request information aiming at the first data table.
In a third aspect, an embodiment of the present application provides a data access apparatus, which is applied to a data storage and retrieval system, where the data storage and retrieval system may be in communication connection with a business system; the data storage and retrieval system comprises a main program, a configuration center and a database, and the data access device comprises:
the communication unit is used for receiving data request information which is sent by the service system and aims at the database;
a determining unit, configured to determine, according to the data request information, a first data table that the service system currently needs to access;
a determining unit, configured to determine whether the memory configuration of the main program includes a table type of the first data table;
if not, the interaction unit is used for interacting with the configuration center to update the memory configuration, so that the memory configuration comprises the table type of the first data table;
and the execution unit executes the operation configured in the data request information aiming at the first data table in the database.
In a fourth aspect, an embodiment of the present application provides a server, including a processor, a memory, a communication interface, and one or more programs, where the one or more programs are stored in the memory and configured to be executed by the processor, and the program includes instructions for executing the steps in any of the methods of the first aspect of the embodiment of the present application.
In a fifth aspect, this application provides a computer-readable storage medium, where the computer-readable storage medium stores a computer program for electronic data exchange, where the computer program enables a computer to perform some or all of the steps described in any one of the methods of the first aspect of this application.
In a sixth aspect, the present application provides a computer program product, wherein the computer program product includes a non-transitory computer-readable storage medium storing a computer program, and the computer program is operable to cause a computer to perform some or all of the steps as described in any one of the methods of the first aspect of the embodiments of the present application. The computer program product may be a software installation package.
It can be seen that, in the embodiment of the present application, first, a main program receives data request information for the database sent by the service system; secondly, determining a first data table which needs to be accessed by the service system at present according to the data request information; secondly, judging whether the memory configuration of the main program comprises the table type of the first data table; if not, interacting with the configuration center to update the memory configuration, so that the memory configuration comprises the table type of the first data table; finally, the operation configured in the data request information is executed aiming at the first data table in the database. It can be seen that, in the embodiment of the present application, when a data table in a database needs to be accessed by a main program, if a table type of the data table that the current memory configuration does not support to be accessed is found, the main program may interact with a configuration center to update the memory configuration, so that the memory configuration supports the corresponding table type, a table structure of the data table that needs to be accessed does not need to be defined in advance, the efficiency of data access, modification and storage is improved, and the convenience of a data access process is improved.
Drawings
In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present application, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts.
FIG. 1 is a schematic diagram of a data storage and retrieval system;
fig. 2 is a schematic flowchart of a data access method provided in an embodiment of the present application;
FIG. 3 is a schematic flow chart diagram of another data access method provided by an embodiment of the present application;
FIG. 4 is a functional flow diagram of a data storage and retrieval system provided by an embodiment of the present application;
fig. 5 is a schematic structural diagram of a server provided in an embodiment of the present application;
fig. 6 is a block diagram of functional units of a data access device according to an embodiment of the present disclosure.
Detailed Description
In order to make the technical solutions of the present application better understood, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only a part of the embodiments of the present application, 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 application.
The terms "first," "second," and the like in the description and claims of the present application and in the above-described drawings are used for distinguishing between different objects and not for describing a particular order. Furthermore, the terms "include" and "have," as well as any variations thereof, are intended to cover non-exclusive inclusions. For example, a process, method, system, article, or apparatus that comprises a list of steps or elements is not limited to only those steps or elements listed, but may alternatively include other steps or elements not listed, or inherent to such process, method, article, or apparatus.
Reference herein to "an embodiment" means that a particular feature, structure, or characteristic described in connection with the embodiment can be included in at least one embodiment of the application. The appearances of the phrase in various places in the specification are not necessarily all referring to the same embodiment, nor are separate or alternative embodiments mutually exclusive of other embodiments. It is explicitly and implicitly understood by one skilled in the art that the embodiments described herein can be combined with other embodiments.
The server according to the embodiments of the present application may include various handheld devices, vehicle-mounted devices, wearable devices, computing devices or other processing devices connected to a wireless modem, and various forms of User Equipment (UE), Mobile Stations (MS), electronic devices (terminal services), and the like.
The embodiments of the present application will be described in detail below with reference to the accompanying drawings.
Fig. 1 is a schematic structural diagram of a data storage and retrieval system disclosed in the embodiment of the present application, as shown in fig. 1. As shown in FIG. 1, the data storage and retrieval system comprises: main program 101, configuration center 102, and database 103. The main program 101 may be in communication connection with a service system to receive and send information, the main program 101 and the configuration center 102 may perform information interaction to update memory configuration information stored in the main program, and the main program 101 may perform operations such as reading, storing, and modifying data information through the database 103. The main program 101, the configuration center 102 and the database 103 can run on the same server; the main program 101 and the configuration center 102 can also operate with a first server, the database 103 is separated from the first server, and the database 103 can be in communication connection with the first server; it is also possible that the main program 101, the configuration center 102 and the database 103 are respectively run on three different hardware carriers that are communicatively connected to each other.
Referring to fig. 2, fig. 2 is a schematic flowchart of a data access method, which is applied to a data storage and retrieval system, where the data storage and retrieval system may be in communication connection with a service system according to an embodiment of the present application; the data storage and retrieval system comprises a main program, a configuration center and a database, and as shown in the figure, the data access method comprises the following steps:
Wherein the performing the data request information configuration operation on the first data table of the database may include: determining an operation which needs to be executed by the service system for at least one piece of data information according to the data request information, generating an operation list for executing the configured operation according to the operation which needs to be executed by each piece of data information in the at least one piece of data information, and executing a corresponding operation for the first data table according to the operation list when a main program accesses the first data table in the database; wherein the configuring may include: and finishing command operation, field extension storage and data access.
It can be seen that, in the embodiment of the present application, first, a main program receives data request information for the database sent by the service system; secondly, determining a first data table which needs to be accessed by the service system at present according to the data request information; secondly, judging whether the memory configuration of the main program comprises the table type of the first data table; if not, interacting with the configuration center to update the memory configuration, so that the memory configuration comprises the table type of the first data table; finally, the operation configured in the data request information is executed aiming at the first data table in the database. It can be seen that, in the embodiment of the present application, when a data table in a database needs to be accessed by a main program, if a table type of the data table that the current memory configuration does not support to be accessed is found, the main program may interact with a configuration center to update the memory configuration, so that the memory configuration supports the corresponding table type, a table structure of the data table that needs to be accessed does not need to be defined in advance, the efficiency of data access, modification and storage is improved, and the convenience of a data access process is improved.
Alternatively, the service system and the data storage and retrieval system may run on two different servers, as long as the two different servers can implement a communication connection.
Alternatively, the main program, the configuration center and the database may not be on the same server, but run on at least two servers, as long as the condition of communication connection between the at least two servers is satisfied.
In one possible example, the interacting of the main program and the configuration center to update the memory configuration includes: the main program sends a configuration modification request to the configuration center, so that the configuration center executes preset operation according to the configuration modification request to update the configuration information currently stored by the configuration center; the main program receives the configuration information sent by the configuration center; and the main program updates the memory configuration according to the configuration information.
Wherein the updated configuration information includes a table type of the first data table.
The step of executing, by the configuration center, a preset operation according to the configuration modification request to update the configuration information may include: the configuration center determines a data table needing to be added currently according to a sent configuration modification request, queries a preset corresponding relation by taking the data table needing to be added as a query identifier, and obtains table type information corresponding to the data table needing to be added, wherein the preset mapping relation comprises the corresponding relation between the data table and the table type information; and updating the configuration information according to the table type information.
Wherein, the memory configuration of the main program after updating still supports the data table supported before updating the memory configuration.
For example, the data table supported by the current main program includes a data table a and a data table B, and if the data table that the current service system needs to access is a data table C, the main program updates the memory configuration according to the above operation, and then the data table supported by the main program includes the data table a, the data table B, and the data table C.
Therefore, in this example, the main program may interact with the configuration center to update the memory configuration, so that the memory configuration includes the table type of the first data table to be accessed, the main program can access the first data table in the database according to the table type of the first data table, the table type of the data table to be accessed does not need to be defined in advance, and the efficiency of the data access process is improved.
Optionally, when the main program determines that the table type of the first data table to be accessed currently does not exist in the memory configuration, the main program sends a system notification message to the visualization configuration center; the staff can check the system notification message, inquire the table type of the first data table through a preset data table configuration interface according to the system notification message and execute preset operation to update the configuration information of the configuration center; if the worker does not inquire the table type of the first data table through the preset data table configuration interface, the worker sends the table type information of the first data table to a corresponding technician, and the technician enters the table type of the first data table to update the configuration information of the configuration center.
In one possible example, before the main program receives data request information for the database sent by the service system, the method further includes: when the main program detects that the service system is started; sending a configuration acquisition request to the configuration center; so that the main program receives the configuration information sent by the configuration center; the main program determines the supported table type according to the configuration information; the main program stores the table type in the memory configuration.
It can be seen that, in this example, when the main program detects that communication with the service system is implemented, the main program may automatically interact with the configuration center to obtain the currently supported data table type, so that when the service system sends data request information later, it is timely determined whether the table type of the data table that the service system needs to access is currently supported, and data access efficiency is improved.
In one possible example, the determining, by the main program, whether the table type of the first data table is included in the memory configuration of the main program includes: the main program queries a preset mapping relation by taking the table type of the first data table as a query identifier; if a first table type corresponding to the query identifier is queried, determining that the memory configuration comprises the table type of the first data table; if the table type corresponding to the query identifier is not queried, determining that the table type of the first data table is not included in the memory configuration; the preset mapping relation comprises a table type and a corresponding relation between the table types.
As can be seen, in this example, the main program may query the preset mapping relationship to determine whether the current memory configuration includes the table type of the first data table, so as to access the first data table in time when it is determined that the table type of the first data table exists in the memory configuration or update the memory configuration in time when the table type of the first data table does not exist in the memory configuration.
In one possible example, after the main program determines whether the table type of the first data table is included in the memory configuration of the main program, the method further includes: if yes, the main program executes the data request information configuration operation on the first data table in the database, and the configuration operation includes at least one of the following operations: command operations, field extension storage, and data access are performed.
Therefore, in this example, the main program may store the table types of the multiple data tables, and when the main program determines that the memory configuration includes the table type of the first data table, the main program may directly access the first data table in the database, thereby improving the efficiency of data access.
Referring to fig. 3, fig. 3 is a schematic flow chart of another data access method provided in the embodiment of the present application, and the data access method is applied to a data storage and retrieval system, where the data storage and retrieval system is capable of being communicatively connected to a business system; the data storage and retrieval system comprises a main program, a configuration center and a database, and as shown in the figure, the data access method comprises the following steps:
And step 302, the main program determines the supported table types according to the configuration information.
And 305, the main program determines a first data table which needs to be accessed by the service system currently according to the data request information.
It can be seen that, in the embodiment of the present application, first, a main program receives data request information for the database sent by the service system; secondly, determining a first data table which needs to be accessed by the service system at present according to the data request information; secondly, judging whether the memory configuration of the main program comprises the table type of the first data table; if not, interacting with the configuration center to update the memory configuration, so that the memory configuration comprises the table type of the first data table; finally, the operation configured in the data request information is executed aiming at the first data table in the database. It can be seen that, in the embodiment of the present application, when a data table in a database needs to be accessed by a main program, if a table type of the data table that the current memory configuration does not support to be accessed is found, the main program may interact with a configuration center to update the memory configuration, so that the memory configuration supports the corresponding table type, a table structure of the data table that needs to be accessed does not need to be defined in advance, the efficiency of data access, modification and storage is improved, and the convenience of a data access process is improved.
In addition, the main program can interact with the configuration center to update the memory configuration, so that the memory configuration comprises the table type of the first data table needing to be accessed, the main program can conveniently access the first data table in the database according to the table type of the first data, the table type of the data table needing to be accessed does not need to be defined in advance, and the efficiency of the data access process is improved.
Referring to fig. 4, fig. 4 is a schematic functional flow diagram of a data storage and retrieval system according to an embodiment of the present application, where the data storage and retrieval system includes a main program, a configuration center, and a database, and the data storage and retrieval system is capable of being communicatively connected to a business system, and as shown in the figure, the functional flow of the data storage and retrieval system includes:
step 401, the main program receives data request information for the database sent by the service system.
Step 402, the main program determines a first data table that the service system needs to access currently according to the data request information.
Step 403, the main program determines whether the memory configuration of the main program includes the table type of the first data table; if not, go to step 404.
Step 404, the main program sends a configuration modification request to the configuration center.
Step 405, the configuration center executes a preset operation according to the configuration modification request to update the configuration information;
step 406, the configuration center sends the configuration information to the main program.
Step 407, the main program updates the memory configuration according to the configuration information.
Step 408, the main program sends a data access request for the first data table to the database.
Step 409, the database verifies the table type information in the data access request, and executes the operation configured in the data request information for the first data table after the verification is passed.
Step 410, the database sends a message of successful response to the main program
It can be seen that, in the embodiment of the present application, first, a main program receives data request information for the database sent by the service system; secondly, determining a first data table which needs to be accessed by the service system at present according to the data request information; secondly, judging whether the memory configuration of the main program comprises the table type of the first data table; if not, interacting with the configuration center to update the memory configuration, so that the memory configuration comprises the table type of the first data table; finally, the operation of data request information configuration is executed aiming at the first data table in the database. It can be seen that, in the embodiment of the present application, when a data table in a database needs to be accessed by a main program, if a table type of the data table that the current memory configuration does not support to be accessed is found, the main program may interact with a configuration center to update the memory configuration, so that the memory configuration supports the corresponding table type, a table structure of the data table that needs to be accessed does not need to be defined in advance, the efficiency of data access, modification and storage is improved, and the convenience of a data access process is improved.
In accordance with the embodiments shown in fig. 2, fig. 3, and fig. 4, please refer to fig. 5, and fig. 5 is a schematic structural diagram of a server 500 provided in the embodiments of the present application, and as shown in the figure, the server 500 includes an application processor 510, a memory 520, a communication interface 530, and one or more programs 521, where the one or more programs 521 are stored in the memory 520 and configured to be executed by the application processor 510, the server may run a data storage and retrieval system, the data storage and retrieval system includes a main program, a configuration center, and a database, and the server 500 may include the database, or the server may be separated from the server but may be connected to the server through communication; the server can also run a service system or realize communication connection with a carrier carrying the service system; the one or more programs 521 include instructions for performing the following steps;
the main program receives data request information aiming at the database and sent by the service system;
the main program determines a first data table which needs to be accessed by the service system currently according to the data request information;
the main program judges whether the memory configuration of the main program comprises the table type of the first data table or not;
if not, the main program interacts with the configuration center to update the memory configuration, so that the memory configuration comprises the table type of the first data table;
and the main program executes the operation configured in the data request information aiming at the first data table in the database.
It can be seen that, in the embodiment of the present application, first, a main program receives data request information for the database sent by the service system; secondly, determining a first data table which needs to be accessed by the service system at present according to the data request information; secondly, judging whether the memory configuration of the main program comprises the table type of the first data table; if not, interacting with the configuration center to update the memory configuration, so that the memory configuration comprises the table type of the first data table; finally, the operation of data request information configuration is executed aiming at the first data table in the database. It can be seen that, in the embodiment of the present application, when a data table in a database needs to be accessed by a main program, if a table type of the data table that the current memory configuration does not support to be accessed is found, the main program may interact with a configuration center to update the memory configuration, so that the memory configuration supports the corresponding table type, a table structure of the data table that needs to be accessed does not need to be defined in advance, the efficiency of data access, modification and storage is improved, and the convenience of a data access process is improved.
In one possible example, in terms of the main program interacting with the configuration center to update the memory configuration, the instructions in the program are specifically configured to perform the following operations: the main program sends a configuration modification request to the configuration center, so that the configuration center executes preset operation according to the configuration modification request to update the configuration information; the main program receives the configuration information sent by the configuration center; and the main program updates the memory configuration according to the configuration information.
In one possible example, before the main program receives the data request information for the database sent by the business system, the instructions in the program are further configured to: when the main program detects that the service system is started; sending a configuration acquisition request to the configuration center; so that the main program receives the configuration information sent by the configuration center; the main program determines the supported table type according to the configuration information; the main program stores the table type in the memory configuration.
In one possible example, in terms of the main program determining whether the memory configuration of the main program includes the table type of the first data table, the instructions in the program are specifically configured to perform the following operations: the main program queries a preset mapping relation by taking the table type of the first data table as a query identifier; if a first table type corresponding to the query identifier is queried, determining that the memory configuration comprises the table type of the first data table; if the table type corresponding to the query identifier is not queried, determining that the table type of the first data table is not included in the memory configuration; the preset mapping relation comprises a table type and a corresponding relation between the table types.
In one possible example, after the main program determines whether the table type of the first data table is included in the memory configuration of the main program, the instructions in the program are further configured to: if yes, the main program executes the data request information configuration operation on the first data table in the database, and the configuration operation includes at least one of the following operations: command operations, field extension storage, and data access are performed.
It is understood that the electronic device comprises corresponding hardware structures and/or software modules for performing the respective functions in order to realize the above-mentioned functions. Those of skill in the art will readily appreciate that the present application is capable of hardware or a combination of hardware and computer software implementing the various illustrative elements and algorithm steps described in connection with the embodiments provided herein. Whether a function is performed as hardware or computer software drives hardware depends upon the particular application and design constraints imposed on the solution. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present application.
In the embodiment of the present application, the electronic device may be divided into the functional units according to the method example, for example, each functional unit may be divided corresponding to each function, or two or more functions may be integrated into one processing unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit. It should be noted that the division of the unit in the embodiment of the present application is schematic, and is only a logic function division, and there may be another division manner in actual implementation.
Fig. 6 is a block diagram of functional units of a data access device 600 according to an embodiment of the present application. The data access device 600 is applied to a data storage and retrieval system which can be in communication connection with a business system; the data storage and retrieval system comprises a main program, a configuration center and a database, the data access device comprises a communication unit 601, a determination unit 602, a judgment unit 603, an interaction unit 604 and an execution unit 605, wherein,
the communication unit 601 is configured to receive, by the main program, data request information for the database sent by a service system;
the determining unit 602 is configured to determine, by the main program, a first data table that the service system needs to access currently according to the data request information;
the determining unit 603 is configured to determine, by the main program, whether the memory configuration of the main program includes a table type of the first data table;
the interaction unit 604 is configured to, if not, interact with the main program and the configuration center to update the memory configuration, so that the memory configuration includes a table type of the first data table;
the execution unit 605, the main program performs the operation of configuring the data request information for the first data table in the database.
It can be seen that, in the embodiment of the present application, first, a main program receives data request information for the database sent by the service system; secondly, determining a first data table which needs to be accessed by the service system at present according to the data request information; secondly, judging whether the memory configuration of the main program comprises the table type of the first data table; if not, interacting with the configuration center to update the memory configuration, so that the memory configuration comprises the table type of the first data table; finally, the operation of data request information configuration is executed aiming at the first data table in the database. It can be seen that, in the embodiment of the present application, when a data table in a database needs to be accessed by a main program, if a table type of the data table that the current memory configuration does not support to be accessed is found, the main program may interact with a configuration center to update the memory configuration, so that the memory configuration supports the corresponding table type, a table structure of the data table that needs to be accessed does not need to be defined in advance, the efficiency of data access, modification and storage is improved, and the convenience of a data access process is improved.
In a possible example, in terms of the main program interacting with the configuration center to update the memory configuration, the interacting unit 604 is specifically configured to: the main program sends a configuration modification request to the configuration center, so that the configuration center executes preset operation according to the configuration modification request to update the configuration information; the main program receives the configuration information sent by the configuration center; and the main program updates the memory configuration according to the configuration information.
In one possible example, before the main program receives the data request information for the database sent by the business system, the interaction unit 604 is further configured to: when the main program detects that the service system is started; sending a configuration acquisition request to the configuration center; so that the main program receives the configuration information sent by the configuration center; the main program determines the supported table type according to the configuration information; the main program stores the table type in the memory configuration.
In a possible example, in terms of the main program determining whether the memory configuration of the main program includes the table type of the first data table, the determining unit 603 is specifically configured to: the main program queries a preset mapping relation by taking the table type of the first data table as a query identifier; if a first table type corresponding to the query identifier is queried, determining that the memory configuration comprises the table type of the first data table; if the table type corresponding to the query identifier is not queried, determining that the table type of the first data table is not included in the memory configuration; the preset mapping relation comprises a table type and a corresponding relation between the table types.
In one possible example, after the main program determines whether the table type of the first data table is included in the memory configuration of the main program, the execution unit 605 is further configured to: if yes, the main program executes the data request information configuration operation on the first data table in the database, and the configuration operation includes at least one of the following operations: command operations, field extension storage, and data access are performed.
Embodiments of the present application also provide a computer storage medium, where the computer storage medium stores a computer program for electronic data exchange, the computer program enabling a computer to execute part or all of the steps of any one of the methods described in the above method embodiments, and the computer includes an electronic device.
Embodiments of the present application also provide a computer program product comprising a non-transitory computer readable storage medium storing a computer program operable to cause a computer to perform some or all of the steps of any of the methods as described in the above method embodiments. The computer program product may be a software installation package, the computer comprising an electronic device.
It should be noted that, for simplicity of description, the above-mentioned method embodiments are described as a series of acts or combination of acts, but those skilled in the art will recognize that the present application is not limited by the order of acts described, as some steps may occur in other orders or concurrently depending on the application. Further, those skilled in the art should also appreciate that the embodiments described in the specification are preferred embodiments and that the acts and modules referred to are not necessarily required in this application.
In the foregoing embodiments, the descriptions of the respective embodiments have respective emphasis, and for parts that are not described in detail in a certain embodiment, reference may be made to related descriptions of other embodiments.
In the embodiments provided in the present application, it should be understood that the disclosed apparatus may be implemented in other manners. For example, the above-described embodiments of the apparatus are merely illustrative, and for example, the above-described division of the units is only one type of division of logical functions, and other divisions may be realized in practice, for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection of some interfaces, devices or units, and may be an electric or other form.
The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
In addition, functional units in the embodiments of the present application may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.
The integrated unit may be stored in a computer readable memory if it is implemented in the form of a software functional unit and sold or used as a stand-alone product. Based on such understanding, the technical solution of the present application may be substantially implemented or a part of or all or part of the technical solution contributing to the prior art may be embodied in the form of a software product stored in a memory, and including several instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the above-mentioned method of the embodiments of the present application. And the aforementioned memory comprises: various media capable of storing program codes, such as a usb disk, a read-Only Memory (ROM), a Random Access Memory (RAM), a removable hard disk, a magnetic disk, or an optical disk.
Those skilled in the art will appreciate that all or part of the steps in the methods of the above embodiments may be implemented by associated hardware instructed by a program, which may be stored in a computer-readable memory, which may include: flash Memory disks, read-Only memories (ROMs), Random Access Memories (RAMs), magnetic or optical disks, and the like.
The foregoing detailed description of the embodiments of the present application has been presented to illustrate the principles and implementations of the present application, and the above description of the embodiments is only provided to help understand the method and the core concept of the present application; meanwhile, for a person skilled in the art, according to the idea of the present application, there may be variations in the specific embodiments and the application scope, and in summary, the content of the present specification should not be construed as a limitation to the present application.
Claims (10)
1. A data access method is characterized in that the method is applied to a data storage and retrieval system, and the data storage and retrieval system can be in communication connection with a business system; the data storage and retrieval system comprises a main program, a configuration center and a database, and the method comprises the following steps:
the main program receives data request information aiming at the database and sent by the service system;
the main program determines a first data table which needs to be accessed by the service system currently according to the data request information;
the main program judges whether the memory configuration of the main program comprises the table type of the first data table or not;
if not, the main program interacts with the configuration center to update the memory configuration, so that the memory configuration comprises the table type of the first data table;
the main program executes the operation configured in the data request information aiming at the first data table in the database;
wherein the performing the operation configured in the data request information for the first data table in the database comprises: the main program determines the operation which needs to be executed by the service system aiming at least one data message according to the data request message; the main program generates an operation list for executing the configured operation according to the operation to be executed by each data information in the at least one data information; the main program accesses the first data table in the database and executes corresponding operation aiming at the first data table according to the operation list; wherein the configuring comprises: and finishing command operation, field extension storage and data access.
2. The method of claim 1, wherein the main program interacting with the configuration center to update the memory configuration comprises:
the main program sends a configuration modification request to the configuration center, so that the configuration center executes preset operation according to the configuration modification request to update the configuration information currently stored by the configuration center;
the main program receives the configuration information sent by the configuration center;
and the main program updates the memory configuration according to the configuration information.
3. The method of claim 2, wherein before the main program receives the data request information for the database sent by the service system, the method further comprises:
when the main program detects that the service system is started, sending a configuration acquisition request to the configuration center so that the main program receives the configuration information sent by the configuration center;
the main program determines the supported table type according to the configuration information;
the main program stores the table type in the memory configuration.
4. The method of claim 2, wherein the determining by the main program whether the table type of the first data table is included in the memory configuration of the main program comprises:
the main program queries a preset mapping relation by taking the table type of the first data table as a query identifier; if a first table type corresponding to the query identifier is queried, determining that the memory configuration comprises the table type of the first data table; if the table type corresponding to the query identifier is not queried, determining that the table type of the first data table is not included in the memory configuration; the preset mapping relation comprises a table type and a corresponding relation between the table types.
5. The method of claim 1, wherein after the main program determines whether the memory configuration of the main program includes the table type of the first data table, the method further comprises:
if yes, the main program executes the data request information configuration operation on the first data table in the database, and the configuration operation includes at least one of the following operations: command operations, field extension storage, and data access are performed.
6. A data storage and retrieval system, comprising: the system comprises a main program, a configuration center and a database, wherein the data storage and retrieval system can be in communication connection with a service system, and comprises:
the main program is used for receiving data request information aiming at the database sent by the service system; determining a first data table which needs to be accessed by the service system at present according to the data request information; judging whether the memory configuration of the main program comprises the table type of the first data table or not; if not, interacting with the configuration center to update the memory configuration; and an operation for executing the configuration in the data request information for the first data table; wherein the executing the operational aspect configured in the data request information for the first data table in the database, the main program is further configured to: determining the operation which needs to be executed by the service system aiming at least one data message according to the data request message; generating an operation list for executing the configured operation according to the operation to be executed by each data information in the at least one data information; accessing the first data table in the database, and executing corresponding operation on the first data table according to the operation list; wherein the configuring comprises: and finishing command operation, field extension storage and data access.
7. The system of claim 6, wherein the main program interacts with the configuration center to update the memory configuration, comprising:
the main program is used for sending a configuration modification request to the configuration center;
the configuration center is used for receiving the configuration modification request; executing preset operation according to the configuration modification request to update the currently stored configuration information; and sending the configuration information to the main program;
the main program is also used for receiving the configuration information; and updating the memory configuration according to the configuration information.
8. A data access device is applied to a data storage and retrieval system which can be in communication connection with a business system; the data storage and retrieval system comprises a main program, a configuration center and a database, and the data access device comprises:
the communication unit is used for receiving data request information aiming at the database sent by the service system by the main program;
a determining unit, configured to determine, by the main program, a first data table that the service system currently needs to access according to the data request information;
a judging unit, configured to judge, by the main program, whether a table type of the first data table is included in a memory configuration of the main program;
if not, the main program interacts with the configuration center to update the memory configuration, so that the memory configuration comprises the table type of the first data table;
an execution unit, configured to execute, by the main program, an operation configured in the data request information with respect to the first data table in the database;
wherein, the executing unit executes the operation configured in the data request information for the first data table in the database, and specifically executes: determining the operation which needs to be executed by the service system aiming at least one data message according to the data request message; generating an operation list for executing the configured operation according to the operation to be executed by each data information in the at least one data information; accessing the first data table in the database, and executing corresponding operation on the first data table according to the operation list; wherein the configuring comprises: and finishing command operation, field extension storage and data access.
9. A server, comprising a processor, memory, a communication interface, and one or more programs stored in the memory and configured to be executed by the processor, the programs including instructions for performing the steps in the method of any of claims 1-5.
10. A computer-readable storage medium, characterized in that a computer program for electronic data exchange is stored, wherein the computer program causes a computer to perform the method according to any one of claims 1-5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811640258.2A CN109800229B (en) | 2018-12-29 | 2018-12-29 | Data access method and related equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811640258.2A CN109800229B (en) | 2018-12-29 | 2018-12-29 | Data access method and related equipment |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109800229A CN109800229A (en) | 2019-05-24 |
| CN109800229B true CN109800229B (en) | 2021-10-08 |
Family
ID=66558237
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811640258.2A Active CN109800229B (en) | 2018-12-29 | 2018-12-29 | Data access method and related equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109800229B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111522817B (en) * | 2020-04-22 | 2023-05-12 | 支付宝(杭州)信息技术有限公司 | Table content mapping system, method and non-transitory storage medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6917944B1 (en) * | 2001-08-30 | 2005-07-12 | Cisco Technology, Inc. | Method and apparatus for configuring access to a plurality of data repositories |
| CN102200977A (en) * | 2010-03-23 | 2011-09-28 | 国际商业机器公司 | Method and system for extending database table under multi-tenant environment |
| CN103914458A (en) * | 2012-12-29 | 2014-07-09 | 中国移动通信集团河北有限公司 | Mass data migration method and device |
| CN104750810A (en) * | 2015-03-30 | 2015-07-01 | 浪潮集团有限公司 | Data querying and processing method based on configuration |
| CN106326499A (en) * | 2016-10-14 | 2017-01-11 | 广州市千钧网络科技有限公司 | Data processing method and device |
Family Cites Families (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080016048A1 (en) * | 2006-07-12 | 2008-01-17 | Dettinger Richard D | Intelligent condition pruning for size minimization of dynamic, just in time tables |
| CN101068161A (en) * | 2007-06-26 | 2007-11-07 | 中兴通讯股份有限公司 | Method for dynamic generating network equipment configuration strategic group |
| CN101546311B (en) * | 2008-03-27 | 2012-05-02 | 北京铭万互联科技有限公司 | Data processing method and data processing device for recycle bin |
| US10127275B2 (en) * | 2014-07-11 | 2018-11-13 | International Business Machines Corporation | Mapping query operations in database systems to hardware based query accelerators |
| CN106156050B (en) * | 2015-03-27 | 2020-01-10 | 阿里巴巴集团控股有限公司 | Data processing method and device |
| CN105095056B (en) * | 2015-08-14 | 2018-01-12 | 焦点科技股份有限公司 | A kind of method of data warehouse data monitoring |
| CN106446019B (en) * | 2016-08-27 | 2019-09-17 | 南京安元科技有限公司 | A kind of software function treating method and apparatus |
-
2018
- 2018-12-29 CN CN201811640258.2A patent/CN109800229B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6917944B1 (en) * | 2001-08-30 | 2005-07-12 | Cisco Technology, Inc. | Method and apparatus for configuring access to a plurality of data repositories |
| CN102200977A (en) * | 2010-03-23 | 2011-09-28 | 国际商业机器公司 | Method and system for extending database table under multi-tenant environment |
| CN103914458A (en) * | 2012-12-29 | 2014-07-09 | 中国移动通信集团河北有限公司 | Mass data migration method and device |
| CN104750810A (en) * | 2015-03-30 | 2015-07-01 | 浪潮集团有限公司 | Data querying and processing method based on configuration |
| CN106326499A (en) * | 2016-10-14 | 2017-01-11 | 广州市千钧网络科技有限公司 | Data processing method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109800229A (en) | 2019-05-24 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107995215B (en) | Control method and device of intelligent household equipment and cloud platform server | |
| CN102255887B (en) | Method and system for providing online services corresponding to multiple mobile devices | |
| CN110762775B (en) | Upgrading method of air conditioner and air conditioner | |
| CN110113247B (en) | Rich media information receiving and sending system, sending and displaying method and terminal equipment | |
| CN104850301A (en) | Method and system for classifying application icons on system desktop | |
| CN106302448B (en) | Remote access control method and device | |
| CN106897162B (en) | Communication mode selection method of component in application, communication system and mobile terminal | |
| CN103491522A (en) | Terminal adaption method and device | |
| CN108234551B (en) | Data processing method and device | |
| CN102722404B (en) | Management system, device and method for application software in intelligent terminal | |
| CN109800229B (en) | Data access method and related equipment | |
| US20160378553A1 (en) | Resource Management Method and Device for Terminal System | |
| CN105792025A (en) | Device information obtaining method and terminal | |
| CN104144170A (en) | URL filtering method, device and system | |
| CN105763616A (en) | Resource-downloading method and device | |
| CN105511273A (en) | Client operation management method and client | |
| CN103327133A (en) | Method and device for updating geographic position information | |
| CN110442059B (en) | Controlled equipment expanding method and device and control equipment | |
| CN106293814B (en) | Upgrading method and device | |
| CN103354927A (en) | Method and apparatus for managing content in a processing device | |
| CN112764874A (en) | CMDB configuration management system-based virtual machine server information acquisition method | |
| CN105610596B (en) | Resource directory management method and network terminal | |
| CN110728379A (en) | Configuration information management method and device, electronic equipment and non-transitory storage medium | |
| CN113301203B (en) | Method and device for updating historical information data based on address book | |
| CN105991729B (en) | Installation package downloading method and server |
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 |