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

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

AWS CloudFront wobbles at worst possible time

Don't start your Black Friday online shopping spree just yet: Amazon Web Services' CloudFront content delivery network has wobbled over the last few hours and the perennially-loss-making retailer, and customers of its cloud computing services, have reportedly been hard to access. Amazon's status page said “We are currently …
Simon Sharwood, 27 Nov 2014
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 …

Microsoft improves Azure SQL Server cloud service, simultaneously makes it worse

Microsoft has announced improvements to its Azure SQL Database service, which offers a managed SQL Server database with patching and operating system maintenance handled automatically by the cloud service. At the Professional Association for SQL Server (PASS) summit currently under way in Seattle, Microsoft Data Platform VP T.K …
Tim Anderson, 06 Nov 2014
Close-up of the flu virus (artist's impression) - Shutterstock

VirusTotal wants YOU (but not you) to join its epic AV whitelist

Google-owned VirusTotal wants large software houses to send in their software catalogues so it can build what could well end up being one of the world's biggest anti-virus whitelists. The whitelist would clarify to users that software being checked for cleanliness came from a recognised developer, and warn vendors and anti-virus …
Darren Pauli, 12 Feb 2015
"Image from the glassbrain project, neuroscapelab.com, UCSF

OH HAPPY DAY! Lawyers replaced by AI

Artificial intelligence is a worry on two fronts. In a worst-case scenario, we end up with The Terminator. In a less-painful scenario, we end up with billions of humans out of work as drudgery is replaced by machines. The second scenario looks just a little bit closer today, but also less painful, after the advent of “ROSS”, a …
Simon Sharwood, 30 Jan 2015

TrueCrypt + Norton AV = BSOD, wail disgruntled users

Updated Encrypted disk users who upgrade to Norton 2015 have been confronted by the dreaded Blue Screen of Death. Norton 2015 appears to trigger a crash on Windows 8.1 PCs that runs a disk encryption driver, according to user complaints about the problem in a thread on a Symantec support forum. Many of those affected are running …
John Leyden, 20 Feb 2015
Smilin' Marv

P0wned plug-in puts a million WordPress sites at risk of attack

Up to a million WordPress websites could be open to full compromise through a vulnerability in the WP-Slimstat plug-in, security bod Marc-Alexandre Montpas says. The weak key flaw can expose admin credentials; bad news for the folks who've downloaded the plug-in 1.3 million times. A patched version of the plug-in has been …
Darren Pauli, 26 Feb 2015
HTML versions found online in the UK between 1996 and 2010

Watch this: Using Foundation for responsive design

Video 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

FYI: OS X Yosemite's Spotlight tells Apple EVERYTHING you're looking for

There has been growing disquiet over Apple's desktop search app Spotlight, which sends queries for things back to the company's servers to process. Spotlight phones home in OS X Yosemite, version 10.10, and it is enabled by default: it can be switched off, but with Apple insisting that it now takes people's privacy seriously, …
John Leyden, 20 Oct 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

Lloyds supplier payments TITSUP: What, you want MONEY from a BANK?

Exclusive Lloyds Banking Group’s (LBG) failure to settle debts with some tech suppliers over the past few months has reached “crisis” point, and could have dire consequence for smaller players, sources tell us. The High Street lender recently automated its payment processing system and brought it back on-shore with the intent of speeding …
Paul Kunert, 16 Jan 2015
Web browsers

Yahoo! Says! Chrome, IE Users! Should! 'Upgrade'! To! FIREFOX!

Yahoo! has started urging visitors to its homepage to "upgrade to the new Firefox" – even when they aren't using the Mozilla browser in the first place. The message, along with a Firefox logo, has begun appearing for some users in the purple band along the top of Yahoo!'s portal pages. It's displayed when the visitor is using …
Neil McAllister, 12 Dec 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

Popular Science site shrugs off malicious code infection

Surfers visiting Popular Science would be well advised to check their systems following an attack that has left the site compromised and harbouring malicious code. Security firm Websense warns that visiting the site exposed surfers to the RIG exploit kit. The malicious code was removed on Wednesday, but a number of surfers may …
John Leyden, 31 Oct 2014
spiders crawl through tunnel of binary numbers

Google must free us from 'invisible web of our personal data' – DPA

Dutch data protection watchdogs have warned Google it will face fines of up to €15m if it doesn’t alter its privacy policy. In 2012, the search giant “consolidated” the privacy policies for 60 of its services including Google Search, YouTube, Gmail, Picasa, Google Drive, Google Docs and Google Maps, thereby combining personal …
Jennifer Baker, 15 Dec 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
DolphinSpeak

Oracle will 'kill MySQL' and steal its users? Ha ha, haha, ha. Seriously, we won't – Oracle exec

OpenWorld If you think Oracle's only goal when it gained control of MySQL was to undermine it, Oracle has a message for you: Get over it. Speaking at the annual OpenWorld conference in San Francisco on Monday, Oracle chief corporate architect Edward Screven said there was never any question of the database giant mothballing MySQL. "Some …
Neil McAllister, 30 Sep 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

Privacy alert: Outlook for iOS does security STUPIDLY, says dev

Big Blue boffin Rene Winkelmeyer has taken aim at Microsoft's iOS Outlook app, launched overnight, claiming it stores credentials in the cloud potentially even after delete requests, and does not observe known good security practices. The spray against the House That Bill Built followed an examination into the way the app …
Darren Pauli, 30 Jan 2015

DataStax slurps graph database biz Titan's brains

NoSQL database-start up DataStax is today expected to announce its plans to start developing and selling a graph database for enterprises. DataStax will announce it has bought Aurelius, whose team is behind the Apache-licensed Titan distributed graph database for Cassandra. Financial terms were not revealed. DataStax said the …
Gavin Clarke, 03 Feb 2015

Analytics pusher Interana: Why tweak your seeks when you can scan your DRAM?

Startup Interana has an analytics tool that processes data in scans rather than seeks, claiming it’s designed to be great at analysing time-based streams of event data. The software is a proprietary database that organises data by time and user to allow for single-pass queries with no intermediate sorts. It runs on clustered …
Chris Mellor, 08 Oct 2014
Unity-based game running in a browser via WebGL

Unity, Mozilla team up to bring PEW! PEW! PEW! to browsers, too

GDC 2015 The latest version of the Unity cross-platform game development toolkit is helping to bring advanced 3D graphics and gaming to the web, albeit in baby steps. Unity 5, released to coincide with the Game Developers Conference taking place in San Francisco this week, includes a preview version of an exporter for WebGL, the evolving …
Neil McAllister, 03 Mar 2015
Apple iPhone 4S

Bug fixes! Get your APPLE BUG FIXES! iOS and OS X updates right here!

Apple is swatting at bugs with updates to its OS X Yosemite and iOS 8 platforms. The company said that the Yosemite v10.10.1 update would address a widely-reported WI-Fi connection error, while users running older iOS devices would find their systems running faster and more reliably after installing iOS 8.1.1. For OS X, the …
Shaun Nichols, 18 Nov 2014
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
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
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
Sad cloud

Chinese researchers develop fuzzy search algorithm for encrypted cloud data

Chinese researchers from Nanjing University have developed an encrypted search mechanism which they say is both more productive and secure than existing systems. Existing systems can search encrypted data only for exact keyword matches and nothing similar. Authors of such systems can employ fuzziness to detect phrases (such as “ …
Darren Pauli, 06 Oct 2014

Sage Pay anti-POODLE upgrade REDUCED security - briefly

Online payment service Sage Pay has been fingered for temporarily reducing its security while revamping its site security. Security consultant Paul Moore noticed that the Sage Pay website was briefly running a weak cipher last week. The issue was quickly corrected after Moore went public with his concerns on Tuesday. He …
John Leyden, 04 Feb 2015
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

Big data, come to BIG DADDY: HDS gobbles upstart Pentaho

Hitachi Data Systems is snapping up Pentaho for its big data integration and predictive analysis technology. Here's a quick look at Pentaho's history: Oct 2004: Founded by Doug Moran, James Dixon (CTO), Richard Daley (chief strategy officer) and Marc Batchelor (chief engineer) 2005: $5m A-round 2006: $8m B-round 2008: $12m C …
Chris Mellor, 10 Feb 2015

POISON PI sniffs WiFi from your mail room, goes on rampage

Security bod Larry Pesce has developed a chopping board-sized hacker package as an inexpensive weapon for hacking wireless networks through the post. The device is designed for so-called "war shipping" attacks described (vid) last year in which hacking hardware is posted to a target organisation with the aim of attacking …
Darren Pauli, 03 Oct 2014

Point DNS blitzed by mystery DDoS assault

Updated 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
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 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
IT Crowd. Source: Channel 4 / 2entertain

Sophos to offshore American support operations

Exclusive Sophos plans to offshore support operations from the US to Canada and the Philippines as part of a wide-ranging restructuring of its support operations. The plans were outlined in an internal email to staff from Mary Winfield, SVP Global Support, leaked to El Reg by an anonymous tipster. "Another year, another round of layoffs …
John Leyden, 20 Oct 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
The fantastical Francesinha

Storage snippets slither forth from San Fran analyst shindig

Western Digital is making more than five times as much money from flash than Seagate: $590m/quarter compared to $100m. This came out at a Stifel Nicolaus Tech, Internet and Media conference held last week in San Francisco, where vendors gave presentations and answered questions. Other highlights were: Seagate thinks there …
Chris Mellor, 17 Feb 2015

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

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

Researchers tell black hats: 'YOU'RE SOOO PREDICTABLE'

Security geeks have worked out a formula for determining which of a series of formerly blacklisted domains would be reused in malware attacks. The method combines the domain name with the generic Top Level Domain, IP address alterations and the cost of a domain transfer. Under the right conditions, the researchers sway, the …
Darren Pauli, 26 Sep 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

LOHAN sponsor Lucidica explains the benefits of being French

Back in October, the Low Orbit Helium Assisted Navigator (LOHAN) team welcomed our magnificent Kickstarter sponsors to Vulture Central, and among those who rolled up to be frisked by security at the door were representatives of London-based IT support firm Lucidica. The Lucidica team at Vulture Central With fighting livers at …
Lester Haines, 26 Nov 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