CN109635017A - Service data guiding method, device, equipment and computer readable storage medium - Google Patents

Service data guiding method, device, equipment and computer readable storage medium Download PDF

Info

Publication number
CN109635017A
CN109635017A CN201811207539.9A CN201811207539A CN109635017A CN 109635017 A CN109635017 A CN 109635017A CN 201811207539 A CN201811207539 A CN 201811207539A CN 109635017 A CN109635017 A CN 109635017A
Authority
CN
China
Prior art keywords
business datum
data table
data
assets
field
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN201811207539.9A
Other languages
Chinese (zh)
Inventor
刘鑫宇
邓新文
陈伟城
冯辉
王柳清
顾佳页
刘浩
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
OneConnect Smart Technology Co Ltd
Original Assignee
OneConnect Smart Technology 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 OneConnect Smart Technology Co Ltd filed Critical OneConnect Smart Technology Co Ltd
Priority to CN201811207539.9A priority Critical patent/CN109635017A/en
Publication of CN109635017A publication Critical patent/CN109635017A/en
Pending legal-status Critical Current

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/06Asset management; Financial planning or analysis

Landscapes

  • Engineering & Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Finance (AREA)
  • Accounting & Taxation (AREA)
  • Development Economics (AREA)
  • Operations Research (AREA)
  • Game Theory and Decision Science (AREA)
  • Human Resources & Organizations (AREA)
  • Entrepreneurship & Innovation (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)
  • Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)

Abstract

The present invention discloses a kind of service data guiding method, device, equipment and computer readable storage medium, which comprises when receiving the request of the importing to assets APMB package, judges whether assets APMB package meets the field requirement of default template;If meeting the field requirement of default template, it is inserted into interim blank table corresponding with default template, and the business datum in assets APMB package is imported into interim blank table, forms temporary data table;Preliminary check is carried out to business datum each in temporary data table, and after preliminary check success, business datum each in temporary data table is split, each associated data table is generated;Each associated data table is verified, and after verifying successfully again again, each associated data table is stored, the importing of finishing service data.This programme is verified by the preliminary check to business datum and again, realizes the data normalization processing to business datum, it is ensured that each business datum imported meets the requirement of financial institution.

Description

Service data guiding method, device, equipment and computer readable storage medium
Technical field
The invention mainly relates to technical field of data processing, specifically, being related to a kind of service data guiding method, dress It sets, equipment and computer readable storage medium.
Background technique
With the development of technology, during operation, involved assets packet is more and more, in assets packet for financial institution Including a plurality of business datum, the debt information of the corresponding debt side of every business datum;Financial institution will be from the third-party institution The assets packet obtained, is managed according to the system that the form of business datum imported into financial institution.
Because assets packet is probably derived from the different third-party institutions, so that the form of business datum is varied, Ke Nengcun In shortage of data, in various formats or business datum existing for type so that the business datum importeding into financial institution is not inconsistent It closes and requires, it is subsequent during to business data processing, once there is the business datum for being unsatisfactory for requiring, need to return preceding Each process problem point is searched, seriously affect the processing progress of business datum.
Summary of the invention
The main object of the present invention is to provide a kind of service data guiding method, device, equipment and computer-readable storage Medium, it is intended to which the business datum for solving to import in the prior art does not meet the requirement of financial institution, and influences business data processing The problem of progress.
To achieve the above object, the present invention provides a kind of service data guiding method, the service data guiding method packet Include following steps:
When receiving the request of the importing to assets APMB package, judge whether the assets APMB package meets default template Field requirement;
If meeting the field requirement of the default template, insertion interim blank table corresponding with the default template, and Business datum in the assets APMB package is imported into the interim blank table, temporary data table is formed;
Preliminary check is carried out to the business datum each in the temporary data table, and after preliminary check success, The business datum each in the temporary data table is split, each associated data table is generated;
Each associated data table is verified again, and it is described verify successfully again after, to each incidence number It is stored according to table, completes the importing of the business datum.
Preferably, the business datum in the assets APMB package is read line by line, and to business number in the assets APMB package According to each required item carry out null value detection, judge in each required item whether there is assigning null data;
If there are assigning null data in each required item, inserting error tables of data, and by the assigning null data source The business data transmission is into the wrong data table;
If assigning null data is not present in each required item, by the business data transmission in the assets APMB package to institute It states in interim blank table, forms temporary data table.
Preferably, described the step of carrying out preliminary check to the business datum each in the temporary data table, includes:
Each business datum in the temporary data table is traversed, is detected each described in the temporary data table Whether the data format of business datum is consistent with preset format;
If the data format and the preset format are consistent, determine to the business each in the temporary data table The preliminary check success of data;
If the data format is uneven consistent with the preset format, determine to the industry each in the temporary data table The preliminary check failure for data of being engaged in.
Preferably, it is described determine the step successful to the preliminary check of the business datum each in the temporary data table it After include:
The number of the assets APMB package is read, and judges whether there is the identical repetition with the number and numbers, if depositing It repeats to number identical with the number, then stops the importing to business datum in the assets APMB package;
It is identical with the number if it does not exist to repeat to number, then it is inserted into each field information table, to generate the incidence number According to table.
Preferably, the business datum in the temporary data table is split, and generates each associated data table The step of include:
Preset field is based on to each business datum in the temporary data table to split, and obtains each Field Count According to;
According to the corresponding relationship between the preset field and each field information table, each field data is transmitted Into each field information table, each associated data table is generated.
Preferably, described the step of being verified again to each associated data table, includes:
Each field data in each associated data table is read one by one, and corresponding with each associated data table Preset data attribute;
The attribute of each field data and preset data attribute are based on the associated data table to compare, judge institute State field data attribute whether with the preset data attributes match, to be verified again to the associated data table.
Preferably, described to judge that the step of whether the assets APMB package meets the field requirement of default template includes:
Judge whether the file format of the assets APMB package is identical as the default file format of the default template, if institute It states that file format is identical as the default file format, then reads the file field of the assets APMB package, and by the file The field of field and the default template requires comparison, to judge whether the assets APMB package meets the word of the default template Duan Yaoqiu;
If the assets APMB package meets the field requirement of the default template, insertion and the default template pair are executed The step of interim blank table answered;
If the assets APMB package is unsatisfactory for the field requirement of the default template, the assets APMB package and institute are grabbed The difference field between default template is stated, the difference field is added in prompt information, and export the prompt information.
In addition, to achieve the above object, the present invention also proposes a kind of business datum gatherer, the business datum is imported Device includes:
Judgment module, for whether judging the assets APMB package when receiving the request of the importing to assets APMB package Meet the field requirement of default template;
Import modul is inserted into corresponding with the default template if the field for meeting the default template requires Interim blank table, and the business datum in the assets APMB package is imported into the interim blank table, form ephemeral data Table;
Module is split, for carrying out preliminary check to the business datum each in the temporary data table, and described first After step verifies successfully, the business datum each in the temporary data table is split, each associated data table is generated;
Memory module, for being verified again to each associated data table, and it is described verify successfully again after, it is right Each associated data table is stored, and the importing of the business datum is completed.
In addition, to achieve the above object, the present invention also proposes that a kind of business datum imports equipment, and the business datum imports Equipment includes: that memory, processor, communication bus and the business datum being stored on the memory import program;
The communication bus is for realizing the connection communication between processor and memory;
The processor imports program for executing the business datum, to perform the steps of
When receiving the request of the importing to assets APMB package, judge whether the assets APMB package meets default template Field requirement;
If meeting the field requirement of the default template, insertion interim blank table corresponding with the default template, and Business datum in the assets APMB package is imported into the interim blank table, temporary data table is formed;
Preliminary check is carried out to the business datum each in the temporary data table, and after preliminary check success, The business datum each in the temporary data table is split, each associated data table is generated;
Each associated data table is verified again, and it is described verify successfully again after, to each incidence number It is stored according to table, completes the importing of the business datum.
In addition, to achieve the above object, it is described computer-readable the present invention also provides a kind of computer readable storage medium Storage medium be stored with one perhaps more than one program the one or more programs can by one or one with On processor execute to be used for:
When receiving the request of the importing to assets APMB package, judge whether the assets APMB package meets default template Field requirement;
If meeting the field requirement of the default template, insertion interim blank table corresponding with the default template, and Business datum in the assets APMB package is imported into the interim blank table, temporary data table is formed;
Preliminary check is carried out to the business datum each in the temporary data table, and after preliminary check success, The business datum each in the temporary data table is split, each associated data table is generated;
Each associated data table is verified again, and it is described verify successfully again after, to each incidence number It is stored according to table, completes the importing of the business datum.
The service data guiding method of the present embodiment is receiving the request of the importing to assets packet, is first judging assets Bao Wen Whether part meets the field requirement of default template, only when the field for meeting default template requires, is just inserted into and default template Corresponding interim blank table, and the business datum in assets APMB package is imported into the interim blank table, form ephemeral data In table, financial institution is imported into avoid the assets APMB package for lacking field;And to each business number in temporary data table After preliminary check success, each business datum is split, each associated data table is generated;Again to each associated data table again It is secondary verify successfully after, each associated data table is stored, and completes the importing of each business datum in assets packet.Pass through setting pair The preliminary check of business datum and again verification scheme, the requirement by financial institution to business datum are arranged to each verification scheme In, it is ensured that each business datum imported meets the various requirement of financial institution, facilitates financial institution subsequent to business datum Working process.
Detailed description of the invention
Fig. 1 is the flow diagram of service data guiding method first embodiment of the invention;
Fig. 2 is the functional block diagram of business datum gatherer first embodiment of the invention;
Fig. 3 is the device structure schematic diagram for the hardware running environment that present invention method is related to.
The embodiments will be further described with reference to the accompanying drawings for the realization, the function and the advantages of the object of the present invention.
Specific embodiment
It should be appreciated that the specific embodiments described herein are merely illustrative of the present invention, it is not intended to limit the present invention.
The present invention provides a kind of service data guiding method.
Fig. 1 is please referred to, Fig. 1 is the flow diagram of service data guiding method first embodiment of the present invention.In this implementation In example, the service data guiding method includes:
It is pre- to judge whether the assets APMB package meets when receiving the request of the importing to assets APMB package by step S10 If the field of template requires;
Service data guiding method of the invention is applied to the server in financial institution, is suitable for provide by server The business datum produced in packet imports in financial institution;The wherein debt that assets packet is bought by financial institution to the third-party institution Information, each debt information are present in assets packet in the form of EXCEL file, and using assets packet as assets APMB package;EXCEL A line in file corresponds to a debt information, includes at least debt side's title, ID card No., connection in every debt information The data such as phone, debt type, amount owed, debt duration characterize every terms of information possessed by every debt.By a debt Information includes various multinomial business datums in assets APMB package as a business datum, each business datum with One debt is corresponding.Business datum is imported into financial institution by server in the form of assets APMB package, and server is connected with letter Breath shows recording device, and the virtual key imported for assets APMB package is provided on the display interface of the display recording device; When having to the importing demand of business datum in assets APMB package, the virtual key is triggered.By the trigger action of the virtual key Importing as assets APMB package is requested, and when receiving importing request, judges whether assets APMB package meets default template Field requirement;The default template is the pre-set template for being imported to assets APMB package, in order to business The standardized administration of data.Multiple fields are provided in default template, for characterizing each industry of required importing in assets APMB package The data attribute for data of being engaged in;Such as field " accommodator's name ", " ID card No. ", " amount owed " and " debt time ".Money It produces the field that APMB package meets in default template to require, it can be ensured that imported into each characterized debt letter of business datum in financial institution The information integrity of breath is conducive to the collection to debt.
In view of assets APMB package derives from the different third-party institutions, there may be a variety of different existence forms;In order to Ensure the consistency of each assets APMB package format, default template is additionally provided with file format other than being provided with field and requiring It is required that such as EXCEL file format.To assets APMB package other than carrying out field and requiring judgement, it is also necessary to carry out file format Judgement;Specifically, judge that the step of whether assets APMB package meets the field requirement of default template includes:
Step S11, judge the assets APMB package file format whether the default file format with the default template It is identical, if the file format is identical as the default file format, the file field of the assets APMB package is read, and will The field of the file field and the default template requires comparison, to judge it is described default whether the assets APMB package meets The field requirement of template;
The file format that has of assets APMB package imported required for reading, and by institute in this document format and default template Pre-set default file format compares, judge assets APMB package file format and default file format whether phase Together.Because the type of file format can be characterized with file extension, so that the file extension of assets APMB package can be read, and Required file extension is preset in default template, by the file extension of reading and required file extension pair Than judging the consistency of the two;When both determining consistent, then illustrate file format possessed by assets APMB package and default The default file format of template is identical, and the file format of assets APMB package meets default requirement of the template to file format, in turn Judge whether assets APMB package meets the field requirement of default template.Read word possessed by business datum in assets APMB package Section, using the field as the file field of assets APMB package;By the pre-set field of institute in this document field and default template It is required that comparing, judge whether assets APMB package meets the field requirement of default template.Default template will be to business datum institute The field of demand is preset, formed field requirement, such as require in business datum include " accommodator's contact method ", " owe Money people ID card No. " and " amount owed " three fields then set field requirement for three fields;And by reading The field of business datum in assets APMB package, the i.e. file field of assets APMB package and the field require comparison, judge to need to lead Whether the assets APMB package entered meets field requirement.
Step S12, if the assets APMB package meet the default template field requirement, execute insertion with it is described pre- If the step of template corresponding interim blank table;
When judging that the field of business datum is consistent with the requirement of the field of default template in assets APMB package, then illustrate to provide The file field for producing APMB package meets default requirement of the template to field, i.e., the field that assets APMB package meets default template is wanted It asks, is then inserted into interim blank table corresponding with default template, to carry out import operation to the business datum in assets APMB package.
Step S13 grabs the assets packet if the assets APMB package is unsatisfactory for the field requirement of the default template The difference field is added in prompt information by the difference field between file and the default template, and mentions described in output Show information.
And works as and judge that the field of business datum and the field of preset model require inconsistent, business number in assets APMB package According to any one for lacking field required by default template in possessed each field;" accommodator such as is required for above-mentioned field Contact method ", " accommodator's ID card No. " and " amount owed ", if lacking field " accommodator's identity card in business datum Number " then determines that assets APMB package is unsatisfactory for the field requirement of default template.In order to enable the required assets APMB package imported Meet the field requirement of default template, and grabs the difference field between assets APMB package and default template;The wherein difference word Field is not present to be present in required each field in default template in section lacking in assets APMB package;And for It is present in assets APMB package, but the field being not present in default template is not as difference field.By the assets APMB package and in advance If the difference field of institute's difference is added in prompt information between template, and will be prompted to information output, to prompt assets APMB package In lacking in field;Convenient for after to field is added lacking in this, then carry out import operation, it is ensured that imported assets The integrality of business datum institute characterization information in APMB package.
Step S20, if meeting the field requirement of the default template, insertion interim sky corresponding with the default template White table, and the business datum in the assets APMB package is imported into the interim blank table, form temporary data table;
Further, it when judging that assets APMB package meets the field requirement of default template, is then inserted into and default template Corresponding interim blank table, the interim blank table are, and word with default template consistent with the default file format of default template The blank table of the consistent not storing data of Duan Yaoqiu;It is such as inserted into the interim blank table of EXCEL format, in the interim blank table Required each field is set in each unit lattice of a line.Business datum in assets APMB package is imported into the interim blank table In, and carried out when importing according to each column where the cell with field;Such as field " debt side's name " in interim blank table In the cell of secondary series, then the name of accommodator each in each business datum is imported into secondary series when importing.It should Interim blank table after importing business datum forms temporary data table, and each row in temporary data table characterizes the items of each debt side Business datum, and respectively arrange, characterize the data attribute of every business datum.
Step S30 carries out preliminary check to the business datum each in the temporary data table, and in the preliminary check After success, the business datum each in the temporary data table is split, each associated data table is generated;
It imported into interim blank table by each business datum in assets APMB package, after forming temporary data table, needs Preliminary check is carried out to every business datum in temporary data table;Preliminary check is the format school to data each in business datum It tests, such as characterizes the format on date, the format etc. comprising fraction data;So that each business datum tool in imported into financial institution There is consistent data format, convenient for the subsequent working process to business datum.Specifically, to business datum each in temporary data table Carry out preliminary check the step of include:
Step S31 traverses each business datum in the temporary data table, detects the temporary data table In each business datum data format it is whether consistent with preset format;
For the data attribute that different field is characterized, it is previously provided with different preset formats;Such as the debt date, Preset format set by the data of dates class such as date of refunding is " yyyy-mm-dd ", for debt capital, interest on arrears etc. Preset format set by the data of debt class is " xxxx.xx " etc..Each business datum in temporary data table is traversed, Whether the data format for detecting each business datum is consistent with preset format;Because preset format corresponding to different field is in the presence of poor The opposite sex is detected according to field corresponding to each data in business datum, judges the number for belonging to each field in business datum According to its correspond to preset format it is whether consistent, until data each in business datum detect completion.
Step S32 determines if the data format and the preset format are consistent to each in the temporary data table The preliminary check success of the business datum;
Step S33 determines if the data format is uneven consistent with the preset format in the temporary data table The preliminary check of each business datum fails.
When detecting that the data format of each business datum is consistent with preset format in temporary data table, then explanation is interim The data format of each business datum is all satisfied the requirement of preset format in tables of data, the data format preliminary check of business datum at Function;And when there are any data format and preset format are inconsistent, then illustrating each business in each business datum of temporary data table The data format of data is uneven consistent with preset format, fails to the preliminary check of business datum each in temporary data table.For The temporary data table of preliminary check failure can decide whether to continue to carry out the business datum in temporary data table according to failure rate Import operation.Inconsistent compared with the data format of multi-service data and preset format when existing in temporary data table, failure rate is higher When, then import operation is not continued to business datum, and export prompt information.And when there is only small parts in temporary data table The data format and preset format of business datum are inconsistent, when failure rate is lower, then the data format and preset format is different The small part business datum of cause carries out delete operation, it is deleted from temporary data table, and to interim after delete operation Each business datum in tables of data continues import operation.
Further, to each business datum in the temporary data table through preliminary check success or delete operation according to field It is split, the identical data of field each in each business datum is split in same tables of data;It such as will be in each business datum table " accommodator's telephone number " and " amount owed " fractionation form telephone number tables of data and amount owed tables of data;Telephone number It include all accommodator's telephone numbers for being related in each business datum of temporary data table in tables of data, in amount owed tables of data Including all amounts owed being related in each business datum of temporary data table.Because fractionation is formed by the data in each tables of data Derive from the debt information of each accommodator, by accommodator as being associated between each tables of data, and will be split each Tables of data is as each associated data table;While realization by each associated data table to the progress Classification Management of each debt information, Incidence relation is formed between each debt information.
Step S40 verifies each associated data table again, and it is described verify successfully again after, to each institute It states associated data table to be stored, completes the importing of the business datum.
Understandably, after splitting according to field by temporary data table and to form each associated data table, each associated data table In all refer to multiple data of each field institute characterization attributes;That is multiple data of the corresponding generic attribute of an associated data table, Data in different associated data tables have different attributes.As for attribute corresponding to name data table be data length not It include " male " and " female " two class for attribute corresponding to gender data table more than a certain value;When in associated data table occur and When it corresponds to attribute inconsistent data, the data there may be exception, imported into financial institution may influence it is subsequent to business The working process of data.To the consistency in order to ensure each data attribute in split associated data table, to each associated data Table is verified again, this is verified as carrying out attribute verification to the had data of each associated data table again.When each associated data Data in table attribute corresponding with associated data table is consistent, then illustrates that associated data table verifies success again, and by each pass Connection tables of data is stored in financial institution, completes the importing to business datum in assets APMB package.When in each associated data table Data unevenness attribute corresponding with associated data table is consistent, and there are a certain data attributes corresponding with its in a certain associated data table Inconsistent, then explanation verifies failure to associated data table again.It, can be according to failure for verifying the associated data table of failure again Rate decides whether to carry out storage operation to associated data table.When there are more data and its correspondence attribute are different in associated data table It causes, when failure rate is higher, then storage operation is not carried out to associated data table, and export prompt information.And when in associated data table There is only small part data attribute corresponding with its is inconsistent, when failure rate is lower, then by this and corresponding attribute is inconsistent lacks Partial data carries out delete operation, the accommodator associated in each associated data table according to the small part data, Jiang Geguan All data relevant to associated debt people are deleted in connection tables of data.Associated data table after delete operation is deposited Storage completes the importing to successful business datum is verified in assets APMB package through preliminary check and again, it is ensured that the industry imported Business data meet financial institution's requirement.
The service data guiding method of the present embodiment is receiving the request of the importing to assets packet, is first judging assets Bao Wen Whether part meets the field requirement of default template, only when the field for meeting default template requires, is just inserted into and default template Corresponding interim blank table, and the business datum in assets APMB package is imported into the interim blank table, form ephemeral data In table, financial institution is imported into avoid the assets APMB package for lacking field;And to each business number in temporary data table After preliminary check success, each business datum is split, each associated data table is generated;Again to each associated data table again It is secondary verify successfully after, each associated data table is stored, and completes the importing of each business datum in assets packet.Pass through setting pair The preliminary check of business datum and again verification scheme, the requirement by financial institution to business datum are arranged to each verification scheme In, it is ensured that each business datum imported meets the various requirement of financial institution, facilitates financial institution subsequent to business datum Working process.
Further, described by the assets Bao Wen in another embodiment of service data guiding method of the present invention Business datum in part is imported into the interim blank table, formed temporary data table the step of include:
Step S21 reads the business datum in the assets APMB package line by line, and to business number in the assets APMB package According to each required item carry out null value detection, judge in each required item whether there is assigning null data;
Understandably, for characterizing the business datum of every terms of information in every debt, during debt collection, some numbers According to for required item, and some is non-required item;Such as accommodator's contact method in business datum, amount owed etc. is required item, And accommodator's gender, accommodator's registered permanent residence location etc. are non-required item.Face business datum each in assets APMB package to be imported into When blank table in formed temporary data table during, need in each business datum required item carry out null value detection;Line by line The business datum in assets APMB package is read, judges to carry in business datum in each required item of required item identifier and whether deposit In assigning null data, which is the data that characterization does not carry any numerical value, that is, judges whether exist in each required item Corresponding numerical value.
Step S22, if there are assigning null data in each required item, inserting error tables of data, and by the null value number According to the business data transmission in source into the wrong data table;
When corresponding numerical value is not present in a certain item in each required item for judging business datum, i.e. the required item is null value When data, illustrate that the business datum is abnormal business datum, thus inserting error tables of data, and required item will be judged for sky The business data transmission of Value Data is into the wrong data table;It reads next line business datum and carries out null value detection, until assets Each business datum detects completion in APMB package.Reflect that each business personnel's data must be filled out in assets APMB package by wrong data table The data integrity of item embodies the quality height of assets APMB package;When the business datum stored in wrong data table is more, then Illustrate in assets APMB package there are required item be null value business datum amount it is more, assets APMB package is of poor quality;And work as error number It is fewer according to the business datum stored in table, then illustrate that there are the business datum amounts that required item is null value to get in assets APMB package Few, assets APMB package quality is better.Because each business datum being present in wrong data table is the incomplete abnormal traffic of information Data, without importeding into financial institution, to ensure to imported into the integrality of each business datum in financial institution.
Step S23 passes business datum in the assets APMB package if assigning null data is not present in each required item It is defeated into the interim blank table, formed temporary data table.
Further, when judging that each required item in business datum has corresponding numerical value, each required item is not deposited In assigning null data, each debt information for illustrating that business datum is characterized is complete, and by the business data transmission to interim empty In white table, as the business datum in temporary data table.All business datums in assets APMB package carry out null value detection Afterwards, all business datums being transferred in interim blank table, form temporary data table, believe debt each in the temporary data table It ceases complete business datum and carries out the import operation for importeding into financial institution.
Further, in another embodiment of service data guiding method of the present invention, the judgement is to the ephemeral data Include: after the successful step of the preliminary check of each business datum in table
Step S50, reads the number of the assets APMB package, and judges whether there is the identical repetition with the number and compile Number, it is identical with the number if it exists to repeat to number, then stop the importing to business datum in the assets APMB package;
Understandably, financial institution is arranged different assets APMB packages to distinguish to each assets APMB package There is different numbers, and in import operation, duplicate import operation may be carried out to assets APMB package.In order to avoid repeating to lead Enter, to before splitting through the successful assets APMB package of preliminary check, reads the number of assets APMB package, and judge server In with the presence or absence of it is identical with the number of the reading repeat number;Identical repetition is numbered if it exists to number, then illustrates server Import operation was carried out to the business datum in the assets APMB package before, current import operation is to repeat to import, and stop Importing to each business datum in assets APMB package.
Step S60, it is identical with the number if it does not exist to repeat to number, then it is inserted into each field information table, to generate State associated data table.
And work as and judge to be not present and number in server identical repetition number, then illustrate server before not to this Business datum in assets APMB package carries out import operation, then is inserted into each field information table, and be arranged to each field information table and unite One number to characterize the corresponding relationship between each field information table and the assets APMB package of the importing, and provides subsequent judgement It whether is the foundation for repeating to import.Wherein field information table is the data for the had data of field each in storage service data Table, for a field information table for storing data corresponding to a kind of field, such as storing field in each business datum is " accommodator The tables of data of name " corresponding data, i.e., the data stored in the tables of data are the name letter of each accommodator in each business datum Breath.All data in business datum is split according to field, and is stored in each field information table, association can be formed Tables of data.Specifically, the step of splitting to the business datum in temporary data table, generating each associated data table include:
Step S34 is based on preset field to each business datum in the temporary data table and splits, and obtains each Field data;
It also include various types of data such as non-required item data because including required item data in business datum, for wherein Certain data, possible financial institution do not need;In order to make the business datum imported better meet the requirement of financial institution, Preset required preset field.Preset field is based on to each business datum in temporary data table to split, and is obtained Each field data, the field data are data corresponding with preset field in presence and business datum.If preset field is w1, w2 And w3, the field in business datum includes w1, w2, s1, s2 and w3, and corresponding data are p1, p2, p3, p4 and p5;Then it is based on W1, w2, w3 are split, and corresponding each field data p1, p2, p5 can be obtained.
Step S35, according to the corresponding relationship between the preset field and each field information table, by each field Data are transferred in each field information table, generate each associated data table.
Further, because field information table is related to field type, and preset field characterizes the required word of financial institution Section, to have corresponding relationship between field information table and preset field.It splits to obtain each field data according to preset field Afterwards, according to the corresponding relationship between the preset field and field information table, each field data is transferred in field information table, After the field data respectively split is transferred to field information table, each field information table is formed according to the accommodator in each business datum Associated data table with correlation.Such as above-mentioned preset field w1, w2, w3, if corresponding field information table be respectively q1, Field data p1 is then transferred in q1 by q2 and q3, and field data p2 is transferred in q2, and field data p3 is transferred to q3 In, to form each associated data table.
Further, described to each associated data table in another embodiment of service data guiding method of the present invention The step of being verified again include:
Step S41, reads each field data in each associated data table one by one, and with each incidence number According to the corresponding preset data attribute of table;
Further, because attribute corresponding to different associated data tables is not identical, and belong in same associated data table Each field data is required to consistent with the attribute;In order to characterize attribute corresponding to each associated data table, for each associated data Table is previously provided with preset data attribute;The preset data attribute of the associated data table at age is such as set as 0~120, identity card The preset data attribute of the associated data table of number is 18;Each age data should be in associated data table to characterize the age Between 0~120 year old, and each ID card No. is necessary for 18 in the associated data table of ID card No..Incidence number is read one by one According in table each field data and each associated data table corresponding to preset data attribute, to judge in each associated data table Whether the attribute of each field data is consistent with its preset data attribute.
The attribute of each field data and preset data attribute are based on the associated data table and carried out pair by step S42 Than, judge the field data attribute whether with the preset data attributes match, with to the associated data table carry out again Secondary verification;
Further, the attribute of each field data and each preset data attribute associated data table is based on to compare, Judge each field data attribute whether with preset data attributes match.It is based on what associated data table compared characterization wherein The preset data attribute that attribute for each field data with reading compares is related to associated data table;Read Field data derives from a certain associated data table, then is that the associated data table is corresponding default for the preset data attribute of comparison Data attribute;The attribute specification in the associated data table, realization pair are all satisfied with each field data ensured in associated data table The verification again of each field data in associated data table.
In addition, referring to figure 2., the present invention provides a kind of business datum gatherer, imports and fill in business datum of the present invention It sets in first embodiment, the business datum gatherer includes:
Judgment module 10, for judging that the assets APMB package is when receiving the request of the importing to assets APMB package The no field requirement for meeting default template;
Import modul 20 is inserted into corresponding with the default template if the field for meeting the default template requires Interim blank table, and the business datum in the assets APMB package is imported into the interim blank table, forms nonce According to table;
Module 30 is split, for carrying out preliminary check to the business datum each in the temporary data table, and described After preliminary check success, the business datum each in the temporary data table is split, each associated data table is generated;
Memory module 40, for being verified again to each associated data table, and it is described verify successfully again after, Each associated data table is stored, the importing of the business datum is completed.
The business datum gatherer of the present embodiment is receiving the request of the importing to assets packet, and judgment module 10 is first sentenced Whether disconnected assets APMB package meets the field requirement of default template, only when the field for meeting default template requires, imports mould Block 20 is just inserted into interim blank table corresponding with default template, and the business datum in assets APMB package is imported into the interim sky In white table, is formed in temporary data table, imported into financial institution to avoid the assets APMB package for lacking field;And to interim After each business datum preliminary check success in tables of data, splits module 30 and each business datum is split, generate each association Tables of data;Again after the success of verification again to each associated data table, memory module 40 stores each associated data table, and Complete the importing of each business datum in assets packet.It, will be golden by being arranged to the preliminary check of business datum and verification scheme again Melt requirement of the mechanism to business datum to be arranged into each verification scheme, it is ensured that each business datum imported meets financial institution Various requirement, facilitate financial institution subsequent to the working process of business datum.
Further, in another embodiment of business datum gatherer of the present invention, the import modul includes:
Judging unit, for reading the business datum in the assets APMB package line by line, and in the assets APMB package Each required item of business datum carries out null value detection, judges in each required item with the presence or absence of assigning null data;
Be inserted into unit, if in each required item there are assigning null data, inserting error tables of data, and by the sky The business data transmission in Value Data source is into the wrong data table;
Transmission unit, if for assigning null data to be not present in each required item, by the industry in the assets APMB package Business data are transferred in the interim blank table, form temporary data table.
Further, in another embodiment of business datum gatherer of the present invention, the fractionation module is also used to:
Each business datum in the temporary data table is traversed, is detected each described in the temporary data table Whether the data format of business datum is consistent with preset format;
If the data format and the preset format are consistent, determine to the business each in the temporary data table The preliminary check success of data;
If the data format is uneven consistent with the preset format, determine to the industry each in the temporary data table The preliminary check failure for data of being engaged in.
Further, in another embodiment of business datum gatherer of the present invention, the business datum gatherer is also Include:
Read module for reading the number of the assets APMB package, and judges whether there is identical with the number It repeats to number, it is identical with the number if it exists to repeat to number, then stop leading business datum in the assets APMB package Enter;
Generation module repeats to number, then each field information table is inserted into, with life for identical with the number if it does not exist At the associated data table.
Further, in another embodiment of business datum gatherer of the present invention, the fractionation module further include:
Split cells is split for being based on preset field to each business datum in the temporary data table, Obtain each field data;
Generation unit, for according to the corresponding relationship between the preset field and each field information table, Jiang Gesuo It states field data to be transferred in each field information table, generates each associated data table.
Further, in another embodiment of business datum gatherer of the present invention, the memory module further include:
Reading unit, for reading each field data in each associated data table one by one, and with it is each described The corresponding preset data attribute of associated data table;
Comparison unit, for by the attribute of each field data and preset data attribute be based on the associated data table into Row comparison, judge the field data attribute whether with the preset data attributes match, with to the associated data table into Row verifies again.
Further, in another embodiment of business datum gatherer of the present invention, the judgment module is also used to:
Judge whether the file format of the assets APMB package is identical as the default file format of the default template, if institute It states that file format is identical as the default file format, then reads the file field of the assets APMB package, and by the file The field of field and the default template requires comparison, to judge whether the assets APMB package meets the word of the default template Duan Yaoqiu;
If the assets APMB package meets the field requirement of the default template, insertion and the default template pair are executed The step of interim blank table answered;
If the assets APMB package is unsatisfactory for the field requirement of the default template, the assets APMB package and institute are grabbed The difference field between default template is stated, the difference field is added in prompt information, and export the prompt information.
Wherein, each virtual functions module of above-mentioned business datum gatherer is stored in the importing of business datum shown in Fig. 3 and sets In standby memory 1005, when processor 1001 executes business datum importing program, modules in embodiment illustrated in fig. 2 are realized Function.
Referring to Fig. 3, Fig. 3 is the device structure schematic diagram for the hardware running environment that present invention method is related to.
Business datum of the embodiment of the present invention, which imports equipment, can be PC (personal computer, personal computer), It can be the terminal devices such as smart phone, tablet computer, E-book reader, portable computer.
As shown in figure 3, it may include: processor 1001, such as CPU (Central that the business datum, which imports equipment, Processing Unit, central processing unit), memory 1005, communication bus 1002.Wherein, communication bus 1002 for realizing Connection communication between processor 1001 and memory 1005.Memory 1005 can be high-speed RAM (random access Memory, random access memory), it is also possible to stable memory (non-volatile memory), such as disk storage Device.Memory 1005 optionally can also be the storage device independently of aforementioned processor 1001.
Optionally, it can also include user interface, network interface, camera, RF (Radio which, which imports equipment, Frequency, radio frequency) circuit, sensor, voicefrequency circuit, WiFi (Wireless Fidelity, WiMAX) module etc.. User interface may include display screen (Display), input unit such as keyboard (Keyboard), and optional user interface can be with Including standard wireline interface and wireless interface.Network interface optionally may include standard wireline interface and wireless interface (such as WI-FI interface).
It does not constitute it will be understood by those skilled in the art that business datum shown in Fig. 3 imports device structure to business Data import the restriction of equipment, may include perhaps combining certain components or different than illustrating more or fewer components Component layout.
As shown in figure 3, as may include operating system, net in a kind of memory 1005 of computer readable storage medium Network communication module and business datum import program.Operating system is to manage and control business datum to import device hardware and software The program of resource supports business datum to import the operation of program and other softwares and/or program.Network communication module is for real Communication between the existing 1005 each component in inside of reservoir, and import in equipment with business datum and lead between other hardware and softwares Letter.
Business datum shown in Fig. 3 imports in equipment, and processor 1001 is for executing the industry stored in memory 1005 Data of being engaged in import program, realize the step in each embodiment of above-mentioned service data guiding method.
The present invention provides a kind of computer readable storage medium, the computer-readable recording medium storage have one or More than one program of person, the one or more programs can also be executed by one or more than one processor with Step in the above-mentioned each embodiment of service data guiding method of realization.
It should also be noted that, herein, the terms "include", "comprise" or its any other variant are intended to non- It is exclusive to include, so that the process, method, article or the device that include a series of elements not only include those elements, It but also including other elements that are not explicitly listed, or further include solid by this process, method, article or device Some elements.In the absence of more restrictions, the element limited by sentence "including a ...", it is not excluded that including There is also other identical elements in the process, method of the element, article or device.
The serial number of the above embodiments of the invention is only for description, does not represent the advantages or disadvantages of the embodiments.
Through the above description of the embodiments, those skilled in the art can be understood that above-described embodiment side Method can be realized by means of software and necessary general hardware platform, naturally it is also possible to by hardware, but in many cases The former is more preferably embodiment.Based on this understanding, technical solution of the present invention substantially in other words does the prior art The part contributed out can be embodied in the form of software products, which is stored in one as described above In computer readable storage medium (such as ROM/RAM, magnetic disk, CD), including some instructions are used so that a terminal device (can To be mobile phone, computer, server or the network equipment etc.) execute method described in each embodiment of the present invention.
The above description is only a preferred embodiment of the present invention, is not intended to limit the scope of the invention, all at this Under the design of invention, using equivalent structure transformation made by description of the invention and accompanying drawing content, or directly/it is used in it indirectly He is included in scope of patent protection of the invention relevant technical field.

