Based on the generic data type, esProc provides the sequence and the Table
Sequence for implementing the complete set-lizing and the much more
convenient relational queries.
The relation between the department and the employee is one-to-many and that
between the employee and the SSN (Social Security Number) is one-to-one.
Everything is related to everything else in the world. The relational query
is the access to relational dataset with the mathematical linguistics. Thanks
to the associated query, the relational database (RDBMS) is extensively
I Case and Comparison
There is a telecommunications enterprise that needs to perform this analysis:
to find out the annual outstanding employees whose line manager having been
awarded the president honor. The data are from two tables: the first is the
department table mainly consisting of deptName and manag... (more)
In Java development, we may encounter the complex set operations. Java alone
is not powerful enough to save programmers' efforts in implementing the
computation details, which is time-consuming and poor in code reuse. In view
of this, programmers usually resort to dynamic calculation script for set
SQL is surely the first kind of script that comes into most programmers'
mind. However, to their disappointments, SQL does not support the explicit
set, and is unable to represent the sets of a set, ordered set, generic set,
and only the result set can be recognized as a set... (more)
What is IOE? I=IBM, O=Oracle, and E=EMC. They represent the typical high-end
database and data warehouse architecture. The high-end servers include HP,
IBM, and Fujitsu, the high-end database software includes Teradata, Oracle,
Greenplum; the high-end storages include EMC, Violin, and Fusion-io.
In the past, such typical high performance database architecture is the
preference of large and middle sized organizations. They can run stably with
superior performance, and became popular when the informatization degree was
not so high and the enterprise application was simple. With the ... (more)
Recently we resolved an issue with Crystal Report, related
with heterogeneous data sourcecomputation. Due to its complexity, the
computation cannot be done with the current functionality of Crystal Report.
Thus esProc is used for cross database computation.
Project background: The customer has recently rolled out their KPI system,
which required some modification on their original salary computation
algorithm. In the past the salary list is mainly calculated from the basic
salary of the employees, which is stored in the MSSQL database used by their
Accounting System. The new sala... (more)
With the ever-changing economy, the business intelligence landscape is also
transforming. According to some predictions, the worldwide spending on IT
will continuously increase in 2013 and even at the next few years. The growth
drivers may include data visualization, big data, speed, agility,
self-service, cloud computing, etc. Therefore, the BI suppliers who have
these features will be more competitive compared with their rivals.
Business growth turns BI into a daily business processes. Thus demands for
new generation BI software are increasing and agility one requirement for