CN115686317A

CN115686317A - Business data processing method and device, electronic equipment and storage medium

Info

Publication number: CN115686317A
Application number: CN202110790756.0A
Authority: CN
Inventors: 于天放
Original assignee: Tencent Technology Shenzhen Co Ltd
Current assignee: Tencent Technology Shenzhen Co Ltd
Priority date: 2021-07-13
Filing date: 2021-07-13
Publication date: 2023-02-03

Abstract

The invention discloses a business data processing method, a business data processing device, electronic equipment and a storage medium, wherein the method comprises the steps of displaying an editing interface, wherein the editing interface comprises a component bar area and an operation area; responding to a target operation instruction, configuring standardized components in a component column area in a working area, and determining a plurality of data tables, a plurality of fields in the data tables and continuity relations of the fields in the data tables; generating a target audit code according to the data tables, the fields in the data tables and the continuity relation of each field in the data tables, wherein the target audit code is used for performing continuity audit on the service data corresponding to the field to be audited; the implementation process of the invention does not need manual audit of personnel at the audit side, reduces the labor cost and improves the audit efficiency, in addition, the invention also reduces the workload of manually writing codes, effectively reduces the error probability, improves the audit quality, and can be widely applied to the technical field of computers.

Description

Business data processing method and device, electronic equipment and storage medium

Technical Field

The present invention relates to the field of computer technologies, and in particular, to a method and an apparatus for processing service data, an electronic device, and a storage medium.

Background

With the development of information technology, the amount of service data generated in the informatization process of each industry is increasingly huge, and in some fields, continuous auditing needs to be performed on special service data so as to reduce potential risks in related services and provide help for development decisions of related services.

For example, an important field in a business data table of a financial institution is an account amount of a user, when the user performs a transaction, the account amount in the business data table changes, generally, a new business data is generated by referring to a field format of the business data table every time the transaction occurs, and according to a requirement of continuity constraint, compared with an old business data, a field value of a final balance in the old business data should be equal to a field value of an initial balance in the new business data, which is a relationship between two pieces of business data. In contrast, the continuity audit work of the auditor is to check whether the two pieces of service data meet the continuity constraint, so as to evaluate whether the value of the account amount is wrong.

The traditional auditing mode needs to be repeatedly communicated with service side personnel by auditing side personnel, the data table content and the field meaning of each service data in the service side are determined, then the auditing side personnel carry out continuity auditing on some data according to experiences, the labor cost is high, the error probability is high, in addition, the accuracy of the auditing object depends on the experiences of the auditing side personnel, auditing mistakes and omissions are easy to occur, the potential risks of mistakes and omissions exist, the auditing efficiency is low, and the auditing method is not reliable enough.

Disclosure of Invention

In view of this, in order to solve at least one defect in the prior art, embodiments of the present invention provide a service data processing method, an apparatus, an electronic device, and a storage medium, so as to reduce labor cost and error probability, and improve efficiency and quality of service data continuity audit.

One aspect of the present invention provides a method for processing service data, including:

displaying an editing interface, wherein the editing interface comprises a component bar area and an operation area, the component bar area comprises a plurality of standardized components, and each standardized component is used for determining the type of a business data table, field information of the business data table or the continuity relation among fields in the business data table;

responding to a target operation instruction, configuring the standardized components of the component column area in the operation area, and determining a plurality of data tables, a plurality of fields in the data tables and continuity relations of the fields in the data tables;

and generating a target audit code according to the plurality of data tables, the plurality of fields in the data tables and the continuity relation of each field in the data tables, wherein the target audit code is used for performing continuity audit on the service data corresponding to the field to be audited.

Another aspect of the embodiments of the present invention provides a service data processing apparatus, including:

the system comprises a first module, a second module and a third module, wherein the first module is used for displaying an editing interface, the editing interface comprises a component column area and an operation area, the component column area comprises a plurality of standardized components, and each standardized component is used for determining the type of a service data table, field information of the service data table or the continuity relation among fields in the service data table;

a second module, configured to configure the standardized component in the component column region in the working region in response to a target operation instruction, and determine a plurality of data tables, a plurality of fields in the data tables, and a continuity relationship between the fields in the data tables;

and the third module is used for generating target audit codes according to the plurality of data tables, the plurality of fields in the data tables and the continuity relation of each field in the data tables, wherein the target audit codes are used for performing continuity audit on the service data corresponding to the fields to be audited.

Another aspect of the embodiments of the present invention provides an electronic device, including a processor and a memory;

the memory is used for storing programs;

the processor executes the program to implement the method as described in the foregoing.

The embodiment of the invention also discloses a computer program product or a computer program, which comprises computer instructions, and the computer instructions are stored in a computer readable storage medium. The computer instructions may be read by a processor of a computer device from a computer-readable storage medium, and the computer instructions executed by the processor cause the computer device to perform the foregoing method.

The embodiment of the invention firstly displays an editing interface, wherein the editing interface comprises a component bar area and an operation area, the component bar area comprises a plurality of standardized components, and each standardized component is used for determining the type of a business data table, the field information of the business data table or the continuity relation among fields in the business data table; then, responding to a target operation instruction, configuring the standardized components of the component column area in the operation area, and determining a plurality of data tables, a plurality of fields in the data tables and continuity relations of the fields in the data tables; finally, generating a target audit code according to the plurality of data tables, the plurality of fields in the data tables and the continuity relation of each field in the data tables, wherein the target audit code is used for performing continuity audit on the service data corresponding to the field to be audited; according to the invention, through the operation of the standardized components in the visual editing interface, such as dragging, clicking and the like, the continuity relation between the fields to be audited can be determined, then the target audit code is automatically generated to perform continuity audit on the service data corresponding to the fields to be audited, the whole process does not need manual audit of personnel at the audit side, the visual interface enables the personnel at the service side and the audit side to easily understand the service logic, the labor cost is reduced, and the audit efficiency is improved; in addition, the invention provides a standardized function for service personnel, reduces the workload of manually writing codes, effectively reduces the error probability and improves the auditing quality.

Drawings

In order to more clearly illustrate the technical solutions in the embodiments of the present application, the drawings needed to be used in the description of the embodiments are briefly introduced below, and it is obvious that the drawings in the following description are only some embodiments of the present application, and it is obvious for those skilled in the art to obtain other drawings based on these drawings without creative efforts.

Fig. 1 is a schematic diagram of an implementation environment of a service data processing method provided in this embodiment;

fig. 2 is a flowchart illustrating steps of a service data processing method according to this embodiment;

FIG. 3 is a schematic diagram of an editing interface of the software system according to the embodiment;

FIG. 4 is a diagram illustrating a continuity relationship between fields of a data table established in a working area according to the present embodiment;

FIG. 5 is a diagram illustrating operations of creating a data table of a transaction by the first standardized component according to the embodiment;

FIG. 6 is a diagram illustrating operations of creating or modifying fields of a data table by a second standardized component according to the embodiment;

FIG. 7 is a diagram illustrating operations of establishing continuity relationships among fields of a data table via a third standardized component according to the embodiment;

FIG. 8 is a schematic diagram illustrating operations of establishing continuity relationships among fields of a data table via a connection line and a third standardized component according to the present embodiment;

FIG. 9 is a flowchart illustrating a step of selecting candidate fields from the business data table according to the continuity constraint condition in the present embodiment;

FIG. 10 is a diagram illustrating the operation of the present embodiment for constructing continuity constraints between fields of a data table;

FIG. 11 is a schematic diagram illustrating an operation of associating or merging data table sets according to the present embodiment;

fig. 12 is a flowchart illustrating steps of another service data processing method according to this embodiment;

fig. 13 is a schematic structural diagram of a service data device according to this embodiment.

Detailed Description

In order to make the objects, technical solutions and advantages of the present application more clearly understood, the present application is further described in detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the present application and are not intended to limit the present application.

In the field of computer technology, a software system refers to a computer software system composed of system software, support software and application software, and is an important component in a computer system. In order to realize human-computer interaction with a user and acquire an operation logic of the user, a software system is generally completed based on a user interface. The user interface is a medium for interaction and information exchange between the system and the user, and can realize the conversion between the internal form of the computer and the acceptable form of the human. Visualization (Visualization) is also an indispensable ring in the process of human-computer interaction through a user interface, and the Visualization technology is a theory, method or technology which utilizes computer graphics and image processing technology to convert data into graphics or images to be displayed on a screen and perform interactive processing; the visualization technology enables a user to directly operate the information with the body in the graphical interface, and the work efficiency of communication with a computer is improved.

As a monitoring mechanism, along with the progress of information technology and the cross-fusion with the field, in the related art, the economic data can be monitored through an auditing software system, for example, whether the transaction data generated in the auditing software system has business continuity or not can be audited through the auditing software system. However, in the related field of auditing, the degree of informatization is relatively low, and the coupling between the business side and the auditing side is too high in the auditing activity, so that auditing is assisted by a software system of a computer, and the communication cost of the auditing process is too high due to the lack of a uniform standard for the data of the business side and the auditing side. Besides, audit analysis depends on personal ability and understanding of auditors, and efficiency and quality of audit analysis cannot be guaranteed, so that research and development efficiency of a software system special for audit is low.

To this end, an embodiment of the present invention provides a business data processing method, which is based on an editing interface of a software system, in the editing interface, an embodiment may configure a standardized component in a component column in a job area according to a target operation instruction of a user, and determine an element to be audited, where the element may include, but is not limited to, a data table, a field in the data table, and a continuity relationship between fields. Then, the embodiment generates a target audit code according to the element to be audited, and conducts continuous audit. The continuity mentioned above refers to the business continuity of the transaction data such as the amount of money and the point, and the continuity may reflect the change of the transaction data due to the operation such as consumption and transaction. The embodiment of the invention can automatically generate the target audit code to carry out continuous audit on the service data in the element to be audited by operating the standardized component in the editing interface, such as dragging, clicking and the like, without manual audit of personnel at the audit side, and the editable operation interface in the embodiment enables the personnel at the service side and the audit side to easily understand the service logic, thereby reducing the labor cost and improving the audit efficiency; in addition, the embodiment provides the standardized function for the service personnel to use through the component packaged by the standardized function, so that the workload of manually writing codes is reduced, the process is simpler, the error probability is effectively reduced, and the auditing quality is improved.

FIG. 1 is a schematic diagram of an implementation environment provided by the present invention. As shown in fig. 1, in this implementation environment, a terminal 101 and a server 102 are included. The terminal 101 is equipped with a software system for processing service data, and the software system can perform continuity relation audit of the service data table. The editing interface of the software system is a visual user interface, the operation area is divided in the user interface, and the divided areas include but are not limited to a component bar area and an operation area; a plurality of standardized components for representing continuity relations are contained in the component column area. And the software system responds to the target operation instruction, configures the standardized components in the operation area, generates target audit codes according to the continuity relation represented by the configured standardized components, and performs continuity audit on the service data to be audited. In this implementation environment, the terminal 101 may be any electronic product that can perform human-computer interaction in one or more manners, such as a keyboard, a touch pad, a touch screen, a remote controller, voice interaction, or a handwriting device, and the electronic product may receive a target operation instruction of a user through a visual operation interface thereof, and perform real-time visual display on a result of the operation instruction. Illustratively, as shown in fig. 1, the terminal 101 may be a Personal Computer (PC), a mobile phone, a smart phone 1011, a Personal Digital Assistant (PDA), a wearable device, a Pocket PC (PPC), a tablet PC, or the like.

In addition, in the implementation environment shown in fig. 1, the terminal 101 may establish a communication connection with the server 102 through a network protocol, and store a large amount of service data in the database of the server 102, where the service data may be data that is not audited, or service data that has been audited, or intermediate service data that is temporarily stored during the auditing process. The server 102 may push various types of data to the terminal 101 according to different invoking instructions sent by the terminal 101. Target audit code is stored in server 102 for performing a continuity audit. In the implementation environment, the server may adopt an independent server, or a server cluster composed of a plurality of servers, or a cloud computing service center; the form of the server is not limited to the form described in the above example, and it can be understood that the server also has a data storage function, and the storage function may be implemented by using a local database or a cloud database.

Taking a specific auditing process as an example, in the implementation environment shown in fig. 1, the complete process of service data processing is as follows: firstly, acquiring service data to be audited from a server 102 through a data acquisition control or instruction on an editing interface, namely a visual user operation interface, of a terminal 101, and displaying the service data on the editing interface; in an embodiment, the business data to be audited can be visually displayed in the form of a data table. The operation interface comprises at least a component column area and an operation area, wherein the component column area comprises standardized components in various forms, and the standardized components can be used for determining the type of a business data table, field information of the business data table or continuity relations among fields in the business data table; for example, the existence of continuity relationships between fields of a form may be represented by way of a connection line component; the content of the continuity relation can also be represented by a functional component, for example. The embodiment acquires operation instructions such as clicking, dragging and connecting performed by a user on an editing interface, responds to the operation instructions, configures operation targets, namely various elements placed in a working area, and determines a plurality of data tables, a plurality of fields in the data tables and continuity relations of the fields in the data tables. After configuration is completed, according to a target audit code generated by the server 102, service data in a data table to be audited in a working area of the terminal 101 are continuously audited, and a result obtained by auditing is visually displayed.

It should be understood that the embodiment of the present invention is only an implementation environment that can be implemented and an implementation result of a possibility exemplarily illustrated in fig. 1, that is, a user sends a data retrieval request through the terminal 101, and the server 102 packages and feeds corresponding data to the terminal 101 for visual display according to the data retrieval request. In other application scenarios of the embodiment of the present invention, the service data processing method may also be implemented only by the terminal 101 carrying the service data processing software system, for example: after the terminal 101 is disconnected from the communication connection with the server 102, a user can perform off-line operation according to data cached in the terminal, and a program is generated according to a target audit code built in the terminal 101 to obtain the target audit code for continuous audit; after the terminal is reconnected to the server 102, the service data cached in the local by the terminal 101 and the related continuity relation are uploaded and updated to the server 102 for data storage and update. The embodiment of the present invention is not limited to a specific application scenario, and the application scenario in fig. 1 is merely an exemplary illustration.

It can be understood that, in an implementation environment of the service data processing method provided in the embodiment of the present invention, a block chain may also be used for data storage; in the implementation process, the service data to be audited uploaded by other block chain nodes can be acquired from the existing blocks in the block chain, the service data are downloaded to the terminal 101 which is the block chain node, visual display is carried out in an editing interface of the terminal 101, and continuity audit is carried out on the service data through the generated target audit code based on the continuity relation between the service data. In addition, the audit result and related data can be packaged into a new block through the terminal 101 and uploaded to a block chain; through a decentralized data storage mode of a block chain, service data are more public and safe, and malicious data tampering is avoided.

As shown in fig. 2, an embodiment of the present invention provides a method for processing service data, which can be implemented by applying to the terminal 101 in fig. 1; alternatively, the method may be performed on any other device or apparatus having data processing capabilities. Referring to fig. 2, the method specifically includes, but is not limited to, steps S100-S300:

s100, displaying an editing interface;

the editing interface in the embodiment may include, but is not limited to, a component bar area and a job area. The component column area is used for providing various types of component tools, and the working area can be used for displaying various types of elements to be examined, wherein the elements to be examined comprise but are not limited to data tables, fields in the data tables, continuity relations among the fields and the like. In an embodiment, the component column region includes multiple standardized components, and each standardized component may carry service data or may be used to determine a service data table type, service data table field information, or a continuity relationship between fields in a service data table.

Illustratively, as shown in FIG. 3, in an embodiment, the component bar area may provide component tools for characterizing various types of continuity relationships, e.g., entity components as well as transaction components are provided in the component tools of system elements. The entity component may be used to characterize a specific hardware device or a storage structure of a data plane involved in the auditing process, and the service data or the associated service data table related to the entity component may be obtained from a database of the server during the auditing process. The transaction component can be used for representing specific transactions involved in an auditing process, the business data acquisition mode of the transaction component is the same as that of the entity component, and the transaction component and the entity component load or record business data in a data table mode. In addition, since the business data in the embodiment is mainly presented in the form of a data table, in the embodiment, the component column area also provides a component tool of the data table: a distributed Data Warehouse (TDW) table-field information component (hereinafter referred to as a table-field information component); a data table of the system element, in which various service data such as an account ID, a version number, and a balance, etc. may be recorded, may be constructed or adjusted by the table-field information component. In addition, the field name and the data type of the service data can be set in the process of constructing a new form through the form-field information component, for example, a certain field name is modified into an account ID, and the account ID is set to be integer data; the other field name is modified to a balance, and the balance is set to floating point type data. It is understood that, in the embodiment, in order to create a new element or table component, the user first selects a target component in the component bar area, and after clicking, moves the component to the job area by means of dragging, so that a component of the corresponding element or table can be displayed in the job area, a preview of business data is displayed in the component, and data modification can be performed by clicking the component. It should be noted that the service data of the components in the working area may be modified in a manner of direct input by an operator, or corresponding service data may be acquired from a server through a service data acquisition space.

S200, responding to a target operation instruction, configuring standardized components of the component columns in an operation area, and determining a plurality of data tables, a plurality of fields in the data tables and continuity relations of the fields in the data tables;

the target operation instruction is an instruction which is triggered by capturing an operation in a working area of an editing interface and is performed on a component by a user; the operation includes, but is not limited to, the user moving, clicking, connecting a field in the component with other fields in the job area. The continuity in the embodiment refers to continuity of data existing in business logic in an auditing process; the balance of the account in the financial data is selected as an example, the continuity refers to data such as money amount, balance and points in the account, and the change generated by operations such as consumption transaction is logically continuous rather than sudden jump; more specifically, the balance of the initial account of the user a is 100 yuan, the user a spends 50 yuan after one consumption, and the balance of the user a is 50 yuan after the consumption is finished, it can be considered that the service data in the transaction flow has continuity. In the embodiment, the continuity relation refers to a correspondence relation that needs to be maintained before and after operations such as consumption transaction, and whether the correspondence relation is satisfied is verified for the service data needing to maintain the continuity, if so, the continuity relation is considered to exist between the service data, otherwise, the continuity relation does not exist between the service data. In an embodiment, specific continuity relationships among the service data may be represented in an editing interface in a graphical or functional manner, for example, a connection line represents that there is a continuity relationship among fields in a data table, and a functional element represents specific contents of the specific continuity relationship. It should be noted that the continuity relationships determined in step S200 are all continuity relationships to be audited, and are not correct continuity relationships between service data, and whether the continuity relationships are correct or not can be determined after auditing in subsequent steps.

Illustratively, as shown in fig. 4, the user selects a form-field information component in the component field area, and two service data forms are created, where the form a is used to characterize the account a information of a transaction operation, including account ID, version number, initial balance, transaction amount, and termination balance; the table B is used for characterizing the account B information in performing a transaction operation, and includes the account ID, the version number, the initial balance, the transaction amount, and the termination balance, as in the table a. Because the operation is transfer, in order to establish a continuous relationship between the initial balance in the table a and the termination balance in the table B, the user can right click the field of the initial balance in the table a by using a mouse in the working area, connect to the field of the termination balance in the table B by using a connecting line, and after connection, associate with the connecting line by selecting a function element, so far, the embodiment establishes a continuous relationship between the initial balance of the account a and the termination balance of the account B.

S300, generating a target audit code according to the data tables, the fields in the data tables and the continuity relation of the fields in the data tables;

the target audit code can be used for performing continuous audit on the service data corresponding to the field to be audited; and the continuity audit is to verify the continuity relation of the service data of the two form fields establishing the continuity relation, and verify whether the service data at the two ends of the connecting line meet the function relation in the function element or not, if so, the continuity audit can be passed, and if not, the data is abnormal and the continuity audit is not passed. It will be appreciated that the results of the audit can be visually displayed in the job area, with the displayed content including, but not limited to, alert icons and reminders for textual content.

Illustratively, in an embodiment, the process of generation of the target audit code may include, but is not limited to, steps S310-S340:

s310, defining a consistency audit grammar rule, and constructing a grammar tree root, defining an entity of grammar and the like.

S320, according to the consistency audit grammar rule, further defining a Domain Specific Language (DSL) of a consistency audit item; for example, after defining a basic entity of the merchant multi-institution account application form, the data structure of the entity may include an ID of the merchant multi-institution application form, an ID of the non-multi-institution application form, an institution type, and the like, and when the pair of entities is examined, field data of the ID of the merchant multi-institution application form, the ID of the non-multi-institution application form, and the institution type is selected as an audit item.

S330, the embodiment carries out lexical analysis on the DSL of the consistency audit item; illustratively, embodiments may convert a defined compliance audit item DSL text into a string of tokens (tokens), where a token is a data type that contains two main attributes: type and content.

S340, performing grammatical analysis on the DSL of the consistency audit item; according to the consistency audit grammar rule defined in the step S310 of the embodiment, the token obtained in the step S330 is constructed to obtain an abstract grammar tree; and traversing the abstract syntax tree, and generating a consistent target audit code by combining a preset code template.

In some alternative embodiments, in response to the target operation instruction, the step S200 of configuring the standardized components of the component column in the job region, and determining the number of data tables, the number of fields in the data tables, and the continuity relationship of the fields in the data tables, the step process may also be different because the standardized components configured by the step S are different. When a user needs to establish a data table in the operation area; embodiment step S200 may include, but is not limited to, step S210:

s210, responding to a first operation instruction of a first standardized component in the component bar area, and establishing a data table in an operation area;

the first standardized component is a control component used for establishing a new data table in the operation area in the component column area; the first operation instruction is an operation performed by a user on the first standardized component in a component bar area or a job area of the editing interface, and the operation is captured and triggered by the editing interface.

Illustratively, as shown in FIG. 5, in the embodiment shown in this figure, the first standardized component is a system element component 501; firstly, a user clicks the component in a component bar area in an editing interface, a control instruction for creating a new data table is triggered, a legend 503 of the data table is generated in the editing interface, and a moving track 502 of the legend 503 is displayed; the user can move the data table to any position of the operation area by long pressing the legend and dragging. It may be understood that, in the embodiment, the service data in the data table may also be filled or modified through other operation instructions, for example, the target service data may be acquired from the server through the data acquisition control and filled into the data table, and for example, a name of the data table may also be modified. In addition, the data table diagram example in the embodiment may display field information included in the data table and specific service data corresponding to the field information, for example, the account ID:1001; version number: 2; balance: 1000.

after the data table is constructed, in order to improve the operability of the embodiment and the richness of the visualized content, in response to a target operation instruction, the embodiment of the present invention configures a standardized component of a component column in a job area, and determines a plurality of data tables, a plurality of fields in the data tables, and a continuity relationship between the fields in the data tables in step S200, which may further include step S220:

s220, responding to a second operation instruction of a second standardized component in the component bar area, and configuring a plurality of fields in a data table in the operation area;

the second standardized component is a control component which is used for modifying, adding and deleting and updating fields of an existing data table in the operation area in the component column area; the second operation instruction is an operation performed by the user on the second standardized component in the component bar area or the job area of the editing interface, and the operation is captured and triggered by the editing interface, and it is understood that the operation triggering the second operation instruction includes, but is not limited to, clicking a control component for creating a new data table field, adding or deleting a field in the data table, and modifying the name and data attribute of the field in the data table.

Illustratively, as shown in FIG. 6, in the embodiment shown in this figure, the second standardized component is a form-field information component, which is displayed as a preview of the data table information currently in the job area, and the preview content 601 includes the fields contained in the data table, the data types of the respective fields, and specific data values. In order to modify the field attribute in the data table, the user may modify the field attribute, the field name, or the field data of the data table by clicking the preview content in the component bar area or clicking the field content of the data table in the job area. For example, in an embodiment, two new fields named "transaction amount" and "termination balance" are added to the data table named "account balance" in the job area through the plus control 6011 in the preview area 601 of the TWD table; and setting the attributes of the two fields to be integer types in a preview area, and acquiring the service data values of the transaction amount and the termination balance in the data table from a database of the server through a data updating control.

After the field content of the data table is adjusted and modified, the user can set the field continuity relation. In some alternative embodiments, in response to the target operation instruction, the step S200 of configuring the standardized components of the component column in the job region, and determining the continuity relationships among the data tables, the fields in the data tables, and the fields in the data tables may further include the step S230 or the step S240:

s230, responding to a third operation instruction of a third standardized component in the component bar area, and configuring the continuity relation of each field in the data table in the operation area;

the third standardized component is a control component used for establishing a continuity relation between fields in an existing data table in the operation area in the component column area, for example, the function element component is a control component capable of representing the continuity relation between the fields through a function relation; the third operation instruction is an operation performed by the user on the third standardized component in the component bar area or the working area of the editing interface, and the operation is captured and triggered by the editing interface, and it can be understood that the operation triggering the third operation instruction includes, but is not limited to, clicking and establishing a new continuity relationship in the component bar area, or moving and modifying an existing continuity relationship in the working area.

For example, as shown in fig. 7, in order to establish a continuity relationship between an "initial balance" field in the data table a and an "end balance" field in the data table B, the user first clicks a preview interface 701 for developing a functional relationship (i.e., a continuity relationship) by a function element, selects a common function control, and inputs "table a initial balance" in an object a of the common function control "fx ="; and inputting 'table B termination balance' in the correspondence B, so far, establishing a continuity relation between an 'initial balance' field in the data table A and a 'termination balance' field in the data table B through a function element, and constraining the continuity relation of the two fields to be equal in data value.

S240, responding to a fourth operation instruction, connecting each field in the data table by using a connecting line or a connecting line with an arrow in the operation area, and selecting a third standardized component in the component column area to configure the continuity relation of each field in the data table;

the third operation instruction is an operation performed by a user on the field content in the data table in the operation area of the editing interface, the editing interface captures the operation and triggers the operation, and the operation corresponding to the instruction is an operation of selecting one data table field to be connected to another data table field through a connecting line or a connecting line with an arrow. It should be noted that, in the process of establishing the continuity relationship between the fields, the two selected fields may originate from the same data table or different data tables.

Illustratively, as shown in fig. 8, in order to establish a continuity relationship between an "initial balance" field 801 in a data table a and an "end balance" field 802 in a data table B, a user firstly clicks the "initial balance" field in the data table a by a right click, a connecting line 803 is led out, and the connecting line is connected to the "end balance" field in the data table B, so that the continuity relationship between the two fields is established; then, the user may select the connection line by clicking, and reselect a commonly used function control "fx = =" in the function control in the component bar region, by which the embodiment of the present invention establishes a continuity relationship between an "initial balance" field in the data table a and an "end balance" field in the data table B, and determines whether constraints of the continuity relationship between the two fields are equal.

In the foregoing embodiments, the third normalization component includes, but is not limited to, relational operators, arithmetic operators, and logical operators, and the continuity relationships include, but are not limited to, numerical magnitude relationships, arithmetic relationships, and logical relationships, corresponding to the operators. In some alternative embodiments, the step S230 of selecting continuity relationships of fields in the third standardized component configuration data table in the component column region may include at least one of the steps S231-S233:

s231, in response to a fifth operation instruction of selecting a relation operator in the component column area, determining the continuity relation of each field in the data table as a numerical value size relation;

the fifth operation instruction is an instruction triggered by the operation of a function control of a selection relation operator in the assembly bar area by a user; in embodiments, numerical magnitude relationships used to characterize includes, but are not limited to, greater than, less than, equal to, and unequal to. Illustratively, a user selects two data table fields needing to establish a numerical value size relationship in an editing interface, which are an "initial balance" field in the data table a and an "end balance" field in the data table B, and after the fields are determined, a commonly-used function control "fx" in the function control is selected in the component bar area, and the commonly-used function control "fx" is used for representing that the continuity relationship established between the "initial balance" field in the data table a and the "end balance" field in the data table B is that the data value of the "initial balance" field in the data table a is greater than the data value of the "end balance" in the data table B.

S232, in response to a sixth operation instruction for selecting an arithmetic operator in the component bar area, determining the continuity relation of each field in the data table as an arithmetic relation;

specifically, the sixth operation instruction is an instruction triggered by the operation of a function control for selecting an arithmetic operator in the assembly bar area by the user; in embodiments, the mathematical relationships used to characterize the arithmetic relationships include, but are not limited to, addition, subtraction, multiplication, division, and the like. Similar to step S231, the user may select a common function control "fx +" in the function control to characterize that the data values in the two selected data table fields are added, and assign the result of the addition to the third data table field, it should be understood that the third data table field may be a new data table field or any one of the two selected data table fields.

