Feeds

ParAccel plugs SQL queries into its analytics engine

Thar be money in them old SQL hills, boys!

Choosing a cloud hosting partner with confidence

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. ®

Internet Security Threat Report 2014

More from The Register

next story
Preview redux: Microsoft ships new Windows 10 build with 7,000 changes
Latest bleeding-edge bits borrow Action Center from Windows Phone
Google opens Inbox – email for people too thick to handle email
Print this article out and give it to someone tech-y if you get stuck
Microsoft promises Windows 10 will mean two-factor auth for all
Sneak peek at security features Redmond's baking into new OS
UNIX greybeards threaten Debian fork over systemd plan
'Veteran Unix Admins' fear desktop emphasis is betraying open source
Entity Framework goes 'code first' as Microsoft pulls visual design tool
Visual Studio database diagramming's out the window
Google+ goes TITSUP. But WHO knew? How long? Anyone ... Hello ...
Wobbly Gmail, Contacts, Calendar on the other hand ...
DEATH by PowerPoint: Microsoft warns of 0-day attack hidden in slides
Might put out patch in update, might chuck it out sooner
Redmond top man Satya Nadella: 'Microsoft LOVES Linux'
Open-source 'love' fairly runneth over at cloud event
prev story

Whitepapers

Choosing cloud Backup services
Demystify how you can address your data protection needs in your small- to medium-sized business and select the best online backup service to meet your needs.
Forging a new future with identity relationship management
Learn about ForgeRock's next generation IRM platform and how it is designed to empower CEOS's and enterprises to engage with consumers.
Security for virtualized datacentres
Legacy security solutions are inefficient due to the architectural differences between physical and virtual environments.
Reg Reader Research: SaaS based Email and Office Productivity Tools
Read this Reg reader report which provides advice and guidance for SMBs towards the use of SaaS based email and Office productivity tools.
Storage capacity and performance optimization at Mizuno USA
Mizuno USA turn to Tegile storage technology to solve both their SAN and backup issues.