Across
- 3. In object-oriented database, a(n) ____________ combines data structures with any functions needed to manipulate the object or the data it holds.
- 6. A unique record key that can be used to identify a specific record from a table in a relational database.
- 9. A small-scale data warehouse which do not aim to hold information across an entire company, but rather focus on one department.
- 10. A type of analysis that aims to identify patterns in the data that can be used to predict future behavior.
- 12. A standardized language for retrieving information from databases.
- 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.
- 15. OLAP implemented using a multidimensional database.
- 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.
- 17. A special software required that allows users to enter, store, organise, manipulate and retrieve data from a database.
- 19. In a relational database, data can be combined from several different sources by defining ____________ between tables.
- 20. A collection of related records in the database.
- 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. In data mining, this technique involves using forecasting and regression analysis to predict sales.
- 2. A system that process large quantities of repetitive transactions conducting simple manipulations.
- 4. A collection of related fields in the database table.
- 5. A set of related data and information stored in an organized way so that specific items can be selected and retrieved quickly.
- 7. In data warehouse, T in ETL stands for?
- 8. A graphical interface to assist people to understand performance measurement information.
- 11. System or software that performs a specific task based on the rules and knowledge stored in a knowledge base.
- 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.
- 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.
- 22. The capability to load and process data as events happen into the data warehouse (abbrev).