[go: up one dir, main page]

CN107203601A - Data processing method and device applied to accounting processing - Google Patents

Data processing method and device applied to accounting processing Download PDF

Info

Publication number
CN107203601A
CN107203601A CN201710337519.2A CN201710337519A CN107203601A CN 107203601 A CN107203601 A CN 107203601A CN 201710337519 A CN201710337519 A CN 201710337519A CN 107203601 A CN107203601 A CN 107203601A
Authority
CN
China
Prior art keywords
data
account
same name
subdatas
unique lock
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
CN201710337519.2A
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.)
China Construction Bank Corp
Original Assignee
China Construction Bank Corp
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 China Construction Bank Corp filed Critical China Construction Bank Corp
Priority to CN201710337519.2A priority Critical patent/CN107203601A/en
Publication of CN107203601A publication Critical patent/CN107203601A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/10File systems; File servers
    • G06F16/16File or folder operations, e.g. details of user interfaces specifically adapted to file systems
    • GPHYSICS
    • G06COMPUTING OR CALCULATING; 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/12Accounting

Landscapes

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

Abstract

The embodiment of the invention discloses a kind of data processing method and device applied to accounting processing, wherein, methods described includes:Accounting data is split as by many parts of account subdatas that data volume is uniform and data dimension is different according to fractionation strategy;Parallel processing of transferring items is performed based on many parts of account subdatas.The method and apparatus provided using the embodiment of the present invention, can ensure data accuracy of the financial data after splitting when transferring items parallel, reduce the data volume of single request of transferring items, reduce the run time of big transactions requests, increase substantially overall efficiency of transferring items.

Description

Data processing method and device applied to accounting processing
Technical field
The present invention relates to data processing field and accounting processing field, it is applied to more particularly, to one kind at account The data processing method and device of reason.
Background technology
It is existing to be used to realize that the data handling system of accounting processing is generally comprised with lower module:It is general ledger management system, solid Determine the asset management system, fund management system, procurement management system, inventory management system, production management system, cost management system System, sale management system, payrool system, client and receivables and payables management system etc..Wherein general ledger management system is whole Kernel subsystems in individual system.
General ledger, refers to account as recorded in a ledger (General Ledger), is opened an account according to total classification subject, complete for registering Portion's economic work, carrying out the accounting of total score class, there is provided the ledger of blanket accounting information.The accounting money that account as recorded in a ledger is provided Material, is the Main Basiss for working out accounting statement, and any unit all must be provided with account as recorded in a ledger.
In common general ledger system, in order to prevent the amount of same general ledger account from wrong data, same set of books occur Financial data must serially transfer items (a kind of exemplary detailed process is not as shown in figure 1, repeat herein), so as to ensure data Uniformity.But, in the case of data volume is king-sized, time-consuming for the mode that conventional serial is transferred items, it is impossible to meets banking Demand.
The content of the invention
In order to solve the above technical problems, the invention provides a kind of data processing method and dress applied to accounting processing Put, data accuracy of the financial data after splitting when transferring items parallel can be ensured, reduce the data volume of single request of transferring items, The run time of big transactions requests is reduced, overall efficiency of transferring items is increased substantially.
On the one hand, the embodiments of the invention provide a kind of data processing method applied to accounting processing, including:
Accounting data is split as by many parts of account subdatas that data volume is uniform and data dimension is different according to fractionation strategy;
Parallel processing of transferring items is performed based on many parts of account subdatas.
On the other hand, the embodiment of the present invention additionally provides a kind of data processing equipment applied to accounting processing, including:
Data split cells, for being split as accounting data according to fractionation strategy, data volume is uniform and data dimension is different Many parts of account subdatas;
Parallel unit of transferring items, for performing parallel processing of transferring items based on many parts of account subdatas.
Implement the data processing method and device that the embodiment of the present invention is provided, can ensure that the financial data after splitting exists Data accuracy when transferring items parallel;Reduce the data volume of single request of transferring items;Reduce the run time of big transactions requests;Significantly Degree improves overall efficiency of transferring items.In addition, passing through lock mechanism provided in an embodiment of the present invention, moreover it is possible to further enhance data accurate Property.
Brief description of the drawings
Fig. 1 is a kind of existing serial schematic flow sheet applied to accounting processing;
Fig. 2 is a kind of schematic flow sheet of data processing method applied to accounting processing according to embodiments of the present invention;
Fig. 3 is a kind of block diagram of data processing equipment applied to accounting processing according to embodiments of the present invention;
Fig. 4 is the block diagram of the module of transferring items in data processing equipment shown in Fig. 3;
Fig. 5 is a kind of process schematic of data processing method applied to accounting processing according to embodiments of the present invention;
Fig. 6 is according to embodiments of the present invention a kind of the schematic flow sheet of data accuracy to be ensured by lock mechanism.
Embodiment
In order that those skilled in the art more fully understand the present invention program, below in conjunction with the embodiment of the present invention Accompanying drawing, the technical scheme in the embodiment of the present invention is clearly and completely described.
In some flows of description in description and claims of this specification and above-mentioned accompanying drawing, contain according to Particular order occur multiple operations, but it should be clearly understood that these operation can not herein occur according to it is suitable Sequence is performed or performed parallel, and the sequence number such as 101,102 etc. of operation is only used for distinguishing each different operation, sequence number Any execution sequence is not represented for itself.In addition, these flows can include more or less operations, and these operations can To perform or perform parallel in order.It should be noted that the description such as " first ", " second " herein, is to be used to distinguish not Same message, equipment, module etc., does not represent sequencing, it is different types also not limit " first " and " second ".
Below in conjunction with the accompanying drawing in the embodiment of the present invention, the technical scheme in the embodiment of the present invention is carried out clear, complete Site preparation is described, it is clear that described embodiment is only a part of embodiment of the invention, rather than whole embodiments.It is based on Embodiment in the present invention, the every other implementation that those skilled in the art are obtained under the premise of creative work is not made Example, belongs to the scope of protection of the invention.
Fig. 2 is a kind of schematic flow sheet of data processing method applied to accounting processing according to embodiments of the present invention, Reference picture 2, methods described includes:
200:Accounting data deconsolidation process.Specifically, according to strategy is split, that accounting data is split as into data volume is uniform And many parts of different account subdatas of data dimension.
In the present embodiment, data volume uniformly can be understood as that data volume is identical or as far as possible identical, and data dimension difference can There is independence on data content or as far as possible with independence to be interpreted as dividing obtained account subdata.This area skill Art personnel should be appreciated that " as far as possible " description is not a fuzzy concept, and it is intended to mean that within the scope of one selection is " more It is excellent " mode, and definitely identical or definitely independent result must be reached by being not offered as selected mode.
202:Parallel processing of transferring items.Specifically, parallel processing of transferring items is performed based on many parts of account subdatas.
The method provided using the present embodiment, by accounting data is split as that data volume is uniform and data dimension is different many parts Account subdata, it can be ensured that data accuracy of the financial data when transferring items parallel after fractionation;Based on multiple after fractionation Financial data file in parallel is transferred items, and reduces the data volume of single request of transferring items, and reduces the run time of big transactions requests, significantly Degree improves overall efficiency of transferring items.
Alternatively, in a kind of implementation of the present embodiment, the fractionation strategy includes:Make many parts of account subnumbers According to subject code combination mark it is different (meanings for including difference as far as possible);And expire the data volume of many parts of account subdatas Sufficient preparatory condition (for example, as uniform as possible).
Exemplarily, the create-rule of subject code combination mark depends on COA popular tourisms (Chart Of Account).COA popular tourisms are one group of accounting item structures for being used to identify general ledger account, typically by several different dimensions Duan Zucheng.Data, according to data distribution situation, can just be split to different files, so as to realize by an optional section in theory The subject code combination mark that data in different files are produced is different.However, to ensure that the file size after splitting is more equal Even, the section that in this implementation data distribution can be selected relatively uniform is used as fractionation foundation.For example, current China Reconstructs The COA popular tourisms of bank are constituted by nine sections.Selection mechanism section in this implementation, the front two numbered according to mechanism is split Data, mechanism numbering front two identical data are assigned in same file.That is, the front two numbered according to mechanism will be described Accounting data is split as many parts of account subdatas.
Alternatively, in a kind of implementation of the present embodiment, in order to realize processing 202, concurrently for every a account Subdata of being engaged in carries out following handle:Obtain database unique lock of the same name of the account subdata;If getting the data Storehouse unique lock of the same name, then carry out transferring items operation and discharge the database unique lock of the same name after the completion of operation of transferring items;If not The database unique lock of the same name is got, then waits the database unique lock of the same name to obtain the database after being released same The unique lock of name.
Wherein, the accounting data is split as to the feelings of many parts of account subdatas in the front two numbered according to mechanism Under condition, database unique lock of the same name of the account subdata can be obtained in the following ways:According to the account subdata The front two of mechanism numbering and the ID of the affiliated set of books of the accounting data generate database unique lock handle of the same name;According to Database unique lock of the same name described in database unique lock handle acquiring of the same name.
The data transferred items parallel in theory are split according to certain rule, and concurrent request is according to identical rule All database should be able to be got plus set of books in the very first time as handle uniquely to lock.But, in order to prevent there may be Accounting data be directly entered step of transferring items without data split cells, can ensure identical again using this implementation General ledger account data will not be because of concurrently causing data inaccurate.
Fig. 3 is a kind of block diagram of data processing equipment applied to accounting processing according to embodiments of the present invention.Reference picture 3, data processing equipment includes data split cells 30 and parallel unit 32 of transferring items.Wherein, data split cells 30 is used for basis Split strategy and accounting data is split as many parts of account subdatas that data volume is uniform and data dimension is different;Parallel unit of transferring items 32 are used to perform parallel processing of transferring items based on many parts of account subdatas.
Alternatively, in a kind of implementation of the present embodiment, the fractionation strategy includes:Make many parts of account subnumbers According to subject code combination mark it is different;And the data volume of many parts of account subdatas is met preparatory condition.
Alternatively, in a kind of implementation of the present embodiment, data split cells 30 according to mechanism specifically for numbering Front two the accounting data is split as many parts of account subdatas.
Alternatively, in a kind of implementation of the present embodiment, as shown in dotted line frame in Fig. 3, unit 32 of transferring items parallel is wrapped Multiple modules of transferring items are included, each module of transferring items corresponds to different account subdatas and carries out processing of transferring items.Specifically, such as Fig. 4 Shown, each module of transferring items can include:Acquisition submodule, the database for obtaining corresponding account subdata is of the same name unique Lock;Submodule is handled, in the case of getting the database unique lock of the same name in the acquisition submodule, is transferred items Operate and discharge the database unique lock of the same name after the completion of operation of transferring items, and for not obtained in the acquisition submodule In the case of the database unique lock of the same name, to obtain the database same after the database unique lock of the same name is released The unique lock of name.
Alternatively, in a kind of implementation of the present embodiment, it is used for what is numbered according to mechanism in data split cells 30 In the case that accounting data to be split as to front two many parts of account subdatas, acquisition submodule 32 is used for:According to corresponding account The front two of the mechanism numbering of subdata and ID generation database unique lock handles of the same name of the affiliated set of books of the accounting data;Root According to database unique lock of the same name described in the database unique lock handle acquiring of the same name.
It is apparent to those skilled in the art that, for convenience and simplicity of description, the device of foregoing description, The specific work process of unit, module, submodule etc., may be referred to the corresponding process in preceding method embodiment, herein no longer Repeat.
Fig. 5 is a kind of process schematic of data processing method applied to accounting processing according to embodiments of the present invention. Reference picture 5, methods described includes:First, single file is loaded, and passes through data split cells (such as aforementioned data split cells 30) single file is split as multiple subfiles (correspondence account subdata), for example, being split as the subfile of more than 30.So Afterwards, as shown in figure 5, for each subfile, concurrently importing data to and transferring items flow to carry out processing of transferring items.
Fig. 6 is according to embodiments of the present invention a kind of the schematic flow sheet of data accuracy to be ensured by lock mechanism.With reference to Fig. 5 and reference picture 6, in each transfers items flow, after data are prepared, are obtained before different mechanisms number all in this document Two, and then obtain unique lock of the same name;If getting unique lock of the same name, transferred items and discharge after transfer items it is of the same name only One lock;If unique lock of the same name is obtained by other process, after wait other side's release, then unique lock of the same name is obtained, it Transferred items afterwards and discharge the processing of the same name uniquely locked.
As it was previously stated, the lock mechanism provided using the present embodiment is able to ensure that data accuracy.
Through the above description of the embodiments, those skilled in the art can be understood that each embodiment can Realized by the mode of software plus required general hardware platform, naturally it is also possible to pass through hardware.Understood based on such, on The part that technical scheme substantially in other words contributes to prior art is stated to embody in the form of software product, should Computer software product can be stored in a computer-readable storage medium, such as ROM/RAM, magnetic disc, CD, including some fingers Order is to cause a computer equipment (can be personal computer, server, or network equipment etc.) to perform each implementation Method described in some parts of example or embodiment.
Finally it should be noted that:The above embodiments are merely illustrative of the technical solutions of the present invention, rather than its limitations;Although The present invention is described in detail with reference to the foregoing embodiments, it will be understood by those within the art that:It still may be used To be modified to the technical scheme described in foregoing embodiments, or equivalent substitution is carried out to which part technical characteristic; And these modification or replace, do not make appropriate technical solution essence depart from various embodiments of the present invention technical scheme spirit and Scope.

