CN102999629A - Asynchronous transfer system for transferring relation database into schema-less database and asynchronous transfer method therefor - Google Patents

Asynchronous transfer system for transferring relation database into schema-less database and asynchronous transfer method therefor Download PDF

Info

Publication number
CN102999629A
CN102999629A CN2012105366161A CN201210536616A CN102999629A CN 102999629 A CN102999629 A CN 102999629A CN 2012105366161 A CN2012105366161 A CN 2012105366161A CN 201210536616 A CN201210536616 A CN 201210536616A CN 102999629 A CN102999629 A CN 102999629A
Authority
CN
China
Prior art keywords
database
mode
data
cell
relational database
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.)
Granted
Application number
CN2012105366161A
Other languages
Chinese (zh)
Other versions
CN102999629B (en
Inventor
马坤
杨波
陈广伟
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Shandong Sizheng Information Technology Co., Ltd
Original Assignee
University of Jinan
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 University of Jinan filed Critical University of Jinan
Priority to CN201210536616.1A priority Critical patent/CN102999629B/en
Publication of CN102999629A publication Critical patent/CN102999629A/en
Application granted granted Critical
Publication of CN102999629B publication Critical patent/CN102999629B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Landscapes

  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention discloses an asynchronous transfer system for transferring a relation database into a schema-less database and an asynchronous transfer method for transferring the relation database into the schema-less database. The asynchronous transfer system comprises a relation database, wherein the relation database transmits a signal to a log sound monitor, the log sound monitor transmits the signal to a mode adjuster, the mode adjuster transmits the signal to the schema-less database, the log sound monitor further transmits the signal to a table cell status register, the table cell status register transmits the signal to a table cell status write-back device, and the table cell status write-back device transmits the signal to the schema-less database. According to the invention, the mode and the data of the relation database are asynchronized and transferred into the schema-less database by the device on the premise that the performance of the relation database is not influenced, the asynchronous mode can not cause the blockage of the relation database, the relation database is taken as a main part, the schema-less database is taken as a subsidiary part, and the problem of I/O (input/output) bottleneck when the relation database queries the big data can be solved.

Description

A kind of relational database is to the asynchronous converting system of non-mode database and method
Technical field
The present invention relates to internet industry distributed data base field, relate in particular to a kind of relational database to the asynchronous converting system of non-mode database and method.
Background technology
Traditional relational is the principal mode of access data during present Web uses.Yet along with the development of the technology such as Web2.0, large data, cloud application, traditional relational database has run into bottleneck in I/O, extensibility, and efficient sharply descends when large data access and access, is also encountering a difficulty aspect enhanced scalability and the high availability.For head it off, many schemes propose in succession, such as distributed data base, master-slave database, non-mode database.The non-mode database is freely database of a kind of pattern, and its pattern is mainly the various ways such as relation, tree, figure, document.In fact, be difficult to abandon existing relational database fully and directly to use the non-mode database.Take relational database as main, the non-mode database is auxiliary, has become the generally accepted scheme of industry member and industrial community.
In the existing technology, the method that exists two class relational databases and non-mode database to carry out combination: (1) is with the method for user's plug-in unit, the non-mode database is integrated in relational database, so that relational database is supported relational operation and non-mode operation simultaneously.The method shortcoming is that the operation of a large amount of opening/closing table is very consuming time, has reduced database performance; (2) mix the use relational database, take relational database as main, the non-mode database is auxiliary, uses relational database to carry out large Data Update operation, adopts certain mechanism that relational data base schema and data are synchronized to the non-mode database.The non-mode database is directly used in inquiry for large data, still adopts relational database and upgrade.The method advantage is both to have solved the inquiry bottleneck problem of large data in the relational database, has solved again non-mode database update bottleneck problem.The difficult point of the method is how relational data base schema and data to be transformed into the non-mode database.The solution of prior art and realization mainly contain two kinds of methods: (1) by the relational database trigger, with the change records of data to interim question blank.This question blank is made of ID, table name, line number, timestamp and operation isotype usually.Then the data with interim question blank are synchronized to target non-mode database; (2) method (1) is improved, cancelled interim question blank, by increasing the self-defined HTTP function of relational database, directly relational database data variation increment is sent to target non-mode database by http protocol, realize the synchronous of data and pattern.
To sum up, existing relational database mainly contains following problem to the conversion method of non-mode database: (1) no matter be trigger or User-Defined Functions, it has a strong impact on the relational database performance; (2) data transmission procedure can't guarantee the order of data manipulation, causes easily the inconsistent of data; (3) method of synchronization meeting blocking data storehouse process, pattern and the Data Update performance of reduction relational database.
Summary of the invention
Purpose of the present invention is exactly in order to address the above problem, provide a kind of relational database to the asynchronous converting system of non-mode database and method, pattern and the data communication device of relational database are crossed the asynchronous non-mode database that is transformed into of this device, take relational database as main, the non-mode database is auxiliary, is used for solving the I/O bottleneck problem of traditional relational when large data query.
To achieve these goals, the present invention adopts following technical scheme:
A kind of relational database is to the asynchronous converting system of non-mode database, comprise relational database, described relational database is transferred to the daily record audiomonitor with signal, described daily record audiomonitor is transferred to the mode adjustment device with signal, described mode adjustment device is transferred to the non-mode database with signal, described daily record audiomonitor also is transferred to signal the cell status register, described cell status register is transferred to cell state write-back device with signal, and described cell state write-back device is transferred to the non-mode database with signal.
Described relational database is that relational database is to the source of the asynchronous converting system of non-mode database.
Described non-mode database is that relational database is to the target of the asynchronous converting system of non-mode database.
Described daily record audiomonitor is used for monitoring the daily record of relational database.Relational database binary log based on row comprises schema update and Data Update, and described schema update is recording the SQL statement of each schema modification, and described Data Update is recording in each affairs with the data before and after the behavior unit change.For update, supervising the front data of audible variation is NULL, and data are newly-increased data after changing; For the renewal operation, monitor and obtain revising the front and back data, for deletion action, supervising the front data of audible variation is deleted data, data are NULL after changing.
Described cell status register is responsible for the delta data based on row that the daily record audiomonitor listens to is split as the cell state.
Described mode adjustment device is responsible for the patterns of change that the daily record audiomonitor listens to is mapped to the non-mode database.Mapping ruler is as follows: the one-one relationship in the relational database is mapped as the relational structure in the non-mode database, one-to-many in the relational database or many-to-one relationship are mapped as the tree in the non-mode database, and the many-to-many relationship in the relational database is mapped as the pattern structure of non-mode database.The relational database database name is mapped as the non-mode database name, and the table name of relational database is mapped as non-mode database collection name (Collection), and the column index of relational database is mapped as the column index (Index) of non-mode database.
Described cell state write-back device is responsible for the cell state key assignments ordered pair in the cell status register is written to the non-mode database.
The conversion method that the above-mentioned relation database adopts to the asynchronous converting system of non-mode database, the specific works step is as follows:
Step (1): the daily record audiomonitor listens to the relational database binary log based on row, and resolve, the data that obtain changing and pattern, if listen to be delta data, turn step (2), otherwise turn step (3).
Step (2): the daily record audiomonitor will be the cell state based on the Data Division before and after the variation of row, if the cell data change, revise value and revision version among the cell state key assignments ordered pair V, if the cell data do not change, then do not carry out any processing, according to said method the cell state is stored in the cell status register, turns step (1).
Step (3): the daily record audiomonitor is resolved the patterns of change SQL statement that listens to, and all the cell states in the cell status register are written back to the non-mode database, turns step (4).
4) the schema modification SQL statement of monitoring according to the daily record audiomonitor, the mode adjustment device turns step (1) by source relational data base schema modifications target non-mode database schema.
The resolving of described step (3) is divided into following four steps:
Step (3-1): if cell state basic version be 1 and revision version be 0, illustrate that newly-increased cell is deleted, be left intact;
Step (3-2): if cell state basic version greater than 1 and revision version be 0, illustrate that newly-increased cell is deleted after revising, need in the non-mode database, delete corresponding data;
Step (3-3): if cell state basic version be 1 and revision version be not 0, be illustrated as newly-increased cell, the cell state need to be written back to the non-mode database;
Step (3-4): if cell state basic version greater than 0 and revision version be not 0, illustrate that cell is modified, need to revise non-mode database corresponding data.
The above-mentioned relation database relates to following term to the asynchronous converting system of non-mode database:
Described cell refers to the data in the relational database bivariate table in the cell state definition.
Described relational database is made of the data cells that ranks form.According to ranks positioning unit lattice, be expert at by major key key assignments ordered pair location database record, by row name locator data record column.Each cell state has defined a key assignments ordered pair K → V, and wherein K is defined as tlv triple<table name, major key key assignments ordered pair, row name 〉, and V is defined as two tuples<train value, revision version 〉.Revision version is recording the version information of these cell data, can represent with positive integer.Increasing the data initial version newly is 1, and after each cell data changed, version added 1.After the cell deletion, version modify is 0.
Described cell state revision version is the latest edition of cell state in buffer.
Described cell state basic version is the initial revision version of cell state in buffer.
For increasing data newly, be split as the cell state, its revision version and basic version are 1; For Update Table, be split as the cell state, if this cell is not in the cell status register, its revision version and basic version are 2, if this cell is in the cell status register, its revision version is that former revision version adds 1, and basic version is former cell state basic version; For the deletion data, revision version is 0.If cell is in the cell status register, basic version is former cell basic version, if cell not in the cell status register, basic version is 0.
Beneficial effect of the present invention:
1 performance that need not to affect relational database just can the implementation relation database to the asynchronous translation function of non-mode database;
2 asynchronous conversion equipments can guarantee the order of data in the data transmission procedure;
Can not cause the obstruction of relational database process in the 3 asynchronous data transfer processes;
4 that the pattern of relational database and data communication device are crossed this device is asynchronous to being transformed into the non-mode database, and take relational database as main, the non-mode database is auxiliary, is used for solving the I/O bottleneck problem of traditional relational when large data query.
Description of drawings
Fig. 1 relational database is to the Organization Chart of the asynchronous conversion method of non-mode database and device;
Fig. 2 removes the process flow diagram of amending unit trellis attitude according to the relational database delta data;
Fig. 3 cell state set is written back to the process flow diagram of non-mode database;
Wherein, 101, relational database, 102, the daily record audiomonitor, 103, the mode adjustment device, 104, the cell status register, 105, cell state write-back device, 106, non-mode database.
Embodiment
The invention will be further described below in conjunction with accompanying drawing and embodiment.
As shown in Figure 1, a kind of relational database is to the asynchronous converting system of non-mode database, comprise relational database 101, described relational database 101 is transferred to daily record audiomonitor 102 with signal, described daily record audiomonitor 102 is transferred to mode adjustment device 103 with signal, described mode adjustment device 103 is transferred to non-mode database 106 with signal, described daily record audiomonitor 102 also is transferred to signal cell status register 104, described cell status register 104 is transferred to cell state write-back device 105 with signal, and described cell state write-back device 105 is transferred to non-mode database 106 with signal.
Described relational database 101 is that relational database 101 is to the source of non-mode database 106 asynchronous conversion equipments.
Described non-mode database 106 is that relational database 101 is to the target of non-mode database 106 asynchronous conversion equipments.
The daily record that described daily record audiomonitor 102 is used for monitoring relational database 101.Relational database 101 binary logs based on row comprise schema update and Data Update, and described schema update is recording the SQL statement of each schema modification, and described Data Update is recording in each affairs with the data before and after the behavior unit change.For update, supervising the front data of audible variation is NULL, and data are newly-increased data after changing; For the renewal operation, monitor and obtain revising the front and back data, for deletion action, supervising the front data of audible variation is deleted data, data are NULL after changing.
Described cell status register 104 is responsible for the delta data based on row that daily record audiomonitor 102 listens to is split as cell.
The patterns of change that described mode adjustment device 103 is responsible for daily record audiomonitor 102 is listened to is mapped to non-mode database 106.Mapping ruler is as follows: the one-one relationship in the relational database 101 is mapped as the relational structure in the non-mode database 106, one-to-many in the relational database 101 or many-to-one relationship are mapped as the tree in the non-mode database 106, and the many-to-many relationship in the relational database 101 is mapped as the pattern structure of non-mode database 106.The database name of relational database 101 is mapped as the database name of non-mode database 106, the table name of relational database 101 is mapped as the set name (Collection) of non-mode database 106, and the column index of relational database 101 is mapped as the column index (Index) of non-mode database 106.
Described cell state write-back device 105 is responsible for the cell state key assignments ordered pair in the cell status register 104 is written to non-mode database 106.
As shown in Figure 2, remove the process flow diagram of the cell state in the amending unit trellis attitude buffer 104 according to relational database 101 delta datas, provided the cell state and generated the specific works process.
Step (110): daily record audiomonitor 102 is monitored the database binary log that relational database 101 produces, and parses delta data and schema modification SQL statement based on row;
Step (111): judge that resolving log information is data variation or patterns of change, if data variation enters step (112), if patterns of change enters step (126);
Step (112): if log information is data variation, continues judging unit trellis attitude buffer 104 usage spaces and whether reach threshold value, just enter step (126) if reach; Just do not enter step (113) according to the cell state in the delta data amending unit trellis attitude buffer 104 if reach;
Step (113): judge the data variation type that daily record audiomonitor 102 parses; If change type just enters step (114) for increasing; If change type just enters step (117) for revising; If change type just enters step (122) for deletion;
Step (114): the data variation type is for increasing: data are NULL before changing, and data are newly-increased data after changing; Enter step (115);
Step (115): increase data with every and be split as a plurality of cell states by row, the cell state is kept at cell status register 104; Enter step (116);
Step (116): basic version and the revision version of each cell state are set to 1; Enter step (128);
Step (117): the data variation type is for revising: data are data before revising before changing, and data are data after revising after changing;
Step (118): data after every modification are split as the cell state by row, only the cell state that changes of processing costs;
Step (119): Already in whether judging unit trellis attitude cell status register 104; If just entering step (120); If just do not entering step (121);
Step (120): if cell state cell status register 104 is Already in then revised the value of this cell state, cell state revision version is added 1; Enter step (128);
Step (121): if the cell state is then revised the value of this cell state not at cell status register 104, cell state basic version and revision version are set to 2, are kept at cell status register 104; Enter step (128);
Step (122): the data variation type is deletion: data are data before the deletion before changing, and data are NULL after changing; Enter step (123);
Step (123): every row deletion data are split as the cell state by row, are kept at cell status register 104; Enter step (124);
Step (124): the cell state value is made as NULL; Enter step (125);
Step (125): cell state revision version is made as 0; Enter step (128);
Step (126): if log information is patterns of change, use cell state write-back device 105 that all the cell states in the cell status register 104 are written back to non-mode database 106; Enter step (127);
Step (127): according to the patterns of change SQL statement that daily record audiomonitor 102 parses, the pattern of using mode adjustment device 103 to remove revise goal non-mode database 106.
Step (128): judge whether to finish, if just finish, just return if not step (111).
The concrete steps of described step (126) are shown in figure (3), and Fig. 3 is the process flow diagram that the cell state set in the cell status register 104 is written back to non-mode database 106,
Step (130): from cell status register 104, take out a cell state; Enter step (131);
Step (131): judge this cell state basic version; If basic version is 1 then enters step (132); Otherwise enter step (137);
Step (132): if this cell state basic version is 1, illustrate that this cell is initially newly-increased data in cell status register 104;
Step (133): judge whether this cell state revision version is 0; If revision version is 0 just to enter step (134); Otherwise enter step (135);
Step (134): if cell state revision version is 0, illustrate that this cell is deleted after the newly-increased data, is left intact; Enter step (143);
Step (135): if cell state revision version is not 0, illustrate that cell is newly-increased data; Enter step (136);
Step (136): use cell state write-back device 105 that this cell state is written back to non-mode database 106 as newly-increased data; Enter step (143);
Step (137): if this cell state basic version greater than 1, illustrates that this cell is initially Update Table in cell status register 104; Enter step (138);
Step (138): judge this cell state revision version; If 0 just enter step (139); Otherwise enter step (141);
Step (139): if cell state revision version is 0, illustrate that this cell is deleted after revising; Enter step (140);
Step (140): use cell state write-back device 105 that this cell corresponding data item in non-mode database 106 is deleted, enter step (143);
Step (141): if cell state revision version is not 0, illustrate that cell is Update Table; Enter step (142);
Step (142): use cell state write-back device 105 values with data item corresponding in this cell state last look correction non-mode database 106; Enter step (143);
Step (143): judge whether to finish, if just finish, just return if not step (130).
Although above-mentionedly by reference to the accompanying drawings the specific embodiment of the present invention is described; but be not limiting the scope of the invention; one of ordinary skill in the art should be understood that; on the basis of technical scheme of the present invention, those skilled in the art do not need to pay various modifications that creative work can make or distortion still in protection scope of the present invention.

