Database Word

Edit Answers
12345678910111213
Across
  1. 1. A complete SELECT statement that specifies 1) the columns and tables from which data is to be retrieved; 2) optionally, conditions that the data must satisfy; 3) optionally, computations that are to be performed on the retrieved column values; and 4) optionally, a desired ordering of the result set.
  2. 5. Occurs when a lock request has waited longer than the prescribed wait time for the request to be granted.
  3. 6. - An acronym for Main Memory Database, also called In-memory Database.
  4. 8. A repository for the computer-readable form of a database's data definition meta-data. Sometimes called the system catalog or just syscat.
  5. 10. A collection of closely related data fields—equivalent to an SQL table. Similar to a C struct, a record type is defined by a set of closely related data fields.
  6. 12. Input/output. For a DBMS, this is normally a disk drive, used to create database durability.
  7. 13. A method used to implement the one-to-many relationship formed between two tables based on their foreign and primary key declarations.
Down
  1. 2. A portion of a DBMS that is included within the process space of an application program.
  2. 3. A stack is a conceptual structure consisting of a set of homogeneous elements and is based on the principle of last in first out (LIFO).
  3. 4. The means of communication between a client and a server. A process may have multiple connections opened, each in its own thread, to one or more databases at a time.
  4. 7. The computer memory that is set aside to contain a portion of the database data that has most recently been accessed by the database application program. A cache is used to minimize the amount of physical disk I/O performed by the DBMS.
  5. 9. The container for a set of common software API functions. Frequently, a library is contained in a DLL or Shared Library.
  6. 10. One set of related values for all of the columns declared in a given table. Also known as a record occurrence.
  7. 11. A collection of closely related columns. A table consists of rows each of which shares the same columns but vary in the column values.