Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Access control method and system of data warehouse and electronic equipment

A data warehouse and access control technology, applied in digital data protection, electronic digital data processing, instruments, etc., can solve the problem that the Hive system cannot support MYSQL storage account password verification, access requests cannot be controlled, and data security low level problem

Pending Publication Date: 2021-09-14
作业帮教育科技(北京)有限公司
View PDF0 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] Due to the following problems in the existing solution: the Hive system cannot support the method of verifying the account password stored in MYSQL, Hive cannot perform permission control on access requests directly connected to the metadata database, and technical problems such as low data security

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
  • Access control method and system of data warehouse and electronic equipment
  • Access control method and system of data warehouse and electronic equipment
  • Access control method and system of data warehouse and electronic equipment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0049] Below, will refer to Figure 1 to Figure 5 An embodiment of the access control method of the data warehouse of the present invention is described.

[0050] The access control method of the present invention is used for access control of data warehouses, and is particularly suitable for data warehouses that provide database access services and metadata access services, such as Hive-based data warehouses (hereinafter, referred to as Hive data warehouses), that is, this The data warehouse in the invention is used to provide a database access service and a metadata access service, and the metadata is used to describe the database in the data warehouse. As a specific embodiment, the metadata includes the table name, the database to which the table belongs (default is default), the columns and partitions of the table and their attributes, the type of the table (whether it is an external table, etc.), the directory where the data of the table is located, and the like.

[0051...

Embodiment 2

[0139] A system embodiment of the present invention is described below, and the system can be used to execute the method embodiment of the present invention. The details described in the system embodiments of the present invention should be regarded as supplements to the above method embodiments; details not disclosed in the system embodiments of the present invention can be implemented with reference to the above method embodiments.

[0140] refer to figure 2 , Figure 4 to Figure 7 , the present invention also provides an access control system 500 for a data warehouse, the data warehouse is used to provide a database access service and a metadata access service, and the metadata is used to describe the database in the data warehouse.

[0141] like Image 6 As shown, the access control system 600 includes: a storage module 601 for storing authorized account associated information, and periodically acquiring metadata to update the authorized account associated information, ...

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 provides an access control method and system for a data warehouse and computer equipment, and the method comprises the steps: storing authorized account associated information, and updating the authorized account associated information through periodically obtaining metadata, the authorized account associated information comprising authorized account information and corresponding database information; establishing an account authentication service independent of the database access service and the metadata access service in a data warehouse to call the stored authorized account association information; responding to an access request of a client; calling an account authentication service to perform identification processing on the account information in the access request according to the stored authorized account association information so as to perform identity authentication; and returning the user request passing the identity authentication to a database access service and a metadata access service for authority verification. According to the invention, the security of the data in the Hive data warehouse is reliably ensured, a more effective identity authentication and authority verification process is realized, and misoperation and malicious operation of a user are effectively prevented.

Description

technical field [0001] The invention relates to the technical field of testing, and in particular, to a data warehouse access control method, system and electronic device. Background technique [0002] In Internet-based application technology, it is often necessary to exchange resources between different parties. The resource referred to here refers to any material, information, money, time, etc. that can be used. Information resources include computing resources and various types of data resources. Data resources include various specialized data in various fields. [0003] Data is an important asset for enterprises, and data security and access control are very important for enterprises. Hive, as the entrance of big data storage and access, is also one of the focuses of the industry. Permission management frameworks such as Ranger and Sentry have emerged in the industry. However, they are all for unified management and control of the HiveServer2 server, and cannot perf...

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/62
CPCG06F21/604G06F21/6218G06F2221/2141
Inventor 曲浩王滨刘晋
Owner 作业帮教育科技(北京)有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com