CN110020930B - Financial data system construction method and device - Google Patents
Financial data system construction method and device Download PDFInfo
- Publication number
- CN110020930B CN110020930B CN201811603399.7A CN201811603399A CN110020930B CN 110020930 B CN110020930 B CN 110020930B CN 201811603399 A CN201811603399 A CN 201811603399A CN 110020930 B CN110020930 B CN 110020930B
- Authority
- CN
- China
- Prior art keywords
- data
- financial
- layer
- financial data
- difference
- 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
Images
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/22—Indexing; Data structures therefor; Storage structures
-
- 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/12—Accounting
- G06Q40/125—Finance or payroll
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Development Economics (AREA)
- Technology Law (AREA)
- Strategic Management (AREA)
- General Business, Economics & Management (AREA)
- Marketing (AREA)
- Economics (AREA)
- Software Systems (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The application provides a financial data system construction method and device. The method comprises the steps of firstly constructing a hierarchical financial data model, guaranteeing the accuracy of financial data quality through data checking layer by layer, designing an upward/downward link as a unique identifier of a data dimension to connect the checking results of all financial data layers in series, and accordingly drilling down from the difference layer by layer of the upper layer until a data layer with difference is found when the financial data checking results are different.
Description
Technical Field
The specification relates to the technical field of internet, in particular to a financial data system construction method and device.
Background
With the development of electronic payment, the financial data volume of various payment platforms is increasingly huge to give an example of a payment bank, the financial system of the payment bank is connected with each business system of the payment bank, business documents generated by various business systems every day need to be input into the financial system, a large number of financial statements can be correspondingly generated, and financial staff carries out daily financial activities according to the statements, such as account checking with a merchant, reporting to a management layer, data disclosure to the outside and the like.
All financial activities are performed correctly on the premise that the data provided by the financial system is correct. Therefore, the requirement on the accuracy of the data is extremely high, and each minute needs to be accurate. In the face of the huge and complicated data and the high-requirement data quality, how to establish a set of traceable financial data system with quality guarantee from the upper layer to the lower layer is a problem which is not solved by the prior art.
Disclosure of Invention
In view of the foregoing technical problems, embodiments of the present specification provide a method and an apparatus for constructing a financial data system, and a technical solution is as follows:
according to a first aspect of embodiments herein, there is provided a financial data architecture construction method, the method comprising:
determining financial data layers in different levels from low to high, wherein the financial data layers in different levels from low to high comprise a detail data layer and at least one financial statement layer, and the financial data layer acquisition method comprises the following steps: data summarization is carried out on the financial detail data by using a preset report processing method so as to obtain an upper-layer financial report with thicker corresponding data dimension, and by analogy, data summarization is continuously carried out on the upper-layer financial report data, and the financial detail data and the sequentially obtained financial report data from the fine dimension data to the coarse dimension data layer by layer upwards are determined as financial data layers from low to high;
obtaining a checking result which is correspondingly output after data checking is carried out on each financial data layer, wherein the checking result at least comprises data difference between each financial data layer and a subordinate financial data layer;
and correspondingly adding at least one pointing link for the checking result of each financial data layer according to checking result check relations of different financial data layers, wherein the pointing link comprises an upward link or a downward link, the upward link of each financial data layer is consistent with the downward link of the upper financial data layer, and the pointing link points to the checking result of a thicker dimension or a thinner dimension of the upper financial data layer or the lower financial data layer corresponding to the checking result of the current financial data layer.
According to a second aspect of embodiments of the present specification, there is provided a method for locating financial difference data based on a financial data system, the method comprising:
acquiring a check result layer with difference data in the financial data system, determining a down link corresponding to the difference data, and determining the position of the difference data in a next layer of check result according to the down link;
and continuing to acquire the downward link of the difference data in the next layer of check results, and sequentially searching downward until the layer of the check results which initially generates the difference data is determined.
According to a third aspect of embodiments herein, there is provided a financial difference data locating apparatus based on a financial data system, the apparatus comprising:
a financial data determination module: the device is used for determining financial data layers from low to high, wherein the financial data layers from low to high comprise a detail data layer and at least one financial statement layer, and the acquisition device of the financial data layers comprises: data summarization is carried out on the financial detail data by using a preset report processing method so as to obtain an upper-layer financial report with thicker corresponding data dimension, and by analogy, data summarization is continuously carried out on the upper-layer financial report data, and the financial detail data and the sequentially obtained financial report data from the fine dimension data to the coarse dimension data layer by layer upwards are determined as financial data layers from low to high;
a check result acquisition module: the system comprises a data acquisition module, a data processing module and a data processing module, wherein the data acquisition module is used for acquiring a checking result which is correspondingly output after data checking is carried out on each financial data layer, and the checking result at least comprises data difference between each financial data layer and a subordinate financial data layer;
a point link addition module: the system is used for correspondingly adding at least one pointing link for the check result of each financial data layer according to check result check relations of different financial data layers, wherein the pointing link comprises an upward link or a downward link, the upward link of each financial data layer is consistent with the downward link of an upper financial data layer, and the pointing link points to the check result of a thicker dimension or a thinner dimension of the upper financial data layer or the lower financial data layer corresponding to the check result of the current financial data layer.
According to a fourth aspect of embodiments herein, there is provided a financial difference data locating apparatus based on a financial data system, the apparatus comprising:
a difference data acquisition module: the system comprises a checking result layer, a down link and a data processing layer, wherein the checking result layer is used for acquiring checking result layers with difference data in the financial data system, determining the down link corresponding to the difference data, and determining the position of the difference data in the next layer of checking result according to the down link;
an initial difference determination module: and the downward link of the difference data in the next layer of checking results is continuously obtained, and the downward search is carried out sequentially until the checking result layer which initially generates the difference data is determined.
According to a fifth aspect of embodiments herein, there is provided a computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor when executing the program implements a method of financial data architecture, the method comprising:
determining financial data layers in different levels from low to high, wherein the financial data layers in different levels from low to high comprise a detail data layer and at least one financial statement layer, and the financial data layer acquisition method comprises the following steps: data summarization is carried out on the financial detail data by using a preset report processing method so as to obtain an upper-layer financial report with thicker corresponding data dimension, and by analogy, data summarization is continuously carried out on the upper-layer financial report data, and the financial detail data and the sequentially obtained financial report data from the fine dimension data to the coarse dimension data layer by layer upwards are determined as financial data layers from low to high;
obtaining a checking result which is correspondingly output after data checking is carried out on each financial data layer, wherein the checking result at least comprises data difference between each financial data layer and a subordinate financial data layer;
and correspondingly adding at least one pointing link for the check result of each financial data layer according to check result check relations of different financial data layers, wherein the pointing link comprises an upward link or a downward link, the upward link of each financial data layer is consistent with the downward link of an upper financial data layer, and the pointing link points to the check result of a thicker dimension or a thinner dimension of the upper financial data layer or the lower financial data layer corresponding to the check result of the current financial data layer.
According to a sixth aspect of embodiments herein, there is provided a computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor when executing the program implements a method for locating financial difference data based on a financial data hierarchy, the method comprising:
acquiring a check result layer with difference data in the financial data system, determining a down link corresponding to the difference data, and determining the position of the difference data in a next layer of check result according to the down link;
and continuing to acquire the downward link of the difference data in the next layer of check results, and sequentially searching downward until the layer of the check results which initially generates the difference data is determined.
According to the technical scheme provided by the embodiment of the specification, a financial data system construction method is provided, a hierarchical financial data model is constructed firstly, the accuracy of financial data quality is guaranteed through layer-by-layer data checking, and the upward/downward link is designed to be used as the unique identifier of a data dimension to connect the checking results of all financial data layers in series, so that when the financial data checking results are different, the data layer can be drilled downwards from the different layer of the upper layer until the different data layer is found.
It is to be understood that both the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of embodiments of the invention.
In addition, any one of the embodiments in the present specification is not required to achieve all of the effects described above.
Drawings
In order to more clearly illustrate the embodiments of the present specification or the technical solutions in the prior art, the drawings needed to be used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments described in the embodiments of the present specification, and other drawings can be obtained by those skilled in the art according to the drawings.
FIG. 1 is a flow diagram illustrating a method for financial data architecture construction in accordance with an exemplary embodiment of the present description;
FIG. 2 is another flow diagram of a method for constructing a financial data hierarchy in accordance with an exemplary embodiment of the present description;
FIG. 3 is a schematic diagram of a financial data hierarchy shown in an exemplary embodiment of the present description;
FIG. 4 is a schematic diagram of a financial discrepancy data locating method based on a financial data hierarchy as illustrated in an exemplary embodiment of the present description;
FIG. 5 is a schematic diagram of a financial data architecture building apparatus shown in an exemplary embodiment of the present description;
FIG. 6 is a schematic diagram of a financial discrepancy data locating device based on a financial data system as illustrated in an exemplary embodiment of the present description;
fig. 7 is a schematic structural diagram of a computer device according to an exemplary embodiment of the present specification.
Detailed Description
Reference will now be made in detail to the exemplary embodiments, examples of which are illustrated in the accompanying drawings. When the following description refers to the accompanying drawings, like numbers in different drawings represent the same or similar elements unless otherwise indicated. The embodiments described in the following exemplary embodiments do not represent all embodiments consistent with the present specification. Rather, they are merely examples of apparatus and methods consistent with certain aspects of the specification, as detailed in the appended claims.
The terminology used in the description herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the description. As used in this specification and the appended claims, the singular forms "a", "an", and "the" are intended to include the plural forms as well, unless the context clearly indicates otherwise. It should also be understood that the term "and/or" as used herein refers to and encompasses any and all possible combinations of one or more of the associated listed items.
It should be understood that although the terms first, second, third, etc. may be used herein to describe various information, such information should not be limited to these terms. These terms are only used to distinguish one type of information from another. For example, the first information may also be referred to as second information, and similarly, the second information may also be referred to as first information, without departing from the scope of the present specification. The word "if" as used herein may be interpreted as "at" \8230; "or" when 8230; \8230; "or" in response to a determination ", depending on the context.
With the development of electronic payment, the financial data volume of various payment platforms is increasingly huge to give an example of a payment bank, the financial system of the payment bank is connected with each business system of the payment bank, business documents generated by various business systems every day need to be input into the financial system, a large number of financial statements can be correspondingly generated, and financial staff carries out daily financial activities according to the statements, such as account checking with a merchant, reporting to a management layer, data disclosure to the outside and the like.
All financial activities are performed normally on the premise that the data provided by the financial system is correct. Therefore, the requirement on the accuracy of the data is extremely high, and each minute needs to be accurate. In the face of the huge and complicated data and the high-requirement data quality, how to establish a set of traceable financial data system with quality guarantee from the upper layer to the lower layer is a problem which is not solved by the prior art.
In view of the above problems, an embodiment of the present specification provides a financial data system construction method and a financial data system construction device for executing the method, and the method according to the embodiment is described in detail below, and with reference to fig. 1, the method may include the following steps:
s101, determining financial data layers of different levels from low to high, wherein the financial data layers of different levels from low to high comprise a detail data layer and at least one financial report surface layer;
the financial system is used for carrying out accounting and posting functions, the operation perception of all business systems related to income, expense and fund is realized, posting certificates are generated according to business documents sent by the business systems according to a certain rule, the financial statements are processed into statements which can be understood by business personnel according to the posting certificates in different business view angles, and the data quality of the whole process from posting details to statement presentation is difficult to guarantee due to system transparent transmission, complex logic of the whole process from detail processing into statements, tortuous system links and difficulty in guaranteeing of the data quality of the whole process from posting details.
Therefore, the embodiment designs a financial data system with quality assurance, wherein the method for acquiring the financial data layer in the financial data system specifically includes: and summarizing the financial detail data by using a preset report processing method to obtain an upper-layer financial report with thicker corresponding data dimension, and repeating the data summarization on the upper-layer financial report data, so that the financial detail data and the sequentially obtained financial report data from the fine dimension data to the coarse dimension data layer by layer upwards are determined as a low-to-high financial data layer.
Specifically, the following two tables are referred to, which are respectively schematic diagrams of the financial detail data and the upper-layer financial statement obtained after the data summarization is performed on the financial detail data:
| up-linking | Business document number | Amount of accounting | Amount of business | …… |
| Company A _ P product _ C user | 0001 | 10 | 11 | …… |
| Company A _ P product _ C user | 0002 | 10 | 12 | …… |
Financial statement data sheet
Upper financial statement
The financial detail data is generated by business document details according to a certain entry rule, and the business document details are various account records generated by different upstream business systems in daily business operation.
The report processing method comprises the steps of obtaining business document details of produced financial detail data, wherein the business document details comprise data records of each business; and determining a required format of the upper-layer financial statement based on the service scene of the detail of the service bill, and further determining a corresponding statement processing method.
S102, obtaining a checking result correspondingly output after data checking is carried out on each financial data layer, wherein the checking result at least comprises data difference between each financial data layer and a subordinate financial data layer;
in order to ensure the accuracy of data processing in the report processing process, each financial data layer needs to be checked with the lower financial data layer to determine whether data difference exists between the two financial data layers.
In order to further ensure the accuracy of data contained in each financial data layer, the same-dimension data processing can be carried out on the business data and the financial data, and each financial data layer is checked with the same-dimension business data.
Specifically, business document details can be acquired first, data summarization is performed on business document detail data by keeping data processing dimensions consistent with financial data, the business document details and business data from the fine dimension data to the coarse dimension data acquired in sequence are determined to be different business data layers layer by layer, and finally, data check is performed on each financial data layer and the business data layer with the same dimension. And outputting a data checking result aiming at each financial data layer, wherein the checking result at least comprises the data difference of the financial data layer and the subordinate financial data layer and the data difference of the service data layer with the same dimension.
S103, correspondingly adding at least one pointing link for the checking result of each financial data layer according to checking result check relations of different financial data layers, wherein the pointing link comprises an upward link or a downward link, the upward link of each financial data layer is consistent with the downward link of a higher financial data layer, and the pointing link points to the checking result of a thicker dimension or a thinner dimension of the higher financial data layer or the lower financial data layer corresponding to the checking result of the current financial data layer.
The embodiment designs the up/down link as the unique identifier of the data dimension to connect the check results of the financial data layers in series, so that when the financial data check results are different, the data layers can be drilled down from the different layers of the upper layer until the difference is found. Furthermore, the service personnel can drill down to the finest layer from the difference layer on the uppermost layer, and the specific service generating the data difference is judged according to the data line generated by the difference of the finest layer.
Embodiments of the present specification further provide a more specific method for constructing a financial data system, which is shown in fig. 2, and the method may include the following steps:
s201, performing posting processing on the business document detail to obtain a corresponding financial detail;
s202, carrying out data summarization on different financial attributes and corresponding attribute values contained in the financial details to produce a superior financial statement with thicker corresponding data dimension;
s203, continuing to perform data summarization on different financial attributes and corresponding attribute values contained in the superior financial statement by analogy, and determining financial detail data and sequentially acquired financial statement data from the fine dimensional data to the coarse dimensional data layer by layer upwards as a low-to-high financial data layer;
s204, acquiring business document details, keeping data processing dimensions of the business document detail data consistent with financial data for data summarization, and determining the business document details and the business data which is acquired in sequence from the fine dimension data to the coarse dimension data layer by layer upwards as different business data layers;
s205, performing data check on each financial data layer and the service data layer with the same dimensionality;
s206, performing data check on each financial data layer and the lower financial data layer thereof;
and S207, checking and outputting a checking result aiming at each financial data layer according to the data.
Referring to fig. 3, which is a schematic diagram of the financial data system constructed in this embodiment, financial data (accounting data) and business data are respectively subjected to data aggregation in the same dimension and then processed into a first-level aggregation layer, and the first-level aggregation layer is subjected to data aggregation again and then processed into a second-level aggregation layer. The detail layer, the first-level summary layer and the second-level summary layer are the financial data layer and the business data layer of different levels from low to high.
Further, based on the above-mentioned financial data system, when actually performing the positioning of the financial difference data, a corresponding positioning method can be seen in fig. 4, and the method may include the following steps:
s401, acquiring a check result layer with difference data in the financial data system, determining a down link corresponding to the difference data, and determining the position of the difference data in a next-layer check result according to the down link;
s402, and so on, continuously obtaining the down link of the difference data in the next layer of check result, and searching downwards in sequence until determining the check result layer which initially generates the difference data.
In the embodiment, a general data structure is designed, an up link/down link field is added to the check result of each layer, the up link construction mode of each layer is consistent with the down link of the previous layer, and specific contents can be defined according to business needs. The technical effect obtained by doing so is: it is possible to drill down from the uppermost differential layer up to the finest layer.
For example, the summary dimension of the report of the first-level summary layer is company + product + contract number + industry category + date, and the dimension of the second-level summary layer is company, then in the check result, the upward link forming mode of the detail layer can be company + product + contract number + industry category + date; the downward link of the first-level summary level is formed by company + product + contract number + industry category + date, and the upward link is formed by company; the secondary aggregation level down-links are formed by companies.
In a specific application scenario, sql can be used as a data programming language, and an alias reporting platform is used for displaying the checking result, so that a data system can be further visualized, and business personnel unfamiliar with financial work can complete difference drill-down analysis without technical foundation. This application scenario is illustrated: when the business personnel find that the second-level check results are different, clicking the data of the different row can pop up the first-level check result corresponding to the line change, find the difference data in the first-level check result, continue clicking, and can develop a more detailed check result corresponding to the first-level check result of the row.
Corresponding to the above method embodiment, an embodiment of the present specification further provides a financial data system construction method apparatus, and referring to fig. 5, the apparatus may include: a financial data determination module 510, a collation result acquisition module 520 and a point link addition module 530.
Financial data determination module 510: the device for determining the financial data layers of different levels from low to high comprises a detailed data layer and at least one financial statement layer, wherein the acquisition device of the financial data layers comprises: data summarization is carried out on the financial detail data by using a preset report processing method so as to obtain an upper-layer financial report with thicker corresponding data dimension, and by analogy, data summarization is continuously carried out on the upper-layer financial report data, and the financial detail data and the sequentially obtained financial report data from the fine dimension data to the coarse dimension data layer by layer upwards are determined as financial data layers from low to high;
the verification result obtaining module 520: the system comprises a data acquisition module, a data processing module and a data processing module, wherein the data acquisition module is used for acquiring a checking result which is correspondingly output after data checking is carried out on each financial data layer, and the checking result at least comprises data difference between each financial data layer and a subordinate financial data layer;
the point link addition module 530: the system comprises a plurality of financial data layers, a plurality of direction links and a plurality of index links, wherein the index links are used for correspondingly adding at least one direction link for the check result of each financial data layer according to check result check relations of different financial data layers, the direction links comprise upward links or downward links, the upward link of each financial data layer is consistent with the downward link of the higher financial data layer, and the direction links point to the check result of the thicker dimension or the thinner dimension of the higher financial data layer or the lower financial data layer corresponding to the check result of the current financial data layer.
Corresponding to the foregoing method embodiment, an embodiment of the present specification further provides a financial data system construction method and apparatus, which is applied to a client, and referring to fig. 6, the apparatus may include: a variance data acquisition module 610 and an initial variance determination module 620.
The difference data acquisition module 610: the system comprises a checking result layer, a down link and a data processing layer, wherein the checking result layer is used for acquiring checking result layers with difference data in the financial data system, determining the down link corresponding to the difference data, and determining the position of the difference data in the next layer of checking result according to the down link;
the initial difference determination module 620: and the downward link of the difference data in the next layer of checking results is continuously obtained, and the downward search is carried out sequentially until the checking result layer which initially generates the difference data is determined.
Embodiments of the present specification further provide a computer device, which at least includes a memory, a processor, and a computer program stored on the memory and executable on the processor, wherein the processor implements the aforementioned financial data system construction method when executing the program, and the method at least includes:
determining financial data layers in different levels from low to high, wherein the financial data layers in different levels from low to high comprise a detail data layer and at least one financial statement layer, and the financial data layer acquisition method comprises the following steps: data summarization is carried out on the financial detail data by using a preset report processing method so as to obtain an upper-layer financial report with thicker corresponding data dimension, and so on, data summarization is continuously carried out on the upper-layer financial report data, and the financial detail data and the sequentially obtained financial report data from the fine dimension data to the coarse dimension data layer by layer upwards are determined as financial data layers from low to high;
obtaining a checking result which is correspondingly output after data checking is carried out on each financial data layer, wherein the checking result at least comprises data difference between each financial data layer and a subordinate financial data layer;
and correspondingly adding at least one pointing link for the checking result of each financial data layer according to checking result check relations of different financial data layers, wherein the pointing link comprises an upward link or a downward link, the upward link of each financial data layer is consistent with the downward link of the upper financial data layer, and the pointing link points to the checking result of a thicker dimension or a thinner dimension of the upper financial data layer or the lower financial data layer corresponding to the checking result of the current financial data layer.
Embodiments of the present specification further provide another computer device, which at least includes a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor executes the computer program to implement the foregoing method for locating financial difference data based on a financial data system, and the method includes:
acquiring a check result layer with difference data in the financial data system, determining a down link corresponding to the difference data, and determining the position of the difference data in a next layer of check result according to the down link;
and so on, continuously obtaining the down link of the difference data in the next layer of check result, and searching downwards in sequence until determining the layer of the check result which initially generates the difference data.
Fig. 7 is a more specific hardware structure diagram of a computing device provided in an embodiment of the present specification, where the device may include: a processor 1110, a memory 1120, an input/output interface 1130, a communication interface 1140, and a bus 1150. Wherein the processor 1110, memory 1120, input/output interface 1130, and communication interface 1140 enable communication connections within the device with each other via the bus 1150.
The processor 1110 may be implemented by a general-purpose CPU (Central Processing Unit), a microprocessor, an Application Specific Integrated Circuit (ASIC), or one or more Integrated circuits, and is configured to execute related programs to implement the technical solutions provided in the embodiments of the present disclosure.
The Memory 1120 may be implemented in the form of a ROM (Read Only Memory), a RAM (Random Access Memory), a static storage device, a dynamic storage device, or the like. The memory 1120 can store an operating system and other application programs, and when the technical solution provided by the embodiments of the present specification is implemented by software or firmware, the relevant program codes are stored in the memory 1120 and called by the processor 1110 for execution.
The input/output interface 1130 is used for connecting an input/output module to input and output information. The i/o module may be configured as a component in a device (not shown) or may be external to the device to provide a corresponding function. The input devices may include a keyboard, a mouse, a touch screen, a microphone, various sensors, etc., and the output devices may include a display, a speaker, a vibrator, an indicator light, etc.
The communication interface 1140 is used to connect a communication module (not shown in the figure) to enable the device to interact with other devices. The communication module can realize communication in a wired mode (such as USB, network cable and the like) and also can realize communication in a wireless mode (such as mobile network, WIFI, bluetooth and the like).
It should be noted that although the above-mentioned device only shows the processor 1110, the memory 1120, the input/output interface 1130, the communication interface 1140 and the bus 1150, in a specific implementation, the device may also include other components necessary for normal operation. In addition, those skilled in the art will appreciate that the above-described apparatus may also include only the components necessary to implement the embodiments of the present disclosure, and need not include all of the components shown in the figures.
For the device embodiments, since they substantially correspond to the method embodiments, reference may be made to the partial description of the method embodiments for relevant points. The above-described embodiments of the apparatus are merely illustrative, and the units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one position, or may be distributed on multiple network units. Some or all of the modules can be selected according to actual needs to achieve the purpose of the solution in the specification. One of ordinary skill in the art can understand and implement without inventive effort.
From the above description of the embodiments, it is clear to those skilled in the art that the embodiments of the present disclosure can be implemented by software plus necessary general hardware platform. Based on such understanding, the technical solutions of the embodiments of the present specification may be essentially or partially implemented in the form of a software product, which may be stored in a storage medium, such as a ROM/RAM, a magnetic disk, an optical disk, etc., and includes several instructions for enabling a computer device (which may be a personal computer, a server, or a network device, etc.) to execute the methods described in the embodiments or some parts of the embodiments of the present specification.
The systems, devices, modules or units illustrated in the above embodiments may be implemented by a computer chip or an entity, or by a product with certain functions. A typical implementation device is a computer, which may take the form of a personal computer, laptop computer, cellular telephone, camera phone, smart phone, personal digital assistant, media player, navigation device, email messaging device, game console, tablet computer, wearable device, or a combination of any of these devices.
All the embodiments in the present specification are described in a progressive manner, and the same and similar parts among the embodiments are referred to each other, and each embodiment focuses on the differences from other embodiments. In particular, the apparatus embodiments are substantially similar to the method embodiments and therefore are described in a relatively simple manner, and reference may be made to some of the description of the method embodiments for relevant points. The above-described apparatus embodiments are merely illustrative, and the modules described as separate components may or may not be physically separate, and the functions of the modules may be implemented in one or more software and/or hardware when implementing the embodiments of the present disclosure. And part or all of the modules can be selected according to actual needs to achieve the purpose of the scheme of the embodiment. One of ordinary skill in the art can understand and implement it without inventive effort.
The foregoing is only a specific embodiment of the embodiments of the present disclosure, and it should be noted that, for those skilled in the art, a plurality of modifications and decorations can be made without departing from the principle of the embodiments of the present disclosure, and these modifications and decorations should also be regarded as the protection scope of the embodiments of the present disclosure.
Claims (16)
1. A method of financial data architecture construction, the method comprising:
determining financial data layers in different levels from low to high, wherein the financial data layers in different levels from low to high comprise a detail data layer and at least one financial statement layer, and the financial data layer acquisition method comprises the following steps: data summarization is carried out on the financial detail data by using a preset report processing method so as to obtain an upper-layer financial report with thicker corresponding data dimension, and by analogy, data summarization is continuously carried out on the upper-layer financial report data, and the financial detail data and the sequentially obtained financial report data from the fine dimension data to the coarse dimension data layer by layer upwards are determined as financial data layers from low to high;
obtaining a checking result which is correspondingly output after data checking is carried out on each financial data layer, wherein the checking result at least comprises data difference between each financial data layer and a subordinate financial data layer;
and correspondingly adding at least one pointing link for the checking result of each financial data layer according to checking result check relations of different financial data layers, wherein the pointing link comprises an upward link or a downward link, the upward link of each financial data layer is consistent with the downward link of the upper financial data layer, and the pointing link points to the checking result of a thicker dimension or a thinner dimension of the upper financial data layer or the lower financial data layer corresponding to the checking result of the current financial data layer.
2. The method according to claim 1, wherein the preset report processing method obtaining method comprises:
acquiring business document details of the produced financial detail data, wherein the business document details comprise data records of each business;
and determining the required format of the upper-layer financial statement based on the detailed business scene of the business document, and further determining a corresponding statement processing method.
3. The method of claim 1, wherein the method for acquiring the financial data layers from low to high comprises the following steps:
performing entry processing on the business document details to obtain corresponding financial details;
different financial attributes and corresponding attribute values contained in the financial details are subjected to data summarization to produce a superior financial statement with a thicker corresponding data dimension;
and repeating the data summarization of different financial attributes and corresponding attribute values contained in the higher-level financial statement, and determining the financial detail data and the sequentially acquired financial statement data from the fine dimension data to the coarse dimension data layer by layer upwards as a low-to-high financial data layer.
4. The method of claim 1, wherein said obtaining a corresponding outcome of a reconciliation result for each of said financial data layers after a data reconciliation comprises:
and performing data checking on each financial data layer and the subordinate financial data layers thereof by using a preset data checking strategy, and outputting a checking result aiming at the financial data layers.
5. The method of claim 1, wherein said obtaining a corresponding outcome of a reconciliation result for each of said financial data layers after a data reconciliation comprises:
acquiring business document details, keeping data processing dimensions of the business document detail data consistent with financial data for data summarization, and determining the business document details and the sequentially acquired business data from the fine dimension data to the coarse dimension data layer by layer upwards as business data layers from low to high;
and performing data check on each financial data layer and the service data layer with the same dimensionality, and outputting a check result aiming at the financial data layer.
6. A method of locating financial difference data based on the method of constructing a financial data system according to any one of claims 1 to 5, the method comprising:
acquiring a check result layer with difference data in the financial data system, determining a down link corresponding to the difference data, and determining the position of the difference data in a next layer of check result according to the down link;
and continuing to acquire the downward link of the difference data in the next layer of check results, and sequentially searching downward until the layer of the check results which initially generates the difference data is determined.
7. The method of claim 6, said looking down until after determining a reconciliation results layer that initially generated said difference data, further comprising:
and extracting data information of the difference data in the checking result layer, and determining the generation reason of the difference data according to the data information.
8. A financial data architecture construction apparatus, the apparatus comprising:
a financial data determination module: the device for determining the financial data layers of different levels from low to high comprises a detailed data layer and at least one financial statement layer, wherein the acquisition device of the financial data layers comprises: data summarization is carried out on the financial detail data by using a preset report processing method so as to obtain an upper-layer financial report with thicker corresponding data dimension, and by analogy, data summarization is continuously carried out on the upper-layer financial report data, and the financial detail data and the sequentially obtained financial report data from the fine dimension data to the coarse dimension data layer by layer upwards are determined as financial data layers from low to high;
a check result acquisition module: the system comprises a data acquisition module, a data processing module and a data processing module, wherein the data acquisition module is used for acquiring a checking result which is correspondingly output after data checking is carried out on each financial data layer, and the checking result at least comprises data difference between each financial data layer and a subordinate financial data layer;
point to link addition module: the system comprises a plurality of financial data layers, a plurality of direction links and a plurality of index links, wherein the index links are used for correspondingly adding at least one direction link for the check result of each financial data layer according to check result check relations of different financial data layers, the direction links comprise upward links or downward links, the upward link of each financial data layer is consistent with the downward link of the higher financial data layer, and the direction links point to the check result of the thicker dimension or the thinner dimension of the higher financial data layer or the lower financial data layer corresponding to the check result of the current financial data layer.
9. The apparatus according to claim 8, wherein the preset report processing method obtaining method comprises:
acquiring business document details of the produced financial detail data, wherein the business document details comprise data records of each business;
and determining the required format of the upper-layer financial statement based on the detailed business scene of the business document, and further determining a corresponding statement processing method.
10. The device of claim 8, wherein the means for acquiring the financial data layers at different levels from low to high comprises:
performing posting processing on the business document detail to obtain a corresponding financial detail;
carrying out data summarization on different financial attributes and corresponding attribute values contained in the financial details to produce a higher-level financial statement with thicker corresponding data dimension;
and by analogy, continuously carrying out data summarization on different financial attributes and corresponding attribute values contained in the higher-level financial statement, and determining the financial detail data and the sequentially acquired financial statement data from the detail dimensional data to the rough dimensional data layer by layer upwards as a low-to-high financial data layer.
11. The apparatus of claim 8, said obtaining a reconciliation result corresponding to a yield after data reconciliation for each of said financial data layers, comprising:
and performing data check on each financial data layer and the subordinate financial data layers thereof by using a preset data check strategy, and outputting a check result aiming at the financial data layers.
12. The apparatus of claim 8, said obtaining a reconciliation result corresponding to a yield after data reconciliation for each of said financial data layers, comprising:
acquiring business document details, keeping data processing dimensions of the business document detail data consistent with financial data for data summarization, and determining the business document details and the business data which is acquired in sequence from the fine dimension data to the coarse dimension data layer by layer upwards as different business data layers;
and performing data check on each financial data layer and the service data layer with the same dimensionality, and outputting a check result aiming at the financial data layer.
13. A financial difference data locating apparatus based on the financial data hierarchy building apparatus of any one of claims 8 to 12, the apparatus comprising:
a difference data acquisition module: the system comprises a checking result layer, a down link and a data processing layer, wherein the checking result layer is used for acquiring checking result layers with difference data in the financial data system, determining the down link corresponding to the difference data, and determining the position of the difference data in the next layer of checking result according to the down link;
an initial difference determination module: and the downward link of the difference data in the next layer of checking results is continuously obtained, and the downward search is carried out sequentially until the checking result layer which initially generates the difference data is determined.
14. The apparatus of claim 13, said looking down until after determining a reconciliation results layer that initially generated said difference data, further comprising:
and extracting data information of the difference data in the checking result layer, and determining the generation reason of the difference data according to the data information.
15. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the method of claim 1 when executing the program.
16. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the method of claim 6 when executing the program.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811603399.7A CN110020930B (en) | 2018-12-26 | 2018-12-26 | Financial data system construction method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811603399.7A CN110020930B (en) | 2018-12-26 | 2018-12-26 | Financial data system construction method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110020930A CN110020930A (en) | 2019-07-16 |
| CN110020930B true CN110020930B (en) | 2023-04-07 |
Family
ID=67188703
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811603399.7A Active CN110020930B (en) | 2018-12-26 | 2018-12-26 | Financial data system construction method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110020930B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114677206A (en) * | 2022-05-27 | 2022-06-28 | 深圳市赢向量科技有限公司 | Data checking system for performing autonomous financial checking through data checking |
| CN117648361A (en) * | 2023-12-18 | 2024-03-05 | 中国人寿保险股份有限公司 | Data benchmarking method, device, computer equipment and storage medium |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104021450A (en) * | 2014-06-19 | 2014-09-03 | 北京工商大学 | Conglomerate statement management method and device |
| CN106228439A (en) * | 2016-07-22 | 2016-12-14 | 李丹 | A kind of financial data management method and system |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20130212455A1 (en) * | 2012-02-10 | 2013-08-15 | William Roger Titera | System and Method for Examining the Financial Data of an Organization |
-
2018
- 2018-12-26 CN CN201811603399.7A patent/CN110020930B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104021450A (en) * | 2014-06-19 | 2014-09-03 | 北京工商大学 | Conglomerate statement management method and device |
| CN106228439A (en) * | 2016-07-22 | 2016-12-14 | 李丹 | A kind of financial data management method and system |
Non-Patent Citations (1)
| Title |
|---|
| 财务报表分析的新视角及财务数据的外延思考;杨峻;《企业科技与发展》;20181010(第10期);第298-299页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110020930A (en) | 2019-07-16 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111708934B (en) | Knowledge content evaluation method, device, electronic equipment and storage medium | |
| US20180165347A1 (en) | Multi-dimensional analysis using named filters | |
| TW202029079A (en) | Method and device for identifying irregular group | |
| CN102187346B (en) | For making system and the process of sensitive information safety | |
| CN112699249B (en) | Knowledge graph-based information processing method, device, equipment and storage medium | |
| CN107357812A (en) | A kind of data query method and device | |
| US20150186776A1 (en) | Contextual data analysis using domain information | |
| US9633110B2 (en) | Enrichment of data using a semantic auto-discovery of reference and visual data | |
| TW201140349A (en) | Compensating for unbalanced hierarchies when generating OLAP queries from report specifications | |
| CN110008193A (en) | Data normalization method and device | |
| US10691704B2 (en) | Domain-based search engine | |
| CA3055029C (en) | System for data consolidation across disparate namespaces | |
| CN110020930B (en) | Financial data system construction method and device | |
| Alghushairy et al. | Data storage | |
| JP2017532675A (en) | Guided data exploration | |
| CN107391533A (en) | Generate the method and device of graphic data base Query Result | |
| CN106033390A (en) | Mail style testing method and apparatus | |
| CN107067276A (en) | Determine the method and device of object influences power | |
| US20160162814A1 (en) | Comparative peer analysis for business intelligence | |
| US10241899B2 (en) | Test input information search device and method | |
| US9639610B1 (en) | Method for gauging public interest in a topic using network analysis of online discussions | |
| Goh et al. | Forensic analytics using cluster analysis: Detecting anomalies in data | |
| AU2017232032A1 (en) | Real-time method and system for assessing and improving a presence and perception of an entity | |
| Huang et al. | Data cleansing | |
| CN108733696B (en) | Credit investigation form generation method and device |
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 | ||
| TA01 | Transfer of patent application right | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20200924 Address after: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman Islands Applicant after: Innovative advanced technology Co.,Ltd. Address before: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman Islands Applicant before: Advanced innovation technology Co.,Ltd. Effective date of registration: 20200924 Address after: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman Islands Applicant after: Advanced innovation technology Co.,Ltd. Address before: A four-storey 847 mailbox in Grand Cayman Capital Building, British Cayman Islands Applicant before: Alibaba Group Holding Ltd. |
|
| GR01 | Patent grant | ||
| GR01 | Patent grant |