Exam (elaborations)
ISTM 210 Exam 3 Phinney - Textbook
- Institution
- ASE Section 5 Sample Preparation Exam 1
ISTM 210 Exam 3 Phinney - Textbook
[Show more]
Seller
Follow
Content preview
ISTM 210 Exam 3 Phinney - TextbookDatabase - ANS-a well thought-out collection of computer files, the most important of
which are called tables (hold data), they consist of records (rows) separated by fields
(columns) that can be queried to produce subsets of info
Database Management System (DBMS) - ANS-Used to create, manipulate, and access
the data in a database
**Business databases are ALWAYS distributed on a computer network for multi-users
Entity Relationship Modeling (ERM) - ANS-a database modeling method used to
construct a theoretical & conceptual representation of the data to produce a database
schema
Database Schema - ANS-a "map" of data tables & their relationships to one another
Data Validation Rules - ANS-help to ensure the integrity of the data - helps avoid data
redundancy
Structured Query Language (SQL) - ANS-most widely used standard computer
language for relational databases as it allows a programmer to manipulate and query
data - simple to update, delete & append
Form - ANS-overlays a table for a more specific view
Oracle - ANS-most widely used database in the world
Cloud - ANS-using computer resources like a hard drive or software that exists on
another computer connected by a network, typically the Internet
iDrives - ANS-internet drives, have been offered for years by sites like GoDaddy.com -
morphed into the cloud
-did not catch on b/c at the time the internet speed was too slow
Cloud Service Providers (CSP) - ANS-like Google, Microsoft or Dropbox will provide
backup automatically through the cloud
-ADV: automatic backup & accessible w/ any internet enabled device
-DISADV: on internet, others can access it
, Infrastructure as a Service (IaaS) - ANS-allows people to access someone else's
computer & all of its resources (e.g. Photoshop) & storage via the internet. On-demand,
uses "pay-as-you-go" model
-ex: Windows Azure & Google Compute Engine
Storage as a Service (SaaS) - ANS-storing or renting space from a CSP
ex: QuickBooks, Microsoft 365
-like renting software
Open Office vs. Microsoft Equivalents - ANS-writer - word
calc - excel
impress - powerpoint
base - access
draw - adobe photoshop
(open office is completely free)
Platform as a Service (PaaS) - ANS-a cloud-provider supplies a computer platform (like
windows) through the internet - can also provide programming applications, databases
& webservers
-ex: Amazon's Elastic Beanstalk, Force.com & Google's App Engine
-ADV: saves lots of $$ and complexity
-DISADV: not flexible enough to allow for Co. growth
Business Intelligence (BI) - ANS-an assortment of software applications used to analyze
an org's raw data - helps them make better decisions but using data in a predicative
way
Ex given) autostore on what inventory to stock
"Big Data" - ANS-collected databases with vast amounts of data info, applied to DSS
Structured Data - ANS-resides in fixed formats, typically well labeled & often w/
traditional fields & records of common data tables. Don't have to be table like, just need
recognizable patterns to make searches & queries easier
Unstructured Data - ANS-disorganized data that cannot be easily read or processed by
a computer b/c its not stored in rows & columns like traditional data tables
**80% of all data us unstructured**
Semi-Structured Data - ANS-lands somewhere in-between structured & unstructured
data & can possibly be converted into structed data with a lot of work
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller denicetho. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for £7.16. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
83822 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy revision notes and other study material for 14 years now