Skip to content

GitLab

  • Projects
  • Groups
  • Snippets
  • Help
    • Loading...
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in
Trac
Trac
  • Project overview
    • Project overview
    • Details
    • Activity
  • Issues 246
    • Issues 246
    • List
    • Boards
    • Labels
    • Service Desk
    • Milestones
  • Operations
    • Operations
    • Metrics
    • Incidents
  • Analytics
    • Analytics
    • Value Stream
  • Wiki
    • Wiki
  • Members
    • Members
  • Collapse sidebar
  • Activity
  • Create a new issue
  • Issue Boards

GitLab is used only for code review, issue tracking and project management. Canonical locations for source code are still https://gitweb.torproject.org/ https://git.torproject.org/ and git-rw.torproject.org.

  • Legacy
  • TracTrac
  • Issues
  • #1630

Closed (moved)
Open
Opened Jul 01, 2010 by Karsten Loesing@karsten

Extend database schema by materialized views

The current database schema in ERNIE consists of tables and views. In order to support ad-hoc queries for dynamic graphs, we need to have materialized views plus a good concept to keep them updated. Update strategies range from (1) periodically re-generating the whole materialized views, (2) collecting changes on base tables and updating only those parts of materialized views that might have changed, and (3) triggering materialized view changes from table changes. While (1) is easiest to implement, it's infeasible for the amount of data in the database. (2) and (3) are harder to implement, but better fit the use case of having data covering multiple years in the database and adding data covering an hour or two. (2) is probably more efficient than (3), but even harder to implement. Kevin is working on this and might have results in July 2010.

To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information
Assignee
Assign to
None
Milestone
None
Assign milestone
Time tracking
None
Due date
None
Reference: legacy/trac#1630