
|
| sandbox |
|
In
Java, a number of cooperating system components that ensure an untrusted,
and possibly malicious, application cannot gain access to system resources. |

|
| scalability |
|
The
ability to increase or decrease size or capability in cost-effective increments
with minimal impact. |

|
| schema |
|
A collection of related database objects including tables, views, and other objects. |

|
| SDK—software
developer's kit |
|
A programming package enabling
application development for a specific platform and typically including
APIs, programming tools, and documentation. |

|
| Secure
Socket Layer (SSL) |
|
A commonly-used
protocol for managing the security of a message transmission on the internet.
Socket refers to the sockets method of passing data back and forth between
a client and a server program in a network or between program layers in
the same computer. SSL uses the public- and private-key encryption system,
which includes the use of a digital certificate. |

|
| SELECT |
|
A SQL statement (command)
that specifies data retrieval operations for data in a relational database. |

|
| selection |
|
The set
of dimension values currently chosen for a dimension, or the script that
contains conditions or criteria to specify those values. |

|
| selector |
|
A set of tools used to
choose dimension values to include in a report, table, graph, or dimension
list box. |

|
| semi-additive |
|
A numeric
fact that can be added along some, but not all, dimensions in a fact table. |

|
| server |
|
Software that handles the
functions required for concurrent, shared access to a database, including
processing of SQL and PL/SQL statements originating from client applications. |

|
| service
level agreement (SLA) |
|
Agreement
between the user and a service provider that establishes the level of service
to be provided. |

|
| servlet |
|
In Java, a program that
extends the functionality of a Web server, generating dynamic content and
interacting with Web clients using a request-response paradigm. |

|
| servlet
container |
|
In Java,
a container that provides the network services over which requests and responses
are sent, decodes requests, and formats responses. |

|
| servlet
container, distributed |
|
In Java, a servlet container
that can run a Web application tagged as distributable and that executes
across multiple Java virtual machines running on the same or different hosts. |

|
| session |
|
In Java,
an object used by a servlet to track a user's interaction with a Web application
across multiple HTTP requests. |

|
| session
bean |
|
In Java, an enterprise
bean that is created by a client and that usually exists only for the duration
of a single client/server session. |

|
| SGML—Standardized Generalized Markup Language |
|
An ISO/ANSI/ECMA
standard that specifies a way to annotate text documents with information
about types of sections of a document. |

|
| shared-nothing
architecture |
|
IBM hardware and software
architecture in which multiple databases are accessed by the same applications,
but do not contain the same information, and are therefore unable to function
as backups for each other. The opposite of Oracle clustering technology
found in Oracle9i Real Application Clusters. |

|
| Simple
Mail Transfer Protocol (SMTP) |
|
A part
of the TCP/IP Protocol Suite that describes methods for exchanging a common
set of network management information. |

|
| Simple
Object Access Protocol (SOAP) |
|
Protocol that uses a combination
of XML-based data structuring and the Hyper TextTransfer Protocol (HTTP)
to define a standardized method for invoking methods in objects distributed
in diverse operating environments across the internet. |

|
| single
sign on |
|
The ability
to use one password to access many applications. |

|
| SLA—service level agreement |
|
Agreement between the user
and a service provider that establishes the level of service to be provided. |

|
| slice
and dice |
|
A mechanism
whereby a query can equally analyze information along any dimension of a
multidimensional model. |

|
| slowly
changing dimensions |
|
The tendency of dimension
records to change gradually or occasionally over time. |

|
| SMTP—Simple Mail Transfer Protocol |
|
A part of the TCP/IP
Protocol Suite that describes methods for exchanging a common set of network
management information. |

|
| snapshots |
|
A copy of the data in a database at
any given point in time. |

|
| snowflake
model |
|
A
type of star schema in which the dimension tables are partly or fully normalized.
See also normalize, schema, star schema. |

|
| SOAP—Simple Object Access Protocol |
|
Protocol that uses a combination
of XML-based data structuring and the Hyper Text Transfer Protocol (HTTP)
to define a standardized method for invoking methods in objects distributed
in diverse operating environments across the internet. |

|
| software
developers kit (SDK) |
|
A programming
package enabling application development for a specific platform and typically
including APIs, programming tools, and documentation. |

|
| source
data |
|
Data used as the basis
of a data warehouse. Also called data source. |

|
| sparsity |
|
A
concept that refers to multidimensional data in which a relatively high
percentage of the combinations of dimension values do not contain actual
data and that take up storage space in a database. |

|
| SQL—Structured Query Language |
|
The standardized relational
database language for querying, manipulating, and updating information in
a relational database. |

|
| SQL
statement |
|
A complete
command or statement written in the SQL language. |

|
| SSL—Secure Sockets Layer |
|
A commonly used
protocol for managing the security of a message transmission on the internet.
Sockets refers to the sockets method of passing data back and forth between
a client and a server program in a network or between program layers in
the same computer. SSL uses the public- and private-key encryption system,
which includes the use of a digital certificate. |

|
| Standardized
Generalized Markup Language (SGML) |
|
An
ISO/ANSI/ECMA standard that specifies a way to annotate text documents with infomration about types of sections of a document. |

|
| star
model |
|
A
relational schema representing a multidimensional data model and consisting
of one or more fact tables and one or more dimension tables that are related
through foreign keys. See also schema. |

|
| star
query |
|
An optimization
technique that enables the dimensions and fact tables in the star model
to be accessed efficiently, and data returned to the user efficiently by
ensuring that dimension data is visited first and fact data visited last
and only once. |

|
| state |
|
In programming, the part of a class or object
definition that describes what information is contained within the class
or object. |

|
| stateful
session bean |
|
In Java,
a session bean with a conversational state. |

|
| stateless
session bean |
|
In Java, a session bean
with no conversational state and for which all instances are identical. |

|
| static |
|
In Java,
a language keyword used to define a variable as a class variable. |

|
| status |
|
The list of currently accessible
values for a given dimension. If the status of a given dimension is limited
to a subset of its stored values, then all expressions that are based on
that dimension will be limited to the corresponding subset of data. |

|
| Structured Query Language (SQL) |
|
The standardized relational database language
for querying, manipulating, and updating information in a relational database. |

|
| subject
area |
|
A
vertical portion of the business, such as Sales and Marketing, that is developed
as an iteration of an enterprisewide data warehouse. |

|
| summary
data |
|
Data
that is aggregated and stored in a summary fact table and made available
to the user for direct and easy access. |

|
| summary
table |
|
A
data structure in a data warehouse that contains summarized, or aggregated,
facts. |

|
| symmetric
multiprocessing (SMP) |
|
A shared-everything
hardware and software architecture where memory and disk controllers are
accessible to all CPUs. |

|
| system
administrator |
|
The person responsible
for configuring and administering the enterprise's computers, networks,
and software systems. |

|
| systems
integrator (SI) |
|
A service organization
that specializes in connecting systems, including hardware, software, and
networking. |

|