Data Integration #2

 

Static data importing and exporting loses the links the data had with the original application.

If you copy database info to a wordprocessor using static exporting, any changes you make to the info in the wordprocessor will not change the data in the database.

 

Dynamic importing and exporting maintains the links with the source application. This means that a change in the wordprocessor will change the database.

 

Clipboard, cutting and pasting, can transfer can transfer information across applications.

 

OLE ( object linking and embedding ) allows drawings, photographs and moving pictures to be stored in fields. These fields are called BLOB ( binary large object ).

 

Mail merge is the most common linking of a database and other applications.