Welcome!

Raqsoft

Jessica Qiu

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


Latest Articles from Jessica Qiu
A code example to read, calculate and write large Excel data in batch more efficiently: Read data of orders and sellers’ information list from data.xlsx, compute sales amount of every department, and return the result into result.xlsx.
Recently, we skillfully handled an industry project to import a great amount of data from file to Oracle in comparatively short time. Later, by adopting the parallel import of sqlldr, the time is shortened to 0.8 hour. Here are the full details: Train of thoughts Split the data file...
How to solve a disturbing issue occurred when retrieving the data in a big detail report? here are some best tips on how to expedite multilevel retrieve process synchronously. Recently, a performance issue occurs in a big detail report, where the original data volume in the two data t...
Both R language and esProc have the outstanding ability to perform the stepwise computations. However, in the particulars they differ from each other. A comparison between them will be done by the following example.
A company has a High Growth SalesMan of the Year report, which analyzes, mainly through sales data, the salesmen whose sales amount exceeds 10% for three consecutive months, and demonstrates the indices such as their sales amount(Sales Amount), sales amount link relative ratio(Amount L...
Based on the generic data type, esProc provides the sequence and the Table Sequence for implementing the complete set-lizing and the much more convenient relational queries. The relation between the department and the employee is one-to-many and that between the employee and the SSN (...
Recently a development team met some difficulties in data source computation when developing iReport reports. After the use of esProc for cross database computation, the problem is resolved. This is a project payment progress report, as part of a project management system. It's based ...
Some reports in a project suffered from very low speed. Despite various iReport and Oracle database optimizations, the situation is not yet satisfying. For example, there is a detail report, involving large data volume, many (dozens of) data tables, and frequent inter-table join (inclu...
Recently we resolved an issue with Crystal Report, related with heterogeneous data source computation. Due to its complexity, the computation cannot be done with the current functionality of Crystal Report. Thus esProc is used for cross database computation.
This is a solution of solving multi databases issue in reporting development.
Comparison of Hive, Impala and esProc in terms of computing performance
In order to ensure the test data is typical and comparable, the three products must go through the same computing. The Hive or Impala is designed for the data warehouse, providing the SQL-like syntax as the only available syntax. By comparison, esProc is designed as the complex procedu...
In the previous article, I’ve shared some experiences in Hadoop coding with the agile esProc syntax. This article is the supplementary and in-depth discussion based on the previous one. Firstly, let’t talk about the Cellset Code. In the previous article, I ‘ve introduced the conv...
Recently, I finished a project which involves using the Excel, R Project, and es-series in combination. An idea occurred to me in the work. Why not put them along with the Matlab, SPSS, and Stata side-by-side to make an introductions and comparisons of Desktop BI tools? At last, this e...
Hadoop is an outstanding parallel computing system whose default parallel computing mode is MapReduce. However, such parallel computing is not specially designed for parallel data computing. Plus, it is not an agile parallel computing program language, the coding efficiency for data co...
Hadoop is an outstanding distributed computing system. However, many users find MapReduce is too complex and too tough to manage, the response is too slow, the realtime is too poor, and the running is inefficient. In a word, it is too heavy. They are users of middle-and-small-scale clu...
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...
Traditional database is difficult to implement real-time application when the data volume is big. Now with data computing middleware, performance of database is improved and real-time application is also realized. The Big Data Real-time Application is a scenario to return the computat...
What is IOE? I=IBM, O=Oracle, and E=EMC. They represent the typical high-end database and data warehouse architecture. The high-end servers include HP, IBM, and Fujitsu, the high-end database software includes Teradata, Oracle, Greenplum; the high-end storages include EMC, Violin, and ...
Spreadsheet software is widely used by people in every industry with flexibility for data computing and analysis. But due to inherent drawbacks, common business spreadsheet software can't conduct relational query like SQL. The spreadsheet can implement the visualized calculation to so...
Raqsoft welcomes anyone who interested in powerful spreadsheet software to write reviews for esCalc or share application cases. Participants can get esCalc for free by doing this. A standalone alternative for Excel on complex data computing, esCalc, will be offered for free to partici...
Getting tickets is always very hard during holidays, especially during transport peak from Jan. 26, 2013 to According to the data of Chendu Railway Station on 18th, February, 2013, 14 temporary trains have been added while still tickets of many trains haven’t been left. To ease the tic...
With Christmas and New Year celebration passing by, enterprises from different industries turn their focus from festival fun to work. It’s time to fresh your mind and recharge your batteries to kick off 2013 in a perfect way. Statistical computing and analytics tools, esProc and esCalc...
Beijing Spirit? Have you ever heard it? It is announced by Beijing government on 2nd, November, 2011. This Beijing Spirit has been taken as a guide by Beijing citizens including the local enterprises. Do you wonder to know why? A country needs great national spirit and so does a city....
Nowadays, made-in-China has become a global phenomenon. But even now, there is still prejudice about Chinese origin products. When many foreign customers talk or mention a made-in-China product, the words that occur to them first might be "cheap and low quality". Such view is particula...
With the ever-changing economy, the business intelligence landscape is also transforming. According to some predictions, the worldwide spending on IT will continuously increase in 2013 and even at the next few years. The growth drivers may include data visualization, big data, speed, a...
esProc supports various data sources. These data sources could be JDBC-driving databases or sequence files that are not stored in database like Excel and Txt. With esProc, analysts can access data from a single data source or from multiple data sources. Results can be showed in esProc ...
Raqsoft will launch esCalc soon, targeting at helping analysts achieve self-service analysis and reporting. It will provide agility and shortcut to decision makers with its outstanding capabilities.
esProc is high capable script for business statistical computing, delivering more advances than traditional tools like SQL. 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 ...
Instant computation and analysis is one of the outstanding highlights, enabling analysts' work to be more convenient and flexible. The recently released esProc for data computation and data analysis has many highlights which differentiates it from traditional business intelligence to...
Raqsoft, a business intelligence tool provider today officially released esProc, the new generation software for data computation and data analytics. The anticipated product which targets at optimizing analysts' benefits has many outstanding features and advantages. This newly launc...
The upcoming esProc for data computation and data analytics has many outstanding highlights. Developed by Raqsoft, the leading provider of software for business intelligence, the anticipated esProc will greatly enhance analysts' work efficiency.
The upcoming esProc, an innovative data computation and data analytics software, will be launched soon within this month. According to Raqsoft, the industry leading data handling software provider, this product features with ease of use. esProc provides a grid user interface similar...
Raqsoft, a software provider for data analytics and structured data computation is going to launch esProc in the next month, aiming at enhancing enterprises' efficiency for decision making and reducing management cost. This tool is innovative in simplifying complex data computation and...