Database Management Systems

In database terminology, a field holds a single type of data (like a column containing only names or only dates). A record contains multiple fields (a complete row), while files and reports are larger database structures.

Indecomposable data items that cannot be broken down further are called elementary items, atoms, or scalars depending on the programming context. All three terms refer to the same concept of basic, non-divisible data units.

A User's Guide is intended for end-users who need to know how to interact with the interface (Field Size, Data Type, Default Value). 'Data Structure' refers to the internal back-end organization of data, which is technical information relevant to developers, not users.

Informatica PowerCenter supports two primary data movement modes: Normal and Bulk. Normal mode logs every row, while Bulk mode bypasses the database log to increase performance during large data loads. 'Large' and 'Simple' are not standard technical terms for these modes.

In JCL, program checkpoints are stored using the SYSCHK DD statement. This allows checkpoints to be saved and later used for job restart in case of failure. The SYSCHK dataset contains the checkpoint data needed to resume processing from the last checkpoint.

ADO.NET Data Services (later renamed WCF Data Services) was the new data access framework introduced with .NET Framework 3.5 SP1. It provided a way to expose and consume data via RESTful services, building on the Entity Framework and enabling data access over HTTP. Note: ADO.NET Entity Framework (not listed) was also introduced in 3.5 SP1 as the ORM.

The PageStatePersister class is the base class that you inherit from to customize how ViewState is stored and loaded. By creating a custom class that derives from PageStatePersister and overriding the Save and Load methods, you can implement persistence to SQL Server or any other custom storage mechanism.

LINQ to ORACLE is not a standard LINQ provider provided by Microsoft. The built-in LINQ providers in .NET Framework 3.5 included LINQ to Objects (in-memory collections), LINQ to XML (XML documents), and LINQ to SQL (SQL Server databases). Third-party providers exist for Oracle, but they are not part of the core framework.

To import Excel 2007 (.xlsx) files in SSIS, you must use the Microsoft Office 12.0 Access Database Engine OLE DB Provider with the Extended Properties set to 'Excel 12.0' because the older Jet provider only supports up to Excel 2003.

Checkpoint restart in SSIS uses a checkpoint file to save execution state. The package can restart from the point of failure without re-executing completed tasks - both control flow and data flow tasks define these restart boundaries.

The Send Mail Task in SSIS only supports plain text emails. To send HTML-formatted emails, you must use a Script Task with .NET code to access System.Net.Mail and set IsBodyHtml=true.

IBM's Debug Tool does support debugging DB2 stored procedures. You can set breakpoints, step through code, inspect variables, and analyze the execution flow of stored procedures. This capability is available for DB2 on various platforms including mainframe (z/OS) and distributed systems.

v$locked_object is the Oracle dynamic performance view that shows detailed information about locked objects in the database, including the session ID, object ID, and lock mode. v$lock provides general lock information but not specific object details, while v$session shows session information without object locking details.

DB2 stored procedures can be debugged using the DB2 Debug Tool or similar debugging utilities. This allows developers to set breakpoints, step through code, inspect variables, and trace execution flow within stored procedures, making it easier to identify and fix logic errors.

Teradata uses the Primary Index (PI) to distribute data across AMPs. The PI value is hashed to determine which AMP will store each row. The Primary Key is a logical concept for uniqueness, while the PI is the physical distribution mechanism.