Database management resources and information

Database management News

June 30, 2022 30 Jun'22
Cloudera embraces Apache Iceberg as cloud data lake evolves

The Cloudera Data Platform now supports the open source cloud data lake table format as part of the continuing evolution of the broader Hadoop ecosystem.
June 29, 2022 29 Jun'22
New Collibra, Snowflake integration enhances data governance

The new tool aims to enable customers to quickly put protections on sensitive data without requiring them to write code so that business users can securely work with data.
June 29, 2022 29 Jun'22
DataStax extends Astra Streaming event data platform

The data platform vendor extended its Apache Pulsar-based Astra Streaming platform with support for more streaming protocols, including Kafka, JMS and RabbitMQ.
June 29, 2022 29 Jun'22
Yugabyte distributed SQL database adds migration service

The YugabyteDB 2.15 distributed SQL database update introduces a table group feature to accelerate and optimize performance for different database workloads.

Bring yourself up to speed with our introductory content

Data Definition Language (DDL)

Data Definition Language (DDL) is used to create and modify the structure of objects in a database using predefined commands and a specific syntax. Continue Reading
DBMS keys: 8 types of keys defined

Here's a guide to primary, super, foreign and candidate keys, what they're used for in relational database management systems and the differences among them. Continue Reading
data abstraction

Data abstraction is the reduction of a particular body of data to a simplified representation of the whole. Continue Reading

Weigh the pros and cons of technologies, products and projects you are considering.

5 challenges IT faces using open source data management

There are a variety of open source challenges for data management software, including lack of real-time BI access, miscalculating costs and underestimating the resources required. Continue Reading
The benefits and pitfalls of cloud-based data management systems

Learn the benefits of cloud-based data management systems, common pitfalls and strategies when considering varying data levels and industry needs. Continue Reading
Top open source database advantages for enterprises

Open source databases typically offer lower upfront costs and more community support and, in recent years, have offered strong competition to commercial database offerings. Continue Reading

Learn to apply best practices and optimize your operations.

How to set up a MySQL database in Linux

Learn to prepare for a SQL-based Linux database, create a new database and create database users with permissions. This enables you to work with many other services. Continue Reading
NoSQL database types explained: Graph

NoSQL graph databases focus on the relationships between pieces of data. Two common frameworks bring different advantages and disadvantages over other NoSQL database types. Continue Reading
NoSQL database types explained: Key-value store

Learn about the benefits and detriments of utilizing a key-value store -- a simply designed NoSQL database that can potentially improve data processing speeds and scalability. Continue Reading

We’ve gathered up expert advice and tips from professionals like you so that the answers you need are always available.

hashing

Hashing is the process of transforming any given key or a string of characters into another value. Continue Reading
10 cloud database migration mistakes to avoid

Database expert Chris Foot lists the top 10 oversights IT teams commonly make when undertaking a cloud database migration and offers tips on how to avoid them. Continue Reading
Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL

In this book excerpt, you'll learn LEFT OUTER JOIN vs. RIGHT OUTER JOIN techniques and find various examples for creating SQL queries that incorporate OUTER JOINs. Continue Reading