Glossary - S to U
Data Migration Glossary This data migration glossary has been split into sections for faster loading. You can access the complete glossary by following the link, or use the search engine below to find specific terms. |
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
Schema
Scrub (data)
- see Cleanse.
SGML - Standard Generalised Markup Language
- An internationally agreed standard for information representation. SGML can be used to produce files which can be read by people, and exchanged between machines and applications in a straightforward manner.
Source system
- The system which currently contains the data.
Spreadsheet
- A spreadsheet is a sheet of paper that shows accounting or other data in rows and columns. A spreadsheet also refers to a computer program that simulates a physical spreadsheet by capturing, displaying, and manipulating data arranged in rows and columns.
SQL - Structured Query Language
- Pronounced 'see-kwull' - A standardised query language for requesting information from a database.
A - B - C - D - f - F - G - H - I - J - K - L - M - N - O - P - Q - R - S - T - U - V - W - X - Y - Z
Table
- Refers to data arranged in rows and columns. A spreadsheet, for example, is a table. In relational database management systems, all information is stored in the form of tables.
Transaction
- A transaction usually means a sequence of information exchange and related work (such as database updating) that is treated as a unit for the purposes of satisfying a request and for ensuring database integrity. An example of a typical transaction might be the purchasing of a ticket.
Transform
- to modify data. This is nearly always required when performing a data migration or data cleansing. An example might be modifying all surnames so that they start with a capital letter. Some transformations can require very sophisticated processing.
Translate
- to convert one value or code to another using a lookup table or business rules.
Target System
A - B - C - D - E - E - G - H - I - J - K - L - M - N - O - P - Q - R - S - T - U - V - W - X - Y - Z
UNIX
- An operating system written at Bell Labs. The name is a pun based on an earlier system, Multics. Unix was written in the C language, which was invented hand-in-hand with UNIX. UNIX source code was distributed freely to universities (due, at least in part, to US trade restrictions on ATT Bell). Consequently UNIX became the first "open" system that could be improved or enhanced by anyone. There is now a freely available UNIX-based operating system named LINUX.
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
The following websites were useful when compiling this page.