Request Information
  Data Warehousing & Data Architecture

Data Architecture is the core of any business that defines how the data or information is stored, managed, distributed, used, transformed and governed in a predefined universe, where the business universe could include entities within and outside the organization. We provide world class engineers to design and implement Data Architectures for small to large scale environments catering to simple to very complex needs..

High Performance Data Architecture
With the advent of high number crunching and fast response times, parallel architectures have become an integral part of high performance solutions. Traditionally there are two types of architectures MPP (Massively Parallel Processing) and SMP (Symmetric Multiprocessing). SMP has some limitations tied to bandwidth of the memory bus, so increasing number of processors after a certain number does not add to any gain. MPP architecture is again share nothing and has its own set of advantages and disadvantages; there are hybrid architectures between SMP and MPP, where they use traditional MPP architecture but share with an exception of sharing memory with high performance cache.


Achieving Unlimited Scalability
When it comes to managing large data warehouses, scalability is always a prime concern. Leading database like Oracle, UDB, Teradata and other have upper limits. Scaling beyond 50 Terabytes, needs to be architected in right manner to achieve the level of performance and scalability. There are several techniques to achieve theoretical sense of unlimited scalability; one of them is to create a database structures that are skeletal in nature. These databases hold reference to databases and data record, sort of pointers to other database and data records, then use co-locate them using intelligent partitioning algorithms for fast retrieval, thus getting the flexibility to grow without compromise on the performance.


Real-time Data Mining and Dynamic Segmentation
Traditionally we have been using static models that are scored on a universe and then the scores are used for the purpose of segmentation. There are newer techniques to conduct more real-time segmentation based on the real-time need. The technique uses a dynamic array of models instead of static model based on the variables selected.( e.g. like a self guided missile which tunes itself based on the additional information it collects as it gets closer to the target, thus increasing the probability to hit the target accurately, this same concept can be applied to business applications, that will fine tune and dynamically change segmentation models based on the changes it recognizes to better target the customer.)

We provide highly experience and expert level resources for development, providing data integration solutions, supporting operations and maintenance. Based on the requirements we can provide onshore and offshore resources through our offshore alliance partners. We specialize in the following database technologies:

  • Oracle 9i and Oracle 10g
  • Teradata
  • SQLServer
  • Sybase.

Need more information, please Contact Us.


Home | Contact us

Copyright © 2008 Blue Square Consulting