Jiaqi YAN

Person

San Carlos, CA, US

People

Patents Grantslast 30 patents

Information Patent Grant
Unified structured and semi-structured data types in database systems
- Patent number 12,321,361
- Issue date Jun 3, 2025
- Snowflake Inc.
- Xinzhu Cai
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Optimized validation of cached query plans
- Patent number 12,277,117
- Issue date Apr 15, 2025
- Snowflake Inc.
- Karan Chadha
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Query plan cache shadow modes
- Patent number 12,277,116
- Issue date Apr 15, 2025
- Snowflake Inc.
- Prashant Gaharwar
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Sharing materialized views in multiple tenant database systems
- Patent number 12,277,115
- Issue date Apr 15, 2025
- Snowflake Inc.
- Prasanna Rajaperumal
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Hidden database objects over external data
- Patent number 12,222,954
- Issue date Feb 11, 2025
- Snowflake Inc.
- Kavinder S. Dhaliwal
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Optimized identification of performance regression
- Patent number 12,216,628
- Issue date Feb 4, 2025
- Snowflake Inc.
- Allison Lee
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Scalable query processing
- Patent number 12,216,656
- Issue date Feb 4, 2025
- Snowflake Inc.
- Thierry Cruanes
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Interleaved execution infrastructure in database engines
- Patent number 12,210,525
- Issue date Jan 28, 2025
- Snowflake Inc.
- Thierry Cruanes
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Performance optimizations for secure objects evaluations
- Patent number 12,204,541
- Issue date Jan 21, 2025
- Snowflake Inc.
- Bicheng Gao
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Database metadata corruption mitigation
- Patent number 12,174,702
- Issue date Dec 24, 2024
- Snowflake Inc.
- Selcuk Aya
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Clustering and compaction of materialized views on a database system
- Patent number 12,169,490
- Issue date Dec 17, 2024
- Snowflake Inc.
- Varun Ganesh
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
System and method for disjunctive joins
- Patent number 12,164,514
- Issue date Dec 10, 2024
- Snowflake Inc.
- Thierry Cruanes
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Multi-phase query plan caching
- Patent number 12,135,715
- Issue date Nov 5, 2024
- Snowflake Inc.
- Xuelai Cui
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Flexible computing
- Patent number 12,106,149
- Issue date Oct 1, 2024
- Snowflake Inc.
- Thierry Cruanes
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
System and method for disjunctive joins using a lookup table
- Patent number 12,056,123
- Issue date Aug 6, 2024
- Snowflake Inc.
- Thierry Cruanes
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Unified table data access in user-specified formats on internal sto...
- Patent number 12,050,582
- Issue date Jul 30, 2024
- Snowflake Inc.
- Selcuk Aya
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Join elimination
- Patent number 12,045,236
- Issue date Jul 23, 2024
- Snowflake Inc.
- Thierry Cruanes
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Performance indexing of production databases
- Patent number 12,026,140
- Issue date Jul 2, 2024
- Snowflake Inc.
- Vlad Bunescu
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Transient materialized view rewrite
- Patent number 12,026,159
- Issue date Jul 2, 2024
- Snowflake Inc.
- Shrainik Jain
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Query plan cache in database systems
- Patent number 12,026,160
- Issue date Jul 2, 2024
- Snowflake Inc.
- Thierry Cruanes
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Checkpoints in batch file processing
- Patent number 12,019,632
- Issue date Jun 25, 2024
- Snowflake Inc.
- Thierry Cruanes
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Schema evolution
- Patent number 12,007,961
- Issue date Jun 11, 2024
- Snowflake Inc.
- Istvan Cseri
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Placement of adaptive aggregation operators and properties in a que...
- Patent number 11,971,888
- Issue date Apr 30, 2024
- Snowflake Inc.
- Bowei Chen
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Token-based secure database query result sharing
- Patent number 11,973,748
- Issue date Apr 30, 2024
- Snowflake Inc.
- Damien Carru
- H04 - ELECTRIC COMMUNICATION TECHNIQUE
Information Patent Grant
Infrastructure for automating rollout of database changes
- Patent number 11,971,783
- Issue date Apr 30, 2024
- Snowflake Inc.
- Vlad Bunescu
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Resource provisioning in database systems
- Patent number 11,914,602
- Issue date Feb 27, 2024
- Snowflake Inc.
- Jeffrey Rosen
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Sharing materialized views in multiple tenant database systems
- Patent number 11,914,591
- Issue date Feb 27, 2024
- Snowflake Inc.
- Prasanna Rajaperumal
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Providing table data access in user-specified formats on user-manag...
- Patent number 11,899,646
- Issue date Feb 13, 2024
- Snowflake Inc.
- Selcuk Aya
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Metadata clustering
- Patent number 11,822,582
- Issue date Nov 21, 2023
- Snowflake Inc.
- Yi Fang
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Incremental refresh of a materialized view
- Patent number 11,809,408
- Issue date Nov 7, 2023
- Snowflake Inc.
- Thierry Cruanes
- G06 - COMPUTING CALCULATING COUNTING

