24 Results for:DDL

  • Sort by: 

What's the difference between DDL and DML?

By Bridget Botelho 26 Jun 2018

What's the difference between DDL and DML? Get the answer and see examples of data manipulation language and data definition language commands for SQL databases. Read More

How generative AI and cloud complement each other

By Aaron Tan 12 Oct 2023

McKinsey partner explains the symbiotic relationship between generative AI and cloud, enabling organisations to speed up cloud migration and harness the benefits of AI Read More

Hibernate and JPA column mapping with annotations

By Cameron McKenzie 04 Jun 2023

Effective Hibernate and JPA column mapping requires the use of the @Column annotation to set important properties such as nullability, uniqueness, precision and scale. Read More

Yugabyte: Decoding the claim of PostgreSQL compatibility

By Adrian Bridgwater 24 Jul 2023

This is a guest post for Computer Weekly Open Source Insider written in full by Karthik Ranganathan, co-founder and CTO, Yugabyte. Yugabyte is known for its distributed SQL database for what the ... Read More

What is the difference between data definition language (DDL) and SQL?

By Mark Whitehorn 02 Aug 2010

Learn the difference between a data definition language (DDL), also known as data descriptive language, and the Structured Query Language (SQL). Find examples of both DDL and SQL. Read More

How do you solve a problem like ‘bad database days’ MariaDB?

By Adrian Bridgwater 23 Jun 2021

MariaDB Community Server 10.6 has arrived. But, to be honest, version 10.6 doesn’t sound like more than a ‘point release’ not worth worrying too much about, right? The company insists otherwise and ... Read More

3 ways to have JPA and Hibernate create tables in a database

By Cameron McKenzie 26 Jun 2020

JPA frameworks such as Hibernate can automatically create tables. Here are three ways to have JPA and Hibernate create tables in a database. Read More

A version 5 Hibernate SchemaExport example with the ServiceRegistry and Metadata

By Cameron McKenzie 27 May 2020

The manner in which you create a version 5 Hibernate SchemaExport object is markedly different than earlier versions of the framework. But it's not overwhelmingly difficult. Here's how you do it. ... Read More

An example hibernate.cfg.xml for MySQL 8 and Hibernate 5

By Cameron McKenzie 02 Aug 2020

Hibernate 5 has updated dialects for various databases, and MySQL 8 has a special one of its own. Here's an example hibernate.cfg.xml for MySQL 8 for Hibernate 5 apps or newer. Read More

Steps for converting a logical data model into a physical data model

By Pete Stiglich 01 Jun 2010

Learn how to convert a logical data model into a physical data model via data modeling best practices. Find out how DDL and your data modeling practices play a role in conversions. Read More