September 2017
Beginner to intermediate
49 pages
55m
English
Content preview from Defining Data-Driven Software Development
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Chapter 4. What DBAs Want
DBAs maintain data in an RDBMS-centric information processing environment, and the typical DBA manages 40 databases containing an average of 5 TB of data.1 Therefore, many have developed a comprehensive, if somewhat protective, view toward maintaining data integrity and accessibility. Perhaps as a consequence, there is some concern in the industry that DBAs are now becoming a limiting factor as organizations attempt to speed up their delivery pipeline.2
ACID Compliance
To ensure streams of data are accurate and consistent, ACID compliance might be a requirement placed on our database management system. To that end, let’s review the ACID acronym:
- Atomicity
-
Make all changes or none.
- Consistency
-
All changes obey database rules.
- Isolation
-
Apply all changes step by step before showing any changes.
- Durability
-
Changes will be permanent.
Note: Some systems will claim “ACID” but ACID across one document is not the same as ACID across the dataset. Likewise, eventual consistency is not the same as formal consistency.
The choice of DBMS will determine whether the database can be trusted to provide the necessary reliability, or whether the developer will need to account for this in the application code.
Minimal Schema Changes
For DBAs, schema changes are critical transactions that need planning and careful execution. Frequent and reckless changes in schemas are both difficult to manage in RDBMSs and propagate risk in ways that are sometimes difficult ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.