GitHub topics: query-optimization

khanzaman8/hypersql-lsb

🔍 Optimize SQL queries with hypersql-lsb to improve performance and streamline database management effortlessly.

Size: 1.29 MB - Last synced at: about 23 hours ago - Pushed at: 1 day ago - Stars: 0 - Forks: 0

Rumia-Chan-osu/freelando_webapi_course-alura-entity-framework-core-transactions_part-12_dotnet-8_csharp-12

Repositório com exercícios do curso “.NET: avance na persistência com EF Core” da Alura. Aborda consultas avançadas, modelo rico, uso de transações, boas práticas com padrões arquiteturais e interceptação de comandos SQL com o Entity Framework Core.

Size: 1.95 KB - Last synced at: 1 day ago - Pushed at: 1 day ago - Stars: 0 - Forks: 0

hyper1-Githubispro/The-Ultimate-Django-Series

📚 Master Django with this organized series featuring code, resources, and notes for building a complete e-commerce storefront.

Size: 1.3 MB - Last synced at: 1 day ago - Pushed at: 1 day ago - Stars: 0 - Forks: 0

Jazz-Man/wp-performance

The main task of this plugin is to increase the security of the site and improve the performance of the site by disabling completely unnecessary hooks and also optimizing SQL queries

Language: PHP - Size: 1.04 MB - Last synced at: 3 days ago - Pushed at: 3 days ago - Stars: 6 - Forks: 0

davideFerigato/BachelorThesis

Ottimizzazione delle Query per Sistemi di Business Intelligence: Tecniche Avanzate per Migliorare le Performance e il Supporto Decisionale

Language: TeX - Size: 12.9 MB - Last synced at: 3 days ago - Pushed at: 4 days ago - Stars: 0 - Forks: 0

maasta28/hypersql-skp

📊 Simplify data management with hypersql-skp, a lightweight SQL database toolkit that boosts performance and streamlines your workflows.

Size: 1.29 MB - Last synced at: 5 days ago - Pushed at: 5 days ago - Stars: 0 - Forks: 0

Mehran-Memon/fspann-query-system

We’re building a secure search engine for high-dimensional data, like images or audio. Normally, finding the ‘nearest neighbors’ in huge datasets is already hard because the vectors are large and the dataset can be billions of points. We add another challenge: the data is encrypted, so the system must be forward-secure.

Language: Java - Size: 230 MB - Last synced at: 5 days ago - Pushed at: 5 days ago - Stars: 1 - Forks: 0

Crasus94/duckdb-dcp

🦆 Enable fast data processing and analytics with DuckDB integration for efficient columnar storage and query capabilities.

Size: 1.29 MB - Last synced at: 5 days ago - Pushed at: 5 days ago - Stars: 0 - Forks: 0

Techyaitop/neo4j-spp

Size: 1.29 MB - Last synced at: 6 days ago - Pushed at: 6 days ago - Stars: 0 - Forks: 0

TeTe3456/sql-server-jlc

🚀 Simplify SQL Server management with JLC tools, enhancing performance and efficiency for database administrators and developers.

Size: 1.29 MB - Last synced at: 6 days ago - Pushed at: 6 days ago - Stars: 0 - Forks: 0

jaspreet97977/elasticsearch-ndp

🔍 Enhance data retrieval performance with Elasticsearch NDP for efficient and scalable data processing in your applications.

Language: Java - Size: 1.36 MB - Last synced at: 6 days ago - Pushed at: 6 days ago - Stars: 0 - Forks: 0

shrutibankar/freelando_webapi_course-alura-entity-framework-core-transactions_part-5_dotnet-8_csharp-12

Repositório com exercícios do curso “.NET: avance na persistência com EF Core” da Alura. Aborda consultas avançadas, modelo rico, uso de transações, boas práticas com padrões arquiteturais e interceptação de comandos SQL com o Entity Framework Core.

Size: 1.95 KB - Last synced at: 7 days ago - Pushed at: 7 days ago - Stars: 0 - Forks: 0

helixcoder/freelando_webapi_course-alura-entity-framework-core-transactions_part-2_dotnet-8_csharp-12

🚀 Learn advanced persistence techniques with EF Core in .NET 8, featuring rich models, transaction management, and SQL command interception.

Language: HTML - Size: 1.29 MB - Last synced at: 7 days ago - Pushed at: 7 days ago - Stars: 0 - Forks: 0

