Feeds

Articles about Queries

Bezos headshot

Phew! These DynamoDB queries are heavy. C'mon Amazon, give us a hand

Amazon has brought global secondary indexes to its non-relational, rentable DynamoDB database. The upgrade means cloud wranglers can perform more complicated queries on data stored in the system without having to sacrifice latency. It achieves this by implementing Global Secondary Indexes (GSIs) – a feature that lets admins …
Jack Clark, 13 Dec 2013
MapR logo

MapR revs up HBase queries with M7 Hadoop distro

You are not just imagining it. Every commercial distributor of the Hadoop system for storing and chewing through unstructured data has come up with its own a different way to deliver something akin to SQL query functionality while at the same time boosting the speed of ad hoc queries. MapR Technologies is one of the earlier …
Apple Maiden data center Teradata

Teradata boosts DRAM on appliances for in-memory queries

If it were as simple as adding more main memory to a server to crank up the performance of a parallel database, Teradata would have done it by now. But with memory capacities going up on x86 servers and memory prices coming down, now is the time to add more in-memory processing to data warehouse appliances – and that is …
The Register breaking news

ParAccel plugs SQL queries into its analytics engine

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 …
Jack Clark, 28 Feb 2013
traffic lights

Microsoft pulls its crowd-control tech from out of the shadows

Microsoft pushed its Windows Azure load balancing technology into general availability amid a widespread DNS disruption. The rollout of "Traffic Manager" was announced on Thursday, and the tech lets admins apply a policy engine to DNS queries to domain names hosted on Azure. The tech works by redirecting user queries to a …
Jack Clark, 23 Nov 2013
SoftLayer's data center

Oracle's NoSQL nightmare MongoDB goes to version 2.6

Upstart database MongoDB has reached its 2.6 release armed with technologies that its backing company says represent "a foundation for the next decade of database innovation." The 2.6 release of the NoSQL document-oriented database became generally available on Tuesday. With this version, the database's eponymous steward MongoDB …
Jack Clark, 08 Apr 2014
Great Wall of China

Microsoft denies reports of scrubbing Chinese-language Bing searches

Microsoft's Bing search engine is returning suspiciously pro-state results for Chinese-language searches even when those searches come from outside of China, activists claim. The Guardian noted that a number of Chinese-language activist blogs are reporting that the results they have been seeing on Bing searches from within the …
Shaun Nichols, 12 Feb 2014

British Gas applies to wind up UK colo outfit Alphadex

British Gas has filed a petition to wind up UK colocation outfit Alphadex. It's the second time Alphadex has found itself in trouble in recent weeks. In early March it experienced significant outages, drawing understandable ire from its users. The company has since explained the incident as having been caused by “unsecured …
Simon Sharwood, 09 Apr 2014
bug on keyboard

Telstra to DNS-block botnet C&Cs with unknown blacklist

Telstra is preparing to get proactive with malware, announcing that it will be implementing a DNS-based blocker to prevent customer systems from contact known command-and-control servers. The “malware suppression” tool will will be introduced at no cost for fixed, mobile and NBN customers using domestic broadband and Telstra …
bug on keyboard

Joomla issues upgrade to patch critical SQL vuln

Joomla's developers have moved to fix a critical SQL injection vulnerability – but are coming under fire for taking a month to address the issue. The version 3.2.3 update, available since late last week, is described by Joomla as fixing a high priority core SQL injection bug (along with two medium priority XSS bugs and an …
bug on keyboard

Microsoft spells out new rules for exiling .EXEs

Microsoft has updated the methodology it uses to define adware, a move designed to make it clearer just what the company considers worthy for removal by its malware tools. Redmond's new rules are simple: an application is adware if any of the following criteria are met: It breaks the “unwanted behaviour” rules (in more detail …

Google inflates BigQuery AaaS

Google has expanded its BigQuery analytics-as-a-service product via price cuts, new features, and more sophisticated commands. The upgrades to BigQuery were announced by Google on Tuesday, and see the company let BigQuery output query results of larger than 128MB, along with being able to ask it more sophisticated queries. …
Jack Clark, 11 Jun 2013

Don't look at Maria's SQL, look at MY SQL, pleads Oracle

Oracle says it has doubled the performance of its open source MySQL database when running over large datasets across more than 40 cores, as it strives to preserve its lead in a market thronging with credible contenders. Oracle gave details of a "Development Milestone" release of version 5.7 of its MySQL database on Monday, …
Jack Clark, 02 Apr 2014
Facebook drowning

Hey, Presto! Facebook spills petabyte-munching SQL brain sauce online

Facebook has come through on its promise to publish its Hive-beating "Presto" analysis software as open source. The code was made available by the social network today under the Apache v2 license, giving developers access to an ANSI-SQL compatible data query and analysis engine that is faster than Apache Hive, and competes with …
Jack Clark, 06 Nov 2013

