CN107784102A - A kind of data difference comparative approach based on oracle database - Google Patents
A kind of data difference comparative approach based on oracle database Download PDFInfo
- Publication number
- CN107784102A CN107784102A CN201711021180.1A CN201711021180A CN107784102A CN 107784102 A CN107784102 A CN 107784102A CN 201711021180 A CN201711021180 A CN 201711021180A CN 107784102 A CN107784102 A CN 107784102A
- Authority
- CN
- China
- Prior art keywords
- database
- data
- name
- difference
- database table
- Prior art date
- Legal status (The legal status 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 status listed.)
- Pending
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/242—Query formulation
- G06F16/2433—Query languages
-
- 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- 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/25—Integrating or interfacing systems involving database management systems
-
- 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/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computing Systems (AREA)
- Mathematical Physics (AREA)
- Computational Linguistics (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of data difference comparative approach based on oracle database, the method compared using text, data table name in two databases, database table field, data item are respectively converted into text-string, is each compared after sequence, finds out data difference.The present invention can provide the difference of two specified databases, including database table name difference, database table structure difference, data record difference and Variant statistical result automatically；The present invention makes full use of the existing data access interface of oracle database system and data management features, it is only necessary to the username and password of two databases is provided, without other manual interventions, you can obtains the detailed difference record of data；Because a variety of causes causes database difference problem during the present invention solves the operation of fast automatic lookup master/slave data storehouse, solve in the case of data volume is very big, artificial the problem of relatively speed is slow, cumbersome.
Description
Technical field
The present invention relates to Computer Database processing technology field, especially a kind of data difference based on oracle database
Different comparative approach.
Background technology
Master/slave data storehouse is that system passes through data to solve data safety and improve the effective ways of data access efficiency
Simultaneous techniques realizes the data consistency in master/slave data storehouse.But it is active and standby always to occur that various exceptions cause in data synchronization process
Database is inconsistent, and how to find out the difference between master/slave data storehouse is that synchronous basis is continued in master/slave data storehouse.Existing
In the data base consistency(-tance) method of inspection, more by the data consistency checks manually participated in, and need to enter the hand-manipulating of needle to database
Transformation to property.
The content of the invention
The technical problems to be solved by the invention are, there is provided a kind of data difference side based on oracle database
Method, the existing data access interface of oracle database system can be made full use of, without manual intervention in the case of, it is automatic real
Existing database compares, and includes database table name, database table structure, the difference of data record between master/slave data storehouse.
In order to solve the above technical problems, the present invention provides a kind of data difference comparative approach based on oracle database,
Comprise the following steps：
(1) two oracle databases are connected by two user names, password respectively, the access provided by database connects
Mouthful, using SQL statement, all database table names of two databases are obtained respectively, after being sorted according to table name, compares output and differs
The database table name of cause；
(2) for title identical database table, by SQL statement, all fields of each database table are read respectively
And its attribute, sorted according to field name, compare field name and whether attribute is identical, export different field name and attribute；
(3) sequence is re-started according to attribute difference to all fields, by SQL query statement, successively according to unique key,
Major key, title are ranked up, and data record is converted into character string, compare the difference of data record successively, export difference field.
Preferably, two are read from the system database table for reading two databases respectively by SQL statement in step (1)
All database table names under individual user, and be compared, specifically comprise the following steps：
(11) log database A and database B is distinguished by database login username and password；
(12) by SQL statement, affiliated data are found out respectively with the entitled querying condition of user from system database table
Storehouse table name, and according to database table name ascending sort；
(13) there is table name to be stored in two chained lists established in internal memory two data places of data respectively, and establish two
Individual pointer is respectively directed to the head of two chained lists；Two database table name differentiation count devices are established, record two databases respectively
Differ table name number；A database table name same count device is established, records same database table number, and establish a note
Use videotape to record with the empty chain table of database-name, all counter initial values are all 0；
(14) based on data via database sort, compare successively database table name that two pointers point to whether phase
Together, compare acquisition comparing result one by one, and count respectively；
(15) if all also having the database table name not compared, repeat step (14) in two chained lists；An if chain
There is no the database table name not compared in table, then exported using all records in another chained list as item is differed, and will
Remaining number increases on corresponding counter, exports statistical result, continues step (2)；If two chained lists all not by
The database table name compared, statistical result is exported, continue step (2).
Preferably, in step (2), all fields and its attribute of each database table include data type, length and are
No is sky.
Preferably, in step (2), for title identical database table, by SQL statement, each data are read respectively
All fields and its attribute of storehouse table, sort according to field name, compare field name and whether attribute is identical, export different fields
Name and attribute, specifically comprise the following steps：
(21) if without untreated table, end processing；Otherwise a database table name not being processed is taken out,
All fields of the table are taken out from the system database table of two databases respectively, by SQL statement by Database field name,
Field type, length, could be empty, whether be that major key is spliced into character string, and sorted according to field name；
(22) literary name section that sorted character string, the comparative approach recycle ratio field more therein of similar step (14) is utilized
Whether attribute is variant, and differences are exported if variant, and the table name is deleted from listC, goes to step (21)；If
There is no difference to go to step (3).
Preferably, in step (3), data query SQL statement is generated using the Database field attribute obtained, respectively
Data record is obtained, and completes to compare, is specifically comprised the following steps：
(31) its all field attribute is taken out from the system database table of a database, includes field name, field class
Type, length, could be empty, whether be major key, the Query Result of two databases is respectively stored in chained list, and linked list element includes
Field name, field type, length, could be empty, whether be major key；
(32) to all fields, be ranked up according to attribute priority difference, major key, non-NULL field are come before, it is raw
Into data base querying SQL statement, the sentence combines all data records in tables of data according to the priority of Database field
Into some character strings, string length is no more than the single field max-length that oracle database is supported, and is ranked up, raw
Into two data lists；
(33) compare data difference in two chained lists using the comparative approach of similar step (14), export discrepant data
Record and statistical result；Continue executing with step (21) and inquire about other database tables.
Beneficial effects of the present invention are：The present invention can provide the difference of two specified databases, including database automatically
Table name difference, database table structure difference, data record difference and Variant statistical result；The present invention makes full use of data base set
Unite existing data access interface and data management features, it is only necessary to the username and password of two databases is provided, without it
His manual intervention, you can obtain the detailed difference record of data；The present invention solves the operation of fast automatic lookup master/slave data storehouse
Period because a variety of causes causes database difference problem, is solved in the case of data volume is very big, artificial relatively speed is slow,
The problem of cumbersome.
Brief description of the drawings
Fig. 1 is the method flow schematic diagram of the present invention.
Fig. 2 is the comparison in difference handling process schematic diagram of the database table title of the present invention.
Embodiment
As shown in figure 1, a kind of data difference comparative approach based on oracle database, comprises the following steps：
Step 1, two oracle databases are connected by two user names, password respectively, the visit provided by database
Interface is asked, using SQL statement, all database table names of two databases is obtained respectively, after being sorted according to table name, compares output
Inconsistent database table name；
Step 2, for title identical database table, by SQL statement, all words of each database table are read respectively
Section and its attribute (data type, length, whether can be sky etc.), sort according to field name, compare field name and attribute whether phase
Together, different field name and attribute are exported；
Step 3, sequence is re-started according to attribute difference to all fields, by SQL query statement, successively according to unique
Key, major key, title are ranked up, and data record is converted into character string, once compare the difference of data record, export difference word
Section.
As shown in Fig. 2 read two from the system database table for reading two databases respectively by SQL statement in step 1
All database table names under individual user, and be compared, step is as follows：
Step 1-1, log database A and database B is distinguished by database login username and password, it is assumed that user name
Password is respectively userA/passwdA and userB/passwdB；
Step 1-2, by SQL statement, distinguished from system database table all_tables with the entitled querying condition of user
Affiliated database table name is found out, query statement is as follows：
Select TABLE_NAME from all_tables where owner=' userA ' order by TABLE_
NAME；
Select TABLE_NAME from all_tables where owner=' userB ' order by TABLE_
NAME；
Query Result is respectively all database table titles under user userA and userB, and according to database table name liter
Sequence sorts.
Step 1-3, respectively by two data places of data have table name be stored in established in internal memory two chained list listA,
In listB, and establish the head that two pointers pA and pB are respectively directed to two chained lists.Establish two database table name differentiation counts
Device numA, numB, respectively database of record A and database B differ table name number；Establish a database table name same count
Device numC, same database table number is recorded, and establish the empty chain table listC of a record identical data library name.All meters
Number device initial value is all 0；
Step 1-4, compare whether the database table name that two pointers point to is identical, if the table name character string that pA is pointed to is small
In the table name character string that pB is pointed to, then the table name that pA is pointed to is exported, and pA points to next table name, and pB is constant, and will count
Device numA adds 1；If the table name character string that pA is pointed to is identical with the table name character string that pB is pointed to, will indicate that increases in listC,
It is identical to show that counter numC adds 1, pA and pB to all point to next table name；If the table name character string that pA is pointed to is pointed to more than pB
Table name character string, then export the table name that pB is pointed to, while pB points to next table name, pA is constant, and counter numB is added
1；Subsequently more use the method.
Step 1-5, if all also having the database table name not compared, repeat step 1-4 in two chained lists；If one
There is no the database table name not compared in chained list, then exported using all records in another chained list as item is differed, and
Remaining number is increased on corresponding counter numA or numB, output statistical result is numA, numB, numC value, after
Continuous step 2；If the database table name that two chained lists are not all compared, output statistical result is numA, numB, numC
Value, continue step 2.
For title identical database table in step 2, by SQL statement, all of each database table are read respectively
Whether field and its attribute (data type, length, can be sky etc.), sort according to field name, whether compares field name and attribute
It is identical, different field name and attribute are exported, step is as follows：
Step 2-1, if there is no untreated table in listC, end processing.Otherwise taking out one from listC does not have
Processed database table name, it is assumed that table name is " tablenameTest ", respectively from the system database table of two databases
Table " tablenameTest " is taken out in user_table_column, user_ind_columns, user_constraints
All fields, and its property value (comprising field name, field type, length, could be sky, whether be major key).
By SQL statement by Database field name, field type, length, could be empty, whether be that major key is spliced into character
String, and sorted according to field name.The Query Result of two databases is respectively stored in chained list StructListA,
In StructListB, linked list element be by field name, field type, length, could be it is empty, whether be major key splicing character
String.
Step 2-2, data field is ranked, more therein using the similar comparative approach recycle ratios of similar step 1-4
Whether field attribute is variant, and differences are exported if variant, and the table name is deleted from listC, goes to step 2-1；
If no difference goes to step 3.
Using the Database field attribute generation data query SQL statement obtained in step 3, data note is obtained respectively
Record, and complete to compare, step is as follows：
Step 3-1, because step 2 has judged that table " tablenameTest " structure on two databases is identical, from one
Taken out in system database the table user_table_column, user_ind_columns, user_constraints of database
Its all field attribute, comprising field name, field type, length, could be empty, whether be major key.
The Query Result of two databases is respectively stored in chained list PropertyList, linked list element include field name,
Field type, length, could be empty, whether be major key.
Step 3-2, to all fields in PropertyList, be ranked up according to attribute priority difference, by major key,
Before non-NULL field comes, data base querying SQL statement is generated.The sentence will be all in tables of data " tablenameTest "
Data record synthesizes some character strings according to the priority groups of Database field, and string length is no more than oracle database branch
The single field max-length (4000 byte) held, and be ranked up, two data list DataListA are generated,
DataListB。
Wherein dataItemij (i=1 ... M, j=1 ... N) represents all words in database table " tablenameTest "
Section, dataItemi1, dataItemi2 ..., dataItemiN field length are added up no more than oracle database branch
The single field max-length (4000 byte) held.Wherein " before nulls first " represent that null value comes.Respectively in two numbers
According to performing above-mentioned query SQL sentence on storehouse, and Query Result is stored in data list DataListA, DataListB；
Step 3-3, compare DataListA, two lists of DataListB using the similar comparative approach of similar step 1-4
Data difference, export discrepant data record and statistical result.Continue executing with step 2-1 and inquire about other database tables.
Although the present invention is illustrated and described with regard to preferred embodiment, it is understood by those skilled in the art that
Without departing from scope defined by the claims of the present invention, variations and modifications can be carried out to the present invention.
Claims (5)
1. a kind of data difference comparative approach based on oracle database, it is characterised in that comprise the following steps：
(1) two oracle databases are connected by two user names, password respectively, the access interface provided by database,
Using SQL statement, all database table names of two databases are obtained respectively, after being sorted according to table name, it is inconsistent to compare output
Database table name；
(2) for title identical database table, by SQL statement, read respectively each database table all fields and its
Attribute, sorted according to field name, compare field name and whether attribute is identical, export different field name and attribute；
(3) sequence is re-started according to attribute difference to all fields, by SQL query statement, successively according to unique key, master
Key, title are ranked up, and data record is converted into character string, compare the difference of data record successively, export difference field.
2. the data difference comparative approach based on oracle database as claimed in claim 1, it is characterised in that step (1)
In by SQL statement, all database tables under two users are read from the system database table for reading two databases respectively
Name, and be compared, specifically comprise the following steps：
(11) log database A and database B is distinguished by database login username and password；
(12) by SQL statement, affiliated database table is found out respectively with the entitled querying condition of user from system database table
Name, and according to database table name ascending sort；
(13) there is table name to be stored in two chained lists established in internal memory two data places of data respectively, and establish two fingers
Pin is respectively directed to the head of two chained lists；Two database table name differentiation count devices are established, record two databases not respectively
Identical table name number；A database table name same count device is established, records same database table number, and establishes a record phase
With the empty chain table of database-name, all counter initial values are all 0；
(14) whether based on data via database sort, it is identical to compare the database table name that two pointers point to successively, by
Bar compares acquisition comparing result, and counts respectively；
(15) if all also having the database table name not compared, repeat step (14) in two chained lists；If in a chained list
The database table name not compared, then using all records in another chained list as differing item output, and by residue
Number increases on corresponding counter, exports statistical result, continues step (2)；If two chained lists are not all compared
Database table name, export statistical result, continue step (2).
3. the data difference comparative approach based on oracle database as claimed in claim 1, it is characterised in that step (2)
In, whether all fields and its attribute of each database table including data type, length and are empty.
4. the data difference comparative approach based on oracle database as claimed in claim 1, it is characterised in that step (2)
In, for title identical database table, by SQL statement, all fields and its attribute of each database table are read respectively,
Sorted according to field name, compare field name and whether attribute is identical, export different field name and attribute, specifically include following step
Suddenly：
(21) if without untreated table, end processing；Otherwise a database table name not being processed is taken out, respectively
All fields of the table are taken out from the system database table of two databases, by SQL statement by Database field name, field
Type, length, could be empty, whether be that major key is spliced into character string, and sorted according to field name；
(22) literary name section that sorted character string, the comparative approach recycle ratio field attribute more therein of similar step (14) is utilized
It is whether variant, differences are exported if variant, and the table name is deleted from listC, go to step (21)；If no
Difference goes to step (3).
5. the data difference comparative approach based on oracle database as claimed in claim 1, it is characterised in that step (3)
In, data query SQL statement is generated using the Database field attribute obtained, obtains data record respectively, and complete ratio
It is right, specifically comprise the following steps：
(31) its all field attribute is taken out from the system database table of a database, includes field name, field type, length
Spend, could be empty, whether be major key, the Query Result of two databases is respectively stored in chained list, and linked list element includes field
Name, field type, length, could be empty, whether be major key；
(32) to all fields, be ranked up according to attribute priority difference, major key, non-NULL field are come before, generate number
According to library inquiry SQL statement, if the sentence synthesizes all data records in tables of data according to the priority groups of Database field
Dry character string, string length is no more than the single field max-length that oracle database is supported, and is ranked up, generation two
Individual data list；
(33) compare data difference in two chained lists using the comparative approach of similar step (14), export discrepant data record
And statistical result；Continue executing with step (21) and inquire about other database tables.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711021180.1A CN107784102A (en) | 2017-10-27 | 2017-10-27 | A kind of data difference comparative approach based on oracle database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711021180.1A CN107784102A (en) | 2017-10-27 | 2017-10-27 | A kind of data difference comparative approach based on oracle database |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107784102A true CN107784102A (en) | 2018-03-09 |
Family
ID=61431720
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711021180.1A Pending CN107784102A (en) | 2017-10-27 | 2017-10-27 | A kind of data difference comparative approach based on oracle database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107784102A (en) |
Cited By (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108509612A (en) * | 2018-03-30 | 2018-09-07 | 北京润科通用技术有限公司 | A kind of data processing method and device |
| CN110069571A (en) * | 2019-03-18 | 2019-07-30 | 平安普惠企业管理有限公司 | A kind of automated data control methods and device, electronic equipment |
| CN110717078A (en) * | 2019-09-16 | 2020-01-21 | 武汉安诠加信息技术有限公司 | Beauty shop business data monitoring method, device, equipment and medium |
| CN110852058A (en) * | 2019-09-24 | 2020-02-28 | 贵阳朗玛信息技术股份有限公司 | List comparison method and device |
| CN111046043A (en) * | 2019-12-11 | 2020-04-21 | 北京西骏数据科技股份有限公司 | Method for quickly and accurately checking database table |
| CN111064739A (en) * | 2019-12-26 | 2020-04-24 | 中国人民解放军陆军工程大学 | Data transmission platform and method thereof |
| CN111143368A (en) * | 2019-12-27 | 2020-05-12 | 瀚高基础软件股份有限公司 | Relational database data comparison method and system |
| CN111143406A (en) * | 2018-11-06 | 2020-05-12 | 北京京东尚科信息技术有限公司 | Database data comparison method and database data comparison system |
| CN111190986A (en) * | 2019-12-31 | 2020-05-22 | 武汉中海庭数据技术有限公司 | Map data comparison method and device |
| CN111459916A (en) * | 2020-04-16 | 2020-07-28 | 中国银行股份有限公司 | GBASE and ORAC L E database table comparison method and system |
| CN111966660A (en) * | 2020-07-08 | 2020-11-20 | 中国人民解放军63686部队 | Database comparison method based on ODBC access |
| CN112256711A (en) * | 2020-10-10 | 2021-01-22 | 武汉鼎森世纪科技有限公司 | Consistency verification method and system for big data synchronization |
| CN112287180A (en) * | 2020-10-26 | 2021-01-29 | 深圳市友华软件科技有限公司 | Fault machine repair management method based on MAC (media access control) search |
| CN111966660B (en) * | 2020-07-08 | 2024-07-05 | 中国人民解放军63686部队 | Database comparison method based on ODBC access |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6738757B1 (en) * | 1999-06-02 | 2004-05-18 | Workwise, Inc. | System for database monitoring and agent implementation |
| CN101236554A (en) * | 2007-11-29 | 2008-08-06 | 中兴通讯股份有限公司 | Database mass data comparison process |
| CN105989089A (en) * | 2015-02-12 | 2016-10-05 | 阿里巴巴集团控股有限公司 | Data comparison method and device |
| CN106484739A (en) * | 2015-09-01 | 2017-03-08 | 中兴通讯股份有限公司 | The structure comparative approach of data base and device |
-
2017
- 2017-10-27 CN CN201711021180.1A patent/CN107784102A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6738757B1 (en) * | 1999-06-02 | 2004-05-18 | Workwise, Inc. | System for database monitoring and agent implementation |
| CN101236554A (en) * | 2007-11-29 | 2008-08-06 | 中兴通讯股份有限公司 | Database mass data comparison process |
| CN105989089A (en) * | 2015-02-12 | 2016-10-05 | 阿里巴巴集团控股有限公司 | Data comparison method and device |
| CN106484739A (en) * | 2015-09-01 | 2017-03-08 | 中兴通讯股份有限公司 | The structure comparative approach of data base and device |
Cited By (17)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108509612A (en) * | 2018-03-30 | 2018-09-07 | 北京润科通用技术有限公司 | A kind of data processing method and device |
| CN111143406A (en) * | 2018-11-06 | 2020-05-12 | 北京京东尚科信息技术有限公司 | Database data comparison method and database data comparison system |
| CN110069571A (en) * | 2019-03-18 | 2019-07-30 | 平安普惠企业管理有限公司 | A kind of automated data control methods and device, electronic equipment |
| CN110717078A (en) * | 2019-09-16 | 2020-01-21 | 武汉安诠加信息技术有限公司 | Beauty shop business data monitoring method, device, equipment and medium |
| CN110852058A (en) * | 2019-09-24 | 2020-02-28 | 贵阳朗玛信息技术股份有限公司 | List comparison method and device |
| CN111046043A (en) * | 2019-12-11 | 2020-04-21 | 北京西骏数据科技股份有限公司 | Method for quickly and accurately checking database table |
| CN111064739B (en) * | 2019-12-26 | 2022-04-26 | 中国人民解放军陆军工程大学 | Data transmission platform and method thereof |
| CN111064739A (en) * | 2019-12-26 | 2020-04-24 | 中国人民解放军陆军工程大学 | Data transmission platform and method thereof |
| CN111143368A (en) * | 2019-12-27 | 2020-05-12 | 瀚高基础软件股份有限公司 | Relational database data comparison method and system |
| CN111143368B (en) * | 2019-12-27 | 2023-05-12 | 瀚高基础软件股份有限公司 | Relational database data comparison method and system |
| CN111190986A (en) * | 2019-12-31 | 2020-05-22 | 武汉中海庭数据技术有限公司 | Map data comparison method and device |
| CN111459916A (en) * | 2020-04-16 | 2020-07-28 | 中国银行股份有限公司 | GBASE and ORAC L E database table comparison method and system |
| CN111966660A (en) * | 2020-07-08 | 2020-11-20 | 中国人民解放军63686部队 | Database comparison method based on ODBC access |
| CN111966660B (en) * | 2020-07-08 | 2024-07-05 | 中国人民解放军63686部队 | Database comparison method based on ODBC access |
| CN112256711A (en) * | 2020-10-10 | 2021-01-22 | 武汉鼎森世纪科技有限公司 | Consistency verification method and system for big data synchronization |
| CN112256711B (en) * | 2020-10-10 | 2022-07-05 | 武汉鼎森电子科技有限公司 | Consistency verification method and system for big data synchronization |
| CN112287180A (en) * | 2020-10-26 | 2021-01-29 | 深圳市友华软件科技有限公司 | Fault machine repair management method based on MAC (media access control) search |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107784102A (en) | A kind of data difference comparative approach based on oracle database | |
| US9805079B2 (en) | Executing constant time relational queries against structured and semi-structured data | |
| KR101183312B1 (en) | Dispersing search engine results by using page category information | |
| US20140046928A1 (en) | Query plans with parameter markers in place of object identifiers | |
| WO2007143899A1 (en) | System and method for intelligent retrieval and treating of information | |
| US10437824B2 (en) | Querying across a composite join of multiple database tables using a search engine index | |
| CN103365992A (en) | Method for realizing dictionary search of Trie tree based on one-dimensional linear space | |
| Bellare et al. | Woo: A scalable and multi-tenant platform for continuous knowledge base synthesis | |
| JPH04124774A (en) | Data storage method for hierarchical construction in related data base | |
| GB2235798A (en) | Join processor for relational database | |
| CN113779349A (en) | Data retrieval system, apparatus, electronic device, and readable storage medium | |
| US11106739B2 (en) | Document structures for searching within and across messages | |
| US7039646B2 (en) | Method and system for compressing varying-length columns during index high key generation | |
| Podkorytov et al. | Hybrid. poly: A consolidated interactive analytical polystore system | |
| US6839716B1 (en) | Method and system for building a dataset | |
| TWI405089B (en) | Method for creating index in database, computer system thereof, and computer program product thereof | |
| Pavia et al. | Simplifying access to large-scale structured datasets by meta-profiling with scalable training set enrichment | |
| KR20090107145A (en) | The integrating and searching method of alien 2-dimension table | |
| Gaoyu et al. | Storage design and implementation of information reconstruction system | |
| KR100434718B1 (en) | Method and system for indexing document | |
| US11301448B2 (en) | Method and system of a secondary index in a distributed data base system | |
| JPS60129873A (en) | Document storage and retrieval system | |
| Kaufmann et al. | Text search using database systems revisited-Some experiments | |
| CN115329086B (en) | Track traffic document retrieval system and method based on classification coding | |
| CN108460067A (en) | Tile index structure, index structuring method and data retrieval method based on data |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| CB02 | Change of applicant information | ||
| CB02 | Change of applicant information |
Address after: No.1 Lingshan South Road, Qixia District, Nanjing City, Jiangsu Province 210046 Applicant after: THE 28TH RESEARCH INSTITUTE OF CHINA ELECTRONICS TECHNOLOGY Group Corp. Address before: 210000 No. 1 East Garden Street, Qinhuai District, Jiangsu, Nanjing Applicant before: THE 28TH RESEARCH INSTITUTE OF CHINA ELECTRONICS TECHNOLOGY Group Corp. |
|
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180309 |