CN115470266A - Data processing method and related equipment - Google Patents

Data processing method and related equipment Download PDF

Info

Publication number
CN115470266A
CN115470266A CN202211110477.6A CN202211110477A CN115470266A CN 115470266 A CN115470266 A CN 115470266A CN 202211110477 A CN202211110477 A CN 202211110477A CN 115470266 A CN115470266 A CN 115470266A
Authority
CN
China
Prior art keywords
data
target
service data
preprocessed
service
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
CN202211110477.6A
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.)
CMB Yunchuang Information Technology Co Ltd
Original Assignee
CMB Yunchuang Information Technology 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 CMB Yunchuang Information Technology Co Ltd filed Critical CMB Yunchuang Information Technology Co Ltd
Priority to CN202211110477.6A priority Critical patent/CN115470266A/en
Publication of CN115470266A publication Critical patent/CN115470266A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • 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/24Querying
    • G06F16/245Query processing
    • G06F16/2458Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
    • G06F16/2462Approximate or statistical queries
    • 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/24Querying
    • G06F16/242Query formulation
    • 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/24Querying
    • G06F16/248Presentation of query results

Landscapes

  • Engineering & Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Theoretical Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Databases & Information Systems (AREA)
  • General Engineering & Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Computational Linguistics (AREA)
  • Probability & Statistics with Applications (AREA)
  • Mathematical Physics (AREA)
  • Fuzzy Systems (AREA)
  • Software Systems (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The embodiment of the application provides a data processing method, which is used for effectively summarizing and counting business data, so that the business requirements of users are met. The method in the embodiment of the application comprises the following steps: acquiring preprocessing service data, wherein the preprocessing service data comprises service data of different attribute categories; displaying the preprocessed service data corresponding to the target query condition to a user according to the target query condition, and determining the preprocessed service data as target service data; and summarizing the target business data according to the target query condition so that the target user can export the target business data.

Description

Data processing method and related equipment
Technical Field
The embodiment of the application relates to the field of data processing, in particular to a data processing method and related equipment.
Background
With the high-speed development of the internet system, online payment becomes daily life, a payer can realize convenient payment of multiple platforms through aggregation of collection codes, and a user can also realize unified collection of different platforms through aggregation of collection.
However, different platforms such as WeChat and Paibao have exclusive two-dimensional code for payment collection. For enterprises, if payments of different platforms need to be supported, payment two-dimensional codes of different platforms need to be displayed for payers. The collection platforms are various and complex, meanwhile, transactions generated by different platforms are inconvenient to manage, data aggregation and statistics are not clear, and the service requirements of users cannot be effectively met, so that the user experience is poor.
Disclosure of Invention
The embodiment of the application provides a data processing method, which is used for effectively summarizing and counting business data, so that the business requirements of users are met.
A first aspect of an embodiment of the present application provides a data processing method, including:
acquiring preprocessing service data, wherein the preprocessing service data comprises service data of different attribute categories;
displaying the preprocessed service data corresponding to the target query condition to a user according to the target query condition, and determining the preprocessed service data as target service data;
and summarizing the target business data according to the target query condition so that the target user can export the target business data.
Optionally, the acquiring the pre-processing service data includes:
acquiring a plurality of attribute categories and to-be-processed service data corresponding to each attribute category in a target type file;
and respectively converting the service data to be processed according to different attribute categories to obtain the preprocessed service data.
Optionally, after the pre-processing service data is obtained, before the pre-processing service data corresponding to the target query condition is displayed to a user according to a target query condition to determine that the pre-processing service data is the target service data, the method further includes:
and storing the preprocessed service data into a database.
Optionally, the storing the preprocessed business data into a database includes:
storing part of the preprocessed service data into the database;
and/or performing service processing on the other part of the preprocessed service data to store the preprocessed service data subjected to the service processing into the database.
Optionally, the performing service processing on another part of the preprocessed service data includes:
calling service data associated with the other part of the preprocessed service data according to the attribute category of the other part of the preprocessed service data so as to complete the other part of the preprocessed service data;
and/or, counting the other part of the preprocessed service data.
Optionally, the displaying, to the user according to the target query condition, the preprocessed service data corresponding to the target query condition includes:
receiving selection results of the target user for different query conditions to determine the target query conditions;
screening the preprocessed service data according to the target query condition to determine the target service data;
and displaying the target service data to the target user.
Alternatively, the first and second liquid crystal display panels may be,
the attribute category comprises transaction type, transaction amount, transaction quantity or transaction time;
the target query condition comprises a payment mode, a bill type or a merchant number.
A second aspect of the embodiments of the present application provides a data processing system, including:
the device comprises an acquisition unit, a processing unit and a processing unit, wherein the acquisition unit is used for acquiring preprocessing service data which comprises service data of different attribute categories;
the display unit is used for displaying the preprocessed service data corresponding to the target query condition to a user according to the target query condition and determining the preprocessed service data as target service data;
and the summarizing unit is used for summarizing the target business data according to the target query condition so as to lead the target user to export the target business data.
Optionally, the data processing system comprises: a conversion unit;
the acquiring unit is specifically configured to acquire a plurality of attribute categories in the target type file and to-be-processed service data corresponding to each attribute category;
and the conversion unit is used for respectively converting the service data to be processed according to different attribute types so as to acquire the preprocessed service data.
Optionally, the data processing system further comprises: a storage unit;
and the storage unit is used for storing the preprocessed service data into a database.
Optionally, the data processing system comprises: a processing unit;
the storage unit is specifically configured to store a part of the preprocessed service data into the database;
and/or the processing unit is used for carrying out service processing on the other part of the preprocessed service data so as to store the preprocessed service data subjected to service processing into the database.
Optionally, the data processing system comprises: a calling unit and a statistical unit;
the calling unit is used for calling the service data which is associated with the other part of the preprocessed service data according to the attribute type of the other part of the preprocessed service data so as to complete the other part of the preprocessed service data;
and/or the statistical unit is used for carrying out statistics on the other part of the preprocessed service data.
Optionally, the data processing system comprises: a receiving unit and a screening unit;
the receiving unit is used for receiving the selection results of the target user for different query conditions to determine the target query conditions;
the screening unit is used for screening the preprocessed business data according to the target query condition so as to determine the target business data;
the display unit is specifically configured to display the target service data to the target user.
Alternatively,
the attribute category comprises transaction type, transaction amount, transaction quantity or transaction time;
the target query condition comprises a payment mode, a bill type or a merchant number.
According to a second aspect of the embodiments of the present application, there is provided a method for performing the data processing method according to the first aspect.
A third aspect of the embodiments of the present application provides a data processing apparatus, including:
the system comprises a central processing unit, a memory, an input/output interface, a wired or wireless network interface and a power supply;
the memory is a transient memory or a persistent memory;
the central processor is configured to communicate with the memory and execute the operations of the instructions in the memory to perform the data processing method of the first aspect.
A fourth aspect of the embodiments of the present application provides a computer-readable storage medium, where the computer-readable storage medium includes instructions that, when executed on a computer, cause the computer to execute the data processing method according to the first aspect.
According to the technical scheme, the embodiment of the application has the following advantages:
according to the data processing method provided by the embodiment of the application, the preprocessed service data are obtained, wherein the preprocessed service data comprise service data of different attribute categories; then, displaying the preprocessed service data corresponding to the target query condition to a target user according to the target query condition, and determining the preprocessed service data as the target service data; and finally, summarizing the target service data according to the target query condition so that the target user can export the target service data. Therefore, the service data of the multiple payment platforms only need to be summarized or processed in one management system, and users can conveniently inquire or manage the service data of the multiple platforms.
Drawings
In order to more clearly illustrate the technical solutions in the embodiments of the present application, the drawings required to be used in the description of the embodiments are briefly introduced below, and it is obvious that the drawings in the following description are only some embodiments described in the present application, and other drawings can be obtained by those skilled in the art according to these drawings.
Fig. 1 is a schematic architecture diagram of a cross-bank cash management platform system disclosed in an embodiment of the present application;
fig. 2 is a schematic flowchart of a data processing method disclosed in an embodiment of the present application;
FIG. 3 is a schematic flow chart diagram of another data processing method disclosed in the embodiments of the present application;
FIG. 4 is a schematic diagram of an aggregate collection pipeline query as disclosed in an embodiment of the present application;
FIG. 5 is a billing statistics chart disclosed in an embodiment of the present application;
FIG. 6 is a block diagram of a data processing system according to an embodiment of the present disclosure;
fig. 7 is a schematic structural diagram of a data processing apparatus according to an embodiment of the present application.
Detailed Description
With the high-speed development of the internet system, online payment becomes daily life, a payer can realize convenient payment of multiple platforms through aggregation of collection codes, and a user can also realize unified collection of different platforms through aggregation of collection.
However, different platforms such as WeChat and Payment treasures all have a collection two-dimensional code which is exclusive to the platforms. If the enterprises need to support payment of different platforms, the customers need to be shown with the payment two-dimensional codes of different platforms. The collection platforms are many and complicated, the transaction management generated by different platforms is inconvenient, and the data aggregation and statistics are unclear. Moreover, the existing system of the enterprise needs to be docked with a multi-party platform, the docking is complex, and the docking cost is high.
Specifically, the enterprise legacy system requires multiple different payment systems to be interfaced to aggregate all transaction data. Meanwhile, transaction data structures of different payment systems are different, the existing system is complicated in data connection, and data aggregation and data processing difficulty is high.
Therefore, the embodiment of the application provides a data processing method, which is used for effectively summarizing and counting business data, so that the business requirements of enterprise users are met.
The technical solutions in the embodiments of the present application will be described clearly and completely with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only some embodiments of the present application, and not all embodiments. All other embodiments obtained by a person of ordinary skill in the art based on the embodiments in the present application without making any creative effort belong to the protection scope of the present application.
Referring to fig. 1, fig. 1 is a schematic diagram of a system architecture for enterprise financing according to an embodiment of the present application. Including a server 101 and a terminal 102.
As shown in fig. 1, the system architecture may include a server 101 and a terminal 102. Terminal 102 may be a laptop, desktop, mobile terminal, \8230; \8230, etc. The server 101 may be an independent physical server, a server cluster or a distributed system formed by a plurality of physical servers, or a cloud server providing basic cloud computing services such as a cloud database, a cloud service, cloud computing, a cloud function, cloud storage, a network service, cloud communication, middleware service, a domain name service, a security service, a CDN, a big data and artificial intelligence platform, and the like. The terminal 102 may also be a smart phone, a tablet computer, a palm computer, a Mobile Internet Device (MID), a wearable device (e.g., a smart watch, a smart bracelet, etc.), a smart computer, a smart vehicle-mounted smart terminal, and the like. The server 101 and the terminal 102 can establish a communication connection therebetween. In other words, the server 101 may establish a communication connection with the terminal 102. The communication connection is not limited to a connection manner, and may be directly or indirectly connected through a wired communication manner, or may be directly or indirectly connected through a wireless communication manner, and the like, which may be determined according to an actual application scenario, and the present application is not limited herein.
It should be understood that different systems or software may be installed or installed on the terminal 102 or the server 101 in the present application. For example, the server 101 may host a band-to-bank cash management platform system (CBS). Specifically, the cross-bank cash management platform system can be interfaced with a user through the terminal 102, and can also be interfaced with a financial institution. The user generally refers to a user interfacing with the CBS system, and includes but is not limited to an individual user, a small business, and the like. It will be understood that the user is the target user mentioned in the above section, and for convenience of description, the following description of the target user is described in terms of CBS user. Specifically, after the cross-bank cash management platform system is in butt joint with the CBS user, that is, after the CBS user accesses the recruit aggregate collection service, the relevant transaction data of collection initiated by the recruit aggregate collection service is synchronized to the head office system. The CBS system can synchronously and relatively aggregate the collection transaction data from the head office of the business organization at regular time, and the data is finally input into the CBS database after data analysis and data processing of the CBS system, so that the CBS user can perform operations such as data query, data export, data aggregation and the like aiming at the data, and the business requirements of the CBS user can be met.
It should be noted that, in the embodiment of the present application, a specific connection manner between the server 101 and the terminal 102 is not limited, and details of this connection are not described further below.
Referring to fig. 2, fig. 2 is a schematic flowchart of a data processing method according to an embodiment of the present disclosure. Comprising step 201 to step 203.
201. And acquiring the preprocessed service data.
As can be understood from fig. 1, the embodiment is mainly applied to a CBS system, but it should be noted that the CBS system is only a specific application scenario in the embodiment of the present application, but not that the embodiment is only applicable to the CBS system, and may also be applied to other financial systems, and details are not described here. For convenience of description, the embodiment will be described in detail only with the CBS system.
After the CBS system acquires the transaction data sent by the server, all the transaction data are analyzed or analyzed, so that all the transaction data are classified according to different attribute information, and thus, the service data with different attribute information can be obtained.
It should be noted that the attribute information may be understood as the attribute type described in the above section, and for convenience of description, the description thereof is not repeated in the following. It should also be noted that the preprocessed data are the preprocessed service data described in the foregoing section, and for convenience of description, the description thereof is not repeated in the following.
202. And displaying the preprocessed service data corresponding to the target query condition to a target user according to the target query condition, and determining the preprocessed service data as the target service data.
After the preprocessed service data is obtained, that is, after the preprocessed data is obtained, the data can be basically used in the CBS system directly, and then the background service module in the CBS system can store the preprocessed data in the CBS database, so that the CBS user can conveniently inquire the data. It is understood that the CBS user is the target user described in the above section, and for convenience of description, the following description of the target user is described in detail with the CBS user.
Specifically, CBS users can query for the data they want from different dimensions. The CBS user may select a dimension that the CBS user wants to select on the front-end interface of the CBS system to view the corresponding preprocessed data, and it should be noted that the dimension may be understood as a query condition, that is, the CBS user may select different query conditions on the front-end interface of the CBS system, so as to query the corresponding preprocessed data according to the selected query condition. It is understood that the query condition selected by the CBS user is the target query condition.
When the front-end interface of the CBS system displays the corresponding data, it can be determined that the data at this time is the target service data.
203. And summarizing the target business data according to the target query conditions so as to lead the target user to export the target business data.
When the CBS user inquires the target service data according to the target inquiry condition, the service data which the CBS user wants can be exported.
Specifically, after the CBS system screens out the target service data according to the target query condition selected by the CBS user, the summary sum statistics may be performed according to some dimensions, and correspondingly, the summary sum statistics may be performed according to the target query condition. And finally, after the target service data is summarized and counted, the target service data can be exported from the CBS system according to the requirements of the CBS user, so that the CBS user can obtain the target service data which the CBS user wants to obtain.
According to the data processing method provided by the embodiment, the preprocessed service data are obtained, wherein the preprocessed service data comprise service data of different attribute categories; then, displaying the preprocessed service data corresponding to the target query condition to a target user according to the target query condition, and determining the preprocessed service data as the target service data; and finally, summarizing the target business data according to the target query condition so as to lead the target user to export the target business data. Therefore, the service data of the multiple payment platforms only need to be summarized or processed in one management system, and users can conveniently inquire or manage the service data of the multiple platforms.
To facilitate a detailed description of a data processing method provided in the embodiment of the present application, please refer to fig. 3, where fig. 3 is a schematic flow chart of another data processing method disclosed in the embodiment of the present application. Comprising step 301-step 307.
301. And acquiring a plurality of attribute categories and to-be-processed service data corresponding to each attribute category in the target type file.
As can be understood from fig. 1, the embodiment is mainly applied to a CBS system, but it should be noted that the CBS system is only a specific application scenario in the embodiment of the present application, but not that the embodiment is only applicable to the CBS system, and may also be applied to other financial systems, and details are not described here. For convenience of description, the embodiment will be described in detail only with the CBS system.
In this embodiment, the CBS system may obtain the target type file by calling a data connection interface of the head office system. After the target type file is obtained, a background service module of the CBS system can identify the number of the sheet pages in the file. It will be appreciated that a sheet page is a table displayed in a workbook window.
Then, the CBS system parses the data in all the sheet pages in the file one by one. It is understood that the above data is to-be-processed service data, and for convenience of description, details of the data are not described later.
It should be noted that each sheet page has X rows and Y columns of data, where X and Y are positive integers greater than or equal to 1. The CBS system may read each row of data for each sheet page in a round-robin fashion. After reading the data of each row, the background service module of the CBS system reads the data of each column by column. Each row of data represents a complete service detail, and each column of data is a different attribute of the detail. It is understood that the different attributes are different attribute categories described above, and for convenience of description, the description thereof is omitted in the following.
In one embodiment, the file type in the target type file may be an xlsx, xls, or et type file. It should be understood that the file type of the file is not limited in this embodiment, and is not described in detail in the following.
In another embodiment, the attribute categories may be attributes of transaction type, amount, quantity, or time. It should be understood that the attribute type of the service data is not limited in this embodiment, and is not described in detail later.
302. And respectively converting the service data to be processed according to different attribute categories to acquire the preprocessed service data.
After each attribute in a complete service detail is acquired, all attribute information of the service detail needs to be converted by a CBS system background, so that service data to be processed is converted into preprocessed service data, and the preprocessed service data can be persisted to a CBS database or used by subsequent processing logic correspondingly. It should be noted that the CBS database is the database described above, and for convenience of description, the CBS database is described in detail later.
In one embodiment, service details with different attribute information may be converted in different ways. Specifically, for example, chinese name information read from excel needs to be converted into a character set before being stored in the CBS database. Correspondingly, the date information also needs to be identified and then converted into a fixed format, for example, the fixed format may be yyyy-MM-dd HH: MM: ss, wherein yyyy is year, MM is month, dd is date, HH is hours, MM is minutes, and ss is seconds. The amount information may be stored in BigDecimal format for the reserved precision. It should be noted that BigDecimal is used to perform precise operation on numbers with more than 16 significant bits.
It should also be noted that, only the service data of a few specific attribute types are described above, and the service data with other attribute types may also be converted by other conversion methods, which is not described herein in detail.
It will be appreciated that the information so converted is referred to as preprocessed data, which can be persisted to a database or used by subsequent processing logic.
303. And storing part of the preprocessed service data into a database.
The preprocessed data may not be able to be persisted directly to the CBS database as data that can be used directly. However, for part of the preprocessed service data, the CBS database may be directly stored.
304. And performing service processing on the other part of the preprocessed service data so as to store the preprocessed service data subjected to the service processing into the database.
The preprocessed data may not be able to be persisted directly to the CBS database as data that can be used directly. In step 303, since part of the preprocessed service data is already stored in the CBS database, another part of the preprocessed service data needs to be processed by the service logic to become service data that can be used by the CBS system.
In one embodiment, there are at least two ways to process traffic data. Specifically, for example, for the customer information, since the original data synchronized from the head office system, that is, the service data to be processed, may only have the customer number, the customer name and other customer affiliated information need to be obtained by calling other modules of the CBS system. Correspondingly, the scene may also be understood as a data completion scene, and the specific name of the specific processing manner or the specific execution manner is not limited herein, and is not further described in the following.
Another service processing method is statistical processing. Specifically, because information such as the transaction amount summary, the transaction number summary, the business turnover summary in different payment manners, the business turnover in the current day, and the like in the CBS system is processed and counted by background logic, part of the statistical information may be generated in advance, and the business processing manner is referred to as a statistical processing manner.
Finally, the preprocessed service data after preprocessing and service processing (e.g., data completion, statistical processing, etc.) can be stored in the CBS database. It should be understood that all the service data are basically the service data that can be directly used in the CBS system, and then the background service module in the CBS system can store the processed service data in a database.
305. And receiving the selection results of the target user for different query conditions to determine the target query conditions.
After the preprocessed service data is obtained, that is, after the preprocessed data is obtained, the data can be basically used in the CBS system directly, and then the background service module in the CBS system can store the preprocessed data in the CBS database, so that the CBS user can conveniently inquire the data. It is understood that the CBS user is the target user described in the above section, and for convenience of description, the following description of the target user is described in detail with the CBS user.
CBS users can query their desired business data from different dimensions through a front-end interface in the CBS system. It should be understood that, in the embodiment, the different dimensions, i.e., the different query conditions, are described, and after the CBS user selects at least one query condition, the CBS system may receive a selection result of the CBS user on the query condition. For convenience of description, the meaning of the query condition and the dimension is not described in detail later.
In one embodiment, the CBS user may query the pre-processed service data in a manner of querying according to a payment manner, querying according to a bill type, or querying according to a merchant number, where the payment manner, the bill type, or the merchant number is a target query condition. It should be noted that, the present embodiment does not limit the specific content of the query condition, and is not further described in the following.
In another implementation, referring to fig. 4, fig. 4 is a schematic diagram of an aggregate collection flow query according to an embodiment of the present disclosure. As can be seen from fig. 4, the inquiry conditions include a merchant number, time date (start date and end date), bill type or merchant order number, and the like. The CBS user can query the business data desired by the CBS user from multiple dimensions, for example, in the list item screening, the CBS user can select all query conditions, so that the CBS system can receive the selection result of the CBS user for different query conditions, wherein the selection result is a full selection.
306. And screening the preprocessed service data according to the target query condition to determine target service data, and displaying the target service data to a target user.
After the CBS system receives the selection results of the CBS user for the different query conditions, that is, the target query conditions, the CBS system may screen the preprocessed service data stored in the CBS database according to the target query conditions, so as to determine the service data required by the CBS user, where the service data is the target service data. Correspondingly, the front-end interface of the CBS system may display the target service data.
307. And summarizing the target service data according to the target query condition so that the target user can export the target service data.
After the CBS user inquires the target service data according to the target inquiry condition, the CBS user can select to export the target service data.
In one embodiment, the target service data may also be summarized and counted in some dimensions, and correspondingly, the summarized and counted may be understood to be summarized and counted according to the target query condition selected by the CBS user.
Specifically, referring to fig. 5, fig. 5 is a bill statistical chart disclosed in the embodiment of the present application. In one of the exporting methods, the exporting is performed in the form of excel table. Correspondingly, the excel table mainly comprises three blocks, a bill summary, bill statistics and transaction details.
Correspondingly, in the bill summary, four large contents are contained. Respectively, the bill type, merchant number, merchant name and reconciliation scope.
In the bill statistics, five contents are included. The transaction type, transaction count, transaction amount, commission fee, and settlement amount, respectively.
In the detailed transaction, eight contents are included, namely, a merchant number, a merchant name, a free order number, a bank serial number, a third party order number, a payment mode, a transaction type and a transaction currency.
It should be understood that the above-mentioned contents may all be included in the service data, and are not limited thereto, and correspondingly, the contents included in each tile may also be modified or adjusted according to the query condition of the CBS user, and are not limited thereto.
In summary, it can be understood that, after accessing the aggregate collection service or the aggregate collection function, the CBS user may transmit the transaction data of the collection initiated by the consumer to the head office system of the financial institution through the aggregate collection service or the aggregate collection function. The CBS system may then set a time, timed, from the head office system to synchronize the relevant aggregated collected transaction data. When the head office system transmits the transaction data to the CBS system, the CBS system can analyze and uniformly process the transaction data and finally input the transaction data into the CBS database, so that CBS users can perform operations such as data query, data export or data aggregation in the CBS database according to different dimensions to meet self business requirements.
By the data processing method provided by the embodiment, based on the CBS system, for a CBS client who has accessed the aggregated payment service and has already docked a related payment system, an existing system (such as the CBS system) used by the user does not need to dock a plurality of payment platforms, and query, management and aggregation of multi-platform payment service data can be realized only by docking the CBS system. Therefore, unified query, management and data aggregation of the multi-platform payment transaction data in the CBS can be realized, the service requirements of users are effectively met, the user experience is improved, and meanwhile, the production cost of the users is correspondingly reduced.
It should be understood that, although the steps in the flowcharts related to the embodiments as described above are sequentially displayed as indicated by arrows, the steps are not necessarily performed sequentially as indicated by the arrows. The steps are not performed in the exact order shown and described, and may be performed in other orders, unless explicitly stated otherwise. Moreover, at least a part of the steps in the flowcharts related to the embodiments described above may include multiple steps or multiple stages, which are not necessarily performed at the same time, but may be performed at different times, and the execution order of the steps or stages is not necessarily sequential, but may be performed alternately or alternately with other steps or at least a part of the steps or stages in other steps.
If the scenario involves sensitive data (e.g., user data, enterprise data), it should be noted that the collection, use, and handling of sensitive data requires compliance with relevant national and regional laws and regulations and standards, and needs to be performed under the permission or consent of the respective subject (e.g., user or enterprise, etc.).
Referring to fig. 6, fig. 6 is a schematic structural diagram of a data processing system according to an embodiment of the present disclosure.
An obtaining unit 601, configured to obtain pre-processing service data, where the pre-processing service data includes service data of different attribute categories;
a presentation unit 602, configured to present, to a target user, pre-processed service data corresponding to a target query condition according to the target query condition, and determine that the pre-processed service data is target service data;
a summarizing unit 603, configured to summarize the target service data according to the target query condition, so that the target user derives the target service data.
Illustratively, a data processing system includes: a conversion unit 604;
an obtaining unit 601, configured to specifically obtain multiple attribute categories in a target type file and to-be-processed service data corresponding to each attribute category;
the conversion unit 604 is configured to convert the to-be-processed service data according to different attribute categories, so as to obtain the pre-processed service data.
Illustratively, the data processing system further comprises: a logging unit 605;
the storing unit 605 is configured to store the pre-processing service data into a database.
Illustratively, a data processing system includes: a processing unit 606;
a storing unit 605, specifically configured to store part of the preprocessed service data into a database;
and/or the processing unit 606 is configured to perform service processing on another part of the pre-processed service data, so as to store the pre-processed service data after the service processing into the database.
Illustratively, a data processing system includes: a calling unit 607 and a statistic unit 608;
the calling unit 607 is configured to call, according to the attribute type of the other part of the preprocessed service data, service data associated with the other part of the preprocessed service data, so as to complete the other part of the preprocessed service data;
and/or, the statistic unit 608 is configured to perform statistics on another part of the preprocessed traffic data.
Illustratively, a data processing system includes: a receiving unit 609 and a screening unit 610;
a receiving unit 609, configured to receive a selection result of the target user for different query conditions, so as to determine a target query condition;
a screening unit 610, configured to screen the preprocessed service data according to the target query condition to determine target service data;
the presentation unit 602 is specifically configured to present the target service data to the target user.
Referring to fig. 7, fig. 7 is a schematic structural diagram of a data processing apparatus according to an embodiment of the present application, including:
a central processing unit 701, a memory 705, an input/output interface 704, a wired or wireless network interface 703 and a power supply 702;
memory 705 is a transient storage memory or a persistent storage memory;
the central processing unit 701 is configured to communicate with the memory 705, and execute the instruction operations in the memory 705 to execute the data processing method in the foregoing embodiment shown in fig. 2 or fig. 3.
The embodiment of the present application further provides a chip system, where the chip system includes at least one processor and a communication interface, where the communication interface and the at least one processor are interconnected by a line, and the at least one processor is configured to run a computer program or instructions to execute the data processing method in the embodiment shown in fig. 2 or fig. 3.
It is clear to those skilled in the art that, for convenience and brevity of description, the specific working processes of the above-described systems, apparatuses and units may refer to the corresponding processes in the foregoing method embodiments, and are not described herein again.
In the several embodiments provided in the present application, it should be understood that the disclosed system, apparatus and method may be implemented in other manners. For example, the above-described apparatus embodiments are merely illustrative, and for example, the division of the units is only one logical division, and other divisions may be realized in practice, for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, devices or units, and may be in an electrical, mechanical or other form.
The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
In addition, functional units in the embodiments of the present application may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.
The integrated unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solutions of the present application, which are essential or part of the technical solutions contributing to the prior art, or all or part of the technical solutions, may be embodied in the form of a software product, which is stored in a storage medium and includes several instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to execute all or part of the steps of the methods described in the embodiments of the present application. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a read-only memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk, and the like.

Claims (10)

1. A method of data processing, the method comprising:
acquiring preprocessing service data, wherein the preprocessing service data comprises service data of different attribute categories;
displaying the preprocessed business data corresponding to the target query condition to a target user according to the target query condition, and determining the preprocessed business data as target business data;
and summarizing the target business data according to the target query condition so that the target user can export the target business data.
2. The data processing method of claim 1, wherein the obtaining pre-processing service data comprises:
acquiring a plurality of attribute categories and to-be-processed service data corresponding to each attribute category in a target type file;
and respectively converting the service data to be processed according to different attribute categories to obtain the preprocessed service data.
3. The data processing method according to claim 1, wherein after the obtaining of the preprocessed business data, before the displaying of the preprocessed business data corresponding to the target query condition to the user according to the target query condition to determine that the preprocessed business data is the target business data, the method further comprises:
and storing the preprocessed service data into a database.
4. The data processing method of claim 3, wherein the storing the pre-processed service data into a database comprises:
storing part of the preprocessed service data into the database;
and/or performing service processing on the other part of the preprocessed service data to store the preprocessed service data subjected to the service processing into the database.
5. The data processing method according to claim 4, wherein said performing the service processing on the other part of the preprocessed service data comprises:
calling service data associated with the other part of the preprocessed service data according to the attribute category of the other part of the preprocessed service data so as to complete the other part of the preprocessed service data;
and/or counting the other part of the preprocessed service data.
6. The data processing method according to claim 1, wherein the presenting the preprocessed business data corresponding to the target query condition to the user according to the target query condition comprises:
receiving selection results of the target user for different query conditions to determine the target query conditions;
screening the preprocessed service data according to the target query condition to determine the target service data;
and displaying the target service data to the target user.
7. The data processing method according to any one of claims 1 to 6,
the attribute category comprises transaction type, transaction amount, transaction quantity or transaction time;
the target query condition comprises a payment mode, a bill type or a merchant number.
8. A data processing system, characterized in that the system comprises:
the device comprises an acquisition unit, a processing unit and a processing unit, wherein the acquisition unit is used for acquiring preprocessed service data which comprises service data with different attribute categories;
the query unit is used for displaying the preprocessed business data corresponding to the target query condition to a user according to the target query condition and determining the preprocessed business data as the target business data;
and the summarizing unit is used for summarizing the target business data according to the target query condition so as to lead the target user to export the target business data.
9. A data processing apparatus, characterized in that the apparatus comprises:
the system comprises a central processing unit, a memory, an input/output interface, a wired or wireless network interface and a power supply;
the memory is a transient storage memory or a persistent storage memory;
the central processor is configured to communicate with the memory and execute the operations of the instructions in the memory to perform the data processing method of any one of claims 1 to 7.
10. A computer-readable storage medium, comprising instructions which, when executed on a computer, cause the computer to perform the data processing method of any one of claims 1 to 7.
CN202211110477.6A 2022-09-13 2022-09-13 Data processing method and related equipment Pending CN115470266A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202211110477.6A CN115470266A (en) 2022-09-13 2022-09-13 Data processing method and related equipment

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202211110477.6A CN115470266A (en) 2022-09-13 2022-09-13 Data processing method and related equipment

Publications (1)

Publication Number Publication Date
CN115470266A true CN115470266A (en) 2022-12-13

Family

ID=84333294

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202211110477.6A Pending CN115470266A (en) 2022-09-13 2022-09-13 Data processing method and related equipment

Country Status (1)

Country Link
CN (1) CN115470266A (en)

Similar Documents

Publication Publication Date Title
US10963955B2 (en) Optimizing aggregation routing over a network
US8346661B2 (en) Aggregation of customer transaction data
EP2863357A1 (en) Method of automating a business loan life cycle
US10318546B2 (en) System and method for test data management
US20240078596A1 (en) System and method for aggregating and presenting financial information
CN110428240B (en) Automatic suspicious transaction identification and processing method, terminal and server
CN111062799A (en) Method and device for managing family client, electronic equipment and storage medium
US8538872B1 (en) Credit card account shadowing
CN111125266A (en) Data processing method, device, equipment and storage medium
CN110942392A (en) Service data processing method, device, equipment and medium
CN111369347A (en) Service processing method, device, equipment and storage medium
CN115470266A (en) Data processing method and related equipment
CN114742547A (en) Internet online collection control method, device, medium and electronic equipment
CN112561689B (en) Transaction data recording processing method, device, equipment and storage medium
CN114820196A (en) Information pushing method, device, equipment and medium
CN114997977B (en) Data processing method, device, electronic equipment and computer readable medium
CN113515374B (en) Data processing method and device, electronic equipment and computer readable storage medium
JP7359919B1 (en) Information processing device, information processing method, and program
CN113487408A (en) Information processing method and device
WO2020245046A1 (en) System and method for ledger analytics and application of digital tax stamps
CN114240391A (en) Method, apparatus, electronic device, medium, and program product for additional recording of declaration information
CN117312673A (en) Enterprise customer recommendation method, system, electronic equipment and medium
CN113971007A (en) Information processing method, information processing apparatus, electronic device, and medium
CN115423595A (en) File information processing method and device, computer equipment and storage medium
CN114116873A (en) Cross-bank account data processing method and device

Legal Events

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