Data export method, system, device and storage medium

By dynamically switching the data export interface mode and using machine learning technology to determine usage scenarios, the problem that the data export system in the existing technology is difficult to adapt to different scenarios is solved, and a more flexible and accurate data export effect is achieved.

CN119065562BActive Publication Date: 2025-01-24NANJING HENTOR INFOMATION TECH CO LTD
View PDF 2 Cites 0 Cited by

Patent Information

Application Number
CN202411562825.2
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2024-11-05
Publication Date
2025-01-24
Estimated Expiration
2044-11-05

AI Technical Summary

Technical Problem

The existing data export system is difficult to automatically identify user scenarios and dynamically adjust the export strategy, resulting in poor user experience and difficult to meet the strict requirements of data accuracy and processing speed in specific scenarios.

Method used

Provide a data export method. By receiving the user's modal, select the command to dynamically switch the data export interface, use machine learning technology to determine the use scenario and find the corresponding export strategy, perform data verification, and generate data files to be exported.

Benefits of technology

It realizes dynamic switching of data export interface modes according to user needs to meet users' diverse needs and improve user experience; it uses machine learning technology to determine usage scenarios and find corresponding export strategies to ensure the accuracy and efficiency of data export.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN119065562B_ABST
    Figure CN119065562B_ABST
Patent Text Reader

Abstract

The present application discloses a data export method, system, device and storage medium, the method comprising: receiving a user's modal selection instruction for a data export interface, dynamically switching the modality of the data export interface; receiving a user's selection of a data field in a table to be exported in the data export interface under the corresponding mode, obtaining the data field to be exported and generating a data file to be exported; using machine learning technology to determine the usage scenario of the data file to be exported, finding the corresponding export strategy based on the determined usage scenario, and using the export data verification strategy in the found export strategy to verify the export data of the export data file; when the data file to be exported is successfully verified, generating a triggering export event prompt information, receiving the export event generated by the user triggering and executing the export event, and exporting the data file. The present application can realize the flexible and accurate completion of data export that meets user needs in a variety of usage scenarios.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present application relates to the technical field of data processing, and specifically to a data export method, system, device and storage medium. Background Art

[0002] With the increase in data volume and the diversification of business needs in various industries, how to improve the flexibility and adaptability of data export has become an urgent problem to be solved. However, most of the current data export systems have a single interface and rigid export strategies, which makes it difficult to meet the efficiency and customization needs of users in different industries in changing work scenarios.

[0003] In order to achieve the basic functions of data export, existing data export systems usually use fixed interface templates and data processing logic without considering the differences in different scenarios. Specifically, these systems generally adopt the following technical means: First, the data export method based on fixed interface templates, users can only choose to export the required data according to the fixed templates provided by the system. Second, predefined data conversion and verification logic is used to complete the specific operation steps before and after data export. Third, some systems provide simple data filtering and sorting functions. Although these means meet the basic data export needs to a certain extent, there are still many defects in practical applications.

[0004] The above existing technical means have obvious shortcomings. They cannot automatically identify user scenarios and dynamically adjust export strategies, resulting in poor user experience. In certain scenarios (such as finance and e-commerce), it is difficult to meet users' stringent requirements for data accuracy and processing speed. Therefore, how to export data more flexibly and accurately in different work scenarios is a technical problem that needs to be solved urgently. Summary of the invention

[0005] In order to achieve more flexible and accurate data export that meets user needs in different usage scenarios, the present application provides a data export method, system, device and storage medium.

[0006] In a first aspect, the present application provides a data export method, comprising:

[0007] Receive a user's mode selection instruction for the data export interface, and dynamically switch the mode of the data export interface, including: an interactive data export interface mode, a template data export interface mode, and an intelligent data export interface mode; the interactive data export interface mode displays the data table according to a preset interactive mode selected by the user, the template data export interface mode displays the data table according to a preset template selected by the user, and the intelligent data export interface mode displays the data table according to the intelligent recommendation of the user's historical exported data analysis results;

[0008] Receive the data fields in the table to be exported selected by the user in the data export interface under the corresponding mode, obtain the data fields to be exported, convert and organize the data fields to be exported, and generate the data files to be exported;

[0009] Using machine learning technology to determine the usage scenario of the data file to be exported, finding the corresponding export strategy based on the determined usage scenario, and using the export data verification strategy in the found export strategy to verify the export data of the exported data file; each usage scenario is provided with a preset export strategy, and each export strategy has an export data verification strategy generated by combining different data verification methods, and the data verification methods include: data integrity and consistency verification, data quality assessment verification, data compliance verification and data authority verification;

[0010] When the verification of the exported data file is successful, a prompt message of triggering the export event is generated and displayed on the data export interface; the export event generated by the user trigger is received and the export event is executed to export the data file.

[0011] By adopting the above solution, the data export interface of different modes is dynamically switched according to user needs, so that users can select the export interface mode as needed, meet the diverse needs of users, and improve the user experience; use machine learning technology to determine the usage scenarios in which users select the data to be exported in the selected mode and find the corresponding export strategy, use a combination of preset multiple data verification methods to verify the data file to be exported, balance the accuracy and efficiency requirements of the exported data in different scenarios, and achieve more flexible and accurate completion of data export tasks in changing scenarios.

[0012] Preferably, it also includes:

