CN114519582A - Service preheating method, preheating device and service system - Google Patents

Service preheating method, preheating device and service system Download PDF

Info

Publication number
CN114519582A
CN114519582A CN202210159246.8A CN202210159246A CN114519582A CN 114519582 A CN114519582 A CN 114519582A CN 202210159246 A CN202210159246 A CN 202210159246A CN 114519582 A CN114519582 A CN 114519582A
Authority
CN
China
Prior art keywords
service
class
sql
preheating
common
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.)
Pending
Application number
CN202210159246.8A
Other languages
Chinese (zh)
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.)
Postal Savings Bank of China Ltd
Original Assignee
Postal Savings Bank of China 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 Postal Savings Bank of China Ltd filed Critical Postal Savings Bank of China Ltd
Priority to CN202210159246.8A priority Critical patent/CN114519582A/en
Publication of CN114519582A publication Critical patent/CN114519582A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q20/00Payment architectures, schemes or protocols
    • G06Q20/38Payment protocols; Details thereof
    • G06Q20/382Payment protocols; Details thereof insuring higher security of transaction
    • 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
    • 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/28Databases characterised by their database models, e.g. relational or object models
    • G06F16/284Relational databases
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F8/00Arrangements for software engineering
    • G06F8/30Creation or generation of source code
    • G06F8/31Programming languages or programming paradigms
    • G06F8/315Object-oriented languages
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F8/00Arrangements for software engineering
    • G06F8/40Transformation of program code
    • G06F8/41Compilation
    • G06F8/42Syntactic analysis
    • G06F8/427Parsing

Abstract

The application provides a preheating method, a preheating device and a service system of a service, wherein the method comprises the following steps: the method comprises the steps that a preheater obtains a plurality of SQL sentences to obtain an SQL sentence set; the preheater analyzes the SQL statement set to obtain a plurality of analysis results, and the analysis results correspond to the SQL statements one by one; the preheater loads a common tool class and a common service class so that the server calls at least one of the analysis result of the preheater, the common tool class and the common service class to execute a service corresponding to the service request under the condition that the server receives the service request, wherein the common tool class is a tool class with service execution service history calling times larger than preset times, and the common service class is a service class with service execution service history calling times larger than preset times. The method solves the problem that redundant data is generated by a service preheating method in the prior art, avoids the hidden trouble of misoperation caused by the fact that test data and production data cannot be effectively isolated, and improves the safety of the production data.

Description

Service preheating method, preheating device and service system
Technical Field
The present application relates to the field of online transaction service initiation technologies, and in particular, to a service preheating method, a preheating device, a computer-readable storage medium, a processor, and a service system.
Background
The problem that after all services of online transaction are started, the time consumption of the first transaction is too long, even the transaction is overtime, so that the user experience is influenced, and multiple factors exist due to the fact that the time consumption of the first transaction is too long. Firstly, when a database partitioning middleware of a distributed data access layer is introduced into an application system, an SQL statement is required to be resolved based on a syntax tree and then routed to a database table under a target partition to operate data, so that the SQL access time consumption is inevitably increased, and even if the caching multiplexing of an SQL resolution result is increased in the industry, the problem of SQL resolution time consumption cannot be fundamentally solved for the first transaction; secondly, java tool codes or service codes in the project comprise static code statement blocks, or SPI (serial peripheral interface) implementation class loading and the like, which are loaded on demand, namely, the loading is triggered when the corresponding service class is called for the first transaction, so that the tool codes or the service classes used for the first transaction can use the service logic method after the static code blocks or the SPI are loaded, and the time consumed for loading is increased.
At present, a common mode in the industry is to introduce a shadow library into a service production environment, call a preheating transaction after the shadow library is started, store data generated by the preheating transaction into the shadow library, and perform real transaction after the preheating transaction is completed.
When the existing shadow library resource is introduced and a preheating transaction mode is selected, a user side is required to adapt, reform and distinguish SQL types, and the SQL request is determined to be a real production library or a shadow library.
The above information disclosed in this background section is only for enhancement of understanding of the background of the technology described herein and, therefore, certain information may be included in the background that does not form the prior art that is already known in this country to a person of ordinary skill in the art.
Disclosure of Invention
The application mainly aims to provide a service preheating method, a preheating device, a computer readable storage medium, a processor and a service system, so as to solve the problem that redundant data is generated by the service preheating method in the prior art.
According to an aspect of an embodiment of the present invention, there is provided a method for pre-heating a service, including: the method comprises the steps that a preheater obtains a plurality of SQL sentences to obtain an SQL sentence set; the preheater analyzes the SQL statement set to obtain a plurality of analysis results, and the analysis results correspond to the SQL statements one by one; the preheater loads a common tool class and a common service class so that a server calls at least one of the analysis result of the preheater, the common tool class and the common service class to execute a service corresponding to the service request under the condition that the server receives a service request, wherein the common tool class is a tool class with service execution service history calling times larger than preset times, and the common service class is a service class with service execution service history calling times larger than the preset times.
Optionally, the pre-heater includes an ORM layer and a multiplexing resource pool, where the ORM layer is configured to map data operations into SQL statements, the multiplexing resource pool is configured to store dynamic SQL statements used in the service history execution service record, the SQL statement set includes a static SQL statement set and a dynamic SQL statement set, and the pre-heater acquires multiple SQL statements to obtain an SQL statement set, and the method includes: obtaining a static SQL statement corresponding to the service through the ORM layer to obtain a static SQL statement set; and reading the dynamic SQL sentences of the multiplexing resource pool to obtain the dynamic SQL sentence set.
Optionally, the pre-heater loads a generic tool class and a generic service class, including: identifying the tool class and the service class of which the historical calling times are more than the preset times to obtain the common tool class and the common service class, wherein the common tool class and the common service class have preheating annotation identification; calling a java annotation scanning function to obtain the common tool class and the common service class; and loading the common tool class and the common service class.
Optionally, before the pre-heater parses the SQL statement set, the method includes: reading a preset preheating strategy, wherein the preheating strategy is used for controlling the execution mode and the execution sequence of the analysis operation and the loading operation; analyzing the SQL statement set according to the preheating strategy to obtain a plurality of analysis results; and loading the common tool class and the common service class according to the preheating strategy.
Optionally, the executing manner includes a synchronous executing manner and an asynchronous executing manner, and the parsing the SQL statement set according to the preheating policy to obtain a plurality of parsing results includes: sending first prompt information under the condition that the execution mode is an asynchronous execution mode and analysis is started, wherein the first prompt information is that the analysis of the SQL statement set is started; and sending second prompt information under the condition that the execution mode is a synchronous execution mode and the analysis is finished, wherein the second prompt information is the analysis of the SQL statement set.
Optionally, analyzing the SQL statement set according to the preheating policy to obtain a plurality of analysis results, further comprising: determining the weight of each SQL statement in the SQL statement set; inputting each SQL statement into a priority queue from high to low according to weight; and analyzing the SQL sentences in sequence according to the output sequence of the priority queue to obtain a plurality of analysis results.
Optionally, the preheater comprises an SPI interface, and before reading the predetermined preheating strategy, the method further comprises: and calling the SPI interface to receive a user-defined preheating strategy of a user.
According to another aspect of the embodiments of the present invention, there is also provided a service preheating apparatus, including: the acquisition unit is used for acquiring a plurality of SQL sentences by the preheater to obtain an SQL sentence set; the analysis unit is used for analyzing the SQL statement set by the preheater to obtain a plurality of analysis results, and the analysis results correspond to the SQL statements one by one; a loading unit, configured to load a common tool class and a common service class by the preheater, so that a server invokes at least one of the analysis result of the preheater, the common tool class, and the common service class to execute a service corresponding to a service request when receiving the service request, where the common tool class is a tool class in which the number of times of history calling of service execution service is greater than a predetermined number of times, and the common service class is a service class in which the number of times of history calling of service execution service is greater than the predetermined number of times.
According to still another aspect of the embodiments of the present invention, there is also provided a computer-readable storage medium including a stored program, wherein the program executes any one of the methods.
According to another aspect of the embodiments of the present invention, there is also provided a processor, configured to run a program, where the program executes to perform any one of the methods.
There is also provided, in accordance with an aspect of an embodiment of the present invention, a service system, including a server and a preheater, the preheater including one or more processors, memory, and one or more programs, wherein the one or more programs are stored in the memory and configured to be executed by the one or more processors, the one or more programs including instructions for performing any of the methods described herein.
In the embodiment of the invention, in the preheating method of the service, firstly, a preheater acquires a plurality of SQL statements to obtain an SQL statement set; then, the preheater analyzes the SQL statement set to obtain a plurality of analysis results, and the analysis results correspond to the SQL statements one by one; finally, the preheater loads a generic tool class and a generic service class, so that the server invokes at least one of the analysis result of the preheater, the generic tool class and the generic service class to execute a service corresponding to the service request when receiving the service request, wherein the generic tool class is a tool class in which the service execution service history invoking frequency is greater than a predetermined frequency, and the generic service class is a service class in which the service execution service history invoking frequency is greater than the predetermined frequency. The method analyzes the SQL statement set to obtain a plurality of analysis results, directly loads the common tools and the common services, saves the time for analyzing the SQL statements and loading the common tools and the common services when subsequently receiving a service request and executing a transaction service, and executes the transaction service for testing without preheating, so that redundant data generated by testing cannot be generated, the problem that redundant data is generated by a service preheating method in the prior art is solved, the hidden danger of misoperation caused by the fact that test data and production data cannot be effectively isolated is avoided, and the safety of the production data is improved.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this application, are included to provide a further understanding of the application, and the description of the exemplary embodiments and illustrations of the application are intended to explain the application and are not intended to limit the application. In the drawings:
FIG. 1 shows a flow diagram of a method of pre-heating a service according to an embodiment of the application;
FIG. 2 illustrates a flow chart of a method of pre-heating a service according to another particular embodiment of the present application;
FIG. 3 shows a schematic diagram of a pre-heating apparatus for a service according to a particular embodiment of the present application;
FIG. 4 shows a schematic diagram of a multiplexed pre-heated resource pool collection running dynamic SQL set according to an embodiment of the present application;
fig. 5 shows a schematic view of a pre-heating device of a service according to another embodiment of the present application.
Detailed Description
It should be noted that the following detailed description is exemplary and is intended to provide further explanation of the disclosure. Unless defined otherwise, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this application belongs.
It is noted that the terminology used herein is for the purpose of describing particular embodiments only and is not intended to be limiting of example embodiments according to the present application. As used herein, the singular forms "a", "an" and "the" are intended to include the plural forms as well, and it should be understood that when the terms "comprises" and/or "comprising" are used in this specification, they specify the presence of stated features, steps, operations, devices, components, and/or combinations thereof, unless the context clearly indicates otherwise.
It will be understood that when an element such as a layer, film, region, or substrate is referred to as being "on" another element, it can be directly on the other element or intervening elements may also be present. Also, in the specification and claims, when an element is described as being "connected" to another element, the element may be "directly connected" to the other element or "connected" to the other element through a third element.
For convenience of description, some terms or expressions referred to in the embodiments of the present application are explained below:
SPI: idea of Service Provider interface.spi mechanism: in object-oriented design, the modules are generally recommended to be programmed based on interfaces, implementation classes are not hard-coded, and in order to realize that the modules cannot be dynamically indicated in a program during module assembly, a service discovery mechanism is needed, and the SPI provides the mechanism: the mechanism for service implementation is found for a certain interface.
ORM: object Relational Mapping is a programming technique for implementing conversion between data of different types of systems in an Object-oriented programming language, and for data operations, classes, objects, corresponding methods and the like are written and called based on an Object-oriented idea, and an ORM converts/maps the data into native SQL to be executed by a database.
Static statement block: when the class is loaded, the class is executed once when the class is initialized, and the execution is destroyed after the completion, and only the class variable, namely the data member modified by static, can be initialized.
Distributed data access layer: a Distributed (Distributed) Data Access Layer (DAL), which is abbreviated as DAL, is an architecture system constructed by using the technical advantages of databases, Proxy, Memcached, clusters, and the like. The DAL layer has the idea that after data is fragmented and split horizontally or vertically, DAL should be able to route queries and merge results, rather than letting an application take charge of the operations.
Logical data sources: usually, data forms data sources of a plurality of physical libraries after being divided into libraries, and only one encapsulated logical data source (or proxy data source) is provided for an external user, so that the user is not sensitive, and when the data is really accessed, a specific physical data source is found by the logical data source according to a corresponding strategy for execution.
As mentioned in the background, the service warm-up method in the prior art generates redundant data, and in order to solve the above problems, in an exemplary embodiment of the present application, a service warm-up method, a warm-up apparatus, a computer-readable storage medium, a processor, and a service system are provided.
According to an embodiment of the present application, a method of pre-heating a service is provided.
Fig. 1 is a flowchart of a method of warming up a service according to an embodiment of the present application. As shown in fig. 1, the method comprises the steps of:
step S101, a preheater acquires a plurality of SQL sentences to obtain an SQL sentence set;
step S102, the preheater analyzes the SQL statement set to obtain a plurality of analysis results, and the analysis results correspond to the SQL statements one by one;
step S103, the preheater loads a common tool class and a common service class, wherein the common tool class is a tool class of which the service execution service history calling times are greater than the preset times, and the common service class is a service class of which the service execution service history calling times are greater than the preset times;
step S104, receiving a service request, and calling at least one of the analysis result, the generic tool class and the generic service class to execute a service corresponding to the service request.
In the preheating method of the service, firstly, a preheater acquires a plurality of SQL sentences to obtain an SQL sentence set; then, the preheater analyzes the SQL statement set to obtain a plurality of analysis results, and the analysis results correspond to the SQL statements one by one; finally, the preheater loads a generic tool class and a generic service class, so that the server invokes at least one of the analysis result of the preheater, the generic tool class and the generic service class to execute a service corresponding to the service request when receiving the service request, wherein the generic tool class is a tool class in which the service execution service history invoking frequency is greater than a predetermined frequency, and the generic service class is a service class in which the service execution service history invoking frequency is greater than the predetermined frequency. The method analyzes the SQL statement set to obtain a plurality of analysis results, directly loads the common tools and the common services, saves the time for analyzing the SQL statements and loading the common tools and the common services when subsequently receiving a service request and executing a transaction service, and executes the transaction service for testing without preheating, so that redundant data generated by testing cannot be generated, the problem that redundant data is generated by a service preheating method in the prior art is solved, the hidden danger of misoperation caused by the fact that test data and production data cannot be effectively isolated is avoided, and the safety of the production data is improved.
It should be noted that the steps illustrated in the flowcharts of the figures may be performed in a computer system such as a set of computer-executable instructions and that, although a logical order is illustrated in the flowcharts, in some cases, the steps illustrated or described may be performed in an order different than presented herein.
As shown in fig. 2, the preheater assembly is implemented by a springboot automatic assembly technology, and the overall preheater mainly performs four parts of operations: the method comprises the following functions of automatic assembly of the preheater, configuration reading of a preheating strategy, acquisition preparation of a preheating resource pool and preheating of the preheating resource pool.
Regarding the automatic assembly function of the preheater, the preheater provides a technology based on springboot automatic assembly, the preheater is introduced in a component dependence mode, the preheater can be plugged and used after opening a box, the preheater can implement preheating of logic table metadata and SQL analysis on the distributed data access layer middleware by acquiring a static SQL set through an ORM mapping layer, and the preheater strictly ensures the sequence of each component automatic assembly dependence through an annotation technology of @ DependsOn. As shown in fig. 3, a distributed logical data source is constructed by the middleware of the data access layer, then the ORM component layer constructs sessionFactory according to the logical data source to complete assembly of DAO, then the pre-heater component starts assembly, then the internal logic of the ORM component is executed, SQL resources are acquired through the ORM layer, and pre-heating is implemented for the data access layer. And in order to ensure the robustness of the system, even if the preheater is abnormal, the service still continues to assemble other components, and the starting of the service is not blocked.
In an embodiment of the present application, the preheater includes an ORM layer and a multiplexing resource pool, the ORM layer is configured to map data operations into SQL statements, the multiplexing resource pool is configured to store dynamic SQL statements used in the service history execution service record, the SQL statement set includes a static SQL statement set and a dynamic SQL statement set, and the preheater obtains a plurality of SQL statements to obtain an SQL statement set, including: obtaining static SQL statements corresponding to the service through an ORM layer to obtain a static SQL statement set; and reading the dynamic SQL sentences of the multiplexing resource pool to obtain the dynamic SQL sentence set. In this embodiment, when the acquisition preparation operation of the preheating resource pool is performed, as shown in fig. 3, the static SQL statement corresponding to the ORM layer acquisition service is added to the current preheating pool. Because the ORM layer maintains the mapping relation between the database table field and the attribute field of the upper-layer object, and defines the public interface for operating the database access, the static SQL statement corresponding to the service can be acquired, and taking the ORM frame of mybatis as an example, the static SQL statement set is finally acquired through the BoundSql technology of MappedStatement. And reading a static SQL statement set from the multiplexing resource pool and adding the static SQL statement set to the current preheating pool. The multiplexing resource pool mainly comprises dynamic SQL statements used in service history execution business records. Whether the multiplexing resource pool is used can be started or closed through configuration, the main principle is that dynamic SQL sentences used in service history execution business records forming history tracks when the previous environment runs are collected into the multiplexing resource pool, and then the current environment directly obtains a dynamic SQL sentence set from the multiplexing resource pool of the dynamic SQL sentences used in the service history execution business records.
It should be noted that the preheating method of the service is implemented based on an SQL post-processing mechanism of distributed data access layer middleware, and the multiplexing resource pool provides post-processing implementation to collect a dynamic SQL statement set. As shown in fig. 4, the specific multiplexing resource pool classifies and collects the parsed dynamic SQL statement set and the parsing result (including the table name index name) according to the service name and the table name. And the import and export functions of the multiplexing resource pool are provided.
In an embodiment of the application, the loading, by the preheater, the generic tool class and the generic service class include: identifying the tool class and the service class with the historical calling times larger than the preset times to obtain the common tool class and the common service class, wherein the common tool class and the common service class have preheating annotation identification; calling a java annotation scanning function to obtain the common tool class and the common service class; and loading the common tool class and the common service class. In this embodiment, as shown in fig. 3, a common tool class and a common service class that contain a static code block or an SPI interface implementation class and are loaded in a delayed manner are scanned, and the common tool class and the common service class that are identified with a preheating annotation in a specified packet path are scanned and added to a current preheating pool based on a java annotation scanning manner.
In an embodiment of the application, before the preheater parses the SQL statement set, the method includes: reading a preset preheating strategy, wherein the preheating strategy is used for controlling the execution mode and the execution sequence of the analysis operation and the loading operation; analyzing the SQL statement set according to the preheating strategy to obtain a plurality of analysis results; and loading the generic tool class and the generic service class according to the preheating strategy. In this embodiment, as shown in fig. 2, before the acquisition of the current preheating resource pool, a preheating policy configuration reading operation is performed. The main technical implementation of the configuration reading of the preheating strategy is based on configuration centralized management and control strategy configuration, all scattered service nodes uniformly access the configuration center to pull corresponding preheating strategies, and if the default provided preheating strategy still does not meet the user, the preheater also provides an individualized preheating strategy which can be customized by the user based on the technical scheme of loading the SPI interface. The preheating strategy and the corresponding technical implementation comprise: the method comprises the steps of grouping a synchronous preheating mode or an asynchronous preheating mode, preheating a resource pool, and realizing the maximum utilization rate of software and hardware resources based on a multithreading high-concurrency java thread pool by using a technology corresponding to a preheating strategy of preheating by taking a group as a unit and importing and exporting a multiplexing preheating resource pool; the technology corresponding to the preheating strategy based on weight preheating for preheating the resource factors is realized by realizing weight preheating based on java priority queue PRIORITYQUEUE; the extensible customized preheating strategy is realized by expanding customization based on an SPI (serial peripheral interface).
In an embodiment of the application, the execution manner includes a synchronous execution manner and an asynchronous execution manner, and the parsing the SQL statement set according to the preheating policy obtains a plurality of parsing results, including: when the execution mode is an asynchronous execution mode and analysis is started, sending first prompt information, wherein the first prompt information indicates that the analysis of the SQL statement set is started; and sending second prompt information when the execution mode is a synchronous execution mode and the analysis is finished, wherein the second prompt information is that the analysis of the SQL statement set is finished. In this embodiment, as shown in fig. 2, after the acquisition of the current preheating resource pool is completed, a preheating resource implementation operation is performed. The preheating resource implementation can asynchronously preheat the metadata of a table in the middleware of the distributed data access layer respectively, and the SQL set in the current preheating resource pool is used for analyzing and preheating the distributed data access layer to form an analysis result cache for directly multiplexing the SQL set analysis result when the first transaction runs.
In an embodiment of the application, parsing the SQL statement set according to the preheating policy to obtain a plurality of parsing results further includes: determining the weight of each SQL statement in the SQL statement set; inputting each SQL statement into a priority queue from high to low according to weight; and analyzing the SQL sentences in sequence according to the output sequence of the priority queue to obtain a plurality of analysis results. In this embodiment, as shown in fig. 2, after the acquisition of the current preheating resource pool is completed, a preheating resource implementation operation is performed. The method is characterized in that weight preheating is realized based on a java priority queue, technologies such as reflection and the like are realized based on multithreading, reflection and the like respectively load an entry to metadata of a data access layer, an SQL analysis entry and the like, reflection objects are called, and refined preheating implementation is triggered, so that time consumption of the first transaction is reduced.
In an embodiment of the present application, the preheater includes an SPI interface, and before reading the predetermined preheating strategy, the method further includes: and calling the SPI interface to receive a user-defined preheating strategy of a user. In this embodiment, the technology corresponding to the extensible customized preheating policy is implemented by extending customization based on the SPI interface. Therefore, the preheater also provides a customized personalized preheating strategy based on the technical scheme of the loading SPI interface.
It should be noted that the preheater has the advantages of light weight, refinement, flexibility and reusability, and is mainly embodied in the following aspects:
and (3) lightening: the shadow library is not required to be introduced into each service, database connection with the shadow library is not required to be established, resources are saved, meanwhile, redundant preheating data are not generated, the safety of production data is guaranteed, and the risk of misoperation is reduced.
Refining: aiming at the main time-consuming core element, point-to-point refinement processing is carried out, namely, the time consumption for introducing the SQL of the distributed data access layer is too long, the targeted preheating and the time consumption for delaying loading of tools or services used as required by the first transaction are optimized, and various preheating strategies such as synchronous or asynchronous preheating modes or preheating according to weight are provided for selection.
Flexibility: if each service uses the preheater, the preheater directly depends on the components, so that the service can be plugged and pulled out, and the user of the service does not need to adapt and reform.
The reusability is as follows: the pre-heater is provided with a multiplexing pre-heating resource pool formed by collecting dynamic SQL and the like in operation according to the name of the deployed service, can selectively store local imported and exported, and can also push a remote end, so that the pre-heating pool can be multiplexed in different environments of the same type of service nodes.
The embodiment of the present application further provides a preheating device for a service, and it should be noted that the preheating device for a service according to the embodiment of the present application may be used to execute the preheating method for a service provided in the embodiment of the present application. The following describes a preheating device for a service provided in an embodiment of the present application.
FIG. 5 is a schematic diagram of a pre-heat apparatus for a service according to an embodiment of the application. As shown in fig. 5, the apparatus includes:
an obtaining unit 10, configured to obtain, by a preheater, a plurality of SQL statements to obtain an SQL statement set;
an analysis unit 20, configured to analyze the SQL statement set by the preheater to obtain a plurality of analysis results, where the analysis results correspond to the SQL statements one to one;
a loading unit 30, configured to load, by the pre-heater, a generic tool class and a generic service class, so that the server, when receiving a service request, invokes at least one of the analysis result of the pre-heater, the generic tool class, and the generic service class to execute a service corresponding to the service request, where the generic tool class is a tool class in which the number of times of invoking the service execution service history is greater than a predetermined number of times, and the generic service class is a service class in which the number of times of invoking the service execution service history is greater than the predetermined number of times.
In the preheating device of the service, an acquisition unit acquires a plurality of SQL sentences to obtain an SQL sentence set; the analysis unit analyzes the SQL statement set to obtain a plurality of analysis results, and the analysis results correspond to the SQL statements one by one; the loading unit loads a generic tool class and a generic service class, so that the server invokes at least one of the analysis result of the preheater, the generic tool class and the generic service class to execute a service corresponding to the service request when receiving the service request, wherein the generic tool class is a tool class in which the service execution service history invoking frequency is greater than a predetermined frequency, and the generic service class is a service class in which the service execution service history invoking frequency is greater than the predetermined frequency. The device analyzes the SQL statement set to obtain a plurality of analysis results, directly loads common tools and common services, saves time for analyzing the SQL statements and loading the common tools and the common services when subsequently receiving a service request and executing the transaction service, and executes the transaction service for testing without preheating, so that redundant data generated by testing cannot be generated, the problem that redundant data is generated by a service preheating method in the prior art is solved, misoperation hidden danger caused by the fact that test data and production data cannot be effectively isolated is avoided, and the safety of the production data is improved.
It should be noted that, as shown in fig. 2, the preheater assembly is implemented by a springboot automatic assembly technology, and the overall preheater mainly performs four parts of operations: the method comprises the following functions of automatic assembly of the preheater, configuration reading of a preheating strategy, acquisition preparation of a preheating resource pool and preheating of the preheating resource pool.
Regarding the automatic assembly function of the preheater, the preheater provides a technology based on springboot automatic assembly, the preheater is introduced in a component dependence mode, the preheater can be plugged and used after opening a box, the preheater can implement preheating of logic table metadata and SQL analysis on the distributed data access layer middleware by acquiring a static SQL set through an ORM mapping layer, and the preheater strictly ensures the sequence of each component automatic assembly dependence through an annotation technology of @ DependsOn. As shown in fig. 3, a distributed logic data source is constructed by the middleware of the data access layer, then the ORM component layer constructs sessionfactor according to the logic data source to complete assembly of DAO, then the preheater component starts assembly, then executes internal logic thereof, acquires SQL resources through the ORM layer, and performs preheating for the data access layer. And in order to ensure the robustness of the system, even if the preheater is abnormal, the service still continuously assembles other components, and the starting of the service is not blocked.
In an embodiment of the present application, the pre-heater includes an ORM layer and a multiplexing resource pool, the ORM layer is configured to map data operations into SQL statements, the multiplexing resource pool is configured to store dynamic SQL statements used in the service history execution business record, and the SQL statement set includes a static SQL statement set and a dynamic SQL statement set. The acquisition unit comprises a static acquisition module and a dynamic acquisition module, and the static acquisition module is used for acquiring static SQL statements corresponding to the service through the ORM layer to obtain the static SQL statement set; and the dynamic acquisition module is used for reading the dynamic SQL sentences of the multiplexing resource pool to obtain the dynamic SQL sentence set. In this embodiment, when the acquisition preparation operation of the preheating resource pool is performed, as shown in fig. 3, a static SQL statement corresponding to the ORM layer acquisition service is added to the current preheating pool. Because the ORM layer maintains the mapping relation between the database table field and the attribute field of the upper-layer object, and defines the public interface for operating the database access, the static SQL statement corresponding to the service can be acquired, and taking the ORM frame of mybatis as an example, the static SQL statement set is finally acquired through the BoundSql technology of MappedStatement. And reading a static SQL statement set from the multiplexing resource pool and adding the static SQL statement set to the current preheating pool. The multiplexing resource pool mainly comprises dynamic SQL statements used in service history execution business records. Whether the multiplexing resource pool is used can be started or closed through configuration, the main principle is that dynamic SQL sentences used in service history execution business records forming history tracks when the previous environment runs are collected into the multiplexing resource pool, and then the current environment directly obtains a dynamic SQL sentence set from the multiplexing resource pool of the dynamic SQL sentences used in the service history execution business records.
It should be noted that the preheating method of the service is implemented based on an SQL post-processing mechanism of distributed data access layer middleware, and the multiplexing resource pool provides post-processing implementation to collect a dynamic SQL statement set. As shown in fig. 4, the specific multiplexing resource pool classifies and collects the parsed dynamic SQL statement set and the parsing result (including the table name index name) according to the service name and the table name. And provides import and export functions for the multiplexed resource pool.
In an embodiment of the application, the loading unit includes an identification module, a calling module, and a loading module, where the identification module is configured to identify the tool class and the service class whose historical calling times are greater than the predetermined times, to obtain the common tool class and the common service class, where the common tool class and the common service class have a preheated annotation identifier; the calling module is used for calling a java annotation scanning function to obtain the common tool class and the common service class; the loading module is used for loading the common tool class and the common service class. In this embodiment, as shown in fig. 3, a common tool class and a common service class that contain a static code block or an SPI interface implementation class and are loaded in a delayed manner are scanned, and the common tool class and the common service class that are identified with a preheating annotation in a specified packet path are scanned and added to a current preheating pool based on a java annotation scanning manner.
In an embodiment of the present application, the preheating device for services further includes a reading unit, where before the preheater parses the SQL statement set, the reading unit needs to read a predetermined preheating policy, and the preheating policy is used to control an execution manner and an execution sequence of parsing and loading operations; the analysis unit analyzes the SQL statement set according to the preheating strategy to obtain a plurality of analysis results; and the loading unit loads the generic tool class and the generic service class according to the preheating strategy. In this embodiment, as shown in fig. 2, before the acquisition of the current preheating resource pool, a preheating policy configuration reading operation is performed. The main technical implementation of the configuration reading of the preheating strategy is based on configuration centralized management and control strategy configuration, all scattered service nodes uniformly access the configuration center to pull corresponding preheating strategies, and if the default provided preheating strategy still does not meet the user, the preheater also provides an individualized preheating strategy which can be customized by the user based on the technical scheme of loading the SPI interface. The preheating strategy and the corresponding technical implementation comprise: the method comprises the steps of grouping a synchronous preheating mode or an asynchronous preheating mode, preheating a resource pool, and realizing the maximum utilization rate of software and hardware resources based on a multithreading high-concurrency java thread pool by using a technology corresponding to a preheating strategy of preheating by taking a group as a unit and importing and exporting a multiplexing preheating resource pool; the preheating strategy corresponding technology based on weight preheating for preheating the resource factors is realized by realizing weight preheating based on java priority queue; the extensible customized preheating strategy is realized by expanding customization based on an SPI (serial peripheral interface).
In an embodiment of the present application, the execution manner includes a synchronous execution manner and an asynchronous execution manner, the parsing unit includes a first sending module and a second sending module, the first sending module is configured to send first prompt information when the execution manner is the asynchronous execution manner and the parsing starts, where the first prompt information is that the parsing of the SQL statement set has started; the second sending module is configured to send second prompt information when the execution mode is the synchronous execution mode and the analysis is finished, where the second prompt information indicates that the analysis of the SQL statement set is completed. In this embodiment, as shown in fig. 2, after the acquisition of the current preheating resource pool is completed, a preheating resource implementation operation is performed. The preheating resource implementation can asynchronously preheat the metadata of a table in the middleware of the distributed data access layer respectively, and the SQL set in the current preheating resource pool is used for analyzing and preheating the distributed data access layer to form an analysis result cache for directly multiplexing the SQL set analysis result when the first transaction runs.
In an embodiment of the present application, the parsing unit further includes a determining module, an ordering module, and a parsing module, where the determining module is configured to determine a weight of each SQL statement in the SQL statement set; the sequencing module is used for inputting each SQL statement into a priority queue according to the weight from high to low; the analysis module is used for sequentially analyzing the SQL sentences according to the output sequence of the priority queue to obtain a plurality of analysis results. In this embodiment, as shown in fig. 2, after the acquisition of the current preheating resource pool is completed, a preheating resource implementation operation is performed. The method is characterized in that weight preheating is realized based on a java priority queue, technologies such as reflection and the like are realized based on multithreading, reflection and the like respectively load an entry to metadata of a data access layer, an SQL analysis entry and the like, reflection objects are called, and refined preheating implementation is triggered, so that time consumption of the first transaction is reduced.
In an embodiment of the present application, the above-mentioned preheater includes an SPI interface, and the preheating device of the above-mentioned service further includes a calling unit, and before reading a predetermined preheating policy, the above-mentioned calling unit is used for calling the above-mentioned SPI interface to receive a user-defined preheating policy of a user. In this embodiment, the technology corresponding to the extensible custom preheating policy is implemented by extending the custom based on the SPI interface. Therefore, the preheater also provides a customized personalized preheating strategy based on the technical scheme of the loading SPI interface.
It should be noted that the preheater has the advantages of light weight, refinement, flexibility and reusability, and is mainly embodied in the following aspects:
and (3) lightening: the shadow library is not required to be introduced into each service, database connection with the shadow library is not required to be established, resources are saved, meanwhile, redundant preheating data are not generated, the safety of production data is guaranteed, and the risk of misoperation is reduced.
Refining: aiming at the main time-consuming core elements, point-to-point refinement processing is carried out, namely, the time consumption for introducing the SQL of the distributed data access layer to analyze is too long, the time consumption for pertinence preheating and the time consumption for delay loading of tools or services used by the first transaction as required is optimized, and meanwhile, various preheating strategies are provided for selection, such as synchronous or asynchronous preheating modes, preheating according to weights and the like.
Flexibility: if each service uses the preheater, the preheater directly depends on the components, so that the service can be plugged and pulled out, and the user of the service does not need to adapt and reform.
The reusability is as follows: the pre-heater is provided with a multiplexing pre-heating resource pool formed by collecting dynamic SQL and the like in operation according to the name of the deployed service, can selectively store local imported and exported, and can also push a remote end, so that the pre-heating pool can be multiplexed in different environments of the same type of service nodes.
The pre-heating device of the service comprises a processor and a memory, wherein the acquisition unit, the analysis unit, the loading unit and the like are stored in the memory as program units, and the processor executes the program units stored in the memory to realize corresponding functions.
The processor comprises a kernel, and the kernel calls the corresponding program unit from the memory. The kernel can be set to be one or more than one, and the problem that redundant data is generated by a service preheating method in the prior art is solved by adjusting kernel parameters.
The memory may include volatile memory in a computer readable medium, Random Access Memory (RAM) and/or nonvolatile memory such as Read Only Memory (ROM) or flash memory (flash RAM), and the memory includes at least one memory chip.
An embodiment of the present invention provides a computer-readable storage medium on which a program is stored, the program implementing the method for warming up the service when executed by a processor.
The embodiment of the invention provides a processor, which is used for running a program, wherein the program executes the preheating method of the service when running.
An embodiment of the present invention provides a service system, including a server and a preheater, where the preheater includes one or more processors, a memory, and one or more programs, where the one or more programs are stored in the memory and configured to be executed by the one or more processors, and the processors implement at least the following steps when executing the programs:
Step S101, a preheater acquires a plurality of SQL statements to obtain an SQL statement set;
step S102, the preheater analyzes the SQL statement set to obtain a plurality of analysis results, and the analysis results correspond to the SQL statements one by one;
step S103, the pre-heater loads a generic tool class and a generic service class, so that the server invokes at least one of the analysis result of the pre-heater, the generic tool class and the generic service class to execute a service corresponding to the service request when receiving the service request, where the generic tool class is a tool class in which the number of times of history calling of the service execution service is greater than a predetermined number of times, and the generic service class is a service class in which the number of times of history calling of the service execution service is greater than the predetermined number of times.
The device herein may be a server, a PC, a PAD, a mobile phone, etc.
The present application further provides a computer program product adapted to perform a program of initializing at least the following method steps when executed on a data processing device:
step S101, a preheater acquires a plurality of SQL sentences to obtain an SQL sentence set;
step S102, the preheater analyzes the SQL statement set to obtain a plurality of analysis results, and the analysis results correspond to the SQL statements one by one;
Step S103, the pre-heater loads a generic tool class and a generic service class, so that the server invokes at least one of the analysis result of the pre-heater, the generic tool class and the generic service class to execute a service corresponding to the service request when receiving the service request, where the generic tool class is a tool class in which the number of times of history calling of the service execution service is greater than a predetermined number of times, and the generic service class is a service class in which the number of times of history calling of the service execution service is greater than the predetermined number of times.
In the above embodiments of the present invention, the description of each embodiment has its own emphasis, and reference may be made to the related description of other embodiments for parts that are not described in detail in a certain embodiment.
In the embodiments provided in the present application, it should be understood that the disclosed technical content can be implemented in other manners. The above-described apparatus embodiments are merely illustrative, and for example, the division of the units may be a logical division, and in actual implementation, there may be another division, for example, multiple units or components may be combined or may be integrated into another system, or some features may be omitted, or may not be executed. In addition, the shown or discussed coupling or direct coupling or communication connection between each other may be an indirect coupling or communication connection through some interfaces, units or modules, and may be electrical or in other forms.
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 position, or may be distributed on a plurality of 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 invention 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 may be implemented in the form of hardware, or may also be implemented in the form of a software functional unit.
The integrated unit, if implemented as a software functional unit and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a computer-readable storage medium and includes 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 method according to the embodiments of the present invention. And the aforementioned computer-readable storage medium comprises: a U-disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a removable hard disk, a magnetic or optical disk, and other various media capable of storing program codes.
From the above description, it can be seen that the above-mentioned embodiments of the present application achieve the following technical effects:
1) in the preheating method of the service, firstly, a preheater acquires a plurality of SQL sentences to obtain an SQL sentence set; then, the preheater analyzes the SQL statement set to obtain a plurality of analysis results, wherein the analysis results correspond to the SQL statements one by one; and finally, the preheater loads a common tool class and a common service class, so that the server calls at least one of the analysis result of the preheater, the common tool class and the common service class to execute the service corresponding to the service request under the condition of receiving the service request, wherein the common tool class is a tool class of which the service execution service history calling times are greater than the preset times, and the common service class is a service class of which the service execution service history calling times are greater than the preset times. The method analyzes the SQL statement set to obtain a plurality of analysis results, directly loads common tools and common services, saves the time for analyzing the SQL statements and loading the common tools and the common services when subsequently receiving a service request and executing a transaction service, and executes the transaction service for testing without preheating, so that redundant data generated by testing cannot be generated, the problem that redundant data is generated by a service preheating method in the prior art is solved, misoperation hidden dangers caused by the fact that test data and production data cannot be effectively isolated are avoided, and the safety of the production data is improved.
2) In the service preheating device, an acquisition unit acquires a plurality of SQL sentences to obtain an SQL sentence set; the analysis unit analyzes the SQL statement set to obtain a plurality of analysis results, and the analysis results correspond to the SQL statements one by one; the loading unit loads a generic tool class and a generic service class, so that the server invokes at least one of the analysis result of the preheater, the generic tool class and the generic service class to execute a service corresponding to the service request when receiving the service request, wherein the generic tool class is a tool class in which the service execution service history invoking frequency is greater than a predetermined frequency, and the generic service class is a service class in which the service execution service history invoking frequency is greater than the predetermined frequency. The device analyzes the SQL statement set to obtain a plurality of analysis results, directly loads common tools and common services, saves time for analyzing the SQL statements and loading the common tools and the common services when subsequently receiving a service request and executing the transaction service, and executes the transaction service for testing without preheating, so that redundant data generated by testing cannot be generated, the problem that redundant data is generated by a service preheating method in the prior art is solved, misoperation hidden danger caused by the fact that test data and production data cannot be effectively isolated is avoided, and the safety of the production data is improved.
3) The service system of the present application comprises a server and a preheater, wherein the preheater comprises one or more processors, a memory, and one or more programs, wherein the one or more programs are stored in the memory and configured to be executed by the one or more processors, and the one or more programs comprise instructions for performing the method described above. The system analyzes the SQL statement set to obtain a plurality of analysis results, directly loads the common tools and the common services, can save the time for analyzing the SQL statements and loading the common tools and the common services when subsequently receiving a service request and executing the transaction service, does not need to execute the transaction service for testing when preheating is carried out, thereby not generating redundant data generated by testing, solving the problem that the service preheating method in the prior art generates redundant data, avoiding misoperation hidden danger caused by the fact that the test data and the production data cannot be effectively isolated, and improving the safety of the production data.
The above description is only a preferred embodiment of the present application and is not intended to limit the present application, and various modifications and changes may be made to the present application by those skilled in the art. Any modification, equivalent replacement, or improvement made within the spirit and principle of the present application shall be included in the protection scope of the present application.

