Welcome!

Raqsoft

Jessica Qiu

Subscribe to Jessica Qiu: eMailAlertsEmail Alerts
Get Jessica Qiu via: homepageHomepage mobileMobile rssRSS facebookFacebook twitterTwitter linkedinLinkedIn


Top Stories by Jessica Qiu

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 on the top 3 outstanding salesmen ranking by their monthly sales in every month from Jan to the previous month, based on the order data. Java alone is difficult to handle such computations. Although it is powerful enough and also quite convenient in debugging, Java has not directly implemented the common computational algorithms yet. So, Java programmers still have to spend great time and efforts to implement the details like aggregating, filtering, grouping, sorting, and ran... (more)

Consolidate Multiple Database Sources for Single-Source Reporting Tool

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 with you. 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 ent... (more)

Script Computation of esProc Optimizes Analysts' Benefits

Through a serial of news and articles released in the last few weeks, analysts may have already know some advantages of esProc, including ease of use, friendly interface, strong computing ability etc. Besides the previously introduced highlights, the core of script computing should not be neglected. esProc is high capable script for business statistical computing. Different from some other script applications, esProc delivers more advances. The script codes of esProc are easy to learn and use since they are short but understandable. Some of its script computation capabilities are ... (more)

Data Environments Support of esProc Makes Statistical Computing More Flexible

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)

Two Ideal Solutions to Complex Calculation on Set in Java

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 operation. 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)