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

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

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

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

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

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

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

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

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

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

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

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

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

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

DRUPAL-OPCALYPSE! Devs say best assume your CMS is owned

Drupal websites that had not patched seven hours after the disclosure on a "highly critical" SQL injection (SQLi) hole disclosed on 15 October are essentially hosed, the content management tool's developers say. Attacks against the vulnerability (CVE-2014-3704) in version seven of the content management system began "hours" …
Darren Pauli, 30 Oct 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
Firefox ad 2nd St SF 2011

Mozilla remembers 2013. Y'know, back when it still gobbled at the Google money-trough

The Mozilla Foundation has released its annual financial statement for 2013, and the numbers raise important questions about Mozilla's future, now that it has ended its longstanding funding relationship with Google. Royalties paid by Google for queries from the Firefox browser's built-in search box have been the major source of …
Neil McAllister, 21 Nov 2014

'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

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

Drupal SQL injection nasty leaves sites 'wide open' to attack

A newly patched SQL injection flaw in Drupal leaves sites that rely on the widely used web development platform wide open to attack. Admins of sites that run Drupal 7 should upgrade to 7.32 to guard against possible attack. Patching needs to take place sooner rather than later because the easy-to-exploit vulnerability hands …
John Leyden, 16 Oct 2014