CN111651488A - Database service processing method, device, medium and electronic equipment - Google Patents

Database service processing method, device, medium and electronic equipment Download PDF

Info

Publication number
CN111651488A
CN111651488A CN202010473304.5A CN202010473304A CN111651488A CN 111651488 A CN111651488 A CN 111651488A CN 202010473304 A CN202010473304 A CN 202010473304A CN 111651488 A CN111651488 A CN 111651488A
Authority
CN
China
Prior art keywords
service
micro
parameter
manuscript
name
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.)
Granted
Application number
CN202010473304.5A
Other languages
Chinese (zh)
Other versions
CN111651488B (en
Inventor
王国琛
杨光
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Taikang Asset Management Co ltd
Taikang Insurance Group Co Ltd
Original Assignee
Taikang Asset Management Co ltd
Taikang Insurance Group Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Taikang Asset Management Co ltd, Taikang Insurance Group Co Ltd filed Critical Taikang Asset Management Co ltd
Priority to CN202010473304.5A priority Critical patent/CN111651488B/en
Publication of CN111651488A publication Critical patent/CN111651488A/en
Application granted granted Critical
Publication of CN111651488B publication Critical patent/CN111651488B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2455Query execution
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/242Query formulation
    • G06F16/2433Query languages
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02DCLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
    • Y02D10/00Energy efficient computing, e.g. low power processors, power management or thermal management

Abstract

The invention provides a database service processing method, which comprises the following steps: acquiring a timing task, wherein the timing task comprises the name and preset time of a work manuscript; calling a working manuscript corresponding to the name of the working manuscript according to the name of the working manuscript, wherein the working manuscript comprises a service call table; traversing the service call table at the preset time to acquire the identifier of the micro service, the parameter name of the micro service, the parameter value of the micro service and the output address of each micro service in the service call table; the micro service identification, the micro service parameter name, the micro service parameter value and the output address of each micro service in the service calling table are used for calling the business data related to the micro service, so that the defects caused by calling the business data by manual operation can be solved at least to a certain extent. The invention also provides a database service processing device, a medium and electronic equipment.

Description

Database service processing method, device, medium and electronic equipment
Technical Field
The invention relates to the technical field of data processing, in particular to a database service processing method, a database service processing device, a database service processing medium and electronic equipment.
Background
With the rapid development of the internet, various service data are generated. The business data may be stored in a database in one or more machines and may be called by business functions when using the business data. However, when the service personnel calls the service data, a large amount of computer languages are required to be written manually to view the form data in the database, so that the service personnel is required to master the basic computer language, such as SQL language. When too many forms are involved, the corresponding storage process is called, but the calling and writing of the storage process are more complicated and complicated, and the method is a great problem for business personnel in non-computer backgrounds.
It is to be noted that the information disclosed in the above background section is only for enhancement of understanding of the background of the present invention and therefore may include information that does not constitute prior art known to a person of ordinary skill in the art.
Disclosure of Invention
Embodiments of the present invention provide a method, an apparatus, a medium, and an electronic device for processing a service of a database, so as to solve at least a defect caused by manual operation when calling service data.
Additional features and advantages of the invention will be set forth in the detailed description which follows, or may be learned by practice of the invention.
According to a first aspect of the embodiments of the present invention, a method for processing a service of a database is provided, including: acquiring a timing task, wherein the timing task comprises the name and preset time of a work manuscript; calling a working manuscript corresponding to the name of the working manuscript according to the name of the working manuscript, wherein the working manuscript comprises a service call table; traversing the service call table at preset time to acquire the identifier of the micro service, the parameter name of the micro service, the parameter value of the micro service and the output address of each micro service in the service call table; and calling business data related to the micro-service through the identification of the micro-service, the parameter name of the micro-service, the parameter value of the micro-service and the output address of each micro-service in a service call table, wherein the work manuscript comprises N preset areas, and the service call table is distributed in one preset area of the N preset areas.
In some embodiments of the present invention, the above work manuscript may further include any one or more of the following items: the system comprises an input parameter table and a report configuration table, wherein the input parameter table and the report configuration table are respectively distributed in one preset area of N preset areas, the input parameter table comprises contents for updating parameter names of micro services and parameter values of the micro services in a service call table, and the report configuration table comprises user information for receiving the service data.
In some embodiments of the invention, prior to traversing the service call table, the method further comprises: reading a dynamic formula in the working manuscript, and determining the content which is required by the current round of calling the service data and is used for updating the parameter name of the micro service and the parameter value of the micro service in the service calling table according to the dynamic formula; generating KV pairing of parameter names and parameter values based on the content of the parameter names and parameter values of the micro services required by the current round of calling the service data and used for updating the parameter names and the parameter values of the micro services in the service calling table; and updating the parameter name of the micro service and the parameter value of the micro service in the service call table according to the KV pairing.
In some embodiments of the invention, the method further comprises: adding the business data to corresponding output addresses according to the output addresses of the micro services in the work manuscript; and sending the work manuscript added with the service data to the user according to the user information for receiving the service data.
In some embodiments of the present invention, the report configuration table further includes a preset operation logic, and the method further includes: and updating a dynamic formula in the working manuscript according to the preset operation logic, or updating and combining the output modes of the micro services according to the preset operation logic.
In some embodiments of the invention, the method further comprises: and determining the running frequency of the timed task according to a preset reference day, and dynamically updating the preset time according to the running frequency.
In some embodiments of the present invention, the invoking of the business data related to the micro service through the identification of the micro service, the parameter name of the micro service, the parameter value of the micro service, and the output address of each micro service in the service invocation table comprises: acquiring the identifier of the micro service, the parameter name of the micro service, the parameter value of the micro service and the network address related to the output address of each micro service in the service call table through a domain name service protocol; and calling the service data related to the micro service from a database according to the network address.
According to a second aspect of the embodiments of the present invention, there is provided a service processing apparatus for a database, including: the system comprises a first acquisition module, a second acquisition module and a third acquisition module, wherein the first acquisition module is used for acquiring a timing task, and the timing task comprises the name and preset time of a work manuscript; the first calling module is used for calling the working manuscript corresponding to the name of the working manuscript according to the name of the working manuscript, wherein the working manuscript comprises a service call table; the traversal module traverses the service call table at the preset time to acquire the identification of the micro service, the parameter name of the micro service, the parameter value of the micro service and the output address of each micro service in the service call table; the second calling module is used for calling the business data related to the micro-service through the identification of the micro-service, the parameter name of the micro-service, the parameter value of the micro-service and the output address of each micro-service in the service calling table; the working manuscript is provided with N preset areas, and the service call table is distributed in one of the N preset areas.
In some embodiments of the present invention, the above-mentioned work script may further comprise any one or more of the following: the system comprises an input parameter table and a report configuration table, wherein the input parameter table and the report configuration table are respectively distributed in one preset area of N preset areas, the input parameter table comprises contents for updating parameter names of micro services and parameter values of the micro services in a service call table, and the report configuration table comprises user information for receiving the service data.
In some embodiments of the invention, the apparatus further comprises: the determining module is used for reading a dynamic formula in the working manuscript and determining the content which is required by the current round of calling the service data and is used for updating the parameter name of the micro service and the parameter value of the micro service in the service calling table according to the dynamic formula; the generation module generates KV pairing of the parameter names and the parameter values based on the content of the parameter names and the parameter values of the micro services required by the current round of calling the service data and used for updating the micro services in the service calling table; and the first updating module is used for updating the parameter name of the micro service and the parameter value of the micro service in the service call table according to the KV pairing.
In some embodiments of the invention, the apparatus further comprises: the adding module is used for adding the business data to the corresponding output address according to the output address of each micro service in the work manuscript; and the sending module is used for sending the work manuscript added with the service data to the user according to the user information used for receiving the service data.
In some embodiments of the present invention, the report configuration table further includes a preset operation logic, and the apparatus further includes: and the second updating module is used for updating the dynamic formula in the working manuscript according to the preset operation logic or updating and combining the output mode of each micro service according to the preset operation logic.
In some embodiments of the invention, the apparatus further comprises: and the third updating module is used for determining the running frequency of the timed task according to a preset reference day and dynamically updating the preset time according to the running frequency.
In some embodiments of the present invention, the second calling module includes: the second acquisition module is used for acquiring the identifier of the micro service, the parameter name of the micro service, the parameter value of the micro service and the network address related to the output address of each micro service in the service call table through a domain name service protocol; and the submodule of the second calling module is used for calling the service data related to the micro service from the database according to the network address.
According to a third aspect of embodiments of the present invention, there is provided an electronic apparatus, including: one or more processors; a storage device, configured to store one or more programs, which when executed by the one or more processors, cause the one or more processors to implement the method for processing the services of the database according to the first aspect of the embodiments.
According to a fourth aspect of the embodiments of the present invention, there is provided a computer-readable medium, on which a computer program is stored, which when executed by a processor, implements the method for processing the services of the database as described in the first aspect of the embodiments above.
The technical scheme provided by the embodiment of the invention has the following beneficial effects:
in the technical scheme provided by some embodiments of the present invention, a timing task is obtained, the timing task includes a name and a preset time of a work manuscript, the work manuscript corresponding to the name of the work manuscript is called according to the name of the work manuscript, the work manuscript includes a service call table, the service call table is traversed at the preset time to obtain an identifier of a micro service, a parameter name of the micro service, a parameter value of the micro service, and an output address of each micro service in the service call table, and service data related to the micro service is called through the identifier of the micro service, the parameter name of the micro service, the parameter value of the micro service, and the output address of each micro service in the service call table, so that a service person is not required to manually write a computer language in calling the service data, thereby improving the work efficiency. Moreover, the labor cost is reduced to a certain extent, and the condition that the recalled business data is inaccurate due to errors of the manually written computer language can be avoided.
It is to be understood that both the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the invention, as claimed.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the invention and together with the description, serve to explain the principles of the invention. It is obvious that the drawings in the following description are only some embodiments of the invention, and that for a person skilled in the art, other drawings can be derived from them without inventive effort. In the drawings:
fig. 1 is a schematic diagram illustrating an exemplary system architecture of a business processing method of a database or a business processing apparatus of a database to which an embodiment of the present invention may be applied;
FIG. 2 schematically shows a flow chart of a method of business processing of a database according to an embodiment of the invention;
FIG. 3 schematically illustrates a flow diagram of a method of business processing of a database in accordance with another embodiment of the invention;
FIG. 4 schematically illustrates a flow diagram of a method of business processing of a database in accordance with another embodiment of the invention;
FIG. 5 schematically illustrates a flow diagram of a method of business processing of a database in accordance with another embodiment of the invention;
FIG. 6 schematically illustrates a schematic diagram of a work script in an embodiment of the present invention;
FIG. 7 schematically shows a block diagram of a database transaction device according to an embodiment of the invention;
FIG. 8 schematically shows a block diagram of a database transaction device according to another embodiment of the invention;
FIG. 9 schematically shows a block diagram of a database transaction device according to another embodiment of the invention;
FIG. 10 schematically shows a block diagram of a database transaction device according to another embodiment of the invention;
FIG. 11 schematically shows a block diagram of a database transaction device according to another embodiment of the present invention;
FIG. 12 schematically shows a block diagram of a database transaction device according to another embodiment of the invention;
FIG. 13 illustrates a schematic structural diagram of a computer system suitable for use with the electronic device to implement an embodiment of the invention.
Detailed Description
Example embodiments will now be described more fully with reference to the accompanying drawings. Example embodiments may, however, be embodied in many different forms and should not be construed as limited to the examples set forth herein; rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the concept of example embodiments to those skilled in the art.
Furthermore, the described features, structures, or characteristics may be combined in any suitable manner in one or more embodiments. In the following description, numerous specific details are provided to provide a thorough understanding of embodiments of the invention. One skilled in the relevant art will recognize, however, that the invention may be practiced without one or more of the specific details, or with other methods, components, devices, steps, and so forth. In other instances, well-known methods, devices, implementations or operations have not been shown or described in detail to avoid obscuring aspects of the invention.
The block diagrams shown in the figures are functional entities only and do not necessarily correspond to physically separate entities. I.e. these functional entities may be implemented in the form of software, or in one or more hardware modules or integrated circuits, or in different networks and/or processor means and/or microcontroller means.
The flow charts shown in the drawings are merely illustrative and do not necessarily include all of the contents and operations/steps, nor do they necessarily have to be performed in the order described. For example, some operations/steps may be decomposed, and some operations/steps may be combined or partially combined, so that the actual execution sequence may be changed according to the actual situation.
Fig. 1 is a schematic diagram illustrating an exemplary system architecture of a database service processing method or a database service processing apparatus to which an embodiment of the present invention may be applied.
As shown in fig. 1, the system architecture 100 may include one or more of terminal devices 101, 102, 103, a network 104, and a server 105. The network 104 serves as a medium for providing communication links between the terminal devices 101, 102, 103 and the server 105. Network 104 may include various connection types, such as wired, wireless communication links, or fiber optic cables, to name a few.
It should be understood that the number of terminal devices, networks, and servers in fig. 1 is merely illustrative. There may be any number of terminal devices, networks, and servers, as desired for implementation. For example, server 105 may be a server cluster comprised of multiple servers, or the like.
The user may use the terminal devices 101, 102, 103 to interact with the server 105 via the network 104 to receive or send messages or the like. The terminal devices 101, 102, 103 may be various electronic devices having a display screen, including but not limited to smart phones, tablet computers, portable computers, desktop computers, and the like.
The server 105 may be a server that provides various services. For example, the server 105 may obtain a user request from the terminal device 103 (or the terminal device 101 or 102), obtain a timing task according to the user request, the timing task includes a name of a work manuscript and a preset time, call the work manuscript corresponding to the name of the work manuscript according to the name of the work manuscript, the work manuscript includes a service call table, traverse the service call table at the preset time to obtain an identifier of a microservice, a parameter name of the microservice, a parameter value of the microservice, and an output address of each microservice in the service call table, and call service data related to the microservice through the identifier of the microservice, the parameter name of the microservice, the parameter value of the microservice, and the output address of each microservice in the service call table, in this way, the service data does not need a service person to manually write a computer language any more, thereby improving the working efficiency. Moreover, the labor cost is reduced to a certain extent, and the condition that the recalled business data is inaccurate due to errors of the manually written computer language can be avoided.
In some embodiments, the database service processing method provided by the embodiment of the present invention is generally executed by the server 105, and accordingly, the service processing device of the database is generally disposed in the server 105. In other embodiments, some terminals may have similar functionality as the server to perform the method. Therefore, the service processing method of the database provided by the embodiment of the invention is not limited to be executed at the server side.
Fig. 2 schematically shows a flowchart of a database business processing method according to an embodiment of the present invention.
As shown in fig. 2, the database service processing method may include steps S210 to S240.
In step S210, a timing task is acquired, where the timing task includes a name of the work manuscript and a preset time.
In step S220, a work manuscript corresponding to the name of the work manuscript is called according to the name of the work manuscript, where the work manuscript includes a service call table.
In step S230, traversing the service call table at the preset time to obtain the identifier of the micro service, the parameter name of the micro service, the parameter value of the micro service, and the output address of each micro service in the service call table.
In step S240, the service data related to the micro service is called through the identifier of the micro service, the parameter name of the micro service, the parameter value of the micro service, and the output address of each micro service in the service call table.
The method can obtain a timing task, the timing task comprises a name and preset time of a work manuscript, the work manuscript corresponding to the name of the work manuscript is called according to the name of the work manuscript, the work manuscript comprises a service call table, the service call table is traversed at the preset time to obtain an identifier of a micro service, a parameter name of the micro service, a parameter value of the micro service and an output address of each micro service in the service call table, and service data related to the micro service is called through the identifier of the micro service, the parameter name of the micro service, the parameter value of the micro service and the output address of each micro service in the service call table, so that service data are called without needing service personnel to manually write a computer language, and the working efficiency is improved. Moreover, the labor cost is reduced to a certain extent, and the condition that the recalled business data is inaccurate due to errors of the manually written computer language can be avoided.
In an embodiment of the present invention, the timing task may be set according to a name and a preset time of the work manuscript. In this example, the method further includes determining an operating frequency of the timed task according to a preset reference day, and dynamically updating the preset time according to the operating frequency. For example, the preset time may be dynamically updated according to the operating frequency. Wherein, the operation frequency can be determined according to the reference day in the configuration table. The timing task table and the configuration table are specifically as follows:
timing task table
Task file Frequency of operation Date of operation Run time
Working manuscript A Second working day of month 2019-08-02 09:07
Working manuscript B Second working day of each quarter 2019-09-07 09:21
The information of the second row or the information of the third row in the above timed task table can be regarded as the content of one timed task. For example, the work manuscript a is a name of the work manuscript, and the operation date and the operation time may be the above-mentioned preset time. Wherein the operation date and the operation time can be dynamically updated according to the operation frequency.
Configuration table
Reference day 2019-08-29
Monday of week on which the reference day is located 2019-08-26
Day one of the month of the reference day 2019-08-01
The operating frequency can be determined according to the second row information or the third row information in the configuration table.
In one embodiment of the invention, the execution schedule and the working day querier of the work manuscript can be defined by the timing task table. For example, executing a calendar queries a weekday querier every minute and updates the calendar, filtering out the work script that should be executed at the current time. And then automatically starting the corresponding working manuscript at regular time through a network request.
In an embodiment of the present invention, the work manuscript includes N preset areas, and the parameter for calling the service data is distributed in each of the N preset areas. For example, the work script may be an excel document. The N preset areas in the working manuscript can be marked and named through the name manager, and parameters distributed in each preset area can be marked and named through the name manager. The parameters for calling the service data may be parameters in a service call table, parameters in an input parameter table, and/or parameters in a report configuration table.
Referring to fig. 6, fig. 6 is a schematic diagram of a working manuscript including three preset regions, a1, a2, and A3. A4 may be sheet, for example, sheet1 is meta, the meta includes contents in the work manuscript, sheets 2 to 7 may correspond to "result output" in the service call table, sheet2 corresponds to a result1 asset detail table, sheet3 corresponds to a result2 accounting classification proportion statistical table, sheet4 corresponds to a result3 income detail table, sheet5 corresponds to a result4 security restocking table, sheet6 corresponds to a result financial balance table, and sheet7 corresponds to a result estimation table.
In an embodiment of the present invention, the parameter for invoking the service data includes any one or more of the following items: the method comprises the following steps of setting parameters of a service call table, parameters of an input parameter table and parameters of a report configuration table, wherein the service call table, the input parameter table and the report configuration table are respectively distributed in one preset area of N preset areas. The service call table comprises an identifier of a micro service, a parameter name of the micro service, a parameter value of the micro service and an output address of each micro service, the input parameter table comprises contents for updating the parameter name of the micro service and the parameter value of the micro service in the service call table, and the report configuration table comprises user information for receiving the service data.
Referring to fig. 6, the service call table may be set at a 1. The first column in the service invocation table may be an identifier of a micro service, for example, operation-data-automation. The second column in the service invocation table may be the parameter name of the microservice, e.g., workbook. The third column in the service invocation table may be the parameter value for the microservice, e.g., excel read test-third party insurance holder report _ 20190331-template. slsx. The fourth column in the service invocation table may be the output address of the respective microservice, e.g., result-1. asset detail table. The fourth column of content in the service invocation table may be a "strong type result", where the content in the column of the "strong type result" is used to indicate whether to refresh the parameter name and the parameter value of the micro service according to the content in the column each time the business data is invoked based on the micro service. In this example, the service call table may include identifiers of a plurality of micro services, where each identifier of a micro service corresponds to a plurality of parameter names, each parameter name corresponds to a parameter value, each identifier of a micro service corresponds to an output address, that is, "result output" in a1, and each identifier of a micro service corresponds to a "strong type result". In this case, the microservice can be automatically called in batch through the working script as shown in fig. 6, and the one-time export of business data can be realized after the logic is merged. For example, the work manuscript shown in fig. 6 may be called out according to the name of the work manuscript in the timing task, at this time, each data of a1 may be sequentially traversed, and a corresponding micro service is connected through a domain name service protocol, then parameters are transmitted into the corresponding micro service by reading the parameters, and finally the result is output to a corresponding output address, that is, the sheet2 to the sheet7 of a4, so that the micro service is automatically called in batches, and after the logics are combined, the business data can be derived at one time, thereby improving the work efficiency.
Referring to fig. 6, the input parameter table may be set at a 2. The input parameter table comprises contents for updating parameter names of the micro-services and parameter values of the micro-services in the service call table. For example, the contents of the first column in the output parameter table may be used to update the service call table with a parameter name of report _ start _ date and a parameter value of 2019-03-02. Specifically, the parameter name of the service call table is report _ start _ date, the parameter value of 2019-03-02 is updated to the parameter name of the service call table is report _ start _ date, and the parameter value of 2019-03-01 is updated according to the content (i.e., the parameter name is report _ start _ date and the parameter value of 2019-03-01) in the first column of the input parameter table. In this embodiment, the input parameter table may set dynamic parameters of the micro-service, such as parameter names and parameter values of the micro-service. The input parameter table may store parameters that change in real time using a functional formula.
Referring to fig. 6, a report configuration table may be set at a 3. Wherein, the report configuration table comprises user information for receiving the service data. For example, user information for receiving business data may include, but is not limited to, a user mailbox, a user name, a user job title. For example, when the service data is called, the service data can be sent to the user according to the content in the report configuration table. In addition, the report configuration table may further include some operation logics, so that the method may further include updating a dynamic formula in the work manuscript according to the preset operation logics, or updating a manner of combining outputs of the respective microservices according to the preset operation logics. For example, how to calculate the dynamic formula may be determined according to the operating system. For example, but not limited to, how the outputs of multiple microservices are combined, and the like.
In an embodiment of the present invention, the number of the preset areas of the work draft may be increased or decreased according to business needs. That is, the data in each preset area can be increased or decreased according to the service requirement.
In an embodiment of the present invention, the parameter name of the micro service and the parameter value of the micro service in the service call table may be updated according to the content in the work draft for updating the parameter name of the micro service and the parameter value of the micro service in the service call table. For example, the contents of the input parameter table are: the parameter name is report _ start _ date and the parameter value is 2019-03-01. The parameter name report _ start _ date in the service call table has parameter value 2019-03-02. In this case, before calling the service data, part of the data in the working script needs to be updated, that is, according to the parameter name of report _ start _ date and the parameter value of 2019-03-01 in the input parameter table, the parameter name of the service call table is report _ start _ date and the parameter value of 2019-03-02 is updated to the parameter name of report _ start _ date and the parameter value of 2019-03-01.
Fig. 3 schematically shows a flowchart of a database business processing method according to another embodiment of the present invention.
As shown in fig. 3, before the step S230, the method may include steps S310 to S330.
In step S310, a dynamic formula in the working manuscript is read, and the content required for updating the parameter name of the micro service and the parameter value of the micro service in the service call table in the current round of calling the service data is determined according to the dynamic formula.
In step S320, KV pairs of parameter names and parameter values are generated based on the content required for updating the parameter names and parameter values of the micro services in the service call table in this round of calling the service data.
In step S330, the parameter name of the micro service and the parameter value of the micro service in the service call table are updated according to the KV pair.
The method can update the parameter name of the micro service and the parameter value of the micro service in the service call list according to the KV pairing, so that the accuracy of the service data called based on the working manuscript can be further ensured.
In one embodiment of the present invention, after reading the work script, the dynamic formulas appearing in the work script may be calculated to identify all the dynamic parameters needed for this round of invocation. For example, the content required for updating the parameter name of the micro service and the parameter value of the micro service in the service call table in the current round of calling the service data is determined according to a dynamic formula. In this embodiment, all the dynamic parameters required for the current round of call, i.e. the contents for updating the parameter names of the micro-services and the parameter values of the micro-services in the service call table, are usually confirmed from the input parameters according to a dynamic formula.
In one embodiment of the invention, the KV pairs of parameter names and parameter values are generated based on the content required for updating the parameter names and parameter values of the micro-services in the service invocation table for the current round of invoking the business data. For example, the content of the parameter name and the parameter value of the micro service required for updating the micro service in the service call table in the current round of calling the service data may be: the parameter name is report _ start _ date and the parameter value is 2019-03-01. A KV pair may be generated based on report start date and 2019-03-01. In the present embodiment, K in the KV pair represents key, i.e., report _ start _ date. V in the KV alignment represents value, i.e., 2019-03-01.
In one embodiment of the invention, the parameter name of the micro service and the parameter value of the micro service in the service call table are updated according to the KV pairing. For example, KV is paired to report _ start _ date-2019-03-01, that is, according to report _ start _ date-2019-03-01, the parameter name of the service call table is report _ start _ date, the parameter value of 2019-03-02 is updated to the parameter name of report _ start _ date, and the parameter value of 2019-03-01, so that the accuracy of the service data called based on the working script can be further ensured.
Fig. 4 schematically shows a flowchart of a database business processing method according to another embodiment of the present invention.
As shown in fig. 4, the step S240 may specifically include a step S410 and a step S420.
In step S410, a network address associated with the identifier of the micro service, the parameter name of the micro service, the parameter value of the micro service, and the output address of each micro service in the service call table is obtained through a domain name service protocol.
In step S420, service data related to the micro service is called from a database according to the network address.
The method can acquire the identifier of the micro service, the parameter name of the micro service, the parameter value of the micro service and the network address related to the output address of each micro service in the service call table through a domain name service protocol, and call the service data related to the micro service from the database according to the network address, so that the service data corresponding to the parameter for calling the service data can be accurately and quickly called from the database.
In one embodiment of the invention, the service call table is traversed to obtain the identifier of the micro service, and all the input parameters (for example, the parameter name and parameter value corresponding to the identifier of the micro service, etc.), then the network address of the micro service is determined through the domain name service protocol, and then the network request is sent to the network address, and finally the service data returned from the database is received.
Fig. 5 schematically shows a flowchart of a database business processing method according to another embodiment of the present invention.
As shown in fig. 5, the method further includes step S510 and step S520.
In step S510, the business data is added to the corresponding output address according to the output address of each micro-service in the work draft.
In step S520, the work draft added with the service data is sent to the user according to the user information used for receiving the service data.
The method can add the service data to the corresponding output address according to the output address of each micro service in the work manuscript, so that the service data called by a plurality of micro services can be stored separately, and then the work manuscript added with the service data is sent to the user directionally according to the user information for receiving the service data, thereby realizing that only the service personnel related to the service data can receive the service data.
Referring to fig. 6, the output address of each micro service may be the content of the column in the service call table where "result output" is located. The "result output" in the service call table corresponds to a sheet 2-sheet 7 in A4, a sheet2 corresponds to a result1 asset detail table, a sheet3 corresponds to a result2 accounting classification proportion statistical table, a sheet4 corresponds to a result3 income detail table, a sheet5 corresponds to a result4 security reserver, a sheet6 corresponds to a result financial balance table, and a sheet7 corresponds to a result estimation table. For example, the service data related to each microservice is added to the output address in a4, respectively.
Fig. 7 schematically shows a block diagram of a service processing device of a database according to an embodiment of the present invention.
As shown in fig. 7, the service processing apparatus 200 of the database includes a first obtaining module 201, a first calling module 202, a traversing module 203, and a second calling module 204.
Specifically, the first obtaining module 201 is configured to obtain a timing task, where the timing task includes a name of a work manuscript and preset time.
A first calling module 202, configured to call, according to the name of the working manuscript, the working manuscript corresponding to the name of the working manuscript, where the working manuscript includes a service call table.
And the traversing module 203 traverses the service call table at the preset time to acquire the identifier of the micro service, the parameter name of the micro service, the parameter value of the micro service and the output address of each micro service in the service call table.
The second calling module 204 is configured to call, through the identifier of the micro service, the parameter name of the micro service, the parameter value of the micro service, and the output address of each micro service in the service call table, the service data related to the micro service.
The service processing device 200 of the database can obtain a timing task, the timing task comprises a name and preset time of a work manuscript, the work manuscript corresponding to the name of the work manuscript is called according to the name of the work manuscript, the work manuscript comprises a service call table, the service call table is traversed at the preset time to obtain an identifier of a micro service, a parameter name of the micro service, a parameter value of the micro service and an output address of each micro service in the service call table, and service data related to the micro service is called through the identifier of the micro service, the parameter name of the micro service, the parameter value of the micro service and the output address of each micro service in the service call table, so that service personnel do not need to write a computer language manually when calling the service data, and the working efficiency is improved. Moreover, the labor cost is reduced to a certain extent, and the condition that the recalled business data is inaccurate due to errors of the manually written computer language can be avoided.
According to the embodiment of the present invention, the service processing apparatus 200 of the database may be used to implement the service processing method of the database described in the embodiment of fig. 2.
Fig. 8 schematically shows a block diagram of an apparatus for determining virtual machine drift according to another embodiment of the present invention.
As shown in fig. 8, the service processing apparatus 200 of the database further includes a determining module 205, a generating module 206, and a sub-module 207 of an updating module.
Specifically, the determining module 205 is configured to read a dynamic formula in the working manuscript, and determine, according to the dynamic formula, content that is needed for updating a parameter name of a micro service and a parameter value of the micro service in the service invocation table in this round of invoking the service data.
And the generating module 206 generates KV pairs of parameter names and parameter values based on the content required for updating the parameter names and parameter values of the micro services in the service call table in the current round of calling the service data.
And the first updating module 207 is configured to update the parameter name of the micro service and the parameter value of the micro service in the service call table according to the KV pairing.
The service processing device 200 of the database can update the parameter name of the micro-service and the parameter value of the micro-service in the service call table according to the KV pairing, so that the accuracy of the service data called based on the working manuscript can be further ensured.
According to the embodiment of the present invention, the service processing apparatus 200 of the database may be used to implement the service processing method of the database described in the embodiment of fig. 3.
Fig. 9 schematically shows a block diagram of a database service processing apparatus according to another embodiment of the present invention.
As shown in fig. 9, the second calling module 204 further includes a second obtaining module 204-1 and a sub-module 204-2 of the second calling module.
Specifically, the second obtaining module 204-1 is configured to obtain, through a domain name service protocol, a network address related to an identifier of a micro service, a parameter name of the micro service, a parameter value of the micro service, and an output address of each micro service in the service invocation table.
And the sub-module 204-2 of the second calling module is configured to call, according to the network address, service data related to the micro-service from a database.
The second invoking module 204 may obtain, through a domain name service protocol, the identifier of the micro service, the parameter name of the micro service, the parameter value of the micro service, and the network address related to the output address of each micro service in the service invocation table, and invoke, according to the network address, the service data related to the micro service from the database, so that the service data corresponding to the parameter for invoking the service data may be accurately and quickly invoked from the database.
According to an embodiment of the present invention, the second calling module 204 may be used to implement the service processing method of the database described in the embodiment of fig. 4.
Fig. 10 schematically shows a block diagram of a database service processing apparatus according to another embodiment of the present invention.
As shown in fig. 10, the service processing apparatus 200 of the database further includes an adding module 208 and a sending module 209.
Specifically, the adding module 208 is configured to add the service data to a corresponding output address according to the output address of each micro-service in the work draft.
A sending module 209, configured to send the work manuscript to which the service data is added to the user according to the user information used for receiving the service data.
The service processing apparatus 200 of the database may add the service data to the corresponding output address according to the output address of each micro-service in the work manuscript, so as to separately store the service data called by the plurality of micro-services, and then directionally send the work manuscript to which the service data is added to the user according to the user information for receiving the service data, thereby realizing that only the service personnel related to the service data can receive the service data.
According to the embodiment of the present invention, the service processing apparatus 200 of the database may be used to implement the service processing method of the database described in the embodiment of fig. 5.
Fig. 11 schematically shows a block diagram of a database service processing apparatus according to another embodiment of the present invention.
As shown in fig. 11, the service processing apparatus 200 of the database further includes a second updating module 210.
Specifically, the second updating module 210 is configured to update a dynamic formula in the work manuscript according to the preset operation logic, or update and combine an output manner of each micro service according to the preset operation logic.
Fig. 12 schematically shows a block diagram of a database service processing apparatus according to another embodiment of the present invention.
As shown in fig. 12, the service processing device 200 of the database further includes a third updating module 211.
Specifically, the third updating module 211 is configured to determine an operating frequency of the timed task according to a preset reference day, and dynamically update the preset time according to the operating frequency.
For details that are not disclosed in the embodiment of the apparatus of the present invention, please refer to the embodiment of the service processing method of the database described above for the embodiment of the present invention, because each module of the service processing apparatus 200 of the database according to the embodiment of the present invention can be used to implement the steps of the exemplary embodiment of the service processing method of the database described above in fig. 2 to 5.
It is understood that the first obtaining module 201, the first calling module 202, the traversing module 203, the second calling module 204, the second obtaining module 204-1, the sub-module 204-2 of the second calling module, the determining module 205, the generating module 206, the first updating module 207, the adding module 208, the sending module 209, the second updating module 210, and the third updating module 211 may be combined and implemented in one module, or any one of them may be split into multiple modules. Alternatively, at least part of the functionality of one or more of these modules may be combined with at least part of the functionality of the other modules and implemented in one module. According to an embodiment of the present invention, at least one of the first obtaining module 201, the first calling module 202, the traversing module 203, the second calling module 204, the second obtaining module 204-1, the sub-module 204-2 of the second calling module, the determining module 205, the generating module 206, the first updating module 207, the adding module 208, the sending module 209, the second updating module 210, and the third updating module 211 may be at least partially implemented as a hardware circuit, such as a Field Programmable Gate Array (FPGA), a Programmable Logic Array (PLA), a system on a chip, a system on a substrate, a system on a package, an Application Specific Integrated Circuit (ASIC), or may be implemented in hardware or firmware in any other reasonable manner of integrating or packaging a circuit, or in a suitable combination of three implementations of software, hardware, and firmware. Alternatively, at least one of the first obtaining module 201, the first calling module 202, the traversing module 203, the second calling module 204, the second obtaining module 204-1, the sub-module 204-2 of the second calling module, the determining module 205, the generating module 206, the first updating module 207, the adding module 208, the sending module 209, the second updating module 210, and the third updating module 211 may be at least partially implemented as a computer program module, which, when executed by a computer, may perform the functions of the respective modules.
Referring now to FIG. 13, shown is a block diagram of a computer system 300 suitable for use with the electronic device implementing an embodiment of the present invention. The computer system 300 of the electronic device shown in fig. 13 is only an example, and should not bring any limitation to the functions and the scope of use of the embodiments of the present invention.
As shown in fig. 13, the computer system 300 includes a Central Processing Unit (CPU)301 that can perform various appropriate actions and processes in accordance with a program stored in a Read Only Memory (ROM)302 or a program loaded from a storage section 308 into a Random Access Memory (RAM) 303. In the RAM 303, various programs and data necessary for system operation are also stored. The CPU301, ROM 302, and RAM 303 are connected to each other via a bus 304. An input/output (I/O) interface 305 is also connected to bus 304.
The following components are connected to the I/O interface 305: an input portion 306 including a keyboard, a mouse, and the like; an output section 307 including a display such as a Cathode Ray Tube (CRT), a Liquid Crystal Display (LCD), and the like, and a speaker; a storage section 308 including a hard disk and the like; and a communication section 309 including a network interface card such as a LAN card, a modem, or the like. The communication section 309 performs communication processing via a network such as the internet. A drive 310 is also connected to the I/O interface 305 as needed. A removable medium 311 such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, or the like is mounted on the drive 310 as necessary, so that a computer program read out therefrom is mounted into the storage section 308 as necessary.
In particular, according to an embodiment of the present invention, the processes described above with reference to the flowcharts may be implemented as computer software programs. For example, embodiments of the invention include a computer program product comprising a computer program embodied on a computer-readable medium, the computer program comprising program code for performing the method illustrated in the flow chart. In such an embodiment, the computer program may be downloaded and installed from a network through the communication section 309, and/or installed from the removable medium 311. The above-described functions defined in the system of the present application are executed when the computer program is executed by the Central Processing Unit (CPU) 301.
It should be noted that the computer readable medium shown in the present invention can be a computer readable signal medium or a computer readable storage medium or any combination of the two. A computer readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the foregoing. More specific examples of the computer readable storage medium may include, but are not limited to: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the present invention, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. In the present invention, however, a computer readable signal medium may include a propagated data signal with computer readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated data signal may take many forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device. Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to: wireless, wire, fiber optic cable, RF, etc., or any suitable combination of the foregoing.
The flowchart and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present invention. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams or flowchart illustration, and combinations of blocks in the block diagrams or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
The units described in the embodiments of the present invention may be implemented by software, or may be implemented by hardware, and the described units may also be disposed in a processor. Wherein the names of the elements do not in some way constitute a limitation on the elements themselves.
As another aspect, the present application also provides a computer-readable medium, which may be contained in the electronic device described in the above embodiments; or may exist separately without being assembled into the electronic device. The computer readable medium carries one or more programs, and when the one or more programs are executed by the electronic device, the electronic device is enabled to implement the database service processing method as described in the above embodiments.
For example, the electronic device may implement the following as shown in fig. 2: in step S210, a timing task is acquired, where the timing task includes a name of the work manuscript and a preset time. In step S220, a work manuscript corresponding to the name of the work manuscript is called according to the name of the work manuscript, where the work manuscript includes a service call table. In step S230, traversing the service call table at the preset time to obtain the identifier of the micro service, the parameter name of the micro service, the parameter value of the micro service, and the output address of each micro service in the service call table. In step S240, the service data related to the micro service is called through the identifier of the micro service, the parameter name of the micro service, the parameter value of the micro service, and the output address of each micro service in the service call table
It should be noted that although in the above detailed description several modules or units of the device for action execution are mentioned, such a division is not mandatory. Indeed, the features and functionality of two or more modules or units described above may be embodied in one module or unit, according to embodiments of the invention. Conversely, the features and functions of one module or unit described above may be further divided into embodiments by a plurality of modules or units.
Through the above description of the embodiments, those skilled in the art will readily understand that the exemplary embodiments described herein may be implemented by software, or by software in combination with necessary hardware. Therefore, the technical solution according to the embodiment of the present invention can be embodied in the form of a software product, which can be stored in a non-volatile storage medium (which can be a CD-ROM, a usb disk, a removable hard disk, etc.) or on a network, and includes several instructions to enable a computing device (which can be a personal computer, a server, a touch terminal, or a network device, etc.) to execute the method according to the embodiment of the present invention.
Other embodiments of the invention will be apparent to those skilled in the art from consideration of the specification and practice of the invention disclosed herein. This application is intended to cover any variations, uses, or adaptations of the invention following, in general, the principles of the invention and including such departures from the present disclosure as come within known or customary practice within the art to which the invention pertains. It is intended that the specification and examples be considered as exemplary only, with a true scope and spirit of the invention being indicated by the following claims.
It will be understood that the invention is not limited to the precise arrangements described above and shown in the drawings and that various modifications and changes may be made without departing from the scope thereof. The scope of the invention is limited only by the appended claims.

Claims (10)

1. A method for processing database services is characterized by comprising the following steps:
acquiring a timing task, wherein the timing task comprises the name and preset time of a work manuscript;
calling a working manuscript corresponding to the name of the working manuscript according to the name of the working manuscript, wherein the working manuscript comprises a service call table;
traversing the service call table at the preset time to acquire the identifier of the micro service, the parameter name of the micro service, the parameter value of the micro service and the output address of each micro service in the service call table;
calling business data related to the micro-service through the identification of the micro-service, the parameter name of the micro-service, the parameter value of the micro-service and the output address of each micro-service in the service calling table;
the working manuscript is provided with N preset areas, and the service call table is distributed in one of the N preset areas.
2. The method of claim 1, wherein the work script further comprises any one or more of: the system comprises an input parameter table and a report configuration table, wherein the input parameter table and the report configuration table are respectively distributed in one preset area of N preset areas, the input parameter table comprises contents for updating parameter names of micro services and parameter values of the micro services in the service call table, and the report configuration table comprises user information for receiving the service data.
3. The method of claim 2, wherein prior to traversing the service call table, the method further comprises:
reading a dynamic formula in the working manuscript, and determining the content which is required by the current round of calling the service data and is used for updating the parameter name of the micro service and the parameter value of the micro service in the service calling table according to the dynamic formula;
generating KV pairing of parameter names and parameter values based on the content of the parameter names and parameter values of the micro services required by the current round of calling the service data and used for updating the parameter names and the parameter values of the micro services in the service calling table;
and updating the parameter name of the micro service and the parameter value of the micro service in the service call table according to the KV pairing.
4. The method of claim 2, further comprising:
adding the business data to corresponding output addresses according to the output addresses of the micro services in the work manuscript;
and sending the work manuscript added with the service data to the user according to the user information for receiving the service data.
5. The method of claim 3, wherein the report configuration table further comprises a predetermined operation logic, the method further comprising:
and updating a dynamic formula in the working manuscript according to the preset operation logic, or updating and combining the output modes of the micro services according to the preset operation logic.
6. The method of claim 1, further comprising:
and determining the running frequency of the timed task according to a preset reference day, and dynamically updating the preset time according to the running frequency.
7. The method according to any one of claims 1 to 6, wherein the step of calling the service data related to the micro service through the identification of the micro service, the parameter name of the micro service, the parameter value of the micro service, and the output address of each micro service in the service call table comprises the following steps:
acquiring the identifier of the micro service, the parameter name of the micro service, the parameter value of the micro service and the network address related to the output address of each micro service in the service call table through a domain name service protocol;
and calling the service data related to the micro service from a database according to the network address.
8. A database transaction apparatus, comprising:
the system comprises a first acquisition module, a second acquisition module and a third acquisition module, wherein the first acquisition module is used for acquiring a timing task, and the timing task comprises the name and preset time of a work manuscript;
the first calling module is used for calling the working manuscript corresponding to the name of the working manuscript according to the name of the working manuscript, and the working manuscript comprises a service call table;
the traversal module traverses the service call table at the preset time to acquire the identification of the micro service, the parameter name of the micro service, the parameter value of the micro service and the output address of each micro service in the service call table;
the second calling module is used for calling the business data related to the micro-service through the identification of the micro-service, the parameter name of the micro-service, the parameter value of the micro-service and the output address of each micro-service in the service calling table;
the working manuscript is provided with N preset areas, and the service call table is distributed in one of the N preset areas.
9. An electronic device, comprising:
one or more processors; and
storage means for storing one or more programs which, when executed by the one or more processors, cause the one or more processors to carry out a method according to any one of claims 1 to 7.
10. A computer-readable medium, on which a computer program is stored, which program, when being executed by a processor, is adapted to carry out the method according to any one of claims 1 to 7.
CN202010473304.5A 2020-05-29 2020-05-29 Method, device, medium and electronic equipment for processing database business Active CN111651488B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202010473304.5A CN111651488B (en) 2020-05-29 2020-05-29 Method, device, medium and electronic equipment for processing database business

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202010473304.5A CN111651488B (en) 2020-05-29 2020-05-29 Method, device, medium and electronic equipment for processing database business

Publications (2)

Publication Number Publication Date
CN111651488A true CN111651488A (en) 2020-09-11
CN111651488B CN111651488B (en) 2023-09-12

Family

ID=72352708

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202010473304.5A Active CN111651488B (en) 2020-05-29 2020-05-29 Method, device, medium and electronic equipment for processing database business

Country Status (1)

Country Link
CN (1) CN111651488B (en)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN112559158A (en) * 2020-12-29 2021-03-26 中国人民银行清算总中心 Micro-service timing task scheduling method and device
CN112667396A (en) * 2020-12-24 2021-04-16 北京奇艺世纪科技有限公司 Access request processing method, device and system

Citations (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109669948A (en) * 2018-12-24 2019-04-23 安徽经邦软件技术有限公司 A kind of quick financial statement combination system and its method based on data warehouse
CN109902105A (en) * 2019-02-28 2019-06-18 携程旅游网络技术(上海)有限公司 For the data query system of micro services framework, method, equipment and storage medium
CN109922158A (en) * 2019-03-22 2019-06-21 泰康保险集团股份有限公司 Data processing method, device, medium and electronic equipment based on micro services
US10409811B1 (en) * 2017-01-27 2019-09-10 Intuit, Inc. Decomposition of queries
US20190286636A1 (en) * 2018-03-13 2019-09-19 deFacto Global, Inc. Systems, methods, and devices for generation of analytical data reports using dynamically generated queries of a structured tabular cube
US20200004847A1 (en) * 2018-06-28 2020-01-02 Bank Of America Corporation Dynamic network database integration system
CN111125170A (en) * 2019-12-22 2020-05-08 浪潮电子信息产业股份有限公司 Cross-service data acquisition method and device of micro-service and micro-service equipment
CN111143352A (en) * 2019-11-28 2020-05-12 泰康保险集团股份有限公司 Data processing method and device, electronic equipment and storage medium

Patent Citations (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US10409811B1 (en) * 2017-01-27 2019-09-10 Intuit, Inc. Decomposition of queries
US20190286636A1 (en) * 2018-03-13 2019-09-19 deFacto Global, Inc. Systems, methods, and devices for generation of analytical data reports using dynamically generated queries of a structured tabular cube
US20200004847A1 (en) * 2018-06-28 2020-01-02 Bank Of America Corporation Dynamic network database integration system
CN109669948A (en) * 2018-12-24 2019-04-23 安徽经邦软件技术有限公司 A kind of quick financial statement combination system and its method based on data warehouse
CN109902105A (en) * 2019-02-28 2019-06-18 携程旅游网络技术(上海)有限公司 For the data query system of micro services framework, method, equipment and storage medium
CN109922158A (en) * 2019-03-22 2019-06-21 泰康保险集团股份有限公司 Data processing method, device, medium and electronic equipment based on micro services
CN111143352A (en) * 2019-11-28 2020-05-12 泰康保险集团股份有限公司 Data processing method and device, electronic equipment and storage medium
CN111125170A (en) * 2019-12-22 2020-05-08 浪潮电子信息产业股份有限公司 Cross-service data acquisition method and device of micro-service and micro-service equipment

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN112667396A (en) * 2020-12-24 2021-04-16 北京奇艺世纪科技有限公司 Access request processing method, device and system
CN112667396B (en) * 2020-12-24 2023-09-01 北京奇艺世纪科技有限公司 Access request processing method, device and system
CN112559158A (en) * 2020-12-29 2021-03-26 中国人民银行清算总中心 Micro-service timing task scheduling method and device

Also Published As

Publication number Publication date
CN111651488B (en) 2023-09-12

Similar Documents

Publication Publication Date Title
CN110706093A (en) Accounting processing method and device
CN111651488A (en) Database service processing method, device, medium and electronic equipment
CN111046640B (en) Dynamic generation method and device for certificate
CN112000902A (en) Method, electronic device, and storage medium for mapping an area
CN111209281B (en) Annuity data processing method, annuity data processing device, medium and electronic equipment
CN111401023B (en) Report generation method, report generation device, server and storage medium
CN108196921B (en) Document development method and device, computer equipment and storage medium
CN111090976A (en) Method and device for generating inspection document based on dynamic data
CN115809228A (en) Data comparison method and device, storage medium and electronic equipment
CN113989058A (en) Service generation method and device
CN113656041A (en) Data processing method, device, equipment and storage medium
CN114169733A (en) Resource allocation method and device
CN113448578A (en) Page data processing method, processing system, electronic device and readable storage medium
CN110955599A (en) Object creation method and device, electronic equipment and computer-readable storage medium
CN112508712A (en) Client data processing method, device, medium and electronic equipment
CN115208960B (en) Protocol switching method and related equipment
CN110728584B (en) Information processing method and device, readable storage medium and electronic equipment
CN115543969B (en) Data migration method, device, equipment and medium
CN115439217A (en) Method for processing limit data and related device
CN113111051A (en) Data migration method and device
CN114201214A (en) File generation method, file generation device, electronic equipment, medium and program product
US20220360555A1 (en) Device estimation device, device estimation method, and device estimation program
CN117349352A (en) Display method, device, equipment and storage medium
CN116795951A (en) Service processing method, device, electronic equipment and storage medium
CN117493206A (en) Test data generation method, device, equipment and storage medium

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant