May 29, 2012

Interactive Query Computation

The decision support is based on the query computations on the existing database. The interactive query is the basic need of end users. The accurate and complete retrieval conditions can help user get the required data from the database.
At present, there are two kinds of interactive query solutions:

May 27, 2012

What OLAP is Indeed for Actual Need

OLAP is an important constituent part of BI (business intelligence)?

Understood literally, OLAP is online analytical processing, that is, users conduct analytical operation on real-time business data.
But, currently the concept of OLAP is seriously narrowed, and only it refers to operations such as conducting drilling, aggregating, pivoting and slicing based on multi-dimensional data, namely, multi-dimensional interaction analysis.

May 24, 2012

Top n Clients Accounting for Half of the Total Sales in This Year

Problem

The table below is the historic sales contracts of an enterprise:

The table below is the Client table:

Clients ranked by sales value in a certain year. The top n clients accounting for half of the total sales value is called as Key account. Please list the key account of this enterprise in the year of 1998.

May 15, 2012

Analyze Data with No SQL Experience

“What is the sales value in this month? What is the increased percentage compared with the previous month? Which sales persons are among the top 10?” – The similar data analysis is mostly required in the sectors like commerce, finance, government, and scientific research. SQL usually is the only choice for such kind of analysis.
As a query language initially developed in early 70s, SQL has a relatively higher technical requirement on analysts. Lacking of advanced IT professionals is the root cause that hinders the data analysis from going any further.
esProc is a data analysis tool of the new generation. It not only provides all features of SQL, but also requires lower technical requirements. Even those developers without SQL expertise can use esProc to analyze the data by themselves.


May 11, 2012

Tap Utmost Value of Excel

Excel® is the most widely-used spreadsheet tool. The nontechnical persons love to use it for computation and analysis though, they usually find the formulas and functions available in Excel® are rather poor and the VBA® is just double Dutch to them for further analysis. Thus, a huge volume of data with valuable information has been wasted in vain.
esProc is introduced to better the situation. Empowered esProc users can tap the utmost value of Excel® by taking the esProc advantages of powerful computation ability, agile and easy-to-use analysis style, and programmed running mode.

May 8, 2012

Bid Farewell to Stored Procedure

A stored procedure is a collection of SQL queries and flow control statements. The stored procedure is usually used to break a complex computation task down to several simple computation steps. Although the stored procedure can improve the flexibility at the cost of complexity, it is always hindered by the inherent drawbacks of SQL, such as incomplete stepwise mechanism, unordered data, and lack of sets and references.
esProc not only overcomes the above drawbacks of SQL, but also greatly lowers the requirements on the technical background of developers. It is an ideal tool to substitute the stored procedure.

A Query Language Over-perform SQL


SQL (Structured Query Language) was initially developed in early 70s. To date, SQL is still a powerful, simple, and widely-applied database query language. However, the drawbacks of SQL are evident: non-stepwise computation, incomplete set-lization, no support for ordered set, and lack of object reference. Although several producers has developed a number of incompatible solutions, such as various stored procedures like PL-SQL®, and T-SQL®, these improvement solutions cannot solve the inherited SQL drawbacks.
As a query language of the new generation, esProc over-perform SQL in respect of computational capability, usability, and applicability.