Data exporting method and device, equipment, storage medium and product

Abstract

The invention discloses a data exporting method and device, equipment, a storage medium and a product, and relates to the technical field of data processing.The data exporting method comprises the steps that a to-be-aligned exporting database and exporting data parameters are determined based on a data exporting request of a user; according to the to-be-exported field and the to-be-exported data option selected in the visual interface, obtaining to-be-exported data from each to-be-aligned export database; performing data alignment on the to-be-exported data based on the exported data parameters to obtain target exported data; and performing data export on the target exported data. The data alignment is performed on the to-be-exported data based on the exported data parameters, so that the flexible automatic alignment structured export of the queue data in a small range is realized. The actual operation time of the user is shortened, the working efficiency is improved, and the personalized cross-queue data alignment requirement is met.

Description

Technical Field

[0001] The present application relates to the field of data processing technology, and in particular to data export methods, devices, equipment, storage media and products. Background Art

[0002] Most of the existing data export processing and alignment technologies are ETL tools. The actual process of the ETL system includes extracting data from various data sources, then processing it through steps such as data cleaning, format conversion and aggregation, and finally loading the processed data into the target system, such as a data warehouse or database, for analysis and reporting. This process ensures that the data is accurate, conforms to the format of the target system, and can efficiently support business decisions.

[0003] However, under the existing solutions, fixed data standards and formats are mostly used, which are not suitable for the personalized needs of different users or systems, resulting in insufficient flexibility in data alignment and export. Summary of the invention

[0004] The main purpose of this application is to provide a data export method, device, equipment, storage medium and product, aiming to solve the technical problems in the prior art that data export does not meet personalized needs and data alignment and export flexibility are insufficient.

[0005] To achieve the above purpose, the present application proposes a data export method, which includes:

[0006] Determine the export database to be aligned and the export data parameters based on the user's data export request; the number of the export databases to be aligned is at least two;

[0007] Acquire the data to be exported from each of the alignment export databases according to the fields to be exported and the data to be exported options selected in the visualization interface;

[0008] Performing data alignment on the data to be exported based on the export data parameters to obtain target export data;

[0009] The target export data is exported.

[0010] In one embodiment, the step of performing data alignment on the data to be exported based on the export data parameters to obtain target export data includes:

[0011] Determine the data scope of the database to be exported according to the export data parameters;

[0012] The data to be exported is aligned based on the data definition within the data scope to obtain target export data.

[0013] In one embodiment, the step of performing data alignment on the data to be exported based on the data definition within the data scope to obtain target exported data includes:

[0014] Determining the to-be-converted export data having data options from the to-be-exported data of each to-be-exported database based on the data definition within the data scope;

[0015] The to-be-converted derived data is converted based on an enumeration conversion generator to obtain a standard enumeration value;

[0016] The to-be-converted export data obtained from different to-be-aligned export databases are aligned based on the standard enumeration value to obtain target export data.

[0017] In one embodiment, the step of converting the derived data to be converted based on the enumeration conversion generator to obtain a standard enumeration value includes:

[0018] Analyze the option data corresponding to the data options in the exported data to be converted based on the enumeration conversion generator to obtain an option data set;

[0019] The option data in the option data set are processed cyclically through natural language processing and its learning algorithm to obtain standard enumeration values.

[0020] In one embodiment, the step of aligning the to-be-converted derived data obtained from different to-be-aligned derived databases based on the standard enumeration value to obtain target derived data comprises:

[0021] Obtaining an enumeration pool based on the standard enumeration value corresponding to the data option;

[0022] Determining whether the enumeration pools in different to-be-aligned export databases match or are contained;

[0023] If not, the enumeration value of the enumeration pool of the data option is dynamically increased;

[0024] Generate a corresponding enumeration value mapping table based on the enumeration pool after dynamically increasing the enumeration value;

[0025] The aligned target export data is obtained based on the enumerated value mapping table.

[0026] In one embodiment, the step of exporting the target export data includes:

[0027] Get preset structured export options;

[0028] Performing typeset processing on the target export data through the preset structured export option to obtain an export data file;

[0029] The export data file is exported.

[0030] In addition, to achieve the above purpose, the present application also proposes a data export device, the data export device comprising:

[0031] A data interaction module, used to determine the export database to be aligned and the export data parameters based on the user's data export request; the number of the export database to be aligned is at least two;

