Différences

Ci-dessous, les différences entre deux révisions de la page.

--- informatique:sgbd [23/02/2011 18:45] – 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) ======
-Voir aussi [[/informatique/SQL|/informatique/SQL]]
+Voir aussi [[/informatique/SQL|/informatique/SQL]], [[/informatique/NoSql|/informatique/NoSql]],
+[[/informatique/GraphDB|/informatique/GraphDB]], [[/informatique/web_semantique|/informatique/web semantique]] (RDF)
 ===== SGBD Relationnels (SGBDR) =====
@@ Ligne 8: / Ligne 8: @@
 [[/informatique/sgbd/MySQL|MySQL]]
+==== DuckDB ====
+[[/informatique/sgbd/DuckDB|DuckDB]]
 ==== Oracle ====
@@ Ligne 18: / Ligne 23: @@
 [[http://www.postgresql.org]]
+==== 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://www.h2database.com/]]
+==== 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/server mode with the Derby Network Client JDBC driver and Derby Network Server.
+  * Derby is easy to install, deploy, and use.
+http://db.apache.org/derby
+==== 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://hsqldb.org/web/features200.html|list of new features]] in version 2.0.
+http://hsqldb.org/
+==== 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, high performance, and powerful language support for stored procedures and triggers. It has been used in production systems, under a variety of names, since 1981.
+The Firebird Project is a commercially independent project of C and C++ programmers, technical advisors and supporters developing and enhancing a multi-platform relational database management system based on the source code released by Inprise Corp (now known as Borland Software Corp) on 25 July, 2000.
+http://www.firebirdsql.org/
 ===== SGBD NoSQL =====
-  * [[http://www.developpez.net/forums/d773158/bases-donnees/decisions-sgbd/sgbd-mouvement-anti-sql-s-amplifie/#post4458431|SGBD : le mouvement anti-SQL s’amplifie ?]]
+voir aussi [[/informatique/nosql|/informatique/NoSql]]
-Google as inventé BigTable sur son Google File System (GFS) qui utilise le paradigme de [[http://labs.google.com/papers/mapreduce-osdi04.pdf|MapReduce (Simplified Data Processing on Large Clusters)]] pour gérer d'énormes quantités de données dans une infrastructure distribuée.
+==== Aerospike ====
-D'autres qui ont des problématiques similaires lui ont emboité le pas comme Facebook avec Cassandra, ...
+Aerospike is a distributed, scalable NoSQL database. It is architected with three key objectives:
-Et heureusement, le monde de l'open source (Apache) n'est pas en retard car il y a Hbase sur Hadoop (HDFS).
+  * To create a high-performance, scalable platform that would meet the needs of today's web-scale applications
+  * To provide the robustness and reliability (i.e., ACID) expected from traditional databases.
+  * To provide operational efficiency (minimal manual involvement)
+  * [[https://www.aerospike.com/products/product-matrix|product matrix]]
+  * [[https://github.com/aerospike/aerospike-server|source code]] @github
 ==== Cassandra ====
@@ Ligne 65: / Ligne 113: @@
 ==== CouchDB ====
+[[/informatique/sgdb/couchdb|/informatique/sgdb/couchdb]]
 CouchDB est un projet de l'ASF (Apache Software Foundation).\\
@@ Ligne 79: / Ligne 129: @@
     * An object-oriented database. Or more specifically, meant to function as a seamless persistence layer for an OO programming language.
-Voir:
+Le livre libre et en français: [[http://guide.couchdb.org/editions/1/fr/index.html]]
   * [[http://couchdb.apache.org/docs/intro.html|What CouchDB is]] sur le [[http://couchdb.apache.org/|site du projet]]
   * [[http://blog.developpez.com/julienpauli/p7864/dev-web-generaliste/vous-connaissez-couchdb/|Article par Julien Pauli]]
+Doc tech:
+  * [[http://wiki.apache.org/couchdb/HTTP_Document_API|HTTP Document API]]
 Le clip [[http://vimeo.com/11852209|I Use Couch DB]] de [[http://vimeo.co/user3158377|Couchio]] sur [[http://vimeo.com|Vimeo]] : \\
@@ Ligne 95: / Ligne 147: @@
 ';
 </php>
+D'autres clips : [[http://vimeo.com/13941628|CouchSpice — the Database YOUR Database Could Replicate Like]], [[http://vimeo.com/11062756|Couch DB Music Video]], [[http://vimeo.com/20499717|So You Wanna Learn About CouchDB ?]]
 ==== MongoDB ====
@@ Ligne 112: / Ligne 167: @@
 Articles:
   * [[http://www.phpclasses.org/blog/post/118-Developing-scalable-PHP-applications-using-MongoDB.html|Developing scalable PHP applications using MongoDB]]
+=== Tools ===
+http://robomongo.org {{http://robomongo.org/images/mac-main-screen.png?200}}
 <code php>
@@ Ligne 118: / Ligne 177: @@
   $collection = $db->people;
 </code>
+==== Redis ====
+https://redis.io/
+  * [https://redis.io/topics/benchmarks|How fast is Redis?]
+  * [https://www.percona.com/blog/2009/08/27/looking-at-redis/|Looking at Redis]