Claims (11)

1. A method for pre-heating a service, comprising:
the method comprises the steps that a preheater obtains a plurality of SQL sentences to obtain an SQL sentence set;
the preheater analyzes the SQL statement set to obtain a plurality of analysis results, and the analysis results correspond to the SQL statements one by one;
the preheater loads a common tool class and a common service class so that a server calls at least one of the analysis result of the preheater, the common tool class and the common service class to execute a service corresponding to the service request under the condition that the server receives a service request, wherein the common tool class is a tool class with service execution service history calling times larger than preset times, and the common service class is a service class with service execution service history calling times larger than the preset times.
2. The method of claim 1, wherein the pre-heater comprises an ORM layer and a multiplexing resource pool, the ORM layer is used for mapping data operations into SQL statements, the multiplexing resource pool is used for storing dynamic SQL statements used in the service history execution business record, the SQL statement set comprises a static SQL statement set and a dynamic SQL statement set, and the pre-heater acquires a plurality of SQL statements to obtain the SQL statement set, and the method comprises:
Obtaining a static SQL statement corresponding to the service through the ORM layer to obtain a static SQL statement set; and reading the dynamic SQL sentences of the multiplexing resource pool to obtain the dynamic SQL sentence set.
3. The method of claim 1, wherein the pre-heater loads a commonality tool class and a commonality service class, comprising:
identifying the tool class and the service class with the historical calling times larger than the preset times to obtain a common tool class and a common service class, wherein the common tool class and the common service class have preheating annotation identification;
calling a java annotation scanning function to acquire the common tool class and the common service class;
and loading the common tool class and the common service class.
4. The method of claim 1, wherein prior to the pre-heater parsing the collection of SQL statements, the method comprises:
reading a preset preheating strategy, wherein the preheating strategy is used for controlling the execution mode and the execution sequence of the analysis operation and the loading operation;
analyzing the SQL statement set according to the preheating strategy to obtain a plurality of analysis results;
and loading the common tool class and the common service class according to the preheating strategy.
5. The method according to claim 4, wherein the execution modes include a synchronous execution mode and an asynchronous execution mode, and the parsing the SQL statement set according to the preheating policy to obtain a plurality of parsing results includes:
sending first prompt information under the condition that the execution mode is an asynchronous execution mode and analysis is started, wherein the first prompt information is that the analysis of the SQL statement set is started;
and sending second prompt information under the condition that the execution mode is a synchronous execution mode and the analysis is finished, wherein the second prompt information is the analysis of the SQL statement set.
6. The method of claim 4, wherein parsing the SQL statement set according to the pre-heating policy to obtain a plurality of parsing results further comprises:
determining the weight of each SQL statement in the SQL statement set;
inputting each SQL statement into a priority queue from high to low according to weight;
and analyzing the SQL sentences in sequence according to the output sequence of the priority queue to obtain a plurality of analysis results.
7. The method of claim 4, wherein the pre-heater comprises an SPI interface, and prior to reading a predetermined pre-heating strategy, the method further comprises:
And calling the SPI interface to receive a user-defined preheating strategy of a user.
8. A service preheating device, comprising:
the acquisition unit is used for acquiring a plurality of SQL sentences by the preheater to obtain an SQL sentence set;
the analysis unit is used for analyzing the SQL statement set by the preheater to obtain a plurality of analysis results, and the analysis results correspond to the SQL statements one by one;
a loading unit, configured to load a common tool class and a common service class by the preheater, so that a server invokes at least one of the analysis result of the preheater, the common tool class, and the common service class to execute a service corresponding to a service request when receiving the service request, where the common tool class is a tool class in which the number of times of history calling of service execution service is greater than a predetermined number of times, and the common service class is a service class in which the number of times of history calling of service execution service is greater than the predetermined number of times.
9. A computer-readable storage medium, characterized in that the computer-readable storage medium comprises a stored program, wherein the program performs the method of any one of claims 1 to 7.
10. A processor, configured to run a program, wherein the program when running performs the method of any one of claims 1 to 7.
11. A service system comprising a server and a preheater, the preheater comprising one or more processors, memory and one or more programs, wherein the one or more programs are stored in the memory and configured to be executed by the one or more processors, the one or more programs comprising instructions for performing the method of any of claims 1 to 7.
CN202210159246.8A 2022-02-21 2022-02-21 Service preheating method, preheating device and service system Pending CN114519582A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202210159246.8A CN114519582A (en) 2022-02-21 2022-02-21 Service preheating method, preheating device and service system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202210159246.8A CN114519582A (en) 2022-02-21 2022-02-21 Service preheating method, preheating device and service system

