CN109189799A - Business datum querying method, device, computer equipment and storage medium - Google Patents
Business datum querying method, device, computer equipment and storage medium Download PDFInfo
- Publication number
- CN109189799A CN109189799A CN201810919749.4A CN201810919749A CN109189799A CN 109189799 A CN109189799 A CN 109189799A CN 201810919749 A CN201810919749 A CN 201810919749A CN 109189799 A CN109189799 A CN 109189799A
- Authority
- CN
- China
- Prior art keywords
- algorithm
- sentence
- field
- service
- business
- 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
Links
- 238000000034 method Methods 0.000 title claims abstract description 40
- 238000004422 calculation algorithm Methods 0.000 claims abstract description 199
- 238000004590 computer program Methods 0.000 claims description 16
- 238000010276 construction Methods 0.000 claims description 6
- PCHJSUWPFVWCPO-UHFFFAOYSA-N gold Chemical compound [Au] PCHJSUWPFVWCPO-UHFFFAOYSA-N 0.000 description 16
- 239000010931 gold Substances 0.000 description 15
- 229910052737 gold Inorganic materials 0.000 description 15
- 230000006870 function Effects 0.000 description 4
- 238000010586 diagram Methods 0.000 description 3
- 238000004364 calculation method Methods 0.000 description 2
- 230000000694 effects Effects 0.000 description 2
- 239000000203 mixture Substances 0.000 description 2
- 230000010485 coping Effects 0.000 description 1
- 230000007423 decrease Effects 0.000 description 1
- 230000002708 enhancing effect Effects 0.000 description 1
- 230000010354 integration Effects 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
- 230000001360 synchronised effect Effects 0.000 description 1
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of business datum querying method, device, computer equipment and storage mediums, the business datum querying method includes: to receive service inquiry field and target service field, obtains corresponding business algorithm according to the service inquiry field and the target service field；Obtain the corresponding algorithmic code of the business algorithm；If there is mutually isostructural sentence in the algorithmic code, merge the mutually isostructural sentence；The algorithmic code after merging the mutually isostructural sentence is executed, is obtained and the associated target service data of the service inquiry field.The business datum querying method can reduce the number of system operations, improve the search efficiency of business datum.
Description
Technical field
The invention belongs to data processing fields, are to be related to a kind of business datum querying method, device, meter more specifically
Calculate machine equipment and storage medium.
Background technique
In operation system, need to calculate associated traffic data to realize by related algorithm, and algorithm is logical
The form of crossing code, which is written in system, to be realized.
Due in current system the step of algorithm it is relatively more, correspondingly code also compare it is more, in this way calculating related data
When, the consumption of system resource is just bigger, is easy to cause system operational speed slow, and the speed for returning to the result of calculating is also slow, effect
Rate is lower.In addition, at present when inquiring business datum, the algorithm of system can only be supported by singly being inquired, inquiry
Efficiency is relatively low.
Summary of the invention
The embodiment of the present invention provides a kind of business datum querying method, device, computer equipment and storage medium, to solve
The relatively low problem of business datum computational efficiency.
A kind of business datum querying method, comprising:
Service inquiry field and target service field are received, according to the service inquiry field and the target service field
Obtain corresponding business algorithm；
Obtain the corresponding algorithmic code of the business algorithm；
If there is mutually isostructural sentence in the algorithmic code, merge the mutually isostructural sentence；
The algorithmic code after merging the mutually isostructural sentence is executed, acquisition is associated with the service inquiry field
Target service data.
A kind of business datum inquiry unit, comprising:
Business algorithm obtains module, for receiving service inquiry field and target service field, according to the service inquiry
Field and the target service field obtain corresponding business algorithm；
Algorithmic code obtains module, for obtaining the corresponding algorithmic code of the business algorithm；
Sentence merging module, if merging the identical knot for there is mutually isostructural sentence in the algorithmic code
The sentence of structure；
Target service data acquisition module, for executing the algorithmic code after merging the mutually isostructural sentence,
It obtains and the associated target service data of the service inquiry field.
A kind of computer equipment, including memory, processor and storage are in the memory and can be in the processing
The computer program run on device, the processor realize above-mentioned business datum querying method when executing the computer program
Step.
A kind of computer readable storage medium, the computer-readable recording medium storage have computer program, the meter
The step of calculation machine program realizes above-mentioned business datum querying method when being executed by processor.
Above-mentioned business datum querying method, device, computer equipment and storage medium, by receive service inquiry field and
Target service field obtains corresponding business algorithm according to service inquiry field and target service field；Then business is obtained to calculate
Method corresponding algorithmic code in server-side, after getting corresponding algorithmic code according to mark, to the sentence in algorithmic code
Judged, if there is mutually isostructural sentence in algorithmic code, merges mutually isostructural sentence, to reduce algorithm generation
The number of steps of code is corresponding, improves the efficiency of system operations；The algorithmic code after merging mutually isostructural sentence is finally executed, is obtained
With the associated target service data of service inquiry field return to client, for user carry out using.By to algorithmic code pair
The step of answering is simplified, and the number of system operations is reduced while reducing vernier number, improves the operational efficiency of system.
Detailed description of the invention
It to describe the technical solutions in the embodiments of the present invention more clearly, below will be to embodiment or description of the prior art
Needed in attached drawing be briefly described, it should be apparent that, the accompanying drawings in the following description is only of the invention some
Embodiment for those of ordinary skill in the art without any creative labor, can also be according to these
Attached drawing obtains other attached drawings.
Fig. 1 is an application environment schematic diagram of business datum querying method in one embodiment of the invention；
Fig. 2 is a flow chart of business datum querying method in one embodiment of the invention；
Fig. 3 is another flow chart of business datum querying method in one embodiment of the invention；
Fig. 4 is another flow chart of business datum querying method in one embodiment of the invention；
Fig. 5 is a functional block diagram of business datum inquiry unit in one embodiment of the invention；
Fig. 6 is a schematic diagram of computer equipment in one embodiment of the invention.
Specific embodiment
Following will be combined with the drawings in the embodiments of the present invention, and technical solution in the embodiment of the present invention carries out clear, complete
Site preparation description, it is clear that described embodiments are some of the embodiments of the present invention, instead of all the embodiments.Based on this hair
Embodiment in bright, every other implementation obtained by those of ordinary skill in the art without making creative efforts
Example, shall fall within the protection scope of the present invention.
Business datum querying method provided by the present application, can be applicable in the application environment such as Fig. 1, wherein client is logical
It crosses network to be communicated with server-side, client receives service inquiry field and target service field and is sent to server-side, takes
End be engaged according to service inquiry field and the corresponding business algorithm of target service field acquisition, then server-side obtains business algorithm pair
The algorithmic code answered merges mutually isostructural sentence if there is mutually isostructural sentence in algorithmic code；Last server-side is held
Row merges the algorithmic code after mutually isostructural sentence, obtains and the associated target service data of service inquiry field.Wherein, objective
Family end, which can be, but not limited to, to be various personal computers, laptop, smart phone, tablet computer and portable wearable sets
It is standby.Server-side can be realized with the server cluster of the either multiple server compositions of independent server.
In one embodiment, it as shown in Fig. 2, providing a kind of business datum querying method, applies in Fig. 1 in this way
It is illustrated, includes the following steps: for server-side
S10: receiving service inquiry field and target service field, is obtained according to service inquiry field and target service field
Corresponding business algorithm.
Wherein, service inquiry field refers to the Field Count inputted when carrying out service related data inquiry in operation system
According to for example, inputting number of policy as service inquiry field when inquiring the business datum of settlement of insurance claim gold.Optionally, business is looked into
It askes field to be inputted by client, is sent to server-side through client.Target service field refers to the word for needing to obtain by inquiry
Section, for example, the calculating of Claims Resolution gold.Optionally, target service field is also to be inputted by client, is sent to service through client
End.Business algorithm refers in operation system for calculating the algorithm of service related data, such as insurance money algorithm.Optionally, industry
Business algorithm is stored in the database of server-side.
Specifically, service inquiry field and target service field are received, service inquiry field and target service field are sent out
It send to server-side, server-side obtains corresponding business algorithm according to service inquiry field and target service field from database.
Such as: user inputs number of policy as service inquiry field by client, and input Claims Resolution gold is used as target service
Field, after number of policy and golden field of settling a claim are sent to server-side by client, server-side gets corresponding guarantor according to number of policy
The information such as single type, declaration form people, declaration form man-year age are obtained from database corresponding with the number of policy further according to these information
The business algorithm of Claims Resolution gold.
It should be understood that the business algorithm of the difference of input condition, use is also different when carry out business calculating.For example,
Carry out Claims Resolution gold calculating when, if calculated when the age is between 18-60 years old with algorithm A, if the age 60 years old with
On calculated with algorithm B, if number of policy corresponding declaration form man-year age be 65 years old, should be calculated with algorithm B.
S20: the corresponding algorithmic code of business algorithm is obtained.
Wherein, algorithmic code refers in operation system for executing the code of corresponding business algorithm.Optionally, algorithm generation
Code is stored in server-side, has one-to-one mark with business algorithm, i.e., is identified according to business algorithm available corresponding
Algorithmic code.
Specifically, business algorithm mark is obtained, is obtained from server-side according to business algorithm mark and is identified with business algorithm
Corresponding algorithmic code.Optionally, business algorithm is identified as business algorithm in the serial number of server-side, and algorithmic code is stored in
It is also number to be stored in order, and corresponded with the serial number of business algorithm when server-side, is calculated in this way according to business
Method mark can obtain corresponding algorithmic code.
S30: if there is mutually isostructural sentence in algorithmic code, merge mutually isostructural sentence.
Wherein, mutually isostructural sentence refers to the algorithm in the algorithmic code the step of with same database language construction
Sentence.The step of algorithmic code, is distinguished with vernier, the opening the step of starting to represent an algorithmic code of a vernier
Begin.Optionally, mutually isostructural sentence refers to that there are same database language construction and the identical data of operation in algorithmic code
The sentence of table.Wherein, tables of data refers to the tables of data specifically called in algorithmic code.
Specifically, judge with the presence or absence of mutually isostructural sentence in the corresponding algorithmic code of business algorithm, if so, then will
It is merged in the presence of mutually isostructural arithmetic statement, to reduce the number of steps of business algorithm is in algorithmic code, that is, reduces trip
Mark number.
In a specific embodiment, when merging mutually isostructural algorithmic code, server-side is looked into using structuring
Formula of union all in inquiry language (Structured Query Language, abbreviation SQL) will have mutually isostructural
Sentence merges, to reduce vernier number.
For example, by taking Claims Resolution gold calculates as an example, arithmetic logic are as follows: this month Claims Resolution gold=of that month Claims Resolution increment-history Claims Resolution, and
The algorithmic code of prior partial are as follows:
Step 1:CURSOR......SELECT this month settles a claim the increment amount of money
FROM Claims Resolution table
WHERE condition 1
AND condition 2
AND condition 3
Step 2:CURSOR......SELECT history amount for which loss settled
FROM Claims Resolution table
WHERE condition 4
AND condition 5
AND condition 6
The above code is meant takes out the of that month Claims Resolution increment amount of money and history amount for which loss settled respectively from Claims Resolution table.Due to
The table used all is identical tables of data (Claims Resolution table), the structure of the SQL of use it is also identical (SELECT, FROM, WHERE and
AND), therefore it can be determined that there is mutually isostructural sentence in algorithm above step.
It is therefore possible to use union all formula in SQL will be present mutually isostructural algorithm steps and merge.
It is the partial code after being merged the step in previous example with union all formula below:
Step 1:CURSOR......SELECT this month settles a claim the increment amount of money
FROM Claims Resolution table
WHERE condition 1
AND condition 2
AND condition 3
UNION ALL
SELECT history amount for which loss settled
FROM Claims Resolution table
WHERE condition 4
AND condition 5
AND condition 6
It should be understood that being the number for being determined to execute according to algorithm steps number i.e. vernier number, i.e. vernier number in system operations
More, the number that whens system operations executes is more, and system resources consumption is bigger.The data volume as involved in operation system is very
Greatly, therefore in operation, especially batch operation, if operation times are excessive, it is easy to the performance of operation system be caused to decline.
Therefore, algorithm steps are merged by union all formula, it is possible to reduce vernier number improves system operations efficiency.
S40: executing the algorithmic code after merging mutually isostructural sentence, obtains and the associated target industry of service inquiry field
Business data.
Wherein, target service data refer to returned according to the associated basic data of service inquiry field with target service word
The corresponding data of section, the associated basic data of service inquiry field are stored in the database of server-side, can be looked by business
It askes field to get from database, when executing algorithmic code, server-side is first obtained from database according to service inquiry field
Associated basic data is taken, corresponding target service data are then returned to according to basic data.For example, if target service field
Be Claims Resolution gold, service inquiry field is number of policy, with the associated basic data of service inquiry field be declaration form man-year age, gender,
The insured time limit etc. data, then target service data are to be according to the golden business algorithm of Claims Resolution and the corresponding basic data of number of policy
The concrete operation result (numerical value of Claims Resolution gold) of return.
Specifically, associated basic data is returned to from database according to service inquiry field, it is identical then executes merging
Algorithmic code after the sentence of structure returns to target service data according to the associated basic data of service inquiry field.
For example, server-side receives the service inquiry field of number of policy and the target service field of Claims Resolution gold, according to declaration form
Specific basic data number is got, executes and the algorithmic code obtained after mutually isostructural sentence is merged according to step S30, according to
Basic data returns to specific operation result, the numerical value (target service data) for gold of as settling a claim.
In the corresponding embodiment of Fig. 2, receive service inquiry field and target service field, according to service inquiry field and
Target service field obtains corresponding business algorithm；Then business algorithm corresponding algorithmic code in server-side is obtained, according to
After mark gets corresponding algorithmic code, the sentence in algorithmic code is judged, if there are identical in algorithmic code
The sentence of structure then merges mutually isostructural sentence, to reduce the number of steps of algorithmic code corresponds to, improves the effect of system operations
Rate；The algorithmic code after merging mutually isostructural sentence is finally executed, is obtained and the associated target service number of service inquiry field
According to return to client, for user carry out using.Simplified by the step corresponding to algorithmic code, reduces the same of vernier number
When reduce the numbers of system operations, improve the operational efficiency of system.
In one embodiment, as shown in figure 3, in step S10, that is, service inquiry field and target service field, root are received
Corresponding business algorithm is obtained according to service inquiry field and target service field, is specifically comprised the following steps:
S11: service inquiry field is received, according to service inquiry field acquisition algorithm parameter.
Wherein, algorithm parameter refers to for judging the parameter using which kind of business algorithm.Such as: number of policy, declaration form human nature
Other and declaration form man-year age etc..Optionally, service inquiry field is one of algorithm parameter.It should be understood that algorithm parameter is not
Together, it will lead to the difference of the business algorithm of use, for example, the gender difference or the difference at age of declaration form people will lead to use
Business algorithm is different.
Specifically, client receives service inquiry field, after received service inquiry field is sent to server-side, service
End obtains algorithm parameter relevant to service inquiry field according to service inquiry field.
For example, input number of policy is as service inquiry field, number of policy returns server-side from database based on the received
Declaration form human nature relevant to the number of policy not, age and the insured time limit etc. algorithm parameter.
S12: acquisition algorithm allocation list, integration algorithm allocation list obtain algorithm configuration summary table.
Wherein, algorithm configuration table refers to the table comprising business algorithm and corresponding algorithm parameter, such as algorithm configuration table
Including the main table of algorithm and algorithm condition table.Optionally, algorithm configuration table is stored in the database of server-side, is based on title
Or field can transfer corresponding algorithm configuration table using database language.Algorithm configuration summary table, which refers to, integrates algorithm configuration table
The new table obtained later.
Specifically, title or field based on algorithm configuration table transfer algorithm configuration using database language from database
Algorithm configuration table is integrated into a new table, i.e. algorithm configuration summary table with database language by table.
Algorithm configuration table is integrated it is alternatively possible to be instructed with the with as in SQL.Wherein, with as is instructed
More than two tables can be associated by identical field and be integrated into a table.For example, algorithm configuration Table A and calculation
Method allocation list B C field having the same can then be matched algorithm configuration Table A and algorithm according to C field using with as instruction
It sets table B and is integrated into algorithm configuration summary table.
It should be understood that due to algorithm condition difference, the business algorithm of corresponding use be also it is different, therefore, selecting
It chooses a job when being engaged in algorithm, such as when algorithm configuration table includes the main table of algorithm and algorithm condition table, the main table of algorithm should be used and also used
To algorithm condition table.In step s 12, by the way that algorithm configuration table is integrated into algorithm configuration summary table, then algorithm configuration summary table had been both
Include that business algorithm also includes the relevant algorithm parameter of business algorithm, facilitates taking for business algorithm.
S13: target service field is received, is obtained from algorithm configuration summary table according to algorithm parameter and target service field pair
The business algorithm answered.
Specifically, target service field is received, the algorithm parameter and target service field obtained according to service inquiry field,
Judge whether there is the business algorithm for meeting these conditions in algorithm configuration summary table, if so, then obtaining the business algorithm.
For example, getting the gender of declaration form people according to number of policy as male, the age was greater than for 65 one full year of life, and calculative data are
Claims Resolution gold, i.e. target service field are Claims Resolution gold, then obtain qualified reason according to these conditions from algorithm configuration summary table
Pay for the business algorithm of gold.
In the corresponding embodiment of Fig. 3, by receiving service inquiry field, according to service inquiry field from the number of server-side
According to acquisition algorithm parameter in library；Then algorithm configuration table is integrated into algorithm configuration summary table；Target service field is received, further according to
Algorithm parameter and target service field obtain corresponding business algorithm from algorithm configuration summary table.By the way that algorithm configuration table is integrated
At algorithm configuration summary table, taking for business algorithm can be convenient, correspondingly, to the call number of algorithm configuration table in algorithmic code
It reduces, improves the efficiency of operation.
In one embodiment, as shown in figure 4, in step S30, there is mutually isostructural sentence even in algorithmic code, then
Merge mutually isostructural sentence, comprising the following steps:
S31: if there are the sentence of same database language construction and the identical tables of data of operation, the languages in algorithmic code
Sentence is mutually isostructural sentence.
Specifically, the algorithm steps for including in business algorithm are subjected to grammer scanning, obtain the structure of database language.Example
Such as position of the word of SELECT, FROM and WHERE grammer and appearance.Specifically, can using indexof () method come
Corresponding character string (" SELECT ", " FROM " or " WHERE " etc.) is searched to obtain the structure of database language.Wherein, data
Table refer to the word of FROM grammer followed by tables of data, indicate these sentences be directed toward tables of data, i.e., from the tables of data obtain number
According to.If the database statement used between two steps is identical, and the tables of data operated is all directed to identical tables of data, then sentences
Sentence between fixed two algorithm steps is mutually isostructural sentence.
Such as:
Step 1:CURSOR......SELECT this month settles a claim the increment amount of money
FROM Claims Resolution table
WHERE condition 1
AND condition 2
AND condition 3
Step 2:CURSOR......SELECT history amount for which loss settled
FROM Claims Resolution table
WHERE condition 4
AND condition 5
AND condition 6
By two above step by grammer scan after compare it is found that they all be using identical SELECT, FROM,
The sentence of the structure of WHERE and AND, and the tables of data operated is all directed to Claims Resolution table, i.e., corresponding number is obtained from Claims Resolution table
According to therefore, it is possible to determine that the two algorithm steps are using mutually isostructural sentence.
S32: the mutually isostructural sentence is merged using database language.
Specifically, when judging two algorithm steps using mutually isostructural sentence, the mark of two algorithm steps is obtained,
The initial position of corresponding algorithmic code is obtained according to the mark of algorithm；Then using the merging grammer in database language by two
The code of a algorithm steps carries out headtotail and completes to merge.Wherein, merging grammer can be public using union all in SQL
Formula will be present mutually isostructural algorithm steps and merge, to reduce the vernier number in algorithmic code.
In the corresponding embodiment of Fig. 4, by judging that algorithmic code with the presence or absence of mutually isostructural sentence, is then adopted if it exists
Mutually isostructural sentence is merged with union all formula, it is possible to reduce the corresponding algorithm steps number of business algorithm improves
The efficiency of operation.
In one embodiment, in step S10, that is, service inquiry field and target service field are received, according to service inquiry
Field and target service field obtain corresponding business algorithm, further includes:
When service inquiry field includes service fields name and service fields value, each business is obtained based on service fields name
Field value, according to each service fields value acquisition algorithm parameter, further according to algorithm parameter and target service field from algorithm configuration
Corresponding business algorithm is obtained in summary table.
Wherein, service fields name refers to the mark of each column in the bivariate table using relational model as data structure.Business
The service fields that field value refer to rank the specific value under mark.
Specifically, when service inquiry field includes service fields name and service fields value, client is looked into reception business
When asking field, each service fields value of service fields under one's name is obtained based on service fields name.It is alternatively possible to be built in client
Found an interface, using the table input form of service fields name and service fields value, i.e., interface using the first row of input as
Service fields name, the second row input as the form of service fields value, each service fields value of input are separately sent to take
Business end, server-side return to algorithm parameter relevant to service fields value according to service fields value from database, and then basis obtains
The algorithm parameter and target service field obtained is judged, judges to calculate in algorithm configuration summary table with the presence or absence of qualified business
Method, if so, then returning to corresponding business algorithm from algorithm configuration summary table.
In the present embodiment, by returning to algorithm parameter from database respectively, so with the input form of service fields value
Corresponding business algorithm is obtained from algorithm configuration summary table according to algorithm parameter and target service field afterwards, it in this way can be according to more
A service fields value batch returns multiple as a result, realizing batch query, improves the efficiency of inquiry.
In one embodiment, after the step s 40, that is, the algorithmic code after merging mutually isostructural sentence is executed, is obtained
After the step of target service data associated with service inquiry field, further includes: by target service data and service inquiry word
Query result is formed after Duan Guanlian and is returned.
Specifically, target service data and service inquiry field are associated using database language, it is a pair of forms one
The form answered returns to client as query result.It is alternatively possible to the left join formula in SQL by service inquiry
Field is associated and returns with target service data.
For example, can be merged with following SQL statement (partial code) to service inquiry field and target service data:
SELECT number of policy
FROM declaration form table
LEFT JOIN (SELECT Claims Resolution gold
FROM Claims Resolution table
WHERE......
The above code means that the Claims Resolution gold using the number of policy in declaration form table as service inquiry field, in table of settling a claim is made
It merges for target service data and is returned as query result.
It is returned by the way that service inquiry field and target service data are formed query result, can make the result returned can
The property read is higher, facilitates checking for query result.
It should be understood that the size of the serial number of each step is not meant that the order of the execution order in above-described embodiment, each process
Execution sequence should be determined by its function and internal logic, the implementation process without coping with the embodiment of the present invention constitutes any limit
It is fixed.
In one embodiment, a kind of business datum inquiry unit is provided, the business datum inquiry unit and above-described embodiment
Middle business datum querying method corresponds.As shown in figure 5, the business datum inquiry unit includes that business algorithm obtains module
10, algorithmic code obtains module 20, sentence merging module 30 and target service data acquisition module 40.Each functional module is specifically
It is bright as follows:
Business algorithm obtains module 10, for receiving service inquiry field and target service field, according to service inquiry word
Section and target service field obtain corresponding business algorithm.
Algorithmic code obtains module 20, for obtaining the corresponding algorithmic code of business algorithm.
Sentence merging module 30, if merging mutually isostructural language for there is mutually isostructural sentence in algorithmic code
Sentence.
Target service data acquisition module 40, for executing the algorithmic code after merging mutually isostructural sentence, obtain and
The associated target service data of service inquiry field.
Further, it includes algorithm parameter acquiring unit 11, algorithm configuration table integral unit that business algorithm, which obtains module 10,
12 and business algorithm acquiring unit 13.
Algorithm parameter acquiring unit 11, for receiving service inquiry field, according to service inquiry field acquisition algorithm parameter.
Algorithm configuration table integral unit 12, is used for acquisition algorithm allocation list, and it is total to obtain algorithm configuration for whole rear algorithm configuration table
Table.
Business algorithm acquiring unit 13, for receiving target service field, according to algorithm parameter and target service field from
Corresponding business algorithm is obtained in algorithm configuration summary table.
Further, sentence merging module 30 includes structure decision unit 31 and sentence combining unit 32.
Structure decision unit 31, if for there are same database language construction and the identical data of operation in algorithmic code
The sentence of table, then the sentence is mutually isostructural sentence.
Sentence combining unit 32, for merging mutually isostructural sentence using database language.
Further, business algorithm obtains module 10 further include: when service inquiry field includes service fields name and business
When field value, each service fields value is obtained based on service fields name；According to each service fields value acquisition algorithm parameter；Root again
Corresponding business algorithm is obtained from algorithm configuration summary table according to algorithm parameter and target service field.
Further, which further includes result relating module 50.
As a result relating module 50, for forming query result after being associated with target service data with service inquiry field and returning
It returns.
Specific about business datum inquiry unit limits the limit that may refer to above for business datum querying method
Fixed, details are not described herein.Modules in above-mentioned business datum inquiry unit can fully or partially through software, hardware and its
Combination is to realize.Above-mentioned each module can be embedded in the form of hardware or independently of in the processor in computer equipment, can also be with
It is stored in the memory in computer equipment in a software form, in order to which processor calls the above modules of execution corresponding
Operation.
In one embodiment, a kind of computer equipment is provided, which can be server, internal junction
Composition can be as shown in Figure 6.The computer equipment include by system bus connect processor, memory, network interface and
Database.Wherein, the processor of the computer equipment is for providing calculating and control ability.The memory packet of the computer equipment
Include non-volatile memory medium, built-in storage.The non-volatile memory medium is stored with operating system, computer program and data
Library.The built-in storage provides environment for the operation of operating system and computer program in non-volatile memory medium.The calculating
The database of machine equipment is for storing basic data, business algorithm, algorithm configuration table, algorithmic code, algorithm parameter and target industry
Business data.The network interface of the computer equipment is used to communicate with external terminal by network connection.The computer program quilt
To realize a kind of business datum querying method when processor executes.
In one embodiment, a kind of computer equipment is provided, including memory, processor and storage are on a memory
And the computer program that can be run on a processor, processor perform the steps of when executing computer program
Service inquiry field and target service field are received, is obtained and is corresponded to according to service inquiry field and target service field
Business algorithm；
The corresponding algorithmic code of acquisition business algorithm；
If there is mutually isostructural sentence in algorithmic code, merge mutually isostructural sentence；
The algorithmic code after merging mutually isostructural sentence is executed, is obtained and the associated target service number of service inquiry field
According to.
In one embodiment, a kind of computer readable storage medium is provided, computer program is stored thereon with, is calculated
Machine program performs the steps of when being executed by processor
Service inquiry field and target service field are received, is obtained and is corresponded to according to service inquiry field and target service field
Business algorithm；
The corresponding algorithmic code of acquisition business algorithm；
If there is mutually isostructural sentence in algorithmic code, merge mutually isostructural sentence；
The algorithmic code after merging mutually isostructural sentence is executed, is obtained and the associated target service number of service inquiry field
According to.
Those of ordinary skill in the art will appreciate that realizing all or part of the process in above-described embodiment method, being can be with
Relevant hardware is instructed to complete by computer program, the computer program can be stored in a non-volatile computer
In read/write memory medium, the computer program is when being executed, it may include such as the process of the embodiment of above-mentioned each method.Wherein,
To any reference of memory, storage, database or other media used in each embodiment provided herein,
Including non-volatile and/or volatile memory.Nonvolatile memory may include read-only memory (ROM), programming ROM
(PROM), electrically programmable ROM (EPROM), electrically erasable ROM (EEPROM) or flash memory.Volatile memory may include
Random access memory (RAM) or external cache.By way of illustration and not limitation, RAM is available in many forms,
Such as static state RAM (SRAM), dynamic ram (DRAM), synchronous dram (SDRAM), double data rate sdram (DDRSDRAM), enhancing
Type SDRAM (ESDRAM), synchronization link (Synchlink) DRAM (SLDRAM), memory bus (Rambus) direct RAM
(RDRAM), direct memory bus dynamic ram (DRDRAM) and memory bus dynamic ram (RDRAM) etc..
It is apparent to those skilled in the art that for convenience of description and succinctly, only with above-mentioned each function
Can unit, module division progress for example, in practical application, can according to need and by above-mentioned function distribution by different
Functional unit, module are completed, i.e., the internal structure of described device is divided into different functional unit or module, more than completing
The all or part of function of description.
Embodiment described above is merely illustrative of the technical solution of the present invention, rather than its limitations；Although referring to aforementioned reality
Applying example, invention is explained in detail, those skilled in the art should understand that: it still can be to aforementioned each
Technical solution documented by embodiment is modified or equivalent replacement of some of the technical features；And these are modified
Or replacement, the spirit and scope for technical solution of various embodiments of the present invention that it does not separate the essence of the corresponding technical solution should all
It is included within protection scope of the present invention.
Claims (10)
1. a kind of business datum querying method, which comprises the following steps:
Service inquiry field and target service field are received, is obtained according to the service inquiry field and the target service field
Corresponding business algorithm；
Obtain the corresponding algorithmic code of the business algorithm；
If there is mutually isostructural sentence in the algorithmic code, merge the mutually isostructural sentence；
The algorithmic code after merging the mutually isostructural sentence is executed, is obtained and the associated mesh of service inquiry field
Mark business datum.
2. business datum querying method as described in claim 1, which is characterized in that the reception service inquiry field and target
Service fields obtain corresponding business algorithm, including following step according to the service inquiry field and the target service field
It is rapid:
Service inquiry field is received, according to the service inquiry field acquisition algorithm parameter；
Acquisition algorithm allocation list integrates the algorithm configuration table, obtains algorithm configuration summary table；
Target service field is received, is obtained from the algorithm configuration summary table according to the algorithm parameter and the target service field
Take corresponding business algorithm.
3. business datum querying method as described in claim 1, which is characterized in that if there are phases in the algorithmic code
Isostructural sentence then merges the mutually isostructural sentence, comprising:
If there are the sentence of same database language construction and the identical tables of data of operation, the sentences in the algorithmic code
For mutually isostructural sentence；
The mutually isostructural sentence is merged using database language.
4. business datum querying method as claimed in claim 2, which is characterized in that the reception service inquiry field and target
Service fields obtain corresponding business algorithm according to the service inquiry field and the target service field, further includes:
When the service inquiry field includes service fields name and service fields value, obtained based on the service fields name each
The service fields value；
The algorithm parameter is obtained according to each service fields value；
Corresponding business algorithm is obtained from the algorithm configuration summary table according to the algorithm parameter and the target service field.
5. business datum querying method as claimed in claim 4, which is characterized in that merge the mutually isostructural language executing
The algorithmic code after sentence, obtain with the step of the service inquiry field associated target service data after, the industry
Business data query method further include:
Query result is formed after the target service data are associated with the service inquiry field and is returned.
6. a kind of business datum inquiry unit characterized by comprising
Business algorithm obtains module, for receiving service inquiry field and target service field, according to the service inquiry field
Corresponding business algorithm is obtained with the target service field；
Algorithmic code obtains module, for obtaining the corresponding algorithmic code of the business algorithm；
Sentence merging module, if merging described mutually isostructural for there is mutually isostructural sentence in the algorithmic code
Sentence；
Target service data acquisition module is obtained for executing the algorithmic code after merging the mutually isostructural sentence
With the associated target service data of the service inquiry field.
7. business datum inquiry unit as claimed in claim 6, which is characterized in that it includes calculating that the business algorithm, which obtains module,
Method parameter acquiring unit, algorithm configuration table integral unit and business algorithm acquiring unit；
The algorithm parameter acquiring unit is joined for receiving service inquiry field according to the service inquiry field acquisition algorithm
Number；
The algorithm configuration table integral unit is used for acquisition algorithm allocation list, integrates the algorithm configuration table, obtain algorithm configuration
Summary table；
The business algorithm acquiring unit, for receiving target service field, according to the algorithm parameter and the target service
Field obtains corresponding business algorithm from the algorithm configuration summary table.
8. business datum inquiry unit as claimed in claim 6, which is characterized in that the sentence merging module includes that structure is sentenced
Disconnected unit and sentence combining unit；
The structure decision unit, if there are same database language construction and the identical tables of data of operation in the algorithmic code
Sentence, then determine the sentence for mutually isostructural sentence；
The sentence combining unit merges the mutually isostructural sentence using database language.
9. a kind of computer equipment, including memory, processor and storage are in the memory and can be in the processor
The computer program of upper operation, which is characterized in that the processor realized when executing the computer program as claim 1 to
The step of any one of 5 business datum querying method.
10. a kind of computer readable storage medium, the computer-readable recording medium storage has computer program, and feature exists
In realizing the business datum querying method as described in any one of claim 1 to 5 when the computer program is executed by processor
Step.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810919749.4A CN109189799B (en) | 2018-08-14 | 2018-08-14 | Service data query method, device, computer equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810919749.4A CN109189799B (en) | 2018-08-14 | 2018-08-14 | Service data query method, device, computer equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109189799A true CN109189799A (en) | 2019-01-11 |
| CN109189799B CN109189799B (en) | 2024-04-26 |
Family
ID=64921302
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810919749.4A Active CN109189799B (en) | 2018-08-14 | 2018-08-14 | Service data query method, device, computer equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109189799B (en) |
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110597842A (en) * | 2019-07-22 | 2019-12-20 | 石化盈科信息技术有限责任公司 | Service data query method and system |
| CN110928607A (en) * | 2019-11-21 | 2020-03-27 | 浙江大搜车软件技术有限公司 | Service implementation method, device, computer equipment and storage medium |
| CN111125092A (en) * | 2019-11-18 | 2020-05-08 | 贝壳技术有限公司 | Service index query method and device |
| CN111460298A (en) * | 2020-03-31 | 2020-07-28 | 深圳市酷开网络科技有限公司 | Service data processing method and device, computer equipment and storage medium |
| CN111475316A (en) * | 2020-04-14 | 2020-07-31 | 中国人民解放军战略支援部队信息工程大学 | Persistence operation method, device, equipment and system for mimicry construction cloud service system |
| CN111563094A (en) * | 2020-03-31 | 2020-08-21 | 北京奇艺世纪科技有限公司 | Data query method and device, electronic equipment and computer-readable storage medium |
| CN112102099A (en) * | 2020-09-16 | 2020-12-18 | 泰康保险集团股份有限公司 | Policy data processing method and device, electronic equipment and storage medium |
| CN113010510A (en) * | 2019-12-20 | 2021-06-22 | 中国移动通信集团安徽有限公司 | Service identification method, device and system and computing equipment |
| CN113515544A (en) * | 2021-06-23 | 2021-10-19 | 金蝶软件（中国）有限公司 | Data attribute query method and data attribute query device |
| CN113780716A (en) * | 2021-07-09 | 2021-12-10 | 北京鼎立保险经纪有限责任公司 | Business machine account generation system |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102004766A (en) * | 2010-11-09 | 2011-04-06 | 北京神州泰岳软件股份有限公司 | Query method and system for configurable information based on information system |
| CN105224566A (en) * | 2014-06-25 | 2016-01-06 | 国际商业机器公司 | Relational database is supported the method and system of injunctive graphical query |
| CN107291907A (en) * | 2017-06-20 | 2017-10-24 | 深圳中兴网信科技有限公司 | A kind of multilingual storage of business datum and querying method and device |
| CN108319722A (en) * | 2018-02-27 | 2018-07-24 | 北京小度信息科技有限公司 | Data access method, device, electronic equipment and computer readable storage medium |
-
2018
- 2018-08-14 CN CN201810919749.4A patent/CN109189799B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102004766A (en) * | 2010-11-09 | 2011-04-06 | 北京神州泰岳软件股份有限公司 | Query method and system for configurable information based on information system |
| CN105224566A (en) * | 2014-06-25 | 2016-01-06 | 国际商业机器公司 | Relational database is supported the method and system of injunctive graphical query |
| CN107291907A (en) * | 2017-06-20 | 2017-10-24 | 深圳中兴网信科技有限公司 | A kind of multilingual storage of business datum and querying method and device |
| CN108319722A (en) * | 2018-02-27 | 2018-07-24 | 北京小度信息科技有限公司 | Data access method, device, electronic equipment and computer readable storage medium |
Cited By (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110597842B (en) * | 2019-07-22 | 2023-10-03 | 石化盈科信息技术有限责任公司 | Service data query method and system |
| CN110597842A (en) * | 2019-07-22 | 2019-12-20 | 石化盈科信息技术有限责任公司 | Service data query method and system |
| CN111125092A (en) * | 2019-11-18 | 2020-05-08 | 贝壳技术有限公司 | Service index query method and device |
| CN110928607A (en) * | 2019-11-21 | 2020-03-27 | 浙江大搜车软件技术有限公司 | Service implementation method, device, computer equipment and storage medium |
| CN110928607B (en) * | 2019-11-21 | 2024-05-14 | 浙江大搜车软件技术有限公司 | Service implementation method, device, computer equipment and storage medium |
| CN113010510A (en) * | 2019-12-20 | 2021-06-22 | 中国移动通信集团安徽有限公司 | Service identification method, device and system and computing equipment |
| CN113010510B (en) * | 2019-12-20 | 2024-03-19 | 中国移动通信集团安徽有限公司 | Service identification method, device, system and computing equipment |
| CN111460298A (en) * | 2020-03-31 | 2020-07-28 | 深圳市酷开网络科技有限公司 | Service data processing method and device, computer equipment and storage medium |
| CN111563094A (en) * | 2020-03-31 | 2020-08-21 | 北京奇艺世纪科技有限公司 | Data query method and device, electronic equipment and computer-readable storage medium |
| CN111475316A (en) * | 2020-04-14 | 2020-07-31 | 中国人民解放军战略支援部队信息工程大学 | Persistence operation method, device, equipment and system for mimicry construction cloud service system |
| CN111475316B (en) * | 2020-04-14 | 2023-01-24 | 中国人民解放军战略支援部队信息工程大学 | Persistence operation method, device, equipment and system for mimicry construction cloud service system |
| CN112102099A (en) * | 2020-09-16 | 2020-12-18 | 泰康保险集团股份有限公司 | Policy data processing method and device, electronic equipment and storage medium |
| CN112102099B (en) * | 2020-09-16 | 2023-11-24 | 泰康保险集团股份有限公司 | Policy data processing method and device, electronic equipment and storage medium |
| CN113515544A (en) * | 2021-06-23 | 2021-10-19 | 金蝶软件（中国）有限公司 | Data attribute query method and data attribute query device |
| CN113780716A (en) * | 2021-07-09 | 2021-12-10 | 北京鼎立保险经纪有限责任公司 | Business machine account generation system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109189799B (en) | 2024-04-26 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109189799A (en) | Business datum querying method, device, computer equipment and storage medium | |
| US9906623B2 (en) | System and method for accessing data objects via remote references | |
| CN107491485B (en) | Method for generating execution plan, plan unit device and distributed NewSQ L database system | |
| CN109558440A (en) | Batch data processing method, device, computer equipment and storage medium | |
| CN110457431A (en) | Answering method, device, computer equipment and the storage medium of knowledge based map | |
| US20100106684A1 (en) | Synchronization of a conceptual model via model extensions | |
| CN109194495B (en) | Server, message processing method, and computer-readable storage medium | |
| CN110298539A (en) | Task data processing method, device, computer equipment and storage medium | |
| CN110580189A (en) | method and device for generating front-end page, computer equipment and storage medium | |
| CN111061766A (en) | Business data processing method and device, computer equipment and storage medium | |
| US20130173509A1 (en) | Method and arrangement for processing data | |
| CN109960633A (en) | A kind of data visualization buries point methods, storage medium and intelligent terminal | |
| CN109062925A (en) | Automatically generate the method, apparatus, computer equipment and storage medium of insert sentence | |
| US11665247B2 (en) | Resource discovery agent computing device, software application, and method | |
| CN109656950B (en) | Recursive query method, device, server and storage medium | |
| CN110471585A (en) | Function of application icon methods of exhibiting, device and computer equipment | |
| CN111324716A (en) | Index data acquisition method and device, computer equipment and storage medium | |
| CN109783788A (en) | Tables of data complementing method, device, computer equipment and storage medium | |
| CN112115276A (en) | Intelligent customer service method, device, equipment and storage medium based on knowledge graph | |
| CN111309991B (en) | Query statement generation method and device and data query method and system | |
| CN110457401B (en) | Data storage method and device, computer equipment and storage medium | |
| CN109656947B (en) | Data query method and device, computer equipment and storage medium | |
| CN110275703A (en) | Assignment method, device, computer equipment and the storage medium of key-value pair data | |
| CN109360111A (en) | Questionnaire data modification method, device, computer equipment and storage medium | |
| CN111522840A (en) | Label configuration method, device, equipment and computer readable 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 |