Database Features- Glossary

Back to root Glossary
An object-relational database (ORD), or object-relational database management system (ORDBMS), is a database management system (DBMS) similar to a relational database, but with an object-oriented database model: objects, classes and inheritance are directly supported in database schemas and in the query language. In addition, it supports extension of the data model with custom data-types and methods. Example of an Object-Oriented Database Model: An object-relational database can be said to provide a middle ground between relational databases and bject-oriented databases (OODBMS). In object-relational databases, the approach is essentially that of relational databases: the data resides in the database and is manipulated collectively with queries in a query language; at the other extreme are OODBMSes in which the database is essentially a persistent object store for software written in an object-oriented programming language, with a programming API for storing and retrieving objects, and little or no specific support for querying.
ALGOL language
An old computer programming language (no longer used) with a syntax similar to Bourne shell programming.
To add information to the end of an existing file (without altering existing data in the file).
Batch file
A file containing commands to execute, as if from the command line. For example, autoexec.bat was a batch file for old DOS systems.
Binary file
A file that contains computer-readable code for a program that can be executed. Binary files are not human-readable.
A counting system consisting of one and zero; or, expressions which can be represented by either True or False (using a one or a zero).
Command interpreter
A computer program that accepts commands entered by a user (normally from the keyboard) and processes them. The DOS C: prompt and a UNIX shell are both command interpreters.
Command line argument
Information included on the command line (as supplementary data) in a command interpreter when a program is launched.
Converting a human-readable source code file for a program into a computer-readable file that can be executed.
Environment variable
Name-value pairs containing values that are needed (and can be accessed) by any program within the environment simply by querying for the value of the environment variable's name.
Error trapping
Defining actions (other than simply printing an error message) that should occur if an error is detected during the execution of a program.
Execute permission
A file permission within UNIX file systems that allows a program to be launched or executed.
The partitioning of one base table partition for each nested table partition is called equipartitioning.
External command
A command started from within a command interpreter (such as a UNIX shell) that is not part of the command interpreter's functionality, but must be launched as a separate (external) program.
File extension
The last part of a filename, usually separated by a period (such as .tif or .doc), which indicates the format or function of the file.
File permission
An access right assigned to a file to determine which user can read, write, or execute a UNIX file.
File extension
The last part of a filename, usually separated by a period (such as .tif or .doc), which indicates the format or function of the file.
a dominant contender within a particular sphere of operation or activity.
Executing a command or list of commands repeatedly, usually one time right after another, with a slightly different value each time through.
A set of one or more commands that are executed repeatedly undercontrol of a programming structure.
Lists of commands within a program such as a word processor that are normally executed by a user, but which have been stored or recorded, and can thus be executed by the program without user intervention.
Using a symbol or shortcut to represent something else, as an abbreviation or memory aid.
Multithreaded applications
Applications that are capable of responding to multiple requests or users simultaneously.
Non-text file
A file that does not contain human-readable words, or that is composed of control characters that cannot be printed normally. A binary executable file is a non-text file.
Numeric expression
A set of numbers (digits) and mathematical operators (such as +, -, *, /) that can be evaluated mathematically to reach a result.
Software for which the source code files (the programming instructions) are readily available.
PATH environment variable
A value stored in the shell that determines where the shell searches for executable programs launched from a command line.
(verb) To route the output of one command as the input of another command (rather than routing that output to the screen or to a file). (noun) Pipes are operators (using the character "|") used within a shell command line that cause the shell to route the output of one program as the input of a second program.
Positional variable
Variables defined by the shell whenever a program or shell script is launched that contain the command line arguments that were included when the program was started.
A task within the UNIX kernel; an independent program.
Process ID number
A unique number assigned by the UNIX kernel to each task (process) running on the system.
Redirection character
An operator used in the shell to change how input and output from programs is used, sending or receiving data from files or to and from other programs.
A standard or simple variable, as opposed to a variable that contains multiple values (like an array) or one that contains additional information (such as a vector in mathematical terms).
Shell prompt
The character used by a shell to indicate that it is ready to accept commands entered by a user from the keyboard. Standard shell prompts are $, %, and #.

The standard input channel used to retrieve data for a program, normally from the keyboard.
The standard output channel used to send output from a program, usually to the screen.
Structured file
A file in which data is organized into fields, columns, records, or some other definable characteristic that allows easy automated processes by a program designed around the structure of the file.
The administrative account; the user account that has permission to control or administer a UNIX system; the root user.
The tape archive utility, used to combine multiple files into a single file (optionally compressed) for creating archives to a tape drive or other archive device, or for saving many files in a single large file for transfer to another location.
Text file
A file containing human-readable data, including configuration instructions, programming languages, or regular prose, but without special control characters like those generated by a word processing program to indicate formatting and otherspecial options.
UNIX root user
The administrative account on a UNIX system; the superuser who has all access to the system.
Working interactively
Working with a command (or list of commands) as they are executed, providing data as needed. Using commands interactively is the opposite of running commands in batch mode (which requires no user intervention).

SEMrush Sports Car