-
编辑 删除
The Oracle Background Processes for Sybase Pros
The Oracle Background Processes for Sybase Pros a introduce document of oracle[@more@]Page 1 The Oracle Background Processes for Sybase Pros By Mich Talebzadeh September 2006 In this article we will be looking at the Oracle background processes and what they mean. Mich Talebzadeh is a consultant and a technical architect who has worked with Sybase and other databases since the early 1990s. He is the co-author of the book “Sybase Transact SQL Programming Guidelines and Bes
-
编辑 删除
LGWR group commits（原）
LGWR group comments the transactions when there are more than one transactions commited while the previous commition processed.[@more@]In times of high activity, LGWR can write to the redo log file using group commits. For example, assume that a user commits a transaction. LGWR must write the transaction's redo entries to disk, and as this happens, other users issue COMMIT statements. However, LGWR cannot write to the redo log file to commit these transactions until it has completed its previous
-
编辑 删除
Performing Tablespace Point-in-Time Recovery with Recovery Manager（转）
I went over TSPITR.[@more@]Performing Tablespace Point-in-Time Recovery with Recovery Manager This chapter describes how to use Recovery Manager (RMAN) to perform tablespace point-in-time recovery (TSPITR), and includes the following topics: Introduction to RMAN TSPITR Planning for TSPITR Preparing the Auxiliary Instance for TSPITR Performing TSPITR Preparing the Target Database for Use After TSPITR Responding to Unsuccessful TSPITR Tuning TSPITR Performance Intr
-
编辑 删除
Data Quality and Data Cleaning
Data Quality and Data Cleaning[@more@]Data QualityETL Data CleaningModel DesignBusiness RuleExample:Verify Data with Decision Tree AlgorithmUtility:Firstlogic of BOInformaticaReference:数据质量评估框架－通用框架http://dsbb.imf.org/vgn/images/pdfs/dqrsdqaf新形势下提高统计数据质量的思考http://www.statistic.hainan.gov.cn/ReadNews.asp?NewsID=225统计数据质量涵义之我见http://www.stats.gov.cn/tjshujia/tjjy/t20050330_402239632.htmData Quality Tools for Data Warehousing - A Small Sample Surveyhttp://www.
-
编辑 删除
ETL和EAI比较
ETL和EAI比较[@more@]整合出来的文章，仅供参考，:)什么是EAI?企业的业务流程会同时涉及到多个应用系统，因此要求这些系统能够协同，但接口、架构的不统一往往使得这些本应紧密集成的应用系统成为了一个个“信息孤岛”。于是，企业应用集成（EnterpriseApplication Integration，EAI）技术应运而生，它可以通过中间件作为粘合剂来连接企业内外各种业务相关的异构系统、应用以及数据源，从而满足E-Commerce、ERP、CRM、SCM、OA、数据库、数据仓库等重要系统之间无缝共享和交换数据的需要。EAI 涉及技术广泛，实施复杂。基本特征EAI 的核心是
