Database configuration and maintenance have historically been complex tasks, often requiring expert knowledge of database design and application behavior. In an embedded environment, it is not possible to require such expertise or to perform ongoing databa
Challenges in Embedded Database System Administration
Margo I. Seltzer, Harvard UniversityMichael A. Olson, Sleepycat Software
Database con guration and maintenance have histori-cally been complex tasks, often requiring expert knowl-edge of database design and application behavior. In anembedded environment, it is not possible to require suchexpertise or to perform ongoing database maintenance.This paper discusses the database administration chal-lenges posed by embedded systems and describes howSleepycat Software’s Berkeley DB architectureaddresses these challenges.
1Introduction
Embedded systems provide a combination of opportuni-ties and challenges in application and system con gura-tion and management. As an embedded system is mostoften dedicated to a single application or small set ofcooperating tasks, the operating conditions of the sys-tem are typically better understood than those of gen-eral-purpose computing environments. Similarly, asembedded systems are dedicated to a small set of tasks,one expects that the software to manage them would besmall and simple. On the other hand, once an embeddedsystem is deployed, it must continue to function withoutinterruption and without administrator intervention.
Database administration has two components,initial con guration and ongoing maintenance. Initialcon guration includes database design, manifestation,and tuning. The instantiation of the design includesdecomposing the data into tables, relations, or objectsand designating proper indices and theirimplementations (e.g., B-trees, hash tables, etc.). Tuningthe design requires selecting a location for the log anddata les, selecting appropriate database page sizes,specifying the size of in-memory caches, anddetermining the practical limits of multi-threading andconcurrency. As we expect that an embedded system iscreated by experienced and knowledgeable engineers,requiring expertise during the initial systemcon guration process is acceptable, and we focus ourefforts on the ongoing maintenance of the system. Inthis way, our emphasis differs from other projects thatfocus on automating database design, such asMicrosoft’s AutoAdmin project [3]and the “no-knobs”administration that is identi ed as an area of importantfuture research by the Asilomar authors [1].
In this paper, we focus on what the authors of theAsilomar report call “gizmo” databases [1], databasesthat reside in devices such as smart cards, toasters, ortelephones. The key characteristics of these databasesare that their functionality must be completelytransparent to users, no explicit database operations ordatabase maintenance is ever performed, the databasemay crash at any time and must recover instantly, thedevice may undergo a hard reset at any time (requiringthat the database return to its initial state), and thesemantic integrity of the database must be maintained atall times. In Section 2, we provide more detail on thesorts of tasks typically performed by databaseadministrators (DBAs) that must be automated in anembedded system.
The rest of this paper is structured as follows. InSection 2, we outline the requirements for embeddeddatabase support. In Section 3, we discuss how BerkeleyDB is conducive to the hands-off management requiredin embedded systems. In Section 4, we discuss novelfeatures that enhance Berkeley DB’s suitability for theembedded applications. In Section 5, we discuss issuesof footprint size. In Section 6, we discuss related work,and we conclude in Section 7.
2Embedded Database Requirements
Historically, much of the commercial database industryhas been driven by the requirements of high perfor-mance online transaction processing (OLTP), complexquery processing, and the industry standard benchmarksthat have emerged (e.g., TPC-C [9], TPC-D [10]) toallow for system comparisons. As embedded systemstypically perform fairly simple queries and only rarelyrequire high, sustained transaction rates, such metricsare not nearly as relevant for embedded database sys-tems as are ease of maintenance, robustness, and a smallmemory and disk footprint. Because of continuouslyfalling hardware prices, robustness and ease of mainte-nance are the key issues of these three requirements.Fortunately, robustness and ease of maintenance are sideeffects of simplicity and good design. These, in turn,lead to a small size, contributing to the third requirementof an embedded database system.
System & Database Admini... 暂无评价 27页 免费 Challenges in embedded d... Understanding and Validating Database System Administration F? bio Oliveira, ...
免费的全文外文数据库 2页 1财富值 Challenges in embedded d... 暂无评价 ... Design and Realization of a Tiny Embedded Database System Dong Jianjun, HE...
Real-Time Database Systems and Data Services: Issues and Challenges Sang H....typically embedded in a large complex system ? dependability (reliability) ...
DELite: Database Support for Embedded Lightweight Devices Krithi Ramamritham ...However, scaling down the database footprint poses challenges since these ...
6页 免费 Challenges in embedded d... 暂无评价 7页 免费喜欢此文档的还...Introduction During last ten years embedded systems has moved toward system-...
Graphics+Subsystem+in+an+Embedded+World_信息与通信_工程科技_专业资料。... Gfx Layer Gfx Layer Gfx Layer Vid Layer + Vid Layer Main challenges ? ...
Challenges in embedded d... 暂无评价 7页 免费 PARITY ERROR DETECTIO...... Optimizing Communication in embedded system cosimulation The Pia hardware-...
the+Multirate+Analog-to-digital+Processing+in+Microcontroller+Embedded+System...Challenges during Analog—to—digital Multirate Processing Design Eicfient design...
This paper describes the concept of embedded mobile database and several key technologies in embedded database system. Then puts the mobile database ...
? 2009 Design and Application Of Embedded System 29 Challenges in embedded ...Moving map obtains position from GPS, paints map from local database. ...
热门文档