User guide

Data Integration with Sybase Avaki Studio 177
Avaki Studio
A graphical, metadata-based data integration tool that lets you
• Build data flows by dragging and dropping input sources, operators, and output targets. You can
deploy your data flows as Avaki data services.
• Import or create metadata models and apply them to Avaki objects or use them to build new data
services.
In addition, you can use Studio to perform provisioning tasks (creating database connectors, data-
base operations, virtual database operations, and SQL views), manipulate categories, and edit ad-hoc
queries and attributes.
cache service
(Formerly proxy cache service.) A staging service that stores copies of files, database operation
results, and data service results. Caching improves retrieval performance. To ensure that an object is
stored in the cache, you can pin a file or directory in the data catalog, or schedule a database operation
or data service. A cache service can provide remote caching, local caching, or both. The freshness of
cached data is controlled by a data expiration interval that determines how long cached data is consid-
ered valid and by a cache coherence window that tells the cache service how often to check whether
cached data is still valid. If cached data is too old to satisfy a new request (or is not stored in this
cache), the cache service does one of the following:
• If the database operation or data service that produced the data is local to this cache service, the
cache service triggers execution of the database operation or data service.
• If the database operation or data service that produced the data is remote from this cache service,
this cache service requests the data from the data source’s local cache service.
A cache service can be associated with a data grid access server, a grid server, or a local user in a CLI
session. See also local cache, remote cache, on-demand caching, and scheduled caching.
category
A mechanism for classifying and organizing the contents of the data catalog. Like Avaki directories,
categories serve as containers for objects in the data catalog. Anything in the data catalog—views,
data services, shared files, even Avaki directories themselves—can be assigned to a category. Catego-
ries are hierarchical, they have attributes, and Avaki access control lists regulate access to them.
CIFS client
A machine that mounts files or directories from the Avaki data catalog by connecting to a CIFS share
through an Avaki data grid access server. A CIFS client need not have Avaki software installed.
(CIFS—Common Internet File System—is a file-sharing protocol based on the file system imple-
mented by Windows.)