Automatic data comparison method and device and electronic equipment

A data comparison and database technology, applied in structured data retrieval, database models, relational databases, etc., can solve problems such as large manpower consumption

Pending Publication Date: 2019-07-30
PINGAN PUHUI ENTERPRISE MANAGEMENT CO LTD
View PDF10 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] In order to solve the problem of high manpower consumption in related technologies, the pr

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Automatic data comparison method and device and electronic equipment
  • Automatic data comparison method and device and electronic equipment
  • Automatic data comparison method and device and electronic equipment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0063] The implementation environment of the present invention may be an electronic device, such as a smart phone, a tablet computer, or a desktop computer.

[0064] figure 1 It is a structural schematic diagram of a device disclosed in an embodiment of the present invention. The apparatus 100 may be the above-mentioned electronic equipment. Such as figure 1 As shown, apparatus 100 may include one or more of the following components: processing component 102 , memory 104 , power component 106 , multimedia component 108 , audio component 110 , sensor component 114 , and communication component 116 .

[0065] The processing component 102 generally controls the overall operations of the device 100, such as operations associated with display, phone calls, data communications, camera operations, and recording operations, among others. The processing component 102 may include one or more processors 118 to execute instructions to complete all or part of the steps of the methods de...

Embodiment 2

[0074] see figure 2 , figure 2 It is a schematic flowchart of an automatic data comparison method disclosed in the embodiment of the present invention. Such as figure 2 The shown automatic data comparison method may include the following steps:

[0075] 201. Receive a first database retrieval instruction and a second database retrieval instruction input by a user; wherein, the first database retrieval instruction is used to extract the first comparison data from the first database, and the second database retrieval instruction is used to extract the first comparison data from the second database Extract the second comparison data.

[0076] The embodiment of the present invention may be applied to an automatic data comparison device or electronic equipment, which is not specifically limited.

[0077] In the embodiment of the present invention, the first database may be an HBase database, and the second database may be an Oracle database. Both the HBase database and the ...

Embodiment 3

[0089] see image 3 , image 3 It is a schematic flowchart of another automatic data comparison method disclosed in the embodiment of the present invention. Such as image 3 As shown, the automatic data comparison method may include the following steps:

[0090] 301. Receive a first database retrieval instruction and a second database retrieval instruction input by a user; wherein, the first database retrieval instruction is used to extract the first comparison data from the first database, and the second database retrieval instruction is used to extract the first comparison data from the second database Extract the second comparison data.

[0091] 302. Extract the first database name from the first database retrieval instruction, and extract the second database name from the second database retrieval instruction.

[0092] 303. Judging whether the automatic data comparison device establishes a connection with the first database corresponding to the name of the first databa...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention relates to the technical field of data synchronization, and discloses an automatic data comparison method and device and electronic equipment. The method comprises the following steps: receiving a first database retrieval instruction and a second database retrieval instruction input by a user; wherein the first database retrieval instruction is used for extracting first comparison data from a first database, and the second database retrieval instruction is used for extracting second comparison data from a second database; extracting first comparison data from the first database according to the first database retrieval instruction; extracting second comparison data from the second database according to the second database retrieval instruction; analyzing difference information between the first comparison data and the second comparison data; and generating a comparison result according to the difference information obtained through analysis. Therefore, the retrieved comparison data can be automatically extracted from the database according to the database retrieval instruction input by the user, and the comparison result after comparison is generated, so that the manual workload is greatly reduced.

Description

technical field [0001] The invention relates to the technical field of data synchronization, in particular to an automatic data comparison method and device, and electronic equipment. Background technique [0002] In daily work, the same data is usually sent to different processors and stored in different databases. For example, the branch office system uploads the sales order to the head office system to be stored in the database of the head office system, and also stores the above sales order in its own database. Therefore, in order to ensure the consistency of the data, it is often necessary to compare and analyze the data with similar content and from different databases, so as to find and correct the errors. Based on this demand, data comparison tools came into being, and can extract the differences between the comparison data. [0003] The current data comparison tools on the market, such as Excel, need to manually query the data in the database, and manually paste t...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
IPC IPC(8): G06F16/28G06F16/2455
CPCG06F16/284G06F16/2455
Inventor 何海鲜
Owner PINGAN PUHUI ENTERPRISE MANAGEMENT CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap