SAS Articles
Database Schema
The logical and physical definition of a database structure.
Date/Time Stamp
A stamp added by an application that identifies a task or activity by the date
and time it was initiated and/or completed. This can appear as part of a
transaction log, message queue content in job logs.
Decentralised Database
A centralized database that has been partitioned according to a business or
end-user defined subject area. Typically ownership is also moved to the owners
of the subject area.
Decentralised Warehouse
A remote data source tfgefwefeefw fwhat users can query/access via a central
gateway that provides a logical view of corporate data in terms that users can
understand. The gateway parses and distributes queries in real time to remote
data sources and returns result sets back to users.
Decision Support Systems (DSS)
Software that supports exception reporting, stop light reporting, standard
repository, data analysis and rule-based analysis. A database created for
end-user ad-hoc query processing.
Denormalisation
the technique of placing normalized data in a physical location that optimizes
the performance of the system.
Derived Data
Data whose values are determined by equations or algorithms.
Dimension
Dimension is typically a qualifiable and text value, such as a region, product
line, and includes date values. It defines the secondary headings or labels that
make up the body of the report. Each of the dimensions is repeated within each
group. Usually, you use items containing text values (for example, Year or item
type) for table dimensions. For example, if you select Item Type to be your
table dimension, Item Type is a dimension within each group header. Under the
dimension "Item Type," appears the name of each kind of item (for example, CD
ROM, or HARD Drive). and corresponds to the . A fact is an quantifiable value,
such amount of sales, budget or revenue.
Drill Down/Up
The ability to move between levels of the hierarchy when viewing data with
multiple levels.
A) Drill down – changing a view to a greateer level of detail
B) Drill up – changing a view to a greater level of aggregation.
A) Drill down – changing a view to a greateer level of detail
B) Drill up – changing a view to a greater level of aggregation.
EDI (Electronic Data Interchange)
is a standard format for exchanging business data.
Encryption
the transformation of data from a recognizable format to a form unrecognizable
without the algorithm used for the transformation.
More Articles...
Page 7 of 20
