You are creating a database from scratch for an application This application will have multiple siloed environments (PROD, TST, INT, DEV) Data from PROD will nightly be moved to the other environments ...

Software developers today have more options open to them. They have tools and services that can help them build new applications quickly, then launch those services to customers globally, and then ...

The end goal of database design is to be able to transform a logical data model into an actual physical database. A logical data model is required before you can even begin to design a physical ...

In the world of tech and innovation, there's a perception that new and disruptive technologies originate solely from a select group of tech elites in Silicon Valley. While this is an obvious ...

There are many ways to describe a database: the role it plays in a distributed architecture, the various internal components that make it work, and the various levels that define specific roles and ...

A proper database design cannot be thrown together quickly by novices. A practiced and formal approach to gathering data requirements and modeling data is mandatory. This modeling effort requires a ...

I recently published a tutorial describing the different available methods to store data locally in an Android app. However, due to article length constraints, I could not adequately cover creating ...

Kevin Xu is general manager of global strategy and operations at PingCAP. TiDB is an open-source, cloud-native, MySQL-compatible distributed database that handles hybrid transactional and analytical ...