User defined data type which encapsulates a range of data values and functions. The functions are both defined on, and operate on the set of values
Column or columns whose values uniquely identify a row in the table and are not primary key columns
Shows the axis of investigation of the dimension in the cube
Qualifies dimensions used in queries. For example, the Time dimension can contain attributes Year, Quarter, Month, and Week
A data type used for large binary objects such as images
Written statement specifying what the information system must do or how it must be structured to support business needs
Index in which the physical order and the logical (indexed) order is the same
Data structure that contains an individual data item within a row (record), model equivalent of a database field
Used to eliminate frequent joins between tables and improve query performance
Entity-relationship diagram that models the information system without considering the details of physical implementation
Named check that enforces data requirements, default values, or referential integrity on a table or a column
Collection of measures corresponding to values stored into each of its data cell. The measures are organized into dimensions to provide for faster retrieval and drill-down
Identification of the data to access, its operating system, DBMS, and network platform
Text file in XML format that contains all the SQL syntax and specifications for a Database Management System
Axis of analysis in a multidimensional structure
Table that stores data related to the axis of investigation of a fact. For example, geography, time, product
Set of values for which a data item is valid
Set of measures manipulated by the cube. For example, Sale, Revenue, Budget are facts
Table that stores variable numerical values related to aspects of a business
Column or columns whose values depend on and migrate from a primary key, or an alternate key, in another table
A function is a form of procedure that returns a value to the calling environment for use in queries and other SQL statements
In an XML model, a global element is the root element of an XML hierarchy. SQL/XML queries are generated from global elements, directly through the SQL/XML Wizard or indirectly through the XML Builder Wizard
Defines navigational and consolidation paths through dimensions
Consists in segmenting a table into multiple tables each containing a subset of rows and the same columns as the partitioned table
Data structure that is based on a key and that speeds access to data and controls unique values
Within a reference, a link between each foreign key column referring to a matching primary key column
Variable that corresponds to the focus of an investigation, it describes the meaning of the analytical values stored in each data cell of the cube. Measures are most of the time numeric values like for example Price or Total
Open Database Connectivity (ODBC) interface which gives PowerDesigner access to data in database management systems (DBMS)
Part of the Open Database Connectivity (ODBC) interface that processes ODBC functions calls, submits SQL requests to a specific data source, and returns results to the application
Online Analytical Processing is a class of analytic application software that exposes business data in a multidimensional format
Usage restrictions set on a particular database object for a particular user, group or role
Table-reference diagram that models the information system including the details of physical implementation
Column or columns whose values uniquely identify a row in a table
Set of rights assigned to a database user, group, or role
Window that displays the properties of an object
Link between a parent table and a child table. A reference can link tables by shared keys or by specified columns
Rules governing data consistency, specifically the relationships among primary keys and foreign keys of different tables
Process of generating a PDM, or specific PDM objects, from an existing database schema
XML extension of the Structured Query Language. To retrieve relational data using the SQL syntax and edit the results in an XML format. A SQL/XML Wizard and a SQLXML macro allow you to insert SQL/XML queries in the definition of a trigger or a procedure
Sub-classification used to extend the semantics of an object without changing its structure; it can be predefined or user-defined
Named partition that stores tables and indexes on a storage device
A stored procedure is a precompiled collection of SQL statements stored under a name and processed as a unit
Alternative name for various types of objects used to mask the name and owner of an object, provide location transparency for remote objects of a distributed database, and simplify SQL statements for database users
Collection of rows (records) that have associated columns (fields)
Consists in merging tables into a single table in order to eliminate joins and to improve query performance
Named partition that stores tables and indexes in a database
Segment of SQL code associated with a table, and stored in a database. It is invoked automatically whenever there is an attempt to modify data in the associated table with an insert, delete, or update command
Name that identifies a person or group working with objects in a PDM, and which has the ability to own other objects in the PDM
Index in which no two rows can have the same index value, including NULL
Consists in segmenting a table into multiple tables each containing a subset of columns and the same number of rows as the partitioned table
Alternate way of looking at the data in one or more tables. Usually created as a subset of columns from one or more tables
An application stored on a Web server that you can access remotely through standard Web protocols (HTTP, SOAP) and data formats (HTML, XML, WSDL), whatever the systems and programming languages
The XML Builder Wizard, available from the Tools menu, helps you build a mapped XML model from a PDM open in the workspace. The generated XML model is linked to the SQL/XML extended model definition, so that you can generate SQL/XML queries from global elements
| Copyright (C) 2005. Sybase Inc. All rights reserved. | ||