Database Development Glossary

connection profile

A connection profile is a configuration set used to access an endpoint. For example, the connection profile for a database endpoint defines the database name, server, user ID, and password parameters that facilitate the connection to the physical database. The server connection profiles provide the information to connect directly to a specific server.

endpoint

An endpoint is a physical instance or implementation of a particular resource type. For example, a database endpoint specifies a particular database instance used in a connection profile. The endpoint for a Java service is the Java source file that implements that service. Other examples are Java classes, stored procedures, and Web services.

launch configuration

A launch configuration keeps a set of named attributes that can be used to store data for a particular kind of program launcher. It describes how a program should be launched. Users interact with a launch configuration dialog to set up parameters for different types of launches, such as those for procedural objects.

nonsharable temporary table

An Adaptive Server Enterprise nonsharable temporary table exists only during the current session while you are connected to the database, and cannot be accessed from other connections. Adaptive Server Enterprise table names that begin with a pound sign (#) are nonsharable temporary tables.

procedural object

A procedural object is a type of database object that refers to a stored procedure, event handler, trigger, or user-defined function.

project

A project is the top level of the Sybase WorkSpace hierarchy. A project is a collection of resources that together accomplish a task.

result instance

In Database Development, a result instance is all of the execution status details, messages, and result sets returned by launching a procedural object or executing a SQL statement. Each result instance appears in a separate line in the History frame of SQL Results view.

result set

In Database Development, a result set is the result returned by executing a single SQL select statement. In SQL Results view, each result set for a single result instance appears in a separate tab in multitab mode, or successively in one tab in single-tab mode.

service

Services are self-describing application modules that provide access to business logic and data in networked software components. All endpoints are modeled as services by using WSDL documents that contain a set of operations and can be used in a business process.

subscription

A subscription is a domain for publishing or consuming one-to-many messaging.

topic

In the publish-and-subscribe model of real-time messaging services, a topic is the destination of a message to which message producers publish and message consumers subscribe.


Created June 25, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com