Stateless data unified access method and system for relational database and non-relational database

Abstract

The invention discloses a stateless unified access middleware method and system for a relational database and a non-relational database, and belongs to the technical field of computer application, and the method comprises the following steps: performing data access on the relational database and the non-relational database through pre-established stateless unified access middleware of the relational database and the non-relational database, unified access of data in the relational database and the non-relational database is realized; the middleware is established through the following method: connecting a relational database and a non-relational database, and performing MyConsection unified packaging on the relational database and the non-relational database to realize stateless unified acquisition and persistence of data of the relational database and the non-relational database; the middleware is stateless, so that an application system is more convenient and efficient to use, and thread security is realized in multi-thread development; different types of database operation differences are shielded, a user can operate two databases in a unified mode, and a unified data access and persistent interface is provided for the user.

Description

technical field [0001] The invention relates to a stateless data unified access method and system of a relational database and a non-relational database, belonging to the technical field of computer applications. Background technique [0002] In recent years, with the development of information technology, big data technology has been widely used in various information fields. Among them, HBASE and MongoDB are non-relational databases, which are widely used in the field of big data. There are differences in data access operations between HBASE, MongoDB and relational databases. Larger, HBASE is a column-oriented database, which is based on Hadoop distributed files, and has its own set of commands for data access operations; MongoDB is a database oriented to JSON objects, and has its own set of operation commands; relational databases Mainly SQL operations; with the development of big data technology in recent years, relational databases, and non-relational databases such as ...

AI Technical Summary

Problems solved by technology

[0002] In recent years, with the development of information technology, big data technology has been widely used in various information fields. Among them, HBASE and MongoDB are non-relational databases, which are widely used in the field of big data. There are differences in data access operations between HBASE, MongoDB and relational databases. Larger, HBASE is a column-oriented database, which is based on Hadoop distributed files, and has its own set of commands for data access operations; MongoDB is a database oriented to JSON objects, and has its own set of operation commands; relational databases Mainly SQL operations; with the development of big data technology in recent years, relational databases, and non-relational databases such as Hbase and MongoDB are often mixed in an information system to shield the differences in operations on different types of databases, allowing users to It is of great significance to operate non-relational and relational databases in a unified manner, so that the first aspect reduces the threshold for using non-relational Hbase and MongoDB databases; the second aspect improves the development efficiency of developers; the third aspect improves the application software Reliability; at present, there is no such middleware in China or abroad

Images