Database management/Data warehousing

By storing company data in databases, redundant data storage is reduced and program-independent access to data used across the company is enabled. Data warehousing ensures quality, integrity, and consistency of the underlying data. The term 'Data Warehouse' generally designates a database that is isolated from operational IT systems and serves as a company-wide data basis for all forms of management support systems. It is characterized by strict separation from operational and decision-supporting data and systems. The focus of the Data Warehouse concept is on efficient provision and processing of large amounts of data to perform evaluations and analyses in decision-relevant processes.

Task: Data structuring/Database design

The structure of databases is determined by the underlying data models.

ARIS support: The most widely used method of data modeling is the entity relationship model (ERM), which serves as the basis for the implementation of a relational database.

The tables and fields of a database system are described by the table diagram.

Object-oriented database systems can be designed using the Unified Modeling Language (UML). In UML, the class diagram can be used to show the static data relationships.

Task: Database management/Access management

Assignment of users and system administrators to database systems.

ARIS support: The access diagram can be used in conjunction with relations and system components to determine the access privileges that organizational units, positions, and persons have for the database system.