keynote

Materialize: a platform for building scalable event based systems

Author:

Frank McSherryAuthors Info & Claims

DEBS '22: Proceedings of the 16th ACM International Conference on Distributed and Event-Based Systems

Page 3

https://doi.org/10.1145/3524860.3544408

Published: 15 July 2022 Publication History

Get Access

Abstract

Materialize is a system that presents to users as SQL against continually changing data. It transforms inbound streams of ^*change data capture^* events into streams that exactly correspond to transformed data, and maintains indexed representations of the results for efficient access and operation. SQL over changing data is surprisingly (for me) expressive: Materialize can operate on unbounded data, implement data-driven windows, and perform event-based queries, all with ANSI standard SQL. We will discuss what an event-based SQL system looks like, SQL idioms that give rise to traditionally stream-exclusive behavior, and how one architects such a system to scale across multiple dimensions.

Materialize: a platform for building scalable event based systems
1. Information systems
  1. Data management systems
2. Theory of computation
  1. Theory and algorithms for application domains
    1. Database theory

Recommendations

Selection of Views to Materialize in a Data Warehouse

A data warehouse stores materialized views of data from one or more sources, with the purpose of efficiently implementing decision-support or OLAP queries. One of the most important decisions in designing a data warehouse is the selection of ...
A compression technique to materialize transitive closure

An important feature of database support for expert systems is the ability of the database to answer queries regarding the existence of a path from one node to another in the directed graph underlying some database relation. Given just the database ...
Selecting Subexpressions to Materialize for Dynamic Large-Scale Workloads
Big Data Analytics and Knowledge Discovery
Abstract
The nature of analytical queries executed either inside or outside of a DBMS increases the redundant computations due to the presence of common query sub-expressions. More recently, a few largely industry-led studies have focussed on the problem ...

Comments

Please enable JavaScript to view thecomments powered by Disqus.

Information & Contributors

Information

Published In

DEBS '22: Proceedings of the 16th ACM International Conference on Distributed and Event-Based Systems

June 2022

210 pages

ISBN:9781450393089

DOI:10.1145/3524860

General Chair:
Yongluan Zhou
University of Copenhagen, Denmark
,
Program Chairs:
Panos K. Chrysanthis
University of Pittsburgh
,
Vincenzo Gulisano
Chalmers University of Technology, Sweden

Permission to make digital or hard copies of part or all of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for third-party components of this work must be honored. For all other uses, contact the Owner/Author.

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 15 July 2022

Check for updates

Qualifiers

Keynote

Conference

DEBS '22

Sponsor:

DEBS '22: The 16th ACM International Conference on Distributed and Event-based Systems

June 27 - 30, 2022

Copenhagen, Denmark

Acceptance Rates

DEBS '22 Paper Acceptance Rate 10 of 19 submissions, 53%;

Overall Acceptance Rate 145 of 583 submissions, 25%

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

0
Total Citations
0
Total Downloads

Downloads (Last 12 months)0
Downloads (Last 6 weeks)0

Reflects downloads up to 20 Nov 2024

Other Metrics

View Author Metrics

Citations

View Options

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Recommendations

Selection of Views to Materialize in a Data Warehouse

A compression technique to materialize transitive closure

Selecting Subexpressions to Materialize for Dynamic Large-Scale Workloads