Claims (10)

1. a kind of data processing method applied to accounting processing, it is characterised in that methods described includes:
Accounting data is split as by many parts of account subdatas that data volume is uniform and data dimension is different according to fractionation strategy;
Parallel processing of transferring items is performed based on many parts of account subdatas.
2. the method as described in claim 1, it is characterised in that the fractionation strategy includes:
The subject code of many parts of account subdatas is set to combine mark difference;And
The data volume of many parts of account subdatas is set to meet preparatory condition.
3. the method as described in claim 1, it is characterised in that described that accounting data is split as by data volume according to fractionation strategy Uniform and many parts of different account subdatas of data dimension, including:
The accounting data is split as many parts of account subdatas by the front two numbered according to mechanism.
4. the method as any one of claim 1-3, it is characterised in that described to be held based on many parts of account subdatas The parallel processing of transferring items of row, including:
Concurrently it is directed to and is handled as follows per a account subdata:
Obtain database unique lock of the same name of the account subdata;
If getting the database unique lock of the same name, progress, which is transferred items, to be operated and discharges the number after the completion of operation of transferring items According to storehouse unique lock of the same name;
If not getting the database unique lock of the same name, the database unique lock of the same name is waited to obtain institute after being released State database unique lock of the same name.
5. method as claimed in claim 4, it is characterised in that
It is described in the case where the accounting data is split as many parts of account subdatas by the front two numbered according to mechanism Obtaining database unique lock of the same name of the account subdata includes:
The front two and the ID of the affiliated set of books of the accounting data numbered according to the mechanism of the account subdata generate the number According to storehouse unique lock handle of the same name;
Database unique lock of the same name according to the database unique lock handle acquiring of the same name.
6. a kind of data processing equipment applied to accounting processing, it is characterised in that described device includes:
Data split cells, for according to splitting strategy by that accounting data is split as that data volume is uniform and data dimension is different is many Part account subdata;
Parallel unit of transferring items, for performing parallel processing of transferring items based on many parts of account subdatas.
7. device as claimed in claim 6, it is characterised in that the fractionation strategy includes:
The subject code of many parts of account subdatas is set to combine mark difference;And
The data volume of many parts of account subdatas is set to meet preparatory condition.
8. device as claimed in claim 6, it is characterised in that the data split cells is used for:
The accounting data is split as many parts of account subdatas by the front two numbered according to mechanism.
9. the device as any one of claim 6-8, it is characterised in that the parallel unit of transferring items includes multiple transfer items Module, each module of transferring items includes:
Acquisition submodule, database unique lock of the same name for obtaining corresponding account subdata;
Submodule is handled, in the case of getting the database unique lock of the same name in the acquisition submodule, was carried out Account operates and discharges the database unique lock of the same name after the completion of operation of transferring items, and for not obtained in the acquisition submodule In the case of getting the database unique lock of the same name, the database is obtained after the database unique lock of the same name is released Unique lock of the same name.
10. device as claimed in claim 9, it is characterised in that be used for what is numbered according to mechanism in the data split cells In the case that the accounting data to be split as to front two many parts of account subdatas, the acquisition submodule is used for:
The front two and the ID of the affiliated set of books of the accounting data numbered according to the mechanism of corresponding account subdata generate data Storehouse unique lock handle of the same name;
Database unique lock of the same name according to the database unique lock handle acquiring of the same name.
CN201710337519.2A 2017-05-15 2017-05-15 Data processing method and device applied to accounting processing Pending CN107203601A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201710337519.2A CN107203601A (en) 2017-05-15 2017-05-15 Data processing method and device applied to accounting processing

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201710337519.2A CN107203601A (en) 2017-05-15 2017-05-15 Data processing method and device applied to accounting processing

