A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

If you do not see a particular word or phrase that you would like to know the definition of, please let us know by writing to John McCormick and indicate the term you would like us to add to the Glossary.


sandbox
A sandbox is a testing environment that isolates untested code changes and outright experimentation from the production environment.

sarbanes-oxley
On July 30, 2002, the Sarbanes-Oxley Act (Public Law 104-204) went into effect, and changed the corporate landscape in the United States in regard to financial reporting and auditing for publicly traded companies. The law establishes stringent financial reporting requirements for companies doing business in the United States. It was designed to make the executives of publicly traded companies more responsible and accountable for oversight of their companies.

SAX
Simple API for XML (SAX) is an event-based interface for processing XML documents.

scalability
The ability to scale to support larger or smaller volumes of data and more or less users. The ability to increase or decrease size or capability in cost-effective increments with minimal impact on the unit cost of business and the procurement of additional services.

schema
A diagrammatic representation of the structure or framework of something. It is the logical and physical definition of data elements, physical characteristics and interrelationships.

scorecard
An application or custom user interface that helps manage an organization's performance by optimizing and aligning organizational units, business processes and individuals. It should also provide internal and industry benchmarks as well as goals and targets that help individuals understand their contributions to the organization. The use of scorecards spans the operational, tactical and strategic aspects of the business and its decisions. Often, methodologies derived from internal best practices or an external industry methodology is used for scorecarding.*

second normal form
The result of normalizing to ensure that a data model contains no partial key dependencies. In practice, when entities have compound keys, seek out any attribute that is dependent upon only part of the key. Whatever business thing is identifiable by that part of the key is an entity, and the 2NF violation is an attribute of that entity.

secondary key
A secondary key is a set of one or more attributes whose value identifies a set of occurrences in a data structure that share common characteristics. Access by secondary keys may return multiple occurrences, where access by a primary key is assured to find no more than one occurrence.

securability
The ability to provide differing access to individuals according to the classification of data and the user's business function, regardless of the variations.

secure sockets layer (SSL)
Secure sockets layer is a security technology that is commonly used to secure server to browser transactions.

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

SEM
Small entrepreneurial manufacturer.

semantic mapping
The mapping of the meaning of a piece of data.

server
A service that provides standard functions for clients in response to standard messages from clients. Note: A commonly used definition of server also refers to the physical computer from which services are provided.

service-oriented architecture (SOA)
A service-oriented architecture is a collection of services that communicate with each other. The services are self-contained and do not depend on the context or state of the other service. They work within a distributed systems architecture.

servlets
Allow users to run Java code on the server and send HTML pages to a browser.

share of wallet
The percentage of a customer's requirements that are filled by a particular brand of product or service.

simple object access protocol (SOAP)
Simple object access protocol is a World Wide Web Consortium (W3C) specification that facilitates the interoperability between a broad mixture of programs and platforms.

six sigma
A rigorous and disciplined methodology that utilizes data and statistical analysis to measure and improve a companies operational performance, practices and systems. Six Sigma identifies and prevents defects in manufacturing and service-related processes. In many organizations, it simply means a measure of quality that strives for near perfection.*

slice and dice
A term used to describe a complex data analysis function provided by MDBMS tools.

SMP
Symmetrical Multi-Processing. The "shared everything" approach of parallel computing.

snowflake schema
A snowflake schema is a set of tables comprised of a single, central fact table surrounded by normalized dimension hierarchies. Each dimension level is represented in a table. Snowflake schema implement dimensional data structures with fully normalized dimensions. Star schema are an alternative to snowflake schema.

social network analysis
Social netowrk analysis (SNA) is the use of information and knowledge from many people and their personal networks. It involves collecting massive amounts of data from multiple sources, analyzing the data to identify relationships and mining it for new information.

source database
An operational, production database or a centralized warehouse that feeds into a target database.

SQL
Structured Query Language. A structured query language for accessing relational, ODBC, DRDA, or non-relational compliant database systems.

SQL query tool
An end-user tool that accepts SQL to be processed against one or more relational databases.

SQL-compliant
Conformity to ANSI standards for Structured Query Language specifications.

standard query
A stored procedure of a recently executed query. Technically, a standard query may be stored on the desktop as "canned " SQL and passed as dynamic SQL to the server database to execute. This is undesirable unless the stored query is seldom executed.

star schema
A star schema is a set of tables comprised of a single, central fact table surrounded by de-normalized dimensions. Each dimension is represented in a single table. Star schema implement dimensional data structures with de- normalized dimensions. Snowflake schema are an alternative to star schema. A relational database schema for representing multidimensional data. The data is stored in a central fact table, with one or more tables holding information on each dimension. Dimensions have levels, and all levels are usually shown as columns in each dimension table.

static query
A stored, parameterized procedure, optimized for access to a particular data warehouse.

stoplighting
A technique using colored circles to identify the content of a data element. The colors are defined by a set of predefined thresholds.

subject oriented databases
Rather than build one massive, centralized data warehouse, most companies are building numerous subject-oriented warehouses to serve the needs of different divisions.

summarization tables
These tables are created along commonly used access dimensions to speed query performance, although the redundancies increase the amount of data in the warehouse. See Aggregated Data.

supply chain
The optimal flow of product from site of production through intermediate locations to the site of final use.

supply chain analytics
The process of extracting and presenting supply chain information to provide measurement, monitoring, forecasting and management of the chain.

surrogate key
A surrogate key is a single-part, artificially established identifier for an entity. Surrogate key assignment is a special case of derived data - one where the primary key is derived. A common way of deriving surrogate key values is to assign integer values sequentially.

syntactic mapping
The mapping required to unravel the syntax of information.

systems architecture
One of the four layers of the information systems architecture. The systems architecture represents the definitions and inter-relationships between applications and the product architecture.

Please note you must now log in with your email address and password.