Claims (10)

1. a kind of service data guiding method, which is characterized in that the service data guiding method the following steps are included:
When receiving the request of the importing to assets APMB package, judge whether the assets APMB package meets the field of default template It is required that;
If meeting the field requirement of the default template, insertion interim blank table corresponding with the default template, and by institute It states the business datum in assets APMB package to imported into the interim blank table, forms temporary data table;
Preliminary check is carried out to the business datum each in the temporary data table, and after preliminary check success, to institute It states each business datum in temporary data table to be split, generates each associated data table;
Each associated data table is verified again, and it is described verify successfully again after, to each associated data table It is stored, completes the importing of the business datum.
2. service data guiding method as described in claim 1, which is characterized in that the industry by the assets APMB package Business data imported into the interim blank table, formed temporary data table the step of include:
The business datum in the assets APMB package is read line by line, and to each required item of business datum in the assets APMB package Null value detection is carried out, is judged in each required item with the presence or absence of assigning null data;
If there are assigning null data in each required item, inserting error tables of data, and will be described in the assigning null data source Business data transmission is into the wrong data table;
If assigning null data is not present in each required item, the business data transmission in the assets APMB package is faced described in When blank table in, formed temporary data table.
3. service data guiding method as described in claim 1, which is characterized in that described to institute each in the temporary data table Stating the step of business datum carries out preliminary check includes:
Each business datum in the temporary data table is traversed, each business in the temporary data table is detected Whether the data format of data is consistent with preset format;
If the data format and the preset format are consistent, determine to the business datum each in the temporary data table Preliminary check success;
If the data format is uneven consistent with the preset format, determine to the business number each in the temporary data table According to preliminary check failure.
4. service data guiding method as claimed in claim 3, which is characterized in that the judgement is in the temporary data table Include: after the successful step of the preliminary check of each business datum
Read the number of the assets APMB package, and judge whether there is with it is described number it is identical repeat number, if it exists with The number is identical to be repeated to number, then stops the importing to business datum in the assets APMB package;
It is identical with the number if it does not exist to repeat to number, then it is inserted into each field information table, to generate the associated data table.
5. service data guiding method as claimed in claim 4, which is characterized in that the institute in the temporary data table The step of stating business datum to be split, generating each associated data table include:
Preset field is based on to each business datum in the temporary data table to split, and obtains each field data;
According to the corresponding relationship between the preset field and each field information table, each field data is transferred to respectively In the field information table, each associated data table is generated.
6. service data guiding method as claimed in claim 5, which is characterized in that described to be carried out to each associated data table Again verify the step of include:
Each field data in each associated data table is read one by one, and corresponding pre- with each associated data table If data attribute;
The attribute of each field data and preset data attribute are based on the associated data table to compare, judge the word The attribute of segment data whether with the preset data attributes match, to be verified again to the associated data table.
7. service data guiding method as claimed in any one of claims 1 to 6, which is characterized in that the judgement assets packet File whether meet default template field require the step of include:
Judge whether the file format of the assets APMB package is identical as the default file format of the default template, if the text Part format is identical as the default file format, then reads the file field of the assets APMB package, and by the file field Comparison is required with the field of the default template, is wanted with judging whether the assets APMB package meets the field of the default template It asks;
If the assets APMB package meets the field requirement of the default template, it is corresponding with the default template to execute insertion The step of interim blank table;
If the assets APMB package is unsatisfactory for the field requirement of the default template, the assets APMB package and described pre- is grabbed If the difference field is added in prompt information, and exports the prompt information by the difference field between template.
8. a kind of business datum gatherer, which is characterized in that the business datum gatherer includes:
Judgment module, for judging whether the assets APMB package meets when receiving the request of the importing to assets APMB package The field requirement of default template;
Import modul is inserted into corresponding with the default template interim if the field for meeting the default template requires Blank table, and the business datum in the assets APMB package is imported into the interim blank table, form temporary data table;
Module is split, for carrying out preliminary check to the business datum each in the temporary data table, and in the preliminary school After testing successfully, the business datum each in the temporary data table is split, each associated data table is generated;
Memory module, for being verified again to each associated data table, and it is described verify successfully again after, to each institute It states associated data table to be stored, completes the importing of the business datum.
9. a kind of business datum imports equipment, which is characterized in that the business datum import equipment include: memory, processor, Communication bus and the business datum being stored on the memory import program;
The communication bus is for realizing the connection communication between processor and memory;
The processor imports program for executing the business datum, to realize as of any of claims 1-7 The step of service data guiding method.
10. a kind of computer readable storage medium, which is characterized in that be stored with business number on the computer readable storage medium According to program is imported, the business datum is imported when program is executed by processor and is realized as of any of claims 1-7 The step of service data guiding method.
CN201811207539.9A 2018-10-16 2018-10-16 Service data guiding method, device, equipment and computer readable storage medium Pending CN109635017A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201811207539.9A CN109635017A (en) 2018-10-16 2018-10-16 Service data guiding method, device, equipment and computer readable storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201811207539.9A CN109635017A (en) 2018-10-16 2018-10-16 Service data guiding method, device, equipment and computer readable storage medium

