Clarity Consulting is the Authorised Forrester Research Partner Forrester

Re-engineering and visualization of a complex, large-scale data warehouse

Our international commercial banking client's data warehouse has been operating for many years, storing a huge amount of information from an ever increasing number of new applications as well as applications that are not in use anymore. The continuously increasing size of databases and complexity of data structures resulted in more and more untraceable program structures. The system became too complex to be transparent, not only for the business users but for the analysts and developers as well. The system documentation couldn't contribute to data flow mapping anymore. Thanks to our deSQL tool, hidden program elements and their relations became fully uncovered and explored. By utilizing deSQL, business analysts can easily identify the impact of any changes in the system. The tool also enables the developers to visually track the whole data stream, fostering quicker implementation at higher quality.

Results in numbers:

  • 6,000,000+ program lines processed
  • 200+ schema relations explored
  • 7,000+ table relations discovered
  • 100,000+ links between data elements documented
  • 20 minutes of total processing time
  • 1 automatically generated, uniform data warehouse documentation
© 2001- 2020 Clarity Consulting Kft.,
Minden jog fenntartva
  • Clarity Consulting Kft.
  • 1145 Budapest, Erzsébet Királyné útja 29/b.
  • tel +36 1 422-3030 / fax +36 1 422-3032
  • email

  • Telconex Middle East
  • BH: +973 1742 2299
  • P.O.Box 80777 Manama, Kingdom of Bahrain

  • Fabintel Pakistan
  • PK: +92 42 35846171
  • UK: +44-741-8447636
  • 133, Aurangzeb Block
  • New Garden Town,
  • Lahore-54600, Pakistan