The Enterprise Data Real-Time Analysis System Based On In-Memory Database

Following the wave of today's Internet and mobile Internet technology development,enterprise information construction is becoming more and more deeply.The employee productivity is not only greatly improved,but also the enterprise application environment becomes more and more complex.At the same time the amount of business data is also constantly growing rapidly.The problem of enterprise is no longer how to store a large amount of data to show,but how to complete the processing of data and get the data value quickly.Big data era has come.A company produces massive amounts of data every day.It is difficult for old computer technology to deal with such an order of magnitude of the data.Along with the computer hardware development,the speed of data processing has been improved.And the bottleneck of data read is still there.An amount of data can be stored in memory by column storage method using in-memory database technology.So the data can be processed quickly with memory computing performance characteristics.Then the data is saved to the database,which greatly reduces the time of data exchange.Therefore the performance of the system is improved.So it is a trend to exploit the data value of an enterprise by leveraging the advantages of memory computing and memory database technology.Firstly,this paper is based on the actual projects and business needs of a multinational A company.Based on the research and analysis of the memory computing and memory database technology,this paper presents the design and implementation of an enterprise data real-time analysis and decision system based on HANA in-memory database.Secondly this article collates the business,functional and nonfunctional requirements of the system and creates the use case model.After that,this article designs the deployment and architecture according to system requirements.According to the business classification,the system is modularized.Considering high availability rule and disaster recovery capabilities,system replication solution is used for system deployment.Then according to different business scenarios and performance indicators,this article describes the logical function.Finally,this paper introduces the implementation process in two application examples,which meets the needs of different business people.After verifying the feasibility of the scheme,through the analysis of test run,the analysis system based on HANA memory database is about 40 times faster than the traditional system in the report data rate based on the new architecture.Thus the performance of the system based on the new architecture has been significantly improved.