Publications (1)

Publication Number Publication Date
CN109635017A true CN109635017A (en) 2019-04-16

Family

ID=66066451

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201811207539.9A Pending CN109635017A (en) 2018-10-16 2018-10-16 Service data guiding method, device, equipment and computer readable storage medium

Country Status (1)

Country Link
CN (1) CN109635017A (en)

Cited By (11)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110471901A (en) * 2019-07-11 2019-11-19 平安科技(深圳)有限公司 Data lead-in method and terminal device
CN110515923A (en) * 2019-08-15 2019-11-29 福建中信网安信息科技有限公司 Data migration method and system between a kind of distributed data base
CN110765118A (en) * 2019-10-21 2020-02-07 北京明略软件系统有限公司 Data revision method, revision device and readable storage medium
CN111143450A (en) * 2019-12-13 2020-05-12 远光软件股份有限公司 Method and device for importing data
CN111626865A (en) * 2020-05-22 2020-09-04 泰康保险集团股份有限公司 Data processing method and device, electronic equipment and storage medium
CN111625586A (en) * 2020-05-27 2020-09-04 北京思特奇信息技术股份有限公司 Method and system for importing general service data
CN111859884A (en) * 2020-05-29 2020-10-30 大数金科网络技术有限公司 Statistical method for full history stack of approval data
CN112347201A (en) * 2020-11-26 2021-02-09 德联易控科技(北京)有限公司 Information processing method, information processing device and terminal equipment
CN113722277A (en) * 2020-05-25 2021-11-30 中兴通讯股份有限公司 Data import method, device, service platform and storage medium
CN114462903A (en) * 2022-04-14 2022-05-10 四川省大数据中心 Water, electricity and gas business applying system
CN115564550A (en) * 2022-12-07 2023-01-03 深圳市中政汇智管理咨询有限公司 Standard inspection method, device, equipment and storage medium for financial business data

