Database Management Systems

A consolidated data mart is a second-level data mart that aggregates and combines data from multiple first-level (atomic) data marts. First-level marts contain detailed transactional data, while second-level (consolidated) marts provide summarized, cross-functional views for reporting and analysis.

In data warehousing, 'stovepipe' data marts refer to isolated, non-integrated systems that do not share common dimensions (conformed dimensions), leading to fragmented and siloed data.

A centipede fact table refers to a fact table with an excessive number of dimensions (often 15+), which makes it difficult to manage and query efficiently. This pattern is considered an anti-pattern in dimensional modeling because it violates the principle of keeping fact tables focused on specific business processes. The name 'centipede' metaphorically describes the table having 'too many legs' (dimensions).

A degenerate dimension is a dimension key (like an invoice or transaction number) that is stored directly in the fact table without joining to a separate dimension table, meaning it has no attributes of its own.

This is a duplicate of question 134480 with reordered options. A consolidated data mart is a second-level data mart that aggregates and combines data from multiple first-level (atomic) data marts, providing summarized, cross-functional views for reporting and analysis.

In data warehousing, a 'stovepipe' refers to isolated data marts that are developed independently without conforming to enterprise standards. These stovepipe systems cannot easily share or integrate data with other parts of the organization, creating information silos. The term comes from the analogy of separate stove pipes that don't connect.

A core purpose of data warehousing is the ETL (Extract, Transform, Load) process that cleanses source data by removing errors, handling missing values, standardizing formats, and applying business rules. The data warehouse stores this cleaned, consistent, integrated data - this is a fundamental differentiator from operational systems that may contain dirty, inconsistent data.

ADABAS is a high-performance database management system. The name ADABAS is an acronym for Adaptable DAta BAse System, reflecting its flexible architecture designed for efficient data processing.

ADABAS uses the Inverted List Model for data storage and retrieval. This model uses inverted indexes to provide fast access to data through multiple keys, which is a key architectural feature of ADABAS.

System crashes cause automatic rollback of uncommitted transactions to maintain database ACID properties. The UNDO logs are used to reverse any uncommitted changes. Normal SQL commands like GRANT, ALTER, or EXIT do not trigger rollbacks.

Full-table scans on large tables read every row, which is expensive. Identifying these scans is critical because they can often be optimized by creating or using appropriate indexes. Indexes allow the database to read only relevant rows instead of scanning the entire table.

In SAP ABAP Dictionary, the 'Data Browser/Table View Maintenance' setting (such as 'Display/Maintenance Allowed') regulates whether and how users can view, edit, or maintain the table's records using tools like SE16 or SM30.

IDMS (Integrated Database Management System) is a Network Model database. The Network model allows many-to-many relationships between records through set relationships, unlike the Hierarchical model (tree structure) or Relational model (tabular structure with foreign keys).

IDMS stands for Integrated Database Management System (or Integrated Data Management System). Option A contains the correct expansion despite a minor spelling error where 'Intergrated' should be 'Integrated'. The other options (B, C, D) represent incorrect expansions.

In DB2, you can change a user's password during connection using the syntax: CONNECT TO database USER username USING old_password NEW new_password CONFIRM new_password. This verifies and updates the password in the operating system or external security manager.