Publications (1)

Publication Number Publication Date
CN114519582A true CN114519582A (en) 2022-05-20

Family

ID=81598381

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202210159246.8A Pending CN114519582A (en) 2022-02-21 2022-02-21 Service preheating method, preheating device and service system

Country Status (1)

Country Link
CN (1) CN114519582A (en)

Citations (17)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6745386B1 (en) * 2000-03-09 2004-06-01 Sun Microsystems, Inc. System and method for preloading classes in a data processing device that does not have a virtual memory manager
US20080127141A1 (en) * 2006-08-17 2008-05-29 Mike Stephen Fulton Conservative class preloading for real time java execution
CN102567033A (en) * 2010-12-14 2012-07-11 北京大学 Class pre-loading method and device based on embedded real-time Java virtual machine
CN103488715A (en) * 2013-09-11 2014-01-01 北京思特奇信息技术股份有限公司 Pre-resolution management method and system based on global configuration
CN103631612A (en) * 2012-08-23 2014-03-12 腾讯科技(深圳)有限公司 Method and device for starting operating system
CN105511874A (en) * 2015-12-02 2016-04-20 海信集团有限公司 Embedded system starting method and intelligent terminal
WO2017049911A1 (en) * 2015-09-21 2017-03-30 中兴通讯股份有限公司 Method, device, and database server for implementing distributed transaction
JP2019074966A (en) * 2017-10-17 2019-05-16 株式会社日立システムズ Sql sentence extraction device, sql sentence extraction method, and program
US20190171750A1 (en) * 2017-12-04 2019-06-06 Bank Of America Corporation Sql server integration services (ssis) package analyzer
CN110019291A (en) * 2017-09-04 2019-07-16 中国移动通信集团浙江有限公司 A kind of SQL analytic method and SQL resolver
CN111966704A (en) * 2020-07-09 2020-11-20 杭州传化智能制造科技有限公司 ORM framework implementation method, system, computer equipment and storage medium
WO2020232569A1 (en) * 2019-05-17 2020-11-26 环球雅途集团有限公司 Database access layer representation method and device
CN112559073A (en) * 2020-12-16 2021-03-26 北京百度网讯科技有限公司 Program starting method, inter-class relation construction method and device and mobile terminal
CN112667632A (en) * 2020-12-24 2021-04-16 浙江大华技术股份有限公司 Metadata processing method and device
US20210191934A1 (en) * 2020-09-04 2021-06-24 Beijing Baidu Netcom Science Technology Co., Ltd. Target data obtaining method and apparatus
CN113872811A (en) * 2021-09-29 2021-12-31 中国建设银行股份有限公司 Operation change method, wide area network control system, electronic device, and storage medium
CN113886426A (en) * 2021-10-21 2022-01-04 京东科技信息技术有限公司 Data query method and device, computer equipment and storage medium

