Welcome!

AJAX & REA Authors: Sebastian Kruk, Pat Romanski, Stephen Pierzchala, RealWire News Distribution, ExtraHop Networks

Related Topics: Java, AJAX & REA

Java: Article

Data Environments Support of esProc Makes Statistical Computing More Flexible

Sequence files that are not stored in database such as Excel and Txt are also supported by esProc

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 to be called as an embedded database by outside applications like JAVA and reports. Analysts can call esProc for complex computation of mass data which is difficult to be conducted by JAVA. This adds great flexibility to analysts' work.

Sequence files that are not stored in database such as Excel and Txt are also supported by esProc. Due to the ease of use and powerful functions, Excel becomes a widely used tool by salespersons, accountants and decision makers for data computing and analytics. Built-in Excel support of esProc can read data in Excel and export data to Excel. What's more, some scattered data including the quickly and temporarily recorded data by scientific researchers during fast experiments can be read and analyzed by esProc. Other fragmented data which is recorded in mobile phone can also be accessed by esProc.

However, industries like finance, telecommunications, scientific research as well as national security defense have many old systems without common database access interface and support limited formats for data import and export. But these old systems usually support the most used Txt files, including those with extended names, such as ini, log, property and etc. esProc is capable of reading and exporting data from these old interfaces. In addition, esProc can access data in security systems which can't be accessed directly due to outside interface lack and can only be approached through indirect interface.

More Stories By Jessica Qiu

Jessica Qiu is the editor of Raqsoft. She provides press releases for data computation and data analytics.

Cloud Expo Breaking News
SYS-CON Events announced today that Wowrack will exhibit at SYS-CON's 12th International Cloud Expo, which will take place on June 10–13, 2013, at the Javits Center in New York City, New York. Wowrack’s core expertise lies in high-availability Private and Public Cloud IaaS Hosting Solutions. Wowrack provides a true Hybrid service – where business release all IT management and hardware provisioning – taking the data center and server system administrative headaches off our customer’s shoulders. ...
As enterprises deploy private IaaS clouds into production they are reevaluating their future application delivery models. SUSE and WSO2 believe that private PaaS will leverage the automation and scalability of Private IaaS solutions, such as OpenStack-based SUSE Cloud, to deliver the secure, standardized development environments that will make migrating to an agile, serviceoriented delivery model possible. In their session at the 12th International Cloud Expo, Chris Haddad, VP of Technology Ev...
“Open source has always provided a number of benefits, including easing adoption costs, propagating a better understanding of the technology, and allowing for faster evolution and commercialization of products and services based on it,” noted Terry Woloszyn, Founder & CEO, Leeward Security Ltd., in this exclusive Q&A with Cloud Expo Conference Chair Jeremy Geelan. “This is clearly evident with the OpenStack and CloudStack,” Woloszyn continued, “and others that have been quickly commercialized as...
Organizations across the world are increasingly starting to see the benefits of moving more and more services to the cloud. The focus on the cost-saving potential of cloud is rapidly shifting to completely transforming the business with cloud. As organizations are investing enormous sums on technology they are starting to realize that in order to maximize the return on investment and accelerate the business transformation process the first area of focus should be people. By ensuring the organiza...
In his session at the 12th International Cloud Expo, Dave Eichorn, Global Data Center Practice Head at Zensar, will share a case study describing how a utility services company handled the migration of its Microsoft platform to the cloud. Challenged with the time-consuming task of opening operations out of temporary offices, this company struggled with the need to simultaneously access data that was accumulated from a vast amount of data-intensive jobs. Zensar migrated the company’s application ...
SYS-CON Events announced today that OpenStack will exhibit at SYS-CON's 12th International Cloud Expo, which will take place on June 10–13, 2013, at the Javits Center in New York City, New York. OpenStack software controls large pools of compute, storage, and networking resources throughout a datacenter, all managed by a dashboard that gives administrators control while empowering their users to provision resources through a web interface. OpenStack powers some of the most widely-used SaaS app...
You're getting pitched every day from your legacy enterprise software and hardware vendors about "cloud." They're doing an amazing job of convincing your CIO and CTO about what cloud is and how you should use it. The reality is they're defending their shrinking market share and keeping you on the legacy treadmill for as long as they can by selling you solutions that aren't "cloud." In her session at the 12th International Cloud Expo, Niki Acosta, Cloud Evangelista for Rackspace, will talk thro...
“Cloud has everything to do with what has happened with Big Data,” explained Jason Deck, Director of Strategic Alliances at Logicworks, in this exclusive Q&A with Cloud Expo Conference Chair Jeremy Geelan. “Big Data doesn’t exist in its easily accessible way without cloud. From reduced startup costs, to cheap storage, to fast processing, to adequate security, to the easy incorporation of third-party analytics tools, cloud made Big Data accessible to customers of all sizes, with all different bud...
SYS-CON Events announced today that nfina Technologies, a provider of highly reliable cloud server products, will exhibit at SYS-CON's 12th International Cloud Expo, which will take place on June 10–13, 2013, at the Javits Center in New York City, New York. nfina Technologies develops, manufactures, and markets highly reliable cloud server products, designed to solve the most demanding data center requirements in mission-critical cloud applications. Nfina’s staff has decades of experience in co...
Many have heard of OAuth but are unsure of how it might apply to their business. In his session at the 12th International Cloud Expo, Alistair Farquharson, CTO of SOA Software, will describe how OAuth can be used to facilitate certain business models and simplify the sharing of private data. Alistair Farquharson is a visionary industry veteran focused on using disruptive technologies to drive business growth and improve efficiency and agility within organizations. As the CTO of SOA Software A...