Syllabus: Fall 2023		Credit hours: 3
Class times: 03:30pm – 04:45pm, TuTh		Classroom: Leonard Hall 107
Class # (on-campus: 513-01): 14986		Class # (on-line: 513-02): 14987
Instructor: Wen-Chen Hu   (my teaching philosophy)		Office: Upson II 366K
: https://und.zoom.us/j/2489867333		Email: wenchen@cs.und.edu
Office hours: 02:30pm – 04:30pm, MoWeFr
Prerequisite: CSCI 455 Database Management Systems
Synchronous class delivery: The class lectures will be delivered synchronously via https://und.zoom.us/j/2489867333, and the Zoom video will be posted on the Blackboard afterwards.
Lecture notes: No textbook will be used. Instead award-winning, interactive, informative, and practical lecture notes (based on books, papers, online documents, and user manuals) and detailed and precise class instructions will be provided. Collectively, the lecture notes and instructions are more like a small book, which supplies much more information than regular notes do and makes the subject studies much easier. Students will not have problem learning the subjects or taking the exams after studying them and doing programming exercises.

---

Grading: Grade information Programming exercises Programming exercise guidelines Examination guidelines

---

Announcements:

• Updated constantly: Class notes:
  • undcemcs02 (most up-to-date and requiring a VPN connection)
  • undcemcs01 (no VPN required, but may not be up-to-date)


• Tuesday, December 12: Final Exam to be held at 6:30pm-8:00pm for both on-campus and on-line students.
• Tuesday, December 05: Final Exam Rules and Question Distribution posted.
• Thursday, December 07: Programming Exercise III due.
• Saturday, November 04: Programming Exercise III posted.
• Tuesday, November 14: Exam II to be held at 6:30pm-8:00pm for both on-campus and on-line students.
• Wednesday, November 01: Exam II Rules and Question Distribution posted.
• Thursday, November 09: Programming Exercise II due.
• Friday, October 06: Programming Exercise II posted.
• Tuesday, October 03: Exam I to be held at 6:30pm-8:00pm for both on-campus and on-line students.
• Monday, September 25: Exam I Rules and Question Distribution posted.
• Saturday, September 09: The complete ~/.profile file is here.
• Saturday, September 09: Check a simple CGI test page at
  
      A CGI Test Page
  
  If you follow it very carefully, you should be able to make the CGI scripts work.
• Thursday, September 28: Programming Exercise I due.
• Monday, August 28: Programming Exercise I posted.
• Monday, August 21: To extend the connection time of SQL Developer, use the following method:
  
  You could turn DBMS output (like collection types) on and setting the polling frequency (refresh) to once every 2 minutes or so by selecting the following SQL Developer options:

     Reports ⇒ Data Dictionary Reports ⇒ All Objects ⇒ Collection Types ⇒
        Select Connection ⇒ Enter Bind Values ⇒ Refresh ⇒ 120

• Monday, August 21: Execute the following command at the server undcemcs02. Otherwise, your CGI scripts will not work.
  
  
  shell> chcon -R -t httpd_user_content_t /home/”USER.ID”/public_html 
  
  Swap out “USER.ID” with your login name:
  
  
  shell> chcon -R -t httpd_user_content_t /home/first.lastname/public_html 
  
  
• Monday, August 21: Register this course via Course Registration.

According to IT Career Finder, Best Computer Jobs for the Future (05/18/2023) are listed as follows:

IT security specialist (not developer)  Mobile application developer  Software engineer Video game designer (including developer) Computer systems analyst (not developer)  Web developer  Health information technician Technology manager  Database administrator (including developer)  Network administrator (not developer)

Computer science is different from many other disciplines (like electrical engineering). It is more like a professional school (such as culinary schools), which emphasizes practical works instead of subject studies because many IT companies want the new recruitees to start contributing immediately. There are three kinds of computing personnel:

• Developers:
  
  
  • Positions (plenty): Developers of front-end and back-end web pages, mobile apps, and all kinds of software
  • Skills (more stable): Programming languages (such as C++ and Java), web programming, mobile app development, data processing and management including databases, and data structures & algorithms


• Practitioners:
  
  
  • Positions (not many): Experienced personnel like data scientists, database or system administrators, security analysts, and network architects (more applications & configuration and less development)
  • Skills (based on the needs of companies): Databases, data warehousing, data lake, Hadoop, MapReduce, Linux, SPSS, SAS, Cogno, Matlab, Tableau, etc.


• Researchers:
  
  
  • Industrial positions (few and based on the needs of corporations): High quality personnel required for the advanced areas like artificial intelligence, security, computer vision, autonomous driving, and speech recognition
  • Academic positions/trends (few and changed according to the government policies): ❓ ⇐ artificial intelligence ⇐ big data ⇐ high-performance computing ⇐ security ⇐ (mobile) networks

Unless you have an impressive resume or a strong connection, practicing tens or hundreds of questions posted at the LeetCode is a must in order to secure a job at corporations (like Google and Facebook). Otherwise, your chance of answering the questions correctly is low because of their high difficulty and time constraint. In addition, you need to create LinkedIn pages to show your achievements, and may consider uploading your projects to the GitHub to showcase them.

---

Remark I: Definitions, terminologies, and theories will be discussed minimally in this course. Instead practical works and programming knowledge will be emphasized and enforced. The old technology, CGI (Common Gateway Interface), will be used to connect the Web to JDBC (Java Database Connectivity) programs because of the limited resources provided by the CEM, but CGI has no problem implementing the features used by other technologies (like ASP.NET or PHP). Also, the focus of this course is on databases, instead of Web-database connection.

