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)

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)

Cross Database Computing in Report Development

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 on an Oracle database. The reports needs to present the project name, payment amount, contract value, payment progress (in percentage), and name of the project manager, etc., for all ongoing projects. Amount these the first 3 items contributes to the difficulties met by the development team. Note t... (more)

Beijing Spirit Leads Enterprises to Continuous Progress

Normal 0 7.8 磅 0 2 false false false EN-US ZH-CN X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:普通表格; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.5pt; mso-bidi-font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:宋... (more)

Visualized Calculation by Empowering Spreadsheet with SQL Ability

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 some extent, and the nontechnical people can perform some rather complex calculations without having to learn the SQL. However, as the core of SQL, the relational query is unable to be implemented through common business spreadsheet software, which adds complexity to the apparently simple problems of mu... (more)