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 »

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: 5471
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: Another Grid Utility

Post by Rathinagiri »

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:

Re: Another Grid Utility

Post by swapan »

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

Re: Another Grid Utility

Post by dhaine_adp »

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: 1454
Joined: Sat Mar 07, 2009 11:52 am
Location: Kolkata, WB, India

Re: Another Grid Utility

Post by sudip »

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: 5471
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: Another Grid Utility

Post by Rathinagiri »

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: 5471
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: Xtract - Data Cube - Optimized version

Post by Rathinagiri »

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 614 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

Re: Xtract - Data Cube - Optimized version

Post by fchirico »

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: 5471
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: Xtract - Data Cube - Optimized version

Post by Rathinagiri »

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