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

Woe, Daddy! GoDaddy customers wail as hosting service GOES TITSUP

Hosting outfit GoDaddy is suffering what appears to be a pretty widespread outage hitting website operators in the UK this morning. The company's own site was struggling to load at time of writing. A miserable message wrapped in a pink box on GoDaddy's support page coughs to a "known issue" with its hosting system. However, The …
Kelly Fiveash, 01 Sep 2014
Burning copyright symbol. Photo by: Martin Fisch http://www.flickr.com/photos/marfis75/ on flickr"

Microsoft bins Bing image widget after Getty sueball

Microsoft has taken down the Bing images widget that so offended Getty Images that it flung a sueball in Redmond's direction last week. As Getty's complaint (reg-and-paywalled) states, “The Bing Image Widget allows website publishers to embed a panel on their websites that will display digital images supplied by Defendant …
Simon Sharwood, 09 Sep 2014

Google ghostly graphics haunt Image search

A slam dunking NBA star and a fatal car crash isn't normally what you'd expect to find when Googling for puppies, but it is exactly what users have received overnight due to some unknown perversion of Google Images. The bug affected a scattering of users from dozens of countries. Australia, the US, the UK and many others noticed …
Darren Pauli, 27 Aug 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
Smug ginger tom

EE accused of silencing customer gripes on social media pages

EE has dismissed claims that its social media staff are attempting to hush fair criticism levelled at the mobile operator on sites such as Facebook. A company spokesman told The Register that it was wrong for subscribers to claim that they were being silenced by EE just for posting complaints about the network online. EE has …
Kelly Fiveash, 27 Aug 2014
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

The Schmidt hits the clan: Google chief mauls publishers' 'abuse of dominance' claims

Google's exec chairman Eric Schmidt has hit back at publishers for complaining about the multinational's alleged dominance in the search market in Europe in a series of splashy newspaper ads today. He said in a blog post this morning that the "serious nature" of the claims - that Google favours its own search products, such as …
Kelly Fiveash, 06 Sep 2014
dropbox privacy security eye

FAIL.GOV – Government asks Dropbox for accounts that don't exist

Dropbox has released its transparency report for the first half of 2014 and says it's handled 120 search warrants, a pair of court orders, 109 subpoenas, between zero and 249 national-security-related requests and 37 requests from governments other than that of the USA. None of the requests pertained to business accounts. …
Simon Sharwood, 12 Sep 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
B&W film still of man with electric drill.

Is your data boring? MapR wants you to bore it back with Apache Drill

MapR has given its customers a new way to use SQL to query their Big Data stores, with the addition of Apache Drill to MapR's eponymous Hadoop distribution. Drill is an open source project developed largely by MapR that aims to create a work-alike to Google's proprietary Dremel data analytics tool, which the Chocolate Factory …
Neil McAllister, 16 Sep 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

Google's 'right to be forgotten': One rule for celebs, another for plebs

Celebrity names won't trigger a Google right to be forgotten disclaimer notice, but yours will. A Google of most of our names will throw up this disclaimer – which makes us appear rather shady – but Stephen Fry needn't worry Google is covering its back following the so-called right to be forgotten ruling in the European Court …
Jennifer Baker, 06 Aug 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 …

'Big data' predicts stock movements, boffins claim

Researchers from the Warwick University's business school reckon they can predict the next crash, by watching Google searches and Wikipedia. The supposed power of Google as a predictive tool has been popular in academia ever since The Chocolate Factory unveiled Google Flu Trends back in 2008. Its usefulness for real-world …
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
Tools

EnterpriseDB chucks devs free tools to craft NoSQL web apps with PostgreSQL

Enterprise-class PostgreSQL database vendor EnterpriseDB has launched a free turnkey development environment designed to make it easier for coders to build web applications using PostgreSQL's new NoSQL capabilities. The open source PostgreSQL project has been adding NoSQL-like features for the past couple of versions, most …
Neil McAllister, 19 Aug 2014

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

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 …
One of New Zealand Post's commemorative Hobbit coins

Nude celeb pics wrongly blamed for DDOS at New Zealand's largest ISP

New Zealand's largest ISP, Spark, has spent the weekend fighting off a DDOS incorrectly assumed to have a connection with last week's nude celebrity picture scandal. The ISP hit trouble last Friday, when it Tweeted that some of its subscribers had become infected with malware that was flooding its DNS servers and making it hard …
Simon Sharwood, 08 Sep 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
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 …
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

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
NSA parody T-shirt

Naughty NSA was so drunk on data it forgot collection rules

Declassified documents from America's Foreign Intelligence Surveillance Court (FISC) shows that even the NSA didn't know the limits of what it was supposed to collect, and overstepped its authorisations for years. The documents were released to the Electronic Privacy Information Centre in response to an FOI request, and record …

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
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
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
Fail and You

Oracle Database 12c's data redaction security smashed live on stage

Oracle’s much-ballyhooed data redaction feature in Database 12c is easy to subvert without needing to use exploit code, attendees at Defcon 22 in Las Vegas have heard. The redaction features in 12c are designed to automatically protect sensitive database material by either totally obscuring column data or partially masking it – …
Iain Thomson, 08 Aug 2014
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
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

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