data-architecture-a

(coco) #1

Spreadsheet The primary tool found in the personal computing environment


SQL The language interface for relational systems


SQL Server The DBMS built and managed by Microsoft


Staging area A location where data that are to be transformed are held in abeyance
waiting for other events to occur


Standard work unit (SWU) The process of creating small modules that can flow
efficiently and without bottlenecks


Star schema (or “star join”) A fact table and its related dimension tables


Statistical analysis The process of looking at a large number of values and evaluating the
values mathematically


Stemming The reduction of words to their root. For example, the stem of moving,
moved, mover, and move is the stem “mov”


Stop word A word in a language that is needed for communication but not needed to
convey information. In English, there are stop words such as “a,” “and,” “the,” “to,” and
“from”


Storage hierarchy Storage units linked to form a storage subsystem in which some units
are small and fast to access and other units are larger and slower to access


State A stage in a life cycle


Structured data Data that are managed by a database management system


Subdoc processing The recognition by textual ETL of the logical grouping of sections of
text


Subject-oriented database A database organized around the major entities of the
corporation


Synonym In grammar, a word that is a substitute for another word


System of record (or “single version of the truth”) The building of systems where there


Glossary
Free download pdf