Serving database information using a flexible server in a three tier architecture
The D0 experiment at Fermilab relies on a central Oracle database for storing all detector calibration information. Access to this data is needed by hundreds of physics applications distributed worldwide. In order to meet the demands of these applications from scarce resources, we have created a distributed system that isolates the user applications from the database facilities. This system, known as the Database Application Network (DAN) operates as the middle tier in a three tier architecture. A DAN server employs a hierarchical caching scheme and database connection management facility that limits access to the database resource. The modular design allows for caching strategies and database access components to be determined by runtime configuration. To solve scalability problems, a proxy database component allows for DAN servers to be arranged in a hierarchy. Also included is an event based monitoring system that is currently being used to collect statistics for performance analysis and problem diagnosis. DAN servers are currently implemented as a Python multithreaded program using CORBA for network communications and interface specification. The requirement details, design, and implementation of DAN are discussed along with operational experience and future plans.
- Research Organization:
- Fermi National Accelerator Lab. (FNAL), Batavia, IL (United States)
- Sponsoring Organization:
- USDOE Office of Energy Research (ER) (US)
- DOE Contract Number:
- AC02-76CH03000
- OSTI ID:
- 812757
- Report Number(s):
- FERMILAB-Conf-03/204-E; TRN: US200316%%222
- Resource Relation:
- Conference: CHEP03, UCSD La Jolla, CA (US), 03/24/2003--03/28/2003; Other Information: PBD: 11 Aug 2003
- Country of Publication:
- United States
- Language:
- English
Similar Records
CORAL Server and CORAL Server Proxy: Scalable Access to Relational Databases from CORAL Applications
The SAMGrid database server component: its upgraded infrastructure and future development path