CSE 3244
Transcript Abbreviation:
Data Mgmt in Cloud
Course Description:
Systematic organization of data on cloud computing architectures; basic indexing techniques, including B-tree and hash-based indexing; fundamentals of query optimization, including access path selection and cardinality estimation; full and partial replication; data partitioning and distributed task scheduling.
Course Levels:
Undergraduate (1000-5000 level)
Designation:
Required
Elective
General Education Course:
(N/A)
Cross-Listings:
(N/A)
Credit Hours (Minimum if “Range”selected):
3.00
Max Credit Hours:
(N/A)
Select if Repeatable:
Off
Maximum Repeatable Credits:
(N/A)
Total Completions Allowed:
(N/A)
Allow Multiple Enrollments in Term:
No
Course Length:
14 weeks (autumn or spring)
Off Campus:
Never
Campus Location:
Columbus
Instruction Modes:
In Person (75-100% campus; 0-24% online)
Prerequisites and Co-requisites:
Prereq: 3241 or 5241; and 2421 or 3430; and enrollment in CSE, CIS, or Data Analytics majors.
Electronically Enforced:
No
Exclusions:
(N/A)
Course Goals / Objectives:
Master using fundamental concepts in indexing and optimization techniques, including B-trees, hash-based indexing and cardinality estimation
Master using mechanisms of distributed data management, including full and partial replication strategies, data partitioning, fault tolerance models and consistency trade-offs
Be competent with data warehousing techniques, including on-line analytical processing (OLAP)
Be competent with distributed algorithms and task scheduling in cloud environments
Be exposed to current cloud-based data management technologies
Check if concurrence sought:
No
Contact Hours:
| Topic | LEC | REC out-of-class | REC in-class | Weekly LAB out-of-class | Weekly LAB in-class |
|---|---|---|---|---|---|
| Review of relevant 3241/5241 Material | 1.0 | 0.0 | 0 | 0.0 | 0 |
| Indexing and Optimization | 18.0 | 0.0 | 0 | 0.0 | 0 |
| Data warehousing and OLAP | 3.0 | 0.0 | 0 | 0.0 | 0 |
| Cloud computing principles | 5.0 | 0.0 | 0 | 0.0 | 0 |
| Replication and partitioning strategies | 6.0 | 0.0 | 0 | 0.0 | 0 |
| Algorithms and platforms for cloud | 9.0 | 0.0 | 0 | 0.0 | 0 |
| Total | 42 | 0 | 0 | 0 | 0 |
Grading Plan:
Letter Grade
Course Components:
Lecture
Grade Roster Component:
Lecture
Credit by Exam (EM):
No
Grades Breakdown:
| Aspect | Percent |
|---|---|
| Homework | 25% |
| Lab assignments | 25% |
| Midterm Exam | 25% |
| Final Exam | 25% |
Representative Textbooks and Other Course Materials:
| Title | Author | Year |
|---|---|---|
| Fundamentals of Database Systems | Ramez Elmasri and Shamkant Navathe | |
| Data-Intensive Text Processing with MapReduce | Jimmy Lin and Chris Dyer |
ABET-CAC Criterion 3 Outcomes:
| Significant contribution (7+ hours) | 1 | Analyze a complex computing problem and to apply principles of computing and other relevant disciplines to identify solutions. |
| Substantial contribution (3-6 hours) | 2 | Design, implement, and evaluate a computing-based solution to meet a given set of computing requirements in the context of the program’s discipline. |
| Some contribution (1-2 hours) | 3 | Communicate effectively in a variety of professional contexts. |
| Some contribution (1-2 hours) | 4 | Recognize professional responsibilities and make informed judgments in computing practice based on legal and ethical principles |
| Some contribution (1-2 hours) | 5 | Function effectively as a member or leader of a team engaged in activities appropriate to the program’s discipline |
| Substantial contribution (3-6 hours) | 6 | Apply computer science theory and software development fundamentals to produce computing-based solutions. |
ABET-ETAC Criterion 3 Outcomes:
(N/A)
ABET-EAC Criterion 3 Outcomes:
| Significant contribution (7+ hours) | 1 | an ability to identify, formulate, and solve complex engineering problems by applying principles of engineering, science, and mathematics |
| Substantial contribution (3-6 hours) | 2 | an ability to apply engineering design to produce solutions that meet specified needs with consideration of public health, safety, and welfare, as well as global, cultural, social, environmental, and economic factors |
| Some contribution (1-2 hours) | 3 | an ability to communicate effectively with a range of audiences - pre-2019 EAC SLO (g) |
| Some contribution (1-2 hours) | 4 | an ability to recognize ethical and professional responsibilities in engineering situations and make informed judgments, which must consider the impact of engineering solutions in global, economic, environmental, and societal contexts |
| Some contribution (1-2 hours) | 5 | an ability to function effectively on a team whose members together provide leadership, create a collaborative and inclusive environment, establish goals, plan tasks, and meet objectives |
| Some contribution (1-2 hours) | 6 | an ability to develop and conduct appropriate experimentation, analyze and interpret data, and use engineering judgment to draw conclusions |
| Some contribution (1-2 hours) | 7 | an ability to acquire and apply new knowledge as needed, using appropriate learning strategies |
Embedded Literacies Info: