CN116225439A - Service data processing method, device, equipment, medium and product - Google Patents

Service data processing method, device, equipment, medium and product Download PDF

Info

Publication number
CN116225439A
CN116225439A CN202111463712.3A CN202111463712A CN116225439A CN 116225439 A CN116225439 A CN 116225439A CN 202111463712 A CN202111463712 A CN 202111463712A CN 116225439 A CN116225439 A CN 116225439A
Authority
CN
China
Prior art keywords
component
compliance
data table
field
pending
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202111463712.3A
Other languages
Chinese (zh)
Inventor
于天放
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Tencent Technology Shenzhen Co Ltd
Original Assignee
Tencent Technology Shenzhen Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Tencent Technology Shenzhen Co Ltd filed Critical Tencent Technology Shenzhen Co Ltd
Priority to CN202111463712.3A priority Critical patent/CN116225439A/en
Publication of CN116225439A publication Critical patent/CN116225439A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F8/00Arrangements for software engineering
    • G06F8/40Transformation of program code
    • G06F8/41Compilation
    • G06F8/44Encoding
    • G06F8/447Target code generation
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/27Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F3/00Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
    • G06F3/01Input arrangements or combined input and output arrangements for interaction between user and computer
    • G06F3/048Interaction techniques based on graphical user interfaces [GUI]
    • G06F3/0481Interaction techniques based on graphical user interfaces [GUI] based on specific properties of the displayed interaction object or a metaphor-based environment, e.g. interaction with desktop elements like windows or icons, or assisted by a cursor's changing behaviour or appearance
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F8/00Arrangements for software engineering
    • G06F8/30Creation or generation of source code
    • G06F8/38Creation or generation of source code for implementing user interfaces
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02PCLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
    • Y02P90/00Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
    • Y02P90/30Computing systems specially adapted for manufacturing

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • General Engineering & Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Software Systems (AREA)
  • Human Computer Interaction (AREA)
  • Databases & Information Systems (AREA)
  • Computing Systems (AREA)
  • Data Mining & Analysis (AREA)
  • User Interface Of Digital Computer (AREA)
  • Digital Computer Display Output (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The present disclosure provides a method, apparatus, device, medium and product for processing service data, where the method includes: displaying an editing page; responding to an operation instruction of an entity component in a component column area, and displaying a business data table to be audited in a working area; determining fields to be audited and compliance constraint information or correctness constraint information in response to an operation instruction of a business data table to be audited; and generating an objective audit code according to the compliance constraint information or the correctness constraint information, wherein the objective audit code is used for carrying out compliance audit on the business data corresponding to the field to be audited according to the compliance constraint information or carrying out correctness audit on the business data corresponding to the field to be audited according to the correctness constraint information. The implementation process of the method does not need manual audit of personnel at an audit side, reduces labor cost, improves audit efficiency, reduces workload of manually writing codes, effectively reduces error probability and improves audit quality.

Description

Service data processing method, device, equipment, medium and product
Technical Field
The present disclosure relates to the field of computer technology, and in particular, to a service data processing method, a service data processing apparatus, an electronic device, a computer readable storage medium, and a computer program product.
Background
With the development of information technology, the amount of business data generated in the informatization process by each industry is increased, and in some fields, correctness audit and/or compliance audit are required to be performed on special business data so as to reduce potential risks in related businesses and provide assistance for development decisions of the related businesses.
The traditional auditing mode is that a business side personnel submits auditing requirements to an auditing side personnel, information possibly used for auditing is described by natural language, after the auditing side personnel receives the requirements, the auditing side personnel and the business side personnel need to communicate the auditing requirements repeatedly, the data table content and the field meaning of each business data in the business side are clear, and then the auditing side personnel analyze which data relate to correctness and/or compliance auditing according to experience, so that on one hand, the labor cost is high and the error probability is high, on the other hand, the accuracy of an auditing object depends on the experience of the auditing side personnel, audit mistakes easily occur, potential risks of mistaking and missing are present, and the auditing efficiency is low and unreliable.
Disclosure of Invention
The present disclosure provides a business data processing method, a business data processing device, an electronic apparatus, a computer readable storage medium, and a computer program product, which can reduce labor cost and error probability, and improve efficiency and quality of business data correctness or compliance audit.
The embodiment of the disclosure provides a service data processing method, which comprises the following steps: displaying an editing page, wherein the editing page comprises a component column area and a working area, and the component column area comprises an entity component; responding to an operation instruction of the entity component in the component column area, and displaying a business data table to be audited in the operation area; determining a to-be-checked field in the to-be-checked business data table and compliance constraint information or correctness constraint information of the to-be-checked field in response to an operation instruction of the to-be-checked business data table in the operation area; generating a target audit code according to compliance constraint information or correctness constraint information of the to-be-checked fields in the to-be-checked business data table, wherein the target audit code is used for carrying out compliance audit on business data corresponding to the to-be-checked fields according to the compliance constraint information or carrying out correctness audit on the business data corresponding to the to-be-checked fields according to the correctness constraint information.
The embodiment of the disclosure provides a service data processing device, which comprises: the display unit is used for displaying an editing page, wherein the editing page comprises a component column area and a working area, and the component column area comprises an entity component; the display unit is also used for responding to the operation instruction of the entity component in the component column area and displaying a business data table to be audited in the operation area; a determining unit, configured to determine a to-be-examined field in the to-be-examined service data table and compliance constraint information or correctness constraint information of the to-be-examined field in response to an operation instruction to the to-be-examined service data table in the operation area; the generating unit is used for generating a target audit code according to compliance constraint information or correctness constraint information of the to-be-checked fields in the to-be-checked business data table, wherein the target audit code is used for conducting compliance audit on business data corresponding to the to-be-checked fields according to the compliance constraint information or conducting correctness audit on the business data corresponding to the to-be-checked fields according to the correctness constraint information.
In an exemplary embodiment, the display unit is configured to perform the steps of: displaying a first entity component in the operation area in response to an operation instruction for the entity component in the component bar area; and responding to an operation instruction of the first entity component in the working area, and converting the first entity component into the pending-meter service data table.
In an exemplary embodiment, the component column area further includes a compliance identification component, a function component, and a table manipulation component. The determining unit is used for executing the following steps: determining a pending field in the pending service data table in response to an operation instruction to the pending service data table in the operation area; responsive to an operation instruction to the compliance identification component in the component bar area, displaying a compliance identification at a first predetermined location of the pending fields; and in response to an operation instruction to the function component and the table operation component in the component bar area, displaying compliance constraint information of the pending fields at a second predetermined location of the compliance identification component.
In an exemplary embodiment, the determining unit is further adapted to perform the steps of: responding to an operation instruction of the to-be-examined business data table in the operation area, and displaying field information in the to-be-examined business data table in the operation area; and determining a pending meter field in the pending meter service data table in response to an operation instruction for field information in the pending meter service data table displayed in the operation area.
In an exemplary embodiment, a table manipulation component is also included in the component column area. The determining unit is further adapted to perform the steps of: and determining a pending meter field in the pending meter service data table in response to an operation instruction of the pending meter service data table in the operation area and an operation instruction of the table operation component in the component column area.
In an exemplary embodiment, the component bar area further includes an association component. The determining unit is further adapted to perform the steps of: responsive to an operation instruction to the associated component in the component bar area, displaying a first business data table associated with the review field at a second predetermined location of the compliance identification component; and in response to an operation instruction to the function component in the component column area, displaying compliance constraint information of a first field in the first business data table at a second preset position of the compliance identification component, wherein the compliance constraint information of the pending field comprises the compliance constraint information of the first field.
In an exemplary embodiment, the determining unit is further adapted to perform the steps of: displaying a second entity component in the operation area in response to an operation instruction for the entity component in the component bar area; responsive to an operation instruction to the second entity component in the working area, converting the second entity component into a second business data table associated with the pending fields; and in response to an operation instruction to the function component in the component column area, displaying compliance constraint information of a second field in the second business data table at a second preset position of the compliance identification component, wherein the compliance constraint information of the pending field comprises the compliance constraint information of the second field.
In an exemplary embodiment, a compliance identification component is also included in the component bar area. The determining unit is further adapted to perform the steps of: determining a pending field in the pending service data table in response to an operation instruction to the pending service data table in the operation area; responding to an operation instruction of the compliance identification component in the component column area, displaying a compliance editing sub-page of the to-be-checked field, wherein the compliance editing sub-page comprises an entity selection control, an entity attribute selection control, an operator selection control and an attribute value determination control; and generating compliance constraint information of the to-be-examined field in response to operation instructions of the entity selection control, the entity attribute selection control, the operator selection control and the attribute value determination control.
In an exemplary embodiment, the component column area further includes a table operation component and a function component. The determining unit is further adapted to perform the steps of: determining a pending field in the pending service data table in response to an operation instruction to the pending service data table in the operation area; displaying a third service data table and a fourth service data table associated with the pending-meter field in the job area; determining operation relation information between a third field in the third service data table and a fourth field in the fourth service data table in response to an operation instruction to the function component, and determining a fifth field in a fifth service data table and corresponding service data thereof according to the operation relation information; and generating correctness constraint information between the to-be-checked field and the fifth field as the correctness constraint information of the to-be-checked field in response to operation instructions of the table operation component and the function component.
The disclosed embodiments provide an electronic device comprising a processor and a memory, wherein at least one instruction or at least one section of program is stored in the memory, and the at least one instruction or the at least one section of program is loaded and executed by the processor to implement the foregoing business data processing method.
Embodiments of the present disclosure provide a computer readable storage medium having stored therein at least one instruction, at least one program, a set of codes, or a set of instructions, which are loaded and executed by a processor to implement a business data processing method as described above.
Embodiments of the present disclosure provide a computer program product or computer program comprising computer instructions stored in a computer readable storage medium. The computer instructions may be read from a computer-readable storage medium by a processor of a computer device, and executed by the processor, to cause the computer device to perform the foregoing method.
The method, the device, the equipment and the computer readable storage medium for processing the business data firstly display an editing interface, wherein the editing interface comprises a component column area and a working area, the component column area comprises an entity component, and a business data table to be audited can be displayed in the working area through an operation instruction of the entity component in the component column area; then, based on the operation instruction of the to-be-checked business data table in the working area, to-be-checked fields in the to-be-checked business data table and compliance constraint information or correctness constraint information of the to-be-checked fields can be determined; and then, generating a target audit code for performing compliance audit on the to-be-inspected field according to the compliance constraint information or the correctness constraint information of the to-be-inspected field in the to-be-inspected service data table, or generating a target audit code for performing correctness audit on the to-be-inspected field according to the correctness constraint information. According to the embodiment of the disclosure, through the operation of the entity components in the visual editing interface and the to-be-audited service data table in the operation area, the correctness constraint information or the compliance constraint information between the to-be-audited fields can be determined, then the target audit code is automatically generated to perform correctness audit or compliance audit on the service data corresponding to the to-be-audited fields, the whole process does not need manual audit of personnel at the audit side, the visual interface enables personnel at the service side and the audit side to easily understand service logic, the labor cost is reduced, and the audit efficiency is improved; in addition, the workload of manually writing codes is reduced, the error probability is effectively reduced, and the auditing quality is improved.
Drawings
In order to more clearly illustrate the embodiments of the present disclosure or the technical solutions and advantages of the prior art, the following description will briefly explain the drawings required for the embodiments or the prior art description, and it is apparent that the drawings in the following description are only some embodiments of the present disclosure, and other drawings may be obtained according to the drawings without inventive effort for those skilled in the art.
Fig. 1 is a schematic diagram of an implementation environment of a service data processing method according to an embodiment of the disclosure.
Fig. 2 is a flow chart of a service data processing method according to an embodiment of the disclosure.
Fig. 3 is a schematic view of an editing interface of a software system according to an embodiment of the disclosure.
FIG. 4 is a schematic diagram of data stored in audited units on a page at the granularity of a data table in a database provided by an embodiment of the present disclosure.
Fig. 5 is a schematic diagram of a determination service data table to be audited according to an embodiment of the disclosure.
Fig. 6 is a schematic diagram of determining a field to be audited provided by an embodiment of the present disclosure.
Fig. 7 is a schematic diagram of generating compliance constraint information provided by an embodiment of the present disclosure.
Fig. 8 is a schematic diagram of another generation of compliance constraint information provided by an embodiment of the present disclosure.
Fig. 9 is a schematic diagram of generating correctness constraint information provided by an embodiment of the present disclosure.
FIG. 10 is a schematic diagram of an editing interface for another software system provided by an embodiment of the present disclosure.
FIG. 11 is a schematic diagram of a compliance editing sub-page provided by an embodiment of the present disclosure.
FIG. 12 is a schematic diagram of another compliance editing sub-page provided by an embodiment of the present disclosure.
Fig. 13 is a flowchart of another service data processing method according to an embodiment of the present disclosure.
Fig. 14 is a flowchart of yet another service data processing method according to an embodiment of the present disclosure.
Fig. 15 is a flowchart of another service data processing method according to an embodiment of the present disclosure.
Fig. 16 is a schematic structural diagram of a service data processing device according to an embodiment of the present disclosure.
Fig. 17 is a schematic structural diagram of a terminal according to an embodiment of the present disclosure.
Detailed Description
The following description of the technical solutions in the embodiments of the present disclosure will be made clearly and completely with reference to the accompanying drawings in the embodiments of the present disclosure, and it is apparent that the described embodiments are only some embodiments of the present disclosure, not all embodiments. All other embodiments, which can be made by one of ordinary skill in the art without undue burden from the disclosure, are within the scope of the disclosure.
It should be noted that the terms "first," "second," and the like in the description and claims of the present disclosure and in the foregoing figures are used for distinguishing between similar objects and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used may be interchanged where appropriate such that the embodiments of the disclosure described herein may be capable of operation in sequences other than those illustrated or described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or server that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed or inherent to such process, method, article, or apparatus, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
In the field of computer technology, a software system refers to a computer software system consisting of system software, supporting software and application software, and is an important component in a computer system. In order to realize man-machine interaction with a user, a software system obtains operation logic of the user, which is usually needed to be completed based on a user interface. User interfaces are media for interaction and exchange of information between a system and a user that enable conversion of information between a computer-internal form and a human-acceptable form.
"compliance" refers to the compliance of data in a software system with country, company, organization, etc. related regulations (e.g., rights, limits, etc.); "compliance audit" refers to auditing the compliance of data in a software system; "compliance constraint" refers to verifying whether it meets compliance requirements for data in a software system that needs to be kept compliant; "compliance audit code" refers to code used to audit data compliance.
"correctness" refers to whether the calculation result of the data audited in the software system is correct, such as commission fee, etc.; "correctness audit" refers to auditing the correctness of data in a software system; the "correct constraint" refers to verifying whether the data in the software system meet the requirement of correctness or not according to the data which needs to keep correctness; "correct audit code" refers to code used to audit the correctness of data.
Audit is taken as a supervision mechanism, and along with the progress of information technology and cross fusion of fields, in the related technology, supervision of economic data can be performed through an audit software system, for example, whether transaction data occurring in the audit software system has business correctness and/or compliance or not is audited through the audit software system. However, in the field related to auditing, the informatization degree is relatively low, the coupling between the business side and the auditing side is too high in the auditing activity, and the auditing is assisted by a software system of a computer, so that the auditing flow communication cost is too high because the data of the business side and the auditing side lack unified standards, and meanwhile, the data table information and the field meaning in the database of the business information system are required to be tidied by the business side and provided for the auditing side, and the auditing side needs to confirm the information meaning for many times, so that the final compliance or correctness auditing scheme can be determined. In addition, compliance or correctness audit analysis relies on the individual abilities and understanding of auditors, and cannot continuously guarantee the efficiency and quality of audit analysis, resulting in low development efficiency of audit-specific software systems.
In the process of man-machine interaction through a user interface, a visual technology is a theory, a method or a technology for converting data into a graph or an image to be displayed on a screen by utilizing a computer graph and image processing technology, and performing interaction processing; the visualization technology enables a user to directly operate the information with the physical body in the graphical interface, and improves the working efficiency of communication with the computer.
Fig. 1 is a schematic structural view of an implementation environment provided by the present disclosure. As shown in fig. 1, in this implementation environment, a terminal 101 and a server 102 are included. A software system for processing service data is installed in the terminal 101, and the software system can audit the correctness constraint information and/or the compliance constraint information of the service data table. The editing interface of the software system is a visual user interface, the user interface is divided into an operation area, and the divided area comprises a component bar area and a work area; a number of standardized functional components for characterizing correctness constraint information and/or compliance constraint information are contained in the component bar area. And the software system responds to the operation instruction, configures a standardized function component in the operation area, generates a target audit code according to correctness constraint information and/or compliance constraint information represented by the standardized function component after the configuration is completed, and carries out correctness audit and/or compliance audit on the business data to be audited.
In this implementation environment, the terminal 101 may be any electronic product capable of performing man-machine interaction through one or more modes such as a keyboard, a touch pad, a touch screen, a remote controller, a voice interaction or a handwriting device, and the electronic product may receive an operation instruction of a user through a visual operation interface thereof and perform real-time visual display on a result of the operation instruction.
By way of example, as shown in fig. 1, the terminal 101 may be a personal computer (Personal Computer, PC), a mobile phone, a smart phone 1011, a personal digital assistant (Personal Digital Assistant, PDA), a wearable device, a Pocket PC, 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 a database of the server 102, where the service data may be data that is not audited, or service data that is audited, or intermediate service data that is temporarily stored in an audit process. The server 102 may push various data to the terminal 101 according to different retrieving instructions sent by the terminal 101. Stored in server 102 is objective audit code for conducting correctness audits and/or compliance audits.
In the implementation environment, the server can adopt an independent server, or a server cluster formed by a plurality of servers, or a cloud computing service center; the form of the server is not limited to the form described by way of example above, and it will be appreciated that the server may also have a data storage function, and the storage function may be implemented using a local database or a cloud database.
It should be understood that the embodiment of the present disclosure illustrates only one implementation environment and one possible implementation result that may be implemented by way of example in fig. 1, that is, the user sends a data call request through the terminal 101, and the server 102 packages and feeds corresponding data back to the terminal 101 for visual display according to the data call request. In other application scenarios of the embodiments of the present disclosure, the service data processing method may be implemented only by the terminal 101 on which the service data processing software system is installed, for example: after the terminal 101 is disconnected from the communication connection with the server 102, a user can perform offline operation according to the data cached in the terminal, and generate a program according to a target audit code built in the terminal 101 to obtain the target audit code and perform correctness audit and/or compliance audit; after being reconnected to the server 102, the service data and the relevant correctness constraint information and/or compliance constraint information cached locally by the terminal 101 are uploaded and updated to the server 102 for data storage and update. The embodiment of the present disclosure is not limited to a specific application scenario, and the application scenario of fig. 1 is merely described as an example.
It can be appreciated that, in the service data processing method provided by the embodiment of the present disclosure, in an implementation environment, a blockchain may be used for data storage; in the implementation process, service data to be audited, which are uploaded by other blockchain nodes, can be acquired from existing blocks in the blockchain, are downloaded to the terminal 101 which is the blockchain node, are visually displayed in an editing interface of the terminal 101, and based on correctness constraint information and/or compliance constraint information among the service data, the correctness audit and/or compliance audit are carried out on the service data through the generated target audit code. In addition, the auditing result and related data can be packaged into a new block through the terminal 101 and uploaded to the block chain; through the data storage mode of the decentralization of the block chain, the service data is more public and safe, and malicious data tampering is avoided at the same time.
As shown in fig. 2, an embodiment of the present disclosure provides a service data processing method, which may be implemented by applying the method to the terminal 101 in fig. 1; alternatively, the method may be performed on any other device or electronic equipment having data processing capabilities.
As shown in fig. 2, the method provided by the embodiment of the present disclosure may include the following steps.
In step S210, an edit page is displayed, the edit page including a component bar area including an entity component and a job area.
Editing interfaces in embodiments of the present disclosure may include, but are not limited to, a component bar area and a job area. The component column area may be used to provide various types of component tools and the job area may then be used to conduct a display of various types of audit elements including, but not limited to, data tables, fields in the data tables, and correctness constraint information and/or compliance constraint information between fields, and the like.
In an exemplary embodiment, a plurality of standardized function components may be included in the component column area, each of which may be used to determine business data table information or correctness constraint information and/or compliance constraint information between fields in the business data table.
In the embodiment of the disclosure, the standardized function components included in the component column area can include a function standardization component and a description standardization component, wherein the function standardization component is used for representing operations (called a table operation component) capable of being performed on a table through a visualized standard component mode and expressing constraint relations (called a function component or a function element) of values of service data through a function mode.
For example, the table operations component can include, but is not limited to, a row/column screening component, a grouping component, a deduplication component, a ranking component, an association component, a merge component, a limit (limit) component, and the like, wherein the row/column screening component can be utilized to perform row/column screening of the selected business data table. The grouping component may be for grouping the selected traffic data tables. The deduplication component may be operative to deduplicate the selected traffic data table. The sorting component can be operative to sort the selected traffic data table. The association component can be operative to associate the selected business data table. The merge component can be operative to merge the selected service data tables. The limit component may be configured to perform limit operations on the selected business data table.
Functional elements may include, but are not limited to, relational operation components, arithmetic operation components, logical operation components, mathematical function components, time function components, conditional function components, string function components, and aggregate function components, where relational operation components may be used to express numerical magnitude relationships of values of business data, including, but not limited to: greater than (denoted ">), less than (denoted" < "), equal to (denoted" = "), null (denoted" is null "), comparing whether two strings match (denoted" like "), and the like.
The arithmetic operation component may be used to express arithmetic operations between business data, including but not limited to: add (denoted "+"), subtract (denoted "-"), multiply (denoted "x"), divide (denoted "/"), modulo (denoted "%"), etc.
The logical operations component may be used to represent logical operations between business data, including, but not limited to: and (denoted "and/or" & "), or (denoted" or "and/or" || ") or not (denoted" not "and/or" | "), etc.
Mathematical function components may be used to represent mathematical functions of business data, including, but not limited to: rounding the number to a specified number of bits (denoted as "round"), rounding down (denoted as "floor"), an exponential function based on a natural constant e (denoted as "exp"), returning a minimum integer greater than or equal to the expression (denoted as "ceil"), and so forth.
The time function component may be used to represent a time function of the business data, including, but not limited to: year (indicated as "year"), month (indicated as "month"), day (indicated as "date"), and the like.
The conditional function component may be used to represent conditional functions that are satisfied by the business data, including, but not limited to: when one condition judges that there are a plurality of values, different operations (denoted as "if, case white then") and the like are performed, respectively.
The string function component may be used to represent string functions of business data, including, but not limited to: string length (denoted as "length"), character intercept function (denoted as "substring"), space clearing (denoted as "trim"), programming function (denoted as "lower") that converts all strings in text into lowercase, and the like.
The aggregate function component may be used to represent aggregate functions between business data, including, but not limited to: the number of data is counted (denoted as "count"), summed (denoted as "sum"), averaged (denoted as "avg"), minimized (denoted as "min"), maximized (denoted as "max"), and the like.
The standardized component is described for representing the audit categories performed by means of a standardized component of the visualization. For example, compliance audits may be represented by compliance identification components (all illustrated below with a left bracket "{" specified by the system, but the disclosure is not limited thereto) for selected ones of the pending meter business data sheets, and specific compliance constraint information may be formulated. As another example, correctness constraint information may be formulated.
The standardized functional components in the visualizations of functional elements are illustrated in the embodiments of fig. 3 and 10 below, but the disclosure is not so limited and may also include a table manipulation component, a compliance identification component, etc. in the component column area.
In step S220, in response to an operation instruction for the entity component in the component bar area, a business data table to be audited is displayed in the job area.
In an exemplary embodiment, displaying a business data table to be audited in the job area in response to an operation instruction to the entity component in the component bar area may include: displaying a first entity component in the operation area in response to an operation instruction for the entity component in the component bar area; and responding to an operation instruction of the first entity component in the working area, and converting the first entity component into the pending-meter service data table.
In the embodiment of the disclosure, the operation instruction for the entity component may include an instruction that a user performs an operation on the entity component in a component bar area of the editing interface, and the component bar area captures a corresponding operation and triggers the operation; the operation includes, but is not limited to, a user moving, clicking, dragging, etc. the physical component in the component bar area. In the following example, a first physical component is displayed in a work area in response to a user operation instruction to drag the physical component in the component bar area to the work area.
In the embodiment of the disclosure, the operation instruction for the first entity component may include an instruction that a user performs an operation on the first entity component in a working area, and the corresponding operation is captured and triggered by the working area; the operation includes, but is not limited to, a user moving, clicking, dragging, double clicking, entering, etc. a first physical component in the job area. In the following illustration, in response to a double-click operation performed by a user on a first entity component in a job area, a window input box is flicked on an editing interface, and a user may input a table name (for example, an order table tab) or a unique table identifier (for example, tab) of a to-be-audited service data table in the input box, so as to determine that the service data table corresponding to the input table name or table identifier is taken as the to-be-audited service data table.
In step S230, in response to an operation instruction to the pending service data table in the job area, determining pending fields in the pending service data table and compliance constraint information or correctness constraint information of the pending fields.
In the embodiment of the disclosure, the correctness constraint information and/or the compliance constraint information are used for characterizing fields in a business data table or constraint relations among the fields, and the fields needing to be audited whether the correctness constraint information and/or the compliance constraint information meet or not are called to-be-audited fields.
In an exemplary embodiment, a compliance identification component, a function component, and a table manipulation component may also be included in the component column region. Wherein, in response to the operation instruction to the pending service data table in the operation area, determining the pending fields in the pending service data table and compliance constraint information of the pending fields may include: determining a pending field in the pending service data table in response to an operation instruction to the pending service data table in the operation area; responsive to an operation instruction to the compliance identification component in the component bar area, displaying a compliance identification at a first predetermined location of the pending fields; and in response to an operation instruction to the function component and the table operation component in the component bar area, displaying compliance constraint information of the pending fields at a second predetermined location of the compliance identification component.
In some embodiments, a compliance audit may be performed on the determined pending business data table itself, for example, a compliance identification component may be dragged from a component column area to a first predetermined location of a corresponding field of the pending business data table, the system may determine that the corresponding field is a pending field, a function component and a table operation component in the component column area may be operated at a second predetermined location of the compliance identification component to generate compliance constraint information for the pending field, the first predetermined location and the second predetermined location may be determined according to a predetermined setting, and in the following illustration, the first predetermined location is determined to be to the right of the pending field and the second predetermined location is determined to be the second predetermined location of the compliance identification component in the system, but the disclosure is not limited thereto.
In an exemplary embodiment, determining a pending meter field in the pending meter business data table in response to an operation instruction to the pending meter business data table in the job area may include: responding to an operation instruction of the to-be-examined business data table in the operation area, and displaying field information in the to-be-examined business data table in the operation area; and determining a pending meter field in the pending meter service data table in response to an operation instruction for field information in the pending meter service data table displayed in the operation area.
In some embodiments, the operation instruction of the to-be-audited service data table in the operation area may be an instruction triggered by a preset operation of clicking, double clicking, dragging, etc. on the to-be-audited service data table in the operation area by a user, for example, the to-be-audited service data table in the operation area is double clicked by the user, field information in the to-be-audited service data table may be displayed at a corresponding position (e.g., below) in the operation area, for example, one or more of a field name, whether to fill in, a composition, a length, etc. of each field included in the to-be-audited service data table may be displayed.
The operation instruction of the displayed field information in the operation area may be an instruction triggered by a preset operation such as a single click, a double click, a drag, a right click, a selection, etc. performed by the user on the field information displayed in the operation area, for example, when the user selects some field information displayed below the operation area, the field corresponding to the selected field information is determined as the field to be checked.
In an exemplary embodiment, a table manipulation component may also be included in the component column area. Wherein determining a review field in the review business data table in response to an operation instruction to the review business data table in the job area may include: and determining a pending meter field in the pending meter service data table in response to an operation instruction of the pending meter service data table in the operation area and an operation instruction of the table operation component in the component column area.
In other embodiments, when a list operation component is included in the component bar area, the user may first select the to-be-audited service data list in the operation area, and then may perform operations such as dragging, clicking, double clicking, and the like on the corresponding list operation component in the component bar area, for example, a row screening component, so as to perform row screening on the to-be-audited service data list in the operation area, thereby determining the to-be-audited field.
In an exemplary embodiment, the component bar area may further include an associated component. Wherein displaying compliance constraint information of the review field at a second predetermined location of the compliance identification component in response to an operation instruction to the function component in the component bar area may include: responsive to an operation instruction to the associated component in the component bar area, displaying a first business data table associated with the review field at a second predetermined location of the compliance identification component; and in response to an operation instruction to the function component in the component column area, displaying compliance constraint information of a first field in the first business data table at a second preset position of the compliance identification component, wherein the compliance constraint information of the pending field comprises the compliance constraint information of the first field.
In some embodiments, when auditing whether the to-be-audited fields in the to-be-audited service data table meet the compliance constraint, auditing is required whether corresponding fields (called first fields) in other service data tables (called first service data tables) associated with the to-be-audited service data table meet the compliance constraint, if the corresponding fields in the first service data table meet the compliance constraint, determining that the to-be-audited fields in the to-be-audited service data table meet the compliance constraint, otherwise, determining that the to-be-audited fields in the to-be-audited service data table do not meet the compliance constraint. The first service data table may be one or more, and may be obtained according to actual situations.
In some embodiments, a service data table having the same or similar fields as the pending service data table may be used as the first service data table, or a service data table having an association with a pending field in the pending service data table may be used as the first service data table, and a field in the first service data table having an association with the pending field may be determined as the first field.
In some embodiments, when the component column area includes the association component, after the user determines the pending field in the operation area, the user may directly trigger the association component in the component column area through clicking, double clicking, dragging, etc. operations, and the system automatically queries the first service data table and displays the first service data table in the operation area, and further, the system may also automatically query the first field and display the first field in a corresponding position of the first service data table in the operation area.
In an exemplary embodiment, in response to an operation instruction to the function component in the component bar area, displaying compliance constraint information of the pending fields at a second predetermined location of the compliance identification component may include: displaying a second entity component in the operation area in response to an operation instruction for the entity component in the component bar area; responsive to an operation instruction to the second entity component in the working area, converting the second entity component into a second business data table associated with the pending fields; and in response to an operation instruction to the function component in the component column area, displaying compliance constraint information of a second field in the second business data table at a second preset position of the compliance identification component, wherein the compliance constraint information of the pending field comprises the compliance constraint information of the second field.
In other embodiments, instead of using the above-mentioned association component, the user may also generate a second entity component by using a similar manner of determining the to-be-audited service data table, for example, dragging the entity component in the component column area to the operation area again, and when the user double-clicks the second entity component, popping up an input box to input the table name or the table identifier of the second service data table, so as to display the second service data table in the operation area. When auditing whether the to-be-audited fields in the to-be-audited business data table accords with the compliance constraint, whether corresponding fields (called second fields) in other business data tables (called second business data tables) associated with the to-be-audited business data table accord with the compliance constraint is required to be audited, if the corresponding fields in the second business data table accord with the compliance constraint, the to-be-audited fields in the to-be-audited business data table accord with the compliance constraint is judged, otherwise, the to-be-audited fields in the to-be-audited business data table do not accord with the compliance constraint is judged. The second service data table may be one or more, and may be obtained according to actual situations.
In an exemplary embodiment, a compliance identification component may also be included in the component bar area. Wherein, in response to the operation instruction to the pending service data table in the operation area, determining the pending fields in the pending service data table and compliance constraint information of the pending fields may include: determining a pending field in the pending service data table in response to an operation instruction to the pending service data table in the operation area; in response to an operation instruction to the compliance identification component in the component bar area, displaying a compliance editing sub-page of the to-be-checked field, wherein the compliance editing sub-page can comprise an entity selection control, an entity attribute selection control, an operator selection control and an attribute value determination control; and generating compliance constraint information of the to-be-examined field in response to operation instructions of the entity selection control, the entity attribute selection control, the operator selection control and the attribute value determination control.
In the embodiment of the disclosure, the compliance editing subpage refers to a page for editing compliance constraint information on the basis of the editing page, for example, in the form of a single page or a popup floating frame, and the compliance editing subpage may include an entity selection control, an entity attribute selection control, an operator selection control and an attribute value determination control, and a user may select, by operating the entity selection control, an entity related to compliance audit of a service data table to be checked (i.e., the service data table may be the service data table to be checked itself, or the first service data table or the second service data table); the user can select a field (either the pending field itself or a first field or a second field related to the pending field) related to the pending field by operating the entity attribute selection control; the user may select a desired operator (e.g., may include logical operation operators and/or relational operation operators, etc.) by manipulating an operator selection control; the user may enter or select the attribute value that needs to be satisfied by the selected field by manipulating the attribute value determination control. According to the embodiment of the disclosure, the business data table to be audited and the fields to be audited are determined firstly, then the compliance editing sub-page is displayed for editing the compliance constraint information, so that the options in the list displayed in the drop-down frame of the entity selection control and the entity attribute selection control can be reduced, and a user can conveniently and quickly determine the required entities and fields from the list. For example, reference may be made to the description of the embodiment of fig. 11 and 12 below.
In an exemplary embodiment, the component column area may further include a table operation component and a function component. Determining a pending field in the pending service data table and correctness constraint information of the pending field in the pending service data table in response to an operation instruction to the pending service data table in the job area may include: determining a pending field in the pending service data table in response to an operation instruction to the pending service data table in the operation area; displaying a third service data table and a fourth service data table associated with the pending-meter field in the job area; determining operation relation information between a third field in the third service data table and a fourth field in the fourth service data table in response to an operation instruction to the function component, and determining a fifth field in a fifth service data table and corresponding service data thereof according to the operation relation information; and generating correctness constraint information between the to-be-checked field and the fifth field as the correctness constraint information of the to-be-checked field in response to operation instructions of the table operation component and the function component. For example, reference may be made to the description of the embodiment of fig. 9 below.
In step S240, a target audit code is generated according to compliance constraint information or correctness constraint information of the to-be-inspected field in the to-be-inspected service data table, where the target audit code is used for performing compliance audit on service data corresponding to the to-be-inspected field according to the compliance constraint information or performing correctness audit on service data corresponding to the to-be-inspected field according to the correctness constraint information.
The target audit code can be used for conducting correctness and/or compliance audit on the business data corresponding to the field to be audited; the correctness and/or compliance audit is the verification of the correctness and/or compliance constraints on the business data corresponding to the pending fields of the pending business data table for which the correctness and/or compliance constraints are established. For example, by verifying whether the service data at the two ends of the connecting line meet the functional relation in the functional element, if so, the data can be audited, and if not, the data is abnormal and the data cannot be audited. It will be appreciated that the results of the audit may be visually displayed in the work area, including but not limited to alert icons and reminders of text content.
In some alternative embodiments, to improve the risk resistance and the security performance, the service data processing method may further include: acquiring a business data table for correctness and/or compliance audit and an audit result of the correctness and/or compliance audit; the business data table is stored in a distributed mode in a database cluster, and the auditing result is stored in a distributed mode in a server cluster.
The server cluster refers to that a plurality of servers are gathered together to perform the same service, and the perception of the client side is that only one server exists. By way of example, the embodiment can realize the encapsulation of standardized function components based on the c++ language, and realize standardized functions and result comparison; recording data generated by interface operation, including but not limited to data table information in a database, standard function information used, compliance constraint information and/or correctness formulas, and the like, packaging the correctness and/or the compliance constraint information, carrying out structuring and modularization processing on a service data table (called as a data table for short), precipitating structured data, and facilitating the realization of automatic flow processing by a software system. In the embodiment of the disclosure, the back-end software system service can adopt a distributed deployment mode, and each back-end service can keep a plurality of copies so as to improve the availability of the software system service. In the embodiment of the disclosure, a Mysql relational database management system can be used for data storage, and redis is synchronously adopted as a cache for guaranteeing system performance. In addition, the database cluster can be deployed separately from the service cluster to reduce the coupling of services and data and provide disaster recovery capability of the database.
The business data processing method provided by the embodiment of the disclosure includes displaying an editing interface, wherein the editing interface comprises a component column area and a working area, the component column area comprises an entity component, and a business data table to be audited can be displayed in the working area through an operation instruction of the entity component in the component column area; then, based on the operation instruction of the to-be-checked business data table in the working area, to-be-checked fields in the to-be-checked business data table and compliance constraint information or correctness constraint information of the to-be-checked fields can be determined; and then, generating a target audit code for performing compliance audit on the to-be-inspected field according to the compliance constraint information or the correctness constraint information of the to-be-inspected field in the to-be-inspected service data table, or generating a target audit code for performing correctness audit on the to-be-inspected field according to the correctness constraint information. According to the embodiment of the disclosure, through the operation of the entity components in the visual editing interface and the to-be-audited service data table in the operation area, the correctness constraint information or the compliance constraint information between the to-be-audited fields can be determined, then the target audit code is automatically generated to perform correctness audit or compliance audit on the service data corresponding to the to-be-audited fields, the whole process does not need manual audit of personnel at the audit side, the visual interface enables personnel at the service side and the audit side to easily understand service logic, the labor cost is reduced, and the audit efficiency is improved; in addition, the system provides a standard function for service personnel, reduces the workload of manually writing codes, effectively reduces the error probability and improves the auditing quality.
Illustratively, as shown in FIG. 3, the displayed editing page may include a component bar area 302 and a job area 301. The component column area 302 may provide component tools for characterizing various types of correctness constraint information and/or compliance constraint information, e.g., providing physical components and transaction components in component tools of system elements (the physical components and the transaction components may each be represented by different symbols, e.g., as shown in fig. 3 and 5, respectively).
The entity component may be used to characterize the storage structure of a particular hardware device or data plane involved in the auditing process, and the business data or associated business data tables associated with the entity component may be obtained from a database of the server during the auditing process. By manipulating the entity components in the component column area 302, a business data table to be audited can be determined and displayed in the job area.
The transaction component may be used to characterize a specific transaction involved in an audit process, where a service data acquisition manner of the transaction component is the same as that of the entity component, and the transaction component and the entity component both load or record service data in a form of a data table, for example, fig. 4 is a schematic diagram of data stored in an audited unit on a page according to granularity of a data table in a database provided in an embodiment of the present disclosure, and it is assumed that a table a includes a key (key) and a attribute value attr corresponding to the key, and a table B includes a key and a attribute value attr corresponding to the key.
In addition, since the service data in the embodiment is mainly shown in the form of a data table, referring to fig. 3, the component column area 302 also provides a component tool of the data table: an entity list component; the service data tables may be displayed or queried by the entity list component, for example, as shown in fig. 5, under the entity list component, table names and table identifications of respective service data tables may be displayed, such as an order table tableea, a commodity information table tableeb, a user information table tableec, a user order detail table tableed, a user order summary table tableee, etc., in each of which various service data may be recorded. The entity list component can preferentially display the service data list which is currently used in the operation area, and can also provide a search box for a user to input a list name or a list identification in the search box for searching.
Fig. 5 is a schematic diagram of a determination service data table to be audited according to an embodiment of the disclosure.
As shown in fig. 5, when the user drags the entity component in the component bar area to the job area, a first entity component is displayed, and when the user double-clicks the first entity component, an input box (not shown in the figure) may be popped up, and the user may refer to a table name or a table identifier displayed in the entity list, and input a table name or a table identifier of a to-be-audited service data table, for example, tableea, in the input box, so as to determine that the tableea is taken as the to-be-audited service data table 502.
Fig. 6 is a schematic diagram of determining a field to be audited provided by an embodiment of the present disclosure.
As shown in fig. 6, when the user double-clicks the to-be-checked business data table tab in the work area, field information in the tab may be displayed under the work area, including, for example, a field name of each field including an application ID, a merchant number, a device number, a commodity description, commodity details, additional data, a merchant order number, a bid amount, an order amount, a terminal IP, a hand-over start time, a hand-over end time, a preference flag, a payment result notification address, a payment product, and the like, whether each field is a necessary item, a composition of each field, a length of each field, and the like.
Fig. 7 is a schematic diagram of generating compliance constraint information provided by an embodiment of the present disclosure.
As shown in fig. 7, step S1 is to display, in the operation area, a to-be-audited service data table TableA and a field (k is an abbreviation of a key) and an attribute value thereof (i.e., corresponding service data, denoted by f) included therein, then drag a row filtering component in a table operation component in a component column area, screen the to-be-audited field by using the row filtering component, and assume that key1 is an order amount field in the table ea and a corresponding attribute value thereof is an attribute value corresponding to the order amount field, denoted as fee1, and the screened to-be-audited field and the attribute value thereof can be used as a Left value left_value, where the Left value in the embodiment of fig. 7 refers to the to-be-audited field located at the Left side of the compliance identification component and the attribute value thereof, which is referred to as screening the Left value from an existing table (e.g., table ea).
And S2, a user drags a compliance identification component in the component column area, for example, a left bracket "{" to the right side of the to-be-checked field to inform the system that key1 is the to-be-checked field, and compliance audit is required to be carried out on the to-be-checked field, namely, compliance constraint given on the right side of the left bracket is required to be met.
In step S3, in the embodiment of fig. 7, with the audit to-be-audited field itself illustrated, the user may copy or drag the tab a displayed in the operation area to the right side of the left bracket, or drag the entity component in the component column area again to the right side of the left bracket, double-click the entity component on the right side, input "tab a" in the input box of the popup window, and select the key1 field in the tab a, after displaying the key1 and its corresponding fe 1, double-click the selected fe 1, or right-click the selected fe 1, pull a line segment to connect the fe 1, and drag the "> =" component in the function component in the component column area to the other end of the line segment, and then input the number "100" after "> =" in the operation area, indicating that the compliance constraint information to be audited by the value y1 is to be greater than or equal to 100, and thus, as to whether the right value satisfies the compliance constraint of greater than or equal to 100 is calculated.
Fig. 8 is a schematic diagram of another generation of compliance constraint information provided by an embodiment of the present disclosure.
As shown in fig. 8, in step S1, firstly, a to-be-audited business data table tab a and a field k and an attribute value f included in the table tab a are displayed in a working area, then, a user drags a row screening component in a table operation component in a component column area, the row screening component is utilized to screen out a to-be-audited field key1 and a corresponding attribute value fee1, and the screened out to-be-audited field and the attribute value thereof can be used as a Left value left_value.
And S2, the user drags a left bracket "{" of the compliance identification component in the component column area to the right side of the to-be-checked field to inform the system that key1 is the to-be-checked field, and compliance audit is to be carried out on the to-be-checked field.
Step S3, in the embodiment of fig. 8, other fields (for example, the first field or the second field may be the above-mentioned) associated with the audit field are illustrated, in some embodiments, the user may drag the entity component in the component column area to the right side of the left bracket again, double-click the entity component on the right side, input "tab" in the input box of the popup window, select the key2 field in the tab b, after displaying the key2 and its corresponding fe 2, double-click the selected fe 2, or right-click the selected fe 2, pull a line segment to connect the fe 2, and drag the "> =" component in the function component in the component column area to the other end of the line segment, and then input the numeral "1" after "> =" in the operation area, which indicates that compliance constraint information to be satisfied by the audit field key2 is that the fe 2 is greater than or equal to 1; similarly, the user may drag the entity component in the component column area to the right side of the left bracket again, double-click the entity component on the right side, input "TableC" in the input box of the popup window, and select the key3 field in the TableC, after displaying key3 and the corresponding fe 3, the user may drag the entity component in the component column area to the right side of the left bracket again, double-click the entity component on the right side, input "table d" in the input box of the popup window, and select the key4 field in the table d, double-click select the fe 3, or right-click select the fe 3, pull one line segment to connect the fe 3, drag the "=" component in the function component in the component column area to the other end of the line segment, double-click the selected fe 4, or right-click the other line segment to connect the fe 4 and "=" component, respectively, to indicate that the corresponding values of the table 4 and the corresponding fe 3 in the table 2 should satisfy the constraint of the table 4 in the table window should be equal; the user can drag the entity component in the component column area to the right side of the left bracket again, double-click the entity component on the right side, input a 'TableE' in an input frame of the popup window, select a key5 field in the TableE, after displaying the key5 and the corresponding fee5, double-click the selected fee5, or right-click the selected fee5, pull out a line segment to connect the fee5, drag a 'component in a function element in the component column area to the other end of the line segment again, and then input a numeral' 200 'after' in an operation area, which indicates that compliance constraint information to be met by the to-be-inspected field key5 is smaller than 200; that is, the compliance constraint information to be satisfied by the to-be-examined field key1 includes that fe 2 on the right side of the left bracket is greater than or equal to 1, and fe 3 is equal to fe 4, while fe 5 is less than 200, and only when the three conditions are satisfied at the same time, it is determined that the key1 satisfies the compliance constraint information, otherwise, if any one of the conditions is not satisfied, it is determined that the key1 does not satisfy the compliance constraint information.
In other embodiments, the user may click on the associated component in the component column area after dragging the compliance identification component left bracket to the right of fee1, the system will automatically look up the business data table TableB, tableC, tableD and TableE associated with the key1 field and display it to the right of the left bracket, and subsequent operations may be described with reference to the above embodiments. The search speed of other business data tables associated with the business data table to be checked can be accelerated through the association component.
In other embodiments, in calculating whether the right value satisfies the compliance constraint, an aggregation function, such as sum, in the component column region may also be dragged to sum selected fields in the business data table to the right of the left brace and to give compliance constraint information that the sum should satisfy.
Fig. 9 is a schematic diagram of generating correctness constraint information provided by an embodiment of the present disclosure.
As shown in fig. 9, step S1 is to display, in the operation area, a to-be-audited service data table ea and the fields k and attribute values f included therein, then drag a row screening component in the table operation component in the component column area, screen out a to-be-audited field key1 (assuming that a real fee is indicated) and the corresponding attribute values fee1 by using the row screening component, and use the screened to-be-audited field and the attribute values thereof as a Left value left_value.
In step S2, the user may drag the entity component in the component column area to the Right side of the left bracket again, double-click the entity component on the Right side, input "table eb" in the input box of the popup window, and select the key2 field in table eb, after displaying key2 (assuming that the field of the procedure fee should be received) and its corresponding fe 2, the user may drag the entity component in the component column area again to the Right side of the left bracket, double-click the entity component on the Right side, input "S (is a simple letter of Sum)" in the input box of the popup window, select the key4 field in Sum (assuming that the procedure fee has been removed), double-click the selected fe 2 after displaying key4 and its corresponding sum_fe, or Right-click the selected fe 2, pull a line segment connecting fe 2, and drag the "- (minus" component in the function element in the component column area to the other end of the line segment, and then double-click the Right-side window, or a value of the window segment connecting with the Right-window 5 is obtained by pulling the value of "window_window_5", and the procedure fee value indicating that the procedure fee is received by the Right-5 is subtracted, respectively.
Step S3, a user selects a key1 field in a Left value left_value, pulls out one end of a line segment to be connected with key1, drags a connecting component (two circles which are partially intersected in the drawing) in a list operation component from a component column area, then selects a key5 field in a Right value right_value, pulls out a line segment to be respectively connected with the key5 and the connecting component in an operation area, so as to represent that an attribute value fee1 corresponding to the key1 field is real-time fee and an attribute value fee5 corresponding to the key5 field is real-time fee-sum (time-cost-off) are compared, if the comparison results are consistent, an intersection is taken, and a result consistent in comparison is reserved; and for the inconsistent comparison result, the left value and the right value which are inconsistent in comparison are reserved, and then the row screening components in the component column area are dragged, so that the left value and the right value which are inconsistent in comparison result can be screened out and displayed. That is, the correctness constraint information in the embodiment of fig. 9 is that the real fee is equal to the chargeable fee minus the refund fee.
Note that in the embodiments of fig. 7 to 9, all the fields in the table of the pending-meter service data may be selected as the pending-meter fields, and the line screening component may not be used.
FIG. 10 is a schematic diagram of an editing interface for another software system provided by an embodiment of the present disclosure.
In the embodiment of fig. 10, the component column area of the editing interface includes function elements for illustration, and the standardized function components for visualization include common function components, normal function components, advanced analysis function components, logic operator components, and the like, where "fx=" representing "equals", "fx+" representing "adding", "Fx-" representing "subtracting", "fx×" representing "multiplying", and "Fx/dividing" are included in the common function components, and it is understood that the function components included in the function elements may be set according to actual requirements, and may be set to represent corresponding symbols, and are not limited to the illustrated examples.
As shown in FIG. 11, in addition to determining compliance constraint information and/or correctness constraint information by dragging the standardized function components in the component column area in the embodiments of FIGS. 7-9 described above, compliance constraint information and/or correctness constraint information may also be edited by a compliance editing sub-page 1101.
As shown in FIG. 11, entity selection control 1102, entity property selection control 1103, operator selection control 1104, and property value determination control 1105, text editing control 1106, formula editing browse control 1107 may be included in compliance editing sub-page 1101.
When the user clicks on the drop-down identification of the entity selection control 1102, the selectable business data table is displayed in a drop-down list manner: such as TableA (order table), tableB (merchandise information table), tableC (user information table), tableD (user order details table), and TableE (user order summary table).
As shown in fig. 12, assuming that tab is selected by the user, when the user clicks on the entity attribute selection control 1103, the selectable fields, such as entity attribute one entity attribute three two entity attribute three, and entity attribute three, are displayed in a drop-down list.
Assume that the user sequentially selects entity attribute one EntityAttributeOne, entity attribute two EntityAttributeTwo and entity attribute three EntityAttributeThree of TableA, and the user selects component "In" for entity attribute one EntityAttributeOne by operating operator selection control 1104, and inputs numerals "1,4,8" In corresponding attribute value determination control 1105 to indicate that compliance constraint information to be satisfied by entity attribute one EntityAttributeOne of TableA is 1,4 and 8 In corresponding service data thereof. The user selects the "= =" component for the entity attribute two EntityAttributeTwo by operating the operator selection control 1104, and inputs the number "1" in the corresponding attribute value determination control 1105, so as to indicate that compliance constraint information to be satisfied by the entity attribute two EntityAttributeTwo of TableA is equal to 1 for the corresponding service data. The user selects "= =" component for the entity attribute three entityatttributethree by operating the operator selection control 1104. Meanwhile, when the fields selected by the user exceed 1, the operator selection control 1104 may further display a logic operation component, and the user may select a corresponding logic operation, for example, logic or "|") through the displayed logic operation component, so as to indicate that compliance constraint information required to be satisfied by the field to be examined only needs to satisfy 1,4 and 8 in the service data corresponding to the entity attribute one of the tableaa, or the service data corresponding to the entity attribute two of the tableaa is equal to 1, or the service data corresponding to the entity attribute three of the tableaa is equal to any one of a certain number of values, so that compliance constraint can be determined.
After the configuration is completed, according to the target audit code generated by the server 102, correctness audit and/or compliance audit are performed on service data corresponding to the to-be-audited fields in the to-be-audited service data table in the operation area of the terminal 101, and the result obtained by the audit is visually displayed.
To this end, the embodiments of the present disclosure provide a business data processing method, which is based on an editing interface of a software system, where standardized function components in a component column area may be configured in a job area according to an operation instruction of a user, and elements to be audited may include, but are not limited to, a business data table, fields in the business data table, and correctness constraint information and/or compliance constraint information of the fields. And then, generating a target audit code according to the element to be audited, and performing correctness and/or compliance audit. The correctness and/or compliance referred to above refers to correctness and/or compliance of the service provided by the service data. According to the embodiment of the disclosure, through the operation of the standardized functional components in the editing interface, such as dragging, clicking and the like, the correctness and/or compliance audit of the business data in the element to be audited by the target audit code can be automatically generated, the manual audit of personnel on the audit side is not needed, and the editable operation interface enables personnel on the business side and the audit side to easily understand the business logic, so that the labor cost is reduced and the audit efficiency is improved; in addition, through the components packaged by the standardized function, the standardized function is provided for service personnel to reduce the workload of manual code writing, the process is simpler, the error probability is effectively reduced, and the auditing quality is improved.
Fig. 13 is a flowchart of another service data processing method according to an embodiment of the present disclosure.
As shown in fig. 13, the method provided by the embodiment of the present disclosure may include the following steps.
In step S1310, a data table in the database of the data to be screened is displayed as the business data table to be audited.
In step S1320, the data in the data table is filtered using the standardized function component to determine the pending fields.
In step S1330, the compliance constraints or correctness constraints are described using standardized compliance or correctness symbols to automatically generate target audit code.
As shown in fig. 13, the operation procedure performed at the editing interface may be divided into three steps, firstly, a data table of data to be screened is displayed at the editing interface, then, the data in the data table is screened by the standardized functional component, and finally, the standardized correctness and/or compliance symbol is used to describe the correctness and/or compliance constraint information. Specifically, the user determines the data tables (the data tables can be any number) to be added, then selects a system element, e.g., an entity component or a transaction component, from the component column area, loads the added data tables into the system element as pending business data tables displayed in the job area, then connects fields of different tables with lines according to correctness and/or compliance constraint requirements between the different data tables, and distinguishes between the different tables with brackets to express that the different fields have correctness and/or compliance constraint information. In addition, the user may also add specific function elements to the line from the component column region to express specific contents of the correctness and/or compliance constraint information, for example, two fields may be equal, a value of a certain field is greater than a certain value, and so on. The results obtained are shown in fig. 7 or 8, indicating that the key1 field of the TableA data table needs to satisfy the compliance constraint information shown on the right side of the bracket, or the results obtained are shown in fig. 9, indicating that the key1 field of the TableA data table needs to satisfy a value equal to the key2 field of the TableB minus the value of the key4 field in the sum data table.
Then, according to correctness and/or compliance constraints among the data tables expressed by the operation area, the software system can automatically generate relevant codes for auditing relevant data in the database, namely, auditing whether the values of the corresponding fields of the table or the tables meet the correctness and/or compliance constraint information, if so, auditing is passed, and if not, the data is problematic, and not.
In the embodiment of the disclosure, the front-end code of the software is implemented based on a Vue open source framework and an element UI open source component, and the standardized function component obtained by packaging independent standardized functions and standardized descriptions is plug and play where required, for example, functional expressions or formulas for describing correctness and/or compliance constraint information are packaged in function elements in fig. 10, for example, the functions may include relational functions (including but not limited to "greater than", "less than", "equal to", and the like), arithmetic operations (including but not limited to adding, subtracting, multiplying, dividing, and the like), and in the case that the correctness and/or compliance constraint information or complex correctness and/or compliance constraint information needs to be established, the establishment of the correctness and/or compliance constraint information or complex correctness and/or compliance constraint information can be completed by clicking and dragging and the like simple interactive instructions. In addition, the standardized functions of the encapsulation in the embodiments of the present disclosure may further include table operation operations, including but not limited to association operations, row filtering operations, merging operations (unit), and connection operations of the data table. The standardized functionality encapsulated in embodiments of the present disclosure may also include a compliance identification component, and the compliance symbol used to represent the compliance identification component may be a special symbol "{" specified by the system, i.e., left brackets, used to identify that certain data is required to satisfy compliance constraints. The standardized function of the encapsulation in the embodiment of the disclosure may further include a correctness formula, so as to represent a calculation formula to be satisfied in the service, for example, a commission fee=transaction amount is 0.6%, so that an operation throughput of personnel at the service side can be reduced, and an auditing process is more intelligent and automatic.
In summary, the following description will be given for the embodiment: according to all possible correctness and/or compliance relation components (i.e. function elements) and content components (i.e. system elements), the user builds a functional interface as shown in fig. 10 or fig. 11 or fig. 12, selects the data table to be audited from the corresponding system elements, and clearly expresses the fields to be audited among the fields of each data table as fields to be audited; for example, which fields require auditing may be determined based on correctness and/or compliance constraint information preset in advance by the user. After the configuration of the operation area is completed, the system automatically generates a target audit code according to correctness and/or compliance constraint information among fields, and audits all actual data, and the process does not need audit staff to perform manual audit or check, so that the audit efficiency is improved.
Under the condition that business operation is required to be executed on business data, related technicians write codes manually to obtain target audit codes capable of executing the business operation. However, since there is a lot of repetitive content in the manually written code, the related technicians need to perform repetitive work in the process of handwriting the code, resulting in inefficiency in code generation. In addition, the quality of the code and the accuracy of the code in performing business operations depend on the ability of the relevant technician to write the code, resulting in that the quality of the code and the accuracy of the execution cannot be guaranteed.
The business data processing method can automatically generate codes for executing business operations of target businesses, so that the technical problems of low code generation efficiency, poor code quality and low code execution accuracy caused by handwriting of codes by personnel in related technologies are solved.
The target audit code generated in embodiments of the present disclosure may include a compliance audit code and/or a correctness audit code, the following fig. 14 embodiment being illustrated with the generation of the compliance audit code and the fig. 15 embodiment being illustrated with the generation of the correctness audit code.
In combination with the application scenario of compliance audit code generation, the embodiment of the present disclosure further provides a service data processing method, as shown in fig. 14, where the method provided by the embodiment of the present disclosure may include the following steps.
In step S1410, preset grammar rules associated with compliance audits are preset.
Specifically, the preset grammar rules associated with the compliance audit may include keywords, entities and operations, and grammar structure relationships among the keywords, entities and operations, the preset grammar rules may be domain specific language (Domain Specific Language, DSL), for example, after defining the basic entity of the merchant multi-mechanism account application form, the data structure of the entity may include the merchant multi-mechanism application form ID, the non-multi-mechanism application form ID, the mechanism type, and the like, and when the entity audit is concerned, the field data of the merchant multi-mechanism application form ID, the non-multi-mechanism application form ID, and the mechanism type are selected as audit items. Next, S1460 is performed.
In step S1460, a preset code template associated with compliance auditing is preset; next, S1420 is performed.
In an embodiment of the disclosure, the preset code template includes a generic part of the code; wherein the generic part is the code part necessary for the target audit code in the case of performing the business operations of the target business.
In the embodiment of the disclosure, a plurality of preset code templates can be set according to the requirement information of different target services or the different requirement information of the same target service; then, a preset code template matched with the target service can be obtained by using a preset code template. Specifically, according to the requirement information of the target service, determining a code template matched with the target service from a plurality of preset code templates; and taking the matched code template as a target audit code template.
In an embodiment of the disclosure, the requirement information includes a service requirement of the target service, where the service requirement characterizes a requirement of performing a service operation of the target service. Taking the target business as a financial management business and the business operation as a compliance audit operation as an example, the business requirements can include requirements for compliance audit of merchant multi-mechanism account application forms in the financial management system.
In the related art, the target audit code written for executing the business operation of the target business generally includes a large amount of repeated content, so that the related technicians need to perform repeated work, and the execution efficiency of the code is reduced while consuming a large amount of manpower. In the embodiment of the disclosure, the general code part of the target audit code is set on the preset code template, so that not only can the manpower be greatly reduced, but also the execution efficiency of the code can be improved.
Wherein, the steps of S1410 and S1460 do not distinguish the execution sequence.
In step S1420, obtaining data to be processed input by an auditor through a terminal, and formatting the data to be processed according to a preset grammar rule associated with compliance audit to obtain target processing data conforming to the preset grammar rule; next, S1430 is performed.
In order to facilitate storing and processing of service data, the service in the embodiments of the present disclosure is executed by a corresponding software system, which is a service system of the service. Accordingly, the data of the service may be stored in the corresponding service system. In one embodiment, the data for the service may be stored in a database of the corresponding service system.
In a specific embodiment, the data to be processed may include data required for performing a business operation of the target business.
In practical applications, service operations are performed on data in a target service, and a field to which the data belongs needs to be determined. Thus, in a specific embodiment, the implementation form of the data to be processed may be a field for distinguishing data.
In a specific embodiment, the target service may include one service or at least two services, and the service operation may include a compliance audit operation performed on data in the service system, so as to ensure that the data stored in different locations of the service system, where the fields belong to the same or different data can meet compliance.
Taking the target service as a business management service and taking the business operation of the business management service as a compliance audit operation as an example: in practical applications, if the auditor wishes to conduct compliance audit on at least one data in the business management service and the merchant multi-institution account application form, the data to be processed can be input through a terminal facing the user, including a field of "merchant multi-institution account application form" and at least one attribute of the field, where the at least one attribute can include "merchant multi-institution application form (Identity Document, ID)", "application form ID" and "institution type". Or, the 'merchant multi-mechanism account application form' field and at least one attribute of the field are stored in a corresponding storage unit in advance, and after a control instruction of a user is acquired, data in the storage unit is read according to the control instruction.
In the above embodiment, by acquiring the data to be processed of the target service, execution of the service operation of the target service may be ensured, and conditions may be provided for automatically generating a code for executing the service operation.
In practical applications, the original data to be processed often does not conform to the grammar rule of the code, and accordingly, in the embodiments of the present disclosure, the data to be processed may be converted into target processing data that conforms to the grammar rule (for example, a preset grammar rule) of the code, so as to generate the target audit code based on the target processing data.
Correspondingly, in the embodiment of the disclosure, the data to be processed may be converted according to the preset grammar rule, so as to obtain the target processing data conforming to the preset grammar rule.
In a specific embodiment, the preset grammar rules comprise keywords, entities and operations, and grammar structure relations among the keywords, the entities and the operations; in a specific embodiment, the grammar rules may be set by existing characters or strings in natural, machine, and programming languages.
It can be understood that the preset grammar rule defines a domain-specific language DSL of the target service, and the original data to be processed is formatted through the DSL of the target service.
In a specific embodiment, taking as an example the business operations of the target business include auditing the data compliance of the target business. Wherein the keywords include, but are not limited to, grammar root (root) and entity (entity); including but not limited to entity 1 (entity_1) and entity 2 (entity_2); including but not limited to join operations (units) and join operations (join). Further, the grammatical structural relations among the keywords, entities, and operations may be identified by at least one character including "(", ")", "|", "'", and "{" etc. Based on the preset grammar rule, performing data conversion on the data to be processed to obtain target processing data conforming to the preset grammar rule, which may include: formatting the data to be processed according to keywords, entities, operations and grammar structure relations among the keywords, the entities and the operations defined in a preset grammar rule; and taking the formatted data to be processed as the target processing data.
In the above embodiment, based on the preset grammar rule, the data to be processed which does not conform to the grammar rule of the code is formatted to obtain the target processing data which conforms to the preset grammar rule, and the target audit code can be generated by analyzing the target processing data in the subsequent processing process.
It can be understood that the above-described embodiments achieve the purpose of converting data to be processed that does not conform to the grammar rule of the code into target processing data that conforms to the grammar rule of the code (preset grammar rule).
In an embodiment of the disclosure, the analysis of the target processing data based on the preset grammar rule may include lexical analysis and grammar analysis.
In step S1430, lexical analysis is performed on the target processing data according to the keywords, the entities and the operations corresponding to the preset grammar rule, so as to segment the target processing data to obtain at least one character string; next, S1440 is performed.
In embodiments of the present disclosure, lexical analysis may be performed on compliance audit item DSL. Illustratively, the defined compliance audit item DSL text can be converted into a string of tokens (token), where token is a type of data that contains two main attributes: genre and content.
Wherein, the part of the lexical analysis may include: determining keywords, entities and operations corresponding to the preset grammar rules; according to the corresponding keywords, entities and operations, word segmentation is carried out on the target processing data to obtain at least one character string, and the type of each character string in the at least one character string is determined; the type of the character string is one of a keyword, an entity and an operation.
In the embodiment of the disclosure, the preset grammar rule comprises definitions of keywords, entities and operations; correspondingly, the keywords, entities and operations corresponding to the preset grammar rules comprise keywords, entities and operations defined in the grammar rules.
Specifically, the word segmentation is performed on the target processing data according to the corresponding keyword, entity and operation to obtain at least one character string, and determining the type of each character string in the at least one character string may include: and identifying the keywords, entities and operations existing in the target processing data according to the keywords, entities and operations defined in the grammar rules, and further identifying character strings defined as the keywords, entities or operations according to the existing keywords, entities and operations.
Therefore, the embodiment of the disclosure can realize word segmentation of the target processing data to obtain the at least one character string, and can also realize identification of the type of the at least one character string.
In some embodiments, the content and the type of each character string are correspondingly recorded. For convenience of storage and subsequent processing, the implementation manner of the corresponding record is preferably as follows: the corresponding recording is performed according to the data type of the token.
In step S1440, performing syntax analysis on the target processing data according to the syntax structure relationship among the keywords, the entities and the operations corresponding to the preset syntax rules, so as to construct at least one character string as a target syntax tree; next, S1450 is performed.
In the embodiment of the disclosure, the compliance audit DSL is parsed: constructing the obtained token to obtain an abstract grammar tree according to a preset grammar rule associated with compliance audit; traversing the abstract syntax tree and generating a compliance target audit code in combination with a preset code template associated with compliance audit.
Wherein the parsed portion includes: and constructing the at least one character string into the target grammar tree according to the type of the at least one character string, wherein the target grammar tree represents the association relation between the data to be processed of the target service.
It will be appreciated that in order to construct a target syntax tree, at least one node of the target syntax tree needs to be determined. The node type of the at least one node comprises a root node, a father node and a child node, and the node relationship of the at least one node comprises a father-child node relationship. Based on this, it is necessary to determine which character string of the at least one character string may be a root node, which character string(s) may be a parent node, which character string(s) may be child nodes, and which character strings have a parent-child node relationship therebetween, so that the target syntax tree may be constructed using the at least one character string.
Specifically, the constructing the at least one character string as the target syntax tree according to the type of the at least one character string includes: determining the grammar structure relation among the corresponding keywords, entities and operations; determining the node type and the node relation of the at least one character string according to the grammar structure relation and the type of the at least one character string; and constructing at least one character string into the target grammar tree according to the node type and the node relation of the at least one character string.
In the embodiment of the disclosure, in the process of setting the preset grammar rule, keywords, entities and operations are defined, and grammar structure relations among the keywords, the entities and the operations are also defined. Based on the grammatical structural relationships between the keywords, entities, and operations, it may be determined which fields of a string (e.g., root) may be used as a root node, which fields of a string (e.g., entity and audit item) may be used as children of the root node, which string may in turn be used as a child of one of the children of the root node, and so on.
In the above embodiment, by performing lexical analysis and syntax analysis on the target processing data, at least one character string in the target processing data may be identified, and the at least one character string may be constructed as a target syntax tree, so as to parse the target syntax tree subsequently, and generate at least one code segment. In addition, the at least one character string is constructed as the target grammar tree, so that the association relationship between the at least one character string can be stored while the at least one character string is conveniently stored, and the subsequent data processing is facilitated.
In step S1450, traversing the target syntax tree, compiling at least one character string obtained by traversing by using an SQL statement, and generating at least one code segment; next, S1470 is performed.
In step S1470, determining a form parameter corresponding to the at least one code segment, where the form parameter is set at a location to be filled of a preset code template associated with compliance audit; next, S1480 is performed.
In step S1480, at least one code segment is returned as a parameter value to the corresponding location to be filled in the preset code template by the form parameter, and a compliance audit code (target audit code) is generated.
In an embodiment of the disclosure, the preset code template includes a generic code portion of the target audit code, and further includes at least one location to be filled.
In the embodiment of the disclosure, the target grammar tree is analyzed to generate at least one code segment; determining the position information of the at least one code segment in the preset code template; and transmitting the at least one code segment to the preset code template based on the position information to obtain the target audit code.
In the embodiment of the disclosure, the position information is characterized by a corresponding relationship between at least one code segment and at least one position to be filled in the preset code template; and filling each code segment in the at least one code segment to each position to be filled according to the corresponding relation between the at least one code segment and the at least one position to be filled.
Specifically, the embodiment of the present disclosure may determine the location information by:
setting form parameters for transmitting parameter values in a preset code template, and correspondingly, under the condition of generating at least one code segment, determining the form parameters corresponding to each code segment, and returning the code segment serving as the parameter value of the corresponding form parameter to the corresponding position to be filled in the preset code template.
Secondly, respectively setting identifiers for at least one position to be filled of the preset code template, and correspondingly, under the condition of generating at least one code segment, determining the identifiers corresponding to the code segments so as to realize filling of the preset code template by replacing the identifiers of the position to be filled with the corresponding code segments. In the embodiment of the present disclosure, the identifier is preferably a type of a character string corresponding to the code segment, so as to save data resources.
Thus, the embodiment of the disclosure can automatically generate the target audit code for executing the business operation corresponding to the target business by automatically filling at least one automatically generated code segment into the corresponding position to be filled of the preset code template.
In some embodiments, the method may further comprise: and executing the business operation corresponding to the target business based on the target audit code.
In the embodiment of the disclosure, the target audit code matched with the target service can be automatically generated by filling the to-be-filled position of the preset code template by utilizing at least one code segment obtained by analyzing the target grammar tree in combination with the position information set in the preset code template, so that the automation and the intellectualization of data processing are improved, and compared with the manual code writing, the efficiency of code generation is improved, the accuracy of the code is ensured, and the execution efficiency of the code in practical application is further improved.
Here, the execution of S1410 to S1480 is not limited to the execution described in fig. 14.
In the embodiment of the disclosure, through presetting a preset grammar rule and a preset code template which are related to compliance audit, formatting to-be-audited content by utilizing the preset grammar rule to obtain target processing data conforming to the preset grammar rule, performing lexical analysis on the target processing data based on the preset grammar rule to obtain at least one character string, further performing grammar analysis on the at least one character string based on the preset grammar rule, constructing the at least one character string into a target grammar tree, filling to-be-filled positions of the preset code template by utilizing at least one code segment obtained by analyzing the target grammar tree, and automatically generating compliance audit codes matched with compliance audit service; on the other hand, after the audit item is automatically analyzed, a compliance audit code is automatically generated according to the set compliance code template, audit research and development and writing codes are not needed, automation and intellectualization of data processing are greatly improved, and compared with manual audit code writing, the efficiency of code generation can be improved, the accuracy of the code is ensured, and further the audit efficiency can be improved.
Fig. 15 is a flowchart of another service data processing method according to an embodiment of the present disclosure.
In combination with an application scenario of correctness audit code generation, the embodiment of the present disclosure further provides a service data processing method, as shown in fig. 15, where the method provided by the embodiment of the present disclosure may include the following steps.
In step S1510, a preset grammar rule associated with the correctness audit is preset.
Specifically, the preset grammar rules associated with the correctness audit may include keywords, entities, and operations, and grammar structure relationships between the keywords, entities, and operations, the preset grammar rules being domain-specific language DSL; next, S1560 is performed.
In step S1560, a preset code template associated with the correctness audit is preset; next, S1520 is performed.
Wherein, the steps of S1510 and S1560 do not distinguish the order of execution.
In step S1520, obtaining data to be processed input by an auditor through a terminal, and formatting the data to be processed according to a preset grammar rule associated with correctness audit to obtain target processing data conforming to the preset grammar rule; next, S1530 is performed.
In step S1530, lexical analysis is performed on the target processing data according to the keywords, the entities and the operations corresponding to the preset grammar rule, so as to segment the target processing data to obtain at least one character string; next, S1540 is performed.
In particular, the implementation of the lexical analysis is referred to the related description in the above embodiments, and is not described herein.
In step S1540, the target processing data is parsed according to the syntax structure relationship among the keywords, the entities and the operations corresponding to the preset syntax rules, so as to construct at least one character string as a target syntax tree; next, S1550 is performed.
In particular, the implementation of the syntax analysis is referred to the related description in the above embodiments, and is not repeated herein.
In step S1550, traversing the target syntax tree, compiling at least one character string obtained by traversing by using an SQL statement, and generating at least one code segment; next, S1570 is performed.
In step S1570, a form parameter corresponding to the at least one code segment is determined, where the form parameter is set at a position to be filled in a preset code template associated with correctness audit; next, S1580 is performed.
In step S1580, at least one code segment is returned as a parameter value to a corresponding position to be filled in the preset code template through a form parameter, and a correctness audit code (target audit code) is generated.
Here, the execution process of S1510 to S1580 is not limited to the execution process described in fig. 15.
In the embodiment of the disclosure, through presetting a preset grammar rule and a preset code template which are related to correctness audit, formatting to-be-audited content by utilizing the preset grammar rule to obtain target processing data conforming to the preset grammar rule, performing lexical analysis on the target processing data based on the preset grammar rule to obtain at least one character string, further performing grammar analysis on the at least one character string based on the preset grammar rule, constructing the at least one character string into a target grammar tree, filling to-be-filled positions of the preset code template by utilizing at least one code segment obtained by analyzing the target grammar tree, and automatically generating correctness audit codes matched with correctness audit service; on the other hand, after the audit item is automatically analyzed, a correctness audit code is automatically generated according to the set correctness code template, audit research and development of written codes are not needed, automation and intelligence of data processing are greatly improved, and compared with manual audit code writing, the efficiency of code generation can be improved, the accuracy of the code is ensured, and further the audit efficiency can be improved.
Fig. 16 is a schematic structural diagram of a service data processing device according to an embodiment of the present disclosure.
As shown in fig. 16, the service data processing apparatus 1600 provided by the embodiment of the present disclosure may include a display unit 1610, a determination unit 1620, and a generation unit 1630.
The display unit 1610 may be used to display an editing page, which may include a component bar area and a job area, and in which an entity component may be included.
The display unit 1610 may be further configured to display a business data table to be audited in the job area in response to an operation instruction for the entity component in the component bar area.
The determining unit 1620 may be configured to determine, in response to an operation instruction to the pending-meter service data table in the job area, a pending-meter field in the pending-meter service data table and compliance constraint information or correctness constraint information of the pending-meter field.
The generating unit 1630 may be configured to generate a target audit code according to compliance constraint information or correctness constraint information of a to-be-inspected field in the to-be-inspected service data table, where the target audit code is configured to perform compliance audit on service data corresponding to the to-be-inspected field according to the compliance constraint information, or perform correctness audit on service data corresponding to the to-be-inspected field according to the correctness constraint information.
In an exemplary embodiment, the display unit 1610 may be used to perform the following steps: displaying a first entity component in the operation area in response to an operation instruction for the entity component in the component bar area; and responding to an operation instruction of the first entity component in the working area, and converting the first entity component into the pending-meter service data table.
In an exemplary embodiment, a compliance identification component, a function component, and a table manipulation component may also be included in the component column region. The determining unit 1620 may be configured to perform the steps of: determining a pending field in the pending service data table in response to an operation instruction to the pending service data table in the operation area; responsive to an operation instruction to the compliance identification component in the component bar area, displaying a compliance identification at a first predetermined location of the pending fields; and in response to an operation instruction to the function component and the table operation component in the component bar area, displaying compliance constraint information of the pending fields at a second predetermined location of the compliance identification component.
In an exemplary embodiment, the determining unit 1620 may be further configured to perform the following steps: responding to an operation instruction of the to-be-examined business data table in the operation area, and displaying field information in the to-be-examined business data table in the operation area; and determining a pending meter field in the pending meter service data table in response to an operation instruction for field information in the pending meter service data table displayed in the operation area.
In an exemplary embodiment, a table manipulation component may also be included in the component column area. The determining unit 1620 may be further configured to perform the steps of: and determining a pending meter field in the pending meter service data table in response to an operation instruction of the pending meter service data table in the operation area and an operation instruction of the table operation component in the component column area.
In an exemplary embodiment, the component bar area may further include an associated component. The determining unit 1620 may be further configured to perform the steps of: responsive to an operation instruction to the associated component in the component bar area, displaying a first business data table associated with the review field at a second predetermined location of the compliance identification component; and in response to an operation instruction to the function component in the component column area, displaying compliance constraint information of a first field in the first business data table at a second preset position of the compliance identification component, wherein the compliance constraint information of the pending field comprises the compliance constraint information of the first field.
In an exemplary embodiment, the determining unit 1620 may be further configured to perform the following steps: displaying a second entity component in the operation area in response to an operation instruction for the entity component in the component bar area; responsive to an operation instruction to the second entity component in the working area, converting the second entity component into a second business data table associated with the pending fields; and in response to an operation instruction to the function component in the component column area, displaying compliance constraint information of a second field in the second business data table at a second preset position of the compliance identification component, wherein the compliance constraint information of the pending field comprises the compliance constraint information of the second field.
In an exemplary embodiment, a compliance identification component may also be included in the component bar area. The determining unit 1620 may be further configured to perform the steps of: determining a pending field in the pending service data table in response to an operation instruction to the pending service data table in the operation area; responding to an operation instruction of the compliance identification component in the component column area, displaying a compliance editing sub-page of the to-be-checked field, wherein the compliance editing sub-page comprises an entity selection control, an entity attribute selection control, an operator selection control and an attribute value determination control; and generating compliance constraint information of the to-be-examined field in response to operation instructions of the entity selection control, the entity attribute selection control, the operator selection control and the attribute value determination control.
In an exemplary embodiment, the component column area may further include a table operation component and a function component. The determining unit 1620 may be further configured to perform the steps of: determining a pending field in the pending service data table in response to an operation instruction to the pending service data table in the operation area; displaying a third service data table and a fourth service data table associated with the pending-meter field in the job area; determining operation relation information between a third field in the third service data table and a fourth field in the fourth service data table in response to an operation instruction to the function component, and determining a fifth field in a fifth service data table and corresponding service data thereof according to the operation relation information; and generating correctness constraint information between the to-be-checked field and the fifth field as the correctness constraint information of the to-be-checked field in response to operation instructions of the table operation component and the function component.
The embodiments of the apparatus and the method in the embodiments of the present disclosure are based on the same inventive concept, and detailed descriptions thereof are omitted herein for specific implementation of the embodiments of the apparatus.
The embodiment of the disclosure also provides an electronic device, which comprises a processor and a memory, wherein at least one instruction or at least one section of program is stored in the memory, and the at least one instruction or the at least one section of program is loaded and executed by the processor to realize the business data processing method.
The electronic device and the method embodiments in the embodiments of the present disclosure are based on the same inventive concept, and detailed description is omitted herein for how the electronic device embodiments are specifically implemented.
The method embodiments provided by the embodiments of the present disclosure may be performed in a mobile terminal, a computer terminal, a server, or similar computing device. Taking the operation on the terminal as an example, fig. 17 is a block diagram of a hardware structure of a terminal for implementing a service data processing method according to an embodiment of the disclosure. As shown in fig. 17, the terminal 1700 may vary considerably in configuration or performance, and may include one or more central processing units (Central Processing Units, CPU) 1710 (the processor 1710 may include, but is not limited to, a microprocessor MCU or a processing device such as a programmable logic device FPGA), a memory 1730 for storing data, one or more storage mediums 1720 (e.g., one or more mass storage devices) for storing applications 1723 or data 1722. Wherein memory 1730 and storage medium 1720 may be transitory or persistent storage. The program stored in the storage medium 1720 may include one or more modules, each of which may include a series of instruction operations in the terminal. Still further, the central processor 1710 may be configured to communicate with a storage medium 1720 to execute a series of instruction operations in the storage medium 1720 on the terminal 1700. Terminal 1700 can also include one or more power supplies 1760, one or more wired or wireless network interfaces 1750, one or more input/output interfaces 1740, and/or one or more operating systems 1721.
Input-output interface 1740 may be used to receive or transmit data via a network. The above-described network specific examples may include a wireless network provided by a communication provider of the terminal 1700. In one example, the input output interface 1740 includes a network adapter (Network Interface Controller, NIC) that may connect to other network devices through a base station to communicate with the internet. In one example, the input output interface 1740 may be a Radio Frequency (RF) module for communicating with the internet wirelessly.
It will be appreciated by those of ordinary skill in the art that the configuration shown in fig. 17 is merely illustrative and is not intended to limit the configuration of the electronic device described above. For example, terminal 1700 may also include more or fewer components than shown in fig. 17, or have a different configuration than shown in fig. 17.
The embodiment of the disclosure also provides a computer readable storage medium, in which at least one instruction or at least one program is stored, and the at least one instruction or the at least one program is loaded and executed by a processor to implement the foregoing service data processing method.
According to one aspect of the present disclosure, there is provided a computer program product or computer program comprising computer instructions stored in a computer readable storage medium. The computer instructions are read from the computer-readable storage medium by a processor of a computer device, and executed by the processor, cause the computer device to perform the methods provided in the various alternative implementations described above.
Alternatively, in the present embodiment, the above-described computer-readable storage medium may be located in at least one network server among a plurality of network servers of the computer network. Alternatively, in the present embodiment, the above-described computer-readable storage medium may include, but is not limited to: a U-disk, a Read-Only Memory (ROM), a random access Memory (RAM, random Access Memory), a removable hard disk, a magnetic disk, or an optical disk, or other various media capable of storing program codes.
It should be noted that: the foregoing sequence of the embodiments of the present disclosure is merely for description and does not represent the advantages or disadvantages of the embodiments. And the foregoing description has been directed to specific embodiments of this specification. Other embodiments are within the scope of the following claims. In some cases, the actions or steps recited in the claims can be performed in a different order than in the embodiments and still achieve desirable results. In addition, the processes depicted in the accompanying figures do not necessarily require the particular order shown, or sequential order, to achieve desirable results. In some embodiments, multitasking and parallel processing are also possible or may be advantageous.
In this specification, each embodiment is described in a progressive manner, and identical and similar parts of each embodiment are all referred to each other, and each embodiment mainly describes differences from other embodiments. In particular, for the device embodiments, since they are substantially similar to the method embodiments, the description is relatively simple, and reference is made to the description of the method embodiments in part.
It will be understood by those skilled in the art that all or part of the steps for implementing the above embodiments may be implemented by hardware, or may be implemented by a program for instructing relevant hardware, where the program may be stored in a computer readable storage medium, and the storage medium may be a read-only memory, a magnetic disk or an optical disk, etc.

Claims (13)

1. A method for processing service data, the method comprising:
displaying an editing page, wherein the editing page comprises a component column area and a working area, and the component column area comprises an entity component;
responding to an operation instruction of the entity component in the component column area, and displaying a business data table to be audited in the operation area;
determining a to-be-checked field in the to-be-checked business data table and compliance constraint information or correctness constraint information of the to-be-checked field in response to an operation instruction of the to-be-checked business data table in the operation area;
generating a target audit code according to compliance constraint information or correctness constraint information of the to-be-checked fields in the to-be-checked business data table, wherein the target audit code is used for carrying out compliance audit on business data corresponding to the to-be-checked fields according to the compliance constraint information or carrying out correctness audit on the business data corresponding to the to-be-checked fields according to the correctness constraint information.
2. The method of claim 1, wherein displaying a business data sheet to be audited in the job area in response to an operation instruction to the entity component in the component bar area comprises:
displaying a first entity component in the operation area in response to an operation instruction for the entity component in the component bar area;
and responding to an operation instruction of the first entity component in the working area, and converting the first entity component into the pending-meter service data table.
3. The method of claim 1, wherein the component bar area further comprises a compliance identification component, a function component, and a table manipulation component;
determining a pending field in the pending service data table and compliance constraint information of the pending field in response to an operation instruction to the pending service data table in the job area, including:
determining a pending field in the pending service data table in response to an operation instruction to the pending service data table in the operation area;
responsive to an operation instruction to the compliance identification component in the component bar area, displaying a compliance identification at a first predetermined location of the pending fields;
And in response to an operation instruction to the function component and the table operation component in the component bar area, displaying compliance constraint information of the pending fields at a second predetermined location of the compliance identification component.
4. The method of claim 3, wherein determining a review field in the review business data table in response to an operation instruction to the review business data table in the job area comprises:
responding to an operation instruction of the to-be-examined business data table in the operation area, and displaying field information in the to-be-examined business data table in the operation area;
and determining a pending meter field in the pending meter service data table in response to an operation instruction for field information in the pending meter service data table displayed in the operation area.
5. The method of claim 3, further comprising a table manipulation component in the component column area;
determining a pending field in the pending service data table in response to an operation instruction to the pending service data table in the job area, including:
and determining a pending meter field in the pending meter service data table in response to an operation instruction of the pending meter service data table in the operation area and an operation instruction of the table operation component in the component column area.
6. The method of claim 3, further comprising associating components in the component bar area;
in response to an operation instruction to the function component in the component bar area, displaying compliance constraint information of the pending fields at a second predetermined location of the compliance identification component, comprising:
responsive to an operation instruction to the associated component in the component bar area, displaying a first business data table associated with the review field at a second predetermined location of the compliance identification component;
and in response to an operation instruction to the function component in the component column area, displaying compliance constraint information of a first field in the first business data table at a second preset position of the compliance identification component, wherein the compliance constraint information of the pending field comprises the compliance constraint information of the first field.
7. The method of claim 3, wherein displaying compliance constraint information of the censored field at a second predetermined location of the compliance identification component in response to an operation instruction to the function component in the component bar area comprises:
Displaying a second entity component in the operation area in response to an operation instruction for the entity component in the component bar area;
responsive to an operation instruction to the second entity component in the working area, converting the second entity component into a second business data table associated with the pending fields;
and in response to an operation instruction to the function component in the component column area, displaying compliance constraint information of a second field in the second business data table at a second preset position of the compliance identification component, wherein the compliance constraint information of the pending field comprises the compliance constraint information of the second field.
8. The method of claim 1, further comprising a compliance identification component in the component bar area;
determining a pending field in the pending service data table and compliance constraint information of the pending field in response to an operation instruction to the pending service data table in the job area, including:
determining a pending field in the pending service data table in response to an operation instruction to the pending service data table in the operation area;
Responding to an operation instruction of the compliance identification component in the component column area, displaying a compliance editing sub-page of the to-be-checked field, wherein the compliance editing sub-page comprises an entity selection control, an entity attribute selection control, an operator selection control and an attribute value determination control;
and generating compliance constraint information of the to-be-examined field in response to operation instructions of the entity selection control, the entity attribute selection control, the operator selection control and the attribute value determination control.
9. The method of claim 1, wherein the component bar area further comprises a table manipulation component and a function component;
determining a pending field in the pending service data table and correctness constraint information of the pending field in the pending service data table in response to an operation instruction to the pending service data table in the operation area, including:
determining a pending field in the pending service data table in response to an operation instruction to the pending service data table in the operation area;
displaying a third service data table and a fourth service data table associated with the pending-meter field in the job area;
Determining operation relation information between a third field in the third service data table and a fourth field in the fourth service data table in response to an operation instruction to the function component, and determining a fifth field in a fifth service data table and corresponding service data thereof according to the operation relation information;
and generating correctness constraint information between the to-be-checked field and the fifth field as the correctness constraint information of the to-be-checked field in response to operation instructions of the table operation component and the function component.
10. A traffic data processing apparatus, the apparatus comprising:
the display unit is used for displaying an editing page, wherein the editing page comprises a component column area and a working area, and the component column area comprises an entity component;
the display unit is also used for responding to the operation instruction of the entity component in the component column area and displaying a business data table to be audited in the operation area;
a determining unit, configured to determine a to-be-examined field in the to-be-examined service data table and compliance constraint information or correctness constraint information of the to-be-examined field in response to an operation instruction to the to-be-examined service data table in the operation area;
The generating unit is used for generating a target audit code according to compliance constraint information or correctness constraint information of the to-be-checked fields in the to-be-checked business data table, wherein the target audit code is used for conducting compliance audit on business data corresponding to the to-be-checked fields according to the compliance constraint information or conducting correctness audit on the business data corresponding to the to-be-checked fields according to the correctness constraint information.
11. An electronic device comprising a processor and a memory having at least one instruction or at least one program stored therein, the at least one instruction or the at least one program being loaded and executed by the processor to implement the method of any one of claims 1 to 9.
12. A computer readable storage medium having stored therein at least one instruction or at least one program, the at least one instruction or the at least one program being loaded and executed by a processor to implement the method of any one of claims 1 to 9.
13. A computer program product comprising computer instructions which, when executed by a processor, implement the method of any of claims 1 to 9.
CN202111463712.3A 2021-12-02 2021-12-02 Service data processing method, device, equipment, medium and product Pending CN116225439A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202111463712.3A CN116225439A (en) 2021-12-02 2021-12-02 Service data processing method, device, equipment, medium and product

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202111463712.3A CN116225439A (en) 2021-12-02 2021-12-02 Service data processing method, device, equipment, medium and product

Publications (1)

Publication Number Publication Date
CN116225439A true CN116225439A (en) 2023-06-06

Family

ID=86579169

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202111463712.3A Pending CN116225439A (en) 2021-12-02 2021-12-02 Service data processing method, device, equipment, medium and product

Country Status (1)

Country Link
CN (1) CN116225439A (en)

Similar Documents

Publication Publication Date Title
US11429600B2 (en) Loading queries using search points
US11562025B2 (en) Resource dependency system and graphical user interface
US10762142B2 (en) User-defined automated document feature extraction and optimization
US11954427B2 (en) Transformation in tabular data cleaning tool
CN105723335A (en) Data flow exploration
WO2019178403A1 (en) User-defined automated document feature modeling, extraction and optimization
US8533140B2 (en) Method and system for design check knowledge construction
CN111444256A (en) Method and device for realizing data visualization
US20150032743A1 (en) Analyzing files using big data tools
CN110990403A (en) Business data storage method, system, computer equipment and storage medium
CN114443854A (en) Processing method and device of multi-source heterogeneous data, computer equipment and storage medium
KR102187322B1 (en) System for business rule management
US20150051929A1 (en) Ad hoc reporting with smart lists
US11308103B2 (en) Data analyzing device and data analyzing method
KR20170043365A (en) Important precedents extraction and sorting method using Big Data
Yang et al. User story clustering in agile development: a framework and an empirical study
KR102217937B1 (en) System for business rule management
US20150066985A1 (en) Retrieving information from social media sites based upon events in an enterprise
JP7022472B1 (en) Data management system, data management method and data management program
CN116225439A (en) Service data processing method, device, equipment, medium and product
US20130218893A1 (en) Executing in-database data mining processes
KR102150911B1 (en) System for business rule management
KR102187321B1 (en) System for business rule management
US9582782B2 (en) Discovering a reporting model from an existing reporting environment
CN111563178A (en) Rule logic diagram comparison method, device, medium and electronic equipment

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination