T. Andrew Yang

Email:

yang@uhcl.edu

Web: 

http://cse.uhcl.edu/yang/

Tel.:

(281) 283-3835 

Last updated:

7/13: Lab 2 due date extended

7/11: ppt links updated

6/15: ppt links updated

6/5/2022: first posted

CSCI 5533-01 Distributed Information Systems

summer 2022  (6/6 7/30)

o   UHCL Return to Campus FAQ: https://www.uhcl.edu/return-to-campus/faq

o   Instruction Mode:

·        This class will be held as a face-to-face class with supplemental services using Blackboard, Zoom, and websites. 

·        To join remotely an ongoing class session, click 'Zoom Class Sessions' in the Blackboard menu. NOTE: If this is the first time you use Zoom on your computer, you will be prompted to install the Zoom software. Click the downloaded exe file to start the installation.

o   Visit https://blackboard.uhcl.edu/ to access your classes in the UHCL’s Blackboard system.

·       For those who are new to Blackboard, visit the UHCL's Blackboard Student Support page (at https://www.uhcl.edu/computing/coursedevelopment/blackboardstudentsupport) to become familiar with the Blackboard app.

In the Blackboard, a discussion board is available for class-related announcements and discussions. Because of uncertainty caused by the pandemic, changes to the class schedule may be announced unexpectedly. Announcements will be posted in the Discussion Board. Be sure to check the posted messages at least once a day (and before each of the class meetings).

Class Notes, Topics & Schedule

Assignments & Projects


Time & Classroom

Mon. & Wedn., 3:00pm – 5:50pm

Classroom: Delta 237

Note: The online sessions will be recorded. If you ever miss any of the sessions, be sure to watch the recorded video of the class session.

Course Description: Distributed transparency, distributed data base design, distributed query processing, distributed concurrency control and recovery, distributed DBMS. 

Prerequisite: CSCI 5333 - Database Management Systems

Course Objectives: This course will provide students the theories, algorithms, and methods of distributed information systems, in particular those involving distributed database systems.

 

Learning Outcome:

  • Describe what a distributed information system is and its characteristics.
  • Describe the various distributed architectures, processes, and communication schemes.
  • Describe what and why distributed database systems, and their architectures.
  • Design a distributed database through various fragmentation strategies and algorithms.
  • Enforce distributed data security through distributed authorization control, and guarantee distributed database consistency through distributed integrity control.
  • Handle distributed query processing through query decomposition and data localization.

Class Format: Lectures are combined with discussions and, if applicable, student presentations and discussions of advanced topics. Students are expected to be active participants, by studying the relevant chapters and/or research papers, and participating at in-class discussions.

 

Lifelong learning

 “Education is not something you can finish.” (Isaac Asimov)

A note about Bloom's Taxonomy and your learning