[0032] A data acquisition module, used for acquiring the data to be exported from each of the alignment export databases according to the fields to be exported and the data options to be exported selected in the visualization interface;

[0033] A data alignment module, used for performing data alignment on the data to be exported based on the export data parameters to obtain target export data;

[0034] The data export module is used to export the target export data.

[0035] In addition, to achieve the above-mentioned purpose, the present application also proposes a data export device, which includes: a memory, a processor, and a computer program stored in the memory and executable on the processor, and the computer program is configured to implement the steps of the data export method described above.

[0036] In addition, to achieve the above-mentioned purpose, the present application also proposes a storage medium, which is a computer-readable storage medium, and a computer program is stored on the storage medium. When the computer program is executed by a processor, the steps of the data export method described above are implemented.

[0037] In addition, to achieve the above-mentioned purpose, the present application also provides a computer program product, which includes a computer program, and when the computer program is executed by a processor, the steps of the data export method described above are implemented.

[0038] One or more technical solutions proposed in this application have at least the following technical effects:

[0039] This application determines the export database to be aligned and the export data parameters based on the user's data export request; obtains the export data from each export database to be aligned according to the fields to be exported and the export data options to be exported selected in the visual interface; performs data alignment on the export data based on the export data parameters to obtain the target export data; and exports the target export data. Since the data alignment of the export data is based on the export data parameters, the flexible automatic alignment and structured export of queue data in a small range is realized. It reduces the actual operation time of users, improves work efficiency, and realizes personalized cross-queue data alignment requirements. BRIEF DESCRIPTION OF THE DRAWINGS

[0040] The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the present application and, together with the description, serve to explain the principles of the present application.

[0041] In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the following is a brief introduction to the drawings required for use in the embodiments or the description of the prior art. Obviously, for ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative labor.

[0042] Figure 1 A flowchart of the first embodiment of the data export method of the present application is provided;

[0043] Figure 2 A schematic diagram of data scope content in one implementation of the data export method of this application;

[0044] Figure 3 A flowchart of the second embodiment of the data export method of the present application is provided;

[0045] Figure 4 A schematic diagram of the mapping relationship between data option types and data model types in one implementation of the data export method of the present application;

[0046] Figure 5 This is a schematic diagram of the overall flow of the data alignment process in one implementation of the data export method of this application;

[0047] Figure 6 This is a simplified flowchart of the data alignment process in one implementation of the data export method of this application;

[0048] Figure 7 A flowchart of the third embodiment of the data export method of the present application is provided;

[0049] Figure 8 This is a schematic diagram of the module structure of the data export device according to an embodiment of the present application;

[0050] Fig. 9 Schematic diagram of the device structure of the hardware operating environment involved in the data export method in the embodiment of the present application.

[0051] The purpose, features and advantages of this application will be further described in conjunction with the embodiments and with reference to the accompanying drawings. DETAILED DESCRIPTION

[0052] It should be understood that the specific embodiments described herein are only used to explain the technical solutions of the present application and are not used to limit the present application.

[0053] In order to better understand the technical solution of the present application, a detailed description will be given below in conjunction with the accompanying drawings and specific implementation methods.

[0054] The main solution of the embodiment of the present application is: determine the export database to be aligned and the export data parameters based on the user's data export request; the number of export databases to be aligned is at least two; obtain the data to be exported from each export database to be aligned according to the field to be exported and the data to be exported options selected in the visual interface; align the data to be exported based on the export data parameters to obtain the target export data; and export the target export data.

[0055] At present, the existing data alignment and export solutions mostly use fixed data standards and formats, which are not suitable for the personalized needs of different users or systems, resulting in insufficient flexibility in data alignment and export. At the same time, it is difficult to enumerate and set options between multiple queues, which requires strong summarization capabilities; in addition, the automatic alignment mechanism in the existing technology usually has strict requirements on data format and structure, and it is difficult to handle inconsistent or dynamically changing data, and it is difficult to cope with various follow-up processes; moreover, the exported data structure often cannot meet the diverse needs of different users or applications.

[0056] This application provides a solution that allows users to define data annotation naming and specifications according to specific needs by introducing personalized data annotation settings and data scopes to better adapt to different business scenarios. At the same time, this application combines natural language processing and machine learning algorithms to involve an enumeration conversion generator that can dynamically generate standard enumerations within the data scope when dynamically and flexibly aligning data.

[0057] It should be noted that the execution subject of this embodiment can be a computing service device with data processing, network communication and program running functions, such as a server, a computer, etc., or an electronic device, a virtual device, etc. that can realize the above functions. The following takes a data export device (hereinafter referred to as the export device) as an example to illustrate this embodiment and the following embodiments.

[0058] Based on this, the present application embodiment provides a data export method, referring to Figure 1 , Figure 1 This is a flow chart of the first embodiment of the data export method of the present application.

[0059] In this embodiment, the data export method includes steps S10 to S40:

[0060] Step S10, determining the database to be aligned and the export data parameters based on the user's data export request;

[0061] The number of exported databases to be aligned is at least two.

[0062] It should be noted that the solution of the present application can be applied to common teaching systems and medical systems. The present application proposes a structured export technology for automatic alignment of flexible data across queues based on personalized standard settings, so as to support users' data alignment and export operations across queues of flexible databases. Specifically, the user can provide the flexible database that he wants to align and export, as well as the data definition and data scope that are consistent with the personalized settings. That is, the export device can obtain the user's data export request, which may include the database to be aligned and exported in the user's data export request, and the export data parameters, which may include parameters such as data definition and data scope.

[0063] It can be understood that in the embodiment of the present application, the number of flexible databases selected can be at least two. When exporting data alignment, the system can align the data according to the data definition within the data scope set by the user, and export the aligned data through a cross-queue data structured export file.

[0064] Step S20, acquiring the data to be exported from each of the alignment export databases according to the fields to be exported and the data options to be exported selected in the visualization interface;

[0065] It should be noted that, in order to facilitate the export of data, the method of the embodiment of the present application also proposes a visual interface. Through the visual interface, the user can select the fields to be exported and the data options to be exported in each (flexible) database, and then export these fields to be exported and the data options to be exported from the corresponding export database to be aligned to obtain the data to be exported.

[0066] It is understandable that the fields in the embodiments of the present application may include data fields such as name, modification time, contact information, etc., and the embodiments of the present application are not limited to this. The data options in the embodiments of the present application may include functional options such as input boxes, number input boxes, date input boxes, radio boxes, multiple selection boxes, and drop-down selection boxes, and the embodiments of the present application are not limited to this.

[0067] It should be understood that different export fields and export data options may be provided for different export databases to be aligned. In order to meet the personalized standard setting and diversified export requirements of users, data alignment may be performed on the export data exported from these export databases to be aligned.

[0068] Step S30, aligning the data to be exported based on the export data parameters to obtain target export data;

[0069] It should be noted that the above-mentioned export data parameters may include a data scope, and data alignment may be achieved based on the data definition within the set data scope.

[0070] It should be explained that in order to better accommodate the automatic alignment and export requirements of the user's routine research cohort and personalized follow-up cohort in the embodiments of the present application, the present application also proposes a data model that combines data definition and data scope. The model covers several key components: data field definition, data type, data relationship, data mapping, and the newly introduced data scope. Among them, the data scope, as the classification and range boundary of data alignment, gives the data model higher flexibility and accuracy.

[0071] In the specific implementation, you can refer to Figure 2 As shown, the data scope in the embodiment of the present application can be used to define the specific scope and classification rules of data alignment, which is particularly important for the follow-up scale data that repeats in the processing queue. Through the application of data scope, the method of the present application can accurately identify and correspond to data fields, ensuring that the same scale variable only needs to be defined once, and efficient reuse can be achieved in different queues, different stages and different processes. The application is determined by individualizing the scale involved in the process (the scale may include fields) to determine the data scope corresponding to the process, which may include parameters or data such as data definition, data type, and data mapping. Through the data scope of the embodiment of the present application, the need for redundant definitions can be effectively reduced, and the potential errors caused by repeated data settings are reduced.

[0072] Specifically, the step of performing data alignment on the data to be exported based on the export data parameters to obtain target export data includes:

[0073] Determine the data scope of the database to be exported according to the export data parameters;

[0074] The data to be exported is aligned based on the data definition within the data scope to obtain target export data.

[0075] Step S40, exporting the target export data.

[0076] It can be understood that when the aligned target export data is determined, the target export data can be subjected to data export processing.

