Overview
Français
ABSTRACT
This paper describes the foundations of embedded databases. Various and autonomous devices need light developments as well as self-managed applications for which the communication network cannot be always assured. The properties of embedded databases are: the portability that consists in using lightweight DBMS to facilitate its integration into an application the accessibility is local without using a network the administration is simplified. Secondly the paper details an example of embedded database named Derby. This is a relational DBMS developed with Java according to JDBC 4.
Read this article from a comprehensive knowledge base, updated and supplemented with articles reviewed by scientific committees.
Read the articleAUTHORS
-
Max CHEVALIER: Teacher-researcher in computer science - University of Toulouse – Institut de recherche en Informatique (IRIT – UMR 5505)
-
Karen PINEL-SAUVAGNAT: Teacher-researcher in computer science - University of Toulouse – Institut de recherche en Informatique (IRIT – UMR 5505)
-
Olivier TESTE: Teacher-researcher in computer science - University of Toulouse – Institut de recherche en Informatique (IRIT – UMR 5505)
INTRODUCTION
In recent years, the diversity of media and means that can be used to run DBMS (Database Management Systems) has overturned the traditional model of desktop workstations accessing a database server (DB). The widespread use of mobile devices (smart phones, tablets, etc.) is driving the need for lightweight development and autonomous applications that cannot be permanently connected. This has led to the emergence of so-called embedded databases (or DBMSs), which we present in this article.
We begin with a definition of embedded databases, then go on to describe their benefits and the fields of application in which they can be found. We then present an example of an embedded DBMS called Derby (JavaDB). We show that Derby, although small in size, fulfills the main objectives and functions classically attributed to DBMSs. Finally, using an example of a simplified car-park management application, we describe Derby's specific implementation features: Java programming using the JDBC standard, integration of stored sub-programs and triggers.
The Ultimate Scientific and Technical Reference
KEYWORDS
database | embedded databases | Derby | database management
This article is included in
Software technologies and System architectures
This offer includes:
Knowledge Base
Updated and enriched with articles validated by our scientific committees
Services
A set of exclusive tools to complement the resources
Practical Path
Operational and didactic, to guarantee the acquisition of transversal skills
Doc & Quiz
Interactive articles with quizzes, for constructive reading
Embedded databases: interest and operation
On-board databases
Bibliography
Websites
Webography as of July 22, 2013 [W1] http://wiki.apache.org/db-derby/DerbySQLroutines
[W2] http://docs.oracle.com/javase/1.5.0/docs/guide/jdbc/getstart/mapping.html
[W3]...
The Ultimate Scientific and Technical Reference
