Snowflake inc. (20240272900). IN-DATABASE APPLICATION PACKAGE UPDATING simplified abstract

IN-DATABASE APPLICATION PACKAGE UPDATING

Organization Name

snowflake inc.

Inventor(s)

Karol Pawel Bienkowski of Toronto (CA)

Damien Carru of New York NY (US)

Jeremy Yujui Chen of Newark CA (US)

Pui Kei Johnston Chu of Richmond Hill (CA)

Benoit Dageville of San Mateo CA (US)

Scott C. Gray of Richmond Hill (CA)

Unmesh Jagtap of San Mateo CA (US)

Subramanian Muralidhar of Mercer Island WA (US)

IN-DATABASE APPLICATION PACKAGE UPDATING - A simplified explanation of the abstract

This abstract first appeared for US patent application 20240272900 titled 'IN-DATABASE APPLICATION PACKAGE UPDATING

The abstract describes an in-database application package and application instance for a data platform. The data platform creates application instances with versioned schemas, system roles, user roles, and administrator roles. Objects are created based on the schema, and privileges are granted to roles. Application instances are upgraded or patched based on package versions, with the platform tracking executing object versions.

• Data platform creates application instances with versioned schemas
• System roles, user roles, and administrator roles are created for application instances
• Objects are created based on versioned schemas
• Privileges are granted to roles
• Application instances are upgraded or patched based on package versions

Potential Applications: This technology can be applied in various industries where data platforms are used, such as finance, healthcare, and e-commerce.

Problems Solved: This technology streamlines the process of managing application instances on a data platform, ensuring proper upgrades and patches are applied.

Benefits: Improved efficiency in managing application instances, enhanced security through role-based access control, and streamlined upgrade processes.

Commercial Applications: This technology can be utilized by software companies, data management firms, and businesses with large-scale data platforms to enhance data management processes and security measures.

Questions about the Technology: 1. How does this technology improve data platform management? 2. What are the key benefits of using versioned schemas in application instances?

Frequently Updated Research: Stay updated on the latest advancements in data platform management and security measures to enhance the effectiveness of this technology.

Original Abstract Submitted

an in-database application package and application instance for a data platform. the data platform creates an application instance of an application package having a versioned schema, creates one or more system roles for the application instance, creates a user role and an administrator role for the application instance, creates one or more objects of the application instance based on a versioned schema, and grants one or more use privileges to the one or more roles. application instances of the application package are upgraded or patched on the data platform based on application package versions. to ensure a proper upgrade or patch, the data platform tracks versions of executing objects of application instances in a call context.