Patent Citations (17)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6745386B1 (en) * 2000-03-09 2004-06-01 Sun Microsystems, Inc. System and method for preloading classes in a data processing device that does not have a virtual memory manager
US20080127141A1 (en) * 2006-08-17 2008-05-29 Mike Stephen Fulton Conservative class preloading for real time java execution
CN102567033A (en) * 2010-12-14 2012-07-11 北京大学 Class pre-loading method and device based on embedded real-time Java virtual machine
CN103631612A (en) * 2012-08-23 2014-03-12 腾讯科技(深圳)有限公司 Method and device for starting operating system
CN103488715A (en) * 2013-09-11 2014-01-01 北京思特奇信息技术股份有限公司 Pre-resolution management method and system based on global configuration
WO2017049911A1 (en) * 2015-09-21 2017-03-30 中兴通讯股份有限公司 Method, device, and database server for implementing distributed transaction
CN105511874A (en) * 2015-12-02 2016-04-20 海信集团有限公司 Embedded system starting method and intelligent terminal
CN110019291A (en) * 2017-09-04 2019-07-16 中国移动通信集团浙江有限公司 A kind of SQL analytic method and SQL resolver
JP2019074966A (en) * 2017-10-17 2019-05-16 株式会社日立システムズ Sql sentence extraction device, sql sentence extraction method, and program
US20190171750A1 (en) * 2017-12-04 2019-06-06 Bank Of America Corporation Sql server integration services (ssis) package analyzer
WO2020232569A1 (en) * 2019-05-17 2020-11-26 环球雅途集团有限公司 Database access layer representation method and device
CN111966704A (en) * 2020-07-09 2020-11-20 杭州传化智能制造科技有限公司 ORM framework implementation method, system, computer equipment and storage medium
US20210191934A1 (en) * 2020-09-04 2021-06-24 Beijing Baidu Netcom Science Technology Co., Ltd. Target data obtaining method and apparatus
CN112559073A (en) * 2020-12-16 2021-03-26 北京百度网讯科技有限公司 Program starting method, inter-class relation construction method and device and mobile terminal
CN112667632A (en) * 2020-12-24 2021-04-16 浙江大华技术股份有限公司 Metadata processing method and device
CN113872811A (en) * 2021-09-29 2021-12-31 中国建设银行股份有限公司 Operation change method, wide area network control system, electronic device, and storage medium
CN113886426A (en) * 2021-10-21 2022-01-04 京东科技信息技术有限公司 Data query method and device, computer equipment and storage medium

