Abstract
In this chapter we describe the detailed physical and logical foundations of SanssouciDB. Simply running an existing database on a machine with a lot of main memory and a large number of cores will not achieve the speed-up we are seeking. To achieve our goal of giving business users information at their fingertips, we need to create a database that fully leverages these technological advantages. Chief among these are the efficient use of main memory, and the parallelization of tasks to take advantage of all the available cores. In addition to these physical considerations, we also use logical design to increase performance. We lay out data in a way that suits the operations being carried out on it and also minimize the amount of data that needs to be processed.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Notes
- 1.
In an inclusive caching hierarchy the data cached on the lower levels is included in the higher level caches, while in an exclusive hierarchy a certain cache line can is stored exactly in one cache level.
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2012 Springer-Verlag Berlin Heidelberg
About this chapter
Cite this chapter
Plattner, H., Zeier, A. (2012). The Technical Foundations of SanssouciDB. In: In-Memory Data Management. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-29575-1_4
Download citation
DOI: https://doi.org/10.1007/978-3-642-29575-1_4
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-29574-4
Online ISBN: 978-3-642-29575-1
eBook Packages: Business and EconomicsBusiness and Management (R0)