ConnectOS

ReadOS / Technology

Databases and Data Models — Part 1

Relational thinking, database structures, data integrity, queries and information architecture.

24 chapters · About 264 minutes · Free to read

Start reading →
KEVOS / READOSTECHNOLOGYDatabases and DataModels — Part 1READOS COLLECTION

Contents

  1. 01Backfilling data while old and new schemas coexistPlan a database backfill that preserves concurrent updates, supports mixed application versions and proves completeness before the old representation is retired.
  2. 02Backing up business databases: recovery targets, restore testing and resilience against ransomwareA backup is only as good as the restore it allows. How to set recovery point and time targets, choose backup types, protect copies from ransomware and prove that restores work.
  3. 03Building repeatable test data for database behaviourHow to create small, controlled database fixtures that expose incorrect joins, missing constraints and migration errors without depending on shared or confidential production data.
  4. 04Building self-describing database archive packagesPreserve database records with the definitions, relationships, versions and validation evidence needed to understand them after the original application retires.
  5. 05Cache invalidation and database correctnessDesign database caches around acceptable staleness, update races, missing records and failure recovery, with practical ways to test their correctness.
  6. 06Changing a live business database safely: structure changes, migration scripts, testing and rollbackCustom systems change as businesses change. How to alter a live database's structure without losing data or stopping work: environments, versioned scripts, staged changes and rollback.
  7. 07Cloud, hosted or on-premise: deciding where business systems and their databases should runWhere a business system runs affects cost, reliability, security and control. How on-premise servers, hosting, managed databases and software as a service compare, and how to choose.
  8. 08Compensating business workflows across databasesDesign recovery for workflows that commit changes in several systems, with explicit compensation, durable progress, safe retries and visible unresolved work.
  9. 09Coordinating database writes with a unit of workHow to collect related application changes, distinguish flushing from committing, order dependent writes and handle failures without leaving a business operation half complete.
  10. 10Database views as stable data contractsUse database views to expose deliberate data contracts, with clear row meaning, types, update rules, access behaviour and compatibility tests as storage changes.
  11. 11Derived values and reproducible database calculationsHow to decide when to calculate, store or freeze a derived value, maintain its dependencies and explain why a saved result differs from a calculation performed today.
  12. 12Designing database triggers with predictable effectsKeep database triggers understandable by defining event scope, transaction effects, bulk behaviour, recursion, concurrency and the evidence needed to test them.
  13. 13Designing forms around database relationshipsHow to make parent records, repeated details and shared relationships clear in business forms, so users understand what they are viewing, changing and saving.
  14. 14Diagnosing database deadlocks and lock orderingUnderstand database deadlocks, distinguish them from ordinary blocking, and use evidence, consistent lock ordering and bounded retries to improve reliability.
  15. 15Enforcing business rules with database constraintsTranslate business rules into database constraints, distinguish state rules from transition rules, and test enforcement across imports and concurrent updates.
  16. 16Events, snapshots and workflow facts in reporting databasesHow to choose reporting rows for events, periodic observations and workflow milestones, reconcile their populations and avoid confusing activity with outstanding work.
  17. 17Hash tables, collisions and database lookupsUnderstand how hashing supports equality searches, why collisions and skew matter, and how to evaluate hash-based database work without misleading speed claims.
  18. 18Identity maps and conflicting copies of database recordsHow applications keep one coherent object for each database record, manage its lifetime and avoid conflicting edits, stale values and accidental cross-customer reuse.
  19. 19Managing legacy Microsoft Access databases: stabilise, upsize, rebuild, replace or retireMany businesses still run important processes on Access databases built years ago. How to assess their risks, stabilise them and choose to upsize, rebuild, replace or retire.
  20. 20Mapping supertypes and subtypes to database tablesChoose a table design for shared and specialised entities by examining identity, overlapping membership, subtype rules, relationships and real query patterns.
  21. 21Mapping XML documents to relational dataPreserve meaning when importing XML into relational tables by handling repeated elements, order, namespaces, missing values and document versions explicitly.
  22. 22Modelling three-way relationships in databasesRecognise facts that depend on three entities, avoid false combinations from pairwise links and choose keys and constraints that preserve the intended relationship.
  23. 23Normalisation and functional dependencies in database designUse functional dependencies to separate business facts, prevent update anomalies and review database normalisation without reducing design to a checklist.
  24. 24Open-source or commercial databases: licences, support, cost and risk for business systemsOpen-source and commercial databases differ in licences, support, cost and risk more than capability. How they compare and how to choose for custom systems, products and packages.

All chapters preserve the original KEVOS Insights content. These topic-based reading collections are organised alphabetically; chapters may be read in any order.

← All books