Exam (elaborations)
CSE 511 Midterm 100% Verified
- Course
- Institution
CSE 511 Midterm 100% Verified...
[Show more]
Content preview
CSE 511 Midterm 100% VerifiedBig data - ANSWER volume of available data is huge. data keeps growing at stunning
rate. data comes from variety of sources in completely different formats
Scalable data processing lets database processing systems cope with the _______,
________, and _________ aspects that big data brings into the system - ANSWER volume,
velocity, variety
Best data processing system for operational workload bank, online store, etc - ANSWER
Relational DBMS Centralized, distributed
Unstructured data-highly available systems-data processing system - ANSWER NoSQL,
graph, document, key-value stores)
Analytics over massive-scale data - ANSWER Hadoop, Spark, Kafka, GraphX
Database - ANSWER large integrated collection of data
3 major functions of DBMS - ANSWER store, retrieve, manage
Store - DBMS function - ANSWER persist and maintain data in storage systems with
structure
Retrieve (DBMS function) - ANSWER define the way of use/read the data by the upper
layer applications
Manage (DBMS function) - ANSWER way of data being managed and manipulated
,Benefits of DBMS - ANSWER Data independence, efficient data access, data integrity
and security, data administration, concurrent access and crash recovery, reduced app
development time
Data Model - ANSWER collection of concepts for describing data
schema - ANSWER description of a particular collection of data, using given data model.
ex. students(sid: string, name: string, GPA: float)
Relational Model - ANSWER relations shown with rows and columns. most widely used
model
External schema - ANSWER view describes how users see the data. Ex.
Course_info(cid:string, enrollment:integer)
conceptual schema - ANSWER defines logical structure of the collection of data AKA
logical. Ex (three tables Students(), Course(), Enrolled())
physical schema - ANSWER describes how data are managed in storage systems. Ex.
relations stored as unordered files, index on first column of students
Defines and creates schemas - ANSWER data description language (DDL)
Modifies/queries data (think language) - ANSWER Data Manipulation language (DML)
Logical Date Independence - ANSWER Protection from changes in logical structure of
data
Physical Data Independence - ANSWER Protection from physical structure of data
, 2 parts of relation - ANSWER Instance, schema
instance - ANSWER a table, with rows and columns. # rows = cardinality, # fields =
degree/arity
SQL statement to create new relation - ANSWER CREATE TABLE Students
(sid CHAR(20),
name CHAR(20),
GPA REAL)
SQL statement to destroy relation - ANSWER DROP TABLE Students
SQL statement to alter schema - ANSWER ALTER TABLE Students
ADD COLUMN firstYear: integer
SQL statement to insert tuple - ANSWER INSERT INTO Students(sid, name, login, age,
gpa)
VALUE (%s)
SQL statement to delete all tuples satisfying conditions - ANSWER DELETE
FROM Students S
WHERE S.name = "Smith"
Integrity constraints - ANSWER condition that must be true for any instance of the
database
Integrity constraints are specified when - ANSWER schema is defined
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 or Stuvia-credit 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 Easton. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $14.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
67163 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now