OMIS2000- Chapter Notes

Internet network architecture the internet backbone

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: the PARTS chart, select Part_Number 137 or 150 Join – combines relational tables to provide the user w/ more info than is available in individual tables. Ex. join Part_Number w/ the Supplier_Number to combine SUPPLIER and PART info in a new table Project – creates a subset consisting of columns in a table, permitting the user to create new tables that contain only the info required. Ex. extract Part_Number 137 and 150 w/ their Part_Names and their matching Supplier_Numbers 8259 and 8263 w/ Supplier_Names (refer to page 183 for visuals!) Object- oriented DBMS – stores the data and procedures that act on those data as objects that can be automatically retrieved and shared. Hybrid OODBMS are also available to provide capabilities of both object- oriented and relational DBMS Although cloud computing is an excellent method of storing large amounts of data, it can be risky and create inconvenience if the cloud is down or unavailable. DBMS have a data definition capability to specify the structure of the content of the database. It would be used to create database tables & to define the characteristics of the fields in each table. This info about the database would be documented in the data dictionary – an automated or manual file that stores definitions of data elements and their characteristics Most DBMS have a specialized language called a data manipulation language that is used to add, change, delete, and retrieve the data in the database The most prominent data manipulation used today is Structured Query Language (SQL) – ex. on page 185 Normalization – process of creating small, stable, yet flexible and adaptive data structures from complex groups of data. It removes any re...
View Full Document

This note was uploaded on 03/28/2014 for the course OMIS 2000 taught by Professor Hk during the Fall '13 term at York University.

Ask a homework question - tutors are online