Abstract

A statistical database can be seen as a set of tables and a set of derivation functions; each function maps a set of tables into a new one. In order to optimize the time performance of the system it would be convenient to store the derived tables in secondary memory. However, a trade-off between storage resources and time performance arises: when the storage space is constrained, it is necessary to choose which derived tables have to be stored and which of them have to be computed on-line. In this paper such trade-off problem is investigated. We formulate it as an integer linear program, both for monadic and for polyadic derivation functions. In the first case we obtain a Simple Plant Location problem with a linear Knapsack constraint; in the second case the obtained program is equivalent to a Simple Plant Location problem with a submodular Knapsack constraint. Moreover we show that the problem is NP-complete and propose an efficient heuristic approach to solve it.

Talk to us

Join us for a 30 min session where you can share your feedback and ask us any queries you have

Schedule a call

Disclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.