Partition permission management method based on distributed database

A permission management and database technology, applied in the database field, can solve the problems of high access control granularity, slow access speed, and low permission control ability.

Pending Publication Date: 2021-01-22
SHANDONG LANGCHAO YUNTOU INFORMATION TECH CO LTD
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] In the scenario where a large number of user requests exist in a traditional database with a large geographical span, because the data in the same table logically is often physically closer, there are limitations in data access, modification, and data access control. Role-based access control has higher granularity, slower access speed, and lower ability to control permissions

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
  • Partition permission management method based on distributed database
  • Partition permission management method based on distributed database
  • Partition permission management method based on distributed database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0031] The present invention will be further described below in conjunction with the accompanying drawings and specific embodiments.

[0032] The distributed database system connects many computers located in different locations to each other through the network to form a complete and global logically centralized and physically distributed large database.

[0033] A distributed database is logically a unified whole, but physically it is stored on different physical nodes. An application can access databases distributed in different geographical locations through the network. The distributed nature of the database is reflected in the fact that the data in the database are not stored in the same site, more precisely, they are not stored in the storage device of the same computer, but are stored in multiple sites in the computer network. This is the main difference between a distributed database and a centralized database. From the user's point of view, the distributed database...

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 partition permission management method based on a distributed database, belongs to the technical field of databases, and aims to partition data, set permission and grant permission including access permission and operation permission to partitions to a user. When a user operates the partition data, checking whether the partition data has access permission or not, and further checking whether the partition data has operation permission or not if the partition data has access permission; if no access permission exists, directly ending; and if the target data has the operation authority, performing corresponding operation on the target data, and if the target data has no operation authority, directly ending. According to the method, the inspection granularity and theinspection efficiency of the permission can be improved by utilizing the partition characteristics of the distributed database on the basis of improving the data access permission, retrieval of a large amount of data is avoided, and the retrieval rate of a database system is improved.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a partition authority management method based on distributed databases. Background technique [0002] In the scenario where a large number of user requests exist in a traditional database with a large geographical span, because the data in the same table logically is often physically closer, there are limitations in data access, modification, and data access control. Role-based access control has higher granularity, slower access speed, and lower ability to control permissions. Contents of the invention [0003] The technical task of the present invention is to aim at the above deficiencies, provide a distributed database-based partition authority management method, which can improve the inspection granularity and inspection efficiency of the authority by using the distributed database partition characteristics on the basis of improving the data access authority, and avoid T...

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 Applications(China)
IPC IPC(8): G06F21/60G06F21/62G06F16/27
CPCG06F21/604G06F21/6218G06F16/27G06F2221/2141
Inventor 邢政沈豪江磊陈磊石梦飞鲍之骁徐扬刘文硕
Owner SHANDONG LANGCHAO YUNTOU INFORMATION TECH CO LTD
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