DimensionUH (2010)

UH is a business application in medical cathegory. It is an ultrasound helper software what can help to doctor and his/her assistants. The program saves data of pregnant women and calculates pregnancy states and much more.


My technology

Mega SQL technology refers to a data allocation and memory query technique facilitating the use of a single SQL select with extremely large memory data rather than repeating millions of small SQL selects. It is a good solution for data restoration. It enables 50* times faster query with LINQ to Object technology on memory.

I used this technology for DimensionUH project. The database restoration ran 15 minutes instead of half day. DimensionUH has a large database with 3 million patient report and 80k patients in magic txt file. I translated this with a Gawk to SQL server for Mega SQL technology restoration.