SQL

SQL | News, how-tos, features, reviews, and videos

weird science 2017universe

Review: Kinetica analyzes billions of rows in real time

GPU database is not only hugely scalable, but integrates graph analysis, location intelligence, and machine learning with standard SQL

weird science 2017universe

Review: Kinetica analyzes billions of rows in real time

GPU database is not only hugely scalable, but integrates graph analysis, location intelligence, and machine learning with standard SQL

Conceptual image of a digital circuit-board key amid binary code.

Composite keys in JPA and Hibernate

Use embeddable objects to join two primary keys into one composite key

Lineup of anthropomorphic nuts, illustrating polymorphism.

Inheritance relationships in JPA and Hibernate

Learn four ways to manage inheritance relationships and support polymorphic querying in Java ORM

JavaWorld > Persistence [series] > data blocks / structure / database / data center

Java persistence with JPA and Hibernate, Part 2: Many-to-many relationships

Many-to-many relationships and cascade type strategies in JPA and Hibernate

JavaWorld > Persistence [series] > data / data center / database / server

Java persistence with JPA and Hibernate, Part 1: Entities and relationships

Get started modeling entities and relationships for Java data persistence, using an example application based on Java 8 with Hibernate 5.3.6

JavaWorld > Persistence [series] > coding / programming / software development

What is JDBC? Introduction to Java Database Connectivity

Get to know Java's low-level API for making database connections and handling SQL queries and responses

Statue of Atlas against a blue sky.

Review: OmniSci GPU database lifts huge data sets

GPU acceleration of database, rendering, and visualization enables interactive exploration of data sets with billions of rows

innovation inspiration lightbulb idea continuity creativity

Why you should use SQLite

Learn why this compact embedded relational database shines for many desktop, mobile, and edge computing applications

innovation inspiration lightbulb idea continuity creativity

Why you should use SQLite

Learn why this compact embedded relational database shines for many desktop, mobile, and edge computing applications

knot rope joined tie tied

MariaDB Platform X3 combines transaction processing and analytics

MariaDB has fused its relational and column-store databases into one, with data automatically synced between workload types

sea lion

SQL tutorial: Learn SQL on MariaDB

Follow this step-by-step guide to install MariaDB, load data, connect to a database, and execute SQL queries including table joins

sea lion

SQL tutorial: Learn SQL on MariaDB

Follow this step-by-step guide to install MariaDB, load data, connect to a database, and execute SQL queries including table joins

bullseye target with 3 arrows

Why you should use Gandiva for Apache Arrow

An execution engine for Arrow-based in-memory processing, Gandiva brings dramatic performance improvements to analytical workloads

speed fast speedometer accelerate

PostgreSQL 11 taps LLVM and parallelization for speed boost

The powerful open source database now offers more features for data sharing, JIT-accelerated queries, and transactions inside stored procedures

big data blue

How TiDB combines OLTP and OLAP in a distributed database

The architecture and use cases of a NewSQL hybrid transactional-analytical, MySQL-compatible, horizontally scalable database

elephant eye close up lurking menacing postgresql

SQL tutorial: Learn SQL on PostgreSQL

Follow this step-by-step guide to install PostgreSQL, load data, connect to a database, and execute SQL queries including table joins

California sea lion

MariaDB tutorial: Get started with MariaDB

Download, install, and set up a basic instance of the popular open source database with this step-by-step guide

California sea lion

MariaDB tutorial: Get started with MariaDB

Download, install, and set up a basic instance of the popular open source database with this step-by-step guide

bos 2018 data

The best open source software for data storage and analytics

InfoWorld’s 2018 Best of Open Source Software Award winners in databases and data analytics

Load More