Course Objectives
In this course, we will lecture on basic methods for the construction and operation of databases. Specifically, we will deal with data modeling for storing real-world data in a computer, methods for storing and retrieving large amounts of data efficiently in a computer, languages for defining and querying data, and controls for enabling simultaneous use of data among many users. We will understand the concepts of databases and learn the knowledge and skills of key areas of expertise, such as designing for data management and programming with database language SQL. The goal is to enable students to flexibly address data management issues and design a specific system that will adapt to the challenges using expertise and expertise in the field of expertise.
Rubric
| Ideal Level | Standard Level | Unacceptable Level |
Achievement 1 | Understand how to model data and to store and retrieve large amounts of data efficiently in a computer, and can design a system. | Understand how to model data and to store and retrieve large amounts of data efficiently in a computer. | Do not understand how to model data and to store and retrieve large amounts of data efficiently in a computer. |
Achievement 2 | Can perform programming by database language SQL and operate a system. | Understand programming by database language SQL and the system. | Do not understand programming with database language SQL, and the system. |
Assigned Department Objectives
Teaching Method
Outline:
It is important to keep programs and data separate and under control. Learn about technologies that make data available for long-term, stable use by understanding the widely used database system as a way to manage data independently. In this course, students will learn what data is, what the database manages, and how it is implemented.
The lectures will be conducted by a teacher who engaged in the research and development of middleware (database) at Hitachi, Ltd. Research & Development Headquarters for five years.
Style:
Classes and exercises
Notice:
It is a prerequisite that a student to master at least one programming language. Knowledge of data structures and algorithms is desirable.
Students who miss 1/3 or more of classes will not be eligible for a passing grade.
Characteristics of Class / Division in Learning
Course Plan
|
|
|
Theme |
Goals |
2nd Semester |
3rd Quarter |
1st |
Outline of the database |
Understand the role of the database, the academic use and the business use of the database, , and the significance and application of the database.
|
2nd |
Basic theories for databases |
Understand basic theories for databases, such as sets and their operations, tuples, and relations of sets
|
3rd |
Relational data model and relational algebra |
Understand the relational data model, which is the data model utilized by RDBMS, and the relational algebra for data manipulation.
|
4th |
SQL(1) |
Understand the basics of SQL, the language used in the general use of RDBMS. Understand basic usage of SQL including data registration, deletion, and update of relations, and simple queries.
|
5th |
SQL(2) |
Can write SQL, a language that is used for general usage of RDBMS. Understand the select statement that queries in SQL.
|
6th |
Internal configuration of the RDBMS |
Understand the internal structure of RDBMS and the indexes, which are the mechanisms for quick access of the data of interest from a large amount of data.
|
7th |
Query optimization |
Understand query optimization in RDBMS to generate execution plans for executing SQL queries.
|
8th |
Midterm exam |
Midterm exam
|
4th Quarter |
9th |
Normalization |
Understand possible data inconsistencies when updating relationships and the normalization of the relationships as the solution.
|
10th |
Data Modeling |
Understand data modeling, a work to determine the scope of the database in the real world, determining the appropriate data structure by extracting and organizing data items, and .
|
11th |
SQL(3) |
Can write SQL, a language that is used for general usage of RDBMS. Understand the advanced select statement for SQL queries.
|
12th |
Transaction and concurrency control |
Understand the concept of transactions, the units in which an application accesses a database, and the basic theory for successful execution of multiple transactions.
|
13th |
NoSQL databases and big data (1) |
Understand the basics of NoSQL, a new database developed to handle big data. Understand NoSQL in general and the data model and execution control theory to handle big data.
|
14th |
NoSQL databases and big data (2) |
Learn the basics of NoSQL, a new database developed to handle big data. Understand parallel distributed processing techniques for large data and distributed processing techniques on NoSQL.
|
15th |
Using RDBMS from programs |
Understand how to use RDBMS from programs written in a generic programming language.
|
16th |
Final exam
|
Final exam
|
Evaluation Method and Weight (%)
| Examination | Presentation | Mutual Evaluations between students | Behavior | Portfolio | Other | Total |
Subtotal | 60 | 0 | 0 | 0 | 40 | 0 | 100 |
Basic Proficiency | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Specialized Proficiency | 60 | 0 | 0 | 0 | 40 | 0 | 100 |
Cross Area Proficiency | 0 | 0 | 0 | 0 | 0 | 0 | 0 |