Data access method under hybrid storage architecture

A data access and hybrid storage technology, applied in structured data retrieval, database indexing, database management systems, etc., can solve problems such as lack of unified management of faults, database system changes, etc., to achieve enhanced scalability, reduced complexity, and convenience Effects of management and use

Active Publication Date: 2016-09-21
JILIN UNIV
View PDF2 Cites 12 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0009] The technical problem to be solved by the present invention is to overcome the complexity of database management and data access under the hybrid storage architecture, a

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
  • Data access method under hybrid storage architecture
  • Data access method under hybrid storage architecture
  • Data access method under hybrid storage architecture

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0193] Example 1: After user 1 enters the request: select*from table1db2 at the user end, the system verifies whether user 1 has permission, if user 1 does not have permission, the request will not be supported, if user 1 has the permission, the request will be forwarded to data access system. According to the request of user 1, the system forwards the request to the DB2 database (IBM's relational database). After receiving the request, the DB2 database executes the request to generate a result set, and forwards the result set to the system. Finally, the system displays the result set to user 1. Accessing a hybrid storage architecture that does not adopt a unified format requires users to find the corresponding database nodes themselves, and requires users to understand each type of database. Not only is the operation complex, but also the requirements for staff are high. From this example, it can be clearly seen that this method is based on a unified query format, which simp...

Embodiment 2

[0194] Example 2: After user 2 inputs a request on the client side: db.users.find(null,{“name”:true,”country”:true,”_id”:false}) mongoDB, the system verifies whether user 2 has permission , if user 2 does not have the authority, the request is not supported, and if user 2 has the authority, the request is forwarded to the data access system. According to the request of user 2, the system forwards the request to the mongoDB database (a popular non-relational database). After receiving the request, the mongoDB database executes the request to generate a result set, and forwards the result set to the system. Finally, the system displays the result set to user 2.

Embodiment 3

[0195] Example 3: After user 3 enters select * from table3oracle on the user end, the system verifies whether user 3 has authority, if user 3 does not have authority, the request will not be supported, if user 3 has the authority, the request will be forwarded to data access system. The system forwards the request to the Oracle database (the relational database of Oracle Corporation) according to the request of user 3, but at this time the Oracle database node server fails, the request cannot be delivered, and the system sends the error to the fault handling module. The fault processing module judges that the Oracle database node server has failed at this time, and the fault processing module issues a warning and returns 3 error messages to the user.

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 discloses a data access method under hybrid storage architecture, and overcomes the problem that database management and data access exhibit complexity and database system changes and faults lack uniform management under the hybrid storage architecture. The data access method under the hybrid storage architecture comprises the following steps: 1) processing a data request and 2) carrying out software change and fault processing. The step 1) comprises the following steps: (1) verifying the access request of a user: requesting a verification module to inquire the cache of a metadata information item to finish verification, and distributing one partial cache, which aims at a database or cluster state zone bit and the activation bit of an agent module, of one piece of metadata information to the verification module, and utilizing the cache to quicken verification speed; (2) adding the data access request to the access cache; (3) carrying out route processing on the request; (4) processing a transactional agent; (5) executing the request; and (6) generating a result or a report of a uniform format. The step 2) comprises the following steps: (1) carrying out the periodic detection and response of the metadata information; (2) carrying out software change processing; and (3) carrying out fault processing.

Description

technical field [0001] The present invention relates to a data access method, more precisely, the present invention relates to a data access method based on a hybrid storage architecture of a non-relational database system and a relational database system. Background technique [0002] In recent years, many companies have used a variety of data storage technologies that are more suitable for running on clusters according to actual scenarios. These technologies basically do not use SQL (Structured Query Language), but open source database technology called non-relational Type database technology (NoSQL technology). [0003] However, the capabilities of relational database systems in online transaction processing are still beyond the reach of non-relational database systems, especially in certain industries such as banking and telecommunications, where data storage is inseparable from relational databases. Therefore, a data storage solution that mixes non-relational database ...

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): G06F17/30
CPCG06F16/22G06F16/25G06F16/27
Inventor 康辉包涵余大洲王凯于跃魏达
Owner JILIN UNIV
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