文档下载 文档下载导航
设为首页 | 加入收藏
搜索 请输入内容:  
 导航当前位置: 文档下载 > 所有分类 > Challenges in embedded database system administration
侵权投诉

Challenges in embedded database system administration

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.

第1页

你可能喜欢

热门文档

相关文档

  • ...Database System Administration

    System & Database Admini... 暂无评价 27页 免费 Challenges in embedded d... Understanding and Validating Database System Administration F? bio Oliveira, ...

  • Design of Embedded Database System

    免费的全文外文数据库 2页 1财富值 Challenges in embedded d... 暂无评价 ... Design and Realization of a Tiny Embedded Database System Dong Jianjun, HE...

  • Real-time database system(Part I)

    Real-Time Database Systems and Data Services: Issues and Challenges Sang H....typically embedded in a large complex system ? dependability (reliability) ...

  • Database Management System

    DELite: Database Support for Embedded Lightweight Devices Krithi Ramamritham ...However, scaling down the database footprint poses challenges since these ...

  • PARITY ERROR DETECTION IN EMBEDDED SYSTEM

    6页 免费 Challenges in embedded d... 暂无评价 7页 免费喜欢此文档的还...Introduction During last ten years embedded systems has moved toward system-...

  • Graphics+Subsystem+in+an+Embedded+World

    Graphics+Subsystem+in+an+Embedded+World_信息与通信_工程科技_专业资料。... Gfx Layer Gfx Layer Gfx Layer Vid Layer + Vid Layer Main challenges ? ...

  • Optimizing Communication in embedded system cosimul...

    Challenges in embedded d... 暂无评价 7页 免费 PARITY ERROR DETECTIO...... Optimizing Communication in embedded system cosimulation The Pia hardware-...

  • ...+Processing+in+Microcontroller+Embedded+System

    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 ...

  • ch4开发工具方法及流程

    ? 2009 Design and Application Of Embedded System 29 Challenges in embedded ...Moving map obtains position from GPS, paints map from local database. ...

站点地图 | 文档上传 | 侵权投诉 | 手机版
本站所有资源均来自互联网,本站只负责收集和整理,均不承担任何法律责任,如有侵权等其它行为请联系我们.
文档下载 Copyright 2013 doc.guandang.net All Rights Reserved.  -  email