[0013] When receiving an export event triggered by a user and executing the export event, determine whether there is a conflict event during the execution of the export event. If there is a conflict event, stop executing the export event until the conflict event disappears and then continue to execute the export event; the conflict event includes a shared data resource export conflict.

[0014] By adopting the above solution, it is determined whether there is a conflict event during the execution of the export event, thereby avoiding data export failure or data inconsistency caused by shared data resource conflicts, and ensuring the stability of the data export process and the integrity of the data.

[0015] Preferably, it also includes:

[0016] When receiving an export event triggered by a user and executing the export event, determine whether a preset restrictive event is triggered during the execution of the export event. If the preset restrictive event is triggered, stop executing the export event until the preset restrictive event disappears and then continue to execute the export event; the preset restrictive events include data export prohibited events during a preset time period, frequent export events during a preset time period, and preset data unclassified export events.

[0017] By adopting the above solution, preset restrictive events can be effectively identified and processed when executing export events, thereby improving the security and compliance of the data export process, avoiding data security issues caused by frequent or improper exports, and ensuring that data export operations are performed at appropriate times and conditions, thereby ensuring the accuracy of data processing and system stability.

[0018] Preferably, it also includes:

[0019] Based on the flow layout and dynamic reorganization technology, it receives the user's instructions for interface layout adjustment and function setting, adjusts the data export interface layout, and sets the function modules as required. The function modules include: data field selection area, data field sorting, format and filter condition setting column;

[0020] The receiving user selects the sorting, formatting and filtering conditions of the data fields to be exported in the adjusted data export interface, and converts and organizes the data fields to be exported according to the sorting, formatting and filtering conditions, and generates the data files to be exported.

[0021] By adopting the above solution, based on streaming layout and dynamic reorganization technology, users can adjust the data export interface layout in real time according to their own needs and set functional modules as needed, making the selection, sorting and setting of filtering conditions of exported data fields more flexible, improving the convenience of user operation and personalized configuration capabilities, thereby improving the efficiency and user experience in the data export process.

[0022] Preferably, it also includes:

[0023] Receive user satisfaction feedback scores on the data export interface and exported data files;

[0024] If the ratio of users whose user satisfaction feedback scores on the data export interface are lower than the preset satisfaction scores to all scoring users is greater than a first preset ratio value, the data export interface under different modes is optimized accordingly, including: adjusting the interactive process for the preset interactive mode in the interactive data export interface mode, adjusting the template style for the preset template in the template-based data export interface mode, and performing incremental training on the intelligent recommendation algorithm in the intelligent data export interface mode;

[0025] If the ratio of users whose user satisfaction feedback scores for the exported data file are lower than the preset satisfaction scores to all scoring users is greater than a second preset ratio value, the data verification method in the export strategy for different usage scenarios is adjusted accordingly.

[0026] By adopting the above solution, the user satisfaction feedback scores for the data export interface and the exported data files are analyzed, and the data export interface under different modes is optimized or the data verification method in the export strategy under different usage scenarios is adjusted to improve the accuracy and satisfaction of data export.

[0027] Preferably, the usage scenarios include: scientific research usage scenarios, e-commerce usage scenarios and financial usage scenarios; a first export data verification strategy is set for the scientific research usage scenario, and the data verification methods adopted by the first export data verification strategy include: data integrity and consistency verification, data quality assessment verification and data compliance verification; a second export data verification strategy is set for the e-commerce usage scenario, and the data verification methods adopted by the second export data verification strategy include: data integrity and consistency verification based on distributed processing technology; a third export data verification strategy is set for the financial usage scenario, and the data verification methods adopted by the third export data verification strategy include: data authority verification, data integrity and consistency verification and data compliance verification.

[0028] By adopting the above solution, corresponding export data verification strategies are set for different usage scenarios. In the scientific research usage scenario, data integrity and consistency verification, data quality assessment verification and data compliance verification are adopted to ensure the high accuracy of the exported data; in the e-commerce usage scenario, data integrity and consistency verification is completed based on distributed processing technology to ensure high efficiency and data consistency under large data volume processing; in the financial usage scenario, data permission verification, data integrity and consistency verification and data compliance verification are adopted to strengthen data security and compliance checks to meet the stringent requirements of the financial industry.

[0029] Preferably, the method further includes: the preset export strategies corresponding to each usage scenario include data file content export strategies, searching for corresponding export strategies based on the determined usage scenario, and adjusting the data content in the data file to be exported using the data file export strategies in the searched export strategies;

[0030] Among them, a first data file content export strategy is set for scientific research usage scenarios, and the first data file content export strategy includes: data version export strategy, and export strategy for associating and labeling typical related data in scientific research usage scenarios; a second data file content export strategy is set for e-commerce usage scenarios, and the second data file content export strategy includes: export strategy for distinguishing and labeling according to user historical data export preferences, and export strategy for labeling according to typical data report content in e-commerce usage scenarios; a third data file content export strategy is set for financial usage scenarios, and the third data file content export strategy includes: export strategy supporting multi-format compatibility, and export strategy according to typical risk levels of data in financial usage scenarios.