Cited By (16)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110471901A (en) * 2019-07-11 2019-11-19 平安科技(深圳)有限公司 Data lead-in method and terminal device
CN110471901B (en) * 2019-07-11 2024-05-07 平安科技(深圳)有限公司 Data importing method and terminal equipment
CN110515923A (en) * 2019-08-15 2019-11-29 福建中信网安信息科技有限公司 Data migration method and system between a kind of distributed data base
CN110515923B (en) * 2019-08-15 2022-12-06 福建中信网安信息科技有限公司 Data migration method and system between distributed databases
CN110765118B (en) * 2019-10-21 2022-05-17 北京明略软件系统有限公司 Data revision method, revision device and readable storage medium
CN110765118A (en) * 2019-10-21 2020-02-07 北京明略软件系统有限公司 Data revision method, revision device and readable storage medium
CN111143450A (en) * 2019-12-13 2020-05-12 远光软件股份有限公司 Method and device for importing data
CN111626865A (en) * 2020-05-22 2020-09-04 泰康保险集团股份有限公司 Data processing method and device, electronic equipment and storage medium
CN111626865B (en) * 2020-05-22 2023-10-03 泰康保险集团股份有限公司 Data processing method, device, electronic equipment and storage medium
CN113722277A (en) * 2020-05-25 2021-11-30 中兴通讯股份有限公司 Data import method, device, service platform and storage medium
CN111625586A (en) * 2020-05-27 2020-09-04 北京思特奇信息技术股份有限公司 Method and system for importing general service data
CN111859884A (en) * 2020-05-29 2020-10-30 大数金科网络技术有限公司 Statistical method for full history stack of approval data
CN112347201B (en) * 2020-11-26 2021-05-18 德联易控科技(北京)有限公司 Information processing method, information processing device and terminal equipment
CN112347201A (en) * 2020-11-26 2021-02-09 德联易控科技(北京)有限公司 Information processing method, information processing device and terminal equipment
CN114462903A (en) * 2022-04-14 2022-05-10 四川省大数据中心 Water, electricity and gas business applying system
CN115564550A (en) * 2022-12-07 2023-01-03 深圳市中政汇智管理咨询有限公司 Standard inspection method, device, equipment and storage medium for financial business data

