Data Warehousing / Business Intelligence
The mission statement of CLD's data warehousing / business intelligence (DW/BI) practice is: "minimizing decision latency through actionable insights". As evident from our mission statement, we believe that the essence in unlocking value is business focus. CLD's DW/BI practice can help release the potential locked in your organization's data to support quick and effective decision-making.

CLD utilizes a robust and detailed methodology that leverages fundamental architecture principles to deliver nimble and scalable solutions to the customers. CLD, based on its multi-technology domain experience in offshore development has developed a Model for BI delivery. This model draws a fine balance between onsite and offshore work and bolstered by robust processes and templates, delivers a cost effective solution to customers.

Database Design & Implementation

• Schema Design Review, Physical Tablespace Layout
• Oracle Installation, Database Creation, Alteration, and Setup
• Oracle Database File Management
• Oracle Storage Segment Administration Including Table, Index, LOB, Rollback, and Temporary Segments
• Oracle Memory Segment Administration Including Library Cache, Data Dictionary Cache, Buffer Cache, Redo Log Buffer, and Java Pool
• Oracle Network Connectivity Management
• Database User Administration Including User Creation, Quota Assignment, Object-level Privilege Administration, Security Management, and Role Creation

Security Administration

• Layered Security Management
• Security Risks Assessment
• Security Checks Performed
• Security Administration Services Rendered

Disaster recovery

• Hot stand by implementation
• Tape/Disk back solutions