Remark II: Database technologies like programming languages have no breakthroughs for years, so old, new, these, or those textbooks are pretty much the same. In other words, not much database research is left to do. However, databases are still a useful tool for other research areas like data science including data (web) mining and discovery, information retrieval, and mobile data management (e.g., location-based services). Don’t mention databases are a must tool for many applications such as e/m-commerce sites and IT systems.

Remark III: This is an advanced database course, so the instructor assumes that you have fundamental database knowledge like SQL. For further advanced topics, check CSci515 Data Engineering and Management using the methods of data mining and data science. For fundamental databases, check CSci455 Database Management Systems.

Remark IV: Online asynchronous is also provided for the distance students. It is conducted fully through Internet instruction. For details, check UND Online & Distance Education or DEDP (Distance Engineering Degree Program). Besides, https://und.zoom.us/j/2489867333 or YuJa is used for hosting and sharing lecture videos, and ProctorU may be used to monitor the exams.

Remark V: Web, mobile, and database programming is a must for IT developers, and the only effective way to learn software development is practicing, instead of studying concepts or writing some testing programs.

No pain, no gain 😂

Remark VI: According to a study, students in computer-science courses learn much more by building large-scale exercises instead of many small-scale test programs, which give fragmented knowledge contrary to solid understanding of the system.

Remark VII: Remote work is a trend for IT workers. This course also allows you to learn how to do it by using the VPN (virtual private networks) to connect to our Linux server undcemcs02.und.edu, and having the exercises set up at the server and be accessed from the clients.

Instructor’s qualification: The instructor’s PhD dissertation is titled “An image database system based on a linear skeleton representation,” which includes a database-driven web system by using Perl and Sybase in 1997, when not many people were familiar with the Web. In fact, all his research to date uses or relates to databases, but not tries to build or enhance a DBMS (database management system). In addition, he is familiar with many kinds of databases like Oracle, MySQL, Google Firebase, SQLite, Microsoft Access, Sybase, and MongoDB.

---

University of North Dakota Course Descriptions (CSCI 513) —
An advanced study of database system architecture, implementation, and applications, with emphasis on the object-oriented, object-relational, and embedded data models, and new database advancements including research and practical issues in database systems and data science.

Database Outline —
A collection of information organized in such a way that a computer program can quickly select desired pieces of data. To access information in a database, you need a database management system (DBMS), which is a collection of programs that enables you to enter, organize, and select data in a database.

Object-Oriented Database Outline —
An object-oriented database system is a system offering DBMS facilities in an object-oriented programming environment. Data is stored as objects and can be interpreted only using the methods specified by its class. The relationship between similar objects is preserved (inheritance) as are references between objects. Queries can be faster because joins are often not needed (as in a relational database). This is because an object can be retrieved directly without a search, by following its object ID. The same programming language can be used for both data definition and data manipulation. The full power of the database programming language’s type system can be used to model data structures and the relationship between the different data items.

A System Structure of a Generic Web-Enabled Database System —


Client-Side Mobile/Handheld Programming Steps —


An Internet-Enabled and Mobile Database Course Sequence —
This is part of an Internet/mobile-enabled database course sequence offered by me:

CSCI 260 .NET and World Wide Web Programming
⇓
CSCI 457 Electronic and Mobile Commerce Systems
⇓
DATA 520 Databases
⇓
CSCI 513 Advanced Database Systems
⇓
CSCI 515 Data Engineering and Management
⇓
DATA 525 Data Engineering and Mining

The following platforms, software, and tools used in these courses greatly help students land a decent job:

• CSCI 260 (.NET and World Wide Web Programming) to build database-driven websites by using
  
  
  • Microsoft Access database,
  • Microsoft ASP.NET,
  • Microsoft C# or Visual Basic,
  • Microsoft .NET, and
  • Microsoft Visual Studio.


• CSCI 457 (Electronic and Mobile Commerce Systems) to build electronic and mobile commerce systems by using
  
  
  • Android programming,
  • Android-server-database connection,
  • (L) Linux operating system,
  • (A) Apache web server,
  • (M) MySQL database, and
  • (P) PHP.


• DATA 520 (Databases) to build Internet/mobile-enabled database systems by using
  
  
  • Android programming,
  • Android-server-database connection,
  • JDBC (Java Database Connectivity),
  • Oracle database, and
  • Relational database design and SQL.


• CSCI 513 (Advanced Database Systems) to build Internet-enabled and embedded database systems by using
  
  
  • Android programming,
  • Android SQLite embedded database,
  • JDBC (Java Database Connectivity),
  • Object-relational SQL and PL/SQL, and
  • Oracle (an object-relational database).


• CSCI 515 (Data Engineering and Management) to build location-based services and data-mining systems to discover knowledge from a large set of data by using
  
  
  • Android programming,
  • Android Google APIs and Firebase database,
  • Data mining and knowledge discovery,
  • Information retrieval,
  • Location-based services, and
  • Smartphones and mobile handheld devices.


• DATA 525 (Data Engineering and Mining) to build Internet-enabled data-mining systems to discover knowledge from a large set of data by using
  
  
  • Data mining and knowledge discovery,
  • Internet-enabled Firebase database,
  • Information retrieval, and
  • Internet-enabled TensorFlow.