Xtract - Data Cube - Optimized version
Moderator: Rathinagiri
Re: Another Grid Utility
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
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
- 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
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.![Smile :)](./images/smilies/icon_e_smile.gif)
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.
![Smile :)](./images/smilies/icon_e_smile.gif)
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
South or North HMG is worth.
...the possibilities are endless.
Re: Another Grid Utility
2 Good!rathinagiri wrote: Yes. I take classes for Information Technology paper for CA students.
Start taking classes for HMG also!!
![Smile :)](./images/smilies/icon_e_smile.gif)
(I'm willing 2 join as a student//
![Very Happy :D](./images/smilies/icon_e_biggrin.gif)
Eagerly awaiting for your this tool's next release....................................
Rgds,
Swapan
- dhaine_adp
- Posts: 457
- Joined: Wed Aug 06, 2008 12:22 pm
- Location: Manila, Philippines
Re: Another Grid Utility
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
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
Danny
Manila, Philippines
Re: Another Grid Utility
Hello Danny,
Thank you very much for this discussion! I found that everyday I am learning something from this forum![Smile :)](./images/smilies/icon_e_smile.gif)
Thank you Rathi for this tool and for the knowledge we shall acquire from this tool![Smile :)](./images/smilies/icon_e_smile.gif)
Regards.
Sudip
Thank you very much for this discussion! I found that everyday I am learning something from this forum
![Smile :)](./images/smilies/icon_e_smile.gif)
Thank you Rathi for this tool and for the knowledge we shall acquire from this tool
![Smile :)](./images/smilies/icon_e_smile.gif)
Regards.
Sudip
With best regards,
Sudip
Sudip
- 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
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.![Smile :)](./images/smilies/icon_e_smile.gif)
However, this is JUST a starting. I hope to join with more hands in this project to be more useful.
![Smile :)](./images/smilies/icon_e_smile.gif)
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
South or North HMG is worth.
...the possibilities are endless.
- 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
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.
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.![Smile :)](./images/smilies/icon_e_smile.gif)
3. Printing the cube.
4. Adding as a component in HFCL for any grid/browse control.
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.
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.
![Smile :)](./images/smilies/icon_e_smile.gif)
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.
South or North HMG is worth.
...the possibilities are endless.
Re: Xtract - Data Cube - Optimized version
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.
- 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
Thanks for your comment and suggestion Fernando Chirico.
I am working on the next version.
I am working on the next version.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
South or North HMG is worth.
...the possibilities are endless.