You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@ignite.apache.org by dm...@apache.org on 2017/08/23 23:38:43 UTC
svn commit: r1805978 - in /ignite/site/ignite-6036/use-cases/comparison:
ignite-for-nosql.html ignite-for-rdbms.html
Author: dmagda
Date: Wed Aug 23 23:38:43 2017
New Revision: 1805978
URL: http://svn.apache.org/viewvc?rev=1805978&view=rev
Log:
prepared ignite for RDBMS users page
Modified:
ignite/site/ignite-6036/use-cases/comparison/ignite-for-nosql.html
ignite/site/ignite-6036/use-cases/comparison/ignite-for-rdbms.html
Modified: ignite/site/ignite-6036/use-cases/comparison/ignite-for-nosql.html
URL: http://svn.apache.org/viewvc/ignite/site/ignite-6036/use-cases/comparison/ignite-for-nosql.html?rev=1805978&r1=1805977&r2=1805978&view=diff
==============================================================================
--- ignite/site/ignite-6036/use-cases/comparison/ignite-for-nosql.html (original)
+++ ignite/site/ignite-6036/use-cases/comparison/ignite-for-nosql.html Wed Aug 23 23:38:43 2017
@@ -36,7 +36,7 @@ under the License.
<link rel="canonical" href="https://ignite.apache.org/use-cases/comparison/ignite-for-nosql.html" />
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
- <title>Apache Ignite for NoSQL Users</title>
+ <title>Apache Ignite and NoSQL</title>
<link media="all" rel="stylesheet" href="/css/all.css?v=1.8">
<link href="https://netdna.bootstrapcdn.com/font-awesome/4.2.0/css/font-awesome.css" rel="stylesheet">
<link media="all" rel="stylesheet" href="/css/syntaxhighlighter.css">
@@ -52,54 +52,150 @@ under the License.
<main id="main" role="main" class="container">
<section id="sql-queries" class="page-section">
<h1 class="first">Ignite for NoSQL Users</h1>
- <div class="col-sm-12 col-md-12 col-xs-12" style="padding:0 0 20px 0;">
- <div class="col-sm-6 col-md-7 col-xs-12" style="padding-left:0;">
- <p>
- SQL is still considered to be a mainstream language for non trivial data processing. Nowadays,
- the language is no longer a prerogative of relational databases and being supported by
- databases and platforms of architectures different from the relational one.
- </p>
- <p>
- Apache Ignite's SQL level of support is so extensive that the platform is widely used as a
- full-fledged <b>SQL database</b>. Combining Ignite's SQL capabilities together with its
- distributed core you get a horizontally scalable, fault tolerant and always available SQL database.
- </p>
-
- <div class="page-heading">Performance and Durability</div>
- <p>
- Data sets as well as indexes can be stored both in memory and on disk thanks to the
- <a href="/features/durablememory.html" target="_blank">Durable Memory</a>
- architecture. This allows executing distributed SQL operations across different memory layers
- achieving in-memory performance with the durability of disk.
- If the <a href="/features/persistence.html" target="_blank">disk layer</a>
- is disabled Apache Ignite can be used as a pure distributed
- <a href="/use-cases/database/in-memory-database.html" target="_blank"><b>in-memory</b> database</a>.
- </p>
- </div>
- <div class="col-sm-6 col-md-5 col-xs-12" style="padding-right:0">
- <a href="/images/Main-Ignite-diagram_v2.png"><img class="img-responsive" src="/images/Main-Ignite-diagram_v2.png" width="500px" style="float:right;"/></a>
- </div>
+ <div style="padding:0 0 20px 0;">
+ <p>
+ Apache Ignite as many other NoSQL databases is horizontally scalable, highly available and
+ fault-tolerantdoes not require you as a skilled RDBMS user to learn new APIs if you want to
+ start working with an Ignite cluster. All the data processing and SQL schema definition can
+ be accomplished with a familiar SQL syntax. Ignite complies with SQL ANSI-99 standard supporting all
+ <b>SQL</b> and <b>DML</b> commands, including SELECT, UPDATE, INSERT, MERGE, DELETE statements and
+ distributed joins. It also provides support for a subset of <b>DDL</b> commands relevant for
+ distributed SQL databases.
+ </p>
+ <p>
+ Ignite can store data and indexes both in memory and on disk which allows executing distributed SQL
+ queries across different memory layers achieving the performance and scale of in-memory computing
+ together with the disk durability and strong consistency in one system. If the persistence is disabled
+ Ignite can act as a pure <a href="/use-cases/database/in-memory-database.html" target="_blank">
+ in-memory database</a>.
+ </p>
</div>
- <div class="page-heading">SQL ANSI-99 Compliance</div>
- <p>
- Ignite complies with SQL ANSI-99 standard supporting all <b>SQL</b> and <b>DML</b> commands,
- including SELECT, UPDATE, INSERT, MERGE, DELETE statements and distributed joins. It also provides
- support for a subset of <b>DDL</b> commands relevant for distributed SQL databases.
- </p>
+ <section id="comparison-matrix-section" class="page-section" style="border: none">
+ <table class="comparison-matrix" name="comparison-matrix">
+ <thead>
+ <tr><th>Feature</th><th>NoSQL</th><th>Ignite</th></tr>
+ </thead>
+ <tbody>
+ <tr>
+ <td>Scalability</td>
+ <td><span class="check-mark">✓</span> horizontal</td>
+ <td class="highlight-ignite-comparison"><span class="check-mark">✓</span> horizontal</b></td>
+ </tr>
+ <tr>
+ <td>Availability</td>
+ <td><span class="check-mark">✓</span> high</td>
+ <td class="highlight-ignite-comparison"><span class="check-mark">✓</span> high</b></td>
+ </tr>
+ <tr>
+ <td>Consistency</td>
+ <td><span class="cross-mark">✗</span> eventual</td>
+ <td class="highlight-ignite-comparison"><span class="check-mark">✓</span> strong</b></td>
+ </tr>
+ <tr>
+ <td>In-Memory</td>
+ <td><span class="cross-mark">✗</span></td>
+ <td class="highlight-ignite-comparison"><span class="check-mark">✓</span> in-memory store</b></td>
+ </tr>
+ <tr>
+ <td>Persistence</td>
+ <td><span class="check-mark">✓</span></td>
+ <td class="highlight-ignite-comparison"><span class="check-mark">✓</span></b></td>
+ </tr>
+ <tr>
+ <td>SQL</td>
+ <td><span class="cross-mark">✗</span></td>
+ <td class="highlight-ignite-comparison"><span class="check-mark">✓</span></b></td>
+ </tr>
+ <tr>
+ <td>Key-Value</td>
+ <td><span class="check-mark">✓</span></td>
+ <td class="highlight-ignite-comparison"><span class="check-mark">✓</span></b></td>
+ </tr>
+ <tr>
+ <td>Collocated Processing</td>
+ <td><span class="cross-mark">✗</span></td>
+ <td class="highlight-ignite-comparison"><span class="check-mark">✓</span></b></td>
+ </tr>
+ </tbody>
+ </table>
+
+ <table class="comparison-matrix-mobile" name="comparison-matrix-sm">
+ <thead>
+ <tr><th>Scalability</th></tr>
+ </thead>
+ <tbody>
+ <tr><td><span class="left">NoSQL</span><span class="right"><span class="check-mark">✓</span> horizontal</span></td></tr>
+ <tr class="ignite"><td><span class="left"><b>Ignite</b></span><span class="right"><span class="check-mark">✓</span> <b>horizontal</b></span></td></tr>
+ </tbody>
+ <thead>
+ <tr><th>Availability</th></tr>
+ </thead>
+ <tbody>
+ <tr><td><span class="left">NoSQL</span><span class="right"><span class="check-mark">✓</span> high</span></td></tr>
+ <tr class="ignite"><td><span class="left"><b>Ignite</b></span><span class="right"><span class="check-mark">✓</span> <b>high</b></span></td></tr>
+ </tbody>
+ <thead>
+ <tr><th>Consistency</th></tr>
+ </thead>
+ <tbody>
+ <tr><td><span class="left">NoSQL</span><span class="right"><span class="cross-mark">✗</span> eventual</span></td></tr>
+ <tr class="ignite"><td><span class="left"><b>Ignite</b></span><span class="right"><span class="check-mark">✓</span> <b>strong</b></span></td></tr>
+ </tbody>
+ <thead>
+ <tr><th>In-Memory</th></tr>
+ </thead>
+ <tbody>
+ <tr><td><span class="left">NoSQL</span><span class="right"><span class="cross-mark">✗</span></span></td></tr>
+ <tr class="ignite"><td><span class="left"><b>Ignite</b></span><span class="right"><span class="check-mark">✓</span> <b>in-memory store</b></span></td></tr>
+ </tbody>
+ <thead>
+ <tr><th>Persistence</th></tr>
+ </thead>
+ <tbody>
+ <tr><td><span class="left">NoSQL</span><span class="right"><span class="check-mark">✓</span></span></td></tr>
+ <tr class="ignite"><td><span class="left"><b>Ignite</b></span><span class="right"><span class="check-mark">✓</span></span></td></tr>
+ </tbody>
+ <thead>
+ <tr><th>SQL</th></tr>
+ </thead>
+ <tbody>
+ <tr><td><span class="left">NoSQL</span><span class="right"><span class="cross-mark">✗</span></span></td></tr>
+ <tr class="ignite"><td><span class="left"><b>Ignite</b></span><span class="right"><span class="check-mark">✓</span></span></td></tr>
+ </tbody>
+ <thead>
+ <tr><th>Key-Value</th></tr>
+ </thead>
+ <tbody>
+ <tr><td><span class="left">NoSQL</span><span class="right"><span class="check-mark">✓</span></span></td></tr>
+ <tr class="ignite"><td><span class="left"><b>Ignite</b></span><span class="right"><span class="check-mark">✓</span></span></td></tr>
+ </tbody>
+ <thead>
+ <tr><th>Collocated-Processing</th></tr>
+ </thead>
+ <tbody>
+ <tr><td><span class="left">NoSQL</span><span class="right"><span class="cross-mark">✗</span></span></td></tr>
+ <tr class="ignite"><td><span class="left"><b>Ignite</b></span><span class="right"><span class="check-mark">✓</span></span></td></tr>
+ </tbody>
+ </table>
+ </section>
- <div class="page-heading">Languages and Tools</div>
<p>
- You can interact with Apache Ignite using the SQL language via natively developed APIs for Java,
- .NET and C++, or via the Ignite <b>JDBC</b> or <b>ODBC</b> drivers. This provides a true
- cross-platform connectivity from an endless number of SQL tools and programming languages.
+ The main difference between Ignite and traditional relational databases is that, first, the memory is
+ treated as a fully functional storage, not just as a caching layer, like most databases do. Second,
+ Ignite is horizontally scalable, highly available and supports both
+ <a href="/features/datagrid.html" target="_blank">key-value</a> APIs and
+ <a href="/collocatedprocessing.html" target="_blank">collocated processing</a> approach.
</p>
+
<p>
Check <a href="/features/sql.html" target="_blank">SQL</a> section for more details or start using
Ignite as a SQL database referring to
- <a href="https://apacheignite.readme.io/docs/getting-started-sql" target="_blank">SQL Getting Started Guide</a>
+ <a href="https://apacheignite.readme.io/docs/getting-started-sql" target="_blank">SQL Getting Started Guide</a>.
+ In addition, learn how Ignite is used for <a href="/use-cases/caching/database-caching.html" target="_blank">
+ relational databases acceleration</a>.
</p>
</section>
</main>
Modified: ignite/site/ignite-6036/use-cases/comparison/ignite-for-rdbms.html
URL: http://svn.apache.org/viewvc/ignite/site/ignite-6036/use-cases/comparison/ignite-for-rdbms.html?rev=1805978&r1=1805977&r2=1805978&view=diff
==============================================================================
--- ignite/site/ignite-6036/use-cases/comparison/ignite-for-rdbms.html (original)
+++ ignite/site/ignite-6036/use-cases/comparison/ignite-for-rdbms.html Wed Aug 23 23:38:43 2017
@@ -36,7 +36,7 @@ under the License.
<link rel="canonical" href="https://ignite.apache.org/use-cases/comparison/ignite-for-rdbms.html" />
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
- <title>Apache Ignite for RDBMS Users</title>
+ <title>Ignite for RDBMS Users</title>
<link media="all" rel="stylesheet" href="/css/all.css?v=1.8">
<link href="https://netdna.bootstrapcdn.com/font-awesome/4.2.0/css/font-awesome.css" rel="stylesheet">
<link media="all" rel="stylesheet" href="/css/syntaxhighlighter.css">