SMG IS 465 Lecture Notes - Lecture 2: Ntfs, Apple File System, Cardinality

21 views5 pages

Document Summary

Database = organized collections of logically related data. The shoebox full of receipts i save for reimbursements. Physical structure = how the os stores data on and accesses from media (ssd/hdd) **operating system -> purpose = user interface** Usually transparent to users of the computer. Logical structure = how users organize data. 4 common logical structures: flat files/spreadsheets, hierarchical (i. e: using directory and files, network, relational (dominant modern approach) Fails to show if a faculty member is in multiple departments. Very efficient in terms of data storage. Most flexible; if 2 tables share a column, they are linked. Most widely used (oracle, mysql, sql server, db2) Metadata = the data about the data. Can show the details about the relationships. Legacy method of storing data -- file processing. Each program manages its data in its own files. Same piece of data is held in separate places. Data changes in 1 file could cause inconsistencies.

Get access

Grade+
$40 USD/m
Billed monthly
Grade+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
10 Verified Answers
Class+
$30 USD/m
Billed monthly
Class+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
7 Verified Answers

Related Documents

Related Questions