[0077] The embodiment of the present application determines the export database to be aligned and the export data parameters based on the user's data export request; obtains the export data from each export database to be aligned according to the fields to be exported and the data options to be exported selected in the visual interface; performs data alignment on the export data based on the export data parameters to obtain the target export data; and exports the target export data. Since the data alignment is performed on the export data based on the export data parameters, the flexible automatic alignment and structured export of the queue data in a small range is realized. The actual operation time of the user is reduced, the work efficiency is improved, and the personalized cross-queue data alignment requirements are realized.

[0078] Based on the first embodiment of the present application, in the second embodiment of the present application, the same or similar contents as those in the above-mentioned embodiment 1 can be referred to the above introduction, and will not be repeated in the following. Figure 3 In an embodiment of the present application, the step of aligning the data to be exported based on the data definition within the data scope to obtain the target exported data includes:

[0079] Step S310, determining the to-be-converted export data having data options from the to-be-exported data of each to-be-exported database based on the data definition within the data scope;

[0080] It should be noted that the data model in the present application can support dynamic adjustment and expansion functions, wherein the data type can be determined based on the summary. In the present application, the data type in the data scope can be set to three main types: normal type (NORMAL), single-choice enumeration type (RADIO) and multiple-choice enumeration type (CHECKBOX). Different data types can correspond to different data models. Through this solution, the method of the present application can still maintain stable performance and accurate data alignment when facing a sharp increase in data volume or changes in data structure. The above design of the present application improves the flexibility and scalability of the system, which is crucial for processing large-scale data integration or complex research designs. Specifically, please refer to Figure 4 As shown, the types of questions (data options) in the queue database in the embodiment of the present application may include input boxes, number input boxes, date input boxes, single-choice questions, multiple-choice questions, drop-down questions, etc. Among them, there may be mapping relationships: mapping between input boxes, number input boxes, date input boxes and conventional types, mapping between single-choice questions, drop-down questions and single-choice enumeration types, and mapping between multiple-choice questions and multiple-choice enumeration types.

[0081] It should be explained that the method of the embodiment of the present application not only optimizes the data alignment process but also improves the overall efficiency of data management through precise data scope definition and efficient data mapping. Through the combination of data field definition and data scope, data processing is made more systematic and modular, which greatly improves the maintainability and consistency of data, thereby meeting diverse research needs and complex follow-up data management tasks.

[0082] Step S320, transforming the to-be-transformed derived data based on the enumeration transformation generator to obtain a standard enumeration value;

[0083] In one implementation of the embodiment of the present application, Figure 4 As shown, the embodiment of the present application designs an enumeration conversion generator based on semantic recognition and machine learning, which can efficiently generate enumeration options during the process of automatic data alignment, especially when processing structural alignment. When faced with the type of questions (i.e., drop-down lists or options) that require setting enumeration options, such as single-choice, multiple-choice, and drop-down lists, the enumeration conversion generator proposed in the present application will automatically perform in-depth semantic analysis on data options with the same definition fields under the same data scope. Using natural language processing (NLP) technology and machine learning algorithms, the method of the present application can perform semantic recognition on data options in the exported data, and intelligently merge based on word meanings and contextual relationships, thereby generating a set of options after deduplication.

[0084] It should be noted that the generated option set can be arranged in natural number order to form an enumeration mapping list. This enumeration mapping list can be saved in an alignment table, which provides convenience and standard mapping for subsequent data alignment and standardization processes. The method of the present application maximizes the flexibility of data alignment and can handle user-personalized fields and non-standard option content well. Specifically, the step of converting the derived data to be converted based on the enumeration conversion generator to obtain a standard enumeration value includes:

[0085] Analyze the option data corresponding to the data options in the exported data to be converted based on the enumeration conversion generator to obtain an option data set;

[0086] The option data in the option data set are processed cyclically through natural language processing and its learning algorithm to obtain standard enumeration values.

[0087] Step S330, aligning the export data to be converted obtained from different export databases to be aligned based on the standard enumeration value to obtain target export data.

