CGS2100 Test 2 Ch 11

  1. alphabetic check
    Confirms that only textual characters are entered in a database field.
  2. artificial intelligence (AI)
    The science that attempts to produce computers that display the same type of reasoning and intelligence that humans do.
  3. batch processing
    The process of accumulating transaction data until a certain point is reached, then processing those transactions all at once.
  4. binary large object (BLOB)
    In databases, a type of object that holds extremely large chunks of data in binary form; this data is usually video clips, pictures, or audio clips.
  5. browsing (
    1) The process of viewing database records. (2) The process of “surfing” the Web.
  6. clickstream data
    Information captured about each click that users make as they navigate a Web site.
  7. completeness check
    A process that ensures that all database fields defined as “required” have data entered into them.
  8. computational field (computed field)
    A numeric field in a database that is filled as the result of a computation.
  9. consistency check
    The process of comparing the value of data in a database field against established parameters to determine whether the value is reasonable.
  10. data centralization
    Having all data in one central location (usually a database). Data centralization helps ensure data integrity by requiring data to be updated only in one place if the data changes.
  11. data dictionary (database schema)
    A file that defines the name, data type, and length of each field in the database.
  12. data field
    Holds data such as birthdays and due dates.
  13. data inconsistency
    Any difference in data in lists caused when data exists in multiple lists and not all lists are updated when a piece of data changes.
  14. data integrity
    The process of ensuring that data contained in a database is accurate and reliable.
  15. data mart
    Small slices of a data warehouse.
  16. data mining
    The process by which great amounts of data are analyzed and investigated.
  17. data redundancy
    When the same data exists in more than one place in a database.
  18. data staging
    A three-step process: extracting data from source databases, transforming (reformatting) the data, and storing the data in a data warehouse.
  19. data type (field type)
    An attribute of a data field that determines what type of data can be stored in the database field or memory location.
  20. data warehouse
    A large-scale electronic repository of data that contains and organizes in one place all the data related to an organization.
  21. database
    A collection of related data that can be easily stored, sorted, organized, and queried.
  22. database administrator (database designer)
    An individual trained in the design, construction, and maintenance of databases.
  23. database management system (DBMS)
    A type of specially designed application software (such as Oracle or Microsoft Access) that interacts with the user, other applications, and the database to capture and analyze data.
  24. database query
    An inquiry the user poses to a database to extract a meaningful subset of data.
  25. date field
    A field in a database that holds date data such as birthdays, due dates, and so on.
  26. decision support system (DSS)
    A system designed to help managers develop solutions for specific problems.
  27. default value
    The value a database will use for a field unless the user enters another value.
  28. detail report
    A report generated with data from a database that shows the individual transactions that occurred during a certain time period.
  29. enterprise resource planning (ERP) system
    System that is used to control many “back office” operations and processing functions such as billing, production, inventory management, and human resources management.
  30. exception report
    A report that shows conditions that are unusual or that need attention by users of a system.
  31. expert system
    A system designed to replicate the decision-making processes of human experts to solve specific problems.
  32. export
    The process of putting data into an electronic file in a format that another application can understand.
  33. external data source
    Any source not owned by the company that owns a decision support system, such as customer demographic data purchased from third parties.
  34. field
    A field where a category of information in a database is stored. Fields are displayed in columns.
  35. field constraint
    Any property that must be satisfied for an entry to be accepted into the database field.
  36. field name
    An identifying name assigned to each field in a database.
  37. field size
    The maximum number of characters (or numbers) that a field in a database can contain.
  38. foreign key
    The primary key of another database table that is included for purposes of establishing relationships with another table.
  39. fuzzy logic
    A type of logic that allows the interjection of experiential learning into an equation by considering probabilities.
  40. hyperlink field
    A field in a database that stores hyperlinks to Web pages.
  41. information system
    A system that includes data, people, procedures, hardware, and software and that is used to gather and analyze information.
  42. input form
    A form that provides a view of the data fields to be filled in a database, with appropriate labels to assist database users in populating the database.
  43. join query
    A database query that links (or joins) two database tables using a common field in both tables and extracts the relevant data from each.
  44. knowledge-based system
    A support system that provides additional intelligence that supplements the user’s own intellect and makes a decision support system (DSS) more effective.
  45. management information system (MIS)
    A system that provides timely and accurate information that enables managers to make critical business decisions.
  46. many-to-many relationship
    A database relationship in which one record in a database table (A) can have many related records in another table (B), and any record in table B can have many related records in table A.
  47. memo field
    A text field in a database that is used to hold long pieces of text.
  48. metadata
    Data that describes other data.
  49. model management system
    A type of software that assists in building management models in decision support systems (DSSs).
  50. multidimensional database
    A database that stores data in multiple dimensions and is organized in a cube format.
  51. natural language processing (NLP) system
    A system that enables users to communicate with computer systems using a natural spoken or written language as opposed to using computer programming languages.
  52. normalization
    The process of recording data only once in a database to reduce data redundancy.
  53. numeric check
    A data validation routine that confirms that only numbers are entered in a database field.
  54. numeric field
    A field in a database that stores numbers.
  55. object field
    A field in a database that holds objects such as pictures, video clips, or entire documents.
  56. object-oriented database
    A database that stores data in objects, not in tables.
  57. object query language (OQL)
    A query language that is used to extract information from an object-oriented database.
  58. office support system (OSS)
    A system (such as Microsoft Office) designed to assist employees in accomplishing their day-today tasks and to improve communications.
  59. one-to-many relationship
    A database relationship in which one record in a data table can have many related records in another data table.
  60. one-to-one relationship
    A database relationship in which one record in a data table has only one related record in another data table.
  61. online transaction processing (OLTP)
    The immediate processing of user requests or transactions.
  62. primary key (key field)
    The unique field that each database record in a table must have.
  63. query
    The process of requesting information from a database.
  64. query language
    A language used to retrieve and display records. A query language consists of its own vocabulary and sentence structure, used to frame the requests.
  65. range check
    A type of data validation used in databases to ensure that a value entered falls within a specified range (such as requiring a person’s age to fall in a range of between 1 and 120).
  66. real-time processing
    The process of updating a database (or information system) immediately as changes are made.
  67. record
    A collection of related fields in a database.
  68. referential integrity
    For each value in the foreign key of one table, there is a corresponding value in the primary key of the related table.
  69. relation
    A database table that contains related data.
  70. relational algebra
    The use of English-like expressions that have variables and operations, much like algebraic equations.
  71. relational database
    A database that organizes data in table format by logically grouping similar data into relations (or tables) that contain related data.
  72. relationship
    In relational databases, the link between tables that defines how the data are related.
  73. select query
    A query that displays a subset of data from a table based on the criteria the user specifies.
  74. sort (index)
    The process of organizing a database into a particular order.
  75. structured (analytical) data
    Data that can be identified and classified as discrete bits of information (such as a name or phone number). Unstructured data includes nontraditional data such as audio clips (including MP3 files), video clips, and pictures that must be viewed in their entirety rather than in discrete segments.
  76. structured query language (SQL)
    The most popular database query language today.
  77. summary report
    A report that summarizes data in some fashion (such as a total of the day’s concession sales at an amusement park). Also known as a summary data report.
  78. table
    In database terminology, a group of related records. Also called a file.
  79. text field
    A database field that can hold any combination of alphanumeric data (letters or numbers) and is most often used to hold text.
  80. time-variant data
    Data that doesn’t all pertain to one period in time—for example, data in a data warehouse.
  81. transaction processing system (TPS)
    A system used to keep track of everyday business activities (such as sales of products).
  82. unstructured data
    Nontraditional database data such as audio clips (including MP3 files), video clips, pictures, and extremely large documents. Data of this type is known as a binary large object (BLOB) because it is actually encoded in binary form.
  83. validation
    The process of ensuring that data entered into a database is correct (or at least reasonable) and complete.
  84. validation rule
    A rule that is set up in a database to alert the user to possible wrong entries.
Card Set
CGS2100 Test 2 Ch 11
FSU CGS2100 Test 2 Chapter 11