WO2018227880A1 - Procédé, appareil, et dispositif de comparaison de données, et support d'informations lisible - Google Patents

Procédé, appareil, et dispositif de comparaison de données, et support d'informations lisible Download PDF

Info

Publication number
WO2018227880A1
WO2018227880A1 PCT/CN2017/111901 CN2017111901W WO2018227880A1 WO 2018227880 A1 WO2018227880 A1 WO 2018227880A1 CN 2017111901 W CN2017111901 W CN 2017111901W WO 2018227880 A1 WO2018227880 A1 WO 2018227880A1
Authority
WO
WIPO (PCT)
Prior art keywords
data
comparison
information
data comparison
logic
Prior art date
Application number
PCT/CN2017/111901
Other languages
English (en)
Chinese (zh)
Inventor
王莹
Original Assignee
平安科技（深圳）有限公司
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by 平安科技（深圳）有限公司 filed Critical 平安科技（深圳）有限公司
Publication of WO2018227880A1 publication Critical patent/WO2018227880A1/fr

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G06F16/248—Presentation of query results
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G06F16/245—Query processing
    • G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries

Definitions

  • the present invention relates to the field of computer technologies, and in particular, to a data comparison method, apparatus, device, and readable storage medium.
  • the main object of the present invention is to provide a data comparison method, apparatus, device and readable storage medium, aiming at improving the efficiency and accuracy of data comparison.
  • the present invention provides a data comparison method, and the data comparison method includes the following steps:
  • the data comparison window is displayed to prompt the user to input the data comparison information
  • the present invention also provides a data comparison device
  • a detection prompting module configured to display a data comparison window when the data comparison request is detected, to prompt the user to input the data comparison information
  • Determining a comparison module configured to determine a data comparison range based on the user input data comparison information, and compare the data information included in the corresponding range;
  • the detection output module is configured to output the result of the comparison of the data information when the comparison of the data information is detected.
  • the present invention also provides a data comparison device, the data comparison device comprising: a memory, a processor, and a data comparison program stored on the memory and operable on the processor,
  • the data comparison program implements any of the steps of the data comparison method described above when executed by the processor.
  • the present invention also provides a readable storage medium, on which the data comparison program is stored, and the data comparison program implements the data ratio described above when executed by the processor. Any step of the method.
  • the invention realizes data comparison through a program. Since the program supports data comparison between the same library and the cross-database, it is not necessary to log in to different databases, and the custom database can be supported, and the data source is filled in the corresponding position of the data comparison window, according to the comparison program.
  • the comparison statement realizes the comparison of large-volume data tables, which effectively improves the data comparison efficiency.
  • the data is manually compared and filtered repeatedly, and is converted into a program to automatically process the data information of the same or different databases for data comparison, thereby saving Larger manpower time, and reduced errors in manual processing results in inaccurate comparison results, and can quickly and accurately obtain data comparison results.
  • FIG. 1 is a schematic structural diagram of a device in a hardware operating environment according to an embodiment of the present invention
  • FIG. 2 is a schematic flow chart of a first embodiment of a data comparison method according to the present invention.
  • FIG. 3 is a schematic flow chart of a second embodiment of a data comparison method according to the present invention.
  • FIG. 4 is a schematic flow chart of a third embodiment of a data comparison method according to the present invention.
  • FIG. 5 is a schematic flowchart of the refinement of step S20 of the data comparison method in FIG. 2;
  • FIG. 6 is a schematic diagram of a refinement process of step S30 of the data comparison method in FIG. 2;
  • FIG. 7 is a schematic flowchart diagram of a fourth embodiment of a data comparison method according to the present invention.
  • FIG. 8 is a schematic diagram of a scenario in which the data comparison method of the present invention is combined.
  • FIG. 9 is a schematic diagram of a data comparison setting setting scenario of a data comparison method according to the present invention.
  • FIG. 10 is a schematic diagram of functional modules of an embodiment of a data comparison device according to the present invention.
  • FIG. 1 is a schematic structural diagram of a terminal (also referred to as a data comparison device) in a hardware operating environment according to an embodiment of the present invention.
  • the terminal may be a PC, or may be a portable terminal device having a display function, such as a smart phone, a tablet computer, or a portable computer.
  • the terminal may include a processor 1001, such as a CPU, a network interface 1004, a user interface 1003, a memory 1005, and a communication bus 1002.
  • the communication bus 1002 is used to implement connection communication between these components.
  • the user interface 1003 can include a display, an input unit such as a keyboard, and the optional user interface 1003 can also include a standard wired interface, a wireless interface.
  • the network interface 1004 can optionally include a standard wired interface, a wireless interface (such as a WI-FI interface).
  • the memory 1005 may be a high speed RAM memory or a stable memory (non-volatile) Memory), such as disk storage.
  • the memory 1005 can also optionally be a storage device independent of the aforementioned processor 1001.
  • the terminal may further include a camera, RF (Radio) Frequency, RF) circuits, sensors, audio circuits, WiFi modules, and more.
  • sensors such as light sensors, motion sensors, and other sensors.
  • the light sensor may include an ambient light sensor and a proximity sensor, wherein the ambient light sensor may adjust the brightness of the display according to the brightness of the ambient light, and the proximity sensor may turn off the display and/or when the mobile terminal moves to the ear. Backlighting.
  • the gravity acceleration sensor can detect the magnitude of acceleration in each direction (usually three axes), and can detect the magnitude and direction of gravity when stationary, and can be used to identify the posture of the mobile terminal (such as horizontal and vertical screen switching, Related games, magnetometer attitude calibration), vibration recognition related functions (such as pedometer, tapping), etc.; of course, the mobile terminal can also be equipped with other sensors such as gyroscope, barometer, hygrometer, thermometer, infrared sensor, etc. No longer.
  • terminal structure shown in FIG. 1 does not constitute a limitation to the terminal, and may include more or less components than those illustrated, or a combination of certain components, or different component arrangements.
  • an operating system may be included in the memory 1005 as a computer storage medium.
  • a network communication module may be included in the memory 1005 as a computer storage medium.
  • a user interface module may be included in the memory 1005 as a computer storage medium.
  • a data comparison application may be included in the memory 1005 as a computer storage medium.
  • the network interface 1004 is mainly used to connect to the background server and perform data communication with the background server;
  • the user interface 1003 is mainly used to connect the client (user end), and perform data communication with the client;
  • the processor 1001 can be used to call the data comparison application stored in the memory 1005 and perform the following operations:
  • the data comparison method includes the following steps:
  • the data comparison window is displayed to prompt the user to input the data comparison information
  • processor 1001 can call the data comparison application stored in the memory 1005, and also performs the following operations:
  • the data comparison window is used to display a data comparison file and a configuration file, and the data comparison file is formed by setting a data comparison function in an Excel table.
  • the step of displaying the data comparison window to prompt the user to input the data comparison information before detecting the data comparison request includes:
  • processor 1001 can call the data comparison application stored in the memory 1005, and also performs the following operations:
  • the data comparison information includes a data source, a data comparison logic, and a data output format.
  • the step of determining the data comparison range based on the user input data comparison information and comparing the data information included in the corresponding range includes:
  • the data comparison information includes data comparison logic, the data information is compared according to the data comparison logic;
  • the data comparison information of the data comparison range is determined as the full data comparison.
  • processor 1001 can call the data comparison application stored in the memory 1005, and also performs the following operations:
  • the step of determining the data comparison range based on the user input data comparison information and comparing the data information included in the corresponding range includes:
  • the data information is combined according to the data comparison logic to form a data information comparison group, and the data information in the corresponding data comparison group is compared.
  • processor 1001 can call the data comparison application stored in the memory 1005, and also performs the following operations:
  • determining the source database of the data information and extracting the data information from the source database, and determining whether there is a data comparison logic step further includes:
  • the full data field in the source database is used as the data comparison logic, and the data information in the database is compared with the full data.
  • processor 1001 can call the data comparison application stored in the memory 1005, and also performs the following operations:
  • the steps of outputting the result of the data information comparison include:
  • the data comparison result is output according to the data output format
  • the data comparison result is output according to a preset default format.
  • processor 1001 can call the data comparison application stored in the memory 1005, and also performs the following operations:
  • the step of outputting the result of the data information comparison includes:
  • the data comparison function in the data comparison file is adjusted to optimize the data comparison file.
  • processor 1001 can call the data comparison application stored in the memory 1005, and also performs the following operations:
  • the output of the data information comparison step further includes:
  • the data comparison data is compared according to the data comparison process to prompt the user to modify the data input information.
  • the data comparison method includes:
  • Step S10 When the data comparison request is detected, the data comparison window is displayed to prompt the user to input the data comparison information.
  • the display screen of the terminal displays a data comparison window (specifically, when the terminal detects the data comparison request, the execution of the application of the data comparison on the terminal may be triggered, and the terminal may call the data. Comparing the underlying interface, so that the data comparison window is displayed on the display interface of the terminal, and the data comparison window displays the data comparison file and the data is compared with the configuration file required by the user when the program is running, in the data ratio
  • Data matching information required for users in files and configuration files data comparison information: data sources including data comparison, database information (database name, database network address, database interface, and data document information in the corresponding database)
  • Data comparison logic (the data comparison logic includes logical primary keys of data comparisons and logical combination keys of data comparisons.
  • the data comparison primary key can be understood as a reference quantity of data comparison, a reference of data comparison, Logical primary key, that is, a reference quantity of a data comparison, a logical combination key, that is, a reference of two data comparisons ) And the comparison result data corresponding to the output format (output format data alignment: that is, comparison result output data, the name of the document xxx)) xxx type in the document.
  • Step S20 Determine a data comparison range based on the user input data comparison information, and compare the data information included in the corresponding range.
  • sql statement sql statement: set in the data comparison file, run in Excel, developed by the program developer according to the user's usage, specifically JAVA, python, VBA or other programming Language
  • Step S30 when it is detected that the data information comparison is completed, the result of the comparison of the data information is output.
  • the user can set the data output document format of the data output and the name of the corresponding document.
  • the data comparison program stores the data comparison on the device, and can compare the data in the data comparison range, and the data ratio in the data comparison range
  • the data comparison program stops executing, and the data comparison statement is jumped out.
  • the data comparison statement is detected, that is, when the data comparison is completed, the data output format of the data comparison result set by the user is obtained, and The output of the data comparison shows that the user can visually and accurately see the results of the data comparison.
  • the data comparison window is displayed to prompt the user to input the data comparison information, and the data comparison range is determined based on the user input data comparison information, and the data included in the corresponding range is compared.
  • Information when the comparison of the data information is completed, the result of the comparison of the data information is output, and the data comparison is realized by the program. Since the program supports the comparison of the data in the same library and the cross-database, it is not necessary to log in to different databases, and the customization can be supported.
  • Database fill the data source to the corresponding position of the data comparison window, compare the large number of data tables according to the comparison statement of the comparison program, effectively improve the data comparison efficiency, compare the data manually by repeated filtering and filtering, and convert For the program to automatically process the data information of the same or different databases for data comparison, it can save a lot of manpower time, and reduce the inaccurate comparison result caused by errors in the manual processing process, and can quickly and accurately obtain the data comparison result.
  • the data comparison window is configured to display a data comparison file and a configuration file, and the data comparison file is formed by setting a data comparison function in an Excel table.
  • the data comparison methods include:
  • Step S40 Acquire preset database information, and generate a configuration file according to the database address in the preset database information, so that the user forms a specified configuration file according to the data comparison requirement setting configuration file.
  • the data comparison is mainly used in the comparison of different or the same database data information (that is, the invention is mainly applied to two upstream and downstream databases, and the data information of the downstream database is imported by the upstream database, and the existing methods are mainly In the process of data import, the data is compared and verified, or after the data is imported, the database is compared for manual data comparison, or the similarity of data information of different data ports is compared, etc., in the embodiment, when the program is developed Obtaining preset database information (preset database information, that is, existing different database names, database network addresses, database interfaces, and corresponding data document information in the database), generating a configuration file for the user to use according to the data Comparing the requirement setting configuration file to form a specified configuration file, specifically, generating a data comparison configuration file during software development, and correspondingly inputting information in the configuration file according to the data comparison situation when the user compares the data, forming a specified configuration file, and the user according to the Data comparison requirements
  • the information entered in the configuration file can contain
  • Step S50 establishing a response association relationship between the comparison function of the data comparison file and the specified configuration file.
  • the user inputs information according to the data comparison requirement, and the obtained data is associated with the specified configuration file and the data comparison file, and the data comparison function is associated with the response between the file and the specified configuration file, that is, the user is in the data ratio.
  • the data trigger comparison data in the data comparison comparison file in the data comparison function can call the configuration information in the configuration file to perform the data comparison program operation.
  • the preset database information is acquired, and a configuration file is generated according to the database address in the preset database information, so that the user can form a configuration file according to the data setting requirement configuration file, and establish a comparison function of the data comparison file and Specifies the response association between profiles.
  • the information of the preset database is acquired, and a data comparison configuration file is generated to prompt the user to obtain a specified configuration file according to the data matching requirement setting file, and associate the specified configuration file with the data comparison file, and the user triggers the data.
  • the data comparison program in the data comparison file can realize the comparison of the batch data information in different or the same database, and the user does not need to log in to import different database information data. Export, manual data comparison, speed up the efficiency of data comparison.
  • the data comparison information includes a data source, a data comparison logic, and a data output format
  • the data comparison method includes:
  • Step S60 Acquire data comparison information input in the data comparison file, and determine whether the data comparison information includes data comparison logic.
  • the data comparison information includes a data source (data source: including source database, database name, etc.), and data comparison logic (data comparison logic: data) Comparing the logical primary key and logical combination key of the logic and the data output format, obtaining the data comparison information input in the data comparison file, further determining whether the user inputs the data comparison logic, that is, determining whether the data comparison information contains data Compare logic.
  • data source including source database, database name, etc.
  • data comparison logic data comparison logic: data
  • Step S70 If the data comparison information includes data comparison logic, the data information is compared according to the data comparison logic.
  • the data comparison logic data comparison logic: logical primary key and logical combination key of the data comparison logic
  • the data comparison logic input by the user, specifically Ground
  • obtain the logical primary key of the data information comparison or the logical combination key of the data comparison that is, the two databases contain the resident user information of a certain community, and compare the data based on the user ID number when the data is compared, Then, the user ID number is used as the logical primary key of the data comparison, and the logical combination key of the data matching the user name and the user gender in the two databases is the same.
  • the present invention can also implement different data comparison.
  • the key, used to determine the order of the data comparisons compares the data information in the data source (same or different database) according to the data comparison logic.
  • Step S80 If the data comparison information does not include the data comparison logic, the data information of the data comparison range is determined as the full data comparison.
  • the user does not input the data comparison logic, and compares all the numbers in the data information in the data comparison range as the data comparison logic, that is, the database contains the name, age, ID number, telephone number, gender.
  • the home address and other information when the user does not enter the data comparison logic, the age, ID number, phone number and the number as the data comparison logic, the full amount of data comparison.
  • the data comparison information is obtained in the data comparison file, and the data comparison information is included in the data comparison logic. If the data comparison information includes the data comparison logic, the data is compared according to the data comparison logic. Information, if the data comparison information does not contain data comparison logic, the data information of the data comparison range is determined as a full data comparison. Determining the data comparison logic of the data comparison to obtain the data comparison result required by the user, and eliminating the need for artificial macroscopic data comparison, thereby improving the efficiency of the data comparison, and at the same time, the user can independently set the data comparison. The logical primary key, to obtain the required data comparison results, makes the data comparison more efficient and convenient.
  • step S20 includes:
  • Step S21 Determine, according to the data source in the data comparison information, the source database of the data information in the response association relationship, and extract the data information from the source database, and determine whether there is data comparison logic.
  • the corresponding data information is obtained in the specified configuration file, and the data is determined.
  • the database of information extracts data information from the database, and extracts data information that needs to be compared in the database (that is, when the data of the present invention is compared, the user does not need to log in to the database, and according to information such as the name of the database input by the user, the database corresponds to the corresponding data.
  • Data information of the interface (data information: including data document information, character information in the document)).
  • Step S22 if there is data comparison logic, the data information comparison group is formed according to the data comparison logic, and the data information in the corresponding data comparison group is compared.
  • the data information in the database is logically combined according to the data comparison to form a data comparison group (data comparison group: can be understood as a data combination formed by the same digital primary key in different source databases, for example, a group of students' information is stored separately
  • data comparison group can be understood as a data combination formed by the same digital primary key in different source databases, for example, a group of students' information is stored separately
  • the student information of the Education Bureau's teaching system A and the school's teaching system B are compared, and the student's student number is used as the logical primary key of the data comparison.
  • the information of the same student number in the teaching system A of the Education Bureau and the teaching system B of the school will be combined, and the relevant information of the students of the same student number in the two teaching systems will appear, and the relevant information of the students of the same student number will be used as the data information.
  • the comparison group compares the other student information in the corresponding data comparison group, that is, whether the contact information of the students in the two systems with the same student number, the parent name, and the like are the same, for example, the data information in the downstream database.
  • the data information in the upstream database it is necessary to determine whether the data information imported into the downstream database from the upstream database is consistent. Then, a data amount in the database is used as a logical primary key of the data comparison.
  • the database of the commodity sales system includes different subsystems, and each subsystem contains different commodity sales data, and the same commodity number is used as a reference.
  • the source database of the data information is determined and the data information is extracted from the source database, and it is determined whether there is data comparison logic; if there is data comparison logic. Then, according to the data comparison logic, the data information is combined to form a data information comparison group, and the data information in the corresponding data comparison group is compared. According to the data set by the user, the data is compared with the logic, which can ensure the optimization of the data comparison program quickly. According to the user setting, the data information is compared, and the data information is logically combined according to the data comparison logic. The data comparison program can be optimized to improve the efficiency of data comparison.
  • the method further includes:
  • Step S23 if there is data comparison logic, the data information comparison group is formed according to the data comparison logic, and the data information in the corresponding data comparison group is compared.
  • the data comparison file does not contain the data comparison logic (that is, the user does not input the data to compare the logical primary key).
  • the data information is compared with the full amount of data, that is, the entire database will be Data field (full data field: all the numbers in the data information, ie, the identity number, phone number and age, a data comparison logic) as the data comparison logic, the data information in the database is compared with the full amount of data, The difference in other data information in the database information.
  • the data comparison logic if there is data comparison logic, the data information is compared according to the data comparison data to form a data information comparison group, and the data information in the corresponding data comparison group is compared, and when the data is compared, if the user does not set
  • the data comparison logic identifies the data comparison as a full-scale data comparison, which ensures the comprehensiveness of the data comparison and compares the data information on a unified basis.
  • step S30 includes:
  • Step S31 when it is detected that the data information comparison is completed, it is determined whether the data amount of the data information is greater than a threshold.
  • the output of the data comparison result can be output according to the user setting, but there may be a large amount of data comparison, and a specific document is required for data output. 9. Determine whether the output of the data comparison is greater than the maximum data amount.
  • the data is output by using xls, xlsx, and csv formats, because the data capacity of the xls and xlsx tables is limited (xls, xlsx tables are suitable for storing data amount is less than 65525, if the comparison result exceeds 65525 can be output in csv format), it will be necessary to determine whether the data amount of the comparison data information is greater than a threshold (threshold value is 65525).
  • step S32 if the data amount of the data information is not greater than the threshold, the data comparison result is output according to the data output format.
  • the result of the data comparison may be output according to the user's setting (the user may set the name of the data output when the data is compared, the data comparison process, or the data comparison result is output.
  • Information such as the output format, the user-set data output format can contain all data formats, ie xls, xlsx or csv).
  • Step S33 If the data amount of the data information is greater than the threshold, the data comparison result is output according to a preset default format.
  • the data comparison result needs to be output in the csv format document, and the data comparison result is according to a preset format (preset default format: when the data volume is greater than 65525, the csv format is adopted. Document) output, the user can customize the naming of documents in csv format.
  • the output of the data comparison result is limited, so that the result of the data comparison is output according to the user definition, and when the data amount exceeds the preset value, the preset format is adopted.
  • the output reduces the user's operation and improves the efficiency of data comparison.
  • the data comparison method further includes:
  • Step S90 Adjust the data comparison function in the data comparison file based on the output data information comparison result to optimize the data comparison file.
  • the user can customize the setting SQL statement on the terminal, so that the data information of different databases is compared according to the user-defined sql statement. It is necessary to add that the server of the data comparison can be based on Based on the output data information comparison result, the program function corresponding to the adjustment data comparison data comparison data makes the data comparison result display easier to view.
  • the data comparison function in the data comparison file is adjusted to optimize the data comparison file, and the user can customize the sql statement to satisfy the user's data comparison requirement, or data.
  • the comparison background automatically adjusts the setting data comparison program according to the output data comparison result, so that the data comparison program is more optimized.
  • the data comparison method further includes:
  • the data comparison data is compared according to the data comparison process to prompt the user to modify the data input information.
  • the required data comparison result is not obtained, that is, the data comparison is abnormal, and the data comparison abnormality processing scheme: when the entered query content does not conform to the format, the output 'Data Incorrect, please check the Document' (for example: the database name does not exist in the configuration document, the SQL statement has a syntax error, the number of logical primary keys is inconsistent, etc.), or other exception handling: when there are other exceptions in the query, the result will not be output. That is, when the result document is found to be missing, please check whether the entered query condition has content that does not meet the requirements (for example: whether the number of table fields is inconsistent, lack of SQL statement, etc.). According to the data comparison process, the data is compared with the abnormal factor to prompt The user modifies the data input information.
  • the Document' for example: the database name does not exist in the configuration document, the SQL statement has a syntax error, the number of logical primary keys is inconsistent, etc.
  • other exception handling when there are other exceptions in the query, the result will not be output. That is, when the
  • the data comparison data is compared according to the data comparison process to prompt the user to modify the data input information, and the execution of the data comparison result is abnormal.
  • the factor allows the user to prompt the user to check the data according to the data comparison logic to correct the input of the information.
  • the present invention also provides a data comparison device.
  • the detection prompting module 10 is configured to display a data comparison window when the data comparison request is detected, to prompt the user to input the data comparison information;
  • the detection output module 30 is configured to output the result of the comparison of the data information when the comparison of the data information is detected.
  • the data comparison method may refer to various embodiments of the data comparison method of the present invention, and details are not described herein again.
  • the present invention also provides a readable storage medium.
  • the readable storage medium of the present invention stores a data comparison program that implements any of the steps of the data comparison method described above when the program is executed by the processor.
  • portions of the technical solution of the present invention that contribute substantially or to the prior art may be embodied in the form of a software product stored in a storage medium (such as a ROM/RAM as described above). , a disk, an optical disk, including a number of instructions for causing a terminal device (which may be a mobile phone, a computer, a server, an air conditioner, or a network device, etc.) to perform the methods described in various embodiments of the present invention.
  • a terminal device which may be a mobile phone, a computer, a server, an air conditioner, or a network device, etc.

Landscapes

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

Abstract

La présente invention porte sur un procédé de comparaison de données, comprenant les étapes suivantes consistant : à afficher une fenêtre de comparaison de données lorsqu'une demande de comparaison de données est détectée, permettant ainsi à un utilisateur d'entrer des informations de comparaison de données (S10) ; sur la base des informations de comparaison de données entrées par l'utilisateur, à déterminer une plage de comparaison de données, et à comparer des informations de données contenues dans la plage correspondante (S20) ; et lorsqu'il est détecté que la comparaison d'informations de données est terminée, à délivrer un résultat de comparaison d'informations de données (S30). L'invention concerne également un appareil et un dispositif de comparaison de données, et un support d'informations lisible. La comparaison de données entre différentes bases de données est réalisée au moyen d'un programme, et le résultat de comparaison de données est obtenu rapidement et avec précision.
PCT/CN2017/111901 2017-06-12 2017-11-20 Procédé, appareil, et dispositif de comparaison de données, et support d'informations lisible WO2018227880A1 (fr)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CN201710440984.9A CN107679054B (zh) 2017-06-12 2017-06-12 数据比对方法、装置及可读存储介质
CN201710440984.9 2017-06-12

Publications (1)

Publication Number Publication Date
WO2018227880A1 true WO2018227880A1 (fr) 2018-12-20

Family

ID=61134158

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/CN2017/111901 WO2018227880A1 (fr) 2017-06-12 2017-11-20 Procédé, appareil, et dispositif de comparaison de données, et support d'informations lisible

Country Status (2)

Country Link
CN (1) CN107679054B (fr)
WO (1) WO2018227880A1 (fr)

Families Citing this family (14)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN108563618A (zh) * 2018-03-15 2018-09-21 链家网（北京）科技有限公司 一种纸质文件线上化方法和系统
CN109241500B (zh) * 2018-08-14 2023-02-03 中国平安人寿保险股份有限公司 文件批量比对方法、装置、计算机设备和存储介质
CN109669937A (zh) * 2018-09-25 2019-04-23 深圳壹账通智能科技有限公司 列表数据比对方法、装置、设备及计算机可读存储介质
CN109634986B (zh) * 2018-10-29 2024-03-29 平安科技（深圳）有限公司 系统监测方法、装置、计算机及计算机可读存储介质
CN109783697B (zh) * 2018-12-14 2021-04-27 北京海数宝科技有限公司 数据处理方法、装置、计算机设备和存储介质
CN109582726B (zh) * 2018-12-18 2021-09-07 网易（杭州）网络有限公司 数据表的处理方法和装置
CN110069571A (zh) * 2019-03-18 2019-07-30 平安普惠企业管理有限公司 一种自动化数据对比方法及装置、电子设备
CN110109824B (zh) * 2019-04-09 2022-05-17 平安科技（深圳）有限公司 大数据自动回归测试方法、装置、计算机设备和存储介质
CN110287182B (zh) * 2019-05-05 2021-09-14 浙江吉利控股集团有限公司 一种大数据的数据对比方法、装置、设备及终端
CN111159234A (zh) * 2019-12-19 2020-05-15 中国建设银行股份有限公司 一种对比报表的方法和装置
CN111709073A (zh) * 2020-06-04 2020-09-25 黄淮学院 建筑结构动力分析用自振频率和振型的测定方法及系统
CN111796800A (zh) * 2020-06-28 2020-10-20 上海建科造价咨询有限公司 一种基于Python的工程量清单准确性校验方法
CN113051882A (zh) * 2021-04-23 2021-06-29 中国工商银行股份有限公司 数据差异对比方法、装置、介质和产品
CN113138933A (zh) * 2021-05-13 2021-07-20 网易（杭州）网络有限公司 数据表的测试方法、电子设备及存储介质

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102722521A (zh) * 2012-04-24 2012-10-10 深圳市神盾信息技术有限公司 监控数据比对的方法及系统
CN103796232A (zh) * 2014-02-10 2014-05-14 大唐移动通信设备有限公司 一种rnc数据比对方法和设备
CN104268291A (zh) * 2014-10-23 2015-01-07 税友软件集团股份有限公司 一种数据一致性处理方法和系统
EP2963568A1 (fr) * 2012-03-26 2016-01-06 Good Red Innovation Pty Ltd Sélection et identification de données
CN105740465A (zh) * 2016-03-04 2016-07-06 浪潮软件集团有限公司 一种灵活的自定义比对方法

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
EP2963568A1 (fr) * 2012-03-26 2016-01-06 Good Red Innovation Pty Ltd Sélection et identification de données
CN102722521A (zh) * 2012-04-24 2012-10-10 深圳市神盾信息技术有限公司 监控数据比对的方法及系统
CN103796232A (zh) * 2014-02-10 2014-05-14 大唐移动通信设备有限公司 一种rnc数据比对方法和设备
CN104268291A (zh) * 2014-10-23 2015-01-07 税友软件集团股份有限公司 一种数据一致性处理方法和系统
CN105740465A (zh) * 2016-03-04 2016-07-06 浪潮软件集团有限公司 一种灵活的自定义比对方法

Also Published As

Publication number Publication date
CN107679054B (zh) 2019-11-05
CN107679054A (zh) 2018-02-09

Similar Documents

Publication Publication Date Title
WO2018227880A1 (fr) Procédé, appareil, et dispositif de comparaison de données, et support d'informations lisible
WO2018205545A1 (fr) Procédé de génération de données, appareil, terminal, et support d'informations lisible par ordinateur
WO2019165691A1 (fr) Procédé, appareil et dispositif de production automatique de cas de test, et support de stockage lisible par ordinateur
WO2019127837A1 (fr) Procédé, appareil et dispositif de génération de script de création de table, et support de stockage lisible par ordinateur
WO2018107610A1 (fr) Procédé, système et dispositif de traitement de données de service, et support d'informations lisible par ordinateur
WO2019104877A1 (fr) Procédé, appareil et dispositif de connexion à un contrat d'assurance par l'intermédiaire d'un site web, et support
WO2019218444A1 (fr) Procédé, appareil et dispositif de génération de rapport d'essai, et support de stockage
WO2019174375A1 (fr) Procédé, appareil et dispositif de test d'interface, et support de stockage lisible par ordinateur
WO2019037396A1 (fr) Procédé, dispositif et équipement de suppression de compte et support d'informations
WO2019192085A1 (fr) Procédé, appareil et dispositif pour une communication à connexion directe entre une banque et une entreprise, et support de stockage lisible par ordinateur
WO2019061613A1 (fr) Procédé de criblage d'habilitation pour un prêt, dispositif et support de stockage lisible par ordinateur
WO2019169814A1 (fr) Procédé, appareil et dispositif de génération automatique d'annotation en chinois, et support d'informations
WO2019100604A1 (fr) Procédé et appareil d'interrogation de compte, dispositif, et support de stockage lisible par ordinateur
WO2016058258A1 (fr) Procédé et système de commande à distance de terminal
WO2017041538A1 (fr) Procédé et dispositif d'affichage commandé par interface utilisateur de terminal
WO2019104876A1 (fr) Procédé et système de poussée de produit d'assurance, terminal, terminal client et support d'informations
WO2018120430A1 (fr) Procédé de construction de page, terminal, support de stockage lisible par ordinateur et dispositif de construction de page
WO2019041832A1 (fr) Procédé, serveur et système de modification de structure de table de base de données source, et support de stockage
WO2019051902A1 (fr) Procédé de commande de terminal, climatiseur et support d'informations lisible par un ordinateur
WO2020224247A1 (fr) Procédé, appareil et dispositif de provenance de données basés sur la chaine de blocs, et support d'informations lisible
WO2019161597A1 (fr) Procédé, appareil et dispositif d'envoi d'informations sur la base d'une messagerie instantanée, et support d'informations
WO2017028613A1 (fr) Procédé de commande de terminal et appareil se basant sur une application de commande à distance
WO2017152603A1 (fr) Procédé et appareil d'affichage
WO2018053963A1 (fr) Procédé et appareil de mise à niveau d'un système de téléviseur intelligent
WO2019061530A1 (fr) Procédé et appareil pour régler automatiquement la luminosité d'affichage et support de stockage

Legal Events

Date Code Title Description
121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 17914025

Country of ref document: EP

Kind code of ref document: A1

NENP Non-entry into the national phase

Ref country code: DE

122 Ep: pct application non-entry in european phase

Ref document number: 17914025

Country of ref document: EP

Kind code of ref document: A1

32PN Ep: public notification in the ep bulletin as address of the adressee cannot be established

Free format text: NOTING OF LOSS OF RIGHTS PURSUANT TO RULE 112(1) EPC (EPO FORM 1205A DATED 07.04.2020)

122 Ep: pct application non-entry in european phase

Ref document number: 17914025

Country of ref document: EP

Kind code of ref document: A1