All
Articles 178,187Blog Posts 163,981Tech Tutorials 47,534Research Papers 34,920News 22,363
⚡ AI Lessons
Dev.to · Judy
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
SQLazy：Conditional Running Total with Reset
Problem Description Conditional running total with reset: restart accumulation when logic...
Dev.to · Judy
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
SQLazy: Querying the Start Timestamp of the Next Group from the Event Table
Problem description A table stores status values of an object at different timestamps, with one...
Dev.to · Judy
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
7mo ago
Lakehouse? More Like a Lake + Warehouse Parking Lot
From all-in-one machine, hyper-convergence, cloud computing to HTAP, we constantly try to combine...
Dev.to · Judy
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
8mo ago
Are Wide Tables Fast or Slow?
Wide tables are usually a standard component of the BI system. Many BI projects will first prepare...
Dev.to · Judy
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
8mo ago
Tired of ETL Bottlenecks? Build a Logical Data Warehouse with SPL
Logical DW (data warehouse) offers users the ability to logically integrate a variety of different...
Dev.to · Judy
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
9mo ago
Beyond SQL: Solving Data Warehouse Performance Bottlenecks with Smart Algorithms, Not Just Bigger Clusters
As the volume of data continues to grow and the complexity of business rises gradually, we are facing...
Dev.to · Judy
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
11mo ago
Understanding data mining and prediction in one article
What is data mining? People always want to be able to predict the future, such as...
Dev.to · Judy
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1y ago
Querying MongoDB：SPL Lightweight Multisource Mixed Computation Practices #4
There are also some other commonly seen data sources, including NoSQL, MQ, MongoDB and others, among...
Dev.to · Judy
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1y ago
Competition of data processing languages on JVM: Kotlin, Scala and SPL
The open-source data processing languages based on JVM mainly include Kotlin, Scala and SPL. This...
Dev.to · Judy
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1y ago
SPL assists MongoDB: Only keep the running total for the last item in the partition
The data of a collection (named grp_core) in the Mongdb database is as follows: [ { "grp": "A",...
Dev.to · Judy
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1y ago
SPL assists MongoDB: Grouping adjacent documents
The data of a collection (named states) in the MongoDB database is as follows: [ {order: 1,...
Dev.to · Judy
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1y ago
The Open-source SPL Boosts MongoDB Computing Ability
MongoDB is a typical NoSQL database. Its document-oriented structure makes both storage and access...
DeepCamp AI