Updated on 2024-05-07 GMT+08:00

Database Logical Architecture

Data nodes (DNs) in GaussDB store data on disks. This section describes the objects on each DN from the logical view and the relationship between these objects. Figure 1 shows the database logical structure.

Figure 1 Database logical architecture
  • A tablespace is a directory. A database contains one or more tablespaces to store physical files of the database. Each tablespace can contain files belonging to different databases.
  • A database manages various data objects and is isolated from each other. Objects managed by a database can be distributed to multiple tablespaces.
  • A datafile segment stores data of only one table. A table containing more than 1 GB of data is stored in multiple datafile segments.
  • One table belongs to only one database and one tablespace. The datafile segments storing the data of the same table must be in the same tablespace.
  • A block is a basic unit for database management. Its default size is 8 KB.