Publications (1)

Publication Number Publication Date
CN107203601A true CN107203601A (en) 2017-09-26

Family

ID=59905942

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201710337519.2A Pending CN107203601A (en) 2017-05-15 2017-05-15 Data processing method and device applied to accounting processing

Country Status (1)

Country Link
CN (1) CN107203601A (en)

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109840837A (en) * 2017-11-27 2019-06-04 财付通支付科技有限公司 Processing method, device, computer-readable medium and the electronic equipment of financial data
CN114140211A (en) * 2021-12-01 2022-03-04 中国建设银行股份有限公司 General ledger data processing method, apparatus, equipment, storage medium and program product
CN117931737A (en) * 2024-01-24 2024-04-26 苏州思客科技(集团)有限公司 Bill file splitting method and system based on multidimensional configuration

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20030083893A1 (en) * 2001-10-29 2003-05-01 Aliffi Patrick A. System and method for facilitating reciprocative small business financial information exchanges
CN101510203A (en) * 2009-02-25 2009-08-19 南京联创科技股份有限公司 Big data quantity high performance processing implementing method based on parallel process of split mechanism
CN101963969A (en) * 2009-07-22 2011-02-02 阿里巴巴集团控股有限公司 Method and database server for realizing load balancing in Oracle RAC (Real Application Cluster) system
CN102609875A (en) * 2012-01-20 2012-07-25 中国工商银行股份有限公司 Method and system for concurrently and dynamically processing bank data
CN104731891A (en) * 2015-03-17 2015-06-24 浪潮集团有限公司 Method for extracting mass data in ETL (extract transform load)

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20030083893A1 (en) * 2001-10-29 2003-05-01 Aliffi Patrick A. System and method for facilitating reciprocative small business financial information exchanges
CN101510203A (en) * 2009-02-25 2009-08-19 南京联创科技股份有限公司 Big data quantity high performance processing implementing method based on parallel process of split mechanism
CN101963969A (en) * 2009-07-22 2011-02-02 阿里巴巴集团控股有限公司 Method and database server for realizing load balancing in Oracle RAC (Real Application Cluster) system
CN102609875A (en) * 2012-01-20 2012-07-25 中国工商银行股份有限公司 Method and system for concurrently and dynamically processing bank data
CN104731891A (en) * 2015-03-17 2015-06-24 浪潮集团有限公司 Method for extracting mass data in ETL (extract transform load)

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
缪忠宜: "国有大型商业银行ERP财务系统的设计与实现", 《中国优秀硕士论文库》 *

