Cloud Database Certification Views for Copy-Free Data Sharing
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing cloud database platforms like Snowflake struggle to efficiently manage data sharing by ensuring consumers access only authorized data portions without duplicating or modifying the underlying data, leading to cumbersome and resource-intensive processes.
Innovation Solution
Implementing a data certification process that generates a limited consumer view definition, allowing consumers to access authorized data portions while maintaining the original data intact, using cloud database platforms with virtual warehouses.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If data is shared by copying or duplicating it for different consumers, then consumers can access authorized data portions, but storage resources are consumed and data updates become complex to manage
Solution Approach 1:
The patent creates a view definition (a virtual copy) that represents the authorized data portion without physically duplicating the actual data. This view definition can be shared with consumers, allowing them to access the data through the view while the underlying data remains single-stored and centrally managed by the data owner.
2Adaptability or versatility
If data is copied for sharing, then consumers can access data portions, but updating the data requires modifying multiple copies
Solution Approach 1:
Instead of copying actual data, the patent copies only the view definition (metadata). When the data owner updates the underlying data, the change automatically reflects to all consumers through the shared view definition without requiring modification of multiple data copies. This eliminates the complexity of synchronizing updates across multiple copies.
3Reliability
If view definitions are created for each consumer with custom rules, then consumers access only authorized data, but the process is cumbersome and resource-intensive
Solution Approach 1:
The patent enables a single view definition to serve multiple consumers with different authorization levels. The view definition can be parameterized or configured to work with different consumer accounts, allowing the same view to enforce different access rules for different consumers without creating separate view definitions for each one. This universal approach significantly improves data sharing efficiency.
Data Source
AI summary
Methods, systems, and apparatuses for providing access to records of a database stored on a database server in a cloud database platform are described herein. A data sharing platform may determine a shared view definition for access to the database. The data sharing platform may determine rules that specify criteria that limit access to the records stored by the database. The one or more first rules may be received via a user interface. The data sharing platform may perform, based on the rules, a data access certification process on the records stored by the database to generate a table of certification results. The data sharing platform may generate, based on the table of certification results, and without modifying the records stored by the database, a limited consumer view definition. Based on updates to the records, a new limited consumer view definition may be generated.