[0088] In one implementation of the embodiment of the present application, the alignment process of the embodiment of the present application can refer to Figure 5 , based on the data model and enumeration conversion generator in this application, this application also designs a flexible queue data alignment strategy. This strategy first subdivides the data model by data scope, and unifies the data model according to the field order within the data scope. The data models in multiple queues are merged within the same data scope and sorted in a predefined order to form a systematic alignment strategy. Through the strategy of this application, it can be ensured that the data accurately implements the process-to-process and data-to-data mapping rules during the alignment process, thereby achieving efficient and on-demand automated alignment. In addition, through the method of this application, it is also possible to flexibly adjust the data structure, support dynamic updates and expansions, optimize the alignment process of the flexible queue database, and improve data consistency and processing efficiency.

[0089] Reference Figure 6 In an embodiment of the present application, at least two queue databases (databases to be aligned and exported) may be included, which may include single-choice questions, multiple-choice questions, drop-down questions and other data options. A single-question option set is composed of data options. By conducting in-depth semantic analysis on these option data, and using natural language processing (NLP) technology and machine learning algorithms, single-question options are split and intelligently merged based on word meaning and contextual relationship, and a deduplicated option set can be obtained. Based on the mapping between the question (data option) type and the data type in the queue database, a standard enumeration value (the figure shows a standardized enumeration value) can be determined. By judging whether the enumeration pool corresponding to the single-question option set contains the same enumeration pool, if not, it can be merged based on the enumeration pools corresponding to different queue databases, realizing the dynamic increase of the single-question enumeration pool, and finally realizing the dynamic maintenance of the enumeration pool, realizing the alignment between different databases, and obtaining the aligned enumeration value mapping table. Specifically, the step of aligning the export data to be converted obtained from different export databases to be aligned based on the standard enumeration value to obtain the target export data includes: obtaining an enumeration pool based on the standard enumeration value corresponding to the data option; judging whether the enumeration pools in different export databases to be aligned match or contain each other; if not, dynamically increasing the enumeration value of the enumeration pool of the data option; generating a corresponding enumeration value mapping table according to the enumeration pool after the dynamic increase of the enumeration value; and obtaining the aligned target export data based on the enumeration value mapping table.

[0090] Understandably, Figure 6 In the embodiment shown, the data to be exported in the two queues (queue 1 and queue 2) include three different scopes, namely SF1, SF2 and SF3. The data model TIME is included in each data scope. The final aligned data is obtained by splitting the option data in different queues and merging the data of the same scope and data model in the single-question data set obtained by the split.

[0091] The embodiment of the present application determines the export data to be converted with data options in the export data of each database to be exported based on the data definition within the data scope; converts the export data to be converted based on the enumeration conversion generator to obtain standard enumeration values; aligns the export data to be converted obtained from different export databases to be aligned based on the standard enumeration values ​​to obtain target export data. Due to the introduction of personalized data standard settings and scopes, users are allowed to define data standard naming and specifications according to specific needs to better adapt to different business scenarios. At the same time, the present application combines natural language processing and machine learning algorithms to realize an enumeration conversion generator that can dynamically generate standard enumerations within the scope when dynamically and flexibly aligning data.

[0092] Based on the first embodiment and / or the second embodiment of the present application, in the third embodiment of the present application, the same or similar contents as those of the above-mentioned first embodiment and / or the second embodiment can refer to the above introduction, and will not be repeated later. Figure 7 In an embodiment of the present application, the step of exporting the target export data includes:

[0093] Step S41, obtaining preset structured export options;

[0094] Step S42, performing typeset processing on the target export data through the preset structured export option to obtain an export data file;

[0095] Step S43, exporting the export data file.

[0096] It should be noted that in the embodiments of the present application, in order to meet the data analysis and use requirements of various clinical cohort studies, the present application can use preset structured export options for data export, and provide a variety of structured setting options. The user can choose whether to export privacy information, add filtering conditions, select export fields, and can customize the typesetting format, such as exporting data in sequence, exporting fixed stages separately from repeatable stages, and periodically exporting repeatable stages (such as 4-week, 8-week, and 16-week medical records of patients). The above-mentioned preset structured export options can be exported in Excel format, or in Json format or other formats, and the embodiments of the present application are not limited to this.

[0097] It is understandable that by implementing periodic export through periodic settings, the data in each period can be automatically exported, so that users do not need to perform manual operations, thereby improving user convenience.

[0098] It should be explained that, in order to facilitate data filtering, this application can use the MongDB unstructured database to store the aligned data. At the same time, the user can set multiple filters when exporting data, and the system will perform a combined search based on these conditions during the export process, and only export data that meets all the conditions.

