Discussions Other Analytics Software

refers http://c.raqsoft.com/article/1687916213139 In addition to common static code, sometimes dynamic code is also needed to solve problems, such as generating code (or part of code) based on parameters and dynamically executing it. For... Lire la suite

Many small and micro applications also require certain data processing and computing abilities. Integrating a database will make the application too heavy. In this case, SQLite is a good choice for its simple framework, easy-integration, ability of storing data persistently and, it provides SQL... Lire la suite

In our daily work, we often need to query and analyze data files (such as csv/xls file), most of which have quite regular form (each row corresponds to one record) and can be regarded as a database table, and it will be relatively convenient to calculate such files in SQL. However, we often have... Lire la suite

This article is about applying SPL, explains various operations over big file, illustrates how to make the computation faster using parallel processing, and gives concise sample programs in esProc SPL. Structured text file processing, such as TXT and CSV files, is common data analysis work.... Lire la suite

Many scenarios need to use programming language to analyze and process the desktop data such as Excel and csv. In these scenarios, simple tasks include querying multiple files of same format through parameter, batch splitting or merging files, processing larger files, etc.; complex tasks include... Lire la suite

refer to http://c.raqsoft.com/article/1642763952755

I want to analyze J1939 CAN messages using CANalyzer. Should CANalyzer Pro be sufficient or I may need additional products?

In terms of structured data calculation outside the database, Stream has taken a step from scratch; Kotlin has slightly enhanced this capability, but the nature of the compiled language makes it impossible to go further; To really solve the problem of structured data computing outside the... Lire la suite

Many big data calculations are implemented in SQL. When running slowly, we have to optimize SQL, but we often encounter situations that we can do nothing about it. SPL maybe a better choice, refter to Lire la suite

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.... Lire la suite

esProc can be used for analytical databases and middleware. Its computing power and expression ability far exceed traditional SQL, and it is suitable for online query and offline batch running scenarios. Refer to Lire la suite

WebService/Restful is a multi-layer data format, and it is very difficult to process after fetching data. Compared with Java/C#, SQL, Python, Scala and other languages, SPL has stronger computing power on WebService/Restful, Lire la suite

SPL not only has a data structure suitable for expressing multi-layer JSON, but also simplifies complex multi-layer calculations, which is a capability that other JSON computing libraries do not have. Refer to Lire la suite

Share your experiences by opting for SAS model