UI STAT 5400 - Computing in Statistics (8 pages)

Previewing pages 1, 2, 3 of 8 page document View the full content.
View Full Document

Computing in Statistics



Previewing pages 1, 2, 3 of actual document.

View the full content.
View Full Document
View Full Document

Computing in Statistics

57 views


Pages:
8
School:
University of Iowa
Course:
Stat 5400 - Computing in Statistics
Computing in Statistics Documents

Unformatted text preview:

1 22S 166 Computing in Statistics 2 ideally should follow this model today s lecture deals with two related topics efficient storage of data applies to setting up datafiles for use by SAS or any other analysis system some aspects of relational database software such as Microsoft Access Intro to relational database concepts Lecture 15 Oct 12 2009 Material drawn in part from www citilink com jgarrick vbasic database rdbms html and http www citilink com jgarrick vbasic database fundamentals html Kate Cowles 374 SH 335 0727 kcowles stat uiowa edu Introduction to relational database concepts database a system for storing data relational database model has become the de facto standard for the design of databases both large and small storage of data for use in statistical analysis 3 What is a relational database 4 Basic concepts relational database stores all its data in tables Primary and Foreign Keys table is a set of rows and columns Referential Integrity set has no predefined sort order for its elements record is database terminology for a row or observation field or attribute is database terminology for a column or variable Queries Normalization 5 6 Flat files how not to store complex data Example customer order entry system simplest model for a database a single table which includes fields for each element you need to store You re managing the data for a company with a number of customers each of which will be placing multiple orders Each order can have one or more items you have probably worked with flat file databases at least in the form of spreadsheets waste storage space and are problematic to maintain 7 8 Data that we wish to record for each component of the application Problems with a flat file for representing this data Customers Customer Number Company Name Address City State ZIP Code Phone Number Orders Order Number Order Date PO Number Order Line Items Item Number Description Quantity Price Each time an order is placed you ll need to repeat the customer



View Full Document

Access the best Study Guides, Lecture Notes and Practice Exams

Loading Unlocking...
Login

Join to view Computing in Statistics and access 3M+ class-specific study document.

or
We will never post anything without your permission.
Don't have an account?
Sign Up

Join to view Computing in Statistics and access 3M+ class-specific study document.

or

By creating an account you agree to our Privacy Policy and Terms Of Use

Already a member?