Patents Applicationslast 30 patents

Information Patent Application
TOKEN-BASED SECURE DATABASE QUERY RESULT SHARING
- Publication number 20250141860
- Publication date May 1, 2025
- Snowflake Inc.
- Damien Carru
- H04 - ELECTRIC COMMUNICATION TECHNIQUE
Information Patent Application
MACHINE TIME ESTIMATION FOR CONTINUOUS MAINTENANCE OF CLUSTERED DATA
- Publication number 20250131017
- Publication date Apr 24, 2025
- Snowflake Inc.
- Varun Ganesh
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
INTERLEAVED EXECUTION INFRASTRUCTURE IN DATABASE ENGINES
- Publication number 20250117387
- Publication date Apr 10, 2025
- Snowflake Inc.
- Thierry Cruanes
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
ISOLATED TESTING PLATFORM FOR CLOUD DATABASE PRODUCTION QUERIES
- Publication number 20250110718
- Publication date Apr 3, 2025
- Snowflake Inc.
- Jin Mo Ahn
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
PERFORMANCE OPTIMIZATIONS FOR SECURE OBJECTS EVALUATIONS
- Publication number 20250103593
- Publication date Mar 27, 2025
- Snowflake Inc.
- Bicheng Gao
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
DYNAMIC PIVOT IMPLEMENTATION USING OBJECT AGGREGATION
- Publication number 20250094418
- Publication date Mar 20, 2025
- Snowflake Inc.
- Srilakshmi Chintala
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
DATABASE METADATA CORRUPTION MITIGATION
- Publication number 20250068522
- Publication date Feb 27, 2025
- Snowflake Inc.
- Selcuk Aya
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
FLEXIBLE COMPUTING
- Publication number 20250021390
- Publication date Jan 16, 2025
- Snowflake Inc.
- Thierry Cruanes
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
MULTI-PHASE QUERY PLAN CACHING
- Publication number 20250021556
- Publication date Jan 16, 2025
- Snowflake Inc.
- Xuelai Cui
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
UNIFIED STRUCTURED AND SEMI-STRUCTURED DATA TYPES IN DATABASE SYSTEMS
- Publication number 20240427790
- Publication date Dec 26, 2024
- Snowflake Inc.
- Xinzhu Cai
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
HIDDEN DATABASE OBJECTS OVER EXTERNAL DATA
- Publication number 20240427794
- Publication date Dec 26, 2024
- Snowflake Inc.
- Kavinder S. Dhaliwal
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
UNIFIED TABLE DATA ACCESS IN USER-SPECIFIED FORMATS ON INTERNAL STO...
- Publication number 20240427755
- Publication date Dec 26, 2024
- Snowflake Inc.
- Selcuk Aya
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
MULTI-PHASE QUERY PLAN CACHING
- Publication number 20240362222
- Publication date Oct 31, 2024
- Snowflake Inc.
- Xuelai Cui
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
MICRO-PARTITION CLUSTERING BASED ON EXPRESSION PROPERTY METADATA
- Publication number 20240354315
- Publication date Oct 24, 2024
- Snowflake Inc.
- Varun Ganesh
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
QUERY PARALLELISM AND MESSAGING INFRASTRUCTURE FOR A CLOUD DATABASE
- Publication number 20240345877
- Publication date Oct 17, 2024
- Snowflake Inc.
- Igor Demura
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
JOIN ELIMINATION
- Publication number 20240338367
- Publication date Oct 10, 2024
- Snowflake Inc.
- Thierry Cruanes
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
QUERY PLAN CACHE SHADOW MODES
- Publication number 20240330287
- Publication date Oct 3, 2024
- Snowflake Inc.
- Prashant Gaharwar
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
TRACKING EVALUATION OF WORKLOAD STABILITY THROUGH PERFORMANCE INDEXING
- Publication number 20240320202
- Publication date Sep 26, 2024
- Snowflake Inc.
- Vlad Bunescu
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
CHECKPOINTS IN BATCH FILE PROCESSING
- Publication number 20240303238
- Publication date Sep 12, 2024
- Snowflake Inc.
- Thierry Cruanes
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
INTERLEAVED EXECUTION INFRASTRUCTURE IN DATABASE ENGINES
- Publication number 20240256540
- Publication date Aug 1, 2024
- Snowflake Inc.
- Thierry Cruanes
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
PLACEMENT OF ADAPTIVE AGGREGATION OPERATORS AND PROPERTIES IN A QUE...
- Publication number 20240241883
- Publication date Jul 18, 2024
- Snowflake Inc.
- Bowei Chen
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
REGRESSION MITIGATION USING MULTIPLE STORED PROCEDURES
- Publication number 20240232019
- Publication date Jul 11, 2024
- Snowflake Inc.
- Vlad Bunescu
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
DYNAMIC CHANGES TO COMPILATION BASED ON QUERY PROPERTIES
- Publication number 20240168950
- Publication date May 23, 2024
- Snowflake Inc.
- Thierry Cruanes
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
FLEXIBLE COMPUTING
- Publication number 20240078135
- Publication date Mar 7, 2024
- Snowflake Inc.
- Thierry Cruanes
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
SCALABLE QUERY PROCESSING
- Publication number 20240028592
- Publication date Jan 25, 2024
- Snowflake Inc.
- Thierry Cruanes
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
USER DEFINED FUNCTION MEMOIZATION
- Publication number 20240028591
- Publication date Jan 25, 2024
- Snowflake Inc.
- Raja Suresh Krishna Balakrishnan
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
INCREMENTAL REFRESH OF A MATERIALIZED VIEW
- Publication number 20240020295
- Publication date Jan 18, 2024
- Snowflake Inc.
- Thierry Cruanes
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
OPTIMIZED IDENTIFICATION OF PERFORMANCE REGRESSION
- Publication number 20240012796
- Publication date Jan 11, 2024
- Snowflake Inc.
- Allison Lee
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
SHARING MATERIALIZED VIEWS IN MULTIPLE TENANT DATABASE SYSTEMS
- Publication number 20230418818
- Publication date Dec 28, 2023
- Snowflake Inc.
- Prasanna Rajaperumal
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
DATABASE METADATA CORRUPTION MITIGATION
- Publication number 20230409430
- Publication date Dec 21, 2023
- Snowflake Inc.
- Selcuk Aya
- G06 - COMPUTING CALCULATING COUNTING