Similar Documents

Publication Publication Date Title
CN109635017A (en) Service data guiding method, device, equipment and computer readable storage medium
CN107908485A (en) Interface parameters transmission method, device, equipment and computer-readable recording medium
CN107341109B (en) Test data generation method and system
CN107894952A (en) Generation method, device, equipment and the readable storage medium storing program for executing of interface testing use-case
CN109474578A (en) Message method of calibration, device, computer equipment and storage medium
CN108255653A (en) The test method and its terminal of a kind of product
CN108984712A (en) Counting method, equipment and readable storage medium storing program for executing are made based on business scenario
CN111506444A (en) Form approval method and device, storage medium and electronic equipment
CN109634996A (en) Customer information table generating method, device, equipment and computer readable storage medium
CN109814856A (en) Data entry method, device, terminal and computer readable storage medium
CN108335237A (en) It puts on record method, terminal and computer readable storage medium
CN109634950A (en) Service data management method, device, equipment and computer readable storage medium
WO2020077836A1 (en) Service data management method, apparatus and device, and computer-readable storage medium
CN113256408A (en) Risk control method and system based on consumption finance and computer equipment
CN111124917A (en) Public test case management and control method, device, equipment and storage medium
CN105138499A (en) Data processing method and apparatus and terminal
CN110515755A (en) Interface function verification method, device, equipment and computer readable storage medium
CN107423223A (en) Test and management system
CN108133069A (en) Integrated circuit back-end design system and method
CN109636594A (en) Assets package management method, device, equipment and storage medium based on big data
CN107644263A (en) Method and server are handled in banking reservation
CN110515924A (en) Database manipulation logic verify method, apparatus, equipment and readable storage medium storing program for executing
CN109492031A (en) Display methods, server and the computer storage medium of list data
CN112651716A (en) Data processing method, device and storage medium
CN112433935A (en) Test method, test device, electronic 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