[0099] In an implementation of an embodiment of the present application, in order to ensure system fluency, the present application can use SxssfSheet to export data, using line-by-line writing rather than loading the entire file at one time, thereby significantly reducing memory usage. Through the solution of the present application, large amounts of data can be efficiently processed, and larger data sets can be processed to meet the needs of large-scale queue research. At the same time, in terms of data security, the solution of the present application can also protect data in the form of encrypted export. When the export file is generated, it is encrypted, and the password is sent to the user via SMS, email or other means, thereby improving the security of the exported data.

[0100] The embodiment of the present application obtains preset structured export options; typesets the target export data through the preset structured export options to obtain an export data file; and exports the export data file. Since the target export data is typeset before exporting, the readability of the export data is improved, and data encryption, data filtering and other operations can also be performed, thereby improving the security and convenience of data export.

[0101] It should be noted that the above examples are only used to understand the present application and do not constitute a limitation on the data export method of the present application. More simple transformations based on this technical concept are all within the scope of protection of the present application.

[0102] This application also provides a data export device, please refer to Figure 8 , the data export device comprises:

[0103] A data interaction module 10 is used to determine the database to be aligned and the export data parameters based on the user's data export request; the number of the database to be aligned and the export data is at least two;

[0104] A data acquisition module 20, used for acquiring the data to be exported from each of the alignment export databases according to the fields to be exported and the data options to be exported selected in the visualization interface;

[0105] A data alignment module 30, configured to perform data alignment on the data to be exported based on the export data parameters to obtain target export data;

[0106] The data export module 40 is used to export the target export data.

[0107] The data export device provided by the present application adopts the data export method in the above embodiment, which can solve the technical problems in the prior art that data export does not meet personalized needs and data alignment and export flexibility are insufficient. Compared with the prior art, the beneficial effects of the data export device provided by the present application are the same as the beneficial effects of the data export method provided by the above embodiment, and the other technical features in the data export device are the same as the features disclosed in the above embodiment method, which will not be repeated here.

[0108] The present application provides a data export device, which includes: at least one processor; and a memory communicatively connected to the at least one processor; wherein the memory stores instructions executable by the at least one processor, and the instructions are executed by the at least one processor so that the at least one processor can execute the data export method in the above-mentioned embodiment one.

[0109] Reference below Fig. 9 , which shows a schematic diagram of the structure of a data export device suitable for implementing the embodiment of the present application. The data export device in the embodiment of the present application may include but is not limited to mobile terminals such as mobile phones, laptop computers, digital broadcast receivers, PDAs (Personal Digital Assistants), PADs (Portable Application Descriptions), PMPs (Portable Media Players), vehicle-mounted terminals (such as vehicle-mounted navigation terminals), etc., and fixed terminals such as digital TVs, desktop computers, etc. Fig. 9 The data export device shown is merely an example and should not bring any limitation to the functions and scope of use of the embodiments of the present application.

[0110] like Fig. 9As shown, the data export device may include a processing device 1001 (e.g., a central processing unit, a graphics processor, etc.), which can perform various appropriate actions and processes according to a program stored in a read-only memory (ROM: Read Only Memory) 1002 or a program loaded from a storage device 1003 to a random access memory (RAM: Random Access Memory) 1004. In RAM1004, various programs and data required for the operation of the data export device are also stored. The processing device 1001, ROM1002, and RAM1004 are connected to each other through a bus 1005. An input / output (I / O) interface 1006 is also connected to the bus. Generally, the following systems can be connected to the I / O interface 1006: an input device 1007 including, for example, a touch screen, a touch pad, a keyboard, a mouse, an image sensor, a microphone, an accelerometer, a gyroscope, etc.; an output device 1008 including, for example, a liquid crystal display (LCD: Liquid Crystal Display), a speaker, a vibrator, etc.; a storage device 1003 including, for example, a magnetic tape, a hard disk, etc.; and a communication device 1009. The communication device 1009 can allow the data export device to communicate with other devices wirelessly or by wire to exchange data. Although the data export device with various systems is shown in the figure, it should be understood that it is not required to implement or have all the systems shown. More or fewer systems can be implemented or have alternatively.

