Xtract - Data Cube - Optimized version

Utilities like DBU, Make, IDE written in HMG/ used to create HMG based applications

Moderator: Rathinagiri

User avatar
swapan
Posts: 242
Joined: Mon Mar 16, 2009 4:23 am
Location: Kolkata, India
Contact:

Re: Another Grid Utility

Post by swapan » Wed Aug 26, 2009 6:53 am

Xcellent Rathi for Xtract!!!

2 b honest I've never gone to see what actually is pivot. In my previous organisation also it was used for data testing and in the development - pivot report was integerated in the grid (all the reports were based upon 3rd party grid tool - ComponentOne).

U've excellently described it..... do u give or use to give "private tutions"?! You are so nice in explaining things..... thanks a lot.

Your this creativity can become a powerful feature in our applications. Just consider the suggestions/feedbacks your are getting from us.

Its great that you've so much passion for HMG. Keep going!

Rgds,

Swapan
Thanks & Regards,
Swapan Das

http://www.swapandas.com/

User avatar
Rathinagiri
Posts: 5077
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Has thanked: 89 times
Been thanked: 103 times
Contact:

Post by Rathinagiri » Wed Aug 26, 2009 7:32 am

Thanks a lot friends.

I will again work on a new pre-release version of the utility with the suggestions and improvements presented by our members.

Swapan,

Yes. I take classes for Information Technology paper for CA students. :)
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.

User avatar
swapan
Posts: 242
Joined: Mon Mar 16, 2009 4:23 am
Location: Kolkata, India
Contact:

Post by swapan » Wed Aug 26, 2009 9:48 am

rathinagiri wrote: Yes. I take classes for Information Technology paper for CA students. :)
2 Good!

Start taking classes for HMG also!! :)
(I'm willing 2 join as a student// :D )

Eagerly awaiting for your this tool's next release....................................

Rgds,

Swapan
Thanks & Regards,
Swapan Das

http://www.swapandas.com/

User avatar
dhaine_adp
Posts: 457
Joined: Wed Aug 06, 2008 12:22 pm
Location: Manila, Philippines

Post by dhaine_adp » Wed Aug 26, 2009 11:07 pm

Hi Rathi,

Though you say it's premature but rather you have already code a very good Data Plotting Utility. For me I would suggest "HMGDataPlot" due to the following statistical reasons:

1. The end result is a valuable input to the decision makers.
2. The output can be used to run further analysis such as forecasting, linear regression,
Markov Chain (Monte Carlo Method), Deltas (like the one we used to see in stocks market)
and other host of statistical functions that is useful in analyzing trends to gain
competitive advantage (I mean business wise), fast moving items and seasonal product
movement, thereby empowering the end users by putting the best business tools on their
finger tips. Finally every users of this tools would let them maximize their assets
most especially cash in managing their business most especially in the period of
global recession.
3. The output can tap the power of HMG Graph facility.
4. I call it HMGDataPlot because using HB Class the code can be called as
Case 1
HMGDataPlot():New()
HMGDataPlot():Query(Area+ProductCode+Salesman) // or
HMGDataPlot():Query() ---> null parameters displays your query engine
HMGDataPlot():GridView() // display the query

Case 2
HMGDataPlot():Compare( Year1Month12, Year2Month12, Year3Month12 ) --> DBF or SQL Tables
HMGDataPlot():Query(Area+ProductCode+Salesman)
HMGDataPlot():Graph("BAR")

5. As you have said premature but it's already on the tip of data mining technology, we can borrow more from MATHLAB and in Neural Theory and Fractals, however as of the moment we don't have enough graphic facility to display them using HMG.


Congrats,


Danny
Regards,

Danny
Manila, Philippines

User avatar
sudip
Posts: 1443
Joined: Sat Mar 07, 2009 11:52 am
Location: Kolkata, WB, India

Post by sudip » Thu Aug 27, 2009 3:50 am

Hello Danny,
Thank you very much for this discussion! I found that everyday I am learning something from this forum :)
Thank you Rathi for this tool and for the knowledge we shall acquire from this tool :)
Regards.
Sudip
With best regards,
Sudip

User avatar
Rathinagiri
Posts: 5077
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Has thanked: 89 times
Been thanked: 103 times
Contact:

Post by Rathinagiri » Thu Aug 27, 2009 3:50 am

OLAP and data mining are very much required Business Intelligence Logics, which have to ported to HMG.

However, this is JUST a starting. I hope to join with more hands in this project to be more useful. :)
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.

User avatar
Rathinagiri
Posts: 5077
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Has thanked: 89 times
Been thanked: 103 times
Contact:

Post by Rathinagiri » Sun Oct 18, 2009 7:58 pm

Here comes the optimized version of Xtract - HMGData Cube

For the past few weeks, I always had in my mind about this project, how to optimize it. I came to know that, it is the asort and ascan functions which took so much time. So, I had decided to write separate functions to search using b-tree logic etc.,

Then, one fine day, it stroke my mind that, I need not re-invent the wheel. In the mean time, there was a huge discussion about SQLite in HMG. I read about SQLite temporary database also.

I just tried to use SQLite temporary database in this project. By executing two simple SQL queries, I could create the Data Cube as desired. To my surprise, it solved the problem of optimization.

In this version I had added total/grand total also. Please check up and give your valuable suggestions as always.
xtract0.50.zip
(10.57 KiB) Downloaded 209 times
Some of improvements in my mind for version 1.0:

1. Live Data Cube (No requirement of pressing a button. As and when row/col/data are changed, we can see the change in the cube immediately.)
2. Ability to see the Data Cube in graphs. :)
3. Printing the cube.
4. Adding as a component in HFCL for any grid/browse control.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.

User avatar
fchirico
Posts: 324
Joined: Sat Aug 23, 2008 11:27 pm
Location: Argentina

Post by fchirico » Mon Oct 19, 2009 12:09 am

rathinagiri wrote:Here comes the optimized version of Xtract - HMGData Cube


In this version I had added total/grand total also. Please check up and give your valuable suggestions as always.

rathinagiri:

The speed is amazing!. I have tried it with over 120,000 records and only took seconds. And the GRAND TOTAL is very useful.

Before running the button "Xtract" would be interesting to filter the desired records.

Excelete your work, but above all helpful.

Regards, Fernando Chirico.
Saludos, Fernando Chirico.

User avatar
Rathinagiri
Posts: 5077
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Has thanked: 89 times
Been thanked: 103 times
Contact:

Post by Rathinagiri » Wed Oct 21, 2009 8:14 am

Thanks for your comment and suggestion Fernando Chirico.

I am working on the next version.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.


Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest