Jessica Qiu

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

Top Stories by Jessica Qiu

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 outstanding ability of esProc to solve the above mentioned problems. Data source that supported by esProc could be the database driving by JDBC. esProc is able to access such kind of databases through their JDBC interface. Besides, esProc provides a standard JDBC interface, allowing esProc ... (more)

More Efficient Data Preparation for Reports Beyond ETL/DW

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 only join 2 result sets roughly, and are also very inconvenient for the complex multi-data-source computations. For example, compute the yearly growth rate of order value for each client i... (more)

Database to Implement Big Data Real-Time Application

The Big Data Real-time Application is a scenario to return the computation and analysis results in real time even if there are huge amounts of data. This is an emerging demand on database applications in recent years. In the past, because there wasn't a lot of data, the computation was simple, and few parallelisms, the pressure on the database wasn't great. A high-end or middle-range database server or cluster could allocate enough resources to meet the demand. Moreover, in order to rapidly and parallel access to the current business data and the historic data, users also tended t... (more)

Creative Spreadsheet Software for Data Processing in Development

In the actual business, data analysis and statistical computation as well as report preparation are required no matter for the management of inventory and human resources, or calculation of customer information and sales data. In this case, a tool which can handle different datasource like text, spreadsheet, database, etc. is needed in urgent. However, most of statistical computation software needs modeling before computation and analysis which reduces flexibility to meet analysts' ever-changing demands. At the same time, complex datasource and abstract formula increase difficult... (more)

Business Intelligence Suppliers: Are You Ready for 2013?

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, agility, self-service, cloud computing, etc. Therefore, the BI suppliers who have these features will be more competitive compared with their rivals. Business growth turns BI into a daily business processes. Thus demands for new generation BI software are increasing and agility one requirement for t... (more)