skills.rest
SolidLao
SolidLaoCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

research-papers

Curate seminal research papers on database query optimization and execution strategies.

71|8|Updated Feb 8, 2026
Search Tags:#query optimization#indexing#database#research papers#join ordering#column stores
One-click install
npx skills add https://github.com/SolidLao/GenDB --skill research-papers-solidlao
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: research-papers
Source: https://github.com/SolidLao/GenDB/tree/main/.claude/skills/research-papers
Command: npx skills add https://github.com/SolidLao/GenDB --skill research-papers-solidlao

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill provides a curated list of seminal research papers to inform complex decision-making in database query optimization, join ordering, and architectural design.

Core Features & Use Cases

  • Query Optimization: Access foundational papers on query planning and optimization algorithms.
  • Join Processing: Reference key research on efficient join techniques.
  • Indexing & Storage: Explore advancements in indexing structures and column-oriented databases.
  • Use Case: When designing a new query optimizer, consult these papers to understand established algorithms and their trade-offs.

Quick Start

Load the research-papers skill to find seminal papers on query optimization.

Frequently Asked Questions about research-papers

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
Where can I find seminal research papers on database query optimization algorithms?▼

Seminal research papers on database query optimization are provided as a curated knowledge base covering query planning, join ordering, and execution strategies to inform architectural design decisions.

What foundational research covers join ordering and indexing in column stores?▼

Foundational research on join ordering, indexing techniques, and column stores is included to provide context on efficient join processing and advancements in storage architectures.

How do I reference key publications when designing a new query optimizer?▼

Reference key publications by loading the curated knowledge base to understand established query optimization algorithms, parallelism, code generation, and their specific trade-offs.

Does this database research cover execution strategies like code generation and parallelism?▼

Yes, the curated database research covers execution strategies including code generation and parallelism, alongside papers detailing query planning and architectural design.

When should I consult these research papers for database systems development?▼

Consult these research papers during database systems development when making complex decisions regarding query optimization, join ordering, indexing, or architectural design to understand established trade-offs.

What is the best way to explore advancements in column-oriented databases and storage?▼

The best way to explore advancements in column-oriented databases and storage is by accessing the curated list of seminal papers focused on indexing structures and execution strategies.

Related Skills

Explore More Education & Research Skills→
Axel-DaMageAxel-DaMage
2

sql-pro

Optimize SQL queries and design database schemas with indexing strategies.

Community
Advanced
AkallabetAkallabet

postgresql-table-design

Generate PostgreSQL database schema designs with data types, indexing, and constraints.

Community
Advanced
rajitsaharajitsaha
10

db

Connect to multiple database engines and execute SQL queries or migrations.

Community
Intermediate
nimadorostkarnimadorostkar
25

sql

Optimize SQL query performance and database indexing strategies.

Community
Advanced