Bui15p1 Activity 1-4 Puzzle

12345678910111213141516171819202122
Across
  1. 3. In object-oriented database, a(n) ____________ combines data structures with any functions needed to manipulate the object or the data it holds.
  2. 6. A unique record key that can be used to identify a specific record from a table in a relational database.
  3. 9. A small-scale data warehouse which do not aim to hold information across an entire company, but rather focus on one department.
  4. 10. A type of analysis that aims to identify patterns in the data that can be used to predict future behavior.
  5. 12. A standardized language for retrieving information from databases.
  6. 14. ___________ software that extracts data from one or more databases, transforms that data into a suitable format for the data warehouse and loads that data into the data warehouse.
  7. 15. OLAP implemented using a multidimensional database.
  8. 16. ____________ database is the most widely used type of database which stores data elements in different tables (relation), each of which consists of rows and columns.
  9. 17. A special software required that allows users to enter, store, organise, manipulate and retrieve data from a database.
  10. 19. In a relational database, data can be combined from several different sources by defining ____________ between tables.
  11. 20. A collection of related records in the database.
  12. 21. A sophisticated security feature that allows the data and information to be encoded so that they appear meaningless until it is properly decoded.
Down
  1. 1. In data mining, this technique involves using forecasting and regression analysis to predict sales.
  2. 2. A system that process large quantities of repetitive transactions conducting simple manipulations.
  3. 4. A collection of related fields in the database table.
  4. 5. A set of related data and information stored in an organized way so that specific items can be selected and retrieved quickly.
  5. 7. In data warehouse, T in ETL stands for?
  6. 8. A graphical interface to assist people to understand performance measurement information.
  7. 11. System or software that performs a specific task based on the rules and knowledge stored in a knowledge base.
  8. 13. It enables a user to locate, sort, update or extract records from the database usually by specifying the conditions that must be met in order for a record to be selected.
  9. 18. It stores information about the order of the records in the database and the locations of records, normally used to increase the speed at which records can be located or sorted.
  10. 22. The capability to load and process data as events happen into the data warehouse (abbrev).