Ana-Julia-C/postgresql-uxt

📊 Enhance your PostgreSQL experience by transforming UX with streamlined tools and intuitive interfaces for efficient database management.

Size: 1.31 MB - Last synced at: 7 days ago - Pushed at: 7 days ago - Stars: 0 - Forks: 0

Releem/mysqlconfigurer

Releem is a MySQL performance monitoring tool that automates analysis, performance issue detection, configuration tuning, query optimization and schema control to save you time and improve MySQL performance.

Language: Go - Size: 74.8 MB - Last synced at: 8 days ago - Pushed at: 8 days ago - Stars: 291 - Forks: 30

kirillshevch/query_track

Find time-consuming database queries for ActiveRecord-based Rails Apps

Language: Ruby - Size: 330 KB - Last synced at: 1 day ago - Pushed at: 3 months ago - Stars: 305 - Forks: 13

tableau/query-graphs

A visualizer for queries - Hyper, Postgres, Tableau

Language: TypeScript - Size: 22.2 MB - Last synced at: 9 days ago - Pushed at: 9 days ago - Stars: 96 - Forks: 29

wesleyscholl/ZipGraph

⚡ Blazing-fast graph processing engine in Rust with ML-powered optimization. 50-200x faster than Python/JS. Self-tuning algorithms, real-time anomaly detection, and sub-10ms queries on million-node graphs. 🚀🧠

Language: Rust - Size: 3.43 MB - Last synced at: 11 days ago - Pushed at: 11 days ago - Stars: 1 - Forks: 0

Lib-Up/sql-optimization-toolkit

Language: Python - Size: 6.84 KB - Last synced at: 13 days ago - Pushed at: 13 days ago - Stars: 0 - Forks: 0

shutuprachael/edgedb-xil

Size: 1.29 MB - Last synced at: 13 days ago - Pushed at: 13 days ago - Stars: 0 - Forks: 0

dagege/dagege.github.io

YongZhang's Page

Language: HTML - Size: 371 KB - Last synced at: 13 days ago - Pushed at: 13 days ago - Stars: 0 - Forks: 0

jmanhype/DSPy-Multi-Document-Agents

An advanced distributed knowledge fabric for intelligent document processing, featuring multi-document agents, optimized query handling, and semantic understanding.

Language: Python - Size: 143 KB - Last synced at: 14 days ago - Pushed at: 14 days ago - Stars: 49 - Forks: 5

marias101/Advanced-SQL-Analytics-Toolkit

Advanced SQL toolkit featuring recursive CTEs, window functions, JSON parsing, dynamic pivoting, lateral joins, and query optimization for scalable, high-performance data analytics and MAANG-level technical mastery.

Size: 542 KB - Last synced at: 14 days ago - Pushed at: 14 days ago - Stars: 0 - Forks: 0

Aadityavarier/Data-Cleaning-and-EDA

A complete SQL-based project analyzing global company layoffs between 2020 and 2023. Includes data cleaning, duplication handling, date standardization, and exploratory analysis to uncover key trends by country, sector, and year — all done using MySQL.

Size: 50.8 KB - Last synced at: 15 days ago - Pushed at: 15 days ago - Stars: 0 - Forks: 0

contriboss/no_fly_list

A flexible, high-performance tagging system for Rails applications with support for polymorphic tags, custom transformers, and database-specific optimizations

Language: Ruby - Size: 153 KB - Last synced at: 23 days ago - Pushed at: 23 days ago - Stars: 10 - Forks: 0

pavlosdais/PriSM

[BSc Thesis] PriSM: Prior-Guided Search Methods for Query Efficient Black-Box Adversarial Attacks

Language: Python - Size: 6.28 MB - Last synced at: 23 days ago - Pushed at: 23 days ago - Stars: 3 - Forks: 0

bvanhoekelen/performance

⏱ PHP performance tool analyser your script on time, memory usage and db query. Support Laravel and Composer for web, web console and command line interfaces.

Language: PHP - Size: 6.17 MB - Last synced at: 2 days ago - Pushed at: over 1 year ago - Stars: 520 - Forks: 38

postgrespro/pg_pathman

Partitioning tool for PostgreSQL

Language: C - Size: 4.59 MB - Last synced at: 26 days ago - Pushed at: 26 days ago - Stars: 589 - Forks: 69

labex-labs/sqlite-intermediate-to-advanced

