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 Analytics | RAQL Samples
 
RAQL Samples
With theMashZone NextGeninstallation some additional samples are installed.
You can install the samples located in MashZoneNG-install/samples/emml/raql using the MashZoneNG-install/prestocli/bin/publish-mashups scripts. These scripts will install any of the samples located in MashZoneNG-install/samples/emml and its subfolders.
After installation, the samples are shown in the Mashup Editor under My Mashups and can be opened directly from there.
Sample name
Short Description
cache-load-store.emml
Cache initialization logic using <storeto/> and <loadfrom/> for subsequent RAQL queries.
correlate1.emml
RAQL query to correlate 2 column values (stock volume & closing price) grouped by months.
Uses group aggregation to get only summary values;
Uses windows aggregation to get summary values along-with record details.
correlate2.emml
Correlation of Stock Closing price & Volume over 3-month Periods.
covariance.emml
Computes Covariance of 2 columns(Stock closing price, volume) for each stock symbol.
cube-rollup.emml
Usage of ROLLUP, CUBE and GROUPING SETS to aggregate data on multiple levels
date-num-funcs.emml
Showcases Conversion and Locale-based Formatting functions :
Currency formatting, Number formatting, Percent formatting, Integer formatting with group separators, Data to/from Epoc conversions. Date Formatting.
datefmts.emml
Use of to_date(...) date conversion function
di-cache-stream.emml
Invokes REST service URL endpoint and stores data into a BigMemory declarative cache.
dom-cache.emml
Stores XML DOM in cache using <storeto/>; then retrieves this DOM from Cache using <loadfrom/> for querying using RAQL .
except.emml
Usage of RAQL except operator to find difference between 2 datasets
hierarchy-agg.emml
Chained RAQL queries to compute Monthly, Quarterly and Yearly Aggregations
intersect.emml
RAQL intersect operator to find intersection of 2 datasets
join-raql.emml
Various RAQL Join queries to illustrate Join of two Stream Sources; two DOM Sources; and a Stream Source with DOM source.
join2-raql.emml
RAQL Join cross diverse data formats - joins XML and CSV datasources.
RAQL Join on columns transformed using functions and cast functions.
joinBigMemory.emml
RAQL Joins 2 BigMemory cache sources; Also illustrates join between BigMemory and Stream/DOM sources.
kmeans1.emml
RAQL query for K-Means clustering using Euclidean and Manhattan measures
kmeans2.emml
RAQL K-Means centroids computation using Euclidean and SquaredEuclidean measures
legislators.emml
Diverse RAQL queries to illustrate usage of - select columns; limit results; distinct records; filter expressions; like search; group aggregations; order by.
linear_regression_1.emml
Use of RAQL Linear Regression analytic function
load-decl-cache.emml
Loads 'Legislators' sample data into cache; for subsequent analysis using assorted queries from query-decl-cache.emml
load-stocks-cache.emml
Loads 'Stocks' data into cache; for subsequent analysis using assorted queries from query-stock-cache.emml
math1.emml
Use of basic arithmetic operators in RAQL queries
mfgplants-cache.emml
Loads 'mfgPlants.csv' CSV dataset into cache; for subsequent analysis using query-mfgplants-cache.emml
mfgplants.emml
Various RAQL queries (Group by, Filter, Sub-query) on CSV dataset
mysql-raql.emml
Use of SQL with RAQL. SQL does base query and sends results to RAQL for windows aggregation.
percent-change-subquery.emml
RAQL query to calculate Volume Mean Percentage change over a certain threshold value, across each quarter. This is done using Sub Query.
percent-change.emml
RAQL query to calculate Volume Mean Percentage change over a certain threshold value, across each quarter. This is done using Chained Query.
query-decl-cache.emml
see load-decl-cache.emml
query-mfgplants-cache.emml
see load-mfgplants-cache.emml
query-stocks-cache.emml
see load-stocks-cache.emml
schema2.emml
EMML In-line Schema definition for RAQL datasources
snapshot.emml
QueryMashZone NextGenSnapshot data using RAQL
snapshot2.emml
Use of alternate pattern to queryMashZone NextGenSnapshots using RAQL
stocks-group-avg.emml
Group avg aggregation of stocks by month, quarter, year
stocks-group-count.emml
Group count aggregation stocks by month, quarter , year
stocks-group-max.emml
Group max aggregation of stocks by month, quarter , year
stocks-group-min.emml
Group min aggregation of stocks by month, quarter , year
stocks-group-stddev.emml
Group stddev of stocks by month, quarter, year
stocks-group-sum.emml
Group sum aggregation by month, quarter, year
stocks-group-variance.emml
Group variance of stocks by month, quarter, year
stocks-price-chg.emml
Using RAQL chained queries compute min and max opening price change between weeks.
stocks-running-avg.emml
Running avg of stocks by month, quarter, year
stocks-running-count.emml
Running count by month, quarter, year
stocks-running-max.emml
Running max of stocks by month, quarter, year
stocks-running-min.emml
Running min of stocks by month, quarter, year
stocks-running-stddev.emml
Running stddev of stocks by month, quarter, year
stocks-running-sum.emml
Running sum of stocks by month, quarter, year
stocks-running-variance.emml
Running variance of stocks by month, quarter, year
subquery1.emml
RAQL query to calculate mean percentage chagne in stock volume over 5% between quarters; implemented using RAQL Sub Query
udf-sample.emml
RAQL query using User-defined Functions
union.emml
RAQL union operator illustrates combining datasets with following properties
*2 stream sources
*2 DOM sources
*XML and CSV source formats
window-functions-using-cache.emml
Query against BigMemory cache using Window functions - rank, dense_rank, lag, lead, first_value, last_value, row_number
window-functions.emml
Query against file datasource using Window functions - rank, dense_rank, lag, lead, first_value, last_value, row_number

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