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
National Service-Learning ClearingHouse - Drupal 6 Site Migration Completed 08/17/2009 02/24/2010 National Service-Learning Clearinghouse
Vitamin Angels - Fundraising System Completed 09/15/2009 03/10/2010 Breedlove Creative
City of Portland - Business Systems Audit Completed 09/21/2009 11/17/2009 City of Portland
NSLC - Drupal 6 Data Migration Completed 11/12/2009 05/05/2009 National Service-Learning Clearinghouse
Ensequence - Drupal 6 Site Migration Completed 11/30/2009 02/04/2011 Ensequence
Changents - Enterprise System Design Phase 1 Completed 12/09/2009 03/30/2010 Changents
Acumed - Drupal 6 Prototype Site Completed 01/08/2010 03/04/2010 Acumed
Health Resources - Medicineworks.com Drupal 6 Completed 02/11/2010 04/16/2010 Health Resources
JanRain Drupal 6 Website Completed 03/22/2010 06/25/2010 JanRain
River Network Drupal Salesforce Integration Completed 03/25/2010 07/23/2011 River Network
Health Resources - Medicineworks.com Maintenance and Support Completed 04/15/2010 06/15/2011 Health Resources
Tektronix - Enterprise Systems Consulting Completed 05/10/2010 09/30/2011 Tektronix
Tektronix - Enterprise Business Object Analysis Completed 05/18/2010 08/31/2011 Tektronix
City of Sherwood - Media Management Solution Completed 06/08/2010 08/05/2010 City of Sherwood
City of Sherwood - Meeting Resources Management Completed 07/20/2010 10/19/2010 City of Sherwood
CRC Health - Enterprise Deployment and Management Strategy Completed 08/03/2010 10/15/2010 CRC Health Group
Cool California - Cool Roofs Completed 08/09/2010 01/20/2011 Ecos
NSLC - Theme and Features Version 3.0 Completed 11/01/2010 12/24/2010 National Service-Learning Clearinghouse
Dogs for the Deaf - CMS and Ecommerce Completed 01/03/2011 07/12/2011 Dogs for the Deaf
Tektronix - Enterprise Hybris/Drupal Integration Completed 02/02/2011 08/18/2011 Tektronix