In this course, delve into advanced SQLite techniques. Master constraints, indexing, joins, subqueries, transactions, triggers, views, full-text search, JSON, backups, PRAGMA tuning, CTEs, window functions, and more!

Size: 33.2 KB - Last synced at: 30 days ago - Pushed at: 30 days ago - Stars: 0 - Forks: 0

knagrecha/saturn

Saturn accelerates the training of large-scale deep learning models with a novel joint optimization approach.

Language: Python - Size: 107 KB - Last synced at: 13 days ago - Pushed at: almost 2 years ago - Stars: 24 - Forks: 5

tpetry/laravel-mysql-explain

Get Visual MySQL EXPLAIN plans with Laravel that are understandable for humans

Language: PHP - Size: 38.1 KB - Last synced at: 20 days ago - Pushed at: 9 months ago - Stars: 263 - Forks: 7

nvpham12/Retail-Sales-Dashboard

This project demonstrates SQL querying and optimization in Google BigQuery to extract a data sample before loading it into Tableau for dashboarding.

Size: 56.2 MB - Last synced at: about 1 month ago - Pushed at: about 1 month ago - Stars: 0 - Forks: 0

socialblue/laravel-query-adviser

With Laravel Query Adviser you can get more insights into the SQL queries created by Eloquent models used in your app. It logs the queries used by your application and provides a helpful overview of the SQL queries. You can rerun the SQL query to analyze the database impact or copy the SQL query to your clipboard.

Language: Vue - Size: 5.54 MB - Last synced at: 28 days ago - Pushed at: 11 months ago - Stars: 20 - Forks: 1

derhuerst/pev2-cli

Run the PostgreSQL Explain Visualizer 2 (pev2) from the command line.

Language: JavaScript - Size: 72.3 KB - Last synced at: 27 days ago - Pushed at: about 1 month ago - Stars: 24 - Forks: 1

altus4/api

🔍 AI-Enhanced MySQL Full-Text Search Engine | Semantic search, query optimization & real-time analytics for MySQL databases | Zero-migration setup.

Language: TypeScript - Size: 909 KB - Last synced at: 9 days ago - Pushed at: 9 days ago - Stars: 5 - Forks: 1

zhangysh1995/awesome-database-testing

数据库测试资料 This repo is a collection of resources on testing database systems

Size: 80.1 KB - Last synced at: 11 days ago - Pushed at: 5 months ago - Stars: 170 - Forks: 18

Btsan/Sketched-SPNs

Code for the paper "Sketched Sum-Product Networks for Joins"

Language: Python - Size: 223 KB - Last synced at: about 2 months ago - Pushed at: about 2 months ago - Stars: 0 - Forks: 0

denysgerasymuk799/virny-flow

A design space for responsible model development that combines evaluation protocol definition, multi-objective Bayesian optimization, cost-aware multi-armed bandits, query optimization, and distributed parallelism.

Language: Jupyter Notebook - Size: 30.6 MB - Last synced at: about 2 months ago - Pushed at: about 2 months ago - Stars: 2 - Forks: 0

saagarnkashyap/Efficient-Query-Processing-in-Column-Family-Database

This repository contains the technical paper and related materials on efficient query processing in Column Family Databases. The paper explores strategies to optimize query performance, focusing on techniques like indexing, query optimization, and data partitioning.

Size: 242 KB - Last synced at: 2 months ago - Pushed at: 2 months ago - Stars: 1 - Forks: 0

hashim21223445/query Fork of npm/query

npm query parser and tools

Language: JavaScript - Size: 125 KB - Last synced at: 2 months ago - Pushed at: 2 months ago - Stars: 1 - Forks: 0

mtholahan/postgresql-tuning-mini-project

Optimized PostgreSQL queries on a computer science publications dataset. Created tables, ingested CSVs, and wrote queries to analyze conferences, authors, and publication trends. Improved performance by designing indexes, refining join/filter logic, and evaluating execution plans with EXPLAIN, demonstrating query tuning and indexing strategies.

Size: 37.1 KB - Last synced at: 2 months ago - Pushed at: 2 months ago - Stars: 0 - Forks: 0

vposd/CachedQueries

CachedQueries is a .NET library that integrates caching directly into Entity Framework (EF) queries. It allows you to cache IQueryable results without adding extra layers, simplifying implementation while improving performance. The library ensures efficient data retrieval, straightforward cache invalidation, and seamless usage with EF’s queries

