About
esProc SPL is a pure Java developed software that can serve as a programming language for data analysis, a middleware for report data preparation, and an efficient big data computing engine.
Documentation: Scudata Community for Software Technologies
Source Code:https://github.com/SPLWare/esProc
What is esProc SPL？
For the data computing scenarios : Offline Batch Job , Online Query/Report
Databases that use SQL syntax and are applied to OLAP scenarios
Code Example
User Session Count
User behavior data table
A session is considered over if a user does not take any action within 10 minutes, or if they do not log in within 5 minutes after logging out. Calculate the number of sessions for each user.
esProc SPL
SQL
Python
......many more examples
The new technology is welcome to download and try!
esProc SPL is a pure Java developed software that can serve as a programming language for data analysis, a middleware for report data preparation, and an efficient big data computing engine.
Documentation: Scudata Community for Software Technologies
Source Code:https://github.com/SPLWare/esProc
What is esProc SPL？
- Data computing and processing language
- Run as an analysis database or middleware
- Computing and processing of structured and semi-structured data
- Offline batch job, online query
- neither SQL system nor NoSQL Technology
- Self created SPL syntax, more concise and efficient
For the data computing scenarios : Offline Batch Job , Online Query/Report
- Slow batch jobs can not fit in certain time window, being strained especially on critical summary dates
- Being forced to wait for minutes for a query/report, the business personnel becomes angry; Pre calculation is difficult to predict, and business personnel are not satisfied
- More concurrencies, longer the query time span, the database crashes
- Distributed clusters anywhere, consume huge hardware resources and have high operational complexity
- Database storage space is expensive and requires continuous expansion
Databases that use SQL syntax and are applied to OLAP scenarios
- Common database: MySQL, PostgreSQL, Oracle, DB2, …
- Data warehouse on Hadoop: Hive, Spark SQL, …
- Distributed data warehouse/MPP: …
- Cloud data warehouse: Snowflake, …
- All-in-one database machine: ExaData, …
- Python, Spark/Scala, Java, …
Code Example
User Session Count
User behavior data table
| U1059 | login | 2023-12-01 18:00:10 |
| U1092 | login | 2023-12-01 18:00:17 |
| U1069 | login | 2023-12-01 18:00:22 |
| … | … | … |
esProc SPL
SQL
Python
......many more examples
The new technology is welcome to download and try!