[0111] In particular, according to the embodiments disclosed in the present application, the process described above with reference to the flowchart can be implemented as a computer software program. For example, the embodiments disclosed in the present application include a computer program product, which includes a computer program carried on a computer-readable medium, and the computer program includes a program code for executing the method shown in the flowchart. In such an embodiment, the computer program can be downloaded and installed from a network through a communication device, or installed from a storage device 1003, or installed from a ROM 1002. When the computer program is executed by the processing device 1001, the above-mentioned functions defined in the method of the embodiment disclosed in the present application are executed.

[0112] The data export device provided by the present application adopts the data export method in the above embodiment, which can solve the technical problems in the prior art that data export does not meet personalized needs and data alignment and export flexibility are insufficient. Compared with the prior art, the beneficial effects of the data export device provided by the present application are the same as the beneficial effects of the data export method provided by the above embodiment, and other technical features in the data export device are the same as the features disclosed in the method of the previous embodiment, which will not be repeated here.

[0113] It should be understood that the various parts disclosed in this application can be implemented by hardware, software, firmware or a combination thereof. In the description of the above embodiments, specific features, structures, materials or characteristics can be combined in any one or more embodiments or examples in a suitable manner.

[0114] The above is only a specific implementation of the present application, but the protection scope of the present application is not limited thereto. Any person skilled in the art who is familiar with the present technical field can easily think of changes or substitutions within the technical scope disclosed in the present application, which should be included in the protection scope of the present application. Therefore, the protection scope of the present application should be based on the protection scope of the claims.

[0115] The present application provides a computer-readable storage medium having computer-readable program instructions (ie, computer programs) stored thereon, wherein the computer-readable program instructions are used to execute the data export method in the above-mentioned embodiment.

[0116] The computer-readable storage medium provided in the present application may be, for example, a USB flash drive, but is not limited to electrical, magnetic, optical, electromagnetic, infrared, or semiconductor systems, systems or devices, or any combination of the above. More specific examples of computer-readable storage media may include, but are not limited to: an electrical connection with one or more wires, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the above. In this embodiment, the computer-readable storage medium may be any tangible medium containing or storing a program that can be used by or in combination with an instruction execution system, system or device. The program code contained on the computer-readable storage medium may be transmitted using any appropriate medium, including but not limited to: wires, optical cables, RF (Radio Frequency), etc., or any suitable combination of the above.

[0117] The computer-readable storage medium may be included in the data export device; or it may exist independently without being assembled into the data export device.

[0118] The computer-readable storage medium carries one or more programs. When the one or more programs are executed by the data export device, the data export device:

[0119] Determine the export database to be aligned and the export data parameters based on the user's data export request; the number of the export databases to be aligned is at least two;

[0120] Acquire the data to be exported from each of the alignment export databases according to the fields to be exported and the data to be exported options selected in the visualization interface;

[0121] Performing data alignment on the data to be exported based on the export data parameters to obtain target export data;

[0122] The target export data is exported.

[0123] Computer program code for performing the operations of the present application may be written in one or more programming languages ​​or a combination thereof, including object-oriented programming languages ​​such as Java, Smalltalk, C++, and conventional procedural programming languages ​​such as "C" or similar programming languages. The program code may be executed entirely on the user's computer, partially on the user's computer, as a separate software package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any type of network, including a local area network (LAN) or a wide area network (WAN), or may be connected to an external computer (e.g., via the Internet using an Internet service provider).

[0124] The flow chart and block diagram in the accompanying drawings illustrate the possible architecture, function and operation of the system, method and computer program product according to various embodiments of the present application. In this regard, each square box in the flow chart or block diagram can represent a module, a program segment or a part of a code, and the module, the program segment or a part of the code contains one or more executable instructions for realizing the specified logical function. It should also be noted that in some alternative implementations, the functions marked in the square box can also occur in a sequence different from that marked in the accompanying drawings. For example, two square boxes represented in succession can actually be executed substantially in parallel, and they can sometimes be executed in the opposite order, depending on the functions involved. It should also be noted that each square box in the block diagram and / or flow chart, and the combination of the square boxes in the block diagram and / or flow chart can be implemented with a dedicated hardware-based system that performs a specified function or operation, or can be implemented with a combination of dedicated hardware and computer instructions.

[0125] The modules involved in the embodiments described in this application may be implemented by software or hardware, wherein the name of the module does not constitute a limitation on the unit itself in some cases.

