Integrate Software AG Products Using Digital Event Services 10.4 | Integrate Software AG Products Using Digital Event Services | MashZone NextGen Help | Appendix | Legacy Presto components | MashZone NextGen APIs, Specifications and Extension Points | Real-Time Analytics Query Language
 
Real-Time Analytics Query Language
The Real-Time Analytics Query Language (RAQL) is an easy-to-learn, SQL-like language to query and analyze large, streaming datasets. Users access datasets in mashups using EMML extension statements that leverage RAQL.
RAQL gives you direct, streaming access to data:
*In files, without registering them as MashZone NextGen mashables.
*In databases or from URL-addressable services.
*In any number of snapshots for MashZone NextGen mashables or mashups.
*Stored in the MashZone NextGen Analytics In-Memory Stores.
Extension statements in EMML also let you store large datasets or query results in the MashZone NextGen Analytics In-Memory Stores.
You can also use RAQL with results for any MashZone NextGen mashable or mashup.
RAQL works with data in CSV, XML or JDBC result formats. Data should be in a flat hierarchy, with simple columns and rows. RAQL queries can:
*Filter dataset columns and rows using simple or complex criteria.
*Sort data with any number of levels.
*Group data in groups, partitions or windows and analytic functions to these sets.
*Use subqueries and many other common SQL features to handle complex requirements.
*Use the plain and analytic functions that are built into MashZone NextGen plus any extensions that user define.
RAQL Extensions: User-Defined Functions
In addition to the RAQL functions built into MashZone NextGen, you can define additional functions to use in RAQL queries to handle unique or domain-specific needs. User-defined functions can be plain functions. Or they can be aggregate or window analytic functions that use the MashZone NextGen RAQL User-Defined Function API.
You add user-defined functions in libraries with library names that you assign. This allows you to manage functions and ensure that function names are unique.

Copyright © 2019 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.
Innovation Release