Language: C# - Size: 261 KB - Last synced at: 24 days ago - Pushed at: 12 months ago - Stars: 8 - Forks: 2

bsoom511m/freelando_webapi_course-alura-entity-framework-core-transactions_part-12_dotnet-8_csharp-12

🔍 Master advanced queries and transactions in EF Core with this hands-on course repository, enhancing your .NET skills through practical exercises.

Size: 105 KB - Last synced at: 2 months ago - Pushed at: 2 months ago - Stars: 0 - Forks: 0

c3xingchen/freelando_webapi_course-alura-entity-framework-core-transactions_part-6_dotnet-8_csharp-12

📊 Explore advanced EF Core transactions, architectural patterns, and SQL command interception in this .NET 8 course repository from Alura.

Size: 0 Bytes - Last synced at: 2 months ago - Pushed at: 2 months ago - Stars: 0 - Forks: 0

sony-g27/Healthcare-Data-Exploration

SQL-driven exploration of healthcare data to uncover demographic and treatment insights.

Size: 4.88 KB - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0

OmprakashTillore/QueryGPT

🔍 Enhance data queries with QueryGPT, a tool that simplifies complex queries using natural language processing for efficient data retrieval.

Language: JavaScript - Size: 4.3 MB - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0

agibahrul/PostgreSQLtvb

📊 Streamline PostgreSQL database management and visualization with PostgreSQLtvb, enhancing data insights and performance tracking effortlessly.

Size: 4.88 KB - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0

muneeb6595/MySQLhaf

🔧 Simplify MySQL database management with MySQLhaf, a seamless tool for efficient operations and optimal performance.

Size: 4.88 KB - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0

Mattialesto/freelando_webapi_course-alura-entity-framework-core-transactions_part-1_dotnet-8_csharp-12

Repositório com exercícios do curso “.NET: avance na persistência com EF Core” da Alura. Aborda consultas avançadas, modelo rico, uso de transações, boas práticas com padrões arquiteturais e interceptação de comandos SQL com o Entity Framework Core.

Size: 1.95 KB - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0

Rezero22/freelando_webapi_course-alura-entity-framework-core-transactions_part-6_dotnet-8_csharp-12

Repositório com exercícios do curso “.NET: avance na persistência com EF Core” da Alura. Aborda consultas avançadas, modelo rico, uso de transações, boas práticas com padrões arquiteturais e interceptação de comandos SQL com o Entity Framework Core.

Size: 1.95 KB - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0

marcin-kor/freelando_webapi_course-alura-entity-framework-core-transactions_part-11_dotnet-8_csharp-12

Repositório com exercícios do curso “.NET: avance na persistência com EF Core” da Alura. Aborda consultas avançadas, modelo rico, uso de transações, boas práticas com padrões arquiteturais e interceptação de comandos SQL com o Entity Framework Core.

Size: 1.95 KB - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0

Cryptic102/freelando_webapi_course-alura-entity-framework-core-transactions_part-2_dotnet-8_csharp-12

Repositório com exercícios do curso “.NET: avance na persistência com EF Core” da Alura. Aborda consultas avançadas, modelo rico, uso de transações, boas práticas com padrões arquiteturais e interceptação de comandos SQL com o Entity Framework Core.

Size: 1.95 KB - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0

Mansiikumarii/MySQL

A curated collection of MySQL scripts covering DDL, DML, and DRL operations. Ideal for beginners to practice and understand core SQL concepts.

Size: 16.6 KB - Last synced at: 2 months ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0

HussienDataAnalyst/SQL-Practice-Questions

A collection of real-world SQL practice questions with solutions, designed to strengthen query skills for data analysis and business insights. Includes scenarios for aggregation, joins, filtering, and advanced SQL techniques.

Size: 3.91 KB - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0

AdiDrac/Relational_Database_Design_Project

Design and implement a normalized relational database for a coffee shop chain using PostgreSQL and MySQL. Explore data modeling and SQL scripting. 🐙

Language: PLpgSQL - Size: 1.69 MB - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0

shivee-code/sql_project_portfolio

A collection of real-world SQL projects focused on business insights, data analysis, and advanced querying using MySQL.

Size: 199 KB - Last synced at: 4 months ago - Pushed at: 4 months ago - Stars: 0 - Forks: 0

