Inventor

Jiaqi YAN

Inventor

US

Overview

2021–2026

Patent span

Physics

Primary field (CPC G)

Patents· 89 as inventor

Public. Assignee & technology derived from the patent record. Each patent links to its LexDana page.

G06Fprimary

G06FElectric digital data processing71%

H04LTransmission of digital information, e.g. telegraphic communication4%

B64CAeroplanes4%

B64UUnmanned aerial vehicles [uav]4%

G05DSystems for controlling or regulating non-electric variables4%

H04NPictorial communication, e.g. television3%

G01CMeasuring distances, levels or bearings2%

G06TImage data processing or generation, in general2%

B64DEquipment for fitting in or to aircraft1%

G01BMeasuring length, thickness or similar linear dimensions1%

PatentTitleYear

12,572,524Unified table data access in user-specified formats on internal storage and user-managed storage2026 12,563,025Token-based secure database query result sharing2026 12,561,325Query plan view framework for management of database query plans2026 12,517,902User defined function memoization2026 12,517,904Dynamic changes to compilation based on query properties2026 D1098839Ice bucket2025 12,386,863Micro-partition clustering based on expression property metadata2025 12,321,361Unified structured and semi-structured data types in database systems2025 12,277,117Optimized validation of cached query plans2025 12,277,116Query plan cache shadow modes2025 12,277,115Sharing materialized views in multiple tenant database systems2025 12,222,954Hidden database objects over external data2025 12,216,628Optimized identification of performance regression2025 12,216,656Scalable query processing2025 12,210,525Interleaved execution infrastructure in database engines2025 12,204,541Performance optimizations for secure objects evaluations2025 12,174,702Database metadata corruption mitigation2024 12,169,490Clustering and compaction of materialized views on a database system2024 12,164,514System and method for disjunctive joins2024 12,135,715Multi-phase query plan caching2024 12,106,149Flexible computing2024 12,056,123System and method for disjunctive joins using a lookup table2024 12,050,582Unified table data access in user-specified formats on internal storage and user-managed storage2024 12,045,236Join elimination2024 12,026,140Performance indexing of production databases2024 12,026,159Transient materialized view rewrite2024 12,026,160Query plan cache in database systems2024 12,019,632Checkpoints in batch file processing2024 12,019,458Systems and methods for coordinating device actions2024 12,007,961Schema evolution2024 11,973,748Token-based secure database query result sharing2024 11,971,783Infrastructure for automating rollout of database changes2024 11,971,888Placement of adaptive aggregation operators and properties in a query plan2024 11,914,591Sharing materialized views in multiple tenant database systems2024 11,914,602Resource provisioning in database systems2024 11,899,646Providing table data access in user-specified formats on user-managed storage2024 11,822,582Metadata clustering2023 11,809,408Incremental refresh of a materialized view2023 11,809,425Function memoization in query processing system2023 11,809,428Scalable query processing2023 D1003620Recliner chair2023 11,782,890Identification of optimal cloud resources for executing workloads2023 11,755,581Cutoffs for pruning of database queries2023 11,748,318Schema evolution2023 11,734,116Infrastructure for automating rollout of database changes2023 11,687,373Flexible computing2023 11,645,281Caching query plans in database systems2023 11,625,367Schema evolution2023 11,620,287Framework for providing intermediate aggregation operators in a query plan2023 11,615,086System and method for disjunctive joins2023 11,615,095Automatic pruning cutoff in a database system2023 11,599,537System and method for disjunctive joins2023 11,593,212Prevention and mitigation of corrupt database data2023 11,593,368Maintenance of clustered materialized views on a database system2023 11,593,306File defragmentation service2023 11,580,103System and method for disjunctive joins using a lookup table2023 11,544,262Transient materialized view rewrite2023 11,544,244Selecting partitions for reclustering based on distribution of overlapping partitions2023 11,537,613Merge small file consolidation2022 11,514,064Resource provisioning in database systems2022 11,513,859Flexible computing2022 11,500,838Feature release and workload capture in database systems2022 11,475,011Pruning cutoffs for database systems2022 11,468,063Aggregation operator optimization during query runtime2022 11,465,743System and method for selecting an operation mode of a mobile platform2022 11,461,326Scalable query processing2022 11,461,327Query plan caching for networked database systems2022 11,461,309Incremental refresh of a materialized view2022 11,461,325Checkpoints in batch file processing2022 11,442,917Incremental reclustering based on local maxima of partition overlap2022 11,429,605System and method for disjunctive joins2022 11,416,463Incremental feature development and workload capture in database systems2022 11,403,275Incremental reclustering of database tables using reclustering-count levels2022 11,386,059Optimized identification of performance regression2022 11,379,492Internal resource provisioning in database systems2022 11,365,014System and method for automated tracking and navigation2022 11,360,989Resource provisioning in database systems2022 11,347,735Scalable query processing2022 11,321,290Incremental feature development and workload capture in database systems2022 11,310,412Autofocusing camera and systems2022 11,222,019Automatic pruning cutoff in a database system2022 11,216,462Transient materialized view rewrite2022 11,218,689Methods and systems for selective sensor fusion2022 11,163,746Reclustering of database tables based on peaks and widths2021 11,144,550Pipeline level optimization of aggregation operators in a query plan during runtime2021 11,138,213Internal resource provisioning in database systems2021 11,138,214Internal resource provisioning in database systems2021 11,138,167Optimized identification of performance regression2021 11,137,776Systems and methods for coordinating device actions2021

Career & activity timeline

Assembled from patent assignee/location history and declaration credentials.

2021–2026Patents assigned to SNOWFLAKE INC (81)· patent assignee history

2021–2024Patents assigned to SZ DJI TECHNOLOGY CO LTD (6)· patent assignee history

2021–2026Based in US· patent location history

2021–2025Based in CN· patent location history

2023–2025Patents assigned to NINGBO HAIYI IND CO LTD (2)· patent assignee history

Inventor activity

Assignee and location history derived from the patent record.

Assignees

Assignee	Patents	Span
SNOWFLAKE INC	81	2021–2026
SZ DJI TECHNOLOGY CO LTD	6	2021–2024
NINGBO HAIYI IND CO LTD	2	2023–2025

Locations

Location	Patents	Span
US	81	2021–2026
CN	8	2021–2025