A database management system comprising: • a multicore processor; • a memory; and • a database engine implemented as a code executed by the multicore processor, wherein the database engine is configured to: ∘ divide the memory into a shared memory and a partitioned memory, wherein the partitioned memory is a memory partitioned into a plurality of logical database partitions; ∘ map a different logical database partition among the plurality of logical database partitions to a different second processing unit among a plurality of second processing units; ∘ activate a cache coherency mechanism for the shared memory; ∘ disable the cache coherency mechanism for the partitioned memory; ∘ execute a plurality of transaction worker threads for managing transaction states and database indexes in the shared memory using the cache coherency mechanism; and ∘ execute a plurality of partition manager threads for handling a plurality of database access actions, submitted by the plurality of transaction worker threads, to access a database in the partitioned memory, the cache coherency mechanism being disabled in the partitioned memory, wherein the plurality of transaction worker threads and the plurality of partition manager threads are executed simultaneously on the multicore processor, wherein the multicore processor comprises: ∘ a plurality of first processing units operatively coupled to the shared memory, wherein each first processing unit among the plurality of first processing units is configured to execute a different transaction worker thread among the plurality of transaction worker threads; and ∘ the plurality of second processing units, wherein each second processing unit of the plurality of second processing units is operatively coupled to a different logical database partition among the plurality of logical database partitions and each respective second processing unit is configured to execute a different partition manager thread among the plurality of partition manager threads. • a multicore processor; • a memory; and • a database engine implemented as a code executed by the multicore processor, wherein the database engine is configured to: ∘ divide the memory into a shared memory and a partitioned memory, wherein the partitioned memory is a memory partitioned into a plurality of logical database partitions; ∘ map a different logical database partition among the plurality of logical database partitions to a different second processing unit among a plurality of second processing units; ∘ activate a cache coherency mechanism for the shared memory; ∘ disable the cache coherency mechanism for the partitioned memory; ∘ execute a plurality of transaction worker threads for managing transaction states and database indexes in the shared memory using the cache coherency mechanism; and ∘ execute a plurality of partition manager threads for handling a plurality of database access actions, submitted by the plurality of transaction worker threads, to access a database in the partitioned memory, the cache coherency mechanism being disabled in the partitioned memory, wherein the plurality of transaction worker threads and the plurality of partition manager threads are executed simultaneously on the multicore processor, wherein the multicore processor comprises: ∘ a plurality of first processing units operatively coupled to the shared memory, wherein each first processing unit among the plurality of first processing units is configured to execute a different transaction worker thread among the plurality of transaction worker threads; and ∘ the plurality of second processing units, wherein each second processing unit of the plurality of second processing units is operatively coupled to a different logical database partition among the plurality of logical database partitions and each respective second processing unit is configured to execute a different partition manager thread among the plurality of partition manager threads. ∘ divide the memory into a shared memory and a partitioned memory, wherein the partitioned memory is a memory partitioned into a plurality of logical database partitions; ∘ map a different logical database partition among the plurality of logical database partitions to a different second processing unit among a plurality of second processing units; ∘ activate a cache coherency mechanism for the shared memory; ∘ disable the cache coherency mechanism for the partitioned memory; ∘ execute a plurality of transaction worker threads for managing transaction states and database indexes in the shared memory using the cache coherency mechanism; and ∘ execute a plurality of partition manager threads for handling a plurality of database access actions, submitted by the plurality of transaction worker threads, to access a database in the partitioned memory, the cache coherency mechanism being disabled in the partitioned memory, ∘ a plurality of first processing units operatively coupled to the shared memory, wherein each first processing unit among the plurality of first processing units is configured to execute a different transaction worker thread among the plurality of transaction worker threads; and ∘ the plurality of second processing units, wherein each second processing unit of the plurality of second processing units is operatively coupled to a different logical database partition among the plurality of logical database partitions and each respective second processing unit is configured to execute a different partition manager thread among the plurality of partition manager threads.