从存储平台加载或卸载数据的数据库系统、方法及介质

By integrating certificateless external staging area objects, the security vulnerabilities and insufficient access control of traditional external staging areas are resolved, enabling secure and efficient data loading and unloading, and supporting multi-path access.

CN116303718BActive Publication Date: 2026-07-17SNOWFLAKE INC

Patent Information

Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
SNOWFLAKE INC
Filing Date
2020-07-30
Publication Date
2026-07-17

AI Technical Summary

Technical Problem

Traditional external staging areas require secret security certificate exchanges in cloud data warehouses, which leads to security vulnerabilities and data leakage risks. Furthermore, access control is not granular enough and cannot be used in multiple file paths.

Method used

By employing certificateless external staging area objects, and through the integration between the network-based data warehouse system and the cloud storage provider system, proxy identity objects and cloud identity objects are used to achieve data loading and unloading without exchanging security certificates, combined with fine-grained access control mechanisms.

Benefits of technology

It enables secure loading and unloading of data within cloud storage provider systems, prevents data leaks, improves the granularity of access control, and supports the use of multiple file paths.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN116303718B_ABST
    Figure CN116303718B_ABST
Patent Text Reader

Abstract

本申请涉及从存储平台加载或卸载数据的数据库系统、方法及介质。存储集成对象是在数据仓库系统的数据库中创建的。存储集成对象标识云存储提供商系统的存储平台中的存储位置和由基于网络的数据仓库系统维护的云身份对象。在云存储提供商的存储平台处,云身份对象与被授予访问存储位置的许可的代理身份对象相关联。基于存储集成对象创建外部暂存区对象。外部暂存区对象标识存储位置,并包括与存储集成对象的关联。接收加载或卸载存储位置处的数据的命令。响应于该命令,经由代理身份对象,使用外部暂存区对象加载或卸载存储位置处的数据。
Need to check novelty before this filing date? Find Prior Art