InfoKarta Inc.
Home
About us
Content

Welcome ...

VDM , VLDB and Data Warehouse Design:

We are architects/designers of data warehouse and VLDB systems since the early 90s and provide specialized consulting services and customized solutions to businesses that build and maintain large data warehouses.

We call our methodogy "The Versioned Dimensional Model" (VDM). It originated in 1991, before dimensional modeling was publicized by Kimball. The earliest publications (1992) were in the Relational Journal (Codd and Date's Relational Institute) and later through the 90s in trade magazines and presented in conferences. Since 2000 various white papers and reports have been only available to existing and prospective customers upon request.

VDM is more of a practitioner's notebook and a toolbox than a sequential process, appropriate for robust data warehousing and decision support environments of a wide spectrum of complexity and size.
 
We specialize in parallel DB2/UDB.

Aggregation Strategy Deployment:

We offer an Aggregation Strategy and Architecture rapid deployment program that helps IT organizations harvest the power of aggregate tables, materialized query tables (MQT) and Multidimensional Clustering. The core program is six to eight weeks, and includes review of the existing design, introduction to the methodology, analysis and selection of optimal aggregations for a fact family (e.g. sales), design and delivery of customized templates and code generation scripts that automate maintenance activities, and finally education and query design with samples that demonstrate performance enhancements. At the end you are left with working code and a working system that can expand for larger deployment, and a comprehensive list of recommendations for further enhancements to improve stability, performance and flexibility to your implementation.

Architecture & Integration Services:

A well-balanced architecture from disk subsystems,  to database and application servers is paramount to achieving cost effectiveness and performance. We help customers with such deployment, performance assessment, and correction of database and ETL environment, and often work directly with IBM and ETL vendors to resolve issues on behalf of our customers.
 
Another aspect of good architecture is the exploitation of parallelism and pipelining inside the database engine, but also in relation to the inbound and outbound components, such as ETL and application/tool access. We assist customers in the design and implementation of tools and applications to better exploit the parallelism and scalability of the total system, not just DB2. We recently assisted a large retailer to implement an I2 Demand Management implementation using the parallel version of DB2 to meet interactive and batch performance goals.  

 

Last updated on

 
228 Church Rd
Devon, PA 19333
(610) 995-2608

For information please  use the contact information above or e-mail to:

inquiries@kamfonas.com