[0031] By adopting the above solution, intelligent adjustment of data file content is achieved in different usage scenarios. For scientific research usage scenarios, data version export strategy and typical related data associated labeling export strategy are adopted to improve the systematicness and traceability of scientific research data export; for e-commerce usage scenarios, the export strategy is distinguished by labeling export strategy according to user historical data export preferences and typical data report content integration export strategy, which improves the speed and intuitiveness of data export; for financial usage scenarios, the export strategy that supports multi-format compatibility and data typical risk level classification is used to enhance the compatibility and security of data export.

[0032] In a second aspect, the present application provides a data export system, comprising:

[0033] The data export interface selection module is used to receive the user's mode selection instruction for the data export interface and dynamically switch the mode of the data export interface, including: interactive data export interface mode, template data export interface mode and intelligent data export interface mode; the interactive data export interface mode displays the data table according to the preset interactive mode selected by the user, the template data export interface mode displays the data table according to the preset template selected by the user, and the intelligent data export interface mode displays the data table according to the intelligent recommendation of the user's historical exported data analysis results;

[0034] The data export selection module is used to receive the data fields in the table to be exported selected by the user in the data export interface under the corresponding mode, obtain the data fields to be exported, convert and organize the data fields to be exported, and generate the data files to be exported;

[0035] A data export verification module is used to determine the usage scenario of the exported data file using machine learning technology, find the corresponding export strategy based on the determined usage scenario, and use the export data verification strategy in the found export strategy to verify the export data of the exported data file; each usage scenario is provided with a preset export strategy, and each export strategy has an export data verification strategy generated by combining different data verification methods, and the data verification methods include: data integrity and consistency verification, data quality assessment verification, data compliance verification and data authority verification;

[0036] The data export execution module is used to generate a trigger export event prompt message and display it on the data export interface when the exported data file is successfully verified; receive the export event triggered by the user and execute the export event to export the data file.

[0037] By adopting the above solution, it is possible to more flexibly and accurately export data that meets user needs in different usage scenarios.

[0038] In a third aspect, the present application provides a computer-readable storage medium, wherein the computer-readable storage medium includes a stored computer program, wherein when the computer program is executed, the device where the computer-readable storage medium is located is controlled to execute the method as described above.

[0039] In a fourth aspect, the present application provides a computer device, comprising a memory, a processor, and a program stored and executable on the memory, wherein the program implements the steps of the above method when executed by the processor.

[0040] In summary, this application has the following beneficial effects:

[0041] 1. Dynamically switch the mode of the data export interface according to user needs, so that users can flexibly choose the export method that meets their needs, improving the personalization and convenience of data export; by receiving the data fields selected by the user in the selected mode and generating the data file to be exported, ensure that users only need to perform simple operations to obtain the required data; use machine learning technology to determine the usage scenarios of data export and find the corresponding export strategy, complete data verification, and further optimize the accuracy and security of data export; by generating and displaying export event prompt information, enhance the user's sense of operation and the transparency of the export process, and improve overall work efficiency and user satisfaction;

[0042] 2. It can effectively identify conflicting events or preset restrictive events when executing export events, ensuring the stability of the data export process and the security and compliance of the data;

[0043] 3. Based on streaming layout and dynamic reorganization technology, users can adjust the data export interface layout in real time according to their own needs and set functional modules as needed, which improves the efficiency and user experience during the data export process. BRIEF DESCRIPTION OF THE DRAWINGS

[0044] Figure 1 is a flow chart of the data export method described in a specific embodiment;

[0045] Figure 2 It is a structural schematic diagram of the data export system described in a specific embodiment. DETAILED DESCRIPTION

[0046] In order to make the purpose, technical solution and advantages of the present application more clearly understood, the present application is further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present application and are not used to limit the present application.

[0047] like Figure 1 As shown, the embodiment of the present application discloses a data export method, and the specific steps are as follows:

[0048] S1. Receive a user's modal selection instruction for a data export interface, and dynamically switch the modality of the data export interface.

[0049] In order to realize data export, a data export interface is designed for users to select the required data to export on the interface. Considering the singleness of the traditional data export interface, such as: a single search bar for each data table; in order to improve the user experience and meet the diverse needs of users for the data export interface, a data export interface in different modes is designed for users to choose, including: interactive data export interface mode, template data export interface mode, intelligent data export interface mode and other data export interface modes; receiving the user's mode selection instruction for the data export interface, and dynamically switching the mode of the data export interface according to the received mode selection instruction.

[0050] Among them, considering that the user's data export requirements in different usage scenarios are not clear, an interactive data export interface modality is designed to gradually guide the user to select the required export data in the data export interface to ensure that the exported data meets the user's actual needs as much as possible; specifically, the interactive data export interface modality displays the data table and / or the data fields in the data table according to the preset interactive method selected by the user; the preset interactive method is pre-set, guiding the user to select the interactive steps for exporting data according to the preset interactive process (which can be touch or voice commands). For example: For the data export of scientific research usage scenarios, a first preset interactive method is set. The first preset interactive method designs an interactive process according to the experimental process to guide the user to gradually select the exported data. The interactive process includes: instructing the user to select the experimental stage data table-instructing the user to select the specific data to be exported in this stage. In order to further meet the user's export needs for different types of data, several preset interactive methods can be designed based on the typical data export methods of the usage scenarios.

