- 博客(4)
- 收藏
- 关注
RSS订阅Type 3 Slowly Change Dimension(原创)
Type 3 ChangesIn most dimensional schemas, the bulk of changes to source data generate type 1 and type 2 changes. Occasionally, neither technique satisfies. A third type of change response is called ...
2015-05-26 20:05:38
375
The Hybrid Response(原创)
The Hybrid ResponseWhen requirements call for changed data to result in both type 1 and type 2 behavior, the solution is disarmingly simple: provide for both. This cannot be achieved with a single a...
2015-05-26 19:05:56
131
原创 Oracle 锁与锁争用
大多数的锁都是行级锁，它们防止两个会话修改相同的行。事务的ACID（原子性、一致性、隔离性和持久性）属性，特别是一致性，它要求Oracle限制对表数据的并发修改。锁（lock）机制用于管理对共享资源的并发访问，Oracle也会在其他多个级别上使用锁，从对多种不同的资源提供并发访问。例如过程，当一个过程正在运行时，过程本身会以某种模式锁定，它允许其他的用户执行这个过程，但不允许其他的用户以任何的...
2015-05-08 02:13:55
482
Type 2 Slowly Change Dimension with Timestamp(原创)
Time-Stamped DimensionsIf there is any uncertainty about requirements for historic data, the most common response to changes in source data is the type 2 slowly changing dimension.It is the safe choi...
2015-05-04 03:24:25
245
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人