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
zGoddess - Drupal 5 and PHPbb System Support Completed 04/27/2009 05/25/2009 zGoddess.com
NSLC Support and Maintenance Completed 02/02/2009 12/15/2010 National Service-Learning Clearinghouse
Portland State University - Multi-department Syndication Service Completed 11/18/2008 01/29/2009 Portland State University
Portland State University - Multi-department CMS Development Completed 05/22/2008 01/29/2009 Portland State University
Oregon Health & Science University - Patient Care Simulation Training System Completed 05/16/2008 11/10/2008 OHSU - Oregon Health & Science University
Portland State University - Multi-department CMS Strategy Analysis Completed 02/18/2008 05/05/2008 Portland State University
Franz Bakery - Event Management System Completed 01/29/2008 02/05/2008 Franz Bakery
Jobdango - Complete System Redesign Completed 05/02/2007 05/10/2008 Jobdango
iTVX - Valuation Editor/Player Ver 4.0 Completed 02/02/2007 04/24/2007 iTVX
HSW Enterprises - Wright Track Intranet Completed 04/24/2006 08/15/2007 HSW Enterprises
Object-based Reference Service Design Completed 02/20/2006 03/15/2006 GamerGod.com
Flir - ECR Document Management Completed 08/08/2005 10/03/2005 Flir
Oregon Food Bank - Process and System Analysis Audit Completed 08/08/2005 02/08/2006 Oregon Food Bank
Oaktree Digital - Intranet Development Completed 07/15/2005 07/27/2005 Oaktree Digital
Oaktree Digital - Business Consulting Completed 06/14/2005 02/19/2006 Oaktree Digital
Portland Ad Federation - Website Redesign Completed 02/09/2005 04/28/2005 Portland Ad Federation
CMD - Media Search Service Completed 10/18/2004 11/26/2004 CMD
Intel - SuperCOM Event Management Completed 06/17/2004 09/23/2004 Intel
Intel - MSI Event Management Completed 04/01/2004 05/28/2004 Intel
Intel - ICG Event Management Completed 03/12/2004 03/30/2004 Intel