ERP Architecture and HANA DB
ERP software and applications were primarily positioned to connect different sets of data across a business using a mainframe computer collecting transactional data through limited terminals.
Data processing had been the era of 1980s where IT infrastructure was focused on acquiring most of the data and utilization of the most meaningful data of it. The software were limited to accessing data without any processing power. The environment were not user-friendly and frameworks allowed limited access to the data. In the early 1990s, the concept of multi-layered architecture arrived which helped re-designing ERP frameworks in such a suitable manner where the input and output connections were easily integrated and processed whenever required. PCs became powerful to support good graphics and then client based ERP 3-Tier architecture was replaced by mainframe computers.
A new 3-tier concept technology on client-server is focused on revealing one database to many users by means of many applications. So, it is one system, one database methodology. All the data is stored in the designated database, processed in architecture layer on application servers and presented to user through a GUI front-end interface which is presentation layer. Depending on usage requirement the data service can be distributed to multiple service hosts. Smaller application although keep the database and application program in the same host, whereas the larger data are made to run and process through client-server channel. The connection for a client to a database through applications are called as instance. Thus, a client can have many instances.
An overview of client-server architecture is described below:
source: Client-Server Architecture
Evolution to new Database Management System – Data Mining
The traditional client-server methodology has given exposure to endless terminals making it possible to process data through a request mechanism, channeled from different instances to database. For each segment, the protocol is to fetch data from database, process and project them on presentation layer. Though the concept was easy and reliable but the data processing time was a concern. The advanced analytical applications require more active connection with database and thus entails more bandwidth.
HANA (High Performance Analytic Appliance) is purely developed and designed by SAP SE which signifies usage of in-memory database. The new technology computing database infrastructure combines OLTP (Online Transaction Processing) and OLAP (Online Analytical Processing) in single system making it OLTAP (Online Transaction and Analytical Processing).
In a simpler way, unlike traditional client-server methodology, HANA stores data in main memory (RAM) rather than disk providing faster...