Tag: database system

[DatabaseSystem] Database Storage 1
September 5, 2018

[DatabaseSystem] Database Storage 1

Today we would focus on how data organized in disk. DBMS would assume that the primary storage is lied on the non-volatile storage. Storage Hierarchy Overview Typical Storage Layer: cpu register cpu cache DRAM (Non-volitile memory) SSD HDD Network Storage Usually data is moved from …

Programming
-
by user
-
0 Comments
[DatabaseSystem] Advanced SQL
September 1, 2018

[DatabaseSystem] Advanced SQL

SQL is a kinf of relational languages, in which users only need to specify the answer that they want, not how to compute it. The DBMS is reponsible for efficient evaluate and optimize the query.

Programming
-
by user
-
0 Comments
[DatabaseSystem] Database Introduction And Relational Model
September 1, 2018

[DatabaseSystem] Database Introduction And Relational Model

Database System is an organized collection of inter-related data that models some aspect of the real-world. Databases are core of most computer applications. Before the whole course discussion, first question is that why we need database system.

Programming
-
by user
-
0 Comments