Skip to content

Technical Glossary Terms - S

The Letter S

Back to Technical Glossary Main Page

Find below a glossary of terms and definitions that begin with the letter S as it relates to technical definitions.

Term Description
Scaleability The ability to increase volumes of data and number of users to the data warehouse solution without any impact on performance.
Schema An information model implemented in a database. A schema may be a logical schema, which will define tables, columns and constraints but not include any optimization. It could be a physical schema that includes optimization.
Scope The boundaries of a project expressed in some combination of geography, organization, applications and/or business functions.
Scope Change A change to project scope which requires an adjustment to the project work plan. Scope changes nearly always impacts project cost, schedule or quality.
Scope Creep The common phenomenon where additional requirements are added after a project has started without reconsidering the resourcing and timescale of the project. Scope creep occurs when there is a misconception that additional requirements will not affect the original project schedule. 
Security Profile A list of role-based security specifications.
Service Level Agreement (SLA) service level agreement (SLA) is a contract between a service provider (either internal or external) and the end user that defines the level of service expected from the service provider. SLAs are output-based in that their purpose is specifically to define what the customer will receive.
Snowflake Schema A common form of dimensional model. In a snowflake schema, different hierarchies in a dimension can be extended into their own dimensional tables. 
Source System The internal or external computer system which provides the source data for the warehouse.
Stakeholder A person, group, or business unit that has a share or an interest in a particular activity or a set of activities.
Structured Query Language (SQL) SQL is an abbreviation for structured query language and is used for requesting information from a database/data warehouse.
Subject Area An area of major interest or importance to the enterprise. It is centered on a major resource, product, or activity.
Summary Data The data that has been aggregated or transformed from the atomic level data. Summary data may reside in all of the database objects of the data warehouse.
Surrogate Key Integer keys that are sequentially assigned as needed in the ETL system. In the dimension table, the surrogate key is the primary key.