Feeds

ParAccel plugs SQL queries into its analytics engine

Thar be money in them old SQL hills, boys!

SANS - Survey on application security programs

Strata 2013 Amazon-blessed database company ParAccel has layered an analysis suite for SQL users on top of its technology.

The extra analytic capabilities – social-media parsing text features, sessionization, JSON parsing, and pattern matching – combine to make the complex system a little bit more attractive to old SQL pros, ParAccel announced on Wednesday.

"A common challenge for ingesting web data is understanding the characteristics of sessions," Walt Maguire, ParAccel's analytics director, told The Register.

Trendy tools like Hadoop can be clunky to use when you need to generate new analytical reports, Maguire said, while existing tools for getting a broad swathe of insight into how people are behaving on your website entails paying a big wodge of cash for a service like Omniture.

ParAccel hopes its new analytical suite will let the database sit somewhere in between the two, giving it a little bit of the flexibility for on-the-fly reports of a typical online metric suite, and some of the computational heft of a platform such as Hadoop.

"In Hadoop it's a brittle, time-consuming process to flex [data] – a lot of people pay Omniture for that," Maguire said.

Some of ParAccel's features, such as tokenization, can help companies analyse social data, such as when someone tweets hashtags that are highly relevant for monitoring the spread of a certain keyword but are (mostly) useless if running large-scale sentiment analysis.

Another feature includes stemming and spell correction, so the system can group various misspelled messages (ones containing "your" along with other keywords can be linked to ones contained "yor" or "yr" or other common abbreviations and howlers) together for further analysis.

ParAccel's features are part of a growing trend in the database and "big data" industry to embed some SQL-like querying into its distributed unstructured data products. The database, cognizant of this, already comes with node-to-node Hadoop connectors that let it transfer data and processes in and out of Hadoop in both directions.

"There's a huge race on right now for SQL access to Hadoop data," ParAccel's vice president of solutions John Santaferraro told The Register. "When we look at some of what's being offered to the marketplace, they're taking a little sliver of SQL capabilities," he said.

The functions will be available within the first half of 2013. The company is still deciding on whether to charge extra for the features or bundle them with the existing ParAccel database. ®

3 Big data security analytics techniques

More from The Register

next story
OpenBSD founder wants to bin buggy OpenSSL library, launches fork
One Heartbleed vuln was too many for Theo de Raadt
Got Windows 8.1 Update yet? Get ready for YET ANOTHER ONE – rumor
Leaker claims big release due this fall as Microsoft herds us into the CLOUD
This time it's 'Personal': new Office 365 sub covers just two devices
Redmond also brings Office into Google's back yard
Ubuntu 14.04 LTS: Great changes, but sssh don't mention the...
Why HELLO Amazon! You weren't here last time
Patch iOS, OS X now: PDFs, JPEGs, URLs, web pages can pwn your kit
Plus: iThings and desktops at risk of NEW SSL attack flaw
Next Windows obsolescence panic is 450 days from … NOW!
The clock is ticking louder for Windows Server 2003 R2 users
Batten down the hatches, Ubuntu 14.04 LTS due in TWO DAYS
Admins dab straining server brows in advance of Trusty Tahr's long-term support landing
Red Hat to ship RHEL 7 release candidate with a taste of container tech
Grab 'near-final' version of next Enterprise Linux next week
Apple inaugurates free OS X beta program for world+dog
Prerelease software now open to anyone, not just developers – as long as you keep quiet
prev story

Whitepapers

Mobile application security study
Download this report to see the alarming realities regarding the sheer number of applications vulnerable to attack, as well as the most common and easily addressable vulnerability errors.
3 Big data security analytics techniques
Applying these Big Data security analytics techniques can help you make your business safer by detecting attacks early, before significant damage is done.
The benefits of software based PBX
Why you should break free from your proprietary PBX and how to leverage your existing server hardware.
Securing web applications made simple and scalable
In this whitepaper learn how automated security testing can provide a simple and scalable way to protect your web applications.
Combat fraud and increase customer satisfaction
Based on their experience using HP ArcSight Enterprise Security Manager for IT security operations, Finansbank moved to HP ArcSight ESM for fraud management.