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.
Product and/or company-specific variations of the ERM are the SAP®-ERM for information modeling by SAP AG, the SeDaM (Semantic Data Model) as a notation by BASF AG, and the IEF data model (Information Engineering Facility) for data modeling of the CASE Tool by Texas Instruments Inc.
For a concrete description of logical data structures the relations diagram can be used, which is added to the data structures designed in the ERM.
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) or the Object Modeling Technique (OMT). In UML, the class diagram can be used to show the static data relationships, while the class description diagram enables an additional representation of attributes, objects, interfaces, etc.
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.