Software AG Products 10.7 | Designing and Implementing Business Process Models | ARIS Method manual | Use cases | Database management/Data warehousing
 
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.