New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

data ware house optimization for main query types #292

Open

3 tasks

ZhenyuZhu-Caltrans opened this issue Jul 12, 2024 · 2 comments

Open

3 tasks

data ware house optimization for main query types #292

ZhenyuZhu-Caltrans opened this issue Jul 12, 2024 · 2 comments

Assignees

Milestone

VDS Data Modeling...

ZhenyuZhu-Caltrans commented Jul 12, 2024 •

edited by jkarpen

Loading

Duplicate the final data sets and optimize each data set toward major query types:

query that aggregate data over geographic domain: District, Route, County
query that aggregate data over time domain: Year, Month, Day, Hour, Minute
query that aggregate data over geographic domain: geofencing .

Contributor

pingpingxiu-DOT-ca-gov commented Jul 16, 2024

@pingpingxiu-DOT-ca-gov

pingpingxiu-DOT-ca-gov self-assigned this

jkarpen added this to the VDS Data Modeling: Performance Optimization milestone

jkarpen commented Sep 12, 2024

This is lower priority than the pipeline feature improvement tasks so keeping in the backlog for now.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment