90 likes | 226 Views
Databases. Setup and Access with Hardware. Matt Nusbaum. Background. Definition: A structured collection of data or documents that are stored in a computer system so that a person can access them using a program or query language. Terms.
E N D
Databases Setup and Access with Hardware Matt Nusbaum
Background • Definition: A structured collection of data or documents that are stored in a computer system so that a person can access them using a program or query language
Terms • Schema - The description of what type of data is being stored in the database • Model – The method in which the information is stored. • Tables – Related rows and columns where the data is stored. This data can either be
Database Management Systems • This term refers to the program that manages and queries the database. • Examples: • MS Access • Oracle • Filemaker • MaxDB
Database Models • Flat – Single table with related Columns and Rows. • Hierarchical – A tree like structure that dictates the nesting of records. • Network – Data with records linked to other records using pointers. • Relational – Dictated by Attributes, Relations, and Domains.
Other Database Models • Object Database – Databases with the Object-Oriented paradigm applied to them. • Post-Relational – Databases that use relations but are not constrained to have all the data represented in only one way.
Accessing Data • Queries are a method to essentially ask the database a question about its data. • Queries are done using a query language or an application with a query capability. • Examples are: • MS Excel and Access • AQT • Other “freeware” Query tools.
Basic Tutorial • Please refer to your handout as I demonstrate.