Databases Reference
In-Depth Information
SAS OLAP Server
a SAS server that provides access to multidimensional data. The data is queried
using the multidimensional expressions (MDX) language.
SAS Open Metadata application
a client application that connects to the SAS Metadata Server and uses metadata
from one or more SAS Metadata Repositories.
SAS Open Metadata Architecture
a general-purpose metadata management facility that provides metadata services to
SAS applications. The SAS Open Metadata Architecture enables applications to
exchange metadata, which makes it easier for these applications to work together.
SAS/CONNECT server
a server that provides SAS/CONNECT services to a client. When SAS Data
Integration Studio generates code for a job, it uses SAS/CONNECT software to
submit code to remote computers. SAS Data Integration Studio can also use SAS/
CONNECT software for interactive access to remote libraries.
SAS/SHARE library
a SAS library for which input and output requests are controlled and executed by a
SAS/SHARE server.
SAS/SHARE server
the result of an execution of the SERVER procedure, which is part of SAS/SHARE
software. A server runs in a separate SAS session that services users' SAS sessions
by controlling and executing input and output requests to one or more libraries.
scheme
a data set that is created from a character variable or column and which is applied to
that same character data for the purpose of transformation or analysis.
sensitivity
in SAS data quality, a value that specifies the degree of complexity in newly created
match codes. A higher sensitivity value results in greater match code complexity,
which in turn results in a larger number of clusters, with fewer members in each
cluster.
server administrator
a person who installs and maintains server hardware or software. See also metadata
administrator.
server component
in SAS Management Console, a metadata object that specifies information about how
to connect to a particular kind of SAS server on a particular computer.
slowly changing dimensions
a technique for tracking changes to dimension table values in order to analyze
trends. For example, a dimension table named Customers might have columns for
Customer ID, Home Address, Age, and Income. Each time the address or income
changes for a customer, a new row could created for that customer in the dimension
table, and the old row could be retained. This historical record of changes could be
combined with purchasing information to forecast buying trends and direct customer
marketing campaigns.
snowflake schema
tables in a database in which a single fact table is connected to multiple dimension
tables. The dimension tables are structured to minimize update anomalies and to
address single themes. This structure is visually represented in a snowflake pattern.
See also star schema.
Search WWH ::
Custom Search