tanushree-c/SQL-Projects

A collection of hands-on SQL projects for data analysis, business insights, and reporting. Each project explores real-world datasets using SQL queries and best practices.

Size: 44.9 KB - Last synced at: 4 months ago - Pushed at: 4 months ago - Stars: 0 - Forks: 0

Cyberoctane29/CUO-On-Site-Internship--Retail-Store-Database-Evaluation-and-Optimization

This repository showcases my internship project at CUO, focused on querying and analysing a music retail store database. Key tasks included analyzing the schema, improving query performance, ensuring data integrity, and implementing security measures. This project enhanced my understanding of database management in a business setting.

Language: Jupyter Notebook - Size: 8.24 MB - Last synced at: 4 months ago - Pushed at: 4 months ago - Stars: 2 - Forks: 0

AhmedSobhy01/query-optimization-research

This repository presents research on SQL query optimization, exploring how different indexing strategies and PostgreSQL configurations impact query performance. The project, which earned second place at TCCD Research Day, provides insights into improving database efficiency.

Language: Python - Size: 6.53 MB - Last synced at: 4 months ago - Pushed at: 11 months ago - Stars: 9 - Forks: 1

cosh/KustoGraphAssistant

A Model Context Protocol (MCP) server that provides comprehensive guidance and best practices for creating and managing Kusto graph models in Azure Data Explorer.

Language: C# - Size: 22.5 KB - Last synced at: 3 months ago - Pushed at: 4 months ago - Stars: 1 - Forks: 0

Jevik-R/Log-Ingestor

Log Ingestor is a scalable DBMS project designed to manage large volumes of log data generated by distributed servers. It uses database sharding to store logs server-wise, maintaining uniform log formats per server and improving query efficiency. This design simplifies log retrieval, speeds up debugging, and supports security compliance.

Size: 1.32 MB - Last synced at: 4 months ago - Pushed at: 4 months ago - Stars: 1 - Forks: 0

Tsihan/LIMAOLifeLongRLDB

LIMAO is a Lifelong Modular Reinforcement Learning framework designed for database query optimization in dynamic environments.

Language: Python - Size: 300 MB - Last synced at: 4 months ago - Pushed at: 4 months ago - Stars: 1 - Forks: 0

Naeem1144/sql-analysis

SQL projects for train booking & retail analytics

Size: 29.3 KB - Last synced at: 4 months ago - Pushed at: 5 months ago - Stars: 0 - Forks: 0

Teymur-Babayev/Laravel-twitcher

twitcher

Language: JavaScript - Size: 49 MB - Last synced at: 2 months ago - Pushed at: over 1 year ago - Stars: 14 - Forks: 0

utndatasystems/parachute

