The Application Of In Memory Database In Business Intelligence

With the rapid development of information technology, business intelligence have been adopted widely in every business area, therefore the competition ofBI products amongthese companies gradually become intense. SAP company is the founder of ERP software, play the leader position of business intelligence for long time. BW considered as the priority for BI solution been widely integrated into ERP landscape. After SAP takeover Business Object, enhance the ability of integration of third party products. In2011, SAP launched a new database product:HANA in-memory column-base database, which is a breakthrough of the bid database technology and a revolution of information analysis technology.In the dissertation, it mainly discussed the DataMart which isbuild up by in-memory database, and consolidate with Business Object platform together to offer business a total solution for business intelligence demand. The dissertation begin from in-memory database architecture, discuss the in-memory database development and innovation history, explain and study the feature and advantage which in-memory been adopt in data warehouse and BI solution. And continue, the dissertation use real project as reference case, descript the detail steps of how to plan, installation, configuration, implement, development and optimization in-memory BI solution on top of Business Object platform. The dissertation also discuss the compatibility and scalability of this solution and the great user experience to business use from this solution.At the end of dissertation, we compare the in-memory BI solution with other product over the market, summarize the advantage and disadvantage of this solution. Provide the reference experience for the further research in this area.