[0051] Among them, in addition to guiding users to select the required export data, for partial data export, preset templates can be used to directly guide users to select the required export data, so as to satisfy users to quickly obtain the required data and improve work efficiency; specifically, the template-based data export interface modality displays data tables and / or data fields in data tables according to the preset template selected by the user; the preset template is pre-set manually, instructing users to select the data to be exported. For example: the data export of e-commerce usage scenarios is set with a first preset template (sales data template), and the first preset template includes the data fields to be exported (product name, sales volume, sales, etc.), data export format and sorting method. In order to further meet the diverse needs of users, users are also allowed to upload their own customized preset templates for data export.

[0052] Among them, in addition to relatively clear guidance or guidance for users to choose to export data, the most suitable export data configuration for users can also be intelligently recommended based on the analysis results of users' historical exported data, so as to satisfy the users' needs to quickly obtain the required data; specifically, the intelligent data export interface modality intelligently recommends and displays data tables for users to choose according to the analysis results of users' historical exported data; wherein, a deep learning algorithm is used to analyze user habits and preferences for historical exported data and intelligently recommends and displays data tables and / or data fields in data tables based on the analyzed user habits and preferences.

[0053] Among them, other data export interface modes can adopt the traditional unified search bar for each data table. The user selects the required data table in the data export interface by entering the table identifier and name, and selects the required data table and / or data field in the data table in the data export interface by entering the table identifier and the data field identifier in the table.

[0054] In addition, in order to further improve the user experience, the mode of the data export interface can be switched adaptively. Specifically, the associated information data can be searched according to the account of the user who logged into the data export interface, including: user occupation label, user's recent selection mode record and export data record and other recent activity records; based on the associated information data, machine learning technology is used to predict the mode selected by the user when logging in next time, so as to automatically switch the mode of the predicted data export interface.

[0055] S2. Receive the data fields in the table to be exported selected by the user in the data export interface under the corresponding mode, obtain the data fields to be exported, and process and generate the data files to be exported.

[0056] Specifically, a table to be exported is received when a user selects it in a data export interface under a corresponding mode. Considering that data fields in a table are displayed in the data export interface under some modes for the user to select, the data fields in the table directly selected by the user are received; or a table to be exported is received when a user selects it in a data export interface under a corresponding mode, the backend server obtains the field name and description in the table and fills them back into the sub-table, and the data fields to be exported selected by the user in the sub-table are received, thereby obtaining the data fields to be exported from the database according to the data fields to be exported received from the user.

[0057] For the obtained export data fields, data conversion, sorting and generation of the data file to be exported are required. Specifically, the file can be created by calling the API, reading the data in the database, converting and processing the obtained data according to the created file format, and writing the data into the created file by using the write operation. After the data is written, the file is closed to release resources and ensure that the data is saved correctly. For example, call the API to create a CSV file, use SQL statements to read the data in the database, convert and process it according to the CSV file format, and use the JAVA file write operation to complete the writing of the exported data line by line into the CSV file.

[0058] S3. Use machine learning technology to determine the usage scenario of the data file to be exported, find the corresponding export policy based on the determined usage scenario, and use the export data verification policy in the found export policy to verify the export data of the export data file.

[0059] Specifically, in order to ensure the security and accuracy of data export, the exported data files are verified, and considering the differences between data in different usage scenarios, data verification is performed according to the different adaptability of usage scenarios to improve the accuracy of data verification; a machine learning algorithm is constructed to determine the usage scenario of the data files to be exported; the machine learning algorithm can use a neural network model, the input of the model is the data file to be exported, and the output of the model is the usage scenario in the data file to be exported, which is generated by training data files with specific usage scenarios historically annotated. In this implementation, the usage scenarios include: scientific research usage scenarios, e-commerce usage scenarios, financial usage scenarios, and other usage scenarios.

[0060] Each usage scenario is set with a preset export strategy and stored in the export strategy database, and each export strategy has an export data verification strategy generated by a combination of different data verification methods. The data verification methods include: data integrity and consistency verification, data quality assessment verification, data compliance verification, and data authority verification.

[0061] In this embodiment, the export verification strategy in the export policy set for the scientific research use scenario is the first export data verification strategy. Considering that the scientific research use scenario focuses more on the quality of the exported data, the data verification methods adopted by the first export data verification strategy include: data integrity and consistency verification, data quality assessment verification, and data compliance verification. The export verification strategy in the export policy set for the e-commerce use scenario is the second export data verification strategy. Considering that the e-commerce use scenario focuses more on the real-time nature of the exported data, the data verification methods adopted by the second export data verification strategy include: completing data integrity and consistency verification based on distributed processing technology. The export verification strategy in the export policy set for the financial use scenario is the third export data verification strategy. Considering that the financial use scenario focuses more on the security of the exported data, the data verification methods adopted by the third export data verification strategy include: data authority verification, data integrity and consistency verification, and data compliance verification; the export verification strategy in the export policy set for other use scenarios is the fourth export data verification strategy. The data verification methods adopted by the fourth export data verification strategy include: data integrity and consistency verification, and data compliance verification.

