Home > The one-million table partitions challenge in an ATLAS experiment DB application |
Talk | |||||||||||
Title | The one-million table partitions challenge in an ATLAS experiment DB application | ||||||||||
Video |
| ||||||||||
Author(s) | Dimitrov, Gancho (speaker) (CERN) | ||||||||||
Corporate author(s) | CERN. Geneva | ||||||||||
Imprint | 2019-05-10. - 0:09:32. | ||||||||||
Series | (IT Lightning Talks (ITLT)) (IT Lightning Talks: session #18) | ||||||||||
Lecture note | on 2019-05-10T10:19:00 | ||||||||||
Subject category | IT Lightning Talks (ITLT) | ||||||||||
Abstract | How can a new database system which manages billions of rows with relatively short lifetime (weeks to months) be designed ? The system should resemble a Whiteboard: - data, grouped by given properties form data collections, are added when requested - data collections are consumed by the requestor - when not needed any more, data collections are removed by a "Whiteboard sponge" process. I will show you what options I explored and which one is potentially the best in terms of efficiency. | ||||||||||
Copyright/License | © 2019-2024 CERN | ||||||||||
Submitted by | pedro.ferreira@cern.ch |