Class Notes (998,859)
US (389,560)
BC (3,835)
ISYS (68)
ISYS1021 (29)
Lecture 15

ISYS 1021 Lecture 15: Data as a Strategic Resource
Premium

2 Pages
52 Views
Fall 2016

Department
Information Systems
Course Code
ISYS1021
Professor
George Wyner
Lecture
15

This preview shows half of the first page. Sign up to view the full 2 pages of the document.
Data as a Strategic Resource:
(Cloud Notes Continued)
Information systems add value by transforming data into information
Database:
o single table or a collection of related tables with large amounts of information
Database management systems: (DBMS)
o Software for creating, maintaining, and manipulating data
o Recreational database is the dominant technology
o Structured Query Language: (SQL)
o Used to create and manipulate relational databases
Database examples:
Web applications like word press
Web base design is important and you need to include enough information
Sort by last name need separate fields
Referential integrity:
o when something doesn’t fit with the data and therefore causes some time of error
statement
Database automatically generates the numerical order ID
When we use V LOOKUP we’re matching data information
Don’t usually use exact lookups
Cloud Computing:
The dynamic provisioning of IT capabilities
Three main categories
o Software (as a service SaaS) Google Docs
o Platform as a service (Paas) Force.com
Software as a service is anytime you get an app that you don’t have to
install (like rental), Facebook, Twitter, Group me (things like it anyway),
app is connecting you
o Infrastructure as a service (IaaS)- Amazon rental computer or storage space
BC uses APEX and has a server room in the old seminary
Cloud Benefits
o Scalability:
easy to grow
When things get overloaded in real life you’re screwed, cloud can be
scaled up or back based on need
o Agility
You can shift size and how things work easily
Because Amazon and Google have such impressively sized infrastructure
they have access to many more forms of data, software, and general
utilities that consumers would otherwise have to purchase separately
o Reliability
Google and amazon run what you need for you so it’s safe and not your
responsibility
o Cost Savings
find more resources at oneclass.com
find more resources at oneclass.com

Loved by over 2.2 million students

Over 90% improved by at least one letter grade.

Leah — University of Toronto

OneClass has been such a huge help in my studies at UofT especially since I am a transfer student. OneClass is the study buddy I never had before and definitely gives me the extra push to get from a B to an A!

Leah — University of Toronto
Saarim — University of Michigan

Balancing social life With academics can be difficult, that is why I'm so glad that OneClass is out there where I can find the top notes for all of my classes. Now I can be the all-star student I want to be.

Saarim — University of Michigan
Jenna — University of Wisconsin

As a college student living on a college budget, I love how easy it is to earn gift cards just by submitting my notes.

Jenna — University of Wisconsin
Anne — University of California

OneClass has allowed me to catch up with my most difficult course! #lifesaver

Anne — University of California
Description
Data as a Strategic Resource : (Cloud Notes Continued) Information systems add value by transforming data into information Database: o single table or a collection of related tables with large amounts of information Database management systems: (DBMS) o Software for creating, maintaining, and manipulating data o Recreational database is the dominant technology o Structured Query Language: (SQL) o Used to create and manipulate relational databases Database examples: Web applications like word press Web base design is important and you need to include enough information Sort by last name need separate fields Referential integrity: o when something doesnt fit with the data and therefore causes some time of error statement Database automatically generates the numerical order ID When we use V LOOKUP were matching data information Dont usually use exact lookups Cloud Computing: The dynamic provisioning of IT capabilities Three main categories o Software (as a service SaaS) Google Docs o
More Less
Unlock Document

Only half of the first page are available for preview. Some parts have been intentionally blurred.

Unlock Document
You're Reading a Preview

Unlock to view full version

Unlock Document

You've reached the limit of 4 previews this month

Create an account for unlimited previews.

Already have an account?

Log In


OR

Don't have an account?

Join OneClass

Access over 10 million pages of study
documents for 1.3 million courses.

Sign up

Join to view


OR

By registering, I agree to the Terms and Privacy Policies
Already have an account?
Just a few more details

So we can recommend you notes for your school.

Reset Password

Please enter below the email address you registered with and we will send you a link to reset your password.

Add your courses

Get notes from the top students in your class.


Submit