A method to avoid database extension
According to research, most complex report development work can be simplified by performing the data source computation in advance. For example, find out the clients who bought all products in the given list, and then present the details of these clients.
In developing such reports, it is the “computation” part and not the “presentation” part that brings about major difficulties. In which stage...
In report development, we may need to present the data from multiple databases in one report, such as data from MSSQL database for CRM and Oracle database for ERP. If the reporting tool like iReport only supports single data source, then we need to consolidate the multiple data sources into a single data source.
The Crystal, BIRT, and other so-called reporting tools for multiple data source can...
In the process of Java development, programmers will come across data computation. But Java alone is not convenient to handle such computation. SQL has limited impact on improving the computational efficiency for Java. In this case, a new way is needed.
The data computation layer of Java aims to reduce the coupling between data persistent layer and the application layer and shift the computational workload from them. In this survey, 5 data computation layers of Hibernate, esProc, SQL, iBATIS, and R language are tested and compared on the basis of the below metrics: maturity, low coupling, scripting, integration, UI friendliness, performance, complex computation, support for big data, non-database computation, cross-database computation, and convenience for debugging.