CN104090873A - High-performance relational operation system for NoSQL (not only structured query language) database - Google Patents
High-performance relational operation system for NoSQL (not only structured query language) database Download PDFInfo
- Publication number
- CN104090873A CN104090873A CN201310110137.8A CN201310110137A CN104090873A CN 104090873 A CN104090873 A CN 104090873A CN 201310110137 A CN201310110137 A CN 201310110137A CN 104090873 A CN104090873 A CN 104090873A
- Authority
- CN
- China
- Prior art keywords
- database
- relational
- nosql
- calculus
- relational operation
- 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a high-performance relational operation system for a NoSQL (not only structured query language) database. Various NoSQL databases have the common major weakness of not providing or only providing finite relational operation capability. By the high-performance relational operation system for the NoSQL database, high-speed storage equipment with a built-in relational database is deployed to endow the NoSQL database with high relational operation capability like a conventional relational database. A main method is to import data required to be subjected to relational operation in the NoSQL database into the built-in relational database of the high-speed storage equipment for relational operation in real time through a data importing program. According to the system, the advantages of an SQL database and the NoSQL database are effectively combined, so that the problem of low relational operation capability of the NoSQL database is solved, functions and application scenarios of the NoSQL database are greatly expanded, and good technical support is provided for massive data processing and cloud computation.
Description
Technical field
Technical field of the present invention is the Database Systems of computing machine.
Background technology
Various NoSQL databases have easy expansion, high-performance, high availability, support big data quantity, data model advantage flexibly, in the Web2.0 epoch, be developed rapidly, but their total large weakness are the relational calculus abilities that does not provide or only provide very limited, brought a lot of inconvenience to the developer of application NoSQL database, the present invention has made up the deficiency of NoSQL database relation arithmetic capability effectively, has widened the application scenarios of NoSQL database.
Another background technology is the development of high speed storing equipment, and IOPS can reach 1,000,000 grades at present, and BPS can reach 6G, and the existence of high speed storing equipment makes us mass data can be imported and exported to Database Systems within the extremely short time.
Summary of the invention
The relational calculus ability of NoSQL database is very weak, the present invention is built in ripe relational database system encapsulation on high speed storing equipment, when application need to be carried out relational calculus to a certain partial data, by data importing program, this partial data in NoSQL database is imported in the relational database being encapsulated on high speed storing equipment in real time, then carry out required relational calculus, again operation result is preserved back in NoSQL database by database derivation program as required.
Because high speed storing equipment performance can reach the IOPS of 1,000,000 grades and the BPS of several G, this system can be carried out computing by the data that need to carry out relational calculus at every turn within the time of several milliseconds to 1 second from NoSQL database imports to relational database, and does not need total data to be all kept in the middle of relational database.The present invention effectively combines the advantage of SQL database and NoSQL database, solved the problem of NoSQL database relation arithmetic capability deficiency, greatly expanded the function and application scene of NoSQL database, for data processing and cloud computing provide better technical support greatly.
Accompanying drawing explanation
The structural representation of Fig. 1 system
Fig. 2 working-flow figure.
Claims (7)
1. one kind provides NoSQL database and relational database to comprise in conjunction with the method for carrying out relational calculus
In the time of need to carrying out relational calculus, related data is imported to relational database from NoSQL database;
The data that import in relational database are carried out to relational calculus;
The result of relational calculus is exported to NoSQL database from relational database.
2. the relational database in claim 1 can be general relational database, can be also database or the independently developed data handling system that possesses relational calculus function of customization.
3. the NoSQL database in claim 1 comprises the Database Systems that kinds of relationships arithmetic capability is not strong.
4. a method that promotes NoSQL database relation arithmetic capability by high speed storing equipment comprises
The data that only relational calculus needed are deposited in high speed storing equipment;
When carrying out relational calculus, related data is dynamically deposited in high speed storing equipment;
Built-in relational database system in high speed storing equipment.
5. the relational database in claim 4 can be general relational database, can be also database or the independently developed data handling system that possesses relational calculus function of customization.
6. the NoSQL database in claim 4 comprises the Database Systems that kinds of relationships arithmetic capability is not strong.
7. the high speed storing equipment in claim 4 comprises the memory device that data rate memory under arbitrary the method can meet application demand.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310110137.8A CN104090873A (en) | 2013-04-01 | 2013-04-01 | High-performance relational operation system for NoSQL (not only structured query language) database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310110137.8A CN104090873A (en) | 2013-04-01 | 2013-04-01 | High-performance relational operation system for NoSQL (not only structured query language) database |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104090873A true CN104090873A (en) | 2014-10-08 |
Family
ID=51638589
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310110137.8A Pending CN104090873A (en) | 2013-04-01 | 2013-04-01 | High-performance relational operation system for NoSQL (not only structured query language) database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104090873A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US11138194B2 (en) | 2019-04-02 | 2021-10-05 | International Business Machines Corporation | Method of extracting relationships from a NoSQL database |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20110258178A1 (en) * | 2010-04-19 | 2011-10-20 | Salesforce.Com | Methods and systems for performing cross store joins in a multi-tenant store |
| CN102982130A (en) * | 2012-11-16 | 2013-03-20 | 深圳市融创天下科技股份有限公司 | Synchronized method for not only structured query language (NOSQL) and relational database management system (RDBMS) database and system thereof |
-
2013
- 2013-04-01 CN CN201310110137.8A patent/CN104090873A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20110258178A1 (en) * | 2010-04-19 | 2011-10-20 | Salesforce.Com | Methods and systems for performing cross store joins in a multi-tenant store |
| CN102982130A (en) * | 2012-11-16 | 2013-03-20 | 深圳市融创天下科技股份有限公司 | Synchronized method for not only structured query language (NOSQL) and relational database management system (RDBMS) database and system thereof |
Non-Patent Citations (3)
| Title |
|---|
| 孙立: "关系数据库还是NoSQL数据库", 《INFOQ》 * |
| 张华强: "关系型数据库与NoSQL数据库", 《电脑知识与技术》 * |
| 蔡金花: "浅析NOSQL及使用", 《电脑知识与技术》 * |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US11138194B2 (en) | 2019-04-02 | 2021-10-05 | International Business Machines Corporation | Method of extracting relationships from a NoSQL database |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10452632B1 (en) | Multi-input SQL-MR | |
| CN106611037A (en) | Method and device for distributed diagram calculation | |
| CN104699723B (en) | Data synchronous system and method between data exchange adapter, heterogeneous system | |
| CN103440288A (en) | Big data storage method and device | |
| CN106156047B (en) | A kind of SNAPSHOT INFO processing method and processing device | |
| CN108460094A (en) | The method and system of storage statistical data | |
| Chawda et al. | Processing Interval Joins On Map-Reduce. | |
| EP3470992B1 (en) | Efficient storage and utilization of a hierarchical data set | |
| CN105956068A (en) | Webpage URL repetition elimination method based on distributed database | |
| CN109101575A (en) | Calculation method and device | |
| CN103699656A (en) | GPU-based mass-multimedia-data-oriented MapReduce platform | |
| CN107016039A (en) | The method and Database Systems of database write-in | |
| Li et al. | Challenges and trends of big data analytics | |
| CN105069109A (en) | Dilatation method and system of distributed database | |
| CN103235811A (en) | Data storage method and device | |
| CN103577431A (en) | Method, device and system for performing system design through multiple databases | |
| CN104881461A (en) | Rapid data storage method | |
| US20160253219A1 (en) | Data stream processing based on a boundary parameter | |
| CN102932416B (en) | A kind of intermediate data storage method of information flow task, processing method and device | |
| CN101894161B (en) | Recurring event access method and device for real-time monitoring | |
| CN110413561A (en) | Data accelerate processing system | |
| CN104090873A (en) | High-performance relational operation system for NoSQL (not only structured query language) database | |
| CN104239537A (en) | Method for realizing generating and processing flow for large-data pre-processing text data | |
| CN105373346B (en) | A kind of virtualization storage method and storage device | |
| US9058344B2 (en) | Supporting flexible types in a database |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20141008 |
|
| WD01 | Invention patent application deemed withdrawn after publication |