BestHub
Sign in
Tagged articles

database query

9 articles · Page 1 of 1
AI Large-Model Wave and Transformation Guide
AI Large-Model Wave and Transformation Guide
Aug 20, 2026 · Artificial Intelligence

Can You Query a Database Without Writing SQL? How NL2SQL Lets You Talk to Your Data

NL2SQL transforms natural language queries into executable SQL, enabling non‑technical users to retrieve data by simply speaking, and the article explains its workflow, evolution from rule‑based to large‑model approaches, current performance on the Spider benchmark, remaining challenges, and real‑world use cases.

AINL2SQLNatural Language Processing
0 likes · 7 min read
Can You Query a Database Without Writing SQL? How NL2SQL Lets You Talk to Your Data
liandk
liandk
Aug 11, 2026 · Databases

Mastering SELECT: The Most Used SQL Query for Beginners

SELECT is the most frequently used SQL command, handling about 80% of data‑related work; this guide explains its core role, basic operations such as selecting all rows, specific columns, distinct values, and row limits, shows practical code examples, and advises against using SELECT * for better performance.

Data RetrievalSELECTSQL
0 likes · 2 min read
Mastering SELECT: The Most Used SQL Query for Beginners
Architect
Architect
Dec 15, 2024 · Databases

Efficient MySQL Queries for Millions of Rows: Regular, Stream, and Cursor

When processing massive MySQL result sets, loading all rows into JVM memory can cause OOM and slow performance, so this guide compares three approaches—regular pagination, streaming queries using server-side cursors, and cursor‑based fetchSize control—detailing their implementations, MyBatis configurations, and trade‑offs.

CursorLarge DataMyBatis
0 likes · 10 min read
Efficient MySQL Queries for Millions of Rows: Regular, Stream, and Cursor
Architecture Digest
Architecture Digest
Aug 6, 2024 · Information Security

How to Perform Fuzzy Queries on Encrypted Data: Approaches and Trade‑offs

This article examines why encrypted data is unfriendly to fuzzy search, categorises three implementation strategies—naïve, conventional, and advanced—analyses their advantages and disadvantages, and provides practical guidance and reference links for securely enabling fuzzy queries on encrypted fields.

algorithm designdatabase queryencrypted data
0 likes · 11 min read
How to Perform Fuzzy Queries on Encrypted Data: Approaches and Trade‑offs
Java Interview Crash Guide
Java Interview Crash Guide
Mar 21, 2022 · Databases

Mastering Multi‑Entity Sales Queries with SQL Row Comparison

This article explains how to design a MySQL table for product sales statistics and compares several query strategies—including loop queries, OR concatenation, mixed filtering, and the SQL‑92 row‑by‑row comparison—to efficiently retrieve sales data for dynamic sets of business institutions and their products in a single indexed query.

MySQLRow ComparisonSQL
0 likes · 7 min read
Mastering Multi‑Entity Sales Queries with SQL Row Comparison
Top Architect
Top Architect
Aug 20, 2021 · Databases

Querying Multi‑Business Unit Product Sales Statistics with MySQL and MyBatis Dynamic SQL

This article explains how to retrieve sales statistics for multiple business units and their associated products from a MySQL table, compares several implementation approaches—including loop queries, OR concatenation, mixed filtering, and row‑comparison using MyBatis dynamic SQL—evaluates index usage, and provides the final recommended solution.

Dynamic SQLMyBatisMySQL
0 likes · 8 min read
Querying Multi‑Business Unit Product Sales Statistics with MySQL and MyBatis Dynamic SQL