Similar Documents

Publication Publication Date Title
US6272674B1 (en) Method and apparatus for loading a Java application program
CN108038045B (en) Android user behavior data acquisition method based on non-buried point
CN109857405A (en) Compilation Method, device, storage medium and the terminal of application program installation kit
US7305376B2 (en) Multiple language-dependent resources compacted into a single resource file
CN109597618B (en) Program development method, program development device, computer device, and storage medium
WO2019085290A1 (en) Test preparation method and apparatus, terminal device, and storage medium
CN108959496A (en) Integration across database access method and abstract data access method based on dynamic proxy
CN112615759B (en) Full link voltage measurement assembly, full link voltage measurement method and device
US8171045B2 (en) Record based code structure
CN113360519B (en) Data processing method, device, equipment and storage medium
EP1704475B1 (en) System and method for dynamically optimized message processing
US7630988B2 (en) Computer product and session management method
CN113821565A (en) Method for synchronizing data of multiple data sources
CN113987337A (en) Search method, system, equipment and storage medium based on componentized dynamic arrangement
CN114519582A (en) Service preheating method, preheating device and service system
CN110059002B (en) Test data generation method, test equipment, storage medium and device
CN112650512A (en) Hardware driving method and device, terminal and storage medium
CN111798309B (en) Wind-controlled variable processing system, method and readable medium
CN117009397A (en) Data query method, data query device, electronic equipment and storage medium
US6219717B1 (en) Method and apparatus for implementing object transparent invocation
CN114138777A (en) Database and table dividing method and device, electronic equipment and storage medium
CN113626001A (en) API dynamic editing method and device based on script
WO2021174756A1 (en) Application system deployment method and apparatus, and computer device and storage medium
CN117234512B (en) Method, system, electronic equipment and storage medium for rapidly developing business
CN116974653B (en) Class loading method and system

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