MS Chart Control, A DataVisualization API

Get real time news update from your favorite websites.
Don't miss any news about your favorite topic.
Personalize your app.

Check out NTyles.

Get it on....

In my previous post I shared some of the quotations which changed my life which I present as a refreshment. Now in this post I will show why MS-Chart Control is a good api for Data Visualization for .NET.

During my internship in one of the reputed company , 'Nepasoft Solutions Pvt. Ltd', I did a project in DATA VISUALIZATION AND FILTERING SYSTEM with other five genius guys from my college. In that project my role was to visualize the data. The project was in ASP.NET and C SHARP. I goggled for some cool API's and I found that MS-Chart control would be the best choice for our project. I found it very helpful and it has a very good documentation too.

Some of the good features I found in this API's are :

• Chart customization features from code also.
• Simple linkage with the database.
• Fabulous documentation
• Sorting, Aggregatem, Analytic etc functions.
• 3D customization, colors different models and many others/
• Trend Analysis
• Many graphing and visualizations tools from pie chart to splines and many more.
• Easy aggregation with back end.
• ASP.Net's user control feature makes the chart control more powerful and user-friendly.

In my next blog I will show you some cool features of chart control with videos and code :), which you guys would surely find helpful. Till then do some research of your own. Let me know if you guys have any queries regarding MS-chart control.

Life Changing Quotations.

Get real time news update from your favorite websites.
Don't miss any news about your favorite topic.
Personalize your app

Check out NTyles.

Get it on....

Before I move on to some other posts, let's get refreshed. I was and am a huge fan of quotations. During my days in SOS Hermann Gmeiner School, I used to look for something that would change my life, that would turn the way I used to think about myself, about everything. I used to regularly get pondered into the world of novels, holy books, magazines and long and short stories to get enlightenment as that of Lord Buddha, hehe. I would regularly wait for a monthly magazine named "WISDOM", is truly a great magazine.

Most of the friends of mine would go for making girl friends and I used to go for novels and magazines, used to be such a wonderful teenage you know ;-).

People need recharging to move on with life, like we need to recharge mobile phone. Some get recharged with something and other get recharged with other things. And I used to get recharged with QUOTATIONS. Here are my collection of some life changing quotes :

• God gives food to every bird, but does not throw it into the nest. 


• Everyone thinks of changing the world, but no one thinks of changing himself.


• A Spark neglected burns the house.


• No one knows his/her ability. It's an ability to find owns ability.


• If a man say, I love God, and hateth his brother, he is a liar: for he that loveth not his brother whom he hath seen, how can he love God whom he hath not seen?


• I sit on a man's back choking him and making him carry me, and yet assure myself and others that i am sorry for him and wish to lighten his load by all means possible....except by getting off his back.


• To the world you may be one person, but to one person you may be the world.


• Any fool can criticize, condemn, and complain, and most fools do.


• People throw rocks at a tree that has fruit.


• Having two ears and one tongue, we should listen twice as much as we speak.

If you guys also remember some quotations that changed thy(your) life then please do let me know.

What is ORACLE HINTS , A Brief Overview.

Get real time news update from your favorite websites.
Don't miss any news about your favorite topic.
Personalize your app

Check out NTyles.

Get it on....

Apart from lucenening and searching. Lets move on to some real time performance issues when you deal with large database with millions and trillions of rows with hundreds and thousands of tables. Oracle's sql processing executes query using the best plan generated by optimizer which has the low cost and needs very less resources executing that query. All the cost association for a query is calculated by Optimizer. In oracle there are two types of Optimizer :

• RBO(Rule Based Optimizer)
• CBO(Cost Based Optimizer)

Here I will not talk about RBO because Oracle is gradually deprecating the use of RBO in its future releases. Generally, all the costing calculation is done by CBO and oracle prefers CBO to do this and by default, its CBO. Oracle's CBO's main goal is the BEST THROUGHPUT, that means to execute all the rows using limited resources available. This is really good if you are querying in the small table. The response time will be good and even best. But think of the condition when an online user is trying to access the few information using simple query and at the back end of the website gives emphasis on BEST THROUGHPUT then surely this really is going to depress the user because he/she is not interested in the overall results and also user don't have patience to wait for 1-2 minutes online. So, the BEST THROUGHPUT really has a big disadvantage when the database is big and when multiple joins etc... are to be done in such database. For the online application, user's will really be happy if they see some results quickly as possible as soon as they hit the 'SHOW RESULTS' button. In order to achieve this we can tell the optimizer to change the execution plan for the best response time. Yes, BEST FAST RESPONSE TIME is another goal that a CBO can perform.But by default it's BEST THROUGHPUT. Now, how to make the optimizer choose the best plan to optimize itself for best fast response time? The answer is.......use oracle's HINTS.

For example if you have ten millions of rows in a table , instead of using this :

SELECT * FROM BIG_TABLE; 

and wait for 10-15 seconds simply use this:

SELECT /*+ FIRST_ROWS(20) */ * FROM BIG_TABLE;

to get few rows in your console as soon  as possible after hitting enter.

The bold section that looks like a comment is a hint embedded in the query, that makes the optimzer to change its execution plan for best fast response time.

Refer here for full syntax of Oracle Hints

.
Hints in Oracle are really very useful in improving performance in large database and should be used sparingly.
If you are not satisfied then don't hesitate to play my presentation:
ORACLE HINTS