You Need a Better Lambda Architecture
A Lambda Architecture is a hybrid, scale-out data platform that can process operational OLTP workloads and analytical OLAP workloads concurrently. It is usually built from components such as HDFS, Hive, Spark, Kafka, Hbase, Cassandra, Impala and/or Druid to support applications. Though effective, these systems are complex to integrate and maintain and they leave much of the data synchronization and consistency tasks to the application programmer.
As we like to say “It takes a lot of duct tape to keep a Lambda Architecture going.”
Why Choose Splice Machine for Your Lambda Architecture
Splice Machine offers a better solution to the complexity of Lambda Architectures. We call it “Lambda-in-a-Box.” With the new scale-out RDBMS systems, you get all the benefits of Lambda with a much simpler architecture and it adds full SQL support for both transactional (OLTP) and analytical (OLAP) applications.
Batch File Ingestion – Imports of raw data files are directly inserted into sharded tables in parallel with indexes that are atomically updated with the data for fast access
Real-time Stream Ingestion – Stored procedures continuously ingest streams with standard SQL and auto-shards
Data Cleansing – Use standard SQL, with constraints and triggers, to clean up small subsets of data as well as entire data sets efficiently, without big batch runs or file explosions
Feature Engineering and Extensive ETL – Execute complex aggregations, joins, sorts, and groupings with efficient SQL that is automatically parallelized and optimized without writing code at the application level
Model Training – Stored procedures execute analytics directly on the data, for example, using built-in functions like ResultSetToRDD that take SQL results and treat them as Spark RDDs or execute R and Python libraries directly on database result sets.
Application Logic – ACID semantics enable the architecture to power concurrent CRUD applications without additional moving parts
Model Execution – Stored procedures and user-defined functions wrap models
Reporting and Data Visualization – Use Tableau, Domo, MicroStrategy and other ODBC/JDBC compliant tools turnkey