Unlock instant, AI-driven research and patent intelligence for your innovation.

Database access control method, device and database system

An access control and database technology, applied in the database field, can solve problems such as performance impact and physical isolation of data, and achieve the effect of reducing mutual influence

Active Publication Date: 2022-03-25
ALIBABA CLOUD COMPUTING LTD
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] In the existing way of realizing multiple users sharing the same table, the distributed database system does not physically isolate the data, and each user uses all the nodes of the distributed database system together, and the performance of each user may affect each other

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
  • Database access control method, device and database system
  • Database access control method, device and database system
  • Database access control method, device and database system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0027] In order to make the objectives, technical solutions and advantages of the present application clearer, the technical solutions of the present application will be clearly and completely described below with reference to the specific embodiments of the present application and the corresponding drawings. Obviously, the described embodiments are only a part of the embodiments of the present application, but not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by those of ordinary skill in the art without creative efforts shall fall within the protection scope of the present application.

[0028] In order to facilitate the understanding of the embodiments of the present application, several elements that will be introduced in the description of the embodiments of the present application are first introduced here.

[0029] Distributed database: refers to the use of high-speed computer networks to connect multiple phy...

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 present application discloses a database access control method, device and database system. The method includes: a management node in the distributed database receives the user's data operation statement; Execute the data operation request corresponding to the data operation statement, wherein the authorized node is a node in the distributed database where the user has the access authority of the data operation type corresponding to the data operation statement. The solutions in the embodiments of the present application can prevent users from performing data operation requests on nodes without access rights, and reduce the mutual influence between data accesses of different users.

Description

technical field [0001] The present application relates to the field of databases, and in particular, to a database access control method, apparatus and database system. Background technique [0002] In a distributed database system, permissions control on databases, tables, users, and columns are generally set to control the data that each user can see. [0003] In practical applications, a distributed database system will have multiple users, so there may be situations where multiple users share a data table, and each user can only see the data that he or she has permission to view. A common method for multiple users to share a table in an existing database is: when a user queries this table, a condition is injected into the query, for example, user A only runs data records whose query field c is 1, and so on. [0004] In the existing method of realizing multiple users sharing the same table, the distributed database system does not physically isolate data, and each user u...

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
Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/25G06F16/2458
CPCG06F16/2471G06F16/25
Inventor 范孝剑张广舟林晓斌窦贤明
Owner ALIBABA CLOUD COMPUTING LTD