The Technical Foundations of SanssouciDB

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 lot 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 can 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. We also need to ensure that other considerations are taken into account, such as virtualization.