Portals eNewsletters Web Seminars dataWarehouse.com DM Review Magazine
DM Review | Covering Business Intelligence, Integration & Analytics
   Covering Business Intelligence, Integration & Analytics Advanced Search
advertisement

RESOURCE PORTALS
View all Portals

WEB SEMINARS
Scheduled Events

RESEARCH VAULT
White Paper Library
Research Papers

CAREERZONE
View Job Listings
Post a job

Advertisement

INFORMATION CENTER
DM Review Home
Newsletters
Current Magazine Issue
Magazine Archives
Online Columnists
Ask the Experts
Industry News
Search DM Review

GENERAL RESOURCES
Bookstore
Buyer's Guide
Glossary
Industry Events Calendar
Monthly Product Guides
Software Demo Lab
Vendor Listings

DM REVIEW
About Us
Press Releases
Awards
Advertising/Media Kit
Reprints
Magazine Subscriptions
Editorial Calendar
Contact Us
Customer Service

Glossary


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 *ALL

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 MaryJo.Nott@sourcemedia.com and indicate the term you would like us to add to the Glossary.

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. Written The law establishes stringent financial reporting requirements for companies doing business in the United States.

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. Its the logical and physical definition of data elements, physical characteristics and interrelationships.

Scorecard
An application or custom user interface that helps manage an organizations 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 customers 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 companys 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.

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.




* definition provided by Hyperion.



Advertisement
advertisement
Site Map Terms of Use Privacy Policy
SourceMedia (c) 2006 DM Review and SourceMedia, Inc. All rights reserved.
SourceMedia is an Investcorp company.
Use, duplication, or sale of this service, or data contained herein, is strictly prohibited.