Relational Database Design Patterns?

There’s a book in Martin Fowler’s Signature Series called Refactoring Databases. That provides a list of techniques for refactoring databases. I can’t say I’ve heard a list of database patterns so much.

I would also highly recommend David C. Hay’s Data Model Patterns and the follow up A Metadata Map which builds on the first and is far more ambitious and intriguing. The Preface alone is enlightening.

Also a great place to look for some pre-canned database models is Len Silverston’s Data Model Resource Book Series Volume 1 contains universally applicable data models (employees, accounts, shipping, purchases, etc), Volume 2 contains industry specific data models (accounting, healthcare, etc), Volume 3 provides data model patterns.

Finally, while this book is ostensibly about UML and Object Modelling, Peter Coad’s Modeling in Color With UML provides an “archetype” driven process of entity modeling starting from the premise that there are 4 core archetypes of any object/data model

Related Posts:

  1. What’s the difference between identifying and non-identifying relationships?
  2. Can I have multiple primary keys in a single table?
  3. What is this JavaScript “require”?
  4. How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
  5. CREATE DATABASE permission denied in database ‘master’ (EF code-first)
  6. WPDB Insert or if exists Update
  7. WP Multisite: load content from site X on site Y
  8. How does $wpdb handle COUNT(*)
  9. WordPress database error: [Query was empty] [closed]
  10. Login in WordPress using external database data
  11. Shared Members between two different wordpress installations with different databases
  12. What is the fastest way to generate a unique id number when registering a user
  13. Efficiency on displaying random authors based on large database
  14. How best to inject ads between posts in the loop?
  15. How to write Hebrew characters?
  16. Error establishing a database connection – with Debug Data
  17. Finding the login page from database?
  18. How to execute mulitple statement SQL queries using $wpdb->query?
  19. Does thumbnail regeneration edit the database?
  20. When and why should I use $wpdb different return types?
  21. Database with mixed collation (utf8mb4 & utf8_general_ci)
  22. WordPress database growing dramatically in size despite adding no new content
  23. Clean database from unused tables
  24. Delete all post meta except featured image Using SQL
  25. WordPress doesn’t show all posts in database
  26. Adding new row to wp_post table
  27. Extracting the post_id via the wp_insert_post action (external db query)
  28. How to interact with another wordpress install on same database?
  29. Are custom tables in the database overwritten when WordPress is updated to new versions?
  30. What is the proper way to validate and sanitize JSON response from REST API?
  31. How do I get the posts within a certain year/date(with sql query)?
  32. batch UPDATE autoload value in wp_options table
  33. Displaying BLOB PDF File
  34. Saving into post_excerpt or post_content
  35. Maintain user profile data in a non-WordPress database
  36. How to fix the disappearance of the “\” character when updating a post in the database
  37. Data storage for JS app using WP REST API
  38. Update from 4.5 to 4.6 failing
  39. Setup 3 Sites To Connect To 1 Database and Share Data
  40. How can I push local database changes to production, without impacting recent posts/pages that were published on production server?
  41. Setup private content for specific users with daily updates [closed]
  42. Does auto_load to ‘no’ in wp_options improve performance
  43. Connection refused on locahost after importing database?
  44. In which format the data is stored in WordPress Databases?
  45. creating new field on mysql
  46. Does WordPress store the username as a primary key in the database?
  47. Is it possible to rebuild the website while not accesseing the original database?
  48. Error message on blog posts only on my local environment [closed]
  49. how to read database fields
  50. $wpdb->query can’t insert data
  51. WSOD 3.9.1 – Tried Everything so far
  52. Database Update Required – Update from command-line
  53. Can you refresh ONLY the wordpress adminbar and not the whole page?
  54. Sending posts from Python to WordPress
  55. Problem migrating to localhost
  56. SQL query to set posts in bulk based on the post content
  57. Automate WordPress website setup with prefilled data
  58. Remote database connection and local development
  59. How can I detect right db type?
  60. Add search bar to Custom Database Table in WordPress Dashboard
  61. Custom search query by category id
  62. Design problems when exporting remote database for local development
  63. How do you render posts from outside wordpress?
  64. A change in URL slug in database returns 404, how can I do auto-redirect?
  65. Second ezSQL initialization for MSSQL
  66. Fetch a single row from a custom table for to a given ID
  67. Database create or redirect
  68. muliple wordpress installs (network) on different databases
  69. Database structure cheatsheet
  70. White Screen in Home Page
  71. WordPress Database – wp_usermeta and the correct number of session_tokens rows
  72. Continuous SQL query errors from outside source
  73. How to escape percentage sign(%) in sql query with $wpdb->prepare?
  74. Recovery – Restore Database after moving folder location locally
  75. Migrate Users From laravel to wordpress
  76. WordPress has been updated! Before we send you on your way, we have to update your database to the newest version
  77. how add more field to wp user and save it to database
  78. How do I cleanup my database with data that is no longer being used?
  79. Malware in old website – how to migrate?
  80. A WP dev site that displays content from a live site’s database but cannot write to wp_posts?
  81. error establishing database connection (WAMP + filezilla)
  82. Is there a way for two deferent themes to consume two different DB on a same WP instance?
  83. How do I update a WordPress wp_postmeta meta_value that contains many options
  84. How to display $wpdb->insert_id; value on redirected page
  85. Should I Use only wpdb Class to Write Custom Queries?
  86. Auto populate form fields based on serial input or pull listings from other websites?
  87. How to extract some part of WordPress full source code
  88. Catchable fatal error in formatting.php
  89. Wrong url for the images while using same database for two WordPress installations
  90. Error establishing a database connection for some files
  91. Hash user emails in database?
  92. Sending WordPress database information to cross domain the safe way?
  93. Database Name Change
  94. Weird characters in title if it contain “ ”
  95. Where To Find bb_profile_data(); In bbPress?
  96. DB access blocked when initializing WP externally
  97. Saving data to database and exporting to excel
  98. Site does not work right, pages not showing up, even for root admin
  99. One information repeated on multiple locations on one site [closed]
  100. Showing Error(TAble already exist)

Leave a Comment