Skip to main content

Jim King

Jim King is a visionary expert in the field of BI, database, Java development and programming. He has more than 10 years of experience in BI and development of Java applications. He is passionate about applying simpler methods to solve the complex problems of users.

 

Raqsoft's blog

How to get data computing faster for java developers

Posted by Raqsoft on January 24, 2014 at 12:05 AM PST

The columnar storage is good, especially when there are lots of tabular fields (this is quite common). In querying, the data to traverse is far less than that on the row storage. Less data to traverse brings less I/O workloads and higher query speed. However, the Hadoop application consumes most time on the hard disk I/O without columnar storage.

Increase Database speed, decrease database expenses

Posted by Raqsoft on December 11, 2013 at 2:11 AM PST

The data warehouse is essential to enterprise business intelligence, which accounts for a great part of the total enterprise cost. With the global data explosion in recent years, the business data volume grow significantly, posing a serious challenge for enterprise data warehouse to meet the diverse and complex business demands.

How to ease database computing in Report Development with Data Computation layer

Posted by Raqsoft on September 11, 2013 at 7:21 PM PDT

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.

Three Solutions for Structured Data Process without Database in Java

Posted by Raqsoft on August 29, 2013 at 8:06 PM PDT

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.

Eliminating Time Waste in Reports with Java Development Tool

Posted by Raqsoft on August 20, 2013 at 10:52 PM PDT

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.

Developers Find Innovative Way for Data Process in Java

Posted by Raqsoft on August 13, 2013 at 7:02 PM PDT

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.

Complex Calculation in Reports with Innovative Java Development Tool

Posted by Raqsoft on August 6, 2013 at 8:09 PM PDT

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.

Solutions of 5 Computation Layers to Data Process in Java

Posted by Raqsoft on July 31, 2013 at 7:07 PM PDT

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.

Avoiding Pitfall of Failure: Java, SQL or other Programming Language?

Posted by Raqsoft on July 24, 2013 at 1:41 AM PDT

Recently, I read Why Big Data Projects Fail by Stephen Brobst. I can’t agree more with his opinions which exposed the problem I’ve been worried about. In this article, I am going to further discuss this topic to remind the enterprises to beware of falling into such pitfall of failure.

Integrating Dynamic Calculation Script for Set Operations in Java

Posted by Raqsoft on July 16, 2013 at 10:59 PM PDT

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.