Claims (9)

1. a relational database is to the asynchronous converting system of non-mode database, it is characterized in that, comprise relational database, described relational database is transferred to the daily record audiomonitor with signal, described daily record audiomonitor is transferred to the mode adjustment device with signal, described mode adjustment device is transferred to the non-mode database with signal, described daily record audiomonitor also is transferred to signal the cell status register, described cell status register is transferred to cell state write-back device with signal, and described cell state write-back device is transferred to the non-mode database with signal.
2. a kind of relational database as claimed in claim 1 is characterized in that to the asynchronous converting system of non-mode database, and described relational database is that relational database is to the source of the asynchronous converting system of non-mode database.
3. a kind of relational database as claimed in claim 1 is characterized in that to the asynchronous converting system of non-mode database, and described non-mode database is that relational database is to the target of the asynchronous converting system of non-mode database.
4. a kind of relational database as claimed in claim 1 is characterized in that to the asynchronous converting system of non-mode database, and described daily record audiomonitor is used for monitoring the daily record of relational database; Relational database binary log based on row comprises schema update and Data Update, and described schema update is recording the SQL statement of each schema modification, and described Data Update is recording in each affairs with the data before and after the behavior unit change; For update, supervising the front data of audible variation is NULL, and data are newly-increased data after changing; For the renewal operation, monitor and obtain revising the front and back data, for deletion action, supervising the front data of audible variation is deleted data, data are NULL after changing.
5. a kind of relational database as claimed in claim 1 is characterized in that to the asynchronous converting system of non-mode database, and described cell status register is responsible for the delta data based on row that the daily record audiomonitor listens to is split as cell.
6. a kind of relational database as claimed in claim 1 is characterized in that to the asynchronous converting system of non-mode database, and described mode adjustment device is responsible for the patterns of change that the daily record audiomonitor listens to is mapped to the non-mode database; Mapping ruler is as follows: the one-one relationship in the relational database is mapped as the relational structure in the non-mode database, one-to-many in the relational database or many-to-one relationship are mapped as the tree in the non-mode database, and the many-to-many relationship in the relational database is mapped as the pattern structure of non-mode database; The relational database database name is mapped as the non-mode database name, and the table name of relational database is mapped as non-mode database collection name, and the column index of relational database is mapped as the column index of non-mode database.
7. a kind of relational database as claimed in claim 1 is characterized in that to the asynchronous converting system of non-mode database, and described cell state write-back device is responsible for the cell state key assignments ordered pair in the cell status register is written to the non-mode database.
8. a kind of relational database as claimed in claim 1 is characterized in that to the conversion method that the asynchronous converting system of non-mode database adopts, and the specific works step is as follows:
Step (1): the daily record audiomonitor listens to the relational database binary log based on row, and resolve, the data that obtain changing and pattern, if listen to be delta data, turn step (2), otherwise turn step (3);
Step (2): the daily record audiomonitor will be the cell state based on the Data Division before and after the variation of row, if the cell data change, revise value and revision version among the cell state key assignments ordered pair V, if the cell data do not change, then do not carry out any processing, according to said method the cell state is stored in the cell status register, turns step (1);
Step (3): the daily record audiomonitor is resolved the patterns of change SQL statement that listens to, and all the cell states in the cell status register are written back to the non-mode database, turns step (4);
4) the schema modification SQL statement of monitoring according to the daily record audiomonitor, the mode adjustment device turns step (1) by source relational data base schema modifications target non-mode database schema.
9. a kind of relational database as claimed in claim 8 is characterized in that to the asynchronous conversion method of non-mode database, and the resolving of described step (3) is divided into following four steps:
Step (3-1): if cell state basic version be 1 and revision version be 0, illustrate that newly-increased cell is deleted, be left intact;
Step (3-2): if cell state basic version greater than 1 and revision version be 0, illustrate that newly-increased cell is deleted after revising, need in the non-mode database, delete corresponding data;
Step (3-3): if cell state basic version be 1 and revision version be not 0, be illustrated as newly-increased cell, the cell state need to be written back to the non-mode database;
Step (3-4): if cell state basic version greater than 0 and revision version be not 0, illustrate that cell is modified, need to revise non-mode database corresponding data.
CN201210536616.1A 2012-12-12 2012-12-12 A kind of relational database is to the asynchronous converting system of non-mode database and method Active CN102999629B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201210536616.1A CN102999629B (en) 2012-12-12 2012-12-12 A kind of relational database is to the asynchronous converting system of non-mode database and method

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201210536616.1A CN102999629B (en) 2012-12-12 2012-12-12 A kind of relational database is to the asynchronous converting system of non-mode database and method

