CN109542890A - Data modification method, device, computer equipment and storage medium - Google Patents

Data modification method, device, computer equipment and storage medium Download PDF

Info

Publication number
CN109542890A
CN109542890A CN201811184393.0A CN201811184393A CN109542890A CN 109542890 A CN109542890 A CN 109542890A CN 201811184393 A CN201811184393 A CN 201811184393A CN 109542890 A CN109542890 A CN 109542890A
Authority
CN
China
Prior art keywords
data
product
vernier
index
original
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
CN201811184393.0A
Other languages
Chinese (zh)
Other versions
CN109542890B (en
Inventor
查月阅
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Ping An Technology Shenzhen Co Ltd
Original Assignee
Ping An Technology Shenzhen Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Ping An Technology Shenzhen Co Ltd filed Critical Ping An Technology Shenzhen Co Ltd
Priority to CN201811184393.0A priority Critical patent/CN109542890B/en
Publication of CN109542890A publication Critical patent/CN109542890A/en
Application granted granted Critical
Publication of CN109542890B publication Critical patent/CN109542890B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q40/00Finance; Insurance; Tax strategies; Processing of corporate or income taxes
    • G06Q40/08Insurance

Landscapes

  • Business, Economics & Management (AREA)
  • Accounting & Taxation (AREA)
  • Finance (AREA)
  • Engineering & Computer Science (AREA)
  • Development Economics (AREA)
  • Economics (AREA)
  • Marketing (AREA)
  • Strategic Management (AREA)
  • Technology Law (AREA)
  • Physics & Mathematics (AREA)
  • General Business, Economics & Management (AREA)
  • General Physics & Mathematics (AREA)
  • Theoretical Computer Science (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention discloses a kind of data modification method, device, terminal device and storage mediums, which comprises obtains product data sheet, wherein product data sheet includes product original cost data and product information field;Original vernier is generated according to product original cost data and product information field, original vernier includes vernier index;Traversing operation is executed to original vernier using vernier index, obtains cursor data;Product price logic checking is carried out to product data sheet using cursor data, if obtaining product data sheet verification result verification result is to be proved to be successful, then enter to join vernier using original vernier as product data sheet, generate target script, and performance objective script modifies to product original cost data, obtains product objective price.The data modification method improves the efficiency of data modification by carrying out data modification after product data sheet is generated vernier.

Description

Data modification method, device, computer equipment and storage medium
Technical field
The present invention relates to field of computer technology more particularly to a kind of data modification method, device, computer equipment and deposit Storage media.
Background technique
With the rapid development of social economy, the scope of business that many products are related to is more and more wider, the product of these business The processing of data also becomes to become increasingly complex, and by taking insurance industry as an example, the constantly expansion of current insurance institution's system is perfect, involved And insurance processing business it is more frequent.Protection amount modification (referring to the protection amount modification in insurance document) is numerous insurance processing industry Very important one in business.Often due to the reason of various aspects, need to modify to the insured amount data in declaration form.
In conventional method, when user needs to modify to this insured amount product data, need by special work people Member removes artificial screening declaration form, is searched from each declaration form corresponding with settlement of insurance claim case of input system, artificial one One audit, then developer modifies according to this insured amount product data that business personnel provides.But it is this artificial careful The mode of core declaration form needs to occupy a large amount of human resources, can waste when being audited one by one to these product data more Time, and error rate is higher, there are higher risks.
Summary of the invention
The embodiment of the present invention provides a kind of data modification method, device, computer equipment and storage medium, to solve data Modify the lower problem of efficiency.
A kind of data modification method, comprising:
Obtain product data sheet, wherein the product data sheet includes product original cost data and product information field;
Original vernier is generated according to the product original cost data and the product information field, the original vernier includes trip Mark index;
Traversing operation is executed to the original vernier using vernier index, obtains cursor data;
Product price logic checking is carried out to the product data sheet using the cursor data, obtains the product data The verification result of table;
If the verification result is to be proved to be successful, swum the original vernier as the ginseng that enters of the product data sheet Mark generates target script, and executes the target script and modify to the product original cost data, obtains product objective valence Lattice.
A kind of data modifying apparatus, comprising:
Original vernier obtains module, for generating original trip according to the product original cost data and the product information field Mark, the original vernier include vernier index;
Cursor data obtains module, for executing traversing operation to the original vernier using vernier index, obtains Cursor data;
Product price logic checking module, for carrying out product price to the product data sheet using the cursor data Logic checking obtains the verification result of the product data sheet;
Product objective price obtains module, if being to be proved to be successful for the verification result, the original vernier is made Enter to join vernier for the product data sheet, generates target script, and execute the target script to the product original cost data It modifies, obtains product objective price.
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 the step of above-mentioned data modification method when executing the computer program Suddenly.
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 data modification method when being executed by processor.
In above-mentioned data modification method, device, computer equipment and storage medium, product data sheet is obtained first, so as to More easily product data sheet is further operated.Then by the way that product original cost data and product information field are raw Data set is extracted at vernier, and then by vernier index, so that the operation of data modification is carried out, so as to more flexible and conveniently It finds and needs the product original cost data modified, while the operation of data modification that user is done is reflected in vernier.Then Traversing operation is executed to original vernier using vernier index, cursor data is obtained, so as to subsequently through to cursor data Reason accelerates data processing process.Product price logic checking is carried out to product data sheet followed by using cursor data, is obtained pair The verification result of product data sheet.If last verification result is to be proved to be successful, using original vernier entering as product data sheet Join vernier, generates target script, and performance objective script modifies to product original cost data, obtains product objective price, mentions The high efficiency of data modification.
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 the application environment schematic diagram of data modification method provided in an embodiment of the present invention;
Fig. 2 is one exemplary diagram of data modification method provided in an embodiment of the present invention;
Fig. 3 is another exemplary diagram of data modification method provided in an embodiment of the present invention;
Fig. 4 is another exemplary diagram of data modification method provided in an embodiment of the present invention;
Fig. 5 is another exemplary diagram of data modification method provided in an embodiment of the present invention;
Fig. 6 is another exemplary diagram of data modification method provided in an embodiment of the present invention
Fig. 7 is a schematic diagram of data modifying apparatus provided in an embodiment of the present invention;
Fig. 8 is a schematic diagram of computer equipment provided in an embodiment of the present 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.
Data modification method provided by the present application can be applicable in the application environment such as Fig. 1, wherein client passes through net Network is communicated with server-side, and server-side receives the product data sheet that client is sent, and according to the production in the product data sheet Product original cost data and product information field generate original vernier, then carry out traversal queries operation to original vernier, obtain vernier Data, and then cursor data is verified, after being verified, modifies, produced to the product original cost data in product data sheet Product target price.Wherein, client can be, but not limited to be various personal computers, laptop, smart phone, plate electricity Brain and portable wearable device.Server-side can use the server cluster of the either multiple server compositions of independent server To realize.
In one embodiment, as shown in Fig. 2, being applied to be illustrated for the server-side in Fig. 1 in this way, including Following steps:
S10: product data sheet is obtained, wherein product data sheet includes product original cost data and product information field.
Wherein, product data sheet refers to that the tables of data of data composition relevant to product, product data sheet include product original Valence mumber evidence and product information field.It is to be appreciated that the product data sheet in the present embodiment belongs to the tables of data of database scope. Product original cost data, which refer to, needs to modify data in product data sheet, normally, which is in product data sheet Data relevant with the amount of money.Product information field refers to the data item in product data sheet, for identifying the attribute data of product, Such as: product number, O/No. or product type etc..
Illustratively, which is a declaration form tables of data, and the product original cost data in the declaration form tables of data can be with It is the protection amount of a certain insurance kind (such as vehicle insurance), product information field can be " number of policy " field or " insurance kind number " field etc..It produces Product tables of data is used to the information of management statistics product.Facilitate developer etc. that product data are inquired or counted etc. with behaviour Make.Specifically, the acquisition modes of product data sheet can be the method that operation SQL statement carries out data query, be also possible to outer Portion's introduction method, i.e., the method for the page documents element after parsing being imported into tables of data, the method that can also be manual creation. Preferably, product data sheet is obtained using the method that is externally introduced in the present embodiment.
In the present embodiment, product data sheet is obtained, product data sheet is stored in temporary storage, and by the product number It is stored in a manner of list according to the product original cost data and product information field of table.Product data sheet is carried out so as to subsequent Further operation.
S20: original vernier is generated according to product original cost data and product information field, original vernier includes vernier index.
Wherein, vernier (cursor) is a data acquisition system in database, provides the data retrieved from table and carries out The flexible means of operation.Vernier is (to can be zero, one or a plurality of note retrieved by relevant case statement by result set Record) and result set in be directed toward specific record vernier index form.Specifically, original vernier refers to that product original cost data are corresponding Result set and the corresponding result set of product information field are directed toward the combination of the vernier index of product original cost data.
Wherein, vernier index (index) is directed to be stored in the data value of the appointed product information field of product data sheet Pointer, index corresponding vernier content and the corresponding product original cost of the vernier content for finding vernier according to vernier index Data.So that the SQL statement for corresponding to product data sheet executes ground faster, to quickly access the specific letter in product data sheet It ceases (such as product original cost data).
In the present embodiment, by the way that product original cost data and product information field are generated original vernier, and then pass through vernier Index is to extract data set, so that the operation of data modification is carried out, so that the management service personnel of product information system are cleverer It is living easily to find the product original cost data for needing to modify, while the operation of data modification done of user is also in original vernier Reflected.
It should be noted that when there is the corresponding original vernier of multiple product information fields, it can be by SQL statement Union function splices the corresponding original vernier of multiple product information fields, and example is as follows:
Wherein, parameter c_params is the title of original vernier, and parameter dual is the title of product data sheet, parameter p_ PolicyNo is expressed as product information field, and parameter p_old_amount is expressed as product original cost data.It is to be appreciated that passing through Union function is spliced, and the treatment progress of product data sheet can be influenced to avoid the dispersion of original vernier.
S30: traversing operation is executed to original vernier using vernier index, obtains cursor data.
Wherein, traversal (Traversal) refers to the access to information all in original vernier, i.e., sequentially to product data sheet In each product original cost data access it is primary.Traversal mode includes but is not limited to: preamble traversal, inorder traversal and postorder traversal Deng.Preferably, traversal mode used in the present embodiment is preamble traversal.
Wherein, cursor data refers to that indexing corresponding data to vernier carries out the data obtained after inquiry screening, for same When multiple product original cost data are handled, accelerate the process of data modification.
It is worth noting that vernier, which indexes corresponding data, to be set according to actual needs, do not limit specifically herein System.For example, vernier, which indexes corresponding data, can be product variety (such as vehicle insurance), it is also possible to product original cost data (as protected Volume).
In the present embodiment, traversing operation is executed to original vernier using vernier index, obtains cursor data, so as to subsequent logical It crosses and cursor data is handled, accelerate data processing process.
S40: product price logic checking is carried out to product data sheet using cursor data, obtains the verifying of product data sheet As a result.
Wherein, product price logic refers to the logic of the quantitative relation between cursor data, for carrying out to cursor data Verifying.In a specific embodiment, product price logic refers to the summation and product information field of product original cost data Sum meets equation: " summation of product original cost data=product original cost data * product information field sum " this condition Logic.Verification result refer to using cursor data to product data sheet carry out product price logic checking after obtain as a result, packet It includes and is proved to be successful and two kinds of verification results of authentication failed.I.e. when equation set up when, verification result be verified, when equation not at Immediately, verification result is authentication failed.
It should be noted that in the present embodiment, in the case where verification result is authentication failed, can by client into Row secondary-confirmation, then returns to verification result.The product original cost data feedback of product price logic will not met to client, and It is uploaded to server-side again after handling the product original cost data.
It is to be appreciated that the verification operation in this step, is the logic checking to product price, if successively to each production Product original cost data carry out price logic checking, will necessarily consume the plenty of time, and by carrying out logic checking to cursor data, only It only needs to carry out one-time authentication, the verification time is greatly saved, be conducive to the efficiency for improving follow-up data modification.
S50: if verification result is to be proved to be successful, enters to join vernier using original vernier as product data sheet, generate mesh Script is marked, and performance objective script modifies to product original cost data, obtains product objective price.
Wherein, enter to join the incoming parameter that vernier refers to product data sheet, which can be stored in the form of caching, Or it deposits in the database.Specifically, entering to join vernier in the present embodiment is original vernier.
Script refers to the set of the sentence for creating database object.For example, storing process [Procedure], affairs [transaction] is indexed [Index], and trigger [Trigger], function [Function] etc. is all a kind of script.Specifically Ground, the target script in the present embodiment is to enter to join what vernier generated as product data sheet by original vernier, be can be improved The efficiency of data access, and carry out relevant data processing.
In a specific embodiment, continue by taking the declaration form tables of data in step S10 as an example, target script refers to declaration form number According to the Modification growth function of table, specifically the insured amount Modification growth function in declaration form tables of data, i.e. the update sentence of database, such as:
UPDATE ec_goods SET click_count`=`click_count`+1WHERE (`ec_id`='(ID Number) ').
Specifically, according to entering to join the field in vernier, corresponding product data sheet is obtained in vernier from entering to join, executes the production The corresponding target script of product original cost data of product tables of data, after executing the target script, i.e., carries out product original cost data Modification, and then obtain product objective price.
It is to be appreciated that ensure that cursor data just under the premise of cursor data passes through product price logic checking True property only need to guarantee to fill in into ginseng vernier to provide correct target script, therefore the modification for product original cost data It is normal, improve the efficiency of data modification.
In the present embodiment, product data sheet is obtained, first so as to more easily carry out product data sheet into one The operation of step.Then it by the way that product original cost data and product information field are generated vernier, and then is extracted by vernier index Data set, to carry out the operation of data modification, to find the product original cost data for needing to modify more flexible and conveniently, together When the operation of data modification done of user reflected in vernier.Then traversal is executed to original vernier using vernier index Operation, obtains cursor data, to handle subsequently through to cursor data, accelerates data processing process.Followed by use Cursor data carries out product price logic checking to product data sheet, obtains the verification result of product data sheet.If last verifying As a result to be proved to be successful, then enter to join vernier using original vernier as product data sheet, generate target script, and performance objective foot This modifies to product original cost data, obtains product objective price, improves the efficiency of data modification.
In one embodiment, as shown in figure 3, in step S30, traversing operation is executed to original vernier using vernier index, Obtain cursor data, comprising:
S31: according to the value sequence from big to small of vernier index, vernier index is ranked up, and ranking results are deposited Into index set, the index sequence comprising n vernier index is obtained, wherein n is the sum of vernier index.
Specifically, according to the value sequence from big to small of vernier index, vernier index is ranked up, and by ranking results It is stored in index set, to obtain the index sequence comprising n vernier index, the total n of vernier index is according to actual conditions It is determined, is not specifically limited herein.
For example, getting tetra- vernier indexes of a1, a2, a3 and a4, the value that the value of a1 is 62532, a2 is 62536, a3's The value that value be 62500, a4 is 62534, the value sequence from big to small indexed by this four verniers is ranked up as 62536, 62534,62532,62500, to obtain the index sequence { a2, a4, a1, a3 } comprising the value sequence indexed by vernier, the rope Drawing sequence includes 4 vernier indexes.
S32: first vernier index in index sequence is obtained, as current index.
Wherein, current index refers to the index for participating in data base querying, inquires according to current index original vernier, It can obtain and currently index corresponding vernier content.Specifically, from the index sequence got in step S31, first is chosen Vernier index, as current index.
Continue with for the index sequence { a2, a4, a1, a3 } that is got in step S31, first in Selecting Index sequence A vernier index a2 is as current index.
S33: using preset vernier function, executes inquiry operation to original vernier according to current index, obtains current cable Draw corresponding vernier content.
Wherein, preset vernier function can be FETCH function, be also possible to what other were extracted for vernier content search Vernier function, is not specifically limited herein.
For example, extracting the data content of vernier index a2 using sentence " FETCH a2INTO record variable ", " record becomes The data content that amount " as needs to extract.
Specifically, by using preset vernier function, according to current index, inquiry operation is executed to original vernier, from And currently indexed corresponding vernier content.
S34: the next vernier currently indexed is obtained according to the sequence of the value of vernier index from big to small in index set Index, is determined as currently indexing, and returns to execution and use preset vernier function, is looked into according to current index the execution of original vernier The step of asking operation, currently being indexed corresponding vernier content, until getting each vernier index pair in index set Until the vernier content answered.
Specifically, it after currently being indexed corresponding vernier content, needs to obtain other verniers and indexes corresponding vernier Content, in the present embodiment, according to the value sequence from big to small of index set middle reaches mark index, determine currently index it is next Vernier index, as new current index, and the step of return step S33, inquiry operation is continued to execute, until getting index Until each vernier in set indexes corresponding vernier content.
Continue by taking the example of step S32 as an example, in the example of step S32, current cable is cited as a2, by step S33's Inquiry operation has got the corresponding vernier content of a2, and then the next vernier index a4 for choosing a2 is indexed as current, and is returned It returns step S33 and executes inquiry operation, in this manner it is achieved that until 4 verniers in index sequence { a2, a4, a1, a3 } index all Corresponding vernier content is got, inquiry operation is terminated.
S35: each vernier is indexed into corresponding vernier content and is determined as cursor data.
Specifically, each vernier that will acquire indexes corresponding vernier content and is determined as cursor data, and cursor data is The set of vernier content.
In the present embodiment, according to the value sequence from big to small of vernier index, vernier index is ranked up, and will sequence As a result it is stored in index set, obtains the index sequence comprising n vernier index, and obtain first vernier in index sequence Index as current index, and then uses preset vernier function, executes inquiry operation to original vernier according to current index, Corresponding vernier content is currently indexed, then by obtaining in index set according to the sequence of the value of vernier index from big to small It takes the next vernier currently indexed to index, is determined as currently indexing, and continue to execute inquiry according to above-mentioned querying method, until obtaining Until getting the corresponding vernier content of each vernier index in index set, and each vernier index that will acquire is corresponding The combination of vernier content, is determined as cursor data, improves the efficiency of original vernier traversal queries.
In one embodiment, product information field includes product variety data and product Party A's data, and cursor data is specific Are as follows:
Product information field includes product variety data and product Party A's data, and cursor data includes the first cursor data C1, the second cursor data C2With third cursor data C3, wherein the first cursor data C1Refer to that each product variety data are corresponding Product original cost data, the second cursor data C2Refer to the summation of the corresponding product original cost data of each product variety data, the Three cursor data C3Refer to the corresponding product Party A data summation of each product variety data, and C1、C2And C3It is positive integer.
Wherein, product variety data refer to data relevant to product variety, such as vehicle insurance or meaning in declaration form tables of data Outer health insurance.Product Party A's data refer to that Party A occupies the number (share) of a certain product variety in product data sheet, for example, protecting Insurer (Party A) quantity of vehicle insurance is participated in forms data table, cursor data includes the first cursor data C1, the second cursor data C2 With third cursor data C3, wherein the first cursor data C1Refer to the corresponding product original cost data of each product variety data, the Two cursor data C2Refer to the summation of the corresponding product original cost data of each product variety data, third cursor data C3Refer to every The corresponding product Party A data summation of one product variety data.Continue the first vernier by taking the declaration form tables of data in step S10 as an example Data C1Refer to that the corresponding product original cost data of each product variety data are the protection amount of declaration form tables of data, the second cursor data C2The summation for referring to the corresponding product original cost data of each product variety data is the corresponding total sum insured of same insurance kind, third trip Mark data C3Refer to that the corresponding product Party A data summation of each product variety data is warrantee's number summation.
In the present embodiment, using cursor data, to carry out the operation of logic checking subsequently through cursor data.
In one embodiment, as shown in figure 4, in step S40, product price is carried out to product data sheet using cursor data Logic checking obtains the verification result of product data sheet, comprising:
S41: the first cursor data C is used1, the second cursor data C2With third cursor data C3Verify equation C2=C1*C3 It is whether true.
Wherein, equation C2=C1*C3, indicate that the summation of the corresponding product original cost data of each product variety data should meet The corresponding product original cost data of each product variety data product Party A data summation corresponding with each product variety data multiplies Long-pending relationship, i.e., under conditions of meeting the equation, the product original cost data in the true product data sheet of ability are correctly modified.
Specifically, using the first cursor data C1, the second cursor data C2With third cursor data C3Carry out verifying equation C2 =C1*C3It is whether true, thus according to the first cursor data C1, the second cursor data C2With third cursor data C3It carries out subsequent Data modification.
S42: if equation C2=C1*C3Invalid, then verification result is authentication failed.
Specifically, continue by taking the declaration form tables of data in step S10 as an example, pass through product price logic checking equation: same The corresponding total sum insured of insurance kind=original insured amount * warrantee's number is verified, i.e., the date expression of the equation is C2=C1*C3, root Inquiring the corresponding total sum insured of same insurance kind according to the number of policy or insurance kind number of declaration form tables of data whether there is, if it does not exist, i.e. equation In the corresponding total sum insured numerical value of same insurance kind be zero, it is clear that equation is invalid, thus verification result be authentication failed.It can manage Xie Di, the corresponding total sum insured of same insurance kind obtain the corresponding insured amount data of each insurance kind by traversing original vernier.Traversing In the process the corresponding protection amount of same insurance kind is added up to obtain.
If inquiring the corresponding total sum insured of same insurance kind, inquires in declaration form tables of data and whether at least protected in the presence of one People, if it does not, warrantee's number numerical value i.e. in equation is zero, it is clear that equation is invalid, so verification result is that verifying is lost It loses.
Exist it is worth noting that the number of policy or insurance kind number of declaration form tables of data inquire the corresponding total sum insured of same insurance kind, I.e. total sum insured is not zero, and whether at least there is a warrantee in declaration form tables of data, i.e. warrantee's number numerical value is not zero, if not Meet equation C2=C1*C3, i.e. C2≠C1*C3, then verification result is authentication failed.
S43: if equation C2=C1*C3It sets up, then verification result is to be proved to be successful.
If inquiring the corresponding total sum insured of same insurance kind and warrantee's number, pass through insured amount logic checking equation: same insurance kind Corresponding total sum insured=original insured amount * warrantee's number is verified, i.e., the date expression of the equation is C2=C1*C3, when this etc. Formula is set up, then verification result is to be proved to be successful.
In the present embodiment, pass through peer-to-peer C2=C1*C3Judged, and then realizes the product price to product data sheet Logic checking improves the accuracy of data modification so that it is guaranteed that product original cost data are modified after through logic checking.
In one embodiment, as shown in figure 5, in step S10, product data sheet is obtained, comprising:
S11: the xml configuration documentation in operation system is parsed to obtain document elements.
Wherein, operation system is the system for carrying out practical business processing.For example, for handling insurance related service Insurance system.Xml refers to extensible markup language, is a kind of general data interchange format, is used for structuring, storage and biography Defeated information, the xml configuration documentation in the present embodiment, refers to that filling in the page in product data sheet by business personnel fills in product original cost After data and product information field, the product data of the xml format got from the page.
Wherein, parsing refers to the process of xml configuration documentation being converted into structural data, by this present embodiment, be by Xml document is converted into the tables of data of database, it is therefore desirable to document elements, to obtain the field and attribute of tables of data.This reality It applies in example and xml data is parsed into one in memory using document dbject model (Document Object Model, DOM) Tree, operates xml by the operation to tree, obtains document elements.Specifically, the resolver of DOM disposably reads entire document, All elements in document are saved in a tree construction in memory.Therefore, the different functions that can use DOM offer come The content and structure of document is read or modified, xml document can also be written in the content modified.
In the present embodiment, it should be noted that due to product data be from by business personnel in the xml for filling in product data It is got in file, it is possible to understand that ground, the product data sheet that operation personnel sees are xml formats.
S12: the structure to document elements according to element carries out isolated first order element and second level element.
Wherein, first order element refers to the type of data, and second level element refers to the size of data, for example, there is an id The xml document element of (01,02,03), then id is first order element, (01,02,03) is second level element.The structure of element Refer to structure of the element in the tables of data of database, for example, the first order element in the present embodiment is equivalent to product data sheet In product information field, second level element is equivalent to the product original cost data in product data sheet.Specifically, for step Document elements obtained in S11 carry out element sepatation according to the structure of element, obtain first order element and second level element.
S13: first order element and second level element are combined, product data sheet is obtained.
In the present embodiment, first order element and second level element are combined and referred to using first order element as field, It is combined second level element as the mode of corresponding field element, to obtain product data sheet.It is to be appreciated that obtaining After product data sheet, product original cost data can be obtained by SQL query statement.
In the present embodiment, by being parsed to obtain document elements to the xml configuration documentation in operation system, to document member Element carries out isolated first order element and second level element according to the structure of element, finally by first order element and second level member Element is combined, and obtains product data sheet, to carry out product original cost data and product information word subsequently through product data sheet The query statistic operation of section.
In one embodiment, as shown in fig. 6, modifying in performance objective script to product original cost field, product is obtained After the step of target price, data modification method further include:
S61: verifying product objective price according to preset regular expression, if product objective price with it is preset Regular expression matching is then verified, and obtains product objective price.
Wherein, preset regular expression can be to look for the regular expression of repeated data, be also possible to other and be used for The regular expression of data verification, is not specifically limited herein in tables of data.
Specifically, connection to database is established, after the data that target price is got using SQL search statement, by this Data are tested with the target price being stored in advance in product data information table in the server by default regular expression Card, when inquiring the target price data, i.e. product objective price and the preset regular expression matching then illustrate product Original cost data are correctly modified.By verifying to product objective price, the accurate of data modification is further improved Property.
S62: if product objective price and preset regular expression mismatch, verifying and do not pass through, and by product objective Price is sent to client and is audited.
Specifically, which is passed through with the target price being stored in advance in product data information table in the server pre- If regular expression is verified, when not inquiring the target price data, i.e. product objective price and the preset canonical Expression formula mismatches, then illustrates product original cost data modification mistake, i.e. product objective price verification does not pass through.
It should be noted that in the present embodiment, in the case where verification result is to verify unacceptable situation, client can be passed through Secondary audit modification is carried out, secondary verifying is then carried out.Verifying client is not fed back to by product objective price, and to this Product objective price is uploaded to server-side after being handled again.Ensure the accuracy of data modification.
In the present embodiment, product objective price is verified according to preset regular expression, further improves number According to the accuracy of modification.
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 data modifying apparatus is provided, which repairs with data in above-described embodiment Change method one-to-one correspondence.As shown in fig. 7, the data modifying apparatus includes that product data sheet obtains module 10, original vernier obtains Module 20, cursor data obtain module 30, product price logic checking module 40 and product objective price and obtain module 50.Each function Detailed description are as follows for energy module:
Product data sheet obtains module 10, for obtaining product data sheet, wherein product data sheet includes product original cost number According to product information field;
Original vernier obtains module 20, former for generating original vernier according to product original cost data and product information field Beginning vernier includes vernier index;
Cursor data obtains module 30, for executing traversing operation to original vernier using vernier index, obtains vernier number According to;
Product price logic checking module 40 is tested for carrying out product price logic to product data sheet using cursor data Card, obtains the verification result of product data sheet;
Product objective price obtains module 50, if being to be proved to be successful for verification result, using original vernier as product Tables of data enters to join vernier, generates target script, and performance objective script modifies to product original cost data, obtains product mesh Marked price lattice.
Specifically, it includes index sequence acquiring unit 31, current index acquiring unit 32, trip that cursor data, which obtains module 30, Mark contents acquiring unit 33, entire vernier contents acquiring unit 34 and cursor data acquiring unit 35.
Specifically, cursor data obtain module 30 further include index sequence acquiring unit 31, current index acquiring unit 32, Vernier contents acquiring unit 33, entire vernier contents acquiring unit 34 and cursor data acquiring unit 35.
Index sequence acquiring unit 31, the sequence of value from big to small for indexing according to vernier index vernier and carry out Sequence, and ranking results are stored in index set, obtain the index sequence comprising n vernier index, wherein n is vernier rope The sum drawn;
Current index acquiring unit 32, for obtaining the index of first vernier in index sequence, as current index;
Vernier contents acquiring unit 33 executes original vernier according to current index for using preset vernier function Inquiry operation is currently indexed corresponding vernier content;
Entire vernier contents acquiring unit 34, for the sequence in index set according to the value of vernier index from big to small The next vernier index currently indexed is obtained, is determined as currently indexing, and returns to execution and uses preset vernier function, according to working as The step of preceding index executes inquiry operation, is currently indexed corresponding vernier content to original vernier, until getting index Until each vernier in set indexes corresponding vernier content;
Cursor data acquiring unit 35 is determined as cursor data for each vernier to be indexed corresponding vernier content.
Specifically, product information field includes product variety data and product Party A's data, and cursor data includes the first trip Mark data C1, the second cursor data C2With third cursor data C3, wherein the first cursor data C1Refer to each product variety number According to corresponding product original cost data, the second cursor data C2Refer to the total of the corresponding product original cost data of each product variety data With third cursor data C3Refer to the corresponding product Party A data summation of each product variety data, and C1、C2And C3It is positive Integer.
Specifically, product price logic checking module 40 include equation authentication unit, the first verification result acquiring unit and Second verification result acquiring unit.
Equation authentication unit, for using the first cursor data C1, the second cursor data C2With third cursor data C3Verifying Equation C2=C1*C3It is whether true;
First verification result acquiring unit, if being used for equation C2=C1*C3Invalid, then verification result is authentication failed;
Second verification result acquiring unit, if being used for equation C2=C1*C3It sets up, then verification result is to be proved to be successful.
Specifically, it includes document elements acquiring unit, document elements separative unit and production that product data sheet, which obtains module 10, Product tables of data acquiring unit.
Document elements acquiring unit, for being parsed to obtain document elements to the xml configuration documentation in operation system;
Document elements separative unit, for document elements according to the structure of element carry out isolated first order element and Second level element;
Product data sheet acquiring unit obtains product data for first order element and second level element to be combined Table.
Specifically, which further includes that the first verification result obtains module and the second verification result acquisition mould Block.
First verification result obtains module, for being verified according to preset regular expression to product objective price, If product objective price and preset regular expression matching, are verified, and obtain product objective price;
Second verification result obtains module, if mismatching for product objective price and preset regular expression, tests Card does not pass through, and product objective price is sent to client and is audited.
Specific about data modifying apparatus limits the restriction that may refer to above for data modification method, herein not It repeats again.Modules in above-mentioned data modifying apparatus can be realized fully or partially through software, hardware and combinations thereof.On Stating each module can be embedded in the form of hardware or independently of in the processor in computer equipment, can also store in a software form In memory in computer equipment, the corresponding operation of the above modules is executed in order to which processor calls.
In one embodiment, a kind of computer equipment is provided, which can be server, internal junction Composition can be as shown in Figure 8.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 product data sheet.The network interface of the computer equipment is used to pass through net with external terminal Network connection communication.To realize a kind of data modification method when the computer program is executed by processor.
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 realize above-described embodiment data modification side when executing computer program The step of method, such as step S10 shown in Fig. 2 to step S50.Alternatively, processor realizes above-mentioned reality when executing computer program Apply the function of each module/unit of a data modifying apparatus, such as module shown in Fig. 7 10 is to module 50.To avoid repeating, this In repeat no more.
In one embodiment, a kind of computer readable storage medium is provided, computer program is stored thereon with, is calculated Machine program realizes that the step of above-described embodiment data modification method or computer program are held by processor when being executed by processor The step of above-described embodiment data modification method is realized when row, to avoid repeating, which is not described herein again.
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 Instruct relevant hardware to complete by computer program, computer program to can be stored in a non-volatile computer readable It takes in storage medium, the computer program is when being executed, it may include such as the process of the embodiment of above-mentioned each method.Wherein, this Shen Please provided by any reference used in each embodiment to memory, storage, database or other media, may each comprise 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 device are divided into different functional unit or module, to complete above description All or part of function.
The above embodiments are merely illustrative of the technical solutions of the present invention, rather than its limitations;Although with reference to the foregoing embodiments Invention is explained in detail, those skilled in the art should understand that: it still can be to aforementioned each implementation Technical solution documented by example is modified or equivalent replacement of some of the technical features;And these modification 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 include Within protection scope of the present invention.

Claims (10)

1. a kind of data modification method, which is characterized in that the data modification method includes:
Obtain product data sheet, wherein the product data sheet includes product original cost data and product information field;
Original vernier is generated according to the product original cost data and the product information field, the original vernier includes vernier rope Draw;
Traversing operation is executed to the original vernier using vernier index, obtains cursor data;
Product price logic checking is carried out to the product data sheet using the cursor data, obtains the product data sheet Verification result;
If the verification result is to be proved to be successful, enter to join vernier, life using the original vernier as the product data sheet It at target script, and executes the target script and modifies to the product original cost data, obtain product objective price.
2. data modification method as described in claim 1, described to be indexed using the vernier to the original vernier execution time Operation is gone through, cursor data is obtained, comprising:
According to the value sequence from big to small of vernier index, vernier index is ranked up, and ranking results are deposited Into index set, the index sequence comprising n vernier index is obtained, wherein n is the sum of vernier index;
First vernier index in the index sequence is obtained, as current index;
Using preset vernier function, inquiry operation is executed to the original vernier according to the current index, obtains described work as It is preceding to index corresponding vernier content;
The next vernier currently indexed is obtained according to the sequence of the value of vernier index from big to small in index set to index, It is determined as currently indexing, and returns and execute the preset vernier function of the use, according to the current index to the original trip Mark executes inquiry operation, obtains described the step of currently indexing corresponding vernier content, until getting in the index set Each vernier index corresponding vernier content until;
Each vernier is indexed into corresponding vernier content and is determined as the cursor data.
3. data modification method as described in claim 1, which is characterized in that the product information field includes product variety number According to product Party A's data, the cursor data include the first cursor data C1, the second cursor data C2With third cursor data C3, wherein the first cursor data C1Refer to the corresponding product original cost data of each product variety data, described second Cursor data C2Refer to the summation of the corresponding product original cost data of each product variety data, third cursor data C3Refer to The corresponding product Party A data summation of each product variety data, and C1、C2And C3It is positive integer.
4. data modification method as claimed in claim 3, which is characterized in that described to use the cursor data to product data Table carries out product price logic checking, obtains the verification result of product data sheet, comprising:
Use the first cursor data C1, the second cursor data C2With the third cursor data C3Verify equation C2= C1*C3It is whether true;
If equation C2=C1*C3Invalid, then the verification result is authentication failed;
If equation C2=C1*C3It sets up, then the verification result is to be proved to be successful.
5. data modification method as described in claim 1, which is characterized in that the acquisition product data sheet, comprising:
Xml configuration documentation in operation system is parsed to obtain document elements;
Structure to the document elements according to element carries out isolated first order element and second level element;
The first order element and second level element are combined, the product data sheet is obtained.
6. data modification method as described in claim 1, which is characterized in that execute the target script to the production described After the step of product original cost field modifies, obtains product objective price, the data modification method further include:
The product objective price is verified according to preset regular expression, if the product objective price with it is described pre- If regular expression matching, then be verified, and obtain the product objective price;
If the product objective price and the preset regular expression mismatch, verify and do not pass through, and by the product Target price is sent to client and is audited.
7. a kind of data modifying apparatus, which is characterized in that the data modifying apparatus includes:
Product data sheet obtains module, for obtaining product data sheet, wherein the product data sheet includes product original cost data With product information field;
Original vernier obtains module, for generating original vernier according to the product original cost data and the product information field, The original vernier includes vernier index;
Cursor data obtains module, for executing traversing operation to the original vernier using vernier index, obtains vernier Data;
Product price logic checking module, for carrying out product price logic to the product data sheet using the cursor data Verifying, obtains the verification result of the product data sheet;
Product objective price obtains module, if being to be proved to be successful for the verification result, using the original vernier as institute That states product data sheet enters to join vernier, generates target script, and execute the target script and carry out to the product original cost data Modification, obtains product objective price.
8. data modifying apparatus as claimed in claim 7, which is characterized in that the cursor data obtains module, comprising:
Index sequence acquiring unit, the sequence of value from big to small for being indexed according to the vernier, to the vernier index into Row sequence, and ranking results are stored in index set, obtain the index sequence comprising n vernier index, wherein n is vernier The sum of index;
Current index acquiring unit, for obtaining first in the index sequence vernier index, as current index;
Vernier contents acquiring unit holds the original vernier according to the current index for using preset vernier function Row inquiry operation obtains described currently indexing corresponding vernier content;
Entire vernier contents acquiring unit, for being obtained in index set according to the sequence of the value of vernier index from big to small It takes the next vernier currently indexed to index, is determined as currently indexing, and return and execute the preset vernier function of the use, according to The current index executes inquiry operation to the original vernier, obtains described the step of currently indexing corresponding vernier content, Until indexing corresponding vernier content until getting each vernier in the index set;
Cursor data acquiring unit is determined as the cursor data for each vernier to be indexed corresponding vernier content.
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 Any one of 6 data modification methods.
10. a kind of computer readable storage medium, the computer-readable recording medium storage has computer program, and feature exists In the step of realization data modification method as described in any one of claim 1 to 6 when the computer program is executed by processor Suddenly.
CN201811184393.0A 2018-10-11 2018-10-11 Data modification method, device, computer equipment and storage medium Active CN109542890B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201811184393.0A CN109542890B (en) 2018-10-11 2018-10-11 Data modification method, device, computer equipment and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201811184393.0A CN109542890B (en) 2018-10-11 2018-10-11 Data modification method, device, computer equipment and storage medium

Publications (2)

Publication Number Publication Date
CN109542890A true CN109542890A (en) 2019-03-29
CN109542890B CN109542890B (en) 2024-01-26

Family

ID=65843656

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201811184393.0A Active CN109542890B (en) 2018-10-11 2018-10-11 Data modification method, device, computer equipment and storage medium

Country Status (1)

Country Link
CN (1) CN109542890B (en)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110308912A (en) * 2019-06-12 2019-10-08 平安科技(深圳)有限公司 A kind of information processing method and relevant apparatus
CN112581295A (en) * 2020-12-15 2021-03-30 平安养老保险股份有限公司 Product data processing method, device, equipment and medium based on field splitting

Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JPH117586A (en) * 1997-06-18 1999-01-12 Tec Corp Commodity sales data register processing system and commodity unit price changing method in the system
CN1407492A (en) * 2001-09-10 2003-04-02 好利集团有限公司 Point to point price negotiating method and system
CN101639848A (en) * 2009-06-01 2010-02-03 北京四维图新科技股份有限公司 Spatial data engine and method applying management spatial data thereof
CN103314371A (en) * 2010-12-31 2013-09-18 肖岩 Retrieval method and system
US20150073872A1 (en) * 2013-09-09 2015-03-12 Emil Bader Network-implemented methods and systems for providing dynamic product pricing
CN108108493A (en) * 2018-01-17 2018-06-01 中国平安人寿保险股份有限公司 Algorithm process method, server and storage medium based on the demonstration of MIT interests
CN108427626A (en) * 2018-01-05 2018-08-21 平安科技(深圳)有限公司 Daily record text handling method, device and storage medium

Patent Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JPH117586A (en) * 1997-06-18 1999-01-12 Tec Corp Commodity sales data register processing system and commodity unit price changing method in the system
CN1407492A (en) * 2001-09-10 2003-04-02 好利集团有限公司 Point to point price negotiating method and system
CN101639848A (en) * 2009-06-01 2010-02-03 北京四维图新科技股份有限公司 Spatial data engine and method applying management spatial data thereof
CN103314371A (en) * 2010-12-31 2013-09-18 肖岩 Retrieval method and system
US20150073872A1 (en) * 2013-09-09 2015-03-12 Emil Bader Network-implemented methods and systems for providing dynamic product pricing
CN108427626A (en) * 2018-01-05 2018-08-21 平安科技(深圳)有限公司 Daily record text handling method, device and storage medium
CN108108493A (en) * 2018-01-17 2018-06-01 中国平安人寿保险股份有限公司 Algorithm process method, server and storage medium based on the demonstration of MIT interests

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110308912A (en) * 2019-06-12 2019-10-08 平安科技(深圳)有限公司 A kind of information processing method and relevant apparatus
CN112581295A (en) * 2020-12-15 2021-03-30 平安养老保险股份有限公司 Product data processing method, device, equipment and medium based on field splitting
CN112581295B (en) * 2020-12-15 2023-09-26 平安养老保险股份有限公司 Product data processing method, device, equipment and medium based on field splitting

Also Published As

Publication number Publication date
CN109542890B (en) 2024-01-26

Similar Documents

Publication Publication Date Title
CN108027818B (en) Inquiry based on figure
Klein et al. A systematic review of system-of-systems architecture research
CN109558440A (en) Batch data processing method, device, computer equipment and storage medium
CN102999561B (en) The context trend of data set and data, services
EP2778929B1 (en) Test script generation system
CN109559231A (en) A kind of retrospect querying method towards block chain
CN1533542A (en) Systems and methods for creating financial advice applications
CN110134705A (en) A kind of data query method, cache server and terminal
US20140289243A1 (en) Method and system for centralized issue tracking
US20130339293A1 (en) Methods and systems for flexible and scalable databases
CN109241068A (en) The method, apparatus and terminal device that foreground and background data compares
CN108460068A (en) Method, apparatus, storage medium and the terminal that report imports and exports
CN112286934A (en) Database table importing method, device, equipment and medium
CN109324960A (en) Automatic test approach and terminal device based on big data analysis
CN109002470A (en) Knowledge mapping construction method and device, client
CN109542890A (en) Data modification method, device, computer equipment and storage medium
CN105843605B (en) A kind of data mapping method and device
CN111061733A (en) Data processing method and device, electronic equipment and computer readable storage medium
CN109325873A (en) Self-service method for processing business, device, computer equipment and storage medium
Ramin XBRL as a new language for business and intangibles reporting
Härer Towards Interoperability of Open and Permissionless Blockchains: A Cross-Chain Query Language
CN109324963A (en) The method and terminal device of automatic test profitable result
EP3278283A1 (en) Tracking data flow in distributed computing systems
US11688027B2 (en) Generating actionable information from documents
CN111723129B (en) Report generation method, report generation device and electronic equipment

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