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
Tools

What's that? The Bureau of Stats has an API and nobody TOLD you?

Australia's national data-collector, the Australian Bureau of Statistics, has quietly published an API to its data sets. While it won't replace most peoples' preferred (or at least tolerated) means to get ABS data - the spreadsheets and CSVs the ABS provides for easy database ingestion - the API will allow others to embed ABS …
Patching celebration

Sysadmins rejoice! Patch rampage killing off nasty DDoS attack vector

Sysadmins rejoice! NSFOCUS researchers say hundreds of thousands of Network Time Protocol (NTP) servers have been patched, reducing the threat from some devastating and cheap distributed denial of service (DDoS) attacks. The patching rampage saw the number of vulnerable NTP servers drop from 432,120 at the start of the year to …
Darren Pauli, 25 Jun 2014
HTML versions found online in the UK between 1996 and 2010

Watch this: Using Foundation for responsive design

Youtube Video Mobile Ready and responsive development are the must know skills for anyone involved with web development, Juggling the HTML5, CSS3 and Javascript is a challenging ask but Foundation is here to help! A rapid prototyping and industrial scalable framework it makes responsive design a simpler and more straightforward …
David Gordon, 06 Jun 2014
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
Azure Index

Redmond in rapid rebuild after sysadmin request STUNNER

Microsoft has released a few useful tweaks to System Center Advisor, its online log file analysis, monitoring and alerting service, and says actual users asked for the new features it has created. System Center Advisor emerged at TechEd North America, way back in May, and offers a graphical representation of log files emitted by …
Simon Sharwood, 28 Jul 2014
4 racks of V7000 boxes

'Behold my creation: Postgres-XL' bellows TransLattice

Database upstart TransLattice has burped out a new free version of the Postgres database, based on tech it acquired from StormDB. It claims the softweare is ideal for supporting modern web-based applications. The company reckons this database, dubbed Postgres-XL, has "extreme online transaction processing scalability and …
Jack Clark, 13 May 2014
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

Point DNS blitzed by mystery DDoS assault

Domain hosts Point DNS has been hammered with a high intensity DDoS attack on Friday, knocking servers out for hours. The size of the attack and techniques used - much less who might be behind the attack - remains unclear. Several Reg readers got in touch to notify us about the issue and the company confirmed the attack online …
John Leyden, 09 May 2014
Google walks

Google adds 'data protection' WARNING to Euro search results

Google has begun notifying European Union-based netizens that its search results have to respect the 28-member-state bloc's 19-year-old data protection law. The ad giant has plastered the warning on its search engine across the EU from today. But, anyone living in those countries who navigate to Google.com will find that the " …
Kelly Fiveash, 26 Jun 2014
Paris Hilton in Faster Pussycat! Kill! Kill!

Google: Grab our TOOL if you want your search query quashed

Google is now offering European Union netizens a hastily thrown together online form they can fill in to submit requests for certain types of links to be removed from the ad giant's search index. It comes after the EU's highest court ruled earlier this month that Google can be held responsible for the type of personal data that …
Kelly Fiveash, 30 May 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

iFind: Critics slam Kickstarter campaign for miraculous battery-free phone finder

As the old saying goes: if it sounds too good to be true, it probably is. It remains to be seen if that adage applies to iFind - hailed as "The World's First Battery Free Item Locating Tag". As of Monday morning, iFind - the brainchild of "WeTag" - had attracted over $500,000 of funding on Kickstarter, thanks to the support of …
Lester Haines, 24 Jun 2014

British Gas Twitter account hijacked by mystery phishermen

An official British Gas Twitter account was hacked over the weekend as part of a phishing scam designed to harvest Twitter login credentials. The account @BritishGasHelp, which is normally geared towards helping people with boiler breakdowns and other queries, was taken over to push a series of ostensibly jokey tweets. The …
John Leyden, 23 Jun 2014
hitahi t7k500 hard disk drive

High-end storage tanked, but 'HDPA' storage about to soar says IDC

Box-counter IDC recently decreed that 2014's first quarter was a shocker for high-end storage sales, but also predicts things are looking up in storage used for what it now calls “high performance data analysis” (HPDA). IDC's veep for HPC and data analysis Steve Conway puts HDPA in a little perspective with a canned quote …
Simon Sharwood, 19 Jun 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 …
From left to right: Mastodon, mammoth, gomphothere. Credit: Sergio de la Rosa

