Exam (elaborations)
CSE 511 Midterm Exam With Complete Solutions Latest Update
- Course
- Institution
CSE 511 Midterm Exam With Complete Solutions Latest Update...
[Show more]
Content preview
CSE 511 Midterm Exam With CompleteSolutions Latest Update
True or false, sources of dat are becoming larger and more diverse - ANSWER True,
Billions or even trillions of data sources
What is the goal of data processing? - ANSWER To extract data that is useful
Why is the volume of data that is available so large? - ANSWER Increasing number of
data sources (social media, wearable tech, sensors, cameras, etc), formats, and data
points
How much data may be generated in a day? - ANSWER A petabyte (1 million GB)
What is scalable data processing? - ANSWER Allows database processing systems to
cope with the volume, velocity, and variety aspects that big data brings into the system
What are the different types of data processing systems? - ANSWER Relational DBMS,
NoSQL Graph/Document Key Value Stores, and Hadoop/Spark
What are the characteristics of a Relational DBMS? - ANSWER Operational workload,
which presents entities and objects in the world using tables and relations between
tables.
What are the characteristics of a NoSQL Graph, Document, Key Value Stores? -
ANSWER Unstructured data, highly available systems. Runs queries that extract
knowledge from the data.
What are the characteristics of Hadoop/Spark? - ANSWER Not operational, analytics
, over massive scale data
What is a database? - ANSWER A very large, integrated collection of data that models
real world enterprises using entities and relationships between those entities
What are the three goals of a DBMS? - ANSWER To store, retrieve, and manage data
What are the advantages of a DBMS? ANSWER Data independnce (no need to know how
data is organized), Efficient data access (by indexes), data administration (one location
of data) concurrency control + crash recovery, data integrity + security, reduced app
development time (no need to care about scalability of database or performance of
database)
What is a data model - ANSWER collection of concepts for describing data. The
mathematical equation that defines a relationship.
What is a schema? - ANSWER A description of a particular collection of data in tables
using a given data model. Description of data using tables in the relational model
What are the three levels of abstraction? - ANSWER External Schema Views, Conceptual
Schema, and Physical Schema
What is the external schema (views)? - ANSWER Describe how the users view the data.
Can have multiple of these views on top of a conceptual schema.
What is the conceptual schema? - ANSWER Describes the logical structure of the
relation. That is to say the attributes that compose the database. Only one conceptual
schema per relation.
What is the physical schema? - ANSWER Describes the files and indexes used. How the
data is sorted, stored, and indexed.
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 $13.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
72042 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now