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.
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).
Bus 1150 includes a pathway for communicating information between various components of the device, such as processor 1110, memory 1120, input/output interface 1130, and communication interface 1140.
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.