Overview
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.
Exclusive to subscribers. 97% yet to be discovered!
Already subscribed? Log in!
KEYWORDS
database | embedded databases | Derby | database management
Embedded databases: interest and operation
On-board databases
Article included in this offer
"Software technologies and System architectures"
(
227 articles
)
Updated and enriched with articles validated by our scientific committees
A set of exclusive tools to complement the resources
Bibliography
Exclusive to subscribers. 97% yet to be discovered!
Already subscribed? Log in!
