This paper discusses design concepts for a hybrid database system in a complex financial environment. A hybrid system is defined here as a database used simultaneously as an OLTP and an OLAP system. The challenge is meeting the divergent functional needs of OLTP (ODS) and a DWH system. The solution requires a process-oriented design, a pattern similar to object-oriented application systems and hybrid partitioning schemes. The development of ‘hybrid’ systems is constrained by existing product boundaries and technological limitations. Solution strategies that allow successful implementation of hybrid database systems aid cost control and rapid implementation timeframes—both of which are attractive to the IT market place. More