We don't want your crap databases, says Twitter: We've made OUR OWN

Twitter is growing up and, like an adult, is beginning to desire consistent guarantees about its data rather than instant availability. At least that's the emphasis placed by the company on its new "Manhattan" data management software, a bedrock storage system that was revealed in a blog post on Wednesday. What's not mentioned …
Jack Clark, 04 Apr 2014
Cnidaria jellyfish

Twitter co-founder wraps tentacles around Q&A market, squirts out Jelly

Twitter co-founder Biz Stone launched a search app dubbed Jelly on Tuesday that he hopes will conquer the already packed-like-sardines online Q&A market. The concept behind the app appears to rely on Facebook and Twitter hive minds. Stone stopped short of calling it that, however, preferring instead to say that "Jelly is …
Kelly Fiveash, 08 Jan 2014

Netcraft adds Heartbleed sniffing to site-scanning browser tool

Internet stats clearinghouse Netcraft has released a new tool aimed at letting consumers know when the sites they visit might have been compromised by the Heartbleed encryption bug. There are lots of tools available that can scan servers to determine whether they're affected by the Heartbleed vulnerability right now, albeit of …
Neil McAllister, 18 Apr 2014

Meta search engines may infringe database rights: EU Court of Justice

Operators of websites in the EU that allow users to search for content on other sites and then display the information on their own site may be in breach of intellectual property laws as a result of a recent ruling by the EU's highest court. In a judgment issued last month, the Court of Justice of the EU (CJEU) said that …
OUT-LAW.COM, 13 Jan 2014

VCs flash cash for Looker's SQL-on-steroids business intelligence tool

Business intelligence is the site of a new goldrush as the twin marketing totems of "big data" and "cloud" collide, creating a supernova of splashy cash for canny firms. So it is with little surprise that a BI startup headed by former Greenplum exec Frank Bien and Netscape technologist Lloyd Tabb has announced $16 million in …
Jack Clark, 13 Aug 2013
The Register breaking news

Amazon's flash-backed database gets EVEN FASTER

Amazon has tuned-up its flash-backed DynamoDB database so that more complex queries can be done in less time. Amazon announced the upgrade on Thursday, which sees the cloud computing company add in a "Local Secondary Index" (LSI) feature that lets admins create five additional indexes across which to query, letting the DB do …
Jack Clark, 19 Apr 2013
Hadoop Elephant

Elders tell cluster tool Apache Spark it's time to quit chillin' in the crib

The Apache Foundation has promoted a fast data-processing tool out of the Apache Incubator in a further sign of the maturity of the Hadoop family. Apache Spark is a fast processing layer for computing data stored within the open-source Hadoop file system or other shared file systems such as NFS. It supports Scala, Java, and …
Jack Clark, 18 Feb 2014
Blindfold

Cisco execs blindside themselves with flash-splash Invicta UCS array

Sources indicate that Cisco’s top execs blundered when they thought the UCS Invicta all-flash array wouldn’t compete with flash arrays from partners EMC and NetApp because it was integrated into the UCS server fabric. Our people suggest that they didn’t understand, when given UCS Invicta integration information by lower-level …
Chris Mellor, 03 Feb 2014
Google sign outside Mountain View headquarters

Google gives Maps a lick of paint, smears it over screens worldwide

Google is preparing to complete the rollout of its redesigned online Maps service. The refreshed satnav-like site was debuted by the web king at its developer conference in May last year, and since then has been shown to some users around the world. "Thanks to your helpful feedback, we're ready to make the new Maps even more …
Jack Clark, 20 Feb 2014
The Register breaking news

MP queries Hargreaves review

An MP has tabled a parliamentary question to find out how BIS arrived at its panel of advisors for the Hargreaves Review. Five experts are advising the former FT journalist with his six-month review into "IP and Growth". But two in particular – campaigning professor James Boyle and former web monkey Tom Loosemore – have raised …
Andrew Orlowski, 16 Dec 2010
Easter Egg

Violin plays storage world like a fiddle, 140 characters at a time

Violin Memory's flash array fightback starts with a present from the Easter bunny: a whole new array. Violin, you will recall, lost CEO Don Basile after its IPO was followed by deepening losses and falling share prices. Incoming CEO Kevin DeNuccio has stabilised the ship, refocussed engineering and recruited new executives, one …
Chris Mellor, 11 Apr 2014

Google Research: Three things that MUST BE DONE to save the data center of the future

One prominent member of Google Research is more concerned with the challenges of speedily answering queries from vast stores of data than he is about finding business intelligence hidden inside the complexities of that omnipresent buzzword, "big data". In fact, Google Fellow Luiz André Barroso, speaking at ISSCC on Sunday night …
Rik Myslewski, 11 Feb 2014

MtGox to customers: Your call is important to us … NOT!

Bitcoin owners keen to understand just what failed exchange MtGox may be able to do for them remain in the dark, after the outfit set up a call centre that, so far as The Register can tell, seldom picks up the phone. MtGox declared bankruptcy last week, taking more than $US400m worth of Bitcoin with it. Users are understandably …
Simon Sharwood, 03 Mar 2014

Presto: Facebook reveals exabyte-scale query engine

Facebook has revealed a query engine for data warehouses that blows the doors off Hive, and plans to publish it as open source this year. The "Presto" technology is a query execution engine built for Facebook's vast data warehouse. It was announced on Thursday at a data analytics conference hosted at Facebook's HQ in Menlo Park …
Jack Clark, 07 Jun 2013
DNS? It's a real bind

DNS poisoning slams web traffic from millions in China into the wrong hole

A widespread DNS outage hit China on Tuesday‪, leaving millions of surfers adrift.‬ DNS issues in China between 7am and 9am GMT left millions of domains inaccessible. Two-thirds of China’s DNS (Domain Name System) infrastructure was blighted by the incident, which stemmed from a cache poisoning attack. Chinese netizens were …
John Leyden, 21 Jan 2014
Photo of the KitKat mascot among the Android lawn statues

I'm Feeling LUCKY OR LAZY™? Chrome gets hands-free voice search

Google has developed a Chrome plugin to allow desktop users to activate the browser's voice-controlled web search feature just by saying "OK, Google". The advertising giant said the "hotword" will start a Google search without any clicking or typing in of queries required. Users just have to say "OK Google" followed by a search …
Shaun Nichols, 27 Nov 2013

AWS speeds content delivery, Gangnam style

Developers and businesses keen to reach customers in the the most connected country on the planet received a boost this week after Amazon Web Services announced a South Korean edge location in Seoul for its CloudFront and Route 53 platforms. The cloudy giant’s sixth location in Asia and 40th globally will help accelerate the …
Phil Muncaster, 03 May 2013
The Valley - code

Facebook helps coders get their Rocks off with flash-wringing DB lib

Facebook has developed an open-source database library that wrings more performance out of server-side flash storage than ever before, while building on previous technology published by Google. The RocksDB embeddable persistent key-value store was announced by Facebook on Thursday, and gives developers a C++ library based on …
Jack Clark, 21 Nov 2013
Google_Hummingbird

Google reveals its Hummingbird: Fly, my little algorithm - FLY!

As more people have come online, the way people search has changed - so Google has overhauled its algorithms to better deal with the vague, rambling questions we bombard it with. The new "Hummingbird" update was announced by Google at a shock-and-awe PR event held in the Menlo Park garage where the ad-slinger spent its early …
Jack Clark, 26 Sep 2013
VMware's monster VM

It's storage's HOLY GRAIL: VSANs, PSANs and virtual silos

Three blog posts about VMware’s VSAN had me thinking furiously. Where is VMware going with this and where could or should it go? The first blog was Storagebod on VSANity in which he says VSAN, the ESXi hypervisor’s aggregating of server-direct attached storage (DAS) into a virtual SAN, was nice up to a point. He asks: “Why limit …
Chris Mellor, 21 Mar 2014
SimCity

Remember when SimCity ABSOLUTELY HAD to be online? Not any more – fancy that!

Gamers will soon be able to play Maxis's SimCity offline – despite the company's earlier insistence that the game absolutely had to be connected to the internet to work. The turnaround was announced by Maxis studio manager Patrick Buechner in a blogpost on Sunday. He said Update 10 for the latest installment of the long-running …
Jack Clark, 13 Jan 2014

AMD: Why we had to evacuate 276TB from Oracle DB to Hadoop

AMD has migrated terabytes of information from an Oracle Database installation to an Apache Hadoop stack, claiming Oracle's pricey software was suffering from scaling issues. The chip maker's chief information officer, Jake Dominguez, revealed further details of the transfer in a chat with The Reg. "Within the common Oracle …
Jack Clark, 24 Mar 2014
The Register breaking news

Google says it can predict movie box office with 94% accuracy

What makes a successful movie? Is it a good plot? Strong characters? Popular leading actors? Impressive special effects? Not necessarily, says Google – and moreover, the online giant says it's figured out how to predict a film's box office performance with up to 94 per cent accuracy. According to a Google whitepaper published on …
Neil McAllister, 06 Jun 2013

NO XMAS PRESENTS FOR Google Now and Siri: Chirpy scamps get a C+

A series of tests on the effectiveness of iOS and Android's voice-controlled search apps shows that Google Now is catching up on Apple's Siri software, but still has some way to go in beating its Cupertinian competitor. Piper Jaffray analyst Gene Munster asked the two personal-assistant programs 800 questions apiece – half …
Iain Thomson, 11 Dec 2013
Evil Android