[0062] The exported data file is verified by using the export data verification strategy in the found export strategy. The exported data verification is deemed to be successful through different verification methods in the found data verification strategy. Among them, the integrity and consistency of the data fields in the file to be exported are compared with the data fields in the export table selected by the user. If the similarity of the comparison result is greater than the preset similarity value, the verification is deemed to be successful; the quality assessment is performed on whether there are missing values, abnormal values ​​and duplicates in the data fields in the file to be exported. If the score of the quality assessment result is greater than the preset quality score, the verification is deemed to be successful; the compliance judgment is performed on the data fields in the file to be exported according to the legality requirements. If it is judged that the exported data complies with the requirements of scientific research ethics and regulations, the verification is deemed to be successful; the data permission verification of the data fields in the file to be exported includes: searching for the associated account permission information according to the user login data export interface account, determining the permission to allow the user to export data, and verifying whether the current exported data exceeds the permission based on the export data permission. If it exceeds the permission, the verification is deemed to be successful.

[0063] S4. When the verification of the exported data file is successful, a prompt message of triggering the export event is generated and displayed on the data export interface, and the export event generated by the user triggering is received and the export event is executed to export the data file.

[0064] Specifically, when the data file to be exported is successfully verified, data can be exported, and a prompt for triggering the export event is generated accordingly, that is, a download button is designed and displayed on the data export interface, instructing the user to export data, and when the user triggers the generation of the export event, the export event is executed and the required export data is output. If the data file to be exported fails to be verified, go to step S2, re-acquire the data field to be exported and process to generate the data file to be exported.

[0065] By adopting the method described in this embodiment, users are no longer restricted by a single interface template and can quickly switch to the most suitable export interface according to actual needs. The adaptive verification mechanism is used to ensure the accuracy and compliance of data processing. This application can better meet the personalized needs of different users and provide a more accurate data export experience in specific fields such as finance, e-commerce, scientific research, etc.

[0066] In a specific embodiment, considering that there are data export conflicts or data export restrictions during the data export process, in order to ensure the stability and accuracy of the data export, the method further includes:

[0067] When receiving an export event triggered by a user and executing the export event, determining whether there is a conflict event or a preset restriction event during the execution of the export event;

[0068] Among them, the conflict events include shared data resource export conflicts, that is, the current shared data resources are being exported or locked; the preset restrictive events include data export prohibited events during a preset time period, frequent export events during a preset time period, preset data ungraded export events, etc.; specifically, considering the existence of prohibited data transactions, in order to avoid exporting data during the prohibited period, a preset time period prohibited data export event is set; considering that frequent data export is a kind of abnormal data export phenomenon, once the frequency of exporting data within a preset time period is greater than the preset frequency, it is easy to cause an increase in the data export error rate. In order to avoid this situation, a preset time period frequent export event is set for exporting data; considering that there are certain regulations restricting that data must be exported in a graded manner, such as data of different confidentiality levels must be exported separately, in order to avoid data security problems caused by the simultaneous export of data that should be exported in a graded manner, a preset data ungraded export event is set.

[0069] If there is a conflict event, the export event will be stopped until the conflict event disappears and then the export event will be continued; or if a preset restrictive event is triggered (i.e. a preset restrictive event occurs when the export event is executed), the export event will be stopped until the preset restrictive event disappears and then the export event will be continued.

[0070] In addition, different conflict events or different types of preset restriction events may be triggered for different usage scenarios. The conflict events and preset restriction events in different usage scenarios can be distinguished, and the conflict events and preset restriction events in the usage scenarios can be determined based on the corresponding queries for the determined usage scenarios. It is determined whether there are queried conflict events or triggered preset restriction events during the execution of the export event, so as to further accurately avoid executing data export events when conflict events and restriction events occur.

[0071] In a specific embodiment, in order to further increase the user's ability to highly customize the data export method and improve the flexibility and user-friendliness of the data export system, the method further includes:

[0072] Capturing the user adding function modules or adjusting the interface layout in a drag-and-drop modification manner on the data export interface, generating interface layout adjustment and function setting instructions accordingly, and receiving the user's interface layout adjustment and function setting instructions; the data export interface is provided with a number of function module components and layout adjustment components;

[0073] Based on streaming layout and dynamic reorganization technology, the data export interface layout is adjusted according to the interface layout adjustment and function setting instructions received from the user, and the functional modules are set as required. The functional modules include: data field selection area, data field sorting, format and filter condition setting column, etc.

[0074] The receiving user selects the sorting, formatting and filtering conditions of the data fields to be exported in the adjusted data export interface, and converts and organizes the data fields to be exported according to the sorting, formatting and filtering conditions, and generates the data files to be exported.

[0075] By adopting the method described in the above embodiment, the user can flexibly adjust the interface and function configuration according to specific needs, which simplifies the user operation steps and greatly improves the user experience.

[0076] In a specific embodiment, the user's feedback on the exported data file is used to continuously optimize and adjust to ensure the accuracy and efficiency of the data export. The method further includes:

[0077] When exporting data files, a user feedback questionnaire on the data export interface and the exported data files is displayed on the data export interface, and user satisfaction feedback scores and problem feedback on the data export interface and the exported data files are received;

[0078] If the ratio of users whose user satisfaction feedback scores on the data export interface are lower than the preset satisfaction scores to all scoring users is greater than a first preset ratio value, it indicates that many users are not satisfied with the data export interface, and the data export interface under different modes is optimized accordingly;

