Studied by 0 people
Looks like no one added any tags here yet for you.
What are the 6 criteria for Databases
Collection of related data
A set of known facts that can be recorded and that have implicit meaning
Miniworld or Universe of Discourse (UoD)
Represents some aspect of the world world
Logically coherent collection of data with inherent meaning (semantics)
Built for a specific purpose
Types of Databases
Traditional database applications
Multimedia databases
Geographic information systems (GIS)
Traditional database applications
Store textual and/or numeric information
Multimedia databases
Store images, audio clips, and video streams digitally
Geographic information systems (GIS)
Store and analyze maps, weather data, and satellite images
Database Management System (DBMS)
A suite of programs that allows a user to create and maintain a database
Metadata/Data dictionary
Describes the data
Schema
The structure of the database, a particular type of metadatathat defines how data is organized and how relationships among data are handled.
What can you do in a Database Management System (DBMS)
You can specify the types of data, relationships between various data elements, and constraints on what can be stored in the database, as well as perform operations such as querying, updating, and managing data.
What are the 4 main activities performed in a database
Update
Change
Delete
Query
What does querying the database do
Retrieves information based upon criteria
What does updating the database include
Adding new information
Changing existing information
Removing records
What are examples of eCommerce databases
eBay
Amazon
What do Data warehouses and online analytical processing (OLAP) systems do
They extract and analyze useful business information from very large databases
What do Data warehouses and OLAP systems support
They support decision making
What is an example of real-time and active database technology
Control industrial and manufacturing processes