Person

Patents Grantslast 30 patents

Unified structured and semi-structured data types in database systems

Optimized validation of cached query plans

Query plan cache shadow modes

Sharing materialized views in multiple tenant database systems

Hidden database objects over external data

Optimized identification of performance regression

Scalable query processing

Interleaved execution infrastructure in database engines

Performance optimizations for secure objects evaluations

Database metadata corruption mitigation

Clustering and compaction of materialized views on a database system

System and method for disjunctive joins

Multi-phase query plan caching

Flexible computing

System and method for disjunctive joins using a lookup table

Unified table data access in user-specified formats on internal sto...

Join elimination

Performance indexing of production databases

Transient materialized view rewrite

Query plan cache in database systems

Checkpoints in batch file processing

Schema evolution

Placement of adaptive aggregation operators and properties in a que...

Token-based secure database query result sharing

Infrastructure for automating rollout of database changes

Resource provisioning in database systems

Sharing materialized views in multiple tenant database systems

Providing table data access in user-specified formats on user-manag...

Metadata clustering

Incremental refresh of a materialized view

Patents Applicationslast 30 patents

TOKEN-BASED SECURE DATABASE QUERY RESULT SHARING

MACHINE TIME ESTIMATION FOR CONTINUOUS MAINTENANCE OF CLUSTERED DATA

INTERLEAVED EXECUTION INFRASTRUCTURE IN DATABASE ENGINES

ISOLATED TESTING PLATFORM FOR CLOUD DATABASE PRODUCTION QUERIES

PERFORMANCE OPTIMIZATIONS FOR SECURE OBJECTS EVALUATIONS

DYNAMIC PIVOT IMPLEMENTATION USING OBJECT AGGREGATION

DATABASE METADATA CORRUPTION MITIGATION

FLEXIBLE COMPUTING

MULTI-PHASE QUERY PLAN CACHING

UNIFIED STRUCTURED AND SEMI-STRUCTURED DATA TYPES IN DATABASE SYSTEMS

HIDDEN DATABASE OBJECTS OVER EXTERNAL DATA

UNIFIED TABLE DATA ACCESS IN USER-SPECIFIED FORMATS ON INTERNAL STO...

MULTI-PHASE QUERY PLAN CACHING

MICRO-PARTITION CLUSTERING BASED ON EXPRESSION PROPERTY METADATA

QUERY PARALLELISM AND MESSAGING INFRASTRUCTURE FOR A CLOUD DATABASE

JOIN ELIMINATION

QUERY PLAN CACHE SHADOW MODES

TRACKING EVALUATION OF WORKLOAD STABILITY THROUGH PERFORMANCE INDEXING

CHECKPOINTS IN BATCH FILE PROCESSING

INTERLEAVED EXECUTION INFRASTRUCTURE IN DATABASE ENGINES

PLACEMENT OF ADAPTIVE AGGREGATION OPERATORS AND PROPERTIES IN A QUE...

REGRESSION MITIGATION USING MULTIPLE STORED PROCEDURES

DYNAMIC CHANGES TO COMPILATION BASED ON QUERY PROPERTIES

FLEXIBLE COMPUTING

SCALABLE QUERY PROCESSING

USER DEFINED FUNCTION MEMOIZATION

INCREMENTAL REFRESH OF A MATERIALIZED VIEW

OPTIMIZED IDENTIFICATION OF PERFORMANCE REGRESSION

SHARING MATERIALIZED VIEWS IN MULTIPLE TENANT DATABASE SYSTEMS

DATABASE METADATA CORRUPTION MITIGATION