🪂 Parachute: Single-Pass Bi-Directional Information Passing (VLDB'25)

Language: Python - Size: 16.8 MB - Last synced at: 5 months ago - Pushed at: 5 months ago - Stars: 0 - Forks: 0

johansolbakken/benchmark

A repository for benchmarking Optimistic Order-Preserving Hash Join (OOHJ) in MySQL using the Join Order Benchmark (JOB). Part of a Master’s thesis project, it includes scripts for setting up the database, running SQL queries, and evaluating performance.

Language: Ruby - Size: 130 MB - Last synced at: 5 months ago - Pushed at: 5 months ago - Stars: 1 - Forks: 0

IT21314742/Database-System_-IT3020-_Lab-Sheets

This repository contains labsheets from the Database Systems (IT3020) module, focused on relational and non-relational databases, object-relational features, XML and NoSQL models, indexing, query optimization, and transaction management. Developed for academic learning and practice.

Language: PLSQL - Size: 13.7 KB - Last synced at: 6 months ago - Pushed at: 6 months ago - Stars: 0 - Forks: 0

TungPhamDuy/apache-cassandra-data-modeling

Data modeling project for Apache Cassandra, focusing on optimizing queries for a music streaming analytics database. Implements ETL processes to populate Cassandra tables, demonstrating NoSQL data modeling principles and query optimization for distributed systems.

Language: Jupyter Notebook - Size: 1.39 MB - Last synced at: 5 months ago - Pushed at: 6 months ago - Stars: 0 - Forks: 0

AliGhorbaniGit/Store-API

A Dockerized Online Shop API built with Django REST Framework

Language: Python - Size: 195 KB - Last synced at: 6 months ago - Pushed at: 6 months ago - Stars: 0 - Forks: 0

AliGhorbaniGit/Learnify

Learnify is an interactive educational platform designed to promote knowledge sharing through video tutorials and articles. It encourages students to contribute by curating content, creating a collaborative space for peer learning. Built with modern tools, it features advanced authentication, content management, and user engage

Language: JavaScript - Size: 2.69 MB - Last synced at: 6 months ago - Pushed at: 6 months ago - Stars: 0 - Forks: 0

ksm26/Prompt-Compression-and-Query-Optimization

Enhance the performance and cost-efficiency of large-scale Retrieval Augmented Generation (RAG) applications. Learn to integrate vector search with traditional database operations and apply techniques like prefiltering, postfiltering, projection, and prompt compression.

Language: Jupyter Notebook - Size: 88.9 KB - Last synced at: 20 days ago - Pushed at: over 1 year ago - Stars: 1 - Forks: 0

zchoi/GLSCL

[TIP25] Code for "Text-Video Retrieval with Global-Local Semantic Consistent Learning"

Language: Python - Size: 5.41 MB - Last synced at: 6 months ago - Pushed at: 6 months ago - Stars: 13 - Forks: 0

tonylevine/Rockbuster-Data-Analysis

SQL-based end-to-end data analysis project delivering actionable business insights to a video rental store

Size: 546 KB - Last synced at: 6 months ago - Pushed at: 6 months ago - Stars: 0 - Forks: 0

wiktork77/oracle_sql_cats

Language: PLSQL - Size: 33.2 KB - Last synced at: 6 months ago - Pushed at: 6 months ago - Stars: 0 - Forks: 0

eugene-khyst/postgresql-performance-essentials

PostgreSQL performance essentials in 1 hour

Size: 71.3 KB - Last synced at: 7 months ago - Pushed at: over 3 years ago - Stars: 62 - Forks: 14

madhurimarawat/Data-Warehousing

This repository contains practical examples of data warehousing concepts, including star schema and ETL processes, all implemented using MySQL.

Language: Jupyter Notebook - Size: 10.5 MB - Last synced at: 6 months ago - Pushed at: 7 months ago - Stars: 1 - Forks: 0

motapinto/sql-query-optimization

SQL: Query optimization

Size: 10.9 MB - Last synced at: 4 months ago - Pushed at: over 4 years ago - Stars: 2 - Forks: 1

KGVikas/SQL-Data-Analysis

Cleaned & analyzed layoff data from `layoffs.csv`. Performed data cleaning (removed duplicates, standardized values) in `data_cleaning_project.sql`, then explored trends in `data_analysis.sql`—top companies, industries, countries, and temporal patterns using SQL aggregations, CTEs, and window functions.

Size: 55.7 KB - Last synced at: 7 months ago - Pushed at: 7 months ago - Stars: 0 - Forks: 0

annitziak/database_systems

SQL interpreter from scratch in Java of a relational database system with query optimizations

Language: Java - Size: 211 KB - Last synced at: 7 months ago - Pushed at: 7 months ago - Stars: 0 - Forks: 0

PrthD/MongoDB-Document-Store-Query-System

🗄️ A MongoDB Document Store Query System that loads and queries JSON data to analyze the impact of normalized vs. embedded document models on query performance. Implements indexing strategies and structured queries to evaluate database efficiency, making it a valuable tool for NoSQL schema design and performance benchmarking. 🚀📊

Language: Python - Size: 14 MB - Last synced at: about 1 month ago - Pushed at: about 1 year ago - Stars: 0 - Forks: 0

Sushmashreeps10/Full-stack-development2025

Database Assessments 📊 A collection of database assessments covering SQL queries, normalization, indexing, transactions and performance optimization. Perfect for practice & skill improvement! 🚀

Language: Java - Size: 5.23 MB - Last synced at: 5 months ago - Pushed at: 8 months ago - Stars: 3 - Forks: 0

zio/zio-query

Add efficient pipelining, batching, and caching to any data source

Language: Scala - Size: 915 KB - Last synced at: 5 months ago - Pushed at: 8 months ago - Stars: 152 - Forks: 22

nehaask/Spotify-Music-Data-Analysis

Analyzed Spotify’s 12M-song dataset using SQL and NoSQL modeling, normalization, indexing, and the Apriori algorithm for pattern mining.

Language: Python - Size: 14.5 MB - Last synced at: 8 months ago - Pushed at: 8 months ago - Stars: 0 - Forks: 0

sueszli/query-queen

postgres query execution plan analysis and benchmarking

Language: Jupyter Notebook - Size: 19.6 MB - Last synced at: 6 months ago - Pushed at: 9 months ago - Stars: 0 - Forks: 0

balsa-project/balsa

Balsa is a learned SQL query optimizer. It tailor optimizes your SQL queries to find the best execution plans for your hardware and engine.

Language: Python - Size: 29.1 MB - Last synced at: 7 months ago - Pushed at: over 3 years ago - Stars: 139 - Forks: 26

tuannh982/query-planner-guide

build your own query planner

Language: Scala - Size: 3.39 MB - Last synced at: 7 months ago - Pushed at: about 1 year ago - Stars: 26 - Forks: 1

course-files/BBT3104-Lab6of6-QueryOptimization

Instructional materials (course files) for the BBT3104 course (Advanced Database Systems) and the MIT8107 course (Advanced Database Systems). Topic: Query Optimization. Based on the IMDb dataset using PostgreSQL and the Join Order Benchmark (JOB).

Language: Python - Size: 1.52 MB - Last synced at: 9 months ago - Pushed at: 9 months ago - Stars: 0 - Forks: 5

Victory-Ik/Analysing-motorcycle-part-sales

This project analyses wholesale sales data to determine how much net revenue each product line generated per month per warehouse. The dataset contains sales transactions from June to August 2021, including details such as payment methods, warehouses, and client types.

Size: 2.93 KB - Last synced at: 9 months ago - Pushed at: 9 months ago - Stars: 0 - Forks: 0

FireTyrant/SQL-Portfolio-Projects

Documenting my SQL learning journey with hands-on projects focused on data cleaning, analysis, and optimization.

Size: 19.5 KB - Last synced at: 8 months ago - Pushed at: 8 months ago - Stars: 0 - Forks: 0

berksudan/Data-Engineering-Case-Study-with-SQL-Optimization-and-Python-Data-Integration

Case Study for a data engineering job application at a company

Language: Python - Size: 2.09 MB - Last synced at: 10 months ago - Pushed at: 10 months ago - Stars: 1 - Forks: 0

Md-Emon-Hasan/Vector-Database

Designed to store and retrieve high-dimensional data, such as embeddings, efficiently. It enables fast similarity searches by leveraging techniques.

Language: Jupyter Notebook - Size: 9.19 MB - Last synced at: 8 months ago - Pushed at: 10 months ago - Stars: 1 - Forks: 0

kiranmayi5/SQL-Database-Projects

A collection of projects focused on demonstrating expertise in SQL, database design, and data analysis.

Size: 108 KB - Last synced at: 9 months ago - Pushed at: 10 months ago - Stars: 1 - Forks: 0

fukien/carrot

Autumn 2017. A simple implementation of relational database with query optimization as the course project of Principles and Design of Database System, Renmin University of China.

Language: C++ - Size: 20.7 MB - Last synced at: 5 months ago - Pushed at: almost 5 years ago - Stars: 20 - Forks: 6

MatthewYeend/Query-Optimizer 📦

Query Optimizer package for Laravel

Language: PHP - Size: 27.3 KB - Last synced at: 2 months ago - Pushed at: 10 months ago - Stars: 0 - Forks: 0

yizenov/l1-error

Sub-optimal Join Order Indicator

Language: Python - Size: 2.4 MB - Last synced at: 10 months ago - Pushed at: 10 months ago - Stars: 1 - Forks: 0

handdl/btcnn

torch-like convolution over binary trees

Language: Python - Size: 121 KB - Last synced at: 11 months ago - Pushed at: 11 months ago - Stars: 0 - Forks: 0

nidhiupman568/MY-SQL-PROBLEM-SOLVED

🌟Welcome to a curated 📚 collection 📚 of solved 🛠️ MySQL 💾 interview 💬 problems ❓ from LeetCode 💡. 📊🔍 This section 📚 showcases 🔍 key questions ❓ and their solutions 💡, providing 📊 a valuable 🛠️ resource 📚 for anyone 💬 preparing 🛠️ for SQL 💾 interviews 💬. 🚀

Size: 64.5 KB - Last synced at: 8 months ago - Pushed at: over 1 year ago - Stars: 3 - Forks: 0