VDO TIS OFFICE - Podręcznik Użytkownika Pobierz pdf (Strona 49)

TIS-Office ToolBox

User Guide Glossary

TU00-0881-01410 02 © Siemens VDO Trading GmbH 44

TIS-Office Toolbox • Edition 07/2007

MSDE MSDE = Microsoft SQL Server Desktop Engine

SQL Server version with a limited number of database management functions, limited

data size (2 GB) and limited number of parallel access operations (max. 5 parallel

processes).

Re-index An index is a separate database file that stores information on the fields used in

database tables. Thus, frequent queries can be performed more quickly.

An index can get fragmented when data is being modified. This fragmentation can

cause query performance problems.

The reindex function reduces fragmentation by rearranging the index pages and

compacting the rows on these pages.

Restore This function enables you to ’install’ a database that replaces the current database.

SQL SQL (Structured Query Language)

SQL is an ANSI (American National Standards Institute) standard computer language

for accessing and manipulating database systems. SQL statements are used to

retrieve and update data in a database.

(Source: www.w3schools.com)

SQL Server 2005 Express Replacement of MSDE 2000 with less limitation.

Transfer The movement of data from one location to another. A modern definition would be the

transfer of data from one environment to another.

(Source: www.wikipedia.org)

1 2 ... 44 45 46 47 48 49 50 51 52

Brak uwag

VDO TIS OFFICE - Podręcznik Użytkownika Strona 49