Since the beginning of ERPs (1970), ERP systems based on database systems. All the industries which introduced ERP had to redesign there business processes. Now database systems radically improved as a consequence it makes possible to redesign business processes again.
I wrote my thesis at SAP HUNGARY Ltd. on the field of Supply Chain Management / Advanced Planner Optimizer / Demand Planning. I state that my thesis doesn’t contain any SAP internal, confidential information. That’s the reason why you can find random generated numbers on the charts, tables and why source code is not enclosed. I used only publicly available materials when I was writing my thesis.
My thesis can be logically divided into two parts. In the first one I will write about SAP HANA in-memory database system. I will list the SAP’s in-memory products in time order to see where HANA comes from (chapter 3). I will inspect database evolution (chapter 4), and hardware development in generally (chapter 5). Then I will go into details to see what’s under the hood, how can HANA reaches that incredible perfomance and to be a real-time platform for analytics and applications (chapter 6). I will outline HANA’s architecture, discuss how HANA is capable of fulfilling ACID requirements and why neither of them are violated, and how data is organized in the memory.