Category: 5 SPL Learning Material

Text handling is an integral and indispensable part of any programming language. SPL (Structured Process Language) provides abundant functions for handling text. There are four categories – character handling, simple string handling, sequence-related handling, and complex analysis.

After we retrieve data from the data source as a cursor in SPL, we can perform all SQL-style operations on the cursor, such as filtering, aggregation, inter-column calculations, sorting, grouping & aggregation, getting top-N & intra-group top-N, distinct, post-grouping distinct, and join to name a few.

After we retrieve data from the data source as a table sequence in SPL, we can perform all SQL-style operations, such as filtering, aggregation, inter-column calculations, sorting, grouping & aggregation, top-N, post-grouping top-N, distinct, post-grouping distinct, and join to name a few. In this essay, we take the file data source to explain how to achieve those operations on a SPL table sequence. 1.Filtering A filtering operation selects records that meet the specified condition (s) from a data table. Example: Get scores of students in class 10 from the following student scores table Students_scores.txt. The first row of the file

Structured data process is also needed in mobile apps. Android operating system supports JAVA, and this article introduces how to integrate SPL in Android apps for structured data calculation.7

Spring Cloud is an excellent framework for micorservices. Microservices can quickly be built based on Spring Cloud; esProc SPL (hereinafter referred to as SPL) is an excellent lightweight computing engine, complex data processing can be easily implemented based on SPL.

Though esProc is a powerful computing engine, it is not good at handling machine learning algorithms. Python, however, is excellent in doing that. So esProc offers the YM external library to call a Python program in an esProc SPL program. That’s smart.

SPL allows programmers to write their own functions to achieve specific functionalities. These user-defined functions, as the built-in ones, can be directly used in a SPL script after they are registered.

Besides the built-in functions, SPL allows programmers to call methods written in Java classes to deal with specific computations or to package certain computing processes.

esProc offers installation packages for Windows/Linux/Max and you can download the suitable one on the above webpage. An installation package encapsulates esProc IDE designer, data storage service, node service, HTTP service, ODBC service and HSQL sample databases.

esProc can write SQL queries directly on data files, as well as SPL scripts to support complex calculations. it provides an embedded JDBC driver to make it easy to return result to application. This article introduces the method of integrating SPL in Kettle through JDBC and different ways to retrieve data.