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?
- 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
- 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
- SPL: The Professional Choice for Processing Multi-Layered JSON Data
- Is This a Refreshing Way to Understand Association?
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
Quantitative Strategy
- SPL quantitative practice series: backtesting routine
- SPL Quantitative Trading Practice Series: Turtle Trading Strategy
- SPL Quantitative Trading Practice Series: The MACD Trading Strategy
- SPL Quantitative Trading Practice Series: The KNN Trading Strategy
- SPL Quantitative Trading Practice Series: Linear Regression Strategy
- SPL Quantitative Trading Practice Series: Trend Trading Strategy
