InfoQ Homepage Database Management Content on InfoQ

Articles

RSS Feed

Newer Older

AI, ML & Data Engineering

How to Migrate an Oracle Database to MySQL Using AWS Database Migration Service

Data migration efforts are typically taken up for database consolidation, cost considerations, or migrating on-prem databases to a cloud platform. In this article, author Deepak Vohra discusses the details of migrating a local database to MySQL database on the cloud, using AWS Database Migration Service.

Deepak Vohra
on Sep 07, 2022
AI, ML & Data Engineering

The Next Evolution of the Database Sharding Architecture

In this article, author Juan Pan discusses the data sharding architecture patterns in a distributed database system. She explains how Apache ShardingSphere project solves the data sharding challenges. Also discussed are two practical examples of how to create a distributed database and an encrypted table with DistSQL.

Trista Pan
on Jan 12, 2022
AI, ML & Data Engineering

Building an SQL Database Audit System Using Kafka, MongoDB and Maxwell's Daemon

In this article, the author discusses the importance of a database audit logging system outside of traditional built-in data replication, using technologies like Kafka, MongoDB, and Maxwell's Daemon.

Vishal Sinha
on Jan 01, 2021
DevOps

How to Source Control Your Databases for DevOps

A robust DevOps environment requires having continuous integration for every component of the system. But far too often, the database is omitted from the equation. In this article, we discuss the unique aspects of databases, both relational and NoSQL, in a successful continuous integration environment.

Jonathan Allen
on Nov 12, 2018
DevOps

GDPR for Operations

With GDPR, taking care of personal data is an organisation-wide responsibility, but in the operations we can provide a lot of supporting tools to help deal with the multiple facets of this problem.

Jon Topper
on Mar 10, 2018
DevOps

Why and How Database Changes Should Be Included in the Deployment Pipeline

Eduardo Piairo on why databases and applications should coexist in the same deployment pipeline and different scenarios and steps to achieve it.

Eduardo Piairo
on Jan 30, 2018
Development

Introducing Obevo: Get Your Database SDLC under Control

In this article, we will describe how Obevo, Goldman Sachs' recently open-sourced DB Deployment utility, helped many of our enterprise applications get their databases under SDLC control.

Shant Stepanian
on Dec 01, 2017
AI, ML & Data Engineering

Pascal Desmarets on NoSQL Data Modeling Best Practices

NoSQL databases are specialized to store different types of data like Key Value, Documents, Column Family, Time Series, Graph, and IoT data. Pascal Desmarets talks about how to perform data modeling in NoSQL databases compared to the modeling in Relational databases.

Srini Penchikala
on May 01, 2017
The Definitive Guide to Database Version Control

In the brave new world of big data and BI, the only technology constant is change. When it comes to database change, agility through automation - the ability to do more with less more rapidly to accelerate delivery – is what differentiates highly competitive, world-class enterprises from the rest of the crowd.

Uri Margalit
on Dec 04, 2014
Your Database: The Threat That Lies Within

What do you need to properly administer you database from conception to production? Yaniv Yehuda talks about some of the challenges that developers are often not even aware of and the tools he prefers to deal with them.

Yaniv Yehuda
on Sep 03, 2014
Database Continuous Delivery

The database creates a real challenge for automation, hence participation in continuous processes. Scripting database objects change-scripts into traditional version or using 'compare & sync' tools is either an inefficient or risky thing to automate, as the two concepts are unaware of the other. A better solution needs to be implemented in the shape of Continuous Delivery and DevOps for database.

Yaniv Yehuda
on May 08, 2014
The Secrets of Database Change Deployment Automation

Yaniv Yehuda looks at the challenges involved in automating database deployments and offer suggestions based on Agile and DevOps concepts.

Yaniv Yehuda
on Feb 07, 2014