Data sources cover the result set of SQL queries or stored procedures, and
the 2D table from the text or Excel files. Owing to the technical competence
or versioning, various reporting tools may only support a single data source,
such as JasperReport, Quiee, BIRT, and Crystal Report.
With years of experience, I've concluded several methods to share and discuss
Virtual Data Source for JasperReport Commercial Server
The Virtual Data Source provided in the JasperReport business edition can
solve this problem. With wizard, one virtual table can be created by joining
two entity tables of either physical table or SQL. The interface is shown
esProc for reporting tools
Unlike the bundled reporting tools, esProc is a data source development tool
that is totally independent of databases and reporting tools.
Data Sources Join for BIRT
BIRT is the famous open ... (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)
Recently, I finished a project which involves using the Excel, R Project, and
es-series in combination. An idea occurred to me in the work. Why not put
them along with the Matlab, SPSS, and Stata side-by-side to make an
introductions and comparisons of Desktop BI tools? At last, this essay comes
into being, as you can see below.
Desktop BI refers to the BI tools running on the desktop environment, almost
not requiring any server supports. The typical Desktop BI only provides the
core BI functions with less requirement on the technical environments. By
comparison, such software a... (more)
The data computation layer in between the data persistent layer and the
application layer is responsible for computing the data from data persistence
layer, and returning the result to the application layer. The data
computation layer of Java aims to reduce the coupling between these two
layers and shift the computational workload from them. The typical
computation layer is characterized with below features:
Ability to compute on the data from arbitrary data persistence layers, not
only databases, but also the non-database Excel, Txt, or XML files. Of all
these computations, the... (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)