Cited By (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109840837A (en) * 2017-11-27 2019-06-04 财付通支付科技有限公司 Processing method, device, computer-readable medium and the electronic equipment of financial data
CN109840837B (en) * 2017-11-27 2022-09-20 财付通支付科技有限公司 Financial data processing method and device, computer readable medium and electronic equipment
CN114140211A (en) * 2021-12-01 2022-03-04 中国建设银行股份有限公司 General ledger data processing method, apparatus, equipment, storage medium and program product
CN117931737A (en) * 2024-01-24 2024-04-26 苏州思客科技(集团)有限公司 Bill file splitting method and system based on multidimensional configuration

Similar Documents

Publication Publication Date Title
CN109614409A (en) Business data processing method, device and server
CN107688591B (en) A kind of actuarial treating method and apparatus
CN107563889A (en) Account balance information processing method and processing device
CN107993151A (en) Fund exchange settlement method, apparatus, equipment and computer-readable recording medium
CN112506588B (en) Data processing method and device for insurance business, electronic equipment and storage medium
CN105303437A (en) Processing method and device for account checking
WO2016060550A1 (en) Electronic processing system for electronic document and electronic file
CN110019194A (en) Verification of data method, apparatus, computer equipment and storage medium
CN104077680A (en) Contract management system for E-business platform
CN107977787A (en) A kind of transaction risk control processing system and method
CN104867250B (en) A kind of processing method and processing device of business handling data
CN106204175A (en) For opening the method and system of many tax rates VAT invoice without amount of tax to be paid sales slip
CN107203601A (en) Data processing method and device applied to accounting processing
CN114021005A (en) Network information query method, device, equipment and storage medium
CN106056418A (en) Invoice submission method, device and system
CN106951913A (en) The method for carrying out data exchange, cloud platform and system
CN108537522A (en) Account balance computational methods in a kind of block chain block
CN108228736A (en) Data processing method, data processing system and computer readable storage medium
CN111144855B (en) Service data storage method and device
CN102521713A (en) Data processing device and data processing method
CN109935287A (en) A kind of similarity analysis method, device and equipment of medical record information
CN110704470B (en) Bill data duplication elimination method, terminal equipment and storage medium
CN109324963A (en) The method and terminal device of automatic test profitable result
CN108108492A (en) A kind of data processing method, device and assets center system
CN107133780A (en) Management method and device in a kind of open task-set

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
RJ01 Rejection of invention patent application after publication
RJ01 Rejection of invention patent application after publication

Application publication date: 20170926