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 the process of development with Java, we will occasionally encounter the computation similar to data processing in database. For instance, there are two frequently updated Excel sheets, which are the clients' information and the orders. We need to query the data of clients who have bought all the products on the list through entering a dynamic product list. The "computation similar to data processing in database" refers to structured data computation of an application without database. Although Java is capable of handling such computation, the procedure is very cumbersome and verbose. It takes programmers a lot of time and efforts to implement the computational details. For example, seek the maximum value, rank, filter, group, and average. In addition, it is cumbersome to define various data types. For example, define class, use object to represent every piece of d... (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)

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)

The Truth About Efficient Data Processes in Java Development

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

An Alternative to Stored Procedure in Big Data Computation

As we know, the stored procedure is designed to handle computations involving complex business logics. In the past, the data structure and business logics were so simple that one SQL statement was enough to achieve user's computational goal. With the rapid growing of information industry, users frequently find that they need to achieve the increasingly complex computational goals to out-perform their competitors. To address such computations, SQL alone is far from enough. Database programmers have the additional demands regarding the judge and loop statements, branches at multip... (more)