Bmlumxkhasuploaded_XXXX年司法考试刑事诉讼法大纲对比下载

http://www.realdba.net/category/db/orcl/basic/[e-mail]xtViewPDF目录PrefaceAudienceDocumentationAccessibilityRelatedDocumentationConventions序言听众文档可访问性相关文档约定1IntroductiontoOracleDatabaseAboutRelationalDatabasesoDatabaseManagementSystem(DBMS)oRelationalModeloRelationalDatabaseManagementSystem(RDBMS)oBriefHistoryofOracleDatabaseSchemaObjectsoTablesoIndexesDataAccessoStructuredQueryLanguage(SQL)oPL/SQLandJavaTransactionManagementoTransactionsoDataConcurrencyoDataConsistencyOracleDatabaseArchitectureoDatabaseandInstanceoDatabaseStorageStructuresoDatabaseInstanceStructuresoApplicationandNetworkingArchitectureOracleDatabaseDocumentationRoadmap第1章Oracle数据库简介关于关系数据库o数据库管理系统(DBMS)o关系模型o关系数据库管理系统(RDBMS)oOracle数据库发展简史模式对象o表o索引数据访问o结构化查询语言(SQL)oPL/SQL和Java事务管理o事务o数据并发性o数据一致性Oracle数据库体系结构o数据库和实例o数据库存储结构o数据库实例结构o应用程序和网络体系结构http://www.realdba.net/category/db/orcl/basic/[e-mail]ateGroupoAdvancedGroupOracle数据库文档路线图o基本组o中级组o高级组PartIOracleRelationalDataStructures第一部分Oracle关系数据结构2TablesandTableClustersIntroductiontoSchemaObjectsoSchemaObjectTypesoSchemaObjectStorageoSchemaObjectDependenciesoSYSandSYSTEMSchemasoSampleSchemasOverviewofTablesoColumnsandRowsoExample:CREATETABLEandALTERTABLEStatementsoOracleDataTypesoIntegrityConstraintsoObjectTablesoTemporaryTablesoExternalTablesoTableStorageOverviewofTableClustersoOverviewofIndexedClustersoOverviewofHashClusters第2章表和表簇模式对象简介o模式对象类型o模式对象存储o模式对象依赖oSYS和SYSTEM模式o示例模式表概述o列和行o示例：CREATETABLE和ALTERTABLE语句oOracle数据类型o完整性约束o对象表o临时表o外部表o表存储表簇概述o索引化表簇概述o哈希簇概述3IndexesandIndex-OrganizedTablesOverviewofIndexesoIndexCharacteristicsoB-TreeIndexesoBitmapIndexesoFunction-BasedIndexesoApplicationDomainIndexes第3章索引和索引组织表索引概述o索引特征oB-树索引o位图索引o基于函数的索引http://www.realdba.net/category/db/orcl/basic/[e-mail]OverviewofIndex-OrganizedTablesoIndex-OrganizedTableCharacteristicsoIndex-OrganizedTableswithRowOverflowAreaoSecondaryIndexesonIndex-OrganizedTableso应用程序域索引o索引存储索引组织表概述o索引组织表特征o索引组织表的行溢出区o索引组织表的辅助索引4Partitions,Views,andOtherSchemaObjectsOverviewofPartitionsoPartitionCharacteristicsoPartitionedTablesoPartitionedIndexesoPartitionedIndex-OrganizedTablesOverviewofViewsoCharacteristicsofViewsoUpdatableJoinViewsoObjectViewsOverviewofMaterializedViewsoCharacteristicsofMaterializedViewsoRefreshMethodsforMaterializedViewsoQueryRewriteOverviewofSequencesoSequenceCharacteristicsoConcurrentAccesstoSequencesOverviewofDimensionsoHierarchicalStructureofaDimensionoCreationofDimensionsOverviewofSynonyms第4章分区、视图和其它模式对象分区概述o分区特征o分区表o分区索引o分区索引组织表视图概述o视图特征o可更新联合视图o对象视图物化视图概述o物化视图的特征o物化视图的刷新方法o查询重写序列概述o序列概述o对序列的并发访问维度概述o维度的层次结构o创建维度同义词概述5DataIntegrityIntroductiontoDataIntegrityoTechniquesforGuaranteeingDataIntegrityoAdvantagesofIntegrityConstraints第5章数据完整性数据完整性介绍o用于保证数据完整性的技术o完整性约束的优势http://www.realdba.net/category/db/orcl/basic/[e-mail]TypesofIntegrityConstraintsoNOTNULLIntegrityConstraintsoUniqueConstraintsoPrimaryKeyConstraintsoForeignKeyConstraintsoCheckConstraintsStatesofIntegrityConstraintsoChecksforModifiedandExistingDataoDeferrableConstraintsoExamplesofConstraintChecking完整性约束的类型o非空完整性约束o唯一性约束o主键约束o外键约束o检查性约束完整性约束的状态o对现有数据和新数据的检查o可延迟约束o约束检查的示例6DataDictionaryandDynamicPerformanceViewsOverviewoftheDataDictionaryoContentsoftheDataDictionaryoStorageoftheDataDictionaryoHowOracleDatabaseUsestheDataDictionaryOverviewoftheDynamicPerformanceViewsoContentsoftheDynamicPerformanceViewsoStorageoftheDynamicPerformanceViewsDatabaseObjectMetadata第6章数据字典和动态性能视图数据字典概述o数据字典的内容o数据字典存储oOracle数据库如何使用数据字典动态性能视图概述o动态性能视图的内容o动态性能视图的存储数据库对象元数据PartIIOracleDataAccess第二部分Oracle数据访问7SQLIntroductiontoSQLoSQLDataAccessoSQLStandardsOverviewofSQLStatementsoDataDefinitionLanguage(DDL)StatementsoDataManipulationLanguage(DML)StatementsoTransactionControlStatementsoSessionControlStatementsoSystemControlStatement第7章SQLSQL简介oSQL数据访问oSQL标准SQL语句概述o数据定义语言(DDL)语句o数据操作语言(DML)语句o事务控制语句o会话控制语句o系统控制语句http://www.realdba.net/category/db/orcl/basic/[e-mail]sOverviewoftheOptimizeroUseoftheOptimizeroOptimizerComponentsoAccessPathsoOptimizerStatisticsoOptimizerHintsOverviewofSQLProcessingoStagesofSQLProcessingoHowOracleDatabaseProcessesDMLoHowOracleDatabaseProcessesDDLo嵌入式的SQL语句优化器概述o使用优化器o优化器组件o访问路径o优化器统计o优化器提示SQL处理的概述oSQL处理的阶段oOracle数据库如何处理DMLoOracle数据库如何处理DDL8Server-SideProgramming:PL/SQLandJavaIntroductiontoServer-SideProgrammingOverviewofPL/SQLoPL/SQLSubprogramsoPL/SQLPackagesoPL/SQLAnonymousBlocksoPL/SQLLanguageConstructsoPL/SQLCollectionsandRecordsoHowPL/SQLRunsOverviewofJavainOracleDatabaseoOverviewoftheJavaVirtualMachine(JVM)oJavaProgrammingEnvironmentOverviewofTriggersoAdvantagesofTriggersoTypesofTriggersoTimingforTriggersoCreationofTriggersoExecutionofTriggersoStorageofTriggers第8章服务器端编程：PL/SQL和Java服务器端编程简介PL/SQL概述oPL/SQL子程序oPL/SQL包o