RaqForum 25 No.
1,635 View  • 
     ...

1 esProc SPL&Code

 

SPL Understanding

Low Code Written in the Grid
A programming language coding in a grid
What to use for data analysis programming, SQL, Python, or esProc SPL?

This Is Probably the Most Interactive Data Analysis Programming
This is probably the most user-friendly programming for Excel data analysts

This Is Probably the Most Perfect Programming for Solving SQL Data Analysis Pain Points
Using SQL for data analysis seems to be a false proposition
SPL: a database language featuring easy writing and fast running
Why a SQL Statement Often Consists of Hundreds of Lines, Measured by KBs？
What can we do while facing the huge difficulty of writing too long, multiple-level nested SQL codes?

Is SPL more difficult or easier than SQL?
Can SPL and SQL be integrated?

Competition of data processing languages on JVM: Kotlin, Scala and SPL
Java or SQL, which is faster for data operation?
Using Java/Python in place of stored procedure for batch jobs?
Two major shortcomings of Python in enterprise applications
The impasse of SQL performance optimizing
What should we do when SQL (and stored procedure) runs too slowly?

Technical Discussion

A Universal File Format N Times Faster Than CSV
This Is Probably the Most Lightweight Columnar Storage Technology

esProc SPL’s Grouping Operations: The Most Powerful in History, Bar None
Farewell to Window Functions, Embrace esProc SPL
Unconventional Yet Common Aggregation Operations
Distinctive Positional Operations
The Implicit Lambda Syntax
Essential Adjacent References

Code Example

Calculate prime number table within 10000 using screening method
Calculate the first N terms of the Fibonacci sequence
Simulate random card issuance
Find the cycle section for infinite cyclic decimals
Count the occurrence rate of words
Simulating Multiple-Layer Loop to Solve Logical Problems
Perpetual Calendar
Eight Queens
24 Point Game

Conventional operations of esProc SPL on structured text files
esProc uses simple SQL queries on structured text files

List the management structure tree
Barcode Inspection and Verification (# 60)
Postage calculation
Marriage matching
The top N customers who accounted for half of the sales that year
Stocks that have risen by 9.5% for three consecutive days
Families with sum of ages of a couple over 70 years old
Employees who have accumulated more than 5 years of work experience in New York
The product with the longest cumulative stockout time in the supermarket within a month
The average dwell time of a certain type of product in the supermarket
The salesperson with the highest sales during the promotion period
Average account balance of customers who have ordered all products and other customers
Employees who have taken leave for more than two days three times consecutively a year
Prepare test data for the sales management system
Display the Olympic gold medal table
Calculate the salary to be paid based on attendance and performance information
Empty seats
Calculation of customer growth rate under renewal mode

Variable Correlation Analysis: Pearson and Spearman
10 lines of code to achieve handwritten digit recognition

 
 •  1,635 View  •