Work by Database Architecture

Database Architecture

Database-centric architecture or data-centric architecture has several distinct meanings, generally relating to software architectures in which databases play a crucial role. Often this description is meant to contrast the design to an alternative approach. For example, the characterization of an architecture as "database-centric" may mean any combination of the following:

  • using a standard, general-purpose relational database management system, as opposed to customized in-memory or file-based data structures and access methods. With the evolution of sophisticated DBMS software, much of which is either free or included with the operating system, application developers have become increasingly reliant on standard database tools, especially for the sake of rapid application development.
  • using dynamic, table-driven logic, as opposed to logic embodied in previously compiled programs. The use of table-driven logic, i.e. behavior that is heavily dictated by the contents of a database, allows programs to be simpler and more flexible. This capability is a central feature of dynamic programming languages. See also control tables for tables that are normally coded and embedded within programs as data structures (i.e. not compiled statements) but could equally be read in from a flat file, database or even retrieved from a spreadsheet.
  • using stored procedures that run on database servers, as opposed to greater reliance on logic running in middle-tier application servers in a multi-tier architecture. The extent to which business logic should be placed at the back-end versus another tier is a subject of ongoing debate. For example, Toon Koppelaars presents a detailed analysis of alternative Oracle-based architectures that vary in the placement of business logic, concluding that a database-centric approach has practical advantages from the standpoint of ease of development and maintainability.
  • using a shared database as the basis for communicating between parallel processes in distributed computing applications, as opposed to direct inter-process communication via message passing functions and message-oriented middleware. A potential benefit of database-centric architecture in distributed applications is that it simplifies the design by utilizing DBMS-provided transaction processing and indexing to achieve a high degree of reliability, performance, and capacity. For example, Base One describes a database-centric distributed computing architecture for grid and cluster computing, and explains how this design provides enhanced security, fault-tolerance, and scalability.
Title Status Start Date End Date Company
The Tech Buyer's Guru - Platform Migration Drupal to Wordpress Ongoing 12/19/2019 The Tech Buyer Guru
Wheel of Fortune - Sony Pictures Television Completed 10/07/2019 10/06/2020 Metal Toad
Los Angeles Philharmonic Mobile Application Completed 07/31/2018 06/24/2019 Los Angeles Philharmonic
The Tech Buyer's Guru - Drupal Maintenance Ongoing 05/31/2018 The Tech Buyer Guru
NetStable Corporate Website Completed 03/15/2018 07/12/2021 NetStable
Sony Networks Customer Portal - Sony Pictures Television Completed 03/12/2018 05/09/2019 Metal Toad
Nia Now 3.0 - Architecture, Design and Development On Hold 04/17/2017 07/17/2017 Nia Technique, Inc
Nia Technique, Inc - Strategy and Technology Consulting Completed 03/27/2017 01/11/2018 Nia Technique, Inc
Nia Now - Business Strategy, Management, and Development Consulting Completed 03/27/2017 01/11/2018 Nia Now
The Mighty Guild - Corporate Website V3 Ongoing 02/20/2017 The Mighty Guild Co.
Robert Foley Consulting - Corporate Website Ongoing 09/15/2016 Robert Foley Jr Consulting
Saturday Academy - Software Engineering Completed 07/19/2016 09/20/2016 Saturday Academy
The Mighty Guild - Corporate Website Completed 05/16/2016 07/13/2016 The Mighty Guild Co.
Multnomah Mental Health and Addiction Services - Responsive Website Redesign Completed 05/09/2016 07/27/2016 Multnomah Mental Health and Addiction Services
The White House - Home Page Highlights and Refactor Completed 10/13/2015 10/29/2015 The White House - Executive Branch
The White House - Petitions Automated Threshold Notification Completed 10/06/2015 10/10/2015 The White House - Executive Branch
The White House - Automated Developer API Key Management Completed 09/22/2015 10/03/2015 The White House - Executive Branch
The White House - Petitions Drupal 7 Refactor Completed 08/04/2015 09/24/2015 The White House - Executive Branch
The White House - Multi-database system refactor Completed 07/28/2015 08/20/2015 The White House - Executive Branch
The White House - Press Release Refactor Completed 06/23/2015 07/02/2015 The White House - Executive Branch