RQLRAW Query Language

At the heart of our platform lies RQL. The result of more than 8 years of research, RQL a powerfully built and simple to use query engine, which exposes raw and operational data to the users through a novel and SQL like interface. It s implemented on top of a RAW's declarative query language that extends common SQL with support for complex and unstructured data. The RAW technology, which encompasses functional language processing, just-in-time code generation, real-time caching and adaptivity to user behavior is vertically integrated into a modern multitouch user interface. All constructs - from the user interface, to the algebra, to the code generation - are engineered jointly to provide the best performance and user experience.

Key Language Features

Query CSV, JSON, XML and other raw data directly

RAW queries data directly from source and in real-time, including popular file formats such as CSV, JSON, XML and machine logs. The data schema is inferred automatically by RAW and can be adjusted through queries. RAW builds, maintains and reuses caches of raw data autonomously and transparently to the user.

Support for Machine Logs

RAW includes native support for parsing semi-structured data. With a query, you can turn a sequence of entries in a log file into a sequence of records, which are then converted into efficient data formats. No scripts are needed.

Support for Complex Data

RAW data model goes beyond “tables” and fully supports complex data structures, including hierarchies and arrays. These data structures are first-class citizens in RAW and can be used seamlessly through RAW’s extended SQL language, allowing for complex transformations, including ETL tasks or advanced analytics.

Assignments

RAW’s extended SQL allows users to build complex queries in parts and use assignments freely. Users can preview partial results while building a query.

Modern Type System

RAW includes a modern type system with support for polymorphic functions. Users can build reusable code for processing data. Entire libraries of code can be built and shared between users of RAW..