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">
