Filter
Top Products
Relation operation
With relational databases, a relation operation allows only data from specified columns or a collection of data that
meets certain conditions to be fetched. Three types of relation operations are available: selection, projection, and join.
Selection refers to fetching rows that match specified conditions from a table. Projection refers to fetching only
specified columns from a table. Join refers to specifying join conditions to create one table from two or more tables.
Rollback
Nullifying the data manipulation of a transaction that is being processed. The two kinds of rollback can be performed.
Rollback in data manipulating SQL statement units can be the occurrence of an exception condition in a data
operation. Rollback in transaction units can be the deliberate execution of a ROLLBACK statement by an application
program.
Related term: commit
Routine name
The name of a procedure routine.
Related term: Procedure routine
Row
A row is one of the components of a table. In relational databases, data is expressed in terms of two-dimensional
tables containing rows and columns.
Row ID
A row ID is used to identify a unique row of a table in the database. Users can manipulate the data of a desired row by
using the row ID which is fetched by executing a single row SELECT statement or FETCH statement.
Schema
A constituent element of a database. SymfoWARE/RDB creates tables and view tables by analyzing data using
information system analysis technique AA/BRMODELLING.
Schema definition
Schema definition is logical structure definition which defines the base tables and view tables that constitute a
database, the column configuration of each table, and the attributes of each column. Authorities, procedure routines,
and triggers can be defined as well as tables.
Scope
When using SQL statements for data manipulation to access a table, the table can be accessed within a specified
data manipulation range. The specified data manipulation range is called a scope. The scope function can determine
a data manipulation range for each user by applying/releasing a scope to/from users who access tables.
214