Recently a development team met some difficulties in data source computation
when developing iReport reports. After the use of esProc for cross database
computation, the problem is resolved.
This is a project payment progress report, as part of a project management
system. It's based on an Oracle database. The reports needs to present the
project name, payment amount, contract value, payment progress (in
percentage), and name of the project manager, etc., for all ongoing projects.
Amount these the first 3 items contributes to the difficulties met by the
Note that the project payment record is stored in accounting system, rather
than the Oracle database used by the development team. The accounting system
is built on MSSQL database. The contract value information is also stored in
a separate MSSQL database, used by contract management system. After a... (more)
The Big Data Real-time Application is a scenario to return the computation
and analysis results in real time even if there are huge amounts of data.
This is an emerging demand on database applications in recent years.
In the past, because there wasn't a lot of data, the computation was simple,
and few parallelisms, the pressure on the database wasn't great. A high-end
or middle-range database server or cluster could allocate enough resources to
meet the demand. Moreover, in order to rapidly and parallel access to the
current business data and the historic data, users also tended t... (more)
In the actual business, data analysis and statistical computation as well as
report preparation are required no matter for the management of inventory and
human resources, or calculation of customer information and sales data. In
this case, a tool which can handle different datasource like text,
spreadsheet, database, etc. is needed in urgent. However, most of statistical
computation software needs modeling before computation and analysis which
reduces flexibility to meet analysts' ever-changing demands. At the same
time, complex datasource and abstract formula increase difficult... (more)
Enterprises always have various data sources, for instance, CRM system may
use SQL Server, sales reports adopt Excel, ERP applies Oracle database. When
it comes to actual business analysis, enterprises usually need to conduct
interactive computation, including filter, group, etc among various data
environments. But data Interaction between multiple data sources are not easy
to realize with some traditional statistical computing tools. In order to
solve such kind of problems, esProc which adapts to various data environments
comes into being.
Support of various data sources is an... (more)
Spreadsheet software is widely used by people in every industry with
flexibility for data computing and analysis. But due to inherent drawbacks,
common business spreadsheet software can't conduct relational query like SQL.
The spreadsheet can implement the visualized calculation to some extent, and
the nontechnical people can perform some rather complex calculations without
having to learn the SQL. However, as the core of SQL, the relational query is
unable to be implemented through common business spreadsheet software, which
adds complexity to the apparently simple problems of mu... (more)