1 / 14

The τ - Synopses System

The τ - Synopses System. Yossi Matias Leon Portman Tel Aviv University. External Synopsis Host. Framework. External Synopsis Host. GUI. External Synopsis Host. Original Data. External Synopsis Host. τ -Synopses.

furman
Download Presentation

The τ - Synopses System

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. The τ- Synopses System Yossi Matias Leon Portman Tel Aviv University

  2. External Synopsis Host Framework External Synopsis Host GUI External Synopsis Host Original Data External Synopsis Host τ-Synopses • Provide a run-time environment for remote execution of pluggable synopses • Research platform for benchmarking and comparison

  3. Key features • Support for multiple synopses types • Pluggable integration • Remote execution • Managed synopses environment • Workload support • Reusable research platform • Approximate query processing

  4. Research Platform • Fast and easy integration • Native execution of synopses • Simple wrapper • No porting required • Readily available data sets and workloads • Predefined / Ad Hoc • Interactive comparison with other synopses • Many synopses available

  5. Datasets

  6. Workloads

  7. Benchmarks

  8. Integrated Synopses • Histograms • Equi-depth • Dynamic • Self-tuning • Samples • Random • ICICLES • Congressional • Wavelet Synopses • Basic • Adaptive • Probabilistic • Weighted • Your synopses here…

  9. External Synopsis Host Framework External Synopsis Host GUI External Synopsis Host Original Data External Synopsis Host System Design

  10. Main Operational processes Relational DB Build Synopses Framework User Query Update

  11. Synopsis Integration External Synopsis Host Framework Synopsis Proxy

  12. Integration Flow • Implement required interface • Build • Query • Update • Synopses Registration • External host address port • Run External Host on remote computer • Proxy will call methods of external synopsis

  13. Framework Technology • Relational databases • SQL Server, Oracle, ODBC, … • System written in C# • .NET Services • Remoting • Database integration • External synopses - in any language • Synopses on any SOAP enabled platform • Win32 fully supported • Wrappers for other platforms under development

  14. Future development • Support for native SQL queries over registered synopses • Synopses reconciliation • Other error metrics • Automatic workload and updates recording • Workload analysis

More Related