Introduction to database management system is explained in this article to provide more clarity on maintaining different SAP systems. Database is mandate for installing, running or maintaining SAP systems. There is no SAP system without a database. Data of entire SAP system is stored within a database. Database is a collection of data. A database management system DBMS is a piece of software designed to assist in maintaining and utilizing large amount of data. Need for this type of systems and their use is growing rapidly.
SAP systems can be installed using different types of RDBMS, such as Oracle, MS Sql server, DB2, Sybase, MaxDB and HANA. You can use any one of these RDBMS to install an SAP system. You have to learn any one of these database administration to maintain SAP systems easily. SAP provides its own tools to manage and maintain the underlying database. But it is better to through of administrating any one RDBMS to gain more grip over maintaining SAP systems. Usually, I use Oracle as database for installing SAP systems. So that, I will provide some important points about Oracle database system.
Oracle is a relational database management system (RDBMS)
- RDBMS manages large amount of data in a multi user environment
- With RDBMS, Many users can access the data concurrently
- RDBMS maintain relationship between data
- RDBMS provides secure access to the data using user authorization concept
- RDMBS helps to recover the data to most recent consistent status after a system failure
- RDBMS delivers high performance to process the data requests
Database administrator is only the user who connects with the database server in an SAP systems. Work processes of an SAP instance will typically perform the processing of application data. Work processes will act as database clients in the SAP systems.
If you want to learn more about maintaining SAP systems, You can watch my videos on SAP Basis/Netweaver administration from the sap basis videos page.