http://www.oraclefaq.net/logical-structure-of-database/
Logical structure mainly consists of tablespace, segments, extents, and oracle data blocks
TABLESPACE
Each database is logically divided into one or more
tablespaces. One or more datafiles are explicitly created for each
tablespace to physically store the data of all logical structures in a
tablespace. The combined size of the datafiles in a tablespace is the
total storage capacity of the tablespace.
SEGMENT
A segment is a set of extents allocated for a certain logical
structure. The segments can be of one of following type data
segment,index segment,temporary segment,rollback segment.
EXTENT
The next level of logical database space is an extent. An
extent is a specific number of contiguous data blocks, obtained in a
single allocation, used to store a specific type of information.
ORACLE DATABLOCKS
At the finest level of granularity, Oracle database data is
stored in data blocks. One data block corresponds to a specific number
of bytes of physical database space on disk. The standard block size is
specified by the DB_BLOCK_SIZE initialization parameter. In addition,
you can specify up to five other block sizes.
分享到:
相关推荐
What information is necessary when specifying the structure of a table? (a) the name of the table and the amount of storage space to be allocated to the table (b) the name of the table, the ...
- **逻辑数据独立性(Logical Data Independence)**:指的是应用程序与数据逻辑结构之间的独立性。当数据的逻辑结构改变时,应用程序不必随之更改。 **1.8 章节总结** - 本章介绍了数据库系统的基本概念,包括...
3. Logical structure design is to design the logical structure of the database, including relationship diagrams and data dictionaries. 4. Physical structure design is to design the physical structure ...
Physical Database Structure 1-15 Tablespaces and Data Files 1-17 SYSTEM and SYSAUX Tablespaces 1-18 Segments, Extents, and Blocks 1-19 Logical and Physical Database Structures 1-20 Course Examples: ...
The database design involves creating an entity relationship (ER) diagram to represent the logical structure of the data, ensuring data consistency and integrity. The data dictionary details the ...
The DFD illustrates how data moves through different parts of the system, while the ER diagram represents the logical structure of the database, defining entities, relationships, and attributes....
look at structure x$kcbsw which is a list of all the functions that Oracle might call to visit a block You will find for 11 2 0 2 that there are 1 164 different functions for doing a logical I O do ...
- **Operators**: Overview of arithmetic, relational, logical, and concatenation operators. - **Control Structures**: Advanced usage of loops, conditional statements, and other flow control mechanisms....
Adopting a three-tier B/S structure after analysis, it selects Oracle 11G as the database considering system functionality and expansion demands, followed by a logical structure design. In module ...
Each section of this book organizes topics into logical groups so the book can be read cover-to-cover or can be used as a reference guide for specific topics. We start with an introduction to the T-...
As mentioned, we tried to follow a logical order in the structure of this book, but like most technical books, it is not absolutely essential to read it in any particular order. However, if you are ...
In terms of system design, the entity relationship (ER) diagram plays a vital role in modeling the database structure, ensuring clear relationships between entities. The data dictionary further ...
Data flow diagrams further illustrate how information flows through the system, helping in understanding the system's logical structure. The detailed design stage outlines the technical ...
In conclusion, the development of the library borrowing management system using JSP and Mysql database demonstrates the application of modern IT techniques in improving organizational efficiency....
**3.5 逻辑数据库设计:从ER到关系 (Logical Database Design: ER to Relational)** - 逻辑设计是将概念设计转换为具体的数据库表的过程。 - **3.5.1 实体集到表 (Entity Sets to Tables)** - 每个实体集通常对应...
- **XML Basics:** Explanation of XML syntax and structure. - **DOM and SAX:** Overview of DOM (Document Object Model) and SAX (Simple API for XML) parsing techniques. - **Creating XML Documents:** ...
R diagram and database logical structure, hierarchical diagram, system flowchart, and program flowchart, to analyze and design the data needs, database, system software structure, system flow, and ...