Multi-system data processing method, device, equipment, medium and program product
Through unified mapping, filtering, cleaning and integration of data in old and new systems, the problems of diverse data formats and variable fields are solved, and data compatibility and efficient query processing are realized.
Patent Information
- Application Number
- CN202411101769.2
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-08-12
- Publication Date
- 2024-12-13
- Estimated Expiration
- Not applicable · inactive patent
AI Technical Summary
The data formats and fields between the old and new systems are diverse, resulting in complex data compatibility and integration, affecting query and processing efficiency.
By obtaining the data of the old and new systems, uniformly map it to the specified field name, data filtering, cleaning and integration are performed, and finally persisting is performed to communicate with the database and transmit it to the database.
It realizes the compatibility and integration of data between old and new systems, eliminates data logic and structural defects, and improves data effectiveness and query and processing efficiency.
Smart Images
Figure CN119127849A_ABST
Abstract
Description
Technical Field
[0001] The present application relates to the field of data processing technology, and in particular to a multi-system data processing method, device, equipment, medium and program product. Background Art
[0002] The company's business is developing rapidly, and a large number of new application systems have been born in the process of development, which has also led to problems in data interaction and management between new and old systems. For example, there are problems with data inconsistency and difficulty in management, and there are a lot of redundant codes for data compatibility and integration in development, and data query performance poses a great challenge. The data in the application system is complex and difficult to manage, which seriously affects the query and processing efficiency, and also causes a waste of development and operation resources, which cannot meet the pressure brought by the growing business.
[0003] The existing technology implementation scheme is very complicated and bloated. For each data query logic, a large amount of redundant program code is required for data integration and logic processing, which limits the development workload and efficiency. It also leads to poor query performance due to data integration between new and old systems. At the same time, it also brings high server costs and causes waste of resources.
[0004] Therefore, a multi-system data processing method is urgently needed to solve the problem that the new system data generated by the ever-expanding new business and the old system data retained historically have diverse data formats, changing fields, and overly complex data compatibility and integration, which affects the query and processing efficiency. Summary of the invention
[0005] The main purpose of this application is to provide a multi-system data processing method, device, equipment, medium and program product, aiming to solve the technical problems that the new system data generated by the ever-expanding new business and the old system data retained historically have diverse data formats, variable fields, and overly complex data compatibility and integration, which affect the query and processing efficiency.
[0006] To achieve the above objectives, the present application proposes a multi-system data processing method, the method comprising:
[0007] Obtain new system data before mapping and old system data before mapping;
[0008] The new system data before mapping and the old system data before mapping are uniformly mapped to the specified field name to obtain the new system data after mapping and the old system data after mapping;
[0009] Performing logic maintenance processing on the mapped new system data and the mapped old system data to obtain target system data; wherein the logic maintenance processing at least includes data filtering, data cleaning and data integration;
[0010] The target system data is persistently processed so that the target system data maintains a communication connection with the database, and the target system data is transmitted to the database.
[0011] In one embodiment, before the step of mapping the pre-mapping new system data and the pre-mapping old system data to a specified field name to obtain the post-mapping new system data and the post-mapping old system data, the step further includes:
[0012] Import the mapper's dependency package;
[0013] A mapping rule of the mapper is defined so that the system data has the specified field name after being mapped; wherein the cleaner attribute in the mapping rule represents the corresponding relationship between the specified field of the mapping rule and the cleaner.
[0014] In one embodiment, the step of performing logic maintenance processing on the mapped new system data and the mapped old system data to obtain the target system data includes:
[0015] Performing data filtering processing on the field contents in the mapped new system data and the mapped old system data to obtain filtered new system data and filtered old system data;
[0016] Performing data cleaning on the filtered new system data and the filtered old system data to obtain cleaned new system data and cleaned old system data;
[0017] The fields in the cleaned new system data and the cleaned old system data are grouped and integrated according to entity definitions to form complete entity data, so as to obtain the target system data.
[0018] In one embodiment, the step of performing data filtering processing on the field contents in the mapped new system data and the mapped old system data to obtain the filtered new system data and the filtered old system data comprises:
[0019] Performing data format verification and conversion on the mapped new system data and the mapped old system data, so that different data formats in the mapped new system data and the mapped old system data are converted into the same data format, thereby obtaining formatted new system data and formatted old system data;
[0020] The formatted new system data and the formatted old system data are validated and filtered to obtain the filtered new system data and the filtered old system data; wherein the validation content of the validation at least includes the field length and the field content range.
[0021] In one embodiment, the step of performing data cleaning on the filtered new system data and the filtered old system data to obtain cleaned new system data and cleaned old system data includes:
[0022] Based on the method of querying the third-party service to obtain complete data, the missing field contents in the filtered new system data and the filtered old system data are supplemented to obtain supplemented new system data and supplemented old system data;
[0023] Based on field rules, the supplemented new system data and the supplemented old system data are logically cleaned to obtain the cleaned new system data and the cleaned old system data; wherein the field rules include nickname length rules, field truncation rules and content selection rules.
[0024] In one embodiment, the step of performing persistence processing on the target system data so as to transfer the target system data to the database includes:
[0025] Using a persister to physically encapsulate the target system data to obtain encapsulated data; wherein the encapsulated data is structured data that can communicate with an Elasticsearch database;
[0026] The persister is used to establish a communication connection with the Elasticsearch database, and the encapsulated data is transmitted to the Elasticsearch database.
[0027] In addition, to achieve the above-mentioned purpose, the present application also proposes a multi-system data processing device, the multi-system data processing device comprising:
[0028] A data acquisition module, used to acquire new system data before mapping and old system data before mapping;
[0029] A mapper module, used for uniformly mapping the new system data before mapping and the old system data before mapping into a specified field name to obtain the new system data after mapping and the old system data after mapping;
[0030] A cleaner module, used for performing logic maintenance processing on the mapped new system data and the mapped old system data to obtain target system data; wherein the logic maintenance processing at least includes data filtering, data cleaning and data integration;
[0031] The persistence module is used to perform persistence processing on the target system data so as to keep the target system data in communication connection with the database and transmit the target system data to the database.
[0032] In addition, to achieve the above objectives, the present application also proposes a multi-system data processing device, which includes: a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the computer program is configured to implement the steps of the multi-system data processing method as described above.
[0033] In addition, to achieve the above objectives, the present application also proposes a storage medium, which is a computer-readable storage medium, on which a computer program is stored, and when the computer program is executed by a processor, the steps of the multi-system data processing method described above are implemented.
[0034] 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 multi-system data processing method described above are implemented.
[0035] One or more technical solutions proposed in this application have at least the following technical effects:
[0036] The present application provides a multi-system data processing method, which first obtains new system data before mapping and old system data before mapping; uniformly maps the new system data before mapping and the old system data before mapping to specified field names to obtain new system data after mapping and old system data after mapping; performs logical maintenance processing on the new system data after mapping and the old system data after mapping to obtain target system data; wherein the logical maintenance processing at least includes data filtering, data cleaning and data integration; performs persistence processing on the target system data to keep the target system data in communication connection with a database, and transmits the target system data to the database.
[0037] The technical solution of the present application uniformly maps the new system data and the old system data, and the mapped new system data and the mapped old system data have a unified designated field name, providing a basis for subsequent logical maintenance processing. After the mapped new system data and the mapped old system data are processed through logical maintenance, the target system data obtained conforms to the unified data structure logic; the target system data is then persisted so that the target system data maintains a communication connection with the database, and the target system data is transferred to the database to provide complete data for data display query and processing. After the above processing, the original new system data and the old system data can finally be compatible and integrated together, and the logical defects and data structure defects in the data are eliminated, effectively improving the validity of the data as well as the query efficiency and processing efficiency of the data. BRIEF DESCRIPTION OF THE DRAWINGS
[0038] 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.
[0039] In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, for ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative labor.
[0040] Figure 1 A flowchart diagram of the first embodiment of the multi-system data processing method of the present application;
[0041] Figure 2 This is a schematic diagram of the module structure of a multi-system data processing device in an embodiment of the present application;
[0042] Figure 3 Schematic diagram of the device structure of the hardware operating environment involved in the multi-system data processing method in the embodiment of the present application.
[0043] 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
[0044] 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.
[0045] 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.
[0046] The main solution of the embodiment of the present application is: obtaining new system data before mapping and old system data before mapping; uniformly mapping the new system data before mapping and the old system data before mapping to specified field names to obtain new system data after mapping and old system data after mapping; performing logical maintenance processing on the new system data after mapping and the old system data after mapping to obtain target system data; wherein the logical maintenance processing at least includes data filtering, data cleaning and data integration; performing persistence processing on the target system data to keep the target system data in communication connection with the database, and transmitting the target system data to the database.
[0047] In this embodiment, for ease of description, the following description is made with the computing terminal as the execution subject.
[0048] Due to the rapid development of the company's business, a large number of new application systems have been born in the process of development, and the problems of data interaction and management between the old and new systems have also arisen. For example, there are problems with inconsistent and difficult to manage data, and there are a lot of redundant codes for data compatibility and integration in development, and the performance of data query poses a great challenge. The data in the application system is complicated and difficult to manage, which seriously affects the query and processing efficiency, and also causes a waste of development and operation resources, which cannot meet the pressure brought by the growing business.
[0049] The existing technology implementation scheme is very complicated and bloated. For each data query logic, a large amount of redundant program code is required for data integration and logic processing, which limits the development workload and efficiency. It also leads to poor query performance due to data integration between new and old systems. At the same time, it also brings high server costs and causes waste of resources.
[0050] Therefore, a multi-system data processing method is urgently needed to solve the problem that the new system data generated by the ever-expanding new business and the old system data retained historically have diverse data formats, changing fields, and overly complex data compatibility and integration, which affects the query and processing efficiency.
[0051] Based on this, an embodiment of the present application proposes a solution. The present application first obtains the new system data before mapping and the old system data before mapping; uniformly maps the new system data before mapping and the old system data before mapping to specified field names to obtain the new system data after mapping and the old system data after mapping; performs logical maintenance processing on the new system data after mapping and the old system data after mapping to obtain target system data; wherein the logical maintenance processing includes at least data filtering, data cleaning and data integration; performs persistence processing on the target system data to keep the target system data in communication with the database, and transmits the target system data to the database.
[0052] The technical solution of the present application uniformly maps the new system data and the old system data, and the mapped new system data and the mapped old system data have a unified designated field name, providing a basis for subsequent logical maintenance processing. After the mapped new system data and the mapped old system data are processed by logical maintenance, the target system data obtained conforms to the unified data structure logic; the target system data is then persisted so that the target system data maintains a communication connection with the database, and the target system data is transferred to the database to provide complete data for data display, query and processing. After the above processing, the original new system data and the old system data can finally be compatible and integrated together, and the logical defects and data structure defects in the data are eliminated, effectively improving the validity of the data and the efficiency of querying and processing the data.
[0053] It should be noted that the execution subject of this embodiment may be a computing service device with data processing, network communication and program running functions, such as a tablet computer, a personal computer, a mobile phone, etc., or an electronic device capable of realizing the above functions, a computing terminal, etc. The following takes a computing terminal as an example to illustrate this embodiment and the following embodiments.
[0054] Based on this, the first embodiment of the present application provides a multi-system data processing method, referring to Figure 1 , Figure 1 This is a flowchart of the first embodiment of the multi-system data processing method of the present application.
[0055] In this embodiment, the multi-system data processing method includes steps S10 to S60:
[0056] Step S10, obtaining new system data before mapping and old system data before mapping;
[0057] It should be noted that the new system data before mapping refers to the unprocessed, original new system data, which may be the new system data generated by the new business; the old system data before mapping refers to the unprocessed, original old system data, which may be the old system data retained for history.
[0058] It is understandable that there may be differences in the format, logic, etc. between the new and old system data, so the new system data and the old system data need to be processed to facilitate subsequent query processing.
[0059] Step S40, mapping the new system data before mapping and the old system data before mapping into designated field names to obtain the new system data after mapping and the old system data after mapping;
[0060] It should be noted that mapping refers to mapping data from a field or attribute of one system to a corresponding field of another system. The specified field name may include field names such as ID and name, and the custom field name may be set according to actual needs. For example, in the old system data, the user ID field name may be "UserID", "comment_id", etc., and the user ID field name in the new system data may be "Uid", "id", etc. After mapping, the mapped new system data and the mapped old system data may both have the specified field name "name".
[0061] In step S40, the new system data before mapping and the old system data before mapping are uniformly mapped to designated field names, thereby providing a basis for subsequent logic maintenance processing.
[0062] Step S50, performing logic maintenance processing on the mapped new system data and the mapped old system data to obtain target system data; wherein the logic maintenance processing at least includes data filtering, data cleaning and data integration;
[0063] It should be noted that data filtering refers to selecting a subset of data from a data set that meets specific conditions. Data cleaning refers to identifying and correcting errors, inconsistencies, duplications, or missing values in a data set; data integration refers to merging data from different sources into a unified, consistent data set.
[0064] Step S60, performing persistence processing on the target system data so as to keep the target system data in communication connection with the database, and transmitting the target system data to the database.
[0065] In the first embodiment of the present application, a multi-system data processing method is provided, which uniformly maps the new system data and the old system data, so that the mapped new system data and the mapped old system data have a unified designated field name, providing a basis for subsequent logical maintenance processing. After the mapped new system data and the mapped old system data are processed by logical maintenance, the target system data obtained conforms to the unified data structure logic; the target system data is then persisted so that the target system data maintains a communication connection with the database, and the target system data is transmitted to the database to provide complete data for data display query and processing. After the above processing, the original new system data and the old system data can finally be compatible and integrated together, and the logical defects and data structure defects in the data are eliminated, effectively improving the validity of the data as well as the query efficiency and processing efficiency of the data.
[0066] 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 first embodiment can be referred to the above description, and will not be repeated hereafter. On this basis, before step S40, the multi-system data processing method further includes steps S20 to S30:
[0067] Step S20, introducing the dependency package of the mapper;
[0068] It should be noted that the dependency package is a third-party library or module used in software development. The dependency package of the mapper contains tools and classes for data mapping and conversion, so that the mapper can perform the mapping function normally.
[0069] Step S30, defining a mapping rule of the mapper so that the system data has the specified field name after mapping; wherein the cleaner attribute in the mapping rule represents the corresponding relationship between the specified field of the mapping rule and the cleaner.
[0070] In step S30, the cleaner attribute in the mapping rule indicates the correspondence between the specified field of the mapping rule and the cleaner. For example, for the custom mapping rule @ReflectField, @ReflectField(value="name",clean="OldCommentClean.userName") can be set, where the clean attribute specifies that the field corresponds to the cleaner.
[0071] In the second embodiment of the present application, the mapper is constructed by introducing the dependency package of the mapper and defining the mapping rules of the mapper, so that the new system data before mapping and the old system data before mapping can be mapped by the mapper to obtain data with a unified specified field name.
[0072] Based on the first embodiment of the present application, in the third embodiment of the present application, the same or similar contents as those in the first embodiment can be referred to the above description, and will not be described in detail later. On this basis, step S40 includes steps S41 to S43:
[0073] Step S41, performing data filtering processing on the field contents in the mapped new system data and the mapped old system data to obtain filtered new system data and filtered old system data;
[0074] In a feasible implementation, step S41 may include steps S411 to S412:
[0075] Step S411, performing data format verification and conversion on the mapped new system data and the mapped old system data, so that different data formats in the mapped new system data and the mapped old system data are converted into the same data format, thereby obtaining formatted new system data and formatted old system data;
[0076] It should be noted that data format verification can be performed through regular expressions, or third-party libraries such as Java's Hibernate Validator and Python's cerberus can be used to achieve complex verification effects; format conversion can be achieved through formatting functions or data mapping frameworks; the specific implementation methods of data format verification and conversion are not limited here.
[0077] In step S411, the data is converted into a common format by performing data format verification and conversion on the mapped new system data and the mapped old system data, so that different system data and new and old system data can understand and process each other, and the speed of data processing and analysis is accelerated.
[0078] Step S412, performing validity check and filtering on the formatted new system data and the formatted old system data, so as to obtain the filtered new system data and the filtered old system data; wherein the validity check content at least includes the field length and the field content range.
[0079] It should be noted that validity checking is a way to ensure that data meets specific standards and quality requirements. Specifically, in step S412, the formatted new system data and the formatted old system data are validity checked and filtered, and the content of the validity check includes at least the field length and the field content range. Exemplarily, the validity check for field length can be performed based on the pre-defined minimum and / or maximum length limit values for each field, and each field is compared to filter out the fields that meet the specific length requirements. The validity check for the field content range can be verified based on the numerical range of the field, the enumeration value list, and other contents.
[0080] In this embodiment, the data is converted into a common format by performing data format verification and conversion on the mapped new system data and the mapped old system data, so that different system data and new and old system data can understand and process each other, and the speed of data processing and analysis is accelerated; then the validity check is performed to screen out valid data that meets the field length and field content range requirements, thereby providing valid content for the next step of data logic maintenance processing.
[0081] Step S42, performing data cleaning processing on the filtered new system data and the filtered old system data to obtain cleaned new system data and cleaned old system data;
[0082] In a feasible implementation, step S42 may include steps S421 to S422:
[0083] Step S421, based on a method of querying a third-party service to obtain complete data, supplement the missing field contents in the filtered new system data and the filtered old system data to obtain supplemented new system data and supplemented old system data;
[0084] In step S421, the data content is supplemented by querying a third-party service to obtain complete data. Exemplarily, for the content of the userName field in OldComment from the old comment system in the old system data, the complete old comment data will be queried through the old comment system service, and the user nickname data in the old comment system will be used as the latest content data to supplement the specified field name field. Correspondingly, for the new comment content in the new system data, the complete new comment data can be queried through the new comment system service, and the user nickname data in the new comment system will be used as the latest content data to supplement the specified field name field.
[0085] Step S422, based on field rules, logically clean the supplemented new system data and the supplemented old system data to obtain the cleaned new system data and the cleaned old system data; wherein the field rules include nickname length rules, field truncation rules and content selection rules.
[0086] In step S42, the supplemented new system data and the supplemented old system data are logically cleaned based on field rules. The field rules include nickname length rules, field interception rules and content selection rules; among them, the nickname length rule can be used to pre-set the nickname length range screening standard to clean up the data content that meets the requirements; the field interception rule can intercept the key fields by setting key fields; the content selection rule can be implemented by methods such as sensitive word filtering, data desensitization, error information correction, and useless information elimination. Taking data desensitization as an example, if the supplemented new system data and the supplemented old system data contain sensitive information such as identity card information and address information, they can be desensitized and the corresponding field content can be discarded.
[0087] In this embodiment, by querying a third-party service to obtain complete data, it is possible to supplement the missing field content in the data, so that the data content is complete. Moreover, compared with the completion strategy based on the decision table, the method of obtaining complete data by querying a third-party service in this embodiment can ensure the integrity and professionalism of the supplemented content by querying the external data source, making the data supplement more accurate. Through the logical cleaning method based on field rules, the supplemented new system data and the supplemented old system data are logically cleaned to obtain the final complete unified data.
[0088] Step S43, grouping and integrating the fields in the cleaned new system data and the cleaned old system data according to entity definitions to form complete entity data, so as to obtain the target system data.
[0089] It should be noted that entity definition refers to the abstract representation of different objects (such as users, orders, products, etc.), which defines the structure and attributes of the entity. By grouping and integrating by entity definition, the field contents of the same entity object can be integrated together, and the field contents of different entity objects can be distinguished, so as to facilitate the subsequent classification and retrieval of data.
[0090] In the third embodiment of the present application, by filtering the mapped new system data and the mapped old system data, then cleaning the data, and finally grouping and integrating them according to the entity definition, the complete target system data that has undergone multiple filtering and cleaning is obtained, which provides complete, effective, highly readable, easy-to-index and process data for subsequent persistence processing and data display.
[0091] Based on the first embodiment of the present application, in the fourth embodiment of the present application, the same or similar contents as those in the first embodiment can be referred to the above description, and will not be described in detail later. On this basis, step S60 includes steps S61 to S62:
[0092] Step S61, using a persister to physically encapsulate the target system data to obtain encapsulated data; wherein the encapsulated data is structured data that can communicate with an Elasticsearch database;
[0093] It should be noted that the Elasticsearch database is a non-relational database and a distributed full-text search and analysis engine that can quickly store, search and analyze large amounts of data.
[0094] In step S61, after receiving the target system data, the persister will physically encapsulate the target system data into structured data that can communicate with the Elasticsearch database, so as to provide the communication connection to successfully complete the data transmission and facilitate the subsequent transmission of the encapsulated data to the Elasticsearch database.
[0095] Step S62, using the persister to establish a communication connection with the Elasticsearch database, and transmitting the encapsulated data to the Elasticsearch database.
[0096] It should be noted that the persister establishes and maintains a long-term communication connection with the Elasticsearch database through the Transmission Control Protocol (TCP) to ensure that the encapsulated data can be transmitted safely and efficiently.
[0097] For ease of understanding, steps S61 to S62 are explained in detail here. Specifically, the target system data will first pass through the persister and then be stored in the Elasticsearch database. The persister carries the persistent entity and transmission capabilities of the data, and saves the final cleaned target system data to the ES database. In the process of storing the target system data in the Elasticsearch database, the target system data is first entity-encapsulated by the persister to obtain encapsulated data, and the persister then transmits the encapsulated data to the Elasticsearch database; during the entire process, the persister will maintain a TCP long connection with the Elasticsearch database during operation to ensure that the entity data can be safely and efficiently input into the Elasticsearch database.
[0098] In the fourth embodiment of the present application, the target system data is physically encapsulated by using a persister so that the obtained encapsulated data meets the communication conditions with the Elasticsearch database; the communication connection with the Elasticsearch database is established and maintained by using the persister, and the encapsulated data is transmitted to the Elasticsearch database to realize data warehousing. After that, the operator can conveniently index and process the stored encapsulated data through the Elasticsearch database, thereby improving the efficiency of data query and processing of new system data and old system data.
[0099] This application also provides a multi-system data processing device, please refer to Figure 2 , the multi-system data processing device comprises:
[0100] A data acquisition module 10 is used to acquire new system data before mapping and old system data before mapping;
[0101] A mapper module 40, used for uniformly mapping the new system data before mapping and the old system data before mapping into a specified field name to obtain the new system data after mapping and the old system data after mapping;
[0102] A cleaning module 50 is used to perform logic maintenance processing on the mapped new system data and the mapped old system data to obtain target system data; wherein the logic maintenance processing at least includes data filtering, data cleaning and data integration;
[0103] The persistence module 60 is used to perform persistence processing on the target system data so as to keep the target system data in communication connection with the database and transmit the target system data to the database.
[0104] The multi-system data processing device provided by the present application adopts the multi-system data processing method in the above embodiment, which can solve the technical problems that the new system data generated by the ever-expanding new business and the old system data retained in history have diverse data formats and fields, and data compatibility and integration are too complicated, which affect the query and processing efficiency. Compared with the prior art, the beneficial effects of the multi-system data processing device provided by the present application are the same as the beneficial effects of the multi-system data processing method provided by the above embodiment, and the other technical features in the multi-system data processing device are the same as the features disclosed in the above embodiment method, which will not be repeated here.
[0105] The present application provides a multi-system data processing 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 multi-system data processing method in the above-mentioned embodiment 1.
[0106] Reference below Figure 3 , which shows a schematic diagram of the structure of a multi-system data processing device suitable for implementing an embodiment of the present application. The multi-system data processing 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. Figure 3 The multi-system data processing device shown is only an example and should not bring any limitation to the functions and scope of use of the embodiments of the present application.
[0107] like Figure 3As shown, the multi-system data processing 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 multi-system data processing 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 multi-system data processing device to communicate with other devices wirelessly or by wire to exchange data. Although the figure shows a multi-system data processing device with various systems, 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.
[0108] 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.
[0109] The multi-system data processing device provided by the present application adopts the multi-system data processing method in the above embodiment, which can solve the technical problems that the new system data generated by the continuously expanding new business and the old system data retained in history have diverse data formats and fields, and data compatibility and integration are too complicated, which affect the query and processing efficiency. Compared with the prior art, the beneficial effects of the multi-system data processing device provided by the present application are the same as the beneficial effects of the multi-system data processing method provided by the above embodiment, and the other technical features in the multi-system data processing device are the same as the features disclosed in the method of the previous embodiment, which will not be repeated here.
[0110] 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.
[0111] 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.
[0112] 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 multi-system data processing method in the above-mentioned embodiment.
[0113] 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.
[0114] The computer-readable storage medium may be included in the multi-system data processing device; or may exist independently without being installed in the multi-system data processing device.
[0115] The computer-readable storage medium carries one or more programs. When the one or more programs are executed by a multi-system data processing device, the multi-system data processing device: obtains new system data before mapping and old system data before mapping; uniformly maps the new system data before mapping and the old system data before mapping to specified field names to obtain new system data after mapping and old system data after mapping; performs logical maintenance processing on the new system data after mapping and the old system data after mapping to obtain target system data; wherein the logical maintenance processing at least includes data filtering, data cleaning and data integration; performs persistence processing on the target system data so that the target system data maintains a communication connection with a database, and transmits the target system data to the database.
[0116] 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).
[0117] 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.
[0118] 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.
[0119] 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 multi-system data processing method, and can solve the technical problems that the new system data generated by the ever-expanding new business and the old system data retained in history have diverse data formats and fields, and data compatibility and integration are too complicated, which affect the query and processing efficiency. 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 multi-system data processing method provided by the above-mentioned embodiment, and will not be repeated here.
[0120] The present application also provides a computer program product, including a computer program, which implements the steps of the multi-system data processing method as described above when executed by a processor.
[0121] The computer program product provided by the present application can solve the technical problems that the new system data generated by the ever-expanding new business and the old system data retained historically have diverse data formats, variable fields, and overly complex data compatibility and integration, which affect the query and processing efficiency. Compared with the prior art, the beneficial effects of the computer program product provided by the present application are the same as those of the multi-system data processing method provided by the above-mentioned embodiment, and will not be elaborated here.
[0122] 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 multi-system data processing method, characterized in that: The method comprises: Obtain new system data before mapping and old system data before mapping; The new system data before mapping and the old system data before mapping are uniformly mapped to the specified field name to obtain the new system data after mapping and the old system data after mapping; Performing logic maintenance processing on the mapped new system data and the mapped old system data to obtain target system data; wherein the logic maintenance processing at least includes data filtering, data cleaning and data integration; The target system data is persistently processed so that the target system data maintains a communication connection with the database, and the target system data is transmitted to the database.
2. The method according to claim 1, characterized in that Before the step of mapping the new system data before mapping and the old system data before mapping into designated field names to obtain the new system data after mapping and the old system data after mapping, the step further includes: Import the mapper's dependency package; A mapping rule of the mapper is defined so that the system data has the specified field name after being mapped; wherein the cleaner attribute in the mapping rule represents the corresponding relationship between the specified field of the mapping rule and the cleaner.
3. The method according to claim 1, characterized in that The step of performing logical maintenance processing on the mapped new system data and the mapped old system data to obtain target system data comprises: Performing data filtering processing on the field contents in the mapped new system data and the mapped old system data to obtain filtered new system data and filtered old system data; Performing data cleaning on the filtered new system data and the filtered old system data to obtain cleaned new system data and cleaned old system data; The fields in the cleaned new system data and the cleaned old system data are grouped and integrated according to entity definitions to form complete entity data, so as to obtain the target system data.
4. The method according to claim 3, characterized in that The step of performing data filtering processing on the field contents in the mapped new system data and the mapped old system data to obtain the filtered new system data and the filtered old system data comprises: Performing data format verification and conversion on the mapped new system data and the mapped old system data, so that different data formats in the mapped new system data and the mapped old system data are converted into the same data format, thereby obtaining formatted new system data and formatted old system data; The formatted new system data and the formatted old system data are validated and filtered to obtain the filtered new system data and the filtered old system data; wherein the validation content of the validation at least includes the field length and the field content range.
5. The method according to claim 3, characterized in that The step of performing data cleaning on the filtered new system data and the filtered old system data to obtain cleaned new system data and cleaned old system data comprises: Based on the method of querying the third-party service to obtain complete data, the missing field contents in the filtered new system data and the filtered old system data are supplemented to obtain supplemented new system data and supplemented old system data; Based on field rules, the supplemented new system data and the supplemented old system data are logically cleaned to obtain the cleaned new system data and the cleaned old system data; wherein the field rules include nickname length rules, field truncation rules and content selection rules.
6. The method according to claim 1, characterized in that The step of performing persistence processing on the target system data so as to transfer the target system data to the database comprises: Using a persister to physically encapsulate the target system data to obtain encapsulated data; wherein the encapsulated data is structured data that can communicate with an Elasticsearch database; The persister is used to establish a communication connection with the Elasticsearch database, and the encapsulated data is transmitted to the Elasticsearch database.
7. A multi-system data processing device, characterized in that: The device comprises: A data acquisition module, used to acquire new system data before mapping and old system data before mapping; A mapper module, used for uniformly mapping the new system data before mapping and the old system data before mapping into a specified field name to obtain the new system data after mapping and the old system data after mapping; A cleaner module, used for performing logic maintenance processing on the mapped new system data and the mapped old system data to obtain target system data; wherein the logic maintenance processing at least includes data filtering, data cleaning and data integration; The persistence module is used to perform persistence processing on the target system data so as to keep the target system data in communication connection with the database and transmit the target system data to the database.
8. A multi-system data processing device, characterized in that: The device comprises: a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the computer program is configured to implement the steps of the multi-system data processing method according to any one of claims 1 to 6.
9. A storage medium, characterized in that: The storage medium 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 multi-system data processing method according to any one of claims 1 to 6 are implemented.
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 multi-system data processing method according to any one of claims 1 to 6 are implemented.