Publications (2)

Publication Number Publication Date
CN102999629A true CN102999629A (en) 2013-03-27
CN102999629B CN102999629B (en) 2016-01-13

Family

ID=47928196

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201210536616.1A Active CN102999629B (en) 2012-12-12 2012-12-12 A kind of relational database is to the asynchronous converting system of non-mode database and method

Country Status (1)

Country Link
CN (1) CN102999629B (en)

Cited By (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103955538A (en) * 2014-05-19 2014-07-30 携程计算机技术(上海)有限公司 HBase data persistence and query methods and HBase system
CN104572505A (en) * 2015-02-03 2015-04-29 济南大学 System and method for ensuring eventual consistency of mass data caches
CN104598396A (en) * 2015-02-03 2015-05-06 济南大学 System and method for ensuring caching instantaneity and caching consistency of mass data
CN110019215A (en) * 2017-10-26 2019-07-16 Sap欧洲公司 Key schema management in multiple lease database system

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7702698B1 (en) * 2005-03-01 2010-04-20 Yahoo! Inc. Database replication across different database platforms
CN102622426A (en) * 2012-02-27 2012-08-01 杭州闪亮科技有限公司 Database writing system and database writing method

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7702698B1 (en) * 2005-03-01 2010-04-20 Yahoo! Inc. Database replication across different database platforms
CN102622426A (en) * 2012-02-27 2012-08-01 杭州闪亮科技有限公司 Database writing system and database writing method

Non-Patent Citations (4)

* Cited by examiner, † Cited by third party
Title
SHASHANK TIWARI: "《深入NoSQL》", 30 November 2012, 人民邮电出版社 *
佐佐木达也: "《NoSql数据库入门》", 31 May 2012, 人民邮电出版社 *
姚林等: "NoSQL的分布式存储与扩展解决方法", 《计算机工程》 *
张红霞: "《数据结构》", 31 August 2005, 河南大学出版社 *

Cited By (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103955538A (en) * 2014-05-19 2014-07-30 携程计算机技术(上海)有限公司 HBase data persistence and query methods and HBase system
CN103955538B (en) * 2014-05-19 2017-05-24 上海携程商务有限公司 HBase data persistence and query methods and HBase system
CN104572505A (en) * 2015-02-03 2015-04-29 济南大学 System and method for ensuring eventual consistency of mass data caches
CN104598396A (en) * 2015-02-03 2015-05-06 济南大学 System and method for ensuring caching instantaneity and caching consistency of mass data
CN104572505B (en) * 2015-02-03 2017-05-17 济南大学 System and method for ensuring eventual consistency of mass data caches
CN104598396B (en) * 2015-02-03 2017-06-16 济南大学 A kind of system and method for ensureing mass data caching real-time and uniformity
CN110019215A (en) * 2017-10-26 2019-07-16 Sap欧洲公司 Key schema management in multiple lease database system
CN110019215B (en) * 2017-10-26 2023-10-20 Sap欧洲公司 Key pattern management in a multi-tenancy database system

Also Published As

Publication number Publication date
CN102999629B (en) 2016-01-13

Similar Documents

Publication Publication Date Title
EP3365805B1 (en) Ability to group multiple container databases as a single container database cluster
US20180060389A1 (en) Query optimization over distributed heterogeneous execution engines
Bolles et al. Streaming SPARQL-extending SPARQL to process data streams
CN105260403B (en) General integration across database access method
CN104391730B (en) A kind of software source codes language translation system and method
CN105183860B (en) Method of data synchronization and system
CN107038162A (en) Real time data querying method and system based on database journal
CN103729447A (en) Method for fast searching database
US20150370836A1 (en) Labeling versioned hierarchical data
CN105320680A (en) Data synchronization method and device
CN104123374A (en) Method and device for aggregate query in distributed databases
US20080120322A1 (en) Techniques of efficient query over text, image, audio, video and other domain specific data in XML using XML table index with integration of text index and other domain specific indexes
CN102999629A (en) Asynchronous transfer system for transferring relation database into schema-less database and asynchronous transfer method therefor
CN101908075A (en) SQL-based parallel computing system and method
WO2015074466A1 (en) Data search method and apparatus
CN103279546B (en) Graph data query method
CN102722582A (en) System and method for integrating data on basis of reverse clearing
CN105335479A (en) Text data statistics realization method based on SQL
CN104598531A (en) Incremental data migration method among heterogeneous relational databases based on trigger
CN101710336A (en) Method for accelerating data processing by using relational middleware
CN102654878B (en) Data operation method for distributed database in embedded system and board card
CN114218218A (en) Data processing method, device and equipment based on data warehouse and storage medium
CN103412869A (en) Method for batch pushing of server data updating
CN103425751A (en) Linkage increment updating method of vector space data based on dependency
Martin et al. Scalable XML Collaborative Editing with Undo: (Short Paper)

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
C14 Grant of patent or utility model
GR01 Patent grant
TR01 Transfer of patent right
TR01 Transfer of patent right

Effective date of registration: 20200701

Address after: Room 212, block a, 253 nanxinzhuang West Road, Shizhong District, Jinan City, Shandong Province

Patentee after: Shandong Sizheng Information Technology Co., Ltd

Address before: Ji'nan City Central Jiwei Road No. 106 of 250022 cities in Shandong Province

Patentee before: University of Jinan