[0079] Among them, optimizing the data export interface under different modes includes: adjusting the interactive process for the preset interactive mode in the interactive data export interface mode, and the interactive process adjustment includes: analyzing the problem feedback using a semantic analysis algorithm and choosing to refine the interactive process or simplify the interactive process based on the analysis results. Optimizing the data export interface under different modes also includes: adjusting the template style for the preset template in the template-based data export interface mode, and the template style adjustment includes: analyzing the problem feedback using a semantic analysis algorithm and choosing to adjust the preset template content or add a new template based on the analysis results. Optimizing the data export interface under different modes also includes: performing incremental training on the intelligent recommendation algorithm in the intelligent data export interface mode, and the incremental training includes: adding training data of historical user exported data and performing incremental training on the constructed neural network model.

[0080] If the ratio of users whose user satisfaction feedback scores for the exported data files are lower than the preset satisfaction scores to all scoring users is greater than a second preset ratio value, it indicates that many users are not satisfied with the exported data in the data export file, and corresponding adjustments or supplements to the verification methods in the export strategies for different usage scenarios are selected, such as adjusting the data verification methods in the existing export strategies for different scenarios.

[0081] In a specific embodiment, in order to further improve user satisfaction with data export, the method also includes: the preset export strategies corresponding to each usage scenario include data file content export strategies, searching for corresponding export strategies based on the determined usage scenarios, and using the data file export strategies in the found export strategies to adjust the data content in the data file to be exported, so as to achieve export in a form that satisfies the user.

[0082] Specifically, a first data file content export strategy is set for scientific research usage scenarios, and the first data file content export strategy includes: data version export strategy, export strategy for associating and annotating typical related data in scientific research usage scenarios, etc.; among them, there are often multiple versions of data in scientific research usage scenarios. In order to further ensure the integrity and orderliness of scientific research data export, different versions of data are adjusted to different sub-files according to the data version export strategy to achieve versioned data export; in addition, there are often associations between data in scientific research usage scenarios. Deep neural algorithms can be used to identify typical related data in scientific research usage scenarios, and the identified typical related data in scientific research usage scenarios can be used to perform association annotation processing on typical related data in the data file to be exported, so that users can promptly determine the related data in the data to be exported together.

[0083] A second data file content export strategy is set for e-commerce usage scenarios, and the second data file content export strategy includes: an export strategy based on the user's historical data export preference distinction, an export strategy based on the typical data report content integration in the e-commerce usage scenario, etc.; among them, for data in the e-commerce usage scenario, deep learning technology is used to perform user preference analysis on historical user exported data, and data in the exported data with user preference values ​​higher than preset preference values ​​is marked so that users can find their preferred data in the exported data in a timely manner; the export strategy based on the typical data report content annotation in the e-commerce usage scenario refers to exporting the content of the typical data report in the e-commerce usage scenario by annotating the content in the file.

[0084] The third data file content export strategy is set for financial usage scenarios. The third data file content export strategy includes: supporting multi-format compatible export strategy, export strategy based on typical risk level of data in financial usage scenarios, etc. Among them, there are often multiple financial data standard formats in financial usage scenarios, such as FIX and FpML. When exporting data file content, support multi-format compatible export of data in the exported file. For data export in financial usage scenarios, the focus is on the hierarchical export of data at different risk levels to prevent data export confusion caused by exporting data of different risk levels at the same time. According to the typical risk level hierarchical export strategy of data in financial usage scenarios, data of different risk levels are adjusted to different sub-files respectively, and sub-files with high risk levels are encrypted to achieve hierarchical export of data of different risk levels.

[0085] In addition, a fourth data file content export strategy is set for other usage scenarios, and the fourth data file content export strategy includes: an export strategy for associating and annotating typical associated data in a specific usage scenario, and the like.

[0086] like Figure 2 As shown, the embodiment of the present application discloses a data export system, including:

[0087] The data export interface selection module 101 is used to receive a user's mode selection instruction for the data export interface and dynamically switch the mode of the data export interface, including: an interactive data export interface mode, a template data export interface mode and an intelligent data export interface mode; the interactive data export interface mode displays the data table according to a preset interactive mode selected by the user, the template data export interface mode displays the data table according to a preset template selected by the user, and the intelligent data export interface mode displays the data table according to the intelligent recommendation of the user's historical exported data analysis results;

[0088] The data export selection module 102 is used to receive the data fields in the table to be exported selected by the user in the data export interface under the corresponding mode, obtain the data fields to be exported, and perform data conversion and sorting on the data fields to be exported to generate a data file to be exported;

[0089] The data export verification module 103 is used to determine the usage scenario of the exported data file by using machine learning technology, find the corresponding export policy based on the determined usage scenario, and use the export data verification policy in the found export policy to verify the export data of the exported data file; each usage scenario is provided with a preset export policy, and each export policy has an export data verification policy generated by combining different data verification methods, and the data verification methods include: data integrity and consistency verification, data quality assessment verification, data compliance verification and data authority verification;

[0090] The data export execution module 104 is used to generate a trigger export event prompt message and display it on the data export interface when the exported data file is successfully verified; receive the export event generated by the user trigger and execute the export event to export the data file.

[0091] In a specific embodiment, the data export selection module 102 is also used to receive user instructions for interface layout adjustment and function setting based on streaming layout and dynamic reorganization technology, and adjust the data export interface layout and set function modules as required. The function modules include: a data field selection area, a data field sorting, a format and a filter condition setting column; receive the user's selection of the data field sorting, format and filter conditions to be exported in the adjusted data export interface, and convert and organize the data fields to be exported according to the data field sorting, format and filter conditions, and generate the data file to be exported.

[0092] In a specific embodiment, the data export verification module 103 is also used to receive user satisfaction feedback scores for the data export interface and the exported data files; if the ratio of users whose user satisfaction feedback scores for the data export interface are lower than the preset satisfaction scores to all scoring users is greater than a first preset ratio value, the data export interface under different modes is optimized accordingly, including: adjusting the interaction process for the preset interactive mode in the interactive data export interface mode, adjusting the template style for the preset template in the template-based data export interface mode, and performing incremental training on the intelligent recommendation algorithm in the intelligent data export interface mode; if the ratio of users whose user satisfaction feedback scores for the exported data files are lower than the preset satisfaction scores to all scoring users is greater than a second preset ratio value, the data verification method in the export strategy under different usage scenarios is adjusted accordingly.

[0093] In a specific embodiment, the data export execution module 104 is also used to receive an export event triggered by a user and, when executing the export event, determine whether a conflict event occurs during the execution of the export event. If a conflict event occurs, the export event is stopped until the conflict event disappears and the export event is continued; the conflict event includes a shared data resource export conflict; the module is also used to receive an export event triggered by a user and, when executing the export event, determine whether a preset restrictive event is triggered during the execution of the export event. If a preset restrictive event is triggered, the export event is stopped until the export event disappears and the export event is continued; the preset restrictive events include data export prohibited events during a preset time period, frequent export events during a preset time period, and preset data ungraded export events.

[0094] The embodiment of the present application also discloses a computer-readable storage medium.

[0095] Specifically, the computer-readable storage medium stores a computer program that can be loaded by a processor and execute the data export method as described above. The computer-readable storage medium includes, for example: a USB flash drive, a mobile hard disk, a read-only memory (ROM), a random access memory (RAM), a magnetic disk or an optical disk, and other media that can store program codes.

[0096] The embodiment of the present application also discloses a computer device.

[0097] Specifically, the computer device includes a memory and a processor, and the memory stores a computer program that can be loaded by the processor and execute the above-mentioned data export method.

[0098] The above are all preferred embodiments of the present application, and are not intended to limit the protection scope of the present application. Any feature disclosed in this specification (including the abstract and drawings), unless otherwise stated, can be replaced by other equivalent or alternative features with similar purposes. That is, unless otherwise stated, each feature is only an example of a series of equivalent or similar features.

Claims

1. A data export method, characterized in that: include: Receive a user's mode selection instruction for the data export interface, and dynamically switch the mode of the data export interface, including: an interactive data export interface mode, a template data export interface mode, and an intelligent data export interface mode; the interactive data export interface mode displays the data table according to a preset interactive mode selected by the user, the template data export interface mode displays the data table according to a preset template selected by the user, and the intelligent data export interface mode displays the data table according to the intelligent recommendation of the user's historical exported data analysis results; Receive the data fields in the table to be exported selected by the user in the data export interface under the corresponding mode, obtain the data fields to be exported, convert and organize the data fields to be exported, and generate the data files to be exported; Machine learning technology is used to determine the usage scenario of the exported data file, and the corresponding export strategy is found based on the determined usage scenario. The exported data file is verified by using the export data verification strategy in the found export strategy; each usage scenario is provided with a preset export strategy, and each export strategy has an export data verification strategy generated by a combination of different data verification methods, and the data verification methods include: data integrity and consistency verification, data quality assessment verification, data compliance verification and data authority verification; the usage scenarios include: scientific research usage scenarios, e-commerce usage scenarios and financial usage scenarios; a first export data verification strategy is set for the scientific research usage scenario, and the data verification methods adopted by the first export data verification strategy include: data integrity and consistency verification, data quality assessment verification and data compliance verification; a second export data verification strategy is set for the e-commerce usage scenario, and the data verification methods adopted by the second export data verification strategy include: completing data integrity and consistency verification based on distributed processing technology; a third export data verification strategy is set for the financial usage scenario, and the third export data verification strategy The data verification methods adopted by the data verification strategy include: data permission verification, data integrity and consistency verification, and data compliance verification; the preset export strategy corresponding to each usage scenario includes a data file content export strategy, and the corresponding export strategy is found based on the determined usage scenario, and the data file export strategy in the found export strategy is used to adjust the data content in the exported data file; among them, the first data file content export strategy is set for the scientific research usage scenario, and the first data file content export strategy includes: data version export strategy, and export strategy for associating and labeling typical related data in the scientific research usage scenario; the second data file content export strategy is set for the e-commerce usage scenario, and the second data file content export strategy includes: export strategy for distinguishing and labeling according to the user's historical data export preference, and export strategy for labeling according to the typical data report content in the e-commerce usage scenario; the third data file content export strategy is set for the financial usage scenario, and the third data file content export strategy includes: support for multi-format compatible export strategy, and export strategy for grading according to the typical risk level of data in the financial usage scenario; When the verification of the exported data file is successful, a prompt message of triggering the export event is generated and displayed on the data export interface; the export event generated by the user trigger is received and the export event is executed to export the data file.

2. The data export method according to claim 1, characterized in that: Also includes: When receiving an export event triggered by a user and executing the export event, determine whether there is a conflicting event during the export event execution process. If there is a conflicting event, stop executing the export event until the conflicting event disappears and then continue to execute the export event; The conflict event includes a shared data resource export conflict.

3. The data export method according to claim 1, characterized in that: Also includes: When receiving an export event triggered by a user and executing the export event, determine whether a preset restrictive event is triggered during the export event execution. If the preset restrictive event is triggered, stop executing the export event until the preset restrictive event disappears and then continue to execute the export event; The preset restrictive events include a preset time period prohibited data export event, a preset time period frequent export event, and a preset data unclassified export event.

4. The data export method according to claim 1, characterized in that: Also includes: Based on the flow layout and dynamic reorganization technology, it receives the user's instructions for interface layout adjustment and function setting, adjusts the data export interface layout, and sets the function modules as required. The function modules include: data field selection area, data field sorting, format and filter condition setting column; The receiving user selects the sorting, formatting and filtering conditions of the data fields to be exported in the adjusted data export interface, and converts and organizes the data fields to be exported according to the sorting, formatting and filtering conditions, and generates the data files to be exported.

5. The data export method according to claim 1, characterized in that: Also includes: Receive user satisfaction feedback scores on the data export interface and exported data files; If the ratio of users whose user satisfaction feedback scores on the data export interface are lower than the preset satisfaction scores to all scoring users is greater than a first preset ratio value, the data export interface under different modes is optimized accordingly, including: adjusting the interactive process for the preset interactive mode in the interactive data export interface mode, adjusting the template style for the preset template in the template-based data export interface mode, and performing incremental training on the intelligent recommendation algorithm in the intelligent data export interface mode; If the ratio of users whose user satisfaction feedback scores for the exported data file are lower than the preset satisfaction scores to all scoring users is greater than a second preset ratio value, the data verification method in the export strategy for different usage scenarios is adjusted accordingly.

6. A data export system, characterized in that: include: The data export interface selection module is used to receive the user's mode selection instruction for the data export interface and dynamically switch the mode of the data export interface, including: interactive data export interface mode, template data export interface mode and intelligent data export interface mode; the interactive data export interface mode displays the data table according to the preset interactive mode selected by the user, the template data export interface mode displays the data table according to the preset template selected by the user, and the intelligent data export interface mode displays the data table according to the intelligent recommendation of the user's historical exported data analysis results; The data export selection module is used to receive the data fields in the table to be exported selected by the user in the data export interface under the corresponding mode, obtain the data fields to be exported, convert and organize the data fields to be exported, and generate the data files to be exported; A data export verification module is used to use machine learning technology to determine the usage scenario of the exported data file, find the corresponding export strategy based on the determined usage scenario, and use the export data verification strategy in the found export strategy to perform export data verification on the exported data file; each usage scenario is provided with a preset export strategy, and each export strategy has an export data verification strategy generated by a combination of different data verification methods, and the data verification methods include: data integrity and consistency verification, data quality assessment verification, data compliance verification and data authority verification; the usage scenarios include: scientific research usage scenarios, e-commerce usage scenarios and financial usage scenarios; a first export data verification strategy is set for the scientific research usage scenario, and the data verification methods adopted by the first export data verification strategy include: data integrity and consistency verification, data quality assessment verification and data compliance verification; a second export data verification strategy is set for the e-commerce usage scenario, and the data verification methods adopted by the second export data verification strategy include: completing data integrity and consistency verification based on distributed processing technology; a third export data verification strategy is set for the financial usage scenario The data verification methods adopted by the third export data verification strategy include: data permission verification, data integrity and consistency verification, and data compliance verification; the preset export strategy corresponding to each usage scenario includes a data file content export strategy, and the corresponding export strategy is found based on the determined usage scenario, and the data file export strategy in the found export strategy is used to adjust the data content in the exported data file; wherein, the first data file content export strategy is set for the scientific research usage scenario, and the first data file content export strategy includes: data version export strategy, and export strategy for associating and labeling typical related data in the scientific research usage scenario; the second data file content export strategy is set for the e-commerce usage scenario, and the second data file content export strategy includes: export strategy for distinguishing and labeling according to the user's historical data export preference, and export strategy for labeling according to the typical data report content in the e-commerce usage scenario; the third data file content export strategy is set for the financial usage scenario, and the third data file content export strategy includes: support for multi-format compatible export strategy, and export strategy for grading according to the typical risk level of data in the financial usage scenario; The data export execution module is used to generate a trigger export event prompt message and display it on the data export interface when the exported data file is successfully verified; receive the export event triggered by the user and execute the export event to export the data file.

7. A computer-readable storage medium, characterized in that: The computer-readable storage medium includes a stored computer program, wherein when the computer program is executed, the device where the computer-readable storage medium is located is controlled to execute the method according to any one of claims 1 to 5.

8. A computer device, characterized in that: The computer device comprises a memory, a processor and a program stored and executable on the memory, and the program implements the steps of the method according to any one of claims 1 to 5 when executed by the processor.

Citation Information

Patent Citations

  • Visualized data generation method based on big data system

    CN111221825A

  • File exporting method and system based on AI cloud computing

    CN118312861A