S233, in response to a seventh operation instruction for selecting a logical operator in the component bar area, determining the continuity relation of each field in the data table as a logical relation;

specifically, the seventh operation instruction is an instruction triggered by the operation of the function control for selecting the logical operator in the assembly bar area by the user; in an embodiment, the characterization logic includes, but is not limited to, including, being included, and the like.

In some alternative embodiments, in order to implement auditing of complex relationships expressed by a combination of multiple (greater than two) data table fields, the business data processing method provided by the embodiments may further include steps S500-S600:

s500, selecting fields in the data table as candidate fields;

specifically, all fields of the data table created by the user in the work area are used as candidate fields.

S600, when the candidate field is the same as the pre-configured field and the continuity relation of the candidate field accords with the pre-configured continuity constraint condition, determining the candidate field as a field to be audited;

the pre-configuration field is a screening range determined by a data table field required to be audited by a user before the user audits; it will be appreciated that the screening scope should include several data table fields, and the pending fields determined by the step may be any combination of data table fields including any number of screening scopes. In addition, the embodiment determines whether the candidate field is an audit field, and also needs to check the continuity relation of the candidate field, and determines that the candidate field meets the continuity constraint condition obtained by combining the continuity relations among the data table fields in the screening range, and then determines the candidate field as the field to be audited.

In order to improve the accuracy of the screened pending fields, in some alternative embodiments, the process of selecting the fields in the data table as candidate fields in step S600 may include, but is not limited to, steps S610 to S620:

s610, acquiring a preconfigured continuity constraint condition;

the continuity constraint condition is used for representing the constraint relation among a plurality of fields in the service data table; illustratively, in a certain consumption operation record, the continuity constraint condition that should be satisfied between table A1 before operation and table A2 after operation is: the version number field of table A2 should be the sum of one of the data values in the version number field of table A1; and the value of the terminal balance field of table A1 should be the same as the value of the initial balance of table A2; further, the ending balance of table A2 should be the sum of the transaction amount of table A2 and the initial balance of table A2. The involved data table fields that satisfy this continuity constraint are then candidate fields.

S620, selecting candidate fields from the business data table according to the continuity constraint condition;

for example, after the server data is obtained, the embodiment obtains the tables A1 and A2, and if the version number field and the termination balance field of the table A1 and the version number field, the transaction amount field and the termination balance field of the table A2 satisfy the continuity constraint condition in step S610, the obtained fields are candidate fields.

In some alternative embodiments, in order to make the obtained candidate field more accurate, the continuity constraint conditions in the embodiments may include, but are not limited to, a business data table format audit formula, a version number field audit formula, an initial balance audit formula, and a final balance audit formula; further, as shown in fig. 9, the step S620 of selecting candidate fields from the service data table according to the continuity constraint condition may include, but is not limited to, the steps S621 to S625:

s621, determining a plurality of target business data tables to be audited under the same business data table format according to the business data table format audit formula;

the business data table format auditing formula can identify the field number and the field attribute contained in the business data table, and when the field number and the field attribute of the business data table are the same, the current business data table to be compared can be determined to belong to a target business data table to be audited with the same format.

For example, as shown in fig. 10, after the server service data is obtained, in the embodiment, a data table A1 and a data table A2 are obtained, according to a table format audit formula, the field numbers and the field attributes of the table A1 and the table A2 are compared, it is determined that the field numbers and the field attributes of the two data tables are the same, and the fields of the data tables are the same: account ID, version number, initial balance, and termination balance.

S622, according to the version number field auditing formula, selecting a version number field from the target service data table as a first field;

the version number field auditing formula is used for auditing the space between two adjacent service data tables, and the version number of the next service data table is equal to the version number of the previous service data table plus one. Taking the data table A1 and the data table A2 in step S621 as an example, the value of the version number field recorded in the table A2 is 3, and the value of the version number field in the table A1 is 2; therefore, the version number fields of table A1 and table A2 both satisfy the version number field audit formula, and the version number fields in data table A1 and data table A2 are determined as the first fields.

S623, selecting an initial balance field from the target service data table as a second field according to an initial balance auditing formula;

the initial balance auditing formula is used for auditing the position between two adjacent service data tables, and the initial balance of the latter service data table is equal to the termination balance of the former service data table. Similarly, taking the data table A1 and the data table A2 in step S621 as an example, the value of the ending balance field in table A1 is 1000; the initial balance field of table A2 has a value of 1000; therefore, the termination balance field of table A1 and the initial balance field of table A2 satisfy the initial balance audit formula, and the termination balance field of data table A1 and the initial balance field of data table A2 are determined as the second field.

S624, selecting a termination balance field from the target service data table as a third field according to the termination balance audit formula;

the termination balance auditing formula is used for auditing any service data table, and the termination balance is equal to the sum of the initial balance and the transaction amount; similarly, taking the data table A2 obtained in step S621 as an example, the value of the ending balance field of table A2 is 1500, the value of the transaction amount field in table A2 is 500, and the value of the initial balance field of table 2 is 1000; thus, the terminating balance field, transaction amount, and initial balance field of table A2 are all third fields.

And S625, determining a candidate field according to the first field, the second field and the third field.

Illustratively, according to the field selection performed on the data tables A1 and A2 in steps S621-S624 in the embodiment of the present invention, the determined candidate fields include: the version number field and the termination balance field of table A1, and the version number field, the transaction amount field and the termination balance field of table A2, which satisfy the continuity constraint condition collectively formed by S621 to S624, and thus, can be determined as candidate fields under the continuity constraint condition.

In order to reduce the data processing amount and make the readability of the data table visually displayed in the operation area stronger, in some optional embodiments, step S621 determines a plurality of target service data tables to be audited belonging to the same service data table format according to the service data table format audit formula; it may include at least one step of S621a and S621 b:

s621a, responding to an eighth operation instruction for the target service data tables, and determining the association relation among the target service data tables;

specifically, as shown in fig. 11, the eighth operation instruction is an instruction triggered by a user performing association query on a plurality of target service data tables in a working area. Illustratively, a user firstly selects a plurality of service data tables 1001 which need to be merged, obtains the association relationship of the plurality of service data tables by clicking an association relationship query control 1002 in an editing interface, and visually displays the association relationship in a working area; the association relationship includes, but is not limited to, the existence of the same or similar fields, or the data in the same field in several business data tables shows obvious distribution trend, etc. According to the embodiment, through the determination and extraction of the association relationship, the user can pay more attention to the data with the association relationship, the data processing amount is reduced, and the processing efficiency is improved.

And S621b, in response to the ninth operation instruction for the target service data tables, merging the target service data tables.

Specifically, the ninth operation instruction is an instruction triggered by merging a plurality of target service data tables in the operation area by the user. Illustratively, as shown in fig. 11, a user first selects several service data tables 1001 to be merged, and by clicking a table merging control 1003 in the editing interface, merges several service data tables selected by the user, where the merging manner includes, but is not limited to, full connection, intra-connection, and the like. The embodiment displays the combined summary table in a visual way in the working area, so as to reduce the number of the displayed data tables and ensure that the visual result has stronger readability.

In some alternative embodiments, the step S100 of displaying an editing interface includes, but is not limited to, the steps S110-S150:

s110, configuring a business data table type set, a business data table field set and a continuity relation set;

specifically, a user logs in a service data processing software system carried by a terminal, and after the user passes authority authentication, obtains an element to be audited from a database of a server or a cloud database, wherein the element can include but is not limited to a data table of service data, fields contained in the data table and continuity relations among the fields; in order to facilitate the user to sort and call the data tables, the software system of the embodiment divides a plurality of data tables obtained from the database according to different types of the data tables to obtain a plurality of service data table type sets, so that the user can retrieve and extract the data tables from the corresponding sets according to the requirements of different data table types, redundant data processing procedures are reduced, and auditing efficiency is improved. In order to facilitate a user to modify field contents and attributes of a data table, the software system of the embodiment integrates the field contents of the data table from various types of data tables to obtain a service data table field set, and the user can directly call a complete field name and field attributes from the service data table field set according to requirements and add the complete field name and field attributes to a target data table, so that an operation flow is saved and auditing efficiency is further improved. In addition, in order to facilitate the user to construct the continuity relationships among the data table fields, the software system of the embodiment integrates all the continuity relationships appearing in the history data to obtain a continuity relationship set, and the user can select the template component which is packaged with the related function expression or formula from the continuity relationship set according to specific requirements to construct the continuity relationships of the target data table fields.

S120, displaying a component bar area and a working area on an editing interface;

the method comprises the following steps that a plurality of standardized components are arranged in a component bar area in an editing interface, and each standardized component can bear service data or can be used for determining the type of a service data table, field information of the service data table or the continuity relation among fields in the service data table; the operation area is used for visually displaying the standardized components selected by the user from the component bar area. It can be understood that the actual operation process of the user and the final auditing result can be displayed visually through the working area of the embodiment.

S130, displaying a first standardized component in a component bar area according to the data table type set;

wherein the first standardized component is used for determining the type of the business data table. For example, in an embodiment, the first standardized component is a system element, and the system element includes an entity component and a transaction component, both of which can characterize a specific hardware device or a storage structure of a data layer involved in an auditing process, and data tables derived by the two components are of the same type; for example, the entity component stores most of the specific amount of money in the user account, and the transaction component stores most of the information data of the transaction behavior. Therefore, in the software system of the embodiment, the user can select the corresponding component according to the type of the required service data table.

S140, displaying a second standardized component in the component bar area according to the data table field set;

the second standardized component is used for determining field composition of the business data table; specifically, the second standardized component may be a field component template that is integrated and encapsulated by the embodiment software system through all fields included in the data table stored in the database, and the user may select a certain field component template to add to the data table in a dragging manner according to specific requirements, and the addition of the field content is completed by inputting a specific data value in the field template.

S150, displaying a third standardized component in the component bar area according to the continuity relation set;

wherein the third normalization component is to determine a continuity relationship between the fields; specifically, the third standardized component may be a component module that the embodiment software system integrates continuity relationships among all data table fields stored in the database and encapsulates a relational expression function or a formula to obtain a continuity relationship; for example, the relational operator, the arithmetic operator and the logical operator are packaged into the function element, and a user can select a component of a certain continuity relation according to specific requirements to establish the continuity relation between fields of the data table in a connection mode.

In some optional embodiments, in order to improve the accuracy of the audit result, the business data processing method may further include step S700:

s700, displaying the number of the business data tables in an editing interface; and when the number of the business data tables is smaller than that of the target business data table, displaying the missing to-be-audited fields in the editing interface.

Specifically, in the embodiment, an audit template of the target business data table may be preset before auditing, where preset contents of the audit template include, but are not limited to, the number of data tables to be audited, fields to be audited, types of field data, and the like, and in a background of a stored-value software system of the audit template, the audit template may be used as a basis for auditing the quality of a to-be-audited business data table constructed by a user. For example, when the number of the data tables newly created by the user through the annotating component is smaller than the number of the audit templates, the software system of the embodiment reminds through a visualization means; for example, the missing pending field is displayed in the job area, or the component displaying the missing field is displayed in the component bar area.

In some optional embodiments, in order to improve the risk resistance and the safety performance, the service data processing method may further include step S800:

s800, acquiring a service data table of continuity audit and an audit result of the continuity audit; storing the service data table in a database cluster in a distributed manner, and storing an audit result in a server cluster in a distributed manner;

the server cluster refers to that a plurality of servers are collected together to perform the same service, and only one server is perceived at a client. In an exemplary embodiment, the encapsulation of standardized functional components and the encapsulation of continuity relation formulas can be realized based on c + + language, and the data table is structured and modularized, so that the software system of the embodiment can realize automatic flow processing more conveniently. The software system service of the embodiment can adopt a distributed deployment mode, and the service can be reserved with a plurality of copies so as to improve the service availability of the software system; the data storage in the embodiment may also use a Mysql relational database management system, and in order to ensure system performance, redis used as cache for synchronization. In addition, the database cluster of the embodiment can be deployed separately from the service cluster, so that the coupling of the service and the data is reduced, and the disaster tolerance capability of the database is provided.

According to the business data processing method, the business data processing process of the embodiment of the invention is described in detail by taking the auditing process of the business data in the financial field as an example and combining the attached drawings of the specification:

illustratively, in a certain transaction scenario in the financial field, account balance data of a user is stored in a database table, and a certain continuity constraint relation needs to be met when the balance in the database table is changed. As shown in fig. 4, in the editing interface of the software system of the embodiment, table a is used for a data table indicating the balance of the user account, and the fields in table a represent data table fields representing the version number, the initial balance, the termination balance, and the transaction amount. In the editing interface of the software system, the visualized data table displays the data stored by the audited unit in the working area at the granularity of the database. In the embodiment, each type of component for determining the type of a service data table, field information of the service data table or continuity relation among fields in the service data table is set in a component column region; for example, lines indicate continuity constraint relationships between data table fields, and function elements indicate the content of specific continuity constraint relationships such as equality or addition. In addition, the system element in the editing interface can only add a plurality of specific data tables, and the continuity relation or more complex continuity constraint relation between the fields of each data table is determined according to the actual situation; for example, table a, table B, and table C may be added, with continuity constraint relationships between fields of table a and table B, and continuity constraint relationships between fields of table B and table C.

As shown in fig. 12, the operation flow performed by the embodiment in the editing interface is divided into three steps, first, a data table of data to be filtered is displayed in the editing interface, then, the data in the data table is filtered through the standardized functional component, and finally, the continuity constraint relationship is described by using the continuity fruit. Specifically, the user determines the data tables (any number of data tables) to be added, and then selects a system element, e.g., an entity or a transaction, from the component bar area, and loads the added data tables into the system element; and forming a table schematic diagram in the operation area, and connecting fields between different tables by lines according to the continuity constraint requirement between different data tables to express that the two fields have continuity constraint relation. In addition, the user can add a specific function element to the line from the component bar area to express the specific content of the continuity constraint relationship, for example, two fields are equal, the value of the previous field is added to one to obtain the value of the next field, and the like. The final result is shown in fig. 4, where there is a continuity constraint relationship between the two data tables, the specific fields are the initial balance and the final balance, and whether the continuity constraint contents between the two fields are equal or not.