Hadoop coop's $50m scoop: Hortonworks takes HP coin

Hadoop has become a strategic battleground for three of the world's most influential technology companies, judging by HP's $50m investment into Hadoop company Hortonworks. The injection, which was announced on Thursday, follows Google Capital – the web giant's investment arm – leading a $110m fundraising round for Hadoop rival …
Jack Clark, 24 Jul 2014

Power BI: Office 365 just got more intelligent

If a picture tells 1,000 words, then an interactive bubble chart indexed by year based on a data model with a hierarchy of sub-categories ought to speak volumes. Microsoft’s business intelligence product Power BI is the latest addition to Office 365, its online office suite designed to integrate with desktop versions of Office …
Danny Bradbury, 29 Jun 2014
OpenStack Summit

Disks with Ethernet ports? Throw in some flash and you've got yourself a HGST p-a-r-t-y

Western Digital Corp subsidiary HGST is developing Ethernet-connected drives for OpenStack users – and they won't require any application software changes, apparently. The architecture of such a product will be demonstrated by HGST at the OpenStack Summit, to take place between 12 and 16 May in Atlanta, GA. The presentation …
Chris Mellor, 08 May 2014
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 …

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
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
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 …

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

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
European Union Flag

Europe: Apple could NOT care less about kids' in-app cash sprees

The European Commission has put Apple on the naughty step over its apparent failure to tackle costly in-app purchases. But the EU body gave Google top marks for the suggestions it put forward. On the back of mounting complaints, the EC earlier this year invited both companies for a chat about the way games and other apps can …
Paul Kunert, 18 Jul 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
Ski the Santa Clara police dog

Google will 'pre-select' an 'independent' competition inspector in EU search case

Competition chiefs in Brussels have begun sending out rejection letters to complainants in the long-running Google search antitrust case, revealing - among other things - that the ad giant will be picking candidates for the role of "monitoring trustee". The person or persons appointed to the role will be expected to …
Kelly Fiveash, 18 Jun 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
SAP Match Insights

SAP: It was our Big Data software wot won it for Germany

When England played in Ecuador and Honduras for “warm weather training” in June ahead of the World Cup, they’d already lost the tournament – they just didn’t know it. SAP Match Insights Do the bendy data, SAP Wayne Rooney and Co took to the field in Florida to adjust to the hot and humid climate they’d face in Brazil and to …
Gavin Clarke, 22 Jul 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

Microsoft's naughty Cortana NOT ALLOWED NEAR CHILDREN

Microsoft's new Cortana personal assistant platform carries privacy concerns that prevent it from being used by children – but Redmond appears to not be alone in its pre-pubescent banishment. Redmond said that the voice-activated search tool in its mobile platform currently carries a minimum age requirement of 13 years, which is …
Shaun Nichols, 25 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
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

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
Sign outside the National Security Agency HQ

HOLD THE FRONT PAGE: US govt backs mass spying by US govt

The US government's Privacy and Civil Liberty Oversight Board (PCLOB) has dealt a blow to opponents of the NSA's surveillance programs in a new report that reaffirms the controversial Section 702 program. The PCLOB said in its official review of the program that 702 represented a "considerable value" to the government despite …
Shaun Nichols, 03 Jul 2014

You want a medal for writing a script? Sure: here it is!

Software engineer and Arizon Army National Guard member Vivin Paliath has explained how writing some Perl and Excel macros saw him decorated with the Army Commendation Medal, a decoration awarded “to any member of the Armed Forces who distinguishes himself or herself by heroism, meritorious achievement, or meritorious service.” …
Simon Sharwood, 27 Jun 2014

Oracle: That BUG in our In-Memory Option will be fixed in October

After much back-and-forth on blogs, Twitter, and online forums, Oracle has admitted that there is a bug that can cause its new in-memory database option to be reported as being in use when it's not, although the actual risk it poses remains unclear. As reported by The Register last week, database pro Kevin Closson was the first …
Neil McAllister, 31 Jul 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
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
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
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

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