CN108363751B - A kind of detection method and system of public accumalation fund for housing construction operation system - Google Patents
A kind of detection method and system of public accumalation fund for housing construction operation system Download PDFInfo
- Publication number
- CN108363751B CN108363751B CN201810085422.1A CN201810085422A CN108363751B CN 108363751 B CN108363751 B CN 108363751B CN 201810085422 A CN201810085422 A CN 201810085422A CN 108363751 B CN108363751 B CN 108363751B
- Authority
- CN
- China
- Prior art keywords
- data
- storehouse
- tables
- standard
- table storehouse
- 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.)
- Active
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/02—Banking, e.g. interest calculation or account maintenance
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Systems or methods specially adapted for specific business sectors, e.g. utilities or tourism
- G06Q50/10—Services
- G06Q50/26—Government or public services
Abstract
The invention discloses the detection methods and system of a kind of public accumalation fund for housing construction operation system, table in public accumulation fund data Table storehouse and standard Table storehouse is matched, tables of data corresponding with the table in standard Table storehouse and composition target data Table storehouse are found in public accumulation fund data Table storehouse, the incidence relation of each table in target data Table storehouse is established, then search the data of each table in target data Table storehouse according to preset rules and verifies whether corresponding data meets preset standard.Can target data Table storehouse corresponding with the table in standard Table storehouse be found in public accumulation fund data Table storehouse automatically, the relationship established between target matrix Ku Gebiao can be automated, the data of each table of target data Table storehouse can be searched automatically according to preset rules and are verified, provide examining report, common reserve fund operation system suitable for different designs detects, for going to design a set of testing process compared to the common reserve fund operation system for each different designs, by effective raising applicability, development cost is greatly reduced, accelerates detection speed.
Description
Technical field
The present invention relates to database technical fields, a kind of detection method more particularly, to public accumalation fund for housing construction operation system and
System.
Background technique
Currently, domestic public accumalation fund for housing construction operation system is the business demand and characteristic by various regions according to itself, oneself master
Hold construction.At this stage, state, which lives the national common reserve fund operation system of the portion's of building requirement, must access the unified platform, and propose a set of
Standard, it is desirable that the data format of related public accumulation fund data table is met the requirements of the standard, and there is no any detections on the market
Tool detects whether public accumalation fund for housing construction operation system has reached standard.
Due to the difference of the developer of various regions public accumalation fund for housing construction operation system, system database logic and structure not phases
Together, standard whether is had reached if necessary to detection public accumalation fund for housing construction operation system, common practice can be for various regions
Each system goes individually designed a set of detection system.But it does so and takes time and effort very much, testing cost will be significantly increased.
Summary of the invention
It is an object of the invention to overcome above-mentioned technical deficiency, a kind of detection method of public accumalation fund for housing construction operation system is proposed
And system, solve above-mentioned technical problem in the prior art.
To reach above-mentioned technical purpose, technical solution of the present invention provides a kind of detection side of public accumalation fund for housing construction operation system
Method, comprising:
S1, the table in public accumulation fund data Table storehouse and standard Table storehouse is matched, is looked in the public accumulation fund data Table storehouse
To tables of data corresponding with the table in the standard Table storehouse and composition target data Table storehouse；
S2, the incidence relation for establishing each table in target data Table storehouse；
S3, according to preset rules search target data Table storehouse in each table data and verify corresponding data whether meet it is default
Standard；
S4, examining report is generated according to verification result.
The present invention also provides a kind of detection systems of public accumalation fund for housing construction operation system, comprising:
Matching module: the table in public accumulation fund data Table storehouse and standard Table storehouse is matched, in the public accumulation fund data table
Tables of data corresponding with the table in the standard Table storehouse and composition target data Table storehouse are found in library；
Incidence relation establishes module: establishing the incidence relation of each table in target data Table storehouse；
Detection module: the data of each table in target data Table storehouse are searched according to preset rules and verify whether corresponding data accords with
Close preset standard；
Examining report generation module: examining report is generated according to verification result, wherein public accumulation fund data Table storehouse in step S1
Matching step with the table in standard Table storehouse includes:
The table name of each table forms the first table name set, the table name in the first table name set in S11, the standard Table storehouse
Mapping relations are established with the table in java standard library table, the table name of each table of the public accumulation fund data Table storehouse forms the second table name set,
The table in table name and public accumulation fund data Table storehouse in the second table name set establishes mapping relations, in the second table name set
The middle table name searched in the first table name set, finding table name is third table name set, each table name in the third table name set
Tables of data in corresponding public accumulation fund data Table storehouse is the first data Table storehouse；
Each table is equipped with primary fields, secondary field, the first table name set and third table name collection in S12, the standard Table storehouse
The difference set of conjunction is the 4th table name set, and the tables of data in the 4th table name set in the corresponding standard Table storehouse of each table name is second
Data Table storehouse；Screening is carried out to public accumulation fund data Table storehouse according to the primary fields of each tables of data in the second data Table storehouse to obtain
Several preliminary screening Table storehouses are taken, the tables of data of each preliminary screening Table storehouse and a second data Table storehouse establishes mapping relations,
Each tables of data in the preliminary screening Table storehouse all has the tables of data of the corresponding second data Table storehouse of the preliminary screening Table storehouse
Primary fields；The data of corresponding preliminary screening Table storehouse are calculated according to the secondary field of the tables of data of the second data Table storehouse
The matching degree of table selects in each preliminary screening Table storehouse the highest tables of data of matching degree as matching result table, each matching result
The union of table composition third data Table storehouse, the first data Table storehouse and the third data Table storehouse is target data Table storehouse, institute
State the secondary word of the field for the tables of data that matching degree is preliminary screening Table storehouse and a tables of data of corresponding second data Table storehouse
The registration of section.
Compared with prior art, the beneficial effect comprise that by the table in public accumulation fund data Table storehouse and standard Table storehouse
It is matched, tables of data corresponding with the table in the standard Table storehouse and composition target is found in the public accumulation fund data Table storehouse
Data Table storehouse establishes the incidence relation of each table in target data Table storehouse after obtaining target data Table storehouse, then according to default rule
It then searches the data of each table in target data Table storehouse and verifies whether corresponding data meets preset standard, generated according to verification result
Examining report, data format, the data of each table of examining report displaying target data Table storehouse settle accounts testing result.It can be automatically in public affairs product
Golden number finds target data Table storehouse corresponding with the table in standard Table storehouse according to Table storehouse, can automate and establish target matrix Ku Gebiao
Between relationship, can automatically according to preset rules search each table of target data Table storehouse data and verified, provide detection report
It accuses, the common reserve fund operation system suitable for different designs detects, and goes compared to the common reserve fund operation system for each different designs
For designing a set of testing process, by effective raising applicability, development cost is greatly reduced, accelerates detection speed.
Detailed description of the invention
Fig. 1 is a kind of detection method flow chart of public accumalation fund for housing construction operation system provided by the invention；
Fig. 2 is a kind of detection system structural block diagram of public accumalation fund for housing construction operation system provided by the invention；
Fig. 3 is the tables of data incidence relation schematic diagram in the specific embodiment of the invention.
In attached drawing: 1, the detection system of public accumalation fund for housing construction operation system, 11, matching module, 12, incidence relation establish mould
Block, 13, detection module, 14, examining report generation module.
Specific embodiment
In order to make the objectives, technical solutions, and advantages of the present invention clearer, with reference to the accompanying drawings and embodiments, right
The present invention is further elaborated.It should be appreciated that the specific embodiments described herein are merely illustrative of the present invention, and
It is not used in the restriction present invention.
As shown in Figure 1, the present invention provides a kind of detection methods of public accumalation fund for housing construction operation system, comprising:
S1, the table in public accumulation fund data Table storehouse and standard Table storehouse is matched, is looked in the public accumulation fund data Table storehouse
To tables of data corresponding with the table in the standard Table storehouse and composition target data Table storehouse；
S2, the incidence relation for establishing each table in target data Table storehouse；
S3, according to preset rules search target data Table storehouse in each table data and verify corresponding data whether meet it is default
Standard；
S4, examining report is generated according to verification result.
The detection method of public accumalation fund for housing construction operation system of the present invention, in step S1: public accumalation fund for housing construction operation system
A large amount of public accumulation fund data tables can be generated in the process of running, and a large amount of public accumulation fund data tables form public accumulation fund data Table storehouse, common reserve fund
Data Table storehouse includes business account tables of data (unit business managing detailed catalogue table, personal business managing detailed catalogue table, loans extended to individual housing purchasers industry
Be engaged in managing detailed catalogue table etc.), bank's account tables of data (bank settlement flowing water information table, bank account journal information table etc.), financial account number
According to table (bookkeeping voucher information table etc.)；Standard Table storehouse includes that " house town and country construction general office, portion is long-pending about house public affairs are carried out
The notice of gold base data standard " in live build 29 standard scales as defined in portion, defined in each standard scale standard scale table name, mark
Quasi- tableau format (such as field name, each field data value range, special field rule, each field data types etc.), firmly builds
The tables of data that portion defines the generation of public accumalation fund for housing construction operation system in the form of standard scale needs the content comprising which table, and
The data format for the table that regulation includes.
The detection method of public accumalation fund for housing construction operation system of the present invention, public accumulation fund data Table storehouse and standard in step S1
The matching step of table in Table storehouse includes:
The table name of each table forms the first table name set, table name and java standard library in the first table name set in S11, standard Table storehouse
Table in table establishes mapping relations, and the table name of each table of public accumulation fund data Table storehouse forms the second table name set, the second table name set
In table name and public accumulation fund data Table storehouse in table establish mapping relations, searched in the second table name set in the first table name set
Table name, finding table name is third table name set, in third table name set in the corresponding public accumulation fund data Table storehouse of each table name
Tables of data is the first data Table storehouse；
Each table is equipped with primary fields in S12, standard Table storehouse, secondary field (provides in the standard scale that standard Table storehouse contains
Which field of standard scale is primary fields, which field is secondary field, and primary fields/secondary field is one or more words
Section), the difference set of the first table name set and third table name set is the 4th table name set, and each table name is corresponding in the 4th table name set
Tables of data in standard Table storehouse is the second data Table storehouse；
If carrying out screening acquisition to public accumulation fund data Table storehouse according to the primary fields of each tables of data in the second data Table storehouse
The tables of data of dry preliminary screening Table storehouse, each preliminary screening Table storehouse and a second data Table storehouse establishes mapping relations, tentatively
Each tables of data in screening Table storehouse all has the main word of the tables of data of the corresponding second data Table storehouse of the preliminary screening Table storehouse
Section；
Of the tables of data of corresponding preliminary screening Table storehouse is calculated according to the secondary field of the tables of data of the second data Table storehouse
With degree, selects the highest tables of data of matching degree in each preliminary screening Table storehouse and formed as matching result table, each matching result table
The union of third data Table storehouse, the first data Table storehouse and third data Table storehouse is target data Table storehouse, and matching degree is preliminary screening
The registration of the secondary field of one tables of data of the field of one tables of data of Table storehouse and corresponding second data Table storehouse；
Specifically, step S11 realization found according to table table name each in standard Table storehouse it is corresponding in public accumulation fund data Table storehouse
Table；If the table name of the part of standards table in standard Table storehouse does not find corresponding table in public accumulation fund data Table storehouse, such
The collection of standard scale is combined into the second data Table storehouse, then realizing the master according to each standard scale in the second data Table storehouse using step S12
Field, secondary field is wanted to search corresponding table in public accumulation fund data Table storehouse, specific method is first to carry out first according to primary fields
Secondary screening public accumulation fund data Table storehouse carries out second further according to the selection result (preliminary screening Table storehouse) of the secondary field to first time
Screening:
Screen for the first time: each standard scale all has primary fields in the second data Table storehouse, in public accumulation fund data Table storehouse
The table that field includes the primary fields of standard scale is filtered out, the public accumulation fund data Table storehouse of the primary fields comprising a standard scale
Table may have multiple, multiple tables one preliminary screening of composition of the public accumulation fund data Table storehouse of the primary fields comprising a standard scale
Table storehouse, then public accumulation fund data Table storehouse is searched according to the primary fields of the standard scale in each second data Table storehouse, if by obtaining
Preliminary screening Table storehouse is done, the standard scale in each preliminary screening Table storehouse and a second data Table storehouse is correspondingly, just
Each tables of data in step screening Table storehouse all has the primary fields of corresponding standard scale；
Programmed screening: the tables of data of each preliminary screening Table storehouse and a second data Table storehouse establishes mapping relations, root
(tables of data of the second data Table storehouse) corresponding preliminary screening table is calculated according to the secondary field of the tables of data of the second data Table storehouse
The matching degree of the tables of data in library, selects in each preliminary screening Table storehouse that the highest tables of data of matching degree is as matching result table, respectively
Matching result table forms third data Table storehouse, and third data Table storehouse is exactly the main word according to each standard scale in the second data Table storehouse
The standard scale that section, secondary field are found out corresponding table in public accumulation fund data Table storehouse；Matching degree is the one of preliminary screening Table storehouse
The registration of the secondary field of one tables of data of the field of tables of data and (the preliminary screening Table storehouse) corresponding second data Table storehouse,
A data sheet field and the registration of B data literary name section between two tables of data of A, B field number account for B data literary name
The percentage of section total number；
The union for the third data Table storehouse that the first data Table storehouse and step S12 that step S11 is obtained obtain is target data
Table storehouse, target data Table storehouse are each standard scale corresponding table in public accumulation fund data Table storehouse in standard Table storehouse, target data Table storehouse
The quantity of middle table is consistent with the quantity of standard scale in standard Table storehouse.
In above-mentioned technical proposal, after the completion of the table in public accumulation fund data Table storehouse and standard Table storehouse is matched, that is, realize
Target data Table storehouse corresponding with the table in standard Table storehouse is found in public accumulation fund data Table storehouse (will live in public accumulation fund data Table storehouse
The needs table that includes of portion's requirement of founding a capital is found out), the table in target data Table storehouse has the standard scale of corresponding standard Table storehouse,
Any content represent according to the table that the standard scale corresponded to is known that in target data Table storehouse.
The detection method of public accumalation fund for housing construction operation system of the present invention is established in step S2 each in target data Table storehouse
The step of incidence relation of table are as follows:
Each table of target data Table storehouse is traversed, if detecting has same major key between two tables in target data Table storehouse
Field or same unique identification field then establish major key field association or the association of unique identification field between two tables, otherwise,
Middle table incidence relation between two tables is searched, middle table association is established；
If all data of a field are all different each other in tables of data, which is unique identification field；
Specifically, associated two tables of middle table are associated by a middle table or multiple middle tables, for example, if
Data registration in A table a field and B table b field reaches 90% or more and then thinks a field and b field is middle table associated characters
Section, meanwhile, if the data registration in B table c field and C table d field reaches 90% or more, then it is assumed that c field and d field are
Middle table associate field, then, A table is associated with by B table with C table, and B table is middle table.Similarly, middle table can be multiple, example
If A table is associated with middle table B table, middle table B table is associated with middle table D table, and middle table D table is associated with C table, final A table and C table
It may be implemented to be associated by middle table B table, D table.
The detection method of public accumalation fund for housing construction operation system of the present invention, in step S3:
The data of each table in target data Table storehouse are searched according to preset rules and verify whether corresponding data meets pre- bidding
It is quasi-, wherein preset standard includes data format standard and data clearing standard；
Specifically, whether verifying corresponding data meets data format standard i.e.: corresponding in detection each table of target data Table storehouse
Value range, special field rule, the data type of respective field, value rule of respective field of field data etc., according to
The data format of the field of standard Table storehouse determines data format standard；Whether verifying corresponding data meets data clearing standard i.e.:
Whether inspection business account tables of data, bank's account tables of data, the incidence relation of financial account tables of data are normal；If find out this three
Related data in class table (business account tables of data, bank's account tables of data, financial account tables of data) can be checked unanimously, then three classes table
Between can achieve account balance (such as to find out the same business amount incurred than common reserve fund business in three classes table consistent, then
This in three classes table is that account balances than common reserve fund business), it can achieve account balance between three classes table then between three classes table
Incidence relation be it is normal, meet data clearing standard.
The step of detection method of public accumalation fund for housing construction operation system of the present invention, step S3 is executed -- " according to default
In rule searching target data Table storehouse the data of each table and verify whether corresponding data meets preset standard ", be in step S2--
It is carried out on the basis of " incidence relation for establishing each table in target data Table storehouse ", establishes the association of each table in target data Table storehouse
After relationship, just conjunctive query can be carried out between table each in target data Table storehouse according to preset rules.Preset rules are bases
Detection demand is preconfigured, searches the data of each table in target data Table storehouse according to preset rules and whether verifies corresponding data
Meet preset standard and be equivalent to and automatically generate a set of testing process, is verified according to rule searching corresponding data.
As shown in figure 3, " establishing target matrix in the detection method of public accumalation fund for housing construction operation system of the present invention
The incidence relation of each table in library searches the data of each table in target data Table storehouse according to preset rules and whether verifies corresponding data
Meet preset standard " specific embodiment are as follows: special bank account information table, cash in bank journal information table, bank settlement
Flowing water information table, bookkeeping voucher information table, detail account information table, general ledger information table are the table in target data Table storehouse, bank
Special family information table is associated with by special bank account number field with cash in bank journal information table, cash in bank journal information table
It is associated with by bank settlement serial number field with bank settlement flowing water information table, bank settlement flowing water information table passes through middle table
TB-1, middle table TB-C, middle table TC-1 are associated with bookkeeping voucher information table, and bank settlement flowing water information table has business flowing water
Number field, bookkeeping voucher information table have a bookkeeping voucher field, and bookkeeping voucher information table passes through bookkeeping voucher field and bright
The association of itemized account information table, detail account information table are associated with by symbolization of accounts field with general ledger information table；After incidence relation is established, silver
The special family information table of row, cash in bank journal information table, bank settlement flowing water information table, bookkeeping voucher information table, detail account letter
This six tables one series relationships of formation of table, general ledger information table are ceased, the phase in this six tables can be searched according to preset rules
Data are closed, related data verifies whether to meet preset standard after finding out, for example,
Bank settlement flowing water information table contains business serial number and business amount incurred field, bookkeeping voucher information table contain note
Account voucher number and business amount incurred field, a common reserve fund business can be in bank settlement flowing water information table, bookkeeping voucher information table
In generate a record, the corresponding business serial number of same common reserve fund business, bookkeeping voucher number are different, but same
Business amount incurred of the common reserve fund business in bank settlement flowing water information table, bookkeeping voucher information table should be identical；
The business serial number and business amount incurred that a record in bank settlement flowing water information table can be searched, search book keeping operation
It is corresponding to find out the bookkeeping voucher number according to bookkeeping voucher number for the corresponding bookkeeping voucher number of business serial number in credential information table
Whether consistent business amount incurred checks two business amounts incurred, if unanimously, meeting preset standard (data clearing standard).
As shown in Fig. 2, the present invention also provides a kind of detection systems 1 of public accumalation fund for housing construction operation system, comprising:
Matching module 11: the table in public accumulation fund data Table storehouse and standard Table storehouse is matched, in the public accumulation fund data
Tables of data corresponding with the table in the standard Table storehouse and composition target data Table storehouse are found in Table storehouse；
Incidence relation establishes module 12: establishing the incidence relation of each table in target data Table storehouse；
Detection module 13: the data of each table in target data Table storehouse are searched according to preset rules and whether verify corresponding data
Meet preset standard；
Examining report generation module 14: examining report is generated according to verification result.
The detection system 1 of public accumalation fund for housing construction operation system of the present invention, matching module 11 include:
Table name matching unit: the table name of each table forms the first table name set, the table in the first table name set in standard Table storehouse
Table in name and java standard library table establishes mapping relations, and the table name of each table of public accumulation fund data Table storehouse forms the second table name set, the
The table in table name and public accumulation fund data Table storehouse in two table name set establishes mapping relations, searches first in the second table name set
Table name in table name set, finding table name is third table name set, the corresponding common reserve fund number of each table name in third table name set
It is the first data Table storehouse according to the tables of data in Table storehouse；
Primary and secondary wants fields match unit: in standard Table storehouse each table be equipped with primary fields, secondary field, the first table name set and
The difference set of third table name set is the 4th table name set, the tables of data in the 4th table name set in the corresponding standard Table storehouse of each table name
For the second data Table storehouse；Public accumulation fund data Table storehouse is screened according to the primary fields of each tables of data in the second data Table storehouse
Several preliminary screening Table storehouses are obtained, the tables of data foundation mapping of each preliminary screening Table storehouse and a second data Table storehouse is closed
It is that each tables of data in preliminary screening Table storehouse all has the tables of data of the corresponding second data Table storehouse of the preliminary screening Table storehouse
Primary fields；Of the tables of data of corresponding preliminary screening Table storehouse is calculated according to the secondary field of the tables of data of the second data Table storehouse
With degree, selects the highest tables of data of matching degree in each preliminary screening Table storehouse and formed as matching result table, each matching result table
The union of third data Table storehouse, the first data Table storehouse and third data Table storehouse is target data Table storehouse, and matching degree is preliminary screening
The registration of the secondary field of one tables of data of the field of one tables of data of Table storehouse and corresponding second data Table storehouse.
The detection system 1 of public accumalation fund for housing construction operation system of the present invention, incidence relation are established in module 12:
Each table of target data Table storehouse is traversed, if detecting has same major key between two tables in target data Table storehouse
Field or same unique identification field then establish major key field association or the association of unique identification field between two tables, otherwise,
Middle table incidence relation between two tables is searched, middle table association is established.
The detection system 1 of public accumalation fund for housing construction operation system of the present invention, incidence relation are established in module 12:
Associated two tables of middle table are associated by a middle table or multiple middle tables, if a word in tables of data
All data of section are all different each other, then the field is unique identification field.
The detection system 1 of public accumalation fund for housing construction operation system of the present invention, in detection module 13:
Preset standard includes data format standard and data clearing standard.
Compared with prior art, the beneficial effect comprise that by the table in public accumulation fund data Table storehouse and standard Table storehouse
It is matched, tables of data corresponding with the table in the standard Table storehouse and composition target is found in the public accumulation fund data Table storehouse
Data Table storehouse establishes the incidence relation of each table in target data Table storehouse after obtaining target data Table storehouse, then according to default rule
It then searches the data of each table in target data Table storehouse and verifies whether corresponding data meets preset standard, generated according to verification result
Examining report, data format, the data of each table of examining report displaying target data Table storehouse settle accounts testing result.It can be automatically in public affairs product
Golden number finds target data Table storehouse corresponding with the table in standard Table storehouse according to Table storehouse, can automate and establish target matrix Ku Gebiao
Between relationship, can automatically according to preset rules search each table of target data Table storehouse data and verified, provide detection report
It accuses, the common reserve fund operation system suitable for different designs detects, and goes compared to the common reserve fund operation system for each different designs
For designing a set of testing process, by effective raising applicability, development cost is greatly reduced, accelerates detection speed.
The above described specific embodiments of the present invention are not intended to limit the scope of the present invention..Any basis
Any other various changes and modifications that technical concept of the invention is made should be included in the guarantor of the claims in the present invention
It protects in range.
Claims (8)
1. a kind of detection method of public accumalation fund for housing construction operation system characterized by comprising
S1, the table in public accumulation fund data Table storehouse and standard Table storehouse is matched, found in the public accumulation fund data Table storehouse and
The corresponding tables of data of table and composition target data Table storehouse in the standard Table storehouse；
S2, the incidence relation for establishing each table in the target data Table storehouse；
S3, the data of each table are searched in the target data Table storehouse according to preset rules and verify corresponding data whether meet it is default
Standard；
S4, examining report is generated according to verification result, wherein
Public accumulation fund data Table storehouse and the matching step of the table in standard Table storehouse include: in step S1
The table name of each table forms the first table name set, table name and mark in the first table name set in S11, the standard Table storehouse
Table in quasi- library table establishes mapping relations, and the table name of each table of the public accumulation fund data Table storehouse forms the second table name set, described
The table in table name and public accumulation fund data Table storehouse in second table name set establishes mapping relations, looks into the second table name set
The table name in the first table name set is looked for, finding table name is third table name set, and each table name is corresponding in the third table name set
Public accumulation fund data Table storehouse in tables of data be the first data Table storehouse；
Each table is equipped with primary fields, secondary field in S12, the standard Table storehouse, the first table name set and third table name set
Difference set is the 4th table name set, and the tables of data in the 4th table name set in the corresponding standard Table storehouse of each table name is the second data
Table storehouse；If carrying out screening acquisition to public accumulation fund data Table storehouse according to the primary fields of each tables of data in the second data Table storehouse
The tables of data of dry preliminary screening Table storehouse, each preliminary screening Table storehouse and a second data Table storehouse establishes mapping relations, described
Each tables of data in preliminary screening Table storehouse all has the master of the tables of data of the corresponding second data Table storehouse of the preliminary screening Table storehouse
Want field；The tables of data of corresponding preliminary screening Table storehouse is calculated according to the secondary field of the tables of data of the second data Table storehouse
Matching degree selects in each preliminary screening Table storehouse the highest tables of data of matching degree as matching result table, each matching result table group
At third data Table storehouse, the union of the first data Table storehouse and the third data Table storehouse is target data Table storehouse, described
The secondary field of one tables of data of field and corresponding second data Table storehouse with the tables of data that degree is preliminary screening Table storehouse
Registration.
2. the detection method of public accumalation fund for housing construction operation system as described in claim 1, which is characterized in that establish mesh in step S2
The step of marking the incidence relation of each table in data Table storehouse are as follows:
Traverse each table of the target data Table storehouse, if detect in the target data Table storehouse between two tables have it is same
Major key field or same unique identification field then establish major key field association or the association of unique identification field between two tables,
Otherwise, middle table incidence relation between two tables is searched, middle table association is established.
3. the detection method of public accumalation fund for housing construction operation system as claimed in claim 2, which is characterized in that in step S2:
Associated two tables of middle table are associated by a middle table or multiple middle tables, if a field in tables of data
All data are all different each other, then the field is the unique identification field.
4. the detection method of public accumalation fund for housing construction operation system as described in claim 1, which is characterized in that in step S3:
The preset standard includes data format standard and data clearing standard.
5. a kind of detection system of public accumalation fund for housing construction operation system characterized by comprising
Matching module: the table in public accumulation fund data Table storehouse and standard Table storehouse is matched, in the public accumulation fund data Table storehouse
Find tables of data corresponding with the table in the standard Table storehouse and composition target data Table storehouse；
Incidence relation establishes module: establishing the incidence relation of each table in the target data Table storehouse；
Detection module: the data of each table in the target data Table storehouse are searched according to preset rules and verify whether corresponding data accords with
Close preset standard；
Examining report generation module: examining report is generated according to verification result, wherein
Matching module includes:
Table name matching unit: the table name of each table forms the first table name set in the standard Table storehouse, in the first table name set
Table name and the java standard library table in table establish mapping relations, the table name of each table of the public accumulation fund data Table storehouse forms second
Table name set, the table in table name and the public accumulation fund data Table storehouse in the second table name set establishes mapping relations, in institute
The table name searched in the first table name set in the second table name set is stated, finding table name is third table name set, described the
Tables of data in three table name set in the corresponding public accumulation fund data Table storehouse of each table name is the first data Table storehouse；
Primary and secondary wants fields match unit: in the standard Table storehouse each table be equipped with primary fields, secondary field, the first table name set and
The difference set of third table name set is the 4th table name set, the number in the 4th table name set in the corresponding standard Table storehouse of each table name
It is the second data Table storehouse according to table；According to the primary fields of each tables of data in the second data Table storehouse to public accumulation fund data Table storehouse
It carries out screening and obtains several preliminary screening Table storehouses, the tables of data of each preliminary screening Table storehouse and a second data Table storehouse is established
Mapping relations, each tables of data in the preliminary screening Table storehouse all have the corresponding second data Table storehouse of the preliminary screening Table storehouse
Tables of data primary fields；Corresponding preliminary screening table is calculated according to the secondary field of the tables of data of the second data Table storehouse
The matching degree of the tables of data in library, selects in each preliminary screening Table storehouse that the highest tables of data of matching degree is as matching result table, respectively
The union of matching result table composition third data Table storehouse, the first data Table storehouse and the third data Table storehouse is target data
Table storehouse, the matching degree are the field of a tables of data of preliminary screening Table storehouse and a tables of data of corresponding second data Table storehouse
The registration of secondary field.
6. the detection system of public accumalation fund for housing construction operation system as claimed in claim 5, which is characterized in that incidence relation establishes mould
In block:
Each table of the target data Table storehouse is traversed, if detecting has same major key between two tables in target data Table storehouse
Field or same unique identification field then establish major key field association or the association of unique identification field between two tables, otherwise,
Middle table incidence relation between two tables is searched, middle table association is established.
7. the detection system of public accumalation fund for housing construction operation system as claimed in claim 6, which is characterized in that incidence relation establishes mould
In block:
Associated two tables of middle table are associated by a middle table or multiple middle tables, if a field in tables of data
All data are all different each other, then the field is the unique identification field.
8. the detection system of public accumalation fund for housing construction operation system as claimed in claim 5, which is characterized in that in detection module:
The preset standard includes data format standard and data clearing standard.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810085422.1A CN108363751B (en) | 2018-01-29 | 2018-01-29 | A kind of detection method and system of public accumalation fund for housing construction operation system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810085422.1A CN108363751B (en) | 2018-01-29 | 2018-01-29 | A kind of detection method and system of public accumalation fund for housing construction operation system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN108363751A CN108363751A (en) | 2018-08-03 |
| CN108363751B true CN108363751B (en) | 2019-08-27 |
Family
ID=63007428
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810085422.1A Active CN108363751B (en) | 2018-01-29 | 2018-01-29 | A kind of detection method and system of public accumalation fund for housing construction operation system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108363751B (en) |
Families Citing this family (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109284284A (en) * | 2018-09-07 | 2019-01-29 | 新华三大数据技术有限公司 | Data processing method and device |
| CN109871382A (en) * | 2019-02-13 | 2019-06-11 | 北京明略软件系统有限公司 | A kind of implementation method and device of tables of data access java standard library |
| CN109902083A (en) * | 2019-02-26 | 2019-06-18 | 北京明略软件系统有限公司 | Method, apparatus, computer storage medium and the terminal of a kind of pair of mark processing |
| CN110399403A (en) * | 2019-07-24 | 2019-11-01 | 北京明略软件系统有限公司 | Data processing method and device, storage medium, electronic device |
| CN110659415B (en) * | 2019-09-04 | 2022-05-10 | 北京三快在线科技有限公司 | Method, device and system for generating business execution certificate |
| CN112199371A (en) * | 2020-09-18 | 2021-01-08 | 中国建设银行股份有限公司 | Data migration method and device, computer equipment and storage medium |
| CN112613892B (en) * | 2020-12-25 | 2024-03-15 | 北京知因智慧科技有限公司 | Data processing method and device based on service system and electronic equipment |
| CN115185982A (en) * | 2022-09-14 | 2022-10-14 | 浩鲸云计算科技股份有限公司 | Data preparation method and system based on data set arrangement |
| CN116415199B (en) * | 2023-04-13 | 2023-10-20 | 广东铭太信息科技有限公司 | Business data outlier analysis method based on audit intermediate table |
Family Cites Families (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20150213444A1 (en) * | 2014-04-07 | 2015-07-30 | Intercontinental Exchange Holdings, Inc. | Systems and methods for improving data processing and management |
| CN105069159A (en) * | 2015-08-26 | 2015-11-18 | 浪潮通用软件有限公司 | Extensible data consistency check tool |
| CN106991140B (en) * | 2017-03-17 | 2023-10-13 | 国网江苏省电力有限公司扬州供电分公司 | Monitoring information table auditing method and system |
| CN107146165B (en) * | 2017-04-24 | 2021-04-13 | 国网江西省电力公司经济技术研究院 | Distribution network planning data management method and system |
| CN107291961B (en) * | 2017-08-08 | 2020-08-11 | 中国银行股份有限公司 | Data processing method and device |
-
2018
- 2018-01-29 CN CN201810085422.1A patent/CN108363751B/en active Active
Also Published As
| Publication number | Publication date |
|---|---|
| CN108363751A (en) | 2018-08-03 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108363751B (en) | A kind of detection method and system of public accumalation fund for housing construction operation system | |
| Leydesdorff et al. | Journal maps on the basis of Scopus data: A comparison with the Journal Citation Reports of the ISI | |
| US7940899B2 (en) | Fraud detection, risk analysis and compliance assessment | |
| CN110188755A (en) | A kind of method, apparatus and computer readable storage medium of image recognition | |
| Omoniyi | The sociology of language and religion: Change, conflict and accommodation | |
| CN107622255A (en) | Bill images field localization method and system based on situation template and semantic template | |
| US20030074633A1 (en) | Apparatus and methods for generating a contract | |
| CN108351898A (en) | Automatic interpretation for structuring multi-field file layout | |
| WO2009145472A1 (en) | System and method of calculating the location suitability index and sales rank of a small business shop | |
| CN103250151B (en) | Information management server, approaches to IM | |
| JP6001743B1 (en) | Data management system, method and program | |
| CN107798515A (en) | A kind of method that database automatically generates accounting voucher | |
| US20050278295A1 (en) | Systems and methods for creating a database for accounting purposes | |
| CN109062881A (en) | Purchase bidding documenting method and system | |
| Zuccala et al. | Metric assessments of books as families of works | |
| CN107577744A (en) | Nonstandard Address automatic matching model, matching process and method for establishing model | |
| Temouri et al. | Tax havens and international business: A conceptual framework of accountability‐avoiding foreign direct investment | |
| Kulczycki et al. | Uses of the Journal Impact Factor in national journal rankings in China and Europe | |
| Zhang et al. | Geographical agglomeration of Indian and Chinese multinationals in Europe: a comparative analysis | |
| Kaur | Financial inclusion and digital India | |
| Gureev et al. | Editing organization profiles in SCOPUS and the RSCI: Facilities comparison | |
| CN106651540B (en) | Product standard cooperation method and system based on online transaction and online purchasing platform | |
| CN111723129A (en) | Report generation method, report generation device and electronic equipment | |
| Liu et al. | How does ethnic diversity shape the design of intergovernmental fiscal relations? Evidence from China | |
| Ramey | Challenging definitions: Human agency, diverse religious practices and the problems of boundaries |
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 |