16.00 - Database Cache - Teradata Studio

Teradata Studio User Guide

Teradata Studio
March 2017
User Guide
The Database Cache option enables you to designate specific databases or users to be cached. A database cache file is created to store the metadata for the database. The metadata describes information about the database, such as its tables, columns, constraints, indexes, macros, parameters, stored procedures, user-defined functions, user-defined types, views, and more. This metadata is used to populate the Data Source Explorer and Transfer View trees.
The Database Cache option is associated with the Connection Profile. If the Connection Profile is deleted, the Database Cache list and any database cache files that were created are also deleted.

Database Cache Inheritance

If the Data Source Explorer load option is set to show databases in hierarchical format, child databases and user objects are nested under the parent database or user object. When you select a database or user object to be cached, all of its child database and user objects are also cached. When you change the Data Source Explorer load option, the database cache is deleted and then re-cached using the new selections.

Progress Monitor

When you first connect to the database and open the Databases folder, the database cache file is created in a background job. To view the progress of the database cache job, open the Progress Monitor view by selecting Window > Show View > Other > General > Progress and clicking OK.

About Refreshing Cache

After the cache is created, you can click Refresh to refresh the list of databases. Refreshing causes the cached databases to load from the database cache file. You can distinguish the cached databases within the Data Source Explorer tree by looking for the cache icon .

If new database objects are modified in the database while it is loaded from the database cache, the modified objects do not display in the Data Source Explorer until you refresh the database cache. To refresh the database cache for a specific database, right-click the cached database and select Refresh Database Cache. This action deletes the database cache file, launches a new background job to create a new database cache file, and refreshes the list of databases.

You can also refresh the database cache by deleting the database cache files in the Teradata JDBC Connection Properties dialog. Click Delete Cache Files to delete the database cache files. The Data Source Explorer shows any changes to the database objects. A subsequent refresh of the Databases folder loads the database from the database cache file.

Termination of Cache Job

Terminating the database cache job causes the database cache files to be deleted and databases to be loaded from the database metadata. To restart the database cache job, you must disconnect and reconnect the Connection Profile, and then click the Databases folder to open it and create the database cache files.