The following is an excerpt from Database Administration: The Complete Guide to Practices and Procedures, by Craig Mullins. It is reprinted here with permission from Addison Wesley Professional. Read ...

A relational database is a type of database that organizes data points with defined relationships for easy access. In the relational database model, the data structures-- data tables, indexes and ...

Things break and the DBA must be prepared for situations where a failure impacts the availability, integrity, or usability of a database. Reacting to failures and service disruptions is a key ...

Jeff Carpenter is a technical evangelist at DataStax. The past 10 years have seen the explosive growth of large-scale distributed systems. This trend has produced a whirlwind of creativity in the ...

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 ...

Document databases offer a wonderfully flexible data model that often leads to scaling and performance issues. Here’s how Aerospike overcomes these challenges. Digital transformation continues to be a ...

A data dictionary is like a bill of materials for a database; it lists all database components, including reports, tables, field names and field types. Such information helps audit databases for ...