informatique:sgbd
Différences
Ci-dessous, les différences entre deux révisions de la page.
Les deux révisions précédentesRévision précédenteProchaine révision | Révision précédente | ||
informatique:sgbd [26/02/2011 09:05] – [H2 Database engine] cyrille | informatique:sgbd [18/11/2022 17:19] (Version actuelle) – DuckDB cyrille | ||
---|---|---|---|
Ligne 1: | Ligne 1: | ||
====== Système de gestion de base de données (SGBD) ====== | ====== Système de gestion de base de données (SGBD) ====== | ||
- | Voir aussi [[/ | + | Voir aussi [[/ |
+ | [[/ | ||
===== SGBD Relationnels (SGBDR) ===== | ===== SGBD Relationnels (SGBDR) ===== | ||
Ligne 8: | Ligne 8: | ||
[[/ | [[/ | ||
+ | |||
+ | |||
+ | ==== DuckDB ==== | ||
+ | |||
+ | [[/ | ||
==== Oracle ==== | ==== Oracle ==== | ||
Ligne 20: | Ligne 25: | ||
==== H2 Database engine ==== | ==== H2 Database engine ==== | ||
+ | |||
+ | H2, the Pure Java SQL database. The main features of H2 are: | ||
+ | * Very fast, open source, JDBC API | ||
+ | * Embedded and server modes; in-memory databases | ||
+ | * Browser based Console application | ||
+ | * Small footprint: around 1 MB jar file size | ||
[[http:// | [[http:// | ||
+ | |||
+ | ==== Derby ==== | ||
+ | |||
+ | Apache Derby, an Apache DB subproject, is an open source relational database implemented entirely in Java and available under the Apache License v2.0. Some key advantages include: | ||
+ | * Derby has a small footprint -- about 2.6 megabytes for the base engine and embedded JDBC driver. | ||
+ | * Derby is based on the Java, JDBC, and SQL standards. | ||
+ | * Derby provides an embedded JDBC driver that lets you embed Derby in any Java-based solution. | ||
+ | * Derby also supports the more familiar client/ | ||
+ | * Derby is easy to install, deploy, and use. | ||
+ | |||
+ | http:// | ||
+ | |||
+ | ==== HyperSQL (HSQLDB) ==== | ||
+ | |||
+ | Pure Java SQL database. | ||
+ | |||
+ | Version 2.0 supports the widest range of SQL Standard features seen in any open source database engine. We have reached SQL Standard conformance to almost full SQL-1992 Advanced Level and SQL:2008 core language features plus an extensive list of SQL:2008 optional features and many extensions. | ||
+ | |||
+ | Version 2.0 is fully multithreaded and supports high performance 2PL and MVCC transaction control models. See the [[http:// | ||
+ | |||
+ | http:// | ||
+ | |||
+ | ==== Firebird ==== | ||
+ | |||
+ | Firebird is a relational database offering many ANSI SQL standard features that runs on Linux, Windows, and a variety of Unix platforms. Firebird offers excellent concurrency, | ||
+ | |||
+ | The Firebird Project is a commercially independent project of C and C++ programmers, | ||
+ | |||
+ | http:// | ||
===== SGBD NoSQL ===== | ===== SGBD NoSQL ===== | ||
- | * [[http://www.developpez.net/forums/d773158/ | + | voir aussi [[/informatique/nosql|/informatique/NoSql]] |
- | Google as inventé BigTable sur son Google File System (GFS) qui utilise le paradigme de [[http:// | + | ==== Aerospike ==== |
- | D' | + | Aerospike is a distributed, scalable NoSQL database. It is architected with three key objectives: |
- | Et heureusement, le monde de l'open source | + | * To create a high-performance, scalable platform that would meet the needs of today's web-scale applications |
+ | * To provide the robustness and reliability | ||
+ | * To provide operational efficiency | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
==== Cassandra ==== | ==== Cassandra ==== | ||
Ligne 69: | Ligne 113: | ||
==== CouchDB ==== | ==== CouchDB ==== | ||
+ | |||
+ | [[/ | ||
CouchDB est un projet de l'ASF (Apache Software Foundation).\\ | CouchDB est un projet de l'ASF (Apache Software Foundation).\\ | ||
Ligne 83: | Ligne 129: | ||
* An object-oriented database. Or more specifically, | * An object-oriented database. Or more specifically, | ||
- | Voir: | + | Le livre libre et en français: [[http:// |
* [[http:// | * [[http:// | ||
* [[http:// | * [[http:// | ||
+ | Doc tech: | ||
+ | * [[http:// | ||
Le clip [[http:// | Le clip [[http:// | ||
Ligne 99: | Ligne 147: | ||
'; | '; | ||
</ | </ | ||
+ | |||
+ | D' | ||
+ | |||
==== MongoDB ==== | ==== MongoDB ==== | ||
Ligne 116: | Ligne 167: | ||
Articles: | Articles: | ||
* [[http:// | * [[http:// | ||
+ | |||
+ | === Tools === | ||
+ | |||
+ | http:// | ||
<code php> | <code php> | ||
Ligne 122: | Ligne 177: | ||
$collection = $db-> | $collection = $db-> | ||
</ | </ | ||
+ | |||
+ | ==== Redis ==== | ||
+ | |||
+ | https:// | ||
+ | |||
+ | * [https:// | ||
+ | * [https:// | ||
+ |
informatique/sgbd.1298707510.txt.gz · Dernière modification : 19/05/2012 00:15 (modification externe)