Google burns promise of 'no big banner ads'. Don't Be Evil next?

Google is toying with the idea of allowing big banner ads to run at the top of its search results pages - in a move that apparently breaks an eight-year-old promise. The Mountain View web goliath is, we're told, "running a very limited, US-only test" of the billboards. A Google spokesman confirmed to the AFP news agency today …
Kelly Fiveash, 24 Oct 2013
HGST SSD1000MR

Amazon slides first flash hardness into Redshift data muncher

Amazon has added compute nodes with flash drives to its cloudy data warehouse Redshift – as the e-retailer turned computer-renter takes on Teradata, Greenplum, Oracle, IBM and the like. The two "Dense Compute Nodes" were announced today by Bezos & Co: these are solid-state-drive-backed server options to sit alongside the disk- …
Jack Clark, 24 Jan 2014

NSA headman: 'Don't worry, our watchful analysts TAKE EXAMS'

NSA head General Keith Alexander believes the NSA's data-slurping programs should "be something we put forward as an example to the rest of the world," due to the oversight afforded by the courts, Congress, and the administration. The spy chief made his remarks at the Black Hat security conference in Las Vegas on Wednesday, …
Jack Clark, 31 Jul 2013
Seagate Delorean drive

Google goes back to the future with SQL F1 database

The tech world is turning back toward SQL, bringing to a close a possibly misspent half-decade in which startups courted developers with promises of infinite scalability and the finest imitation-Google tools available, and companies found themselves exposed to unstable data and poor guarantees. The shift has been going on …
Jack Clark, 30 Aug 2013

Day 2: Gov web catalogue CloudStore still in darkness

Older methods are sometimes still the best and public sector buyers that want to buy services via CloudStore have been advised to email enquiries to the Cabinet Office. The government's web catalogue of suppliers, CloudStore is down for the second day following maintenance work on Friday that seemingly caused more glitches than …
Paul Kunert, 12 Nov 2013
PivotalHD

Pivotal: So who fancies skinny-dipping in our 'Business Data Lake'? PS: It'll cost you

EMC and VMware's spin-off Pivotal is trying to make money from a bevy of open-source big-data-crunching technologies by making their most complicated aspects disappear. With the launch of Hadoop distribution Pivotal HD 2.0 and analytics engine Pivotal GemFire XD on Monday, the company has created a clutch of technologies that …
Jack Clark, 18 Mar 2014

APNIC boffins may enlist TCP to defend DNS

Could defending the Domain Name System (DNS) infrastructure against amplification attacks be as simple as switching protocols in resolvers? Probably not – but an experiment conducted at APNIC has far-reaching implications. As Geoff Huston, chief scientist at APNIC, writes, DNS amplification attacks are easy to launch and can be …
The Register breaking news

Who's a Siri boy, then? Apple hoards your voices for TWO years

A leading UK privacy warrior has urged Apple to explain itself after the tech titan admitted Siri queries are kept on record for two years. Nick Pickles, director of pressure group Big Brother Watch, spoke out after the iPhone maker today revealed exactly how long it retains questions fired at its voice-controlled personal …
Jasper Hamill, 19 Apr 2013
The Hubble Extreme Deep Field (XDF): an image of a small area of space in the constellation Fornax, created using Hubble Space Telescope datafrom combined Space Telescope exposures taken over a decade

MIT scientists craft a storage system fit for THE ENTIRE UNIVERSE

Distributed file systems may be cheap to run, but their performance can be atrocious when the network becomes saturated, and some boffins are hoping to change this so to better simulate our universe. MIT researchers have tried to solve the network saturation problems bought about by SSD-loaded distributed storage systems with a …
Jack Clark, 31 Jan 2014

EMC touts screeching Hawq SQL performance for Hadoop

EMC's Pivotal Initiative division made a big splash last week with the launch of its Pivotal HD distribution of Hadoop. This is not a normal Hadoop distribution, but one that takes the parallel guts of the Greenplum database and reworks them to transform the Hadoop Distributed File System (HDFS) into something that speaks …
Outlook.com logo

Outlook son of Hotmail goes titsup for many in the US and UK

Hotmail Outlook services are down for some users and have been for most of today, although it's unclear what the issue is. While many users have taken to Twitter to complain that they can't access their emails, others have said they have been able to access the service, suggesting that the problems hasn't spread worldwide. …
Pickaxe

Apple gets into Twitter data-mining biz with mystery Topsy buy

In an unanticipated move, Apple has acquired Twitter analytics firm Topsy – though what it plans to do with its latest purchase is anyone's guess. The Wall Street Journal reports that Cupertino recently snapped up the six-year-old venture-backed startup for more than $200m. Topsy specializes in analyzing data from the Twitter " …
Neil McAllister, 03 Dec 2013