CN107506383A - A kind of audit data processing method and computer equipment - Google Patents
A kind of audit data processing method and computer equipment Download PDFInfo
- Publication number
- CN107506383A CN107506383A CN201710609814.9A CN201710609814A CN107506383A CN 107506383 A CN107506383 A CN 107506383A CN 201710609814 A CN201710609814 A CN 201710609814A CN 107506383 A CN107506383 A CN 107506383A
- Authority
- CN
- China
- Prior art keywords
- data
- audit
- rules unit
- rules
- unit
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
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
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2477—Temporal data queries
-
- 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/248—Presentation of query results
-
- 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Computational Linguistics (AREA)
- Fuzzy Systems (AREA)
- Mathematical Physics (AREA)
- Probability & Statistics with Applications (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Present disclose provides a kind of audit data processing method and computer equipment.This method includes：Audit data source is obtained, and relevant database is arrived into the data source storage of acquisition；Inquiry request of the user to data source in database is received, Query Result is generated according to inquiry request；First volatile data base table is generated according to Query Result, and the table name of the first volatile data base table is associated with the first rules unit；Judge whether the first rules unit is last rules unit in predefined procedure, if so, then using the first volatile data base table corresponding to the first rules unit as sampling achievement；If it is not, then using the first volatile data base table corresponding to the first rules unit as the data from the sample survey source of Second Rule unit.In accordance with the invention it is possible to improve the durability of sampling prescription, the degree of coupling between rule is reduced, improves audit data processing efficiency.
Description
Technical field
The present invention relates to data processing field, more particularly, it is related to a kind of audit data processing method and computer
Equipment.
Background technology
In the related art, Audit Data Sampling Analysis system, typically by treating data from the sample survey storehouse, sampling analysis component, taking out
Sample result database forms.First, the various business datum of enterprise is arranged, is loaded into and treats in data from the sample survey storehouse.Then, auditor
Member sets the rule preserved before sampling prescription or use and carries out audit sample extraction by sampling analysis component.Finally will
Sampling results is saved in sampling results database, tests and uses for follow-up audit.
What above-mentioned design used treats sample data structures, is often relatively fixed, and corresponding sampling prescription is often whole as one
Body is preserved, used.And in actual audit process, the complicated sampling process of step can be used in many cases, and auditor can only
Typing content is complicated, the rule of process tedious, or even leads to not realize because rule is excessively complicated.When similar answer being present
When miscellaneous regular, auditor needs to repeat identical part in typing rule again, it is meant that the fine division step degree of coupling in rule
It is higher, reusability is relatively low.
The content of the invention
Present disclose provides a kind of audit data processing method and computer equipment, sampling process is split as to independent rule
Then unit, the inquiry achievement of each rules unit can be as the data source of another rules unit, and rules unit can be with
Combined according to different order, the degree of coupling between sampling prescription can be reduced, improve the durability between rule in sampling process.
According to the first aspect of embodiment of the present invention, there is provided a kind of audit data processing method, methods described can wrap
Include：Audit data source is obtained, and relevant database is arrived into the data source storage of acquisition；User is received to number in the database
According to the inquiry request in source, Query Result is generated according to the inquiry request；First ephemeral data is generated according to the Query Result
Storehouse table, and the table name of the first volatile data base table is associated with the first rules unit, wherein, first rules unit pair
Any one sampling prescription in sampling prescription engine is answered, the sampling prescription engine includes multiple rules with predefined procedure
Unit；Judge whether first rules unit is last rules unit in the predefined procedure, if so, then will described in
First volatile data base table corresponding to first rules unit is as sampling achievement；It is if it is not, then that first rules unit is corresponding
Data from the sample survey source of the first volatile data base table as Second Rule unit.
In some embodiments, methods described also includes：It is interim by described in SQL SQL query first
Database table makes the inquiry achievement of the first rules unit described in the Second Rule cell refernce.
In some embodiments, the acquisition Audit data source, and relational data is arrived into the data source storage of acquisition
Storehouse includes：The Audit data that user uploads is received, the data class that parsing determines the Audit data is carried out to the Audit data
Type, the data type include date type, long and text-type；Database table is created according to the data type determined,
And the Audit data is stored into the associated databases table into local data base according to data type.
In some embodiments, the acquisition Audit data source, and relational data is arrived into the data source storage of acquisition
Storehouse includes：The audit associated data in other data sources is read, is deposited after the audit associated data is changed according to mapping relations
Store up local data base.
In some embodiments, each rules unit in the sampling prescription engine can be according to a variety of different orders
It is combined.
According to the second aspect of embodiment of the present invention, there is provided a kind of computer equipment, including memory, processor and
It is stored in the computer program that can be run on memory and on a processor, realizes during the computing device described program：
Audit data source is obtained, and relevant database is arrived into the data source storage of acquisition；User is received to data in the database
The inquiry request in source, Query Result is generated according to the inquiry request；First volatile data base is generated according to the Query Result
Table, and the table name of the first volatile data base table is associated with the first rules unit, wherein, first rules unit is corresponding
Any one sampling prescription in sampling prescription engine, it is single that the sampling prescription engine includes multiple rules with predefined procedure
Member；Judge whether first rules unit is last rules unit in the predefined procedure, if so, then by described
First volatile data base table corresponding to one rules unit is as sampling achievement；If it is not, then by corresponding to first rules unit
Data from the sample survey source of the first volatile data base table as Second Rule unit.
In some embodiments, also realized during the computing device described program：Pass through SQL SQL
The first volatile data base table is inquired about to make the inquiry achievement of the first rules unit described in the Second Rule cell refernce.
In some embodiments, further realized during the computing device described program：User is received to upload
Audit data, the data type that parsing determines the Audit data is carried out to the Audit data, the data type includes
Date type, long and text-type；Database table is created according to the data type determined, and by the Audit data according to
Data type storage associated databases table into local data base.
In some embodiments, further realized during the computing device described program：Read other data
Audit associated data in source, stored after the audit associated data is changed according to mapping relations and arrive local data base.
In some embodiments, each rules unit in the sampling prescription engine can be according to a variety of different orders
It is combined.
The audit data processing method and computer equipment that embodiment of the present invention provides, consider the sampling rule of audit process
The flexibility then designed and complexity, sampling process is split as to independent rules unit, the sampling achievement of each rules unit
Using the data from the sample survey source as another rule or step unit, and rule or step unit can be arbitrarily combined, and be met
The flexibility of sampling prescription design, and used by the modularization of rules unit, the durability of rules unit can be improved,
The degree of coupling between them is reduced, so as to improve the treatment effeciency of audit data processing on the whole；Moreover, to different data
Source, parsing and conversion process accordingly are carried out, be transformed to the database table of unified form, meet that the processing in data from the sample survey source will
Ask.
Brief description of the drawings
Fig. 1 is the schematic flow sheet according to the audit data processing method of embodiment of the present invention.
Fig. 2 is the block schematic illustration according to the audit data processing of embodiment of the present invention.
Fig. 3 is the block schematic illustration according to the computer equipment of embodiment of the present invention.
Embodiment
It is described in detail to various aspects of the present invention below in conjunction with the drawings and specific embodiments.Wherein, many institute's weeks
Module, unit and its mutual connection, link, communication or the operation known are not shown or not elaborated.Also, institute
Feature, framework or the function of description can combine in any way in one or more embodiments.People in the art
Member is it should be appreciated that following various embodiments are served only for for example, not for limiting the scope of the invention.May be used also
To be readily appreciated that, module or unit or processing mode in each embodiment described herein and shown in the drawings can by it is various not
It is combined and designs with configuration.
Referring to Fig. 1, Fig. 1 is according to the schematic flow sheet of the audit data processing method of embodiment of the present invention, the audit
Data processing method may include：
S101, Audit data source is obtained, and relevant database is arrived into the data source storage of acquisition.
Audit data source may include the also each with the data that associate of auditing, the storage format of these data of a variety of separate sources
Differ.These original Audit datas can be the data of structuring or non-structured data.
In some embodiments, original data source can be non-structured data, for example, the form such as excel, txt
Data etc..For such unstructured data, S101 can include:The Audit data that user uploads is received, is examined described
Count and parsed, determine the data type of the Audit data, wherein, the data type may include, but be not limited to：Day
Phase type, long and text-type；Database table is created according to the data type determined, and by Audit data according to data class
Type storage corresponding database table into local data base, wherein, every kind of data type corresponds to a kind of database table.
In one embodiment, after receiving user's upload excel, the data in excel lists, such as " 2017/ are parsed
04/02 ", " 420120342 ", " on March 23rd, 2016, shop assistant is connected to customer complaint ... ", sentence afterwards according to certain logic
Break its most suitable data type, such as date type, long, text-type etc., and reality user's adjustment, confirms on the page
Afterwards, database table structure is created according to expected data type, and the corresponding of local data base is arrived in the Audit data storage parsed
In database table.
In other embodiment, original Audit data can be the data of structuring, and these data are stored in
Other data source.For such structural data, S101 may include：The audit associated data in other data sources is read, will
Local data base is arrived in storage after the audit associated data is changed according to mapping relations.Due to the database table in other data source
Structure can be different with the structure of target database table in local data base, field is adjusted to target data in query SQL
Database table structure.
S102, inquiry request of the user to data source in the database is received, is generated and inquired about according to the inquiry request
As a result.
In some embodiments, the inquiry request of user can be inputted by page editing instrument, for example, it may be
The form of sql like language.By selecting SQL script templates, addition keyword, the support for selecting function user can be allow clever
Assembled sql like language living performs inquiry.User can be used as querying condition using custom field.
In other embodiment, inquiry request can be to simple single table data query, for example, value scope,
Function calculates, data compare, fuzzy query etc..
S103, the first volatile data base table is generated according to the Query Result, and by the first volatile data base table
Table name associates with the first rules unit, wherein, first rules unit corresponds to any one sampling in sampling prescription engine
Rule, the sampling prescription engine include multiple rules units with predefined procedure.
In some embodiments, Query Result caused by SQL is run, is stored using the first volatile data base table, this
The table name of one volatile data base table associates with the first rules unit, for example, can be by the table name of volatile data base table and rule list
The mark association of member, and the incidence relation of the two is stored.Volatile data base table is saved in relevant database, ephemeral data
The table result of storehouse table generates according to the inquiry field in SQL, and the data type of field is identical with Data source table structure.First rule
Unit can be any one sampling prescription in sampling prescription engine.Rules unit it can be appreciated that in sampling process one
Individual step unit, each sampling process may include the multiple rules units or step unit according to certain order.And rule of sampling
Then engine may include multiple rules units, and these rules units can have predetermined order, and can be according to a variety of differences
Order be combined.For example, the audit user for different demands, can be according to its corresponding demand to these rules units
It is combined, user A can arrange rules unit a, b, c, d, e according to 1,2,3,4,5 order, and user B can be by rule
Unit a, b, c, d, f, m arrange according to 2,1,5,3,4,6 order.
S104, judge whether first rules unit is last rules unit in the predefined procedure, if so,
S105 is then performed, if it is not, then performing S106.
S105, using the first volatile data base table corresponding to first rules unit as sampling achievement.
S106, using the first volatile data base table corresponding to first rules unit as the sampling number of Second Rule unit
According to source, wherein, the Second Rule unit is next rule adjacent with first rules unit in the predefined procedure
Unit.
In some embodiments, it is necessary to judge that the rule is single after Query Result and rules unit U1 are associated
First U1 whether be a certain predefined procedure rules unit combination in last rules unit, if rules unit U1 is most
The latter rules unit, then can make using volatile data base table corresponding to rules unit U1 as sampling achievement for user
With.If rules unit U1 is not last rules unit in rules unit combination, then can be by the rules unit
Data source of the corresponding volatile data base table as other rules unit, wherein, the other rules unit can be predetermined
The rule of the next rules unit or other predefined procedures adjacent with rules unit U1 in the rules unit combination of order
Then other rules units in unit combination.That is, rules unit U1 sampling achievement can be used as other rules units
Data from the sample survey source.
In some embodiments, rules unit in addition can pass through nonce corresponding to SQL query rules unit U1
Rules unit U1 inquiry achievement is quoted according to storehouse table.
In some embodiments, volatile data base table generates temporarily in data processing, but next producing
After individual Query Result (volatile data base table), first volatile data base table will be automatically deleted.
In one embodiment, as shown in Fig. 2 decimation blocks 11 obtain sampling prescription from sampling prescription engine 12, from
Data from the sample survey source is obtained in data source 13, sampling prescription is verified and whether data source matches, if matching.Then according to sampling prescription pair
Data source calculates, and obtains sampling results, there is provided is shown to sampling results display module 16 to user, and sampling results is sent to
Source of new data release module 14 is issued, and sampling results can be sent to data source 13 by source of new data release module 14, be updated
Data source 13.Source of new data release module 14 can also receive the data source of the transmission of data source adaptation module 15, data source adaptation mould
The data source that block 15 provides may include the data that user uploads carrying out parsing generation database table and read other data sources
Database table.The data source that data source adaptation module 15 provides can also be updated by data source release module 14 arrives data source
13, used for decimation blocks 11.
Embodiment of the present invention additionally provides a kind of computer equipment, as shown in figure 3, the computer equipment 300 includes：Deposit
Reservoir 301, processor 302 and it is stored in the computer program that can be run on memory 301 and on processor 302, institute
State when processor 302 performs described program and realize：Audit data source is obtained, and relational data is arrived into the data source storage of acquisition
Storehouse；Inquiry request of the user to data source in the database is received, Query Result is generated according to the inquiry request；According to institute
State Query Result and generate the first volatile data base table, and the table name of the first volatile data base table and the first rules unit are closed
Connection, wherein, first rules unit corresponds to any one sampling prescription in sampling prescription engine, the sampling prescription engine
Including multiple rules units with predefined procedure；Judge whether first rules unit is last in the predefined procedure
One rules unit, if so, then using the first volatile data base table corresponding to first rules unit as sampling achievement；If
It is no, then using the first volatile data base table corresponding to first rules unit as the data from the sample survey source of Second Rule unit.
In some embodiments, also realized during the computing device described program：Pass through SQL SQL
The first volatile data base table is inquired about to make the inquiry achievement of the first rules unit described in the Second Rule cell refernce.
In some embodiments, further realized during the computing device described program：Receive examining for user's upload
Count, the data type that parsing determines the Audit data is carried out to the Audit data, the data type includes the date
Type, long and text-type；Database table is created according to the data type determined, and by the Audit data according to data
Type storage associated databases table into local data base.
In some embodiments, further realized during the computing device described program：Read in other data sources
Audit associated data, by it is described audit associated data changed according to mapping relations after storage arrive local data base.
In some embodiments, each rules unit in the sampling prescription engine can be according to a variety of different orders
It is combined.
Through the above description of the embodiments, those skilled in the art can be understood that the present invention can be by
The mode of software combination hardware platform is realized.Based on such understanding, technical scheme makes tribute to background technology
That offers can be embodied in the form of software product in whole or in part, and the computer software product can be stored in storage and be situated between
In matter, such as ROM/RAM, magnetic disc, CD, including some instructions are make it that a computer equipment (can be individual calculus
Machine, server, smart mobile phone either network equipment etc.) perform described in some parts of each embodiment of the present invention or embodiment
Method.
The term and wording used in description of the invention is just to for example, be not intended to form restriction.Ability
Field technique personnel should be appreciated that on the premise of the general principle of disclosed embodiment is not departed from, to above-mentioned embodiment
In each details can carry out various change.Therefore, the scope of the present invention is only determined by claim, in the claims, unless
It is otherwise noted, all terms should be understood by the broadest rational meaning.
Claims (10)
- A kind of 1. audit data processing method, it is characterised in that methods described includes：Audit data source is obtained, and relevant database is arrived into the data source storage of acquisition；Inquiry request of the user to data source in the database is received, Query Result is generated according to the inquiry request；First volatile data base table is generated according to the Query Result, and by the table name and first of the first volatile data base table Rules unit associates, wherein, first rules unit corresponds to any one sampling prescription in sampling prescription engine, described to take out Sample regulation engine includes multiple rules units with predefined procedure；Judge whether first rules unit is last rules unit in the predefined procedure,If so, then using the first volatile data base table corresponding to first rules unit as sampling achievement；If it is not, then using the first volatile data base table corresponding to first rules unit as the data from the sample survey of Second Rule unit Source.
- 2. according to the method for claim 1, it is characterised in that methods described also includes：Made by the first volatile data base table described in SQL SQL query described in the Second Rule cell refernce The inquiry achievement of first rules unit.
- 3. according to the method for claim 1, it is characterised in that the acquisition Audit data source, and by the data source of acquisition Storing relevant database includes：The Audit data that user uploads is received, the data type that parsing determines the Audit data is carried out to the Audit data, The data type includes date type, long and text-type；Database table is created according to the data type determined, and the Audit data is arrived into local number according to data type storage According to associated databases table in storehouse.
- 4. according to the method for claim 1, it is characterised in that the acquisition Audit data source, and by the data source of acquisition Storing relevant database includes：The audit associated data in other data sources is read, stores and arrives after the audit associated data is changed according to mapping relations Local data base.
- 5. according to the method for claim 1, it is characterised in that each rules unit in the sampling prescription engine can be by It is combined according to a variety of different orders.
- 6. a kind of computer equipment, including memory, processor and it is stored on memory and can runs on a processor Computer program, it is characterised in that realized during the computing device described program：Audit data source is obtained, and relevant database is arrived into the data source storage of acquisition；Inquiry request of the user to data source in the database is received, Query Result is generated according to the inquiry request；First volatile data base table is generated according to the Query Result, and by the table name and first of the first volatile data base table Rules unit associates, wherein, first rules unit corresponds to any one sampling prescription in sampling prescription engine, described to take out Sample regulation engine includes multiple rules units with predefined procedure；Judge whether first rules unit is last rules unit in the predefined procedure,If so, then using the first volatile data base table corresponding to first rules unit as sampling achievement；If it is not, then using the first volatile data base table corresponding to first rules unit as the data from the sample survey of Second Rule unit Source.
- 7. computer equipment according to claim 6, it is characterised in that reality is gone back during the computing device described program It is existing：Made by the first volatile data base table described in SQL SQL query described in the Second Rule cell refernce The inquiry achievement of first rules unit.
- 8. computer equipment according to claim 6, it is characterised in that further during the computing device described program Realize：The Audit data that user uploads is received, the data type that parsing determines the Audit data is carried out to the Audit data, The data type includes date type, long and text-type；Database table is created according to the data type determined, and the Audit data is arrived into local number according to data type storage According to associated databases table in storehouse.
- 9. computer equipment according to claim 6, it is characterised in that further during the computing device described program Realize：The audit associated data in other data sources is read, stores and arrives after the audit associated data is changed according to mapping relations Local data base.
- 10. computer equipment according to claim 6, it is characterised in that each rule in the sampling prescription engine is single Member can be combined according to a variety of different orders.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710609814.9A CN107506383B (en) | 2017-07-25 | 2017-07-25 | Audit data processing method and computer equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710609814.9A CN107506383B (en) | 2017-07-25 | 2017-07-25 | Audit data processing method and computer equipment |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107506383A true CN107506383A (en) | 2017-12-22 |
| CN107506383B CN107506383B (en) | 2021-07-23 |
Family
ID=60689405
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710609814.9A Active CN107506383B (en) | 2017-07-25 | 2017-07-25 | Audit data processing method and computer equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107506383B (en) |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108304464A (en) * | 2017-12-26 | 2018-07-20 | 北京明略软件***有限公司 | A kind of method and device of data cleansing |
| CN108984700A (en) * | 2018-07-05 | 2018-12-11 | 腾讯科技（深圳）有限公司 | Data processing method and device, computer equipment and storage medium |
| CN109598484A (en) * | 2018-12-04 | 2019-04-09 | 广东电网有限责任公司 | A kind of project under construction turns fixed assets number auditing method and device |
| CN110580556A (en) * | 2018-06-08 | 2019-12-17 | 阿里巴巴集团控股有限公司 | Data processing method and system and processor |
| CN110633315A (en) * | 2018-06-20 | 2019-12-31 | ***通信集团有限公司 | Data processing method and device and computer storage medium |
| CN113076352A (en) * | 2021-03-17 | 2021-07-06 | 远光软件股份有限公司 | Auditing method, electronic device and storage medium |
| CN113327023A (en) * | 2021-05-24 | 2021-08-31 | 建信金融科技有限责任公司 | Traversal test method and device, electronic equipment and computer readable storage medium |
Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1590989A (en) * | 2003-08-27 | 2005-03-09 | 上海宏力半导体制造有限公司 | Defect analgsis sampling control system and method |
| CN101777142A (en) * | 2009-09-01 | 2010-07-14 | 厦门东南融通***工程有限公司 | Method for converting rules and regulations of enterprises and public institutions into computer-recognizable programs |
| CN102262678A (en) * | 2011-08-16 | 2011-11-30 | 郑毅 | System for sampling mass data and managing sampled data |
| CN102629267A (en) * | 2012-03-08 | 2012-08-08 | 北京神州数码思特奇信息技术股份有限公司 | Data processing method and data processing module |
| CN103049708A (en) * | 2012-12-27 | 2013-04-17 | 华为技术有限公司 | Audit configuration method and audit configuration system for database |
| CN105095240A (en) * | 2014-05-04 | 2015-11-25 | ***股份有限公司 | Database data sample acquisition |
| CN105447090A (en) * | 2015-11-05 | 2016-03-30 | 华中科技大学 | Automated data mining preprocessing method |
| CN106326776A (en) * | 2015-07-02 | 2017-01-11 | 阿里巴巴集团控股有限公司 | Data object verification method, device and system based on rules, and electric device |
| WO2017017748A1 (en) * | 2015-07-27 | 2017-02-02 | 株式会社日立製作所 | Computer system and sampling method |
| CN106484885A (en) * | 2016-10-17 | 2017-03-08 | 深圳市穗彩科技开发有限公司 | The auditing method of multi-source heterogeneous data and system |
-
2017
- 2017-07-25 CN CN201710609814.9A patent/CN107506383B/en active Active
Patent Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1590989A (en) * | 2003-08-27 | 2005-03-09 | 上海宏力半导体制造有限公司 | Defect analgsis sampling control system and method |
| CN101777142A (en) * | 2009-09-01 | 2010-07-14 | 厦门东南融通***工程有限公司 | Method for converting rules and regulations of enterprises and public institutions into computer-recognizable programs |
| CN102262678A (en) * | 2011-08-16 | 2011-11-30 | 郑毅 | System for sampling mass data and managing sampled data |
| CN102629267A (en) * | 2012-03-08 | 2012-08-08 | 北京神州数码思特奇信息技术股份有限公司 | Data processing method and data processing module |
| CN103049708A (en) * | 2012-12-27 | 2013-04-17 | 华为技术有限公司 | Audit configuration method and audit configuration system for database |
| CN105095240A (en) * | 2014-05-04 | 2015-11-25 | ***股份有限公司 | Database data sample acquisition |
| CN106326776A (en) * | 2015-07-02 | 2017-01-11 | 阿里巴巴集团控股有限公司 | Data object verification method, device and system based on rules, and electric device |
| WO2017017748A1 (en) * | 2015-07-27 | 2017-02-02 | 株式会社日立製作所 | Computer system and sampling method |
| CN105447090A (en) * | 2015-11-05 | 2016-03-30 | 华中科技大学 | Automated data mining preprocessing method |
| CN106484885A (en) * | 2016-10-17 | 2017-03-08 | 深圳市穗彩科技开发有限公司 | The auditing method of multi-source heterogeneous data and system |
Non-Patent Citations (3)
| Title |
|---|
| 吴松 等: "一种预定义规则的数据挖掘方法在商业银行审计中的应用", 《信息***工程》 * |
| 石佳滢: "商业银行数据质量控制研究", 《现代商贸工业》 * |
| 赵同: "信息化技术在审计抽样中的应用", 《电力行业信息化优秀论文集2013》 * |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108304464A (en) * | 2017-12-26 | 2018-07-20 | 北京明略软件***有限公司 | A kind of method and device of data cleansing |
| CN108304464B (en) * | 2017-12-26 | 2021-01-29 | 北京明略软件***有限公司 | Data cleaning method and device |
| CN110580556A (en) * | 2018-06-08 | 2019-12-17 | 阿里巴巴集团控股有限公司 | Data processing method and system and processor |
| CN110633315A (en) * | 2018-06-20 | 2019-12-31 | ***通信集团有限公司 | Data processing method and device and computer storage medium |
| CN108984700A (en) * | 2018-07-05 | 2018-12-11 | 腾讯科技（深圳）有限公司 | Data processing method and device, computer equipment and storage medium |
| CN108984700B (en) * | 2018-07-05 | 2021-07-27 | 腾讯科技（深圳）有限公司 | Data processing method and device, computer equipment and storage medium |
| CN109598484A (en) * | 2018-12-04 | 2019-04-09 | 广东电网有限责任公司 | A kind of project under construction turns fixed assets number auditing method and device |
| CN113076352A (en) * | 2021-03-17 | 2021-07-06 | 远光软件股份有限公司 | Auditing method, electronic device and storage medium |
| CN113327023A (en) * | 2021-05-24 | 2021-08-31 | 建信金融科技有限责任公司 | Traversal test method and device, electronic equipment and computer readable storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107506383B (en) | 2021-07-23 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107506383A (en) | A kind of audit data processing method and computer equipment | |
| CN103177068B (en) | According to the system and method for existence compatible rule merging source record | |
| US8660987B2 (en) | Data cache techniques in support of synchronization of databases in a distributed environment | |
| US8341131B2 (en) | Systems and methods for master data management using record and field based rules | |
| CN106164865B (en) | The method and system of the affairs batch processing of dependence perception for data duplication | |
| US20050187794A1 (en) | Electronic medical record registry including data replication | |
| CN110309058A (en) | Business end test method, device, computer installation and computer storage medium | |
| CN107368493A (en) | Data base query method and device | |
| CN101202966B (en) | Method, system and apparatus for collecting user information | |
| CN111767303A (en) | Data query method and device, server and readable storage medium | |
| CN110119473A (en) | A kind of construction method and device of file destination knowledge mapping | |
| CN107229718A (en) | The method and apparatus for handling report data | |
| CN105808653B (en) | A kind of data processing method and device based on user tag system | |
| US11636078B2 (en) | Personally identifiable information storage detection by searching a metadata source | |
| CN109524070A (en) | Data processing method and device, electronic equipment, storage medium | |
| CN110765272A (en) | Knowledge graph-based signing method and device, computer equipment and computer storage medium | |
| CN107783985A (en) | A kind of distributed networks database query method, apparatus and management system | |
| CN109656999A (en) | Method of data synchronization, equipment, storage medium and the device of big data quantity | |
| CN110781183A (en) | Method and device for processing incremental data in Hive database and computer equipment | |
| CN105912840A (en) | Search and processing method, device and system for image data | |
| CN113887941B (en) | Business process generation method, device, electronic equipment and medium | |
| CN110019713A (en) | Based on the data retrieval method and device, equipment and storage medium for being intended to understand | |
| CN109815254A (en) | Cross-region method for scheduling task and system based on big data | |
| CN109902126A (en) | Support the loading system and its implementation of HIVE auto-partition | |
| CN107944677A (en) | Achievement method for tracing, application server and computer-readable recording medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |