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 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.