Finally, according to the continuity constraint between the two data tables expressed by the operation area, the software system of the embodiment can automatically generate related codes for auditing related data in the database, namely whether the initial balance and the final balance in the two tables meet the continuity constraint relation or not is audited, if so, the audit is passed, and if not, the data is proved to have problems, and the audit is not passed.

It should be added that the front-end code of the embodiment software is implemented based on Vue open source framework and element UI open source components, and encapsulates an independent standardization function and a standardization component obtained by standardization description, for example, function expressions or formulas for describing various continuity relationships are encapsulated in the function element in fig. 4, and in the case that a continuity relationship or a complex continuity constraint relationship needs to be established, the establishment of the continuity relationship or the complex continuity constraint relationship can be completed by simple interactive instructions such as clicking and dragging. In addition, the standardized function of the encapsulation in the embodiment can also comprise the association operation and the combination operation of the data table, so that the data processing amount of business side personnel can be reduced, the table fields displayed by the data table on the interface are less, and the reading performance is stronger. The normalization functions of the encapsulation performed in embodiments may also include functions for expressing complex persistence constraint relationships; for example, in one embodiment, the field data that establishes the continuity constraint relationship in the data must all satisfy the following four-term formula:

1. the two data tables are the same (the data table updated after the same type or the same object is subjected to transaction operation), and are respectively marked as a table A and a table B;

2. adding a data value equal to the version number in table B to the data value in the version number field in table a; the version number identifies the change times of the data in the data sheet, and the value of the version number is increased by one every time the data is changed;

3. the data value of the initial balance field of table a is equal to the data value of the final balance field of table B;

4. in table B, the data value of the terminating balance field should be equal to the sum of the data value of the initial balance field of table B and the data of the transaction amount field of table B.

Taking account balance information record of a user as an example, before a certain transaction is carried out, the account balance information is as follows: the current balance is 100 dollars, the user has made a 10 dollar cost in this transaction, and after the transaction is completed, a new account balance information record is generated in the database: the current balance is 90 yuan. Corresponding the four formulas to the transaction scene, and corresponding the account balance information records before the transaction to a data table A; the account balance information records after the transaction correspond to the data table B. In table a, the data recorded in the termination balance field is 100; in table B, the data recorded in the initial balance is 100, the data recorded in the transaction amount field is 10, and the data recorded in the termination balance field is 90; in addition, if the value recorded in the version number field of table a is 1, the value recorded in the version number field of table B is 2.

To sum up, the following description is given to the present embodiment: a user builds a functional interface as shown in fig. 4 according to all possible continuity relation components (namely function elements) and content components (namely system elements), selects a data table to be audited in the corresponding system element, and clearly expresses fields to be audited among fields of the data table; for example, which fields need to be audited may be determined according to a continuity constraint relationship preset by a user in advance. After the configuration of the operation area is completed, the system of the embodiment automatically generates the audit code according to the continuity relation between the fields, and audits all actual data, and the process does not need an auditor to perform manual audit or proofreading, and is favorable for improving the audit efficiency.

As shown in fig. 13, an embodiment of the present invention further provides a service data processing apparatus, where the apparatus includes a first module 1301, a second module 1302, and a third module 1303;

the first module 1301 is used for displaying an editing interface, the editing interface includes a component bar area and an operation area, the component bar area includes multiple standardized components, and each standardized component is used for determining a service data table type, service data table field information or a continuity relation between fields in the service data table;

a second module 1302, configured to configure standardized components of the component column in the job region in response to the target operation instruction, and determine a plurality of data tables, a plurality of fields in the data tables, and a continuity relationship between fields in the data tables;

the third module 1303 is configured to generate a target audit code according to the data tables, the fields in the data tables, and the continuity relation between the fields in the data tables, where the target audit code is used to perform continuity audit on the service data corresponding to the field to be audited.

Illustratively, under the cooperation of the first module, the second module and the third module in the device, the embodiment device may implement any one of the aforementioned business data processing methods, that is, according to a target operation instruction of a user, a standardized component in a component column is configured in a working area, and an element to be audited is determined, where the element may include, but is not limited to, a data table, a field in the data table, and a continuity relationship between fields. Then, the embodiment generates a target audit code according to the element to be audited, and conducts continuous audit. The assembly packaged by the standardized function is used by service personnel for the standardized function, so that the workload of manually writing codes is reduced, the process is simpler, the error probability is effectively reduced, and the audit quality is improved.

The embodiment of the invention also provides electronic equipment, which comprises a processor and a memory;

the memory stores a program;

the processor executes the program to execute the business data processing method; the electronic device has a function of loading and operating a software system for processing service data provided by the embodiment of the present invention, for example, a Personal Computer (PC), a mobile phone, a smart phone, a Personal Digital Assistant (PDA), a wearable device, a Pocket PC (Pocket PC), a tablet Computer, and the like.

An embodiment of the present invention further provides a computer-readable storage medium, where the storage medium stores a program, and the program is executed by a processor to implement the service data processing method described above.

In alternative embodiments, the functions/acts noted in the block diagrams may occur out of the order noted in the operational illustrations. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality/acts involved. Furthermore, the embodiments presented and described in the flow charts of the present invention are provided by way of example in order to provide a more thorough understanding of the technology. The disclosed methods are not limited to the operations and logic flows presented herein. Alternative embodiments are contemplated in which the order of various operations is changed and in which sub-operations described as part of larger operations are performed independently.

Embodiments of the present invention also disclose a computer program product or computer program comprising computer instructions stored in a computer readable storage medium. The processor of the computer device may read the computer instructions from the computer readable storage medium, and the processor executes the computer instructions, so that the computer device executes the aforementioned service data processing method.

Furthermore, although the present invention is described in the context of functional modules, it should be understood that, unless otherwise stated to the contrary, one or more of the described functions and/or features may be integrated in a single physical device and/or software module, or one or more functions and/or features may be implemented in a separate physical device or software module. It will also be appreciated that a detailed discussion of the actual implementation of each module is not necessary for an understanding of the present invention. Rather, the actual implementation of the various functional modules in the apparatus disclosed herein will be understood within the ordinary skill of an engineer given the nature, function, and interrelationships of the modules. Accordingly, those skilled in the art can, using ordinary skill, practice the invention as set forth in the claims without undue experimentation. It is also to be understood that the specific concepts disclosed are merely illustrative of and not intended to limit the scope of the invention, which is to be determined from the appended claims along with their full scope of equivalents.

The functions, if implemented in the form of software functional units and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk, and other various media capable of storing program codes.

The logic and/or steps represented in the flowcharts or otherwise described herein, such as an ordered listing of executable instructions that can be considered to implement logical functions, can be embodied in any computer-readable medium for use by or in connection with an instruction execution system, apparatus, or device, such as a computer-based system, processor-containing system, or other system that can fetch the instructions from the instruction execution system, apparatus, or device and execute the instructions. For the purposes of this description, a "computer-readable medium" can be any means that can contain, store, communicate, propagate, or transport the program for use by or in connection with the instruction execution system, apparatus, or device.

More specific examples (a non-exhaustive list) of the computer-readable medium would include the following: an electrical connection (electronic device) having one or more wires, a portable computer diskette (magnetic device), a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber device, and a portable compact disc read-only memory (CDROM). Additionally, the computer-readable medium could even be paper or another suitable medium upon which the program is printed, as the program can be electronically captured, via for instance optical scanning of the paper or other medium, then compiled, interpreted or otherwise processed in a suitable manner if necessary, and then stored in a computer memory.

It should be understood that portions of the present invention may be implemented in hardware, software, firmware, or a combination thereof. In the above embodiments, various steps or methods may be implemented in software or firmware stored in a memory and executed by a suitable instruction execution system. For example, if implemented in hardware, as in another embodiment, any one or combination of the following techniques, which are known in the art, may be used: a discrete logic circuit having a logic gate circuit for implementing a logic function on a data signal, an application specific integrated circuit having an appropriate combinational logic gate circuit, a Programmable Gate Array (PGA), a Field Programmable Gate Array (FPGA), or the like.

In the description herein, references to the description of the term "one embodiment," "some embodiments," "an example," "a specific example," or "some examples," etc., mean that a particular feature, structure, material, or characteristic described in connection with the embodiment or example is included in at least one embodiment or example of the invention. In this specification, the schematic representations of the terms used above do not necessarily refer to the same embodiment or example. Furthermore, the particular features, structures, materials, or characteristics described may be combined in any suitable manner in any one or more embodiments or examples.

While embodiments of the invention have been shown and described, it will be understood by those of ordinary skill in the art that: various changes, modifications, substitutions and alterations can be made to the embodiments without departing from the principles and spirit of the invention, the scope of which is defined by the claims and their equivalents.

While the preferred embodiments of the present invention have been illustrated and described, it will be understood by those skilled in the art that various changes in form and details may be made therein without departing from the spirit and scope of the invention as defined by the appended claims.

Claims

1. A method for processing service data, comprising:

2. The business data processing method according to claim 1, wherein the configuring the standardized components of the component column area in the working area in response to a target operation instruction, and determining a number of data tables, a number of fields in the data tables, and a continuity relationship of each of the fields in the data tables, comprises:

and in response to a first operation instruction of a first standardized component in the component column area, establishing the data table in the operation area.

3. The business data processing method according to claim 2, wherein the configuring the standardized components of the component column area in the working area in response to a target operation instruction, and determining a number of data tables, a number of fields in the data tables, and a continuity relationship of each of the fields in the data tables, comprises:

configuring a number of fields in the data table in the working area in response to a second operating instruction for a second standardized component in the component bar area.

4. The business data processing method according to claim 3, wherein the configuring the standardized components of the component column area in the working area in response to a target operation instruction, and determining a number of data tables, a number of fields in the data tables, and a continuity relationship of each of the fields in the data tables, comprises:

in response to a third operation instruction for a third standardized component in the component column area, configuring a continuity relation of each field in the data table in the working area;

or responding to a fourth operation instruction, connecting the fields in the data table by using a connecting line or a connecting line with an arrow in the operation area, and selecting a third standardized component in the component column area to configure the continuity relation of the fields in the data table.

5. The business data processing method of claim 4, wherein the third standardized component comprises relational operators, arithmetic operators, and logical operators, the continuity relationships comprise numerical magnitude relationships, arithmetic relationships, and logical relationships,

selecting a third standardized component in the component column area to configure the continuity relation of each field in the data table, wherein the continuity relation comprises the following steps:

in response to a fifth operation instruction of selecting the relational operator in the component column region, determining the continuity relation of each field in the data table as a numerical value size relation;

or, in response to a sixth operation instruction of selecting the arithmetic operator in the component column area, determining the continuity relation of each field in the data table as an arithmetic relation;

or, in response to a seventh operation instruction of selecting the logical operator in the component bar area, determining the continuity relation of each field in the data table as a logical relation.

6. The method for processing service data according to claim 1, wherein the method further comprises:

selecting the field in the data table as a candidate field;

and when the candidate field is the same as the pre-configured field and the continuity relation of the candidate field meets the pre-configured continuity constraint condition, determining the candidate field as the field to be audited.

7. The method according to claim 6, wherein said selecting said field in said data table as a candidate field comprises:

acquiring a preconfigured continuity constraint condition; the continuity constraint condition is used for representing the constraint relation among a plurality of fields in the service data table;

and selecting candidate fields from a business data table according to the continuity constraint condition.

8. The business data processing method of claim 7, wherein the continuity constraint condition includes a business data table format audit formula, a version number field audit formula, an initial balance audit formula and a final balance audit formula; selecting candidate fields from a business data table according to the continuity constraint condition, wherein the candidate fields comprise:

determining a plurality of target service data tables to be audited under the same service data table format according to the service data table format audit formula;

according to the version number field auditing formula, selecting a version number field from the target service data table as a first field; the version number field auditing formula is used for auditing the space between two adjacent service data tables, and the version number of the next service data table is equal to the version number of the previous service data table plus one;

selecting an initial balance field from the target service data table as a second field according to the initial balance auditing formula; the initial balance auditing formula is used for auditing the position between two adjacent service data tables, and the initial balance of the latter service data table is equal to the termination balance of the former service data table;

selecting a termination balance field from the target service data table as a third field according to the termination balance audit formula; the termination balance auditing formula is used for auditing any service data table, and the termination balance is equal to the sum of the initial balance and the transaction amount;

determining the candidate field according to the first field, the second field, and the third field.

9. The method for processing service data according to claim 8, wherein after the step of determining a plurality of target service data tables to be audited belonging to the same service data table format according to the service data table format audit formula, the method further comprises at least one of the following steps:

responding to an eighth operation instruction of the target service data tables, and determining the incidence relation among the target service data tables;

or, in response to a ninth operation instruction for the target service data tables, merging the target service data tables.

10. The method for processing service data according to claim 1, wherein the displaying an editing interface includes:

configuring a business data table type set, a business data table field set and a continuity relation set;

displaying the component bar area and the operation area on the editing interface;

displaying a first standardized component in the component column area according to the data table type set, wherein the first standardized component is used for determining the type of a business data table;

displaying a second standardized component in the component column area according to the data table field set, wherein the second standardized component is used for determining field composition of a business data table;

and displaying a third standardized component in the component bar area according to the continuity relation set, wherein the third standardized component is used for determining the continuity relation between the fields.

11. The traffic data processing method according to any of claims 1-10, characterized in that the method further comprises:

displaying the number of the business data tables in the editing interface;

and when the number of the business data tables is smaller than that of the target business data tables, displaying the missing fields to be audited in the editing interface.

12. The traffic data processing method according to any of claims 1-10, characterized in that the method further comprises:

acquiring a service data table of the continuity audit and an audit result of the continuity audit;

and storing the service data table in a database cluster in a distributed manner, and storing the auditing result in a server cluster in a distributed manner.

13. A service data processing apparatus, comprising:

and the third module is used for generating a target audit code according to the plurality of data tables, the plurality of fields in the data tables and the continuity relation of each field in the data tables, wherein the target audit code is used for performing continuity audit on the service data corresponding to the field to be audited.

14. An electronic device comprising a processor and a memory;

the memory is used for storing programs;

the processor executing the program realizes the method of any one of claims 1-12.

15. A computer-readable storage medium, characterized in that the storage medium stores a program, which is executed by a processor to implement the method according to any one of claims 1-12.