Data Management - Applications 3 Flashcards
A clause applied to the output of a GROUP BY operation to restrict selected rows.
In SQL, a comparison operator used to check whether a value is among a list of specified values.
A SQL command that allows the insertion of one or more data rows into a table.
HAVING / IN / INSERT
In the object-oriented data model, a named set of instructions to perform an action. ??? represent real-world actions, and are invoked through messages.
The computer software that allows clients and servers to communicate within the client/server architecture. It is used to insulate client processes from the network protocols and the details of the server process protocols.
method / middleware
Words used by a system that cannot be used for any other purpose. For example, in Oracle SQL, the word INITIAL cannot be used to name tables or columns.
A SQL command that allows attribute values to be changed in one or more rows of a table.
The table on which a view is based.
A routine that pools transactions into a single group to update a master table in a single operation.
reserved words / UPDATE / base tables / batch update routine
A subquery that executes once for each row in the outer query.
A SQL command that creates a logical, “virtual” table. The view can be treated as a real table.
correlated subquery / CREATE VIEW
A join that performs a relational product (or Cartesian product) of two tables.
Dealing with or related to sets, or groups of things. In the relational model, SQL operators are ??? because they operate over entire sets of rows and columns at once.
cross join / set-oriented
A view that can update attributes in base tables that are used in the view.
A virtual table based on a SELECT query that is saved as an object in the database.
updatable view / view
The transaction property that requires all parts of a transaction to be treated as a single, indivisible, logical unit of work. All parts of a transaction must be completed or the entire transaction is aborted.
atomicity
A special type of third normal form (3NF) in which every determinant is a candidate key. A table in ??? must be in 3NF.
A table is in ??? if it is in 3NF and contains no multiple independent sets of multivalued dependencies.
BCNF / 4NF
An attribute that is not part of a key.
A condition in which an attribute is dependent on another attribute that is not part of the primary key.
nonprime attribute / transitive dependency
A set of instructions generated at application compilation time that is created and managed by a DBMS. The ??? ??? predetermines how an application’s query will access the database at run time.
A method by which a DBMS finds the most efficient access path for the execution of a query.
access plan / automatic query optimization
