1

cache-load-store.emml

Cache initialization logic using <storeto/> and <loadfrom/> for subsequent RAQL queries.

2

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.

3

correlate2.emml

Correlation of Stock Closing price & Volume over 3-month Periods.

4

covariance.emml

Computes Covariance of 2 columns(Stock closing price, volume) for each stock symbol.

5

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.

6

datefmts.emml

Use of to_date(...) date conversion function

7

di-cache-stream.emml

Invokes REST service URL endpoint and stores data into a BigMemory declarative cache.

8

dom-cache.emml

Stores XML DOM in cache using <storeto/>; then retrieves this DOM from Cache using <loadfrom/> for querying using RAQL .

9

except.emml

Usage of RAQL except operator to find difference between 2 datasets

10

hierarchy-agg.emml

Chained RAQL queries to compute Monthly, Quarterly and Yearly Aggregations

11

intersect.emml

RAQL intersect operator to find intersection of 2 datasets

12

join-raql.emml

Various RAQL Join queries to illustrate Join of two Stream Sources; two DOM Sources; and a Stream Source with DOM source.

13

join2-raql.emml

RAQL Join cross diverse data formats - joins XML and CSV datasources.

RAQL Join on columns transformed using functions and cast functions.

14

joinBigMemory.emml

RAQL Joins 2 BigMemory cache sources; Also illustrates join between BigMemory and Stream/DOM sources.

15

kmeans1.emml

RAQL query for K-Means clustering using Euclidean and Manhattan measures

16

kmeans2.emml

RAQL K-Means centroids computation using Euclidean and SquaredEuclidean measures

17

legislators.emml

Diverse RAQL queries to illustrate usage of - select columns; limit results; distinct records; filter expressions; like search; group aggregations; order by.

18

linear_regression_1.emml

Use of RAQL Linear Regression analytic function

19

load-decl-cache.emml

Loads 'Legislators' sample data into cache; for subsequent analysis using assorted queries from query-decl-cache.emml

20

load-stocks-cache.emml

Loads 'Stocks' data into cache; for subsequent analysis using assorted queries from query-stock-cache.emml

21

math1.emml

Use of basic arithmetic operators in RAQL queries

22

mfgplants-cache.emml

Loads 'mfgPlants.csv' CSV dataset into cache; for subsequent analysis using query-mfgplants-cache.emml

23

mfgplants.emml

Various RAQL queries (Group by, Filter, Sub-query) on CSV dataset

24

mysql-raql.emml

Use of SQL with RAQL. SQL does base query and sends results to RAQL for windows aggregation.

25

parallel-query1.emml

ForEach parallel statement to perform RAQL queries in parallel and then combine results using <fuse/> statement

26

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.

27

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.

28

query-decl-cache.emml

see load-decl-cache.emml

29

query-mfgplants-cache.emml

see load-mfgplants-cache.emml

30

query-stocks-cache.emml

see load-stocks-cache.emml

31

schema2.emml

EMML In-line Schema definition for RAQL datasources

32

snapshot.emml

Query Presto Snapshot data using RAQL

33

snapshot2.emml

Use of alternate pattern to query Presto Snapshots using RAQL

34

stocks-group-avg.emml

Group avg aggregation of stocks by month, quarter, year

35

stocks-group-count.emml

Group count aggregation stocks by month, quarter , year

36

stocks-group-max.emml

Group max aggregation of stocks by month, quarter , year

37

stocks-group-min.emml

Group min aggregation of stocks by month, quarter , year

38

stocks-group-stddev.emml

Group stddev of stocks by month, quarter, year

39

stocks-group-sum.emml

Group sum aggregation by month, quarter, year

40

stocks-group-variance.emml

Group variance of stocks by month, quarter, year

41

stocks-price-chg.emml

Using RAQL chained queries compute min and max opening price change between weeks.

42

stocks-running-avg.emml

Running avg of stocks by month, quarter, year

43

stocks-running-count.emml

Running count by month, quarter, year

44

stocks-running-max.emml

Running max of stocks by month, quarter, year

45

stocks-running-min.emml

Running min of stocks by month, quarter, year

46

stocks-running-stddev.emml

Running stddev of stocks by month, quarter, year

47

stocks-running-sum.emml

Running sum of stocks by month, quarter, year

48

stocks-running-variance.emml

Running variance of stocks by month, quarter, year

49

subquery1.emml

RAQL query to calculate mean percentage chagne in stock volume over 5% between quarters; implemented using RAQL Sub Query

51

udf-sample.emml

RAQL query using User-defined Functions

52

union.emml

RAQL union operator illustrates combining datasets with following properties

53

window-functions-using-cache.emml

Query against BigMemory cache using Window functions - rank, dense_rank, lag, lead, first_value, last_value, row_number

54

window-functions.emml

Query against file datasource using Window functions - rank, dense_rank, lag, lead, first_value, last_value, row_number