Oracle
Java_Super_Man
这个作者很懒,什么都没留下…
展开
-
Table Clusters
Table Clusters原创 2013-10-19 17:40:56 · 1147 阅读 · 0 评论 -
Tablespaces
A tablespace is a logical storage container for segments. Segments are database objects, such as tables and indexes, that consume storage space. At the physical level, a tablespace stores data in on原创 2013-11-05 17:37:59 · 1391 阅读 · 0 评论 -
Data Blocks
Data Blocks Oracle Database manages the logical storage space in the data files of a database in units called data blocks, also called Oracle blocks or pages. A data block is the minimum原创 2013-11-05 10:54:25 · 1354 阅读 · 0 评论 -
Logical Storage Structures
Introduction to Logical Storage Structures Oracle Database allocates logical space for all data in the database. The logical units of database space allocation are data blocks, extents, segme原创 2013-11-05 09:32:55 · 1921 阅读 · 0 评论 -
Segments
A segment is a set of extents that contains all the data for a logical storage structure within a tablespace. For example, Oracle Database allocates one or more extents to form the data segment for原创 2013-11-05 15:28:51 · 1243 阅读 · 0 评论 -
Extents
Overview of Extents An extent is a logical unit of database storage space allocation made up of contiguous data blocks. Data blocks in an extent are logically contiguous but can be physical原创 2013-11-05 14:47:31 · 1425 阅读 · 0 评论 -
Oracle Database Locking Mechanism
A lock is a mechanism that prevents destructive interactions, which are interactions that incorrectly update data or incorrectly alter underlying data structures, between transactions accessing shar原创 2013-11-04 11:32:17 · 1366 阅读 · 0 评论 -
Index-Organized Tables
Index-Organized Tables原创 2013-10-28 22:42:03 · 989 阅读 · 0 评论 -
Index Scans
Index Scans原创 2013-10-21 17:31:12 · 901 阅读 · 0 评论 -
Sequences
Sequences原创 2013-10-20 16:41:16 · 678 阅读 · 0 评论 -
Partitions
Partitions原创 2013-10-20 12:24:16 · 1778 阅读 · 0 评论 -
Materialized Views
Materialized Views原创 2013-10-20 13:59:38 · 1358 阅读 · 0 评论 -
Partitioned Indexes
Partitioned Indexes原创 2013-10-20 13:12:05 · 1464 阅读 · 0 评论 -
Types of Indexes
index原创 2013-10-19 17:59:08 · 1021 阅读 · 0 评论 -
Bitmap Join Indexes
A bitmap join index is a bitmap index for the join of two or more tables. For each value in a table column, the index stores the rowid of the corresponding row in the indexed table. In contrast, a s原创 2013-10-19 19:42:39 · 1602 阅读 · 0 评论 -
Function-Based Indexes
Function-Based Indexes原创 2013-10-19 18:28:02 · 1117 阅读 · 0 评论 -
Dynamic Performance Views
Dynamic Performance Views原创 2013-10-20 16:19:17 · 1646 阅读 · 0 评论 -
Data Dictionary
Data Dictionary原创 2013-10-20 15:31:00 · 1638 阅读 · 0 评论 -
Oracle数据建模器---data modeler 简介
目前以下几个功能可以提高工作当中的数据库开发效率,以及可以利用此工具理解现有数据的关系。其他功能未做深入调研。1、根据数据字典生成关系模型。2、关系模型与逻辑模型的相互转化。3、通过设计逻辑模型转化为关系模型,此时可以导出ddl以及可以直接同步到连接的数据库。4、方案的版本化管理。原创 2013-12-05 10:53:59 · 6077 阅读 · 0 评论