User:Maabel/sandbox

SlamData

Developer(s)	SlamData Inc.
Initial release	2014 (2014)
Stable release	1.2.14 / 15 January 2015 (2015-01-15)
Operating system	Cross-platform
Available in	English
Type	Business Data Analytics
License	GNU AGPL v3.0
Website	slamdata.com

SlamData

SlamData is an open-sourced cross-platform business data analytics tool that allows for unrestricted ad-hoc SQL style operations on a document-oriented database, a type of NoSQL data system. The current version supports the open-sourced MongoDB database and is expected to support other document-oriented databases in future releases. Released under the GNU Affero General Public License, SlamSQL is free and open-source software.

SlamData's Graphical User Interface (GUI) allows unstructured data collections to be queried with both standard SQL and an extended SQL dialect referred to as SlamSQL. This dialect allows queries on nested, diverse and multidimensional aggregated data. SlamSQL was defined by the SlamData, Inc. developers as an extension to standard SQL to handle non flattened data. The SlamData also translates the SQL syntax into MongoDB data query plans.

SlamData uses a multistage optimization planner that will map complex queries to one or a combination of the three available MongoDB query mechanisms. These optimized plans are executed directly on the database relieving the client of any client-side post-processing.

Features

Some of the main features include:

SlamData Admin Console

The graphical User Interface (GUI) that allows SQL query string editing, compiling queries into MongoDB query plans, and result set viewing in a single window environment. This interface also has a file listing column. This version is implemented as a java virtual machine (JVM).

SlamSQL

An extended SQL Language created by SlamData, Inc. allowing for the querying of nested documents and arrays while maintaining backward compatibility with ANSI standard SQL.

SlamEngine

The back end software component that drives the SlamData application interpreting the SlamSQL. The SlamEngine processes the query strings to create instructions (query plans) that execute directly on the MongoDB server.

SQL Reference

Operators

Type	Operators
Arithmetic	+,-,*,/,%
Relational	=,<>,>=,<=,BETWEEN,IN,NOT IN
Boolean	AND,OR,NOT
Date/Time	TIMESTAMP, DATE, INTERVAL, TIME

Data Types

Types
NULL
Boolean
Integer
Decimal
DateTime
Array
Object
Set

Example

Test Data

> db.Books.find()
{ "_id" : ObjectId("54ef91c160e5052d098b4567"), "title" : "My Title One", "author" : "Bill W." }
{ "_id" : ObjectId("54ef91c160e5052d098b4568"), "title" : "My Title Two", "author" : "Chuck M." }
{ "_id" : ObjectId("54ef91c160e5052d098b4569"), "title" : "My Title Three", "author" : "Dave W." }
{ "_id" : ObjectId("54ef91c160e5052d098b456a"), "title" : "My Title Four", "author" : "Charles P." }
{ "_id" : ObjectId("54ef91c160e5052d098b456b"), "title" : "My Title Five", "author" : "Doug K." }

SlamData SQL Example

select *
  from "/Books"
  where author like '%C%'

SlamData Generated Query Plan Example

db.Books.aggregate(
  [
    { "$match": { "author": { "$regex": "^.*C.*$", "$options": "" } } },
    { "$out": "tmp.gen_0" }],
  { "allowDiskUse": true });
db.tmp.gen_0.find();

Version History

• Version 1.2 - Latest version with new User Interface which is scheduled to become the administration tool. Implemented as a JVM instead of a web based application and removed the Graphical analytic and notation tools.
• Version 1.1 - Web based front end with utilities to create SQL queries, data analysis charts, and notations for documentation purposes.
• Version 1.0 - Initial release of a web based front end utility for working with MongoDB database sources. Allowed SQL queries to be run against the data source without prior transformations on NoSQL data.

Licensing and support

• SlamData is available for free under the GNU Affero General Public License.
• Software support is available with or without a paid subscription from SlamData, Inc.

See also

• MongoDB
• SQL

External links

• Official website
• [1] an InfoWorld Review
• [2] a KDNuggets Review