In Java, implementing via SQL is a well-developed practice for database computation. However, the structured data is not only stored in the database, but also in the text, Excel, and XML files. Considering this, how to compute appropriately regarding the structured data from non-database files? This article raises 3 solutions for your reference: implement via Java API, convert to database...
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
In Java development, the typical data computation problems are characterized with:
Long computation procedure requiring a great deal of debugging
Data may from database, or Excel/Txt
Data may from multiple databases, instead of just one.
Some computation goals are complex, such as relative position computation, and set-related computation
Just suppose a sales department needs to make statistics...
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...