[0126] The readable storage medium provided by the present application is a computer-readable storage medium, which stores computer-readable program instructions (i.e., computer programs) for executing the above-mentioned data export method, and can solve the technical problems that the data export in the prior art does not meet the personalized needs, and the data alignment and export flexibility are insufficient. Compared with the prior art, the beneficial effects of the computer-readable storage medium provided by the present application are the same as the beneficial effects of the data export method provided by the above-mentioned embodiment, and will not be repeated here.

[0127] The present application also provides a computer program product, including a computer program, which implements the steps of the above-mentioned data export method when executed by a processor.

[0128] The computer program product provided by the present application can solve the technical problems in the prior art that data export does not meet personalized needs and data alignment and export flexibility are insufficient. Compared with the prior art, the beneficial effects of the computer program product provided by the present application are the same as the beneficial effects of the data export method provided by the above embodiment, which will not be described in detail here.

[0129] The above descriptions are only some embodiments of the present application, and are not intended to limit the patent scope of the present application. All equivalent structural changes made using the contents of the present application specification and drawings under the technical concept of the present application, or direct / indirect applications in other related technical fields are included in the patent protection scope of the present application.

Claims

1. A data export method, characterized in that: The method comprises: Determine the export database to be aligned and the export data parameters based on the user's data export request; the number of the export databases to be aligned is at least two; Acquire the data to be exported from each of the alignment export databases according to the fields to be exported and the data to be exported options selected in the visualization interface; Performing data alignment on the data to be exported based on the export data parameters to obtain target export data; The target export data is exported.

2. The data export method according to claim 1, characterized in that: The step of performing data alignment on the data to be exported based on the export data parameters to obtain target export data comprises: Determine the data scope of the database to be exported according to the export data parameters; The data to be exported is aligned based on the data definition within the data scope to obtain target export data.

3. The data export method according to claim 2, characterized in that: The step of aligning the data to be exported based on the data definition within the data scope to obtain target exported data comprises: Determining the to-be-converted export data having data options from the to-be-exported data of each to-be-exported database based on the data definition within the data scope; The to-be-converted derived data is converted based on an enumeration conversion generator to obtain a standard enumeration value; The to-be-converted export data obtained from different to-be-aligned export databases are aligned based on the standard enumeration value to obtain target export data.

4. The data export method according to claim 3, characterized in that: The step of converting the derived data to be converted based on the enumeration conversion generator to obtain a standard enumeration value includes: Analyze the option data corresponding to the data options in the exported data to be converted based on the enumeration conversion generator to obtain an option data set; The option data in the option data set are processed cyclically through natural language processing and its learning algorithm to obtain standard enumeration values.

5. The data export method according to claim 4, characterized in that: The step of aligning the to-be-converted derived data obtained from different to-be-aligned derived databases based on the standard enumeration value to obtain target derived data comprises: Obtaining an enumeration pool based on the standard enumeration value corresponding to the data option; Determining whether the enumeration pools in different to-be-aligned export databases match or are contained; If not, the enumeration value of the enumeration pool of the data option is dynamically increased; Generate a corresponding enumeration value mapping table based on the enumeration pool after dynamically increasing the enumeration value; The aligned target export data is obtained based on the enumerated value mapping table.

6. The data export method according to claim 1, characterized in that: The step of exporting the target export data comprises: Get preset structured export options; Performing typeset processing on the target export data through the preset structured export option to obtain an export data file; The export data file is exported.

7. A data export device, characterized in that: The data export device comprises: A data interaction module, used to determine the export database to be aligned and the export data parameters based on the user's data export request; the number of the export database to be aligned is at least two; A data acquisition module, used for acquiring the data to be exported from each of the alignment export databases according to the fields to be exported and the data options to be exported selected in the visualization interface; A data alignment module, used for performing data alignment on the data to be exported based on the export data parameters to obtain target export data; The data export module is used to export the target export data.

8. A data export device, characterized in that: The device comprises: a memory, a processor, and a data export program stored in the memory and executable on the processor, wherein the data export program is configured to implement the steps of the data export method according to any one of claims 1 to 6.

9. A storage medium, characterized in that: The storage medium stores a data export program, which, when executed by a processor, implements the steps of the data export method according to any one of claims 1 to 6.

10. A computer program product, characterized in that The computer program product comprises a computer program, and when the computer program is executed by a processor, the steps of the data export method according to any one of claims 1 to 6 are implemented.

Images