Jiale Lao
Community@solidlao
CS PhD Candidate at Cornell University
Agent Skills by Jiale Lao
Showing 12 vetted skills indexed across 1 GitHub repositories.
SolidLaoexperience
Enforce GenDB correctness and performance rules for query execution.
SolidLaoparallelism
Optimize OLAP query execution with morsel-driven parallelism and OpenMP.
SolidLaodata-structures
Select hash tables, bloom filters, or sorted arrays for database query operations.
SolidLaoaggregation-optimization
Select aggregation algorithms for SQL GROUP BY queries based on cardinality and memory.
SolidLaogendb-storage-format
Document GenDB binary columnar storage with type mappings and encodings.
SolidLaodata-loading
Optimize database data loading with memory mapping, prefetching, and NUMA-aware allocation.
SolidLaoresearch-papers
Curate seminal research papers on database query optimization and execution strategies.
SolidLaogendb-code-patterns
Generate C++ file structure templates for GenDB query execution.
SolidLaojoin-optimization
Optimize SQL join operations with hash join variants and join ordering.
SolidLaoindexing
Guide storage index selection and implementation for GenDB query performance.
SolidLaohash-tables
Implement optimized hash tables for database joins and aggregations.
SolidLaoscan-optimization
Optimize SQL scan and filter operations using predicate pushdown and SIMD filtering.