CN109325041A - Business data processing method, device, computer equipment and storage medium - Google Patents
Business data processing method, device, computer equipment and storage medium Download PDFInfo
- Publication number
- CN109325041A CN109325041A CN201810920892.5A CN201810920892A CN109325041A CN 109325041 A CN109325041 A CN 109325041A CN 201810920892 A CN201810920892 A CN 201810920892A CN 109325041 A CN109325041 A CN 109325041A
- Authority
- CN
- China
- Prior art keywords
- target
- demand
- splicing
- data
- source
- 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
- 238000003672 processing method Methods 0.000 title claims abstract description 32
- 238000003860 storage Methods 0.000 title claims abstract description 23
- 238000012545 processing Methods 0.000 claims abstract description 27
- 230000006870 function Effects 0.000 claims description 116
- 238000004590 computer program Methods 0.000 claims description 26
- 238000004422 calculation algorithm Methods 0.000 claims description 9
- 238000000034 method Methods 0.000 abstract description 19
- 230000008569 process Effects 0.000 description 10
- 239000011159 matrix material Substances 0.000 description 5
- 238000006243 chemical reaction Methods 0.000 description 4
- 238000000605 extraction Methods 0.000 description 4
- 238000013518 transcription Methods 0.000 description 4
- 230000035897 transcription Effects 0.000 description 4
- 238000010586 diagram Methods 0.000 description 3
- 241000208340 Araliaceae Species 0.000 description 2
- 235000005035 Panax pseudoginseng ssp. pseudoginseng Nutrition 0.000 description 2
- 235000003140 Panax quinquefolius Nutrition 0.000 description 2
- 238000004458 analytical method Methods 0.000 description 2
- 238000004364 calculation method Methods 0.000 description 2
- 235000008434 ginseng Nutrition 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 230000007306 turnover Effects 0.000 description 2
- 230000009471 action Effects 0.000 description 1
- 230000006399 behavior Effects 0.000 description 1
- 230000010485 coping Effects 0.000 description 1
- 238000012217 deletion Methods 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000009826 distribution Methods 0.000 description 1
- 230000002708 enhancing effect Effects 0.000 description 1
- PCHJSUWPFVWCPO-UHFFFAOYSA-N gold Chemical compound [Au] PCHJSUWPFVWCPO-UHFFFAOYSA-N 0.000 description 1
- 239000010931 gold Substances 0.000 description 1
- 229910052737 gold Inorganic materials 0.000 description 1
- 238000005304 joining Methods 0.000 description 1
- 239000000203 mixture Substances 0.000 description 1
- 238000002360 preparation method Methods 0.000 description 1
- 238000012216 screening Methods 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
- 230000001360 synchronised effect Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION 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
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/08—Insurance
Abstract
The invention discloses a kind of business data processing method, device, computer equipment and storage mediums, this method comprises: creating at least one original splicing function, each original splicing function includes splicing type；Business datum demand is obtained, business datum demand includes target type, target component, target source and goal condition；Database is inquired according to target type, is that the corresponding original splicing function of target type is determined as target splicing function by splicing type；Splicing is carried out to target component, target source and goal condition using target splicing function, generates target SQL instruction；It is instructed according to target SQL, source corresponding with target source table in database is handled, obtain target data.The business data processing method can be automatically converted to SQL instruction according to business datum demand, and instruct according to SQL and carry out data processing, to improve data-handling efficiency and save human cost.
Description
Technical field
The present invention relates to data processing field more particularly to a kind of business data processing method, device, computer equipment and
Storage medium.
Background technique
With economic development, the business datum stored in database is more and more, it usually needs to the data in database
It is handled, in the prior art it is generally necessary to which data requirements to be artificially converted to SQL instruction, and executes SQL instruction to database
Middle data extract analysis.When data requirements is more, the process for being artificially turned into SQL instruction need to expend a large amount of manpowers, and
Than relatively time-consuming, it is unfavorable for improving data-handling efficiency.
Summary of the invention
The embodiment of the present invention provides a kind of business data processing method, device, computer equipment and storage medium, to solve
Demand is artificially converted into the problem of SQL is instructed and carried out data handling procedure time-consuming.
A kind of business data processing method, comprising:
At least one original splicing function is created, each original splicing function includes splicing type；
Obtain business datum demand, the business datum demand includes that target type, target component, target carry out source and target
Condition；
Database is inquired according to the target type, is the corresponding original splicing letter of the target type by splicing type
Number is determined as target splicing function；
The target component, the target source and the goal condition are spliced using target splicing function
Processing generates target SQL instruction；
It is instructed according to the target SQL, source table corresponding with the target source in database is handled, obtain mesh
Mark data.
A kind of service data processing apparatus, comprising:
Original splicing function creation module, for creating at least one original splicing function, each original splicing letter
Number includes splicing type；
Data acquisition module, for obtaining business datum demand, the business datum demand includes target type, target ginseng
Number, target source and goal condition；
Splice function and obtain module, is the target by splicing type for inquiring database according to the target type
The corresponding original splicing function of type is determined as target splicing function；
SQL directive generation module, for using the target splicing function to the target component, the target source and
The goal condition carries out splicing, generates target SQL instruction；
Data acquisition module, for being instructed according to the target SQL, to source corresponding with the target source in database
Table is handled, and target data is obtained.
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 data processing 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 data processing method when being executed by processor.
Above-mentioned business data processing method, device, computer equipment and storage medium, by creating at least one original spelling
Function is connect, each original splicing function includes splicing type, is spliced so as to subsequent according to original splicing function.Pass through acquisition
Business datum demand, business datum demand includes target type, target component, target source and goal condition, so as to subsequent right
Business datum demand is corresponding to carry out splicing according to target type, target component, target source and goal condition.According to target
Splicing type is that the corresponding original splicing function of target type is determined as target splicing function, energy by type queries database
Enough by the corresponding splicing function of target type quick obtaining, acquisition process is simple and quick.Target is joined using target splicing function
Number, target source and goal condition carry out splicing, generate target SQL instruction, are not required to manually carry out the transcription of SQL instruction,
It saves labour turnover, and improves transcription productivity.According to target SQL instruct, to source corresponding with target source table in database into
Row processing obtains target data, and acquisition target data process is simple and quick, improves data-handling efficiency.
Detailed description of the invention
In order to illustrate the technical solution of the embodiments of the present invention more clearly, below by institute in the description to the embodiment of the present invention
Attached drawing to be used is needed to be briefly described, it should be apparent that, the accompanying drawings in the following description is only some implementations of the invention
Example, for those of ordinary skill in the art, without any creative labor, can also be according to these attached drawings
Obtain other attached drawings.
Fig. 1 is an application environment schematic diagram of business data processing method in one embodiment of the invention；
Fig. 2 is a flow chart of business data processing method in one embodiment of the invention；
Fig. 3 is a flow chart of business data processing method in one embodiment of the invention；
Fig. 4 is a flow chart of business data processing method in one embodiment of the invention；
Fig. 5 is a flow chart of business data processing method in one embodiment of the invention；
Fig. 6 is a functional block diagram of service data processing apparatus in one embodiment of the invention；
Fig. 7 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 data processing method provided in an embodiment of the present invention can be applicable in the application environment such as Fig. 1, wherein visitor
Family end is communicated by network with server.Client uploads business datum to server, and server carries out business datum
Storage, and query processing can be carried out to the business datum that server stores.Wherein, client can be, but not limited to various individuals
Computer, laptop, smart phone, tablet computer and portable wearable device.Server can use independent service
The server cluster of device either multiple servers composition is realized.
In one embodiment, it as shown in Fig. 2, providing a kind of business data processing method, applies in Fig. 1 in this way
It is illustrated, includes the following steps: for server
S10: creating at least one original splicing function, and each original splicing function includes splicing type.
Wherein, original splicing function is preset, and storage is in the database.
Specifically, server creates corresponding original splicing function according to the difference of splicing type, and splicing type refers to SQL
The condition types of sentence, for example, select..from..where... and delete...from..where.. etc..By original spelling
It connects function and splicing type one-to-one correspondence is stored in data.By the way that original splicing function is pre-created, so as to subsequently through spelling
It connects type and execution is called to original splicing function, and only need to once create, called repeatedly for subsequent.
S20: obtaining business datum demand, and business datum demand includes that target type, target component, target carry out source and target
Condition.
Wherein, business datum demand refers to the demand that the business datum to source table in database is handled.Source table refers to
It is the table for loading tracking, needs to check or use its business datum when replay tracks, store at least one source in database
Table.Target type is used to limit the type for the SQL statement to be converted into, which may include inquiry, increases, modification
With delete etc. types, indicated respectively with select, insert, update and delete.Target component refers to be needed from business datum
Seek the field parameter of middle extraction.Target source refers to the source table name extracted from business data requirements.Goal condition refers to working
The screening conditions extracted in business data requirements.
Specifically, by network connection, server receives the business datum demand that client is sent for client and server.
Wherein, business datum demand can be the corresponding business datum demand of a source table, and it is one corresponding to be also possible to multiple source tables
Business datum demand.Target type, target component, target source and goal condition are obtained from business data requirements.Wherein, mesh
Mark type can be select, insert, update and delete, and target component can be the field of source table in database, mesh
Mark source can be the title of source table in database, and goal condition can refer to the condition screened to data.When target item
When using conditional operator in part, it is generally used for counting greater than, equal to and being less than etc., is greater than in SQL syntax and uses symbol > table
Show, equal to symbol=indicate, less than with symbol < indicate.For example, the demand analysis age be greater than 30 years old client from history till now
Goal condition can be set as age > 30, insurance kind=A insurance kind by the A insurance kind amount of money of purchase.
Server after extracting target type, target component, target source and goal condition in business data requirements,
Target type, target component, target source and goal condition are stored according to preset standard requirement tables of data.Wherein,
Standard requirement tables of data is the pre-set tables of data for meeting SQL conversion requirements.In standard requirement tables of data by type field,
Parameter field, source field and condition field as type field in gauge outfit field, with standard requirement tables of data, parameter field,
Source field and the corresponding field value of condition field are respectively target type, target component, target source and goal condition.Example
Such as, server receives a certain business datum demand are as follows: " in statistics A table purchase insurance kind be B insurance kind client, it is average insured amount and
Amount for which loss settled " can determine that its target type is " select type " by business datum demand, and target component is that " client puts down
It is insured amount, amount for which loss settled ", target source is " A table ", is " insurance kind=B insurance kind " to goal condition；Then, it will acquire
Target type, target component, target source and goal condition stored according to standard requirement tables of data as shown in Table 1:
One standard requirement tables of data of table
S30: inquiring database according to target type, is the corresponding original splicing letter of the target type by splicing type
Number is determined as target splicing function.
Wherein, target splicing function, which refers to, is stored in advance splicing function corresponding with target type in the database.
Splicing function corresponding with each type is previously stored in the present embodiment, in database, so as to according to type
Find corresponding splicing function.Specifically, server determines target type, target component, target by business datum demand
Behind source and goal condition, it is that target type inquires Field Inquiry database by splicing type, is found from database and mesh
The corresponding original splicing function of type is marked, the original splicing function found is determined as target splicing function.For example, splicing
Type is target type select, searches database, and get original splicing function corresponding with select type as mesh
Mark splicing function.
S40: splicing is carried out to target component, target source and goal condition using target splicing function, generates mesh
Mark SQL instruction.
Wherein, target SQL instruction refers to SQL instruction corresponding with target component, target source and goal condition.SQL
(Structured Query Language, structured query language) is a kind of programming language of specific purposes, is a kind of data
Library inquiry and programming language, for accessing data and querying, updating, and managing relational database system.SQL is instructed
Refer in the database for executing the instruction of the operations such as inquiry, increase, modification and deletion.
Specifically, after server gets target splicing function according to target type, target splicing function is acquired to mesh
It marks parameter, target source and goal condition and carries out splicing, to generate target SQL instruction, target SQL instruction generated
SQL syntax format are as follows: target type target component from target source where goal condition.As shown in Table 1, from data
After getting target splicing function corresponding with select in library, function is spliced to target component " client, average guarantor by target
Volume, amount for which loss settled ", target source " A table ", goal condition " insurance kind=B insurance kind " carry out splicing, meet SQL to get
The target SQL of syntax format is instructed, target SQL instruction are as follows: select client, average protection amount, amount for which loss settled from A table
Where insurance kind=B insurance kind.
S50: instructing according to target SQL, handle source corresponding with target source table in database, obtains number of targets
According to.
Wherein, target data refers to the business datum corresponding with target SQL instruction obtained from database.
Specifically, the source table of all business datums is stored in database, source table refers to the table of a load tracking, weight
It needs to check or use its business datum when broadcasting tracking, stores at least one source table in database.The source of storage in the database
The data of table can be XLS file, may be TEX file when source table data volume is very big.Business datum in each source table
It may include customer information, policy information and product information；Customer information can specifically include in name, contact method and age etc.
Hold；Information of insuring can specifically include the contents such as insurance kind title and protection amount；Product information can specifically include name of product and reason
The contents such as the amount of money are paid for, by loading the business datum that tracks and can get in the table of source.Server can be referred to by performance objective SQL
It enables, inquires source corresponding with target source table in database, obtain corresponding target data from the corresponding source table in target source.
As shown in Table 1, get target SQL corresponding with business datum demand instruction, by target SQL instruction to target source
Corresponding B table is inquired, and client, average insured amount and amount for which loss settled target that purchase insurance kind is A insurance kind are got from B table
Data.
In step S10-S50, by creating at least one original splicing function, each original splicing function includes splicing class
Type is spliced so as to subsequent according to original splicing function.By obtaining business datum demand, business datum demand includes target
Type, target component, target source and goal condition, so as to subsequent corresponding to business datum demand according to target type, target
Parameter, target source and goal condition carry out splicing.Database is inquired according to target type, is target class by splicing type
The corresponding original splicing function of type is determined as target splicing function, can pass through the corresponding splicing letter of target type quick obtaining
Number, acquisition process are simple and quick.Stitching portion is carried out to target component, target source and goal condition using target splicing function
Reason generates target SQL instruction, is not required to manually carry out the transcription of SQL instruction, save labour turnover, and improve transcription productivity.According to
Target SQL instruction, handles source corresponding with target source table in database, obtains target data, obtains target data
Process is simple and quick, improves data-handling efficiency.
In one embodiment, as shown in figure 3, in step S20, that is, business datum demand is obtained, is specifically included included below:
S21: initial data demand schedule is obtained, initial data demand schedule includes at least one initial data demand.
Wherein, initial data demand schedule is the tables of data for storing initial data demand.Initial data demand is user
The demand of the business datum of required acquisition.
Specifically, client is connect with server network, and server can carry out batch processing to initial data demand.Service
Device obtains the initial data demand schedule that client is sent, wherein includes that at least one initial data needs in initial data demand schedule
It asks, initial data demand schedule can be standardized tables of data, be also possible to the homemade demand schedule of client.
S22: judge whether initial data demand schedule is standard requirement tables of data.
Specifically, server obtains the gauge outfit field of initial data demand schedule, by the gauge outfit field of initial data demand schedule
It is matched with the gauge outfit field of standard requirement tables of data, when the gauge outfit field and standard requirement tables of data of initial data demand schedule
Gauge outfit fields match success, then initial data demand schedule be standard requirement tables of data.If working as the gauge outfit of initial data demand schedule
The gauge outfit fields match of field and standard requirement tables of data is unsuccessful, then initial data demand schedule is not standard requirement tables of data,
Then initial data demand schedule is adjusted accordingly according to standard requirement tables of data.
S23: if initial data demand schedule is standard requirement tables of data, judge each word in each initial data demand
Whether matching word segment value is corresponding fills in specification for segment value.
Specifically, when server judges that initial data demand schedule is standard requirement tables of data, i.e. initial data demand
When the gauge outfit field of table and the successful gauge outfit fields match of standard requirement tables of data, filling out for the field value of each gauge outfit field is determined
It writes and whether meets that the field value is corresponding to fill in specification.Filling in specification is the form rule preset for limiting a certain field value
Model.For example, in initial data demand schedule in " target component " this corresponding field value of gauge outfit field and standard requirement tables of data
Pre-set " target component " corresponding field value fill in specification whether successful match, such as limited in standard requirement tables of data
The specification of filling in of the corresponding field value of the parameter that sets the goal is " using comma as separator between multiple parameters "；If initial data needs
When to seek in table the corresponding field value of target component include more than two field values, then symbol when being separated between two field values with comma
Close its it is corresponding fill in specification, conversely, not meeting its when if not separated with comma between two field values corresponding fills in rule
Model.In addition, filling in specification may include gauge outfit field formal Specification whether corresponding with the field value of gauge outfit field, such as table one
It is shown, field value select cannot be matched in the field value of target component, target source and goal condition.
S24: if the equal matching word segment value of each field value is corresponding to fill in specification, initial data demand needs for business datum
It asks.
Specifically, when each field value of initial data demand meets, the field value is corresponding to fill in specification, then original
Initial data demand in data requirements table is business datum demand；If either field value is not met, field value is corresponding to fill in rule
Model then needs correspondingly to be adjusted, i.e., server can send corresponding prompt information to client, so that user is according to client
The prompt information of end display is adjusted.
In step S21-S24, by obtaining initial data demand schedule, initial data demand schedule includes at least one original number
According to demand, so that the subsequent initial data demand Batch conversion in initial data demand schedule is SQL instruction.Judge initial data
Whether demand schedule is standard requirement tables of data, when initial data demand is not standard requirement tables of data, needs accordingly to be adjusted
It is whole；If initial data demand schedule is standard requirement tables of data, judge whether is each field value in each initial data demand
Matching word segment value is corresponding to fill in specification, to guarantee that subsequent conversion is instructed at correct SQL.If each equal matching field of field value
Be worth it is corresponding fill in specification, then initial data demand be business datum demand, so as to subsequent to every in initial data demand schedule
One initial data demand carries out splicing, and implementation method is rapidly and efficiently.
In one embodiment, as shown in figure 4, acquisition business datum demand in step S20, business datum demand includes mesh
Mark type, target component, target source and goal condition, specifically comprise the following steps include:
S211: obtaining initial data demand, is needed using going deactivated word algorithm to extract at least one of initial data demand
Seek keyword.
Wherein, initial data demand is the demand of the business datum obtained needed for user.Demand keyword refers to from original
The keyword extracted in data requirements.
Specifically, server obtains the initial data demand that client is sent, and original using going deactivated word algorithm to extract
The keyword extracted is determined as demand corresponding with initial data demand and closed by least one keyword in data requirements
Keyword.It is to be appreciated that the initial data demand can be the one or more demands determined from initial data demand schedule.Often
Extractable at least one keyword out of one initial data demand.
In the present embodiment, server, which pre-establishes, deactivates dictionary.Wherein, deactivated dictionary is gone to refer to that storage needs to filter out
Certain words or word database.Specifically, server is after obtaining initial data demand, and calling goes to deactivate dictionary, and acquisition is gone
The stop words in dictionary is deactivated, stop words is carried out to initial data demand using the stop words for going to deactivate in dictionary and is handled, is obtained
It takes and removes stop words in initial data demand treated at least one keyword.Wherein, stop words is not related to physical meaning content,
It may include single text, punctuation mark and cypher.It goes to deactivate the stop words in dictionary it is to be understood that calling, will deactivate
Word is matched with initial data demand, and the stop words that initial data demand is matched to carries out rejecting processing, obtains original number
According to remove stop words in demand treated keyword as demand keyword.For example, " purchase insurance kind is B insurance kind in statistics A table
Client, average insured amount and amount for which loss settled " can get demand keyword by going stop words to handle as " statistics ", " A table ", " insurance kind
For B insurance kind ", " client ", " average protection amount " and " amount for which loss settled ".
S212: each demand keyword is matched with the gauge outfit field of standard requirement tables of data, the gauge outfit
Field includes type field, parameter field, source field and condition field.
Wherein, standard requirement tables of data is the pre-set tables of data for meeting SQL conversion requirements.As shown in Table 1, it marks
Gauge outfit field in quasi need tables of data includes type field, parameter field, source field and condition field.
Specifically, server obtains the demand keyword of each initial data demand, by demand keyword and standard requirement
Gauge outfit field in tables of data is matched, i.e., by the type field in demand keyword and standard requirement tables of data, parameter word
Section, source field and condition field are matched, and determine the gauge outfit field of the demand keyword of each initial data demand.
S213: the demand keyword with type field successful match is determined as target type, will be matched with parameter field
Successful demand keyword is determined as target component, the demand keyword with source field successful match is determined as to target
Source, and the demand keyword with condition field successful match is determined as goal condition.
Wherein, it is preset in type field, parameter field, source field and condition field in standard requirement tables of data corresponding
Field value, may include select, delete, updata and insert, parameter field in the corresponding drop down button of type field
Drop down button in may include each source table in data field, may include each in database in the drop down button of source field
The table name of source table, may include in the drop down button of condition field an equal condition (equal), a blurred equality condition (like),
One range of condition (between), a greater than condition (greater), a less-than condition (smaller), one are more than or equal to condition
(greater or equal), one are less than or equal to condition (smaller or equal) etc..
For example, the demand keyword of a certain initial data demand is that " purchase insurance kind is the client of B insurance kind, puts down in statistics A table
Insured amount and amount for which loss settled ", by go stop words can get demand keyword be " statistics ", " A table ", " insurance kind is B insurance kind ",
" client ", " average protection amount " and " amount for which loss settled ".By by demand keyword and type field, parameter field, source field and
Condition field is matched, if " A table " and source field successful match, " client ", " average protection amount " and " amount for which loss settled " and ginseng
Digital section successful match, " insurance kind is B insurance kind " i.e. " insurance kind=B insurance kind " and condition successful match, then be determined as mesh for " statistics "
Type is marked, " client ", " average protection amount " and " amount for which loss settled " is determined into target component, " A table " is determined as target source, it will
" insurance kind is B insurance kind " is determined as goal condition.
In step S211-S213, by obtain initial data demand, using go deactivate word algorithm extract initial data demand
In at least one demand keyword, to determine aiming field subsequently through demand keyword.By each demand keyword with
The gauge outfit field of standard requirement tables of data is matched, and the demand keyword of successful match is identified as target type, mesh
Parameter, target source or goal condition are marked, extraction process is simple and convenient, and is conducive to improve user experience.
In one embodiment, each original splicing function further includes at least one formal parameter.
Wherein, formal parameter is not physical presence variable, so also known as dummy variable, is the use when function is spliced in definition
Parameter the parameter being passed to when calling the splicing function is received, by parameter assignment to formal parameter for when calling function.
Specifically, server creates corresponding original splicing function, each original splicing letter according to the difference of splicing type
Include at least one formal parameter in number, formal parameter can be spliced according to splicing type by original splicing function.
In step s 40, i.e., target component, target source and goal condition are spliced using target splicing function
Processing generates in target SQL instruction, comprising: target component, target source and goal condition are assigned to target splicing letter respectively
Formal parameter in number generates target SQL instruction.
Specifically, server obtains corresponding target splicing function according to target type, and will be corresponding with target type
Target component, target source and goal condition be assigned to formal parameter in target splicing function respectively, and spliced according to target
Function splices target component, target source and goal condition.As shown in Table 1, it is got by target type select
Target corresponding with select splices function, is " client, average protection amount, Claims Resolution gold by target component corresponding with select
Volume ", target source is " A table " and goal condition is the formal parameter that " insurance kind=B insurance kind " is assigned to respectively in target splicing function
In, and splicing function according to target is " client, average protection amount, amount for which loss settled " to target component, target source is " A table " and mesh
Mark condition is that " insurance kind=B insurance kind " is spliced, target SQL instruction.SQL instruction is a kind of data base querying and program design language
Speech, for accessing data and querying, updating, and managing relational database system.In the present embodiment, function is spliced according to target
Splicing is carried out to target component, target source and goal condition, generates target SQL instruction, joining method is simple, is not required to people
Work is spliced, and is discharged labour, is improved efficiency.
In one embodiment, after the step s 40, i.e., after the step of generating target SQL instruction, business data processing
Method further include: business datum demand and target SQL instruction are corresponded, and stored to splicing instruction catalogue.
Specifically, each business datum demand is spliced function by corresponding target to splice, and obtains each industry
Data requirements of being engaged in corresponding target SQL instruction, and each business datum demand and target SQL instruction are corresponded, store to
In the splicing instruction catalogue of database, source in database is directly searched by the target SQL instruction in splicing instruction catalogue so as to subsequent
The data of table are not required to again splice business datum demand, save the time.
In one embodiment, splicing instruction catalogue is stored in database, it is original to be stored at least one in splicing instruction catalogue
SQL instruction.Wherein, original SQL instruction, which refers to, presets and stores, for carrying out splicing correspondence to business datum demand
Instruction.Initial data demand and original SQL instruction corresponding with initial data demand are stored in splicing instruction catalogue.
As shown in figure 5, after obtaining business datum demand step, business data processing method further include:
S61: using business datum demand inquiry splicing instruction catalogue.
Specifically, server searches the splicing instruction catalogue for being stored in database by business datum demand, splices instruction catalogue
In be stored with the corresponding original SQL instruction of the business datum demand spliced.Server is looked by business datum demand
Look for splicing instruction catalogue, avoid it is subsequent to identical business datum demand carry out splicing, save the time.
S62: if the target SQL instruction to match with business datum demand is stored in splicing instruction catalogue, according to target
SQL instruction, handles source corresponding with target source table in database, obtains target data.
Specifically, by by business datum demand with splicing instruction catalogue match, specifically with splicing instruction catalogue Central Plains
Beginning data requirements matches, then will be former when a certain initial data demand successful match in business datum demand and splicing instruction catalogue
The corresponding original SQL instruction of beginning data requirements passes through target SQL as the corresponding target SQL instruction of the business datum demand
Instruction handles source table in database, gets target data.
Wherein, by when original data requirements matches in business datum demand and splicing instruction catalogue, editing distance can be passed through
Business datum demand and initial data demand are carried out similarity calculation by algorithm, and obtain business datum demand and each original number
The initial data is then determined when the similarity of a certain initial data demand is higher than preset threshold according to the corresponding similarity of demand
Demand and business datum demand successful match.Editing distance refers to a character string, every time can only be by being inserted into a character, deleting
Except a character or the method for modifying a character, become the minimal action number of another character string.For example, using compiling
Collect the similarity that distance algorithm calculates business datum demand and initial data demand.Firstly, establishing matrix, completed often for saving
A character string converts the number of operations needed to be implemented, determine business datum demand and initial data demand length be respectively m and
N, and initialize the first behavior 0 and arrive m, first is classified as 0 to n, and the matrix d of foundation is (m+1) * (n+1).When str (m, st)==
Otherwise str (n, st), temp 0 are 1.Wherein, temp is the character string that computational length is m and the character string that length is n
Value, it can be understood as, when the character string that length is m is identical as the character string that length is n, then temp is 0, and character string is not identical then
It is 1.Loop nesting Ergodic Matrices d [m, n] gives d [i-1, j]+1, d [i, j-1]+1 and d to each value in matrix d [m, n]
The minimum value of [i-1, j-1]+temp three until matrix whole assignment is completed, and returns to matrix the last one value d [m] [n] i.e.
It is editing distance L, and passes through calculating formula of similarityWherein, MAX (m, n) is m's and n
Maximum length.
S63: if not being stored with the target SQL instruction to match with business datum demand in splicing instruction catalogue, root is executed
The step of inquiring database according to target type, obtaining target splicing function corresponding with target type.
Specifically, by by business datum demand with splicing instruction catalogue match, specifically with splicing instruction catalogue Central Plains
Beginning data requirements matches, when each non-successful match of initial data demand in business datum demand and splicing instruction catalogue, then
Database is inquired according to target type in business datum demand, target corresponding with target type is obtained and splices function.
In step S61-S63, splicing instruction catalogue is searched by business datum demand, is avoided subsequent to identical business datum
Demand carries out splicing, saves the time.If being stored with the target SQL to match with business datum demand in splicing instruction catalogue to refer to
It enables, is then instructed according to target SQL, source corresponding with target source table in database is handled, obtain target data, obtain
Process is simple and quick.If not being stored with the target SQL instruction to match with business datum demand in splicing instruction catalogue, root is executed
The step of inquiring database according to target type, obtaining target splicing function corresponding with target type, the i.e. step of step S20
Suddenly, function is spliced to business datum demand progress splicing according to target so as to subsequent, obtains target SQL instruction, and utilize
Target SQL instruction obtains target data.
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 service data processing apparatus is provided, the service data processing apparatus and above-described embodiment
Middle business data processing method corresponds.As shown in fig. 6, the service data processing apparatus includes original splicing function creation mould
Block 10, business datum demand obtain module 20, splicing function obtains module 30, SQL directive generation module 40 and data acquisition mould
Block 50.Detailed description are as follows for each functional module:
Original splicing function creation module 10, for creating at least one original splicing function, each original splicing function
Including splicing type.
Business datum demand obtains module 20, for obtaining business datum demand, business datum demand include target type,
Target component, target source and goal condition.
Splice function and obtain module 30, is target type phase by splicing type for inquiring database according to target type
Corresponding original splicing function is determined as target splicing function.
SQL directive generation module 40, for using target splicing function to target component, target source and goal condition into
Row splicing generates target SQL instruction.
Data acquisition module 50 carries out source corresponding with target source table in database for being instructed according to target SQL
Processing obtains target data.
In one embodiment, business datum demand obtains module 20 and sentences including the first initial data acquiring unit 21, first
Disconnected unit 22, second judgment unit 23 and the first data determination unit 24.
First initial data acquiring unit 21, for obtaining initial data demand schedule, initial data demand schedule includes at least
One initial data demand.
First judging unit 22, for judging whether initial data demand schedule is standard requirement tables of data.
Second judgment unit 23 judges each original number if being standard requirement tables of data for initial data demand schedule
According to each field value in demand, whether matching word segment value is corresponding fills in specification.
First data determination unit 24 is original if filling in specification for the equal matching word segment value of each field value to be corresponding
Data requirements is business datum demand.
In one embodiment, it includes the second initial data acquiring unit 211, at matching that business datum demand, which obtains module 20,
Manage unit 212 and the second data determination unit 213.
Second initial data acquiring unit 211 is original using going deactivated word algorithm to extract for obtaining initial data demand
At least one demand keyword in data requirements.
Matching treatment unit 212, for by the gauge outfit field of each demand keyword and standard requirement tables of data into
Row matching, the gauge outfit field includes type field, parameter field, source field and condition field.
Second data determination unit 213, for will with the type field, the parameter field, the source field and
The demand keyword of the condition field successful match is identified as target type, target component, target source or target item
Part.
In one embodiment, each original splicing function further includes at least one formal parameter.Splice function and obtains module
30 are also used to inquire database according to target type, are that the corresponding original splicing function of target type is determined as by splicing type
Target splices function.
SQL directive generation module 40 is also used to for target component, target source and goal condition being assigned to target spelling respectively
Formal parameter in function is connect, target SQL instruction is generated.
In one embodiment, service data processing apparatus further includes requirement command storage unit 401, for generating target
After the step of SQL is instructed, business datum demand and target SQL instruction are corresponded, and stored to splicing instruction catalogue.
In one embodiment, splicing instruction catalogue is stored in database, it is original to be stored at least one in splicing instruction catalogue
SQL instruction.
Service data processing apparatus further includes query unit 61, first processing units 62 and the second processing unit 63.
Query unit 61, for using business datum demand inquiry splicing instruction catalogue.
First processing units 62, if for splicing the target SQL for being stored in instruction catalogue and matching with business datum demand
Instruction is then instructed according to target SQL, is handled source corresponding with target source table in database, obtains target data.
The second processing unit 63, if for splicing the target for not being stored in instruction catalogue and matching with business datum demand
SQL instruction, then execute and inquire database according to target type, obtains the step of target splicing function corresponding with target type
Suddenly.
Specific about service data processing apparatus limits the limit that may refer to above for business data processing method
Fixed, details are not described herein.Modules in above-mentioned service data processing apparatus 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 structure
Figure can be as shown in Figure 7.The computer equipment includes processor, the memory, network interface sum number connected by system bus
According to library.Wherein, the processor of the computer equipment is for providing calculating and control ability.The memory of the computer equipment includes
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 storage service data requirements, source table data, splicing instruction catalogue and target data etc..The computer is set
Standby network interface is used to communicate with external terminal by network connection.To realize when the computer program is executed by processor
A kind of business data processing method.
In one embodiment, a kind of computer equipment is provided, including memory, processor and storage are on a memory simultaneously
The computer program that can be run on a processor, processor performs the steps of when executing computer program creates at least one
Original splicing function, each original splicing function include splicing type；Obtain business datum demand, business datum demand packet
Include target type, target component, target source and goal condition；Database is inquired according to target type, is institute by splicing type
It states the corresponding original splicing function of target type and is determined as target splicing function；Using target splicing function to target component,
Target source and goal condition carry out splicing, generate target SQL instruction；According to target SQL instruct, in database with mesh
The corresponding source table in mark source is handled, and target data is obtained.
In one embodiment, it is performed the steps of when processor executes computer program and obtains initial data demand schedule, it is former
Beginning data requirements table includes at least one initial data demand；Judge whether initial data demand schedule is standard requirement tables of data；
If initial data demand schedule is standard requirement tables of data, judge whether each field value in each initial data demand meets
Field value is corresponding to fill in specification；If each equal matching word segment value of field value is corresponding to fill in specification, initial data demand is
Business datum demand.
In one embodiment, it is performed the steps of when processor executes computer program and obtains initial data demand, used
It goes to deactivate at least one demand keyword in word algorithm extraction initial data demand；By each demand keyword and standard
The gauge outfit field of demand data table is matched, and the gauge outfit field includes type field, parameter field, source field and condition
Field；It will be determined as target type with the demand keyword of the type field successful match, will be matched with the parameter field
Successful demand keyword is determined as target component, will be determined as target with the demand keyword of the source field successful match
Source, and goal condition will be determined as with the demand keyword of the condition field successful match.
In one embodiment, each original splicing function further includes at least one formal parameter.
Processor is also performed the steps of when executing computer program by target component, target source and goal condition point
It is not assigned to formal parameter in target splicing function, generates target SQL instruction.
In one embodiment, it also performs the steps of when processor executes computer program by business datum demand and mesh
It marks SQL instruction to correspond, and stores to splicing instruction catalogue.
In one embodiment, splicing instruction catalogue is stored in database, it is original to be stored at least one in splicing instruction catalogue
SQL instruction.
After obtaining business datum demand step, processor also performs the steps of use when executing computer program
Business datum demand inquiry splicing instruction catalogue；If being stored with the target SQL to match with business datum demand in splicing instruction catalogue
Instruction is then instructed according to target SQL, is handled source corresponding with target source table in database, obtains target data；If
The target SQL instruction to match with business datum demand is not stored in splicing instruction catalogue, then executes and is inquired according to target type
Database obtains the step of target corresponding with target type splices function.
In one embodiment, a kind of computer readable storage medium is provided, computer program, computer are stored thereon with
It is performed the steps of when program is executed by processor and creates at least one original splicing function, each original splicing function
Including splicing type；Business datum demand is obtained, business datum demand includes target type, target component, target source and mesh
Mark condition；Database is inquired according to target type, is that the corresponding original splicing function of the target type is true by splicing type
It is set to target splicing function；Splicing is carried out to target component, target source and goal condition using target splicing function, it is raw
It is instructed at target SQL；It is instructed according to target SQL, source corresponding with target source table in database is handled, obtain target
Data.
In one embodiment, it is also performed the steps of when computer program is executed by processor and obtains initial data demand
Table, initial data demand schedule include at least one initial data demand；Judge whether initial data demand schedule is standard requirement number
According to table；If initial data demand schedule is standard requirement tables of data, judge that each field value in each initial data demand is
No matching word segment value is corresponding to fill in specification；If each equal matching word segment value of field value is corresponding to fill in specification, initial data
Demand is business datum demand.
In one embodiment, it is also performed the steps of when computer program is executed by processor and obtains initial data demand,
Using at least one the demand keyword gone in deactivated word algorithm extraction initial data demand；By each demand keyword with
The gauge outfit field of standard requirement tables of data is matched, the gauge outfit field include type field, parameter field, source field and
Condition field；To be determined as target type with the demand keyword of the type field successful match, will be with the parameter field
The demand keyword of successful match is determined as target component, will be determined as with the demand keyword of the source field successful match
Target source, and goal condition will be determined as with the demand keyword of the condition field successful match.
In one embodiment, each original splicing function further includes at least one formal parameter.
It is also performed the steps of when computer program is executed by processor by target component, target source and goal condition
It is assigned to formal parameter in target splicing function respectively, generates target SQL instruction.
In one embodiment, also performed the steps of when computer program is executed by processor by business datum demand with
Target SQL instruction corresponds, and stores to splicing instruction catalogue.
In one embodiment, splicing instruction catalogue is stored in database, it is original to be stored at least one in splicing instruction catalogue
SQL instruction.
After the step of obtaining business datum demand, also performed the steps of when computer program is executed by processor
Splicing instruction catalogue is inquired using business datum demand；If being stored with the target to match with business datum demand in splicing instruction catalogue
SQL instruction, then instruct according to target SQL, handle source corresponding with target source table in database, obtains number of targets
According to；If not being stored with the target SQL instruction to match with business datum demand in splicing instruction catalogue, execute according to target type
The step of inquiring database, obtaining target splicing function corresponding with target type.
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 data processing method characterized by comprising
At least one original splicing function is created, each original splicing function includes splicing type；
Obtain business datum demand, the business datum demand includes that target type, target component, target carry out source and target item
Part；
Database is inquired according to the target type, is that the corresponding original splicing function of the target type is true by splicing type
It is set to target splicing function；
Stitching portion is carried out to the target component, the target source and the goal condition using target splicing function
Reason generates target SQL instruction；
It is instructed according to the target SQL, source table corresponding with the target source in database is handled, obtain number of targets
According to.
2. business data processing method as described in claim 1, which is characterized in that the acquisition business datum demand, comprising:
Initial data demand schedule is obtained, the initial data demand schedule includes at least one initial data demand；
Judge whether the initial data demand schedule is standard requirement tables of data；
If the initial data demand schedule is standard requirement tables of data, each word in each initial data demand is judged
Whether segment value meets that the field value is corresponding to fill in specification；
If each field value meets, the field value is corresponding to fill in specification, and the initial data demand needs for business datum
It asks.
3. business data processing method as claimed in claim 2, which is characterized in that the acquisition business datum demand, it is described
Business datum demand includes target type, target component, target source and goal condition, comprising:
Initial data demand is obtained, it is crucial using going deactivated word algorithm to extract at least one demand in the initial data demand
Word；
Each demand keyword is matched with the gauge outfit field of standard requirement tables of data, the gauge outfit field includes class
Type-word section, parameter field, source field and condition field；
It will be determined as target type with the demand keyword of the type field successful match, will be matched into the parameter field
The demand keyword of function is determined as target component, will be determined as target with the demand keyword of the source field successful match
Source, and goal condition will be determined as with the demand keyword of the condition field successful match.
4. business data processing method as described in claim 1, which is characterized in that each original splicing function further includes
At least one formal parameter；
It is described that the target component, the target source and the goal condition are spliced using target splicing function
Processing generates target SQL instruction, comprising:
The target component, the target source and the goal condition are assigned to form in the target splicing function respectively
Parameter generates target SQL instruction.
5. business data processing method as described in claim 1, which is characterized in that in the step of the generation target SQL instruction
After rapid, the business data processing method further include:
The business datum demand and target SQL instruction are corresponded, and stored to splicing instruction catalogue.
6. business data processing method as claimed in claim 5, which is characterized in that be stored with splicing instruction in the database
Table is stored at least one original SQL instruction in the splicing instruction catalogue；
After the acquisition business datum demand step, the business data processing method further include:
Splicing instruction catalogue is inquired using the business datum demand；
If being stored with the target SQL to match with the business datum demand in the splicing instruction catalogue to instruct, according to
Target SQL instruction, handles source table corresponding with the target source in database, obtains target data；
If not being stored with the target SQL to match with the business datum demand in the splicing instruction catalogue to instruct, root is executed
The step of inquiring database according to the target type, obtaining target splicing function corresponding with the target type.
7. a kind of service data processing apparatus characterized by comprising
Original splicing function creation module, for creating at least one original splicing function, each original splicing function packet
Include splicing type；
Data acquisition module, for obtaining business datum demand, the business datum demand include target type, target component,
Target source and goal condition；
Splice function and obtain module, is the target type by splicing type for inquiring database according to the target type
Corresponding original splicing function is determined as target splicing function；
SQL directive generation module, for using target splicing function to the target component, the target source and described
Goal condition carries out splicing, generates target SQL instruction；
Data acquisition module, for according to the target SQL instruct, to source table corresponding with the target source in database into
Row processing, obtains target data.
8. service data processing apparatus as claimed in claim 7, which is characterized in that the data acquisition module, comprising:
First initial data acquiring unit, for obtaining initial data demand schedule, the initial data demand schedule includes at least one
A initial data demand；
First judging unit, for judging whether the initial data demand schedule is standard requirement tables of data；
Second judgment unit judges each described original if being standard requirement tables of data for the initial data demand schedule
Whether each field value in data requirements meets that the field value is corresponding to fill in specification；
First data determination unit, if meeting for each field value, the field value is corresponding to fill in specification, the original
Beginning data requirements is business datum demand.
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 6 business data processing 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 data processing method as described in any one of claim 1 to 6 when the computer program is executed by processor
Step.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810920892.5A CN109325041B (en) | 2018-08-14 | 2018-08-14 | Service data processing method, device, computer equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810920892.5A CN109325041B (en) | 2018-08-14 | 2018-08-14 | Service data processing method, device, computer equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109325041A true CN109325041A (en) | 2019-02-12 |
| CN109325041B CN109325041B (en) | 2023-11-21 |
Family
ID=65264119
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810920892.5A Active CN109325041B (en) | 2018-08-14 | 2018-08-14 | Service data processing method, device, computer equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109325041B (en) |
Cited By (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109947853A (en) * | 2019-03-25 | 2019-06-28 | 阿里巴巴集团控股有限公司 | A kind of business activity change cognitive method, system and server |
| CN110275703A (en) * | 2019-06-27 | 2019-09-24 | 浙江大搜车软件技术有限公司 | Assignment method, device, computer equipment and the storage medium of key-value pair data |
| CN110347732A (en) * | 2019-05-20 | 2019-10-18 | 中国平安人寿保险股份有限公司 | A kind of data transfer device and device |
| CN110427399A (en) * | 2019-06-18 | 2019-11-08 | 深圳壹账通智能科技有限公司 | Real-time data acquisition method, system, device and storage medium |
| CN110502516A (en) * | 2019-08-22 | 2019-11-26 | 深圳前海环融联易信息科技服务有限公司 | List data analytic method, device, computer equipment and storage medium |
| CN110659281A (en) * | 2019-08-14 | 2020-01-07 | 中国平安财产保险股份有限公司 | Hive-based data processing method and device, computer equipment and storage medium |
| CN110765118A (en) * | 2019-10-21 | 2020-02-07 | 北京明略软件系统有限公司 | Data revision method, revision device and readable storage medium |
| CN110781184A (en) * | 2019-09-16 | 2020-02-11 | 平安科技（深圳）有限公司 | Data table construction method, device, equipment and storage medium |
| CN110826297A (en) * | 2019-11-05 | 2020-02-21 | 北京锐安科技有限公司 | Data export method, device, equipment and storage medium |
| CN110908892A (en) * | 2019-09-18 | 2020-03-24 | 泰康保险集团股份有限公司 | Interface data testing method and device and readable storage medium |
| CN111857876A (en) * | 2020-07-20 | 2020-10-30 | 北京字节跳动网络技术有限公司 | Service processing method and device, electronic equipment and computer readable medium |
| CN112882752A (en) * | 2021-01-26 | 2021-06-01 | 苏州达家迎信息技术有限公司 | Method and device for batch processing of microservices, computer equipment and storage medium |
| CN113271307A (en) * | 2021-05-18 | 2021-08-17 | 中国工商银行股份有限公司 | Data assembling method, device, computer system and storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103226478A (en) * | 2013-05-22 | 2013-07-31 | 北京金和软件股份有限公司 | Method for automatically generating and using code |
| CN106598612A (en) * | 2016-12-20 | 2017-04-26 | 北京润科通用技术有限公司 | Operation method and system for data table in database |
| CN106874335A (en) * | 2016-08-19 | 2017-06-20 | 阿里巴巴集团控股有限公司 | Behavioral data processing method, device and server |
| CN107679057A (en) * | 2017-06-26 | 2018-02-09 | 平安科技（深圳）有限公司 | Data docking calculation, device, server and storage medium |
-
2018
- 2018-08-14 CN CN201810920892.5A patent/CN109325041B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103226478A (en) * | 2013-05-22 | 2013-07-31 | 北京金和软件股份有限公司 | Method for automatically generating and using code |
| CN106874335A (en) * | 2016-08-19 | 2017-06-20 | 阿里巴巴集团控股有限公司 | Behavioral data processing method, device and server |
| CN106598612A (en) * | 2016-12-20 | 2017-04-26 | 北京润科通用技术有限公司 | Operation method and system for data table in database |
| CN107679057A (en) * | 2017-06-26 | 2018-02-09 | 平安科技（深圳）有限公司 | Data docking calculation, device, server and storage medium |
Cited By (19)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109947853A (en) * | 2019-03-25 | 2019-06-28 | 阿里巴巴集团控股有限公司 | A kind of business activity change cognitive method, system and server |
| CN110347732A (en) * | 2019-05-20 | 2019-10-18 | 中国平安人寿保险股份有限公司 | A kind of data transfer device and device |
| CN110427399A (en) * | 2019-06-18 | 2019-11-08 | 深圳壹账通智能科技有限公司 | Real-time data acquisition method, system, device and storage medium |
| CN110275703A (en) * | 2019-06-27 | 2019-09-24 | 浙江大搜车软件技术有限公司 | Assignment method, device, computer equipment and the storage medium of key-value pair data |
| CN110275703B (en) * | 2019-06-27 | 2023-06-06 | 浙江大搜车软件技术有限公司 | Method and device for assigning key value to data, computer equipment and storage medium |
| CN110659281A (en) * | 2019-08-14 | 2020-01-07 | 中国平安财产保险股份有限公司 | Hive-based data processing method and device, computer equipment and storage medium |
| CN110659281B (en) * | 2019-08-14 | 2023-09-12 | 中国平安财产保险股份有限公司 | Hive-based data processing method, hive-based data processing device, computer equipment and storage medium |
| CN110502516A (en) * | 2019-08-22 | 2019-11-26 | 深圳前海环融联易信息科技服务有限公司 | List data analytic method, device, computer equipment and storage medium |
| CN110502516B (en) * | 2019-08-22 | 2021-10-19 | 深圳前海环融联易信息科技服务有限公司 | Table data analysis method and device, computer equipment and storage medium |
| CN110781184B (en) * | 2019-09-16 | 2023-06-16 | 平安科技（深圳）有限公司 | Data table construction method, device, equipment and storage medium |
| CN110781184A (en) * | 2019-09-16 | 2020-02-11 | 平安科技（深圳）有限公司 | Data table construction method, device, equipment and storage medium |
| CN110908892A (en) * | 2019-09-18 | 2020-03-24 | 泰康保险集团股份有限公司 | Interface data testing method and device and readable storage medium |
| CN110765118A (en) * | 2019-10-21 | 2020-02-07 | 北京明略软件系统有限公司 | Data revision method, revision device and readable storage medium |
| CN110826297A (en) * | 2019-11-05 | 2020-02-21 | 北京锐安科技有限公司 | Data export method, device, equipment and storage medium |
| CN111857876A (en) * | 2020-07-20 | 2020-10-30 | 北京字节跳动网络技术有限公司 | Service processing method and device, electronic equipment and computer readable medium |
| CN112882752B (en) * | 2021-01-26 | 2022-10-28 | 苏州达家迎信息技术有限公司 | Method and device for processing micro services in batches, computer equipment and storage medium |
| CN112882752A (en) * | 2021-01-26 | 2021-06-01 | 苏州达家迎信息技术有限公司 | Method and device for batch processing of microservices, computer equipment and storage medium |
| CN113271307B (en) * | 2021-05-18 | 2023-05-16 | 中国工商银行股份有限公司 | Data assembling method, device, computer system and storage medium |
| CN113271307A (en) * | 2021-05-18 | 2021-08-17 | 中国工商银行股份有限公司 | Data assembling method, device, computer system and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109325041B (en) | 2023-11-21 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109325041A (en) | Business data processing method, device, computer equipment and storage medium | |
| CN109558440A (en) | Batch data processing method, device, computer equipment and storage medium | |
| CN109063217B (en) | Work order classification method and device in electric power marketing system and related equipment thereof | |
| CN110659298B (en) | Financial data processing method and device, computer equipment and storage medium | |
| CN110609954A (en) | Data acquisition method and device, computer equipment and storage medium | |
| JP2010514035A (en) | System and method for optimizing data set changes | |
| CN107918621A (en) | Daily record data processing method, device and operation system | |
| CN109885828A (en) | Word error correction method, device, computer equipment and medium based on language model | |
| CN109215796A (en) | Searching method, device, computer equipment and storage medium | |
| CN111310440A (en) | Text error correction method, device and system | |
| CN109885823A (en) | A kind of distributed semantic recognition methods of financial industry and system and device | |
| CN109871527A (en) | A kind of method for recognizing semantics based on participle | |
| US20230123941A1 (en) | Multiscale Quantization for Fast Similarity Search | |
| CN109325042A (en) | Handle template acquisition methods, form processing method, device, equipment and medium | |
| US11782888B2 (en) | Dynamic multi-platform model generation and deployment system | |
| CN115619448A (en) | User loss prediction method and device, computer equipment and storage medium | |
| US8862609B2 (en) | Expanding high level queries | |
| CN114327374A (en) | Business process generation method and device and computer equipment | |
| CN110362798A (en) | Ruling information retrieval analysis method, device, computer equipment and storage medium | |
| CN110377618A (en) | Ruling interpretation of result method, apparatus, computer equipment and storage medium | |
| CN110059967B (en) | Data processing method and device applied to city aid decision analysis | |
| CN110955712A (en) | Development API processing method and device based on multiple data sources | |
| CN109871526A (en) | The method for recognizing semantics and system and device of one B shareB industry | |
| CN109410069A (en) | Settlement data processing method, device, computer equipment and storage medium | |
| CN109783508B (en) | Data query method and device, computer equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |