Basic_Practice_In_Oracle

Basic_Practice_In_Oracle - Data, Information, Knowledge...

Info iconThis preview shows pages 1–9. Sign up to view the full content.

View Full Document Right Arrow Icon
CIS 255 # 1 Data, Information, Knowledge – Data Data ........................ ........................ Facts, images, or sounds ............ ............ Media Media Relevancy is not known – nor cared about at point of storage Information Information .............. .............. Data whose form or content are appropriate for a particular use Meaningful data Knowledge Knowledge ... ... Instincts, ideas, rules, and procedures Guide actions and decisions Awareness of context application of information Def: Def: Data Knowledge Information Noise recursive nature of information
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
CIS 255 # 2 Database Management Database – A collection of related related data organized in a way to facilitate data searches and retrievals “The bits and bytes” Database management system (DBMS) Software Software to create, store, organize, and retrieve data from a single database or several databases EX: MS Access, ORACLE, SQL Server Def: Def:
Background image of page 2
CIS 255 # 3 Database . ... Data Dictionary / Repository Stored rules and descriptions about the structure and usage of the data Access Routines Implemented algorithms for efficient storage and retrieval Include index manipulation, clustering and partitioning logic Simple Overview of DBMS: Terms
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
CIS 255 # 4 Data Definition Language Route into data dictionary Commands to create or destroy structure in the dictionary EX: CREATE .... DROP . ... ALTER . ... tables, views, indexes, users, accounts, roles, privileges, triggers . ... Data Manipulation Language Commands to modify structure in the dictionary or to modify content in the database EX: INSERT .... DELETE . ... UPDATE . ... tables, views, indexes, users, accounts, roles, privileges, triggers . ... Simple Overview of DBMS: Terms -- p. 2
Background image of page 4
CIS 255 # 5 Query Language Commands to retrieve data EX: SELECT . ... Report Generator Utility to format data in a print or screen layout Commands to protect the current state of a database Commands to constrain or permit database access EX: GRANT . .. REVOKE . ... ROLLBACK . ... Simple Overview of DBMS: Terms -- p. 3
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
12 January 2009 CIS 255 # 6 Sample “Flat File” of Data
Background image of page 6
CIS 255 # 7 Flat File “Organized”
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Records and Files Record - each row of a structure like above Fields - the columns, representing the facts File - the entire structure Salesperson Number Salesperson Name City State Office Number Commission Percentage Year of Hire 119 Taylor New York NY 1211 15 2003 137 Baker Detroit MI 1284 10 1995 186 Adams Dallas TX 1253 15 2001 204 Dickens Dallas TX 1209 10 1998 255 Lincoln Atlanta GA 1268 20 2003 361 Carlyle Detroit MI 1227 20 2001 420 Green Tucson AZ 1263 10 1993 Figure 2.2 Salesperson file. key
Background image of page 8
Image of page 9
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 66

Basic_Practice_In_Oracle - Data, Information, Knowledge...

This preview shows document pages 1 - 9. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online