ISYS2120

Data & Information Management

The ubiquitous use of information technology leaves us facing a tsunami of data produced by users, IT systems and mobile devices. The proper management of data is hence essential for all applications and for effective decision making within organizations. This unit of study will introduce the basic concepts of database designs at the conceptual, logical and physical levels. We will place particular emphasis on introducing integrity constraints and the concept of data normalization which prevents data from being corrupted or duplicated in different parts of the database. This in turn helps in the data remaining consistent during its lifetime. Once a database design is in place, the emphasis shifts towards querying the data in order to extract useful information. The unit will introduce the SQL database query languages, which is industry standard. Other topics covered will include the important concept of transaction management, application development with a backend database, and an overview of data warehousing and OLAP. 无处不在的信息技术使我们面临着用户，IT系统和移动设备产生的数据海啸。因此，适当的数据管理对于所有应用程序和组织内的有效决策至关重要。 本单元将在概念，逻辑和物理层面介绍数据库设计的基本概念。我们将特别强调引入完整性约束和数据规范化概念，以防止数据在数据库的不同部分被破坏或重复。这反过来有助于数据在其生命周期内保持一致。一旦数据库设计到位，重点就转移到查询数据以提取有用信息。该单元将介绍SQL数据库查询语言，这是行业标准。涵盖的其他主题包括事务管理的重要概念，使用后端数据库的应用程序开发，以及数据仓库和OLAP的概述。 本课程介绍是由往届学长学姐回忆编辑而成。 简介：编程语言为SQL，这门课是Advanced Computing学位的必修课，是一门基础的数据库课程，这门课包涵了数据库的基础知识以及SQL语句，Assignment也很对应Lecture上所学的内容和知识，是一门很有用的课。 Tutor简评： 1. 这门课为Double Pass 2. 需要花时间不断练习 3. 比较容易拿高分