(source: https://tips.uark.edu/using-blooms-taxonomy/ )

 


Instructor: Dr. T. Andrew Yang

-       Email address: yang@uhcl.edu

-       Web site: http://cse.uhcl.edu/yang (or https://sceweb.uhcl.edu/yang

-       Office: Delta 174

-       Phone: (281) 283-3835 (Please leave a message if not available.

 

-       Drop-in Office Hours via Zoom 

Click this link: https://uhcl.zoom.us/j/93285948037?pwd=U3NJMmhMaWVjZy9INUxwbS9ENDBvZz09

               Tuesdays: 3:00pm-4:00pm

               Thursdays: 3:00pm-4:00pm

 

-       To communicate with the professor, you are encouraged to email your questions or issues to yang@uhcl.edu and, if necessary, set up a time with the professor to have an online meeting. Emails are typically replied within 24 hours. If you have not received a response within 24 hours, either send a reminder email or leave a message at (281) 283-3835.

 

-       Using emails effectively:

Emailing has become an indispensable tool in most work places.

Emails without a subject line or the signature line will be considered as potentially malicious and be discarded. Here is a sample subject line: "CSCI 5533 assignment #1, question 3". The signature line should have your full name and the name of the class.

Although email messages tend to be informal, please check the grammar and spelling of your messages to ensure their legibility.

Try to provide sufficient details in your email message, such as the problem(s) you have encountered, the solution(s) you have tried, and the outcome you have got from these solution(s).

Teaching assistant info and office hours

 

Mettu, Pranay

Email: MettuP5486@UHCL.edu

 

Office Hours: 

Monday: 1 PM - 4 PM

Thursday: 9 AM - 12 PM

Friday: 9 AM - 11 AM and 12 PM - 6 PM

 

Office hours are conducted in Delta PC Lab (2nd floor) and as Zoom meetings as well. Below are the zoom meeting details:

https://us04web.zoom.us/j/2836038413?pwd=Um04M1dNVSs3WitFS0plYlA2RmNqdz09

https://sceweb.uhcl.edu/yang/teaching/csci5233spring2022/index_files/image004.jpg

 


Required Text:

B1. M. Van Steen and A. S. Tanenbaum, Distributed Systems, 3rd edition, CreateSpace, 2017. (ISBN 13: 978-1543057386)

NOTE: The e-book can be downloaded for free from the authors’ website at https://www.distributed-systems.net/index.php/books/ds3/.

 

B2. M. Tamer Özsu and Patrick Valduriez, Principles of Distributed Database Systems, 3rd edition, Springer, 2011. (ISBN 13: 978-1441988331).

+ Instructor's handouts in the class and/or on the Web

 


Topics and Notes
NOTE: The following schedule will be adhered to as closely as possible, although changes are probable. Always check with your instructor if you are not sure what would be covered next week.

week (dates)

Topics & Slides (Book: Chapters)

Due Dates

1 (6/6, 8)

Syllabus

-        Introduction to Distributed Systems

-        Intro by Van Steen and Tanenbaum (B1: Ch 1)

2 (6/13, 15)

-        Introduction to Distributed DBMS (B2: Ch 1)

-        Distributed Architectures (B1: Ch 2)   partA   partB

3 (6/20, 22)

-        Distributed Processes (B1: Ch 3)

Quiz (6/22)

4 (6/27, 29)

-        Background and Review of Relational DBMS (B2: Ch 2)

Lab 1 (6/29)

5 (7/6)

No class meeting on 7/4.

Test on 7/6.

Test #1 (7/6)

6 (7/11, 13)

-        Communications (B1: Ch 4) partA   partB

-        Distributed Design (B2: Ch 3)

 

7 (7/18, 20)

-        Design Integration (B2: Ch 4)

 

Lab 2 (7/20 7/24)

8 (7/25, 27)

-        Distributed Query Processing: overview (B2: Ch 6)

-        Test 2

Take your online course evaluations at https://apps.uhcl.edu/OnlineEvals (before the last teaching day).

 

 

Test #2 (7/27)

 


Attendance Policy: You are expected to attend all classes. If you have ever missed a class, be sure to watch the recorded session to learn what had been covered. It is your responsibility to get hold of whatever may have been discussed in the class.

Evaluation:

Take-home labs (20% each X 2)

40%

 

Quiz

5%

 

Tests (25% each X 2)

50%

Participation+

5%

Total:

100%

+ Class Participation: Participating in the class is expected. You should ask or answer questions during the in-class or online discussions.

Grading Scale:

The accumulated points from all the categories determine a person's final grade. There will be no extra-credit projects.

Percentile

Grade

 

Percentile

Grade

90% or above

A

 

70% - 73%

C

87% - 89%

A-

 

67% - 69%

C-

84% - 86%

B+

 

64% - 66%

D+

80% - 83%

B

 

60% - 63%

D

77% - 79%

B-

 

57% - 59%

D-

74% - 76%

C+

 

Less than 57%

F

Quizzes, Tests, and Exams:

Both analytic and synthetic abilities are emphasized. Being able to apply the learned knowledge toward problem solving is also highly emphasized in the tests. 

Unless due to unexpected, documented emergency, no make-up quiz, tests or exams will be given.

Assignments and Late Penalty:

Assignments will be posted at the class web site as well as in the Blackboard. The due date and time of each assignment is specified when it is published in the Blackboard.

A late assignment will not be graded. No extension will be granted except for documented emergency. Starting to work on the assignments as early as possible is always the best strategy.

 

Assignments Guidelines:

-        Identification page: All assignments must have your name, and course name/number/section number (e.g., CSCI 5533-01) at the top of the first page.

-        Proper organization of submitted material: If your submission include multiple documents, combine all of them into a single document (for example, a single PDF or ZIP).

-        Order! Order! Arrange the solutions following the sequence of the questions. Write the question number at the top-right corner of each page.

-        Word processing: It is required that you type your reports (e.g., print them using a printer). Use a word processor and appropriate typesetting and/or drawing tools to do the assignments. Spell-check the whole document before submitting it. You may lose points due to spelling or grammatical errors. 

Academic Honesty Policy:

NOTE: Unless otherwise specified, all assignments and projects are individual work.

Students should take caution not to violate the academic honesty policy specified by the university.

Per the UHCL academic honesty policy, plagiarism is defined as follow.

Plagiarism:

a. Incorporating the work or idea of another person into one’s own work without acknowledging the source of that work or idea.

b. Attempting to receive credit for work performed by another person, including papers obtained in whole or part from individuals or other sources.

c. Copying copyrighted computer programs or data files belonging to someone else.

Visit http://cse.uhcl.edu/yang/citing.htm for more information about cited references.

NOTE: When a grade is assigned, the grade can only be appealed within a week after the grade has been posted. Always review a graded lab or test immediately and, if needed, talk to the instructor within a week.

There is a tutorial at https://www.youtube.com/watch?v=im1j8wGNoBg about how to view grades and instructor feedbacks in the Blackboard. It's smart to find out what might have gone wrong in your answers (so the same mistakes won't be repeated in the future exams).

 

A note about problem-solving:

An important part of problem solving is correct understanding of the given problem.

-        Try to have a good grasp of the problem before starting the process of finding the solution(s).

-        Use any resources, including the instructor, the TA, your classmates/friends, and online resources to ensure that you have correctly understood the given problem.

-        While trying to figure out the solution(s), continue to verify your understanding of the problem.

-        Read the given instructions carefully before taking any action; while preparing your solutions, be sure to follow the given instructions.

Instructor's Notes:

Important: If you think you have lost some points due to grading errors, make sure you approach the instructor within a week after the assignment, project, or test has been returned to the class.

To get the most out of this class, you need to read the textbooks and spend time using computers regularly. Be prepared for a class by previewing the material to be covered in that class and participate in discussions and problem-solving exercises, if applicable, in the class.

Taking notes and understanding what are covered in classes are essential for successfully passing the exams.

As a student being trained to become a professional person, you are expected to behave according to the professional codes of conduct (e.g., the IEEE Code of Conduct) or code of ethics (e.g., the ACM Code of Ethics).

As a starting point, listed below are some of the common behaviors that do not conform to the codes of ethics:

-       Being regularly late for the class.

-       Chatting with another person while the instructor or someone is giving a speech in class.

-       Being regularly late when submitting assignments.

-       Asking the instructor or the TA for a favor when submitting a late assignment.

-       Checking out others’ answers during an exam.

-       Continuing to write when an exam’s time is up, or submitting an online exam past the due time.

-       Violating academic honesty when working on the assignments or exams.

-       Using others’ write-up without proper citing when writing a paper or report.

-       …

o   Some wishful thinking that could harm your learning and grade:

“It’s during the pandemic, so the instructor must make it easy for all students to pass the class.”

“If sufficient number of students do not do well in a test or exam, it is the instructor’s fault and he/she must give a make-up exam.”

“Submitting an assignments just a few minutes late should be acceptable and the TA or the instructor should not take points off.”

“Submitting a completed quiz or exam late should be ok if I had started the exam a few minutes late.”

...

 

 

 

Related Links:

·        UHCL General Program Requirements: https://catalog.uhcl.edu/current/

 

·        Withdrawals, Appeals, GPA, Repeated Courses, and the 6 Drop Rule: https://www.uhcl.edu/registrar/enrollment/six-drop-rule

 

·        ASSESSMENT FOR ACCREDITATION:

The School of Science and Computer Engineering may use assessment tools in this course and other courses for curriculum evaluation.  Educational assessment is defined as the systematic collection, interpretation, and use of information about student characteristics, educational environments, learning outcomes, and client satisfaction to improve program effectiveness, student performance, and professional success. This assessment will be related to the learning objectives for each course and individual student performance will be disaggregated relative to these objectives.  This disaggregated analysis will not impact student grades, but will provide faculty with detailed information that will be used to improve courses, curriculum, and student performance.

·        UHCL Disability Policy:

If you believe that you have a disability requiring an academic adjustment/auxiliary aid, please contact the Accessibility Support Center by phone at 281-283-2648, or email disability@uhcl.edu, or go to the office in the Student Services Building (SSCB), Room 1.302.

The University of Houston System complies with Section 504 of the Rehabilitation Act of 1973 and the Americans with Disabilities Act of 1990, pertaining to the provision of reasonable academic adjustments/auxiliary aids for students with a disability. In accordance with Section 504 and ADA guidelines, each University within the System strives to provide reasonable academic adjustments/auxiliary aids to students who request and require them.

 

Go to the Index


UHCL Covid-related Policies and Information (Fall 2021)

The documentation below contains language approved by the Office of General Council from UH System for inclusion in all syllabi. 

Face Covering Policy
To reduce the spread of COVID-19, the University strongly encourages everyone (vaccinated or not) to wear face coverings indoors on campus including classrooms for both faculty and students.  In addition, please respect each other’s personal space in the classroom to help reduce viral spread.

Presence in Class
Your presence in class each session means that you:

·        Are NOT exhibiting any  Coronavirus Symptoms that makes you think that you may have COVID-19

·        Have NOT tested positive or been diagnosed for COVID-19

·        Have NOT knowingly been exposed to someone with COVID-19 or suspected/presumed COVID-19

If you are experiencing any COVID-19 symptoms that are not clearly related to a pre-existing medical condition, do not come to class. Please see Student Protocols for what to do if you experience symptoms and potential exposure for what to do if you have potentially been exposed to COVID-19. The Covid-19 Reporting Forms for students are easily accessible and you are encouraged to report a diagnosis or an exposure.

COVID-19 Information
Students are encouraged to visit the University’s COVID-19 website for important information including on-campus testing, vaccines, diagnosis and symptom protocols, campus cleaning and safety practices, report forms, and positive cases on campus. Please check the website throughout the semester for updates.

Vaccinations
Data suggests that vaccination remains the best intervention for reliable protection against COVID-19. Students are asked to familiarize themselves with pertinent vaccine information, consult with their health care provider. The University strongly encourages all students, faculty and staff to be vaccinated. 

Reasonable Academic Adjustments/Auxiliary Aids
The University of Houston-Clear Lake complies with Section 504 of the Rehabilitation Act of 1973 and the Americans with Disabilities Act of 1990, pertaining to the provision of reasonable academic adjustments/auxiliary aids for disabled students. In accordance with Section 504 and ADA guidelines, UHCL strives to provide reasonable academic adjustments/auxiliary aids to students who request and require them. If you believe that you have a disability requiring an academic adjustments/auxiliary aid, please contact the Accessibility Support Center.

Recording of Class
Students may not record all or part of class, livestream all or part of class, or make/distribute screen captures, without advanced written consent of the instructor. If you have or think you may have a disability such that you need to record class-related activities, please contact the Accessibility Support Center. If you have an accommodation to record class-related activities, those recordings may not be shared with any other student, whether in this course or not, or with any other person or on any other platform. Classes may be recorded by the instructor. Students may use instructor’s recordings for their own studying and notetaking. Instructor’s recordings are not authorized to be shared with anyone without the prior written approval of the instructor. Failure to comply with requirements regarding recordings will result in a disciplinary referral to the Dean of Students Office and may result in disciplinary action.

Syllabus Changes
Due to the changing nature of the COVID-19 pandemic, please note that the instructor may need to make modifications to the course syllabus and may do so at any time. Notice of such changes will be announced as quickly as possible through BlackBoard.

Resources for Online Learning
The University of Houston-Clear Lake is committed to student success, and provides information to optimize the online learning experience through our Office of Information Technology website and the special Covid-19 Computing Resources website. Please visit this website for a comprehensive set of resources, tools, and tips including: obtaining access to the internet, E-Services, and Blackboard; requesting a laptop through the Online Learning Assistance Program (OLARP); using your smartphone as a webcam; and downloading Microsoft Office 365 at no cost. For questions or assistance contact supportcenter@uhcl.edu.

UHCL Email
Please check and use your UHCL email for communications related to this course.

Go to the Index