全部博文
-
编辑 删除
Business Intelligence Questions
概念来自于Oracle 数据库文档“Concepts”的Business Intelligence一章。#1 - What is ETL The process of extracting data from source systems and bringing it into the data warehouse is commonly called ETL,...
-
编辑 删除
Architecture
Physical StructuresDatafilesEvery Oracle database has one or more physical datafiles. The datafiles contain all the database data. Tables and indexes are also stored in the datafiles.Control FilesEv...
-
编辑 删除
运行一个语句的过程
1、运行一个语句的过程(1) 将SQL语句经过hash算法后得到一个值hash value.(2) 如果该值在内存中存在，那么叫命中软分析(3) 如果该值不存在，执行硬分析 (4) 语法分析: 进行语法分析，看语法...
