Articles about Queries

US Army's spun-off GPU database gets ready for more matrix operations

Kinetica, the in-memory GPU-accelerated database, is adding user-defined functions (UDFs) to contribute to more sophisticated analytic workloads. Eric Mizell, Kinetica's global solution engineering veep, told The Register that the company was keen to discourage the idea of “data science as a black box”. Although Kinetica …
AI

Sysadmin chatbots: We have the technology

Storage Blockhead Chatbots are flashing up in our future view as something that could improve an admin's lot. Instead of using a GUI with nested and drill-down screen forms to do their job, they'll have a new form of Command Line Interface, only this will be a Chat Line Interface to a chatbot. Array vendor Tintri is showing how this could be …
Chris Mellor, 16 Jan 2017
James Madison University

Promising compsci student sold key-logger, infects 16,000 machines, pleads guilty, faces jail

A 21-year-old computer science student, who won a Programmer of the Year Award in high school, has admitted selling key-logging malware out of his college dorm room. On Friday, Zachary Shames, an undergraduate at James Madison University in Virginia, US, pleaded guilty in a federal district court to one count of aiding and …
Shaun Nichols, 14 Jan 2017
Uber Movement screen interface

Uber's Movement dumps data on city planners

Uber, which has been fighting to withhold ride destination data from New York City, on Sunday threw municipal governments a bone with a service called Movement. Movement aims to provide driving data to urban planners so local transportation systems can be optimized to operate more efficiently, a challenge that increases as …
Thomas Claburn, 09 Jan 2017
Some of the Super Pressure Balloon. M. McCarthy, submitted to the ABC

2016 – the year 3D XPoint came down to earth from Planet Hype

Storage Review in 2016 Storage in 2016 saw its on-premises SAN/filer array heartland assaulted by the public cloud on the one hand, and hyper-converged and software-defined storage on the other. The now-classic dual-controller disk array went hybrid to keep storing primary data, but all-flash arrays are taking on that role and so the hybrids went …
Chris Mellor, 05 Jan 2017
Twilight Zone, 'Time Enough At Last'

How the NYE leap second clocked Cloudflare – and how a single character fixed it

When the leap second was added just before the arrival of 2017, Cloudflare stumbled. The content delivery network's DNS service suffered a limited service interruption during the first few hours of the new year. John Graham-Cumming, head of engineering for the company, said in a phone interview with The Register that the …
Thomas Claburn, 04 Jan 2017
Exhausted looking business man on phone in from of laptop. Photo by Shutterstock

DomainMonster email service restored at last after Yuletide borkage

Updated DomainMonster finally resolved problems with its hosted email service on Tuesday, more than two weeks after they first began on 21 December. Reg readers affected by the problem were eventually told that a data centre networking issue was to blame for the extended outage. This remains unconfirmed since neither DomainMonster, a …
John Leyden, 04 Jan 2017

Netgear: Nothing to see here, please disperse. Just another really bad router security hole

Netgear has downplayed the significance of newly discovered flaws in its WNR2000 line of consumer routers. The vulnerabilities could hypothetically allow a remote attacker to execute code and take over the device without authentication, claims Pedro Ribeiro, the security researcher who discovered the bugs. “It is a LAN based …
John Leyden, 23 Dec 2016
The_incredible_hulk

Splunk slam dunk as FC SAN sunk by NVMe hulk

Case study Apeiron has had its Splunk processing speed advantage confirmed by ESG. Big deal. So what? The deal is that Splunk was built as a distributed and scale-out Big Data ingest and search engine running across multiple servers each with their own storage, providing real-time access to data analytics. Because data sets grew, ESG …
Chris Mellor, 23 Dec 2016

Gluster techie shows off 'MySQL of object storage' Minio projects

Backgrounder Minio and its µServer were first described by El Reg in December a year ago. Now we have had a closer look, courtesy of a press tour to Silicon Valley earlier this month. The basic product comes as three software items: Open source µServer Open Source Client Software development kit The µServer is a lightweight piece of …
Chris Mellor, 21 Dec 2016
Australian Parliament House Canberra

HPE storage meltdown at Australian Tax Office lost no taxpayer data

The Australian Taxation Office (ATO) has revealed that no taxpayer data was lost as a result of the weird crash of Hewlett Packard Enterprise 3Par storage kit. The ATO described the Monday outage as the result of a never-before-experienced problem that HPE was working to fix. The Register understands a 3Par storage rig was to …
Simon Sharwood, 15 Dec 2016

Crate.io unboxes clustered SQL CrateDB, decamps to California

After more than a million downloads since its introduction two years ago, CrateDB, an open-source distributed SQL database suited for real-time analysis of machine data, has reached to its 1.0 release. And while the door remains open to technical talent from abroad, Crate.io, which began with offices in Berlin, Germany, and …
Thomas Claburn, 14 Dec 2016

In the three years since IETF said pervasive monitoring is an attack, what's changed?

Feature After three years of work on making the Internet more secure, the Internet Engineering Task Force (IETF) still faces bottlenecks: ordinary peoples' perception of risk, sysadmins worried about how to manage encrypted networks, and – more even than state snooping – an advertising-heavy 'net business model that relies on collecting …
NHM VR Experience audience

Microsoft boffins think VR visions will rival drugs by 2027

Search as people presently know it – a dialog box for typed queries – will vanish in a decade, according to Susan Dumais, distinguished scientist and deputy managing director of Microsoft Research Lab. Dumais is one of 17 Microsoft researchers who, in a blog post on Monday, offered predictions about technology developments we …
Thomas Claburn, 06 Dec 2016

Amazonian Athena gifts the AWS team with the wisdom of SaaS on PaaS

Athena, goddess of wisdom, has bestowed her name upon Amazon's new interactive query service for S3 as the company seeks to become more than a mere infrastructure vendor. Announced at re:Invent, Athena is a serverless service using distributed query engine Presto with standard ANSI SQL support to allow customers to analyse …

Cheap virtual box hosters – Amazon's Lightsail is out to destroy you (yes, you, Digital Ocean)

AWS re:Invent Now that it dominates the public cloud market, Amazon is setting its sights lower – on developers deploying small projects – in the hope that these customers will remain within the AWS ecosystem. In conjunction with AWS re:Invent in Las Vegas on Wednesday, Amazon introduced Lightsail, a service that allows customers to launch …
Thomas Claburn, 30 Nov 2016

It's sooo much more than a data warehouse! Microsoft beams over new appliance update

Microsoft has made its latest appliance update generally available, reminding users that PolyBase exists and that SQL Server isn't just a boring old data warehouse. Redmond's Analytics Platform System (APS) is a scale-orientated, parallel-processing, fully integrated platform for data warehouse workloads, and is now generally …
Baby penguins, image via Shutterstock

SQL Server on Linux: Runs well in spite of internal quirks. Why?

First Look Microsoft has released a public preview of SQL Server for Linux, and I took it for a spin. There are three supported platforms for SQL Server on Linux, these being Red Hat Enterprise 7.2, Ubuntu 16.04, and a Linux-based Docker engine. Installation on other versions of Linux may also work, although unsupported. The Docker image …
Tim Anderson, 24 Nov 2016
AWS boss Andy Jassy speaking at AWS SFO Summit 2015

AWS to launch Aurora service for PostgreSQL at re:Invent – report

Amazon Web Services will announce a PostgreSQL compatible managed cloud service during its re:Invent conference next week, according to reports. Just as AWS cloned MySQL to create Aurora – its own MySQL-compatible relational database engine which it claims is the fastest-growing service in its history – it is now set to launch …
DNS privacy slide from Dan Gillmor, ACLU

IETF plants privacy test inside DNS

The Internet Engineering Task Force's (IETF's) years-long effort to protect Internet users has taken a small step forward, with one option for better Domain Name System (DNS) privacy reaching the test stage. "Stubby", created by the getdns project team, lets users test encrypted DNS queries. The idea isn't to flick the switch …
Her Majesty the Queen. Crown copyright/MoD

British politicians sign off on surveillance law, now it's over to the Queen

The UK's Investigatory Powers Bill has completed its passage through parliament and now only awaits Her Majesty's stamp of approval before becoming law. Also known as the Snoopers' Charter, the legislation has been criticised as being among the most onerous in the world upon the civilian population, and will require British …
gushing fire hydrant, photo via Shutterstock

HDS has HCI – but it's not hyper-converged infrastructure

HDS has announced Hitachi Content Intelligence, software which can search for and read content in multiple structured and unstructured data silos and analyse it. HCI can extract data from the silos and pump it into workflows to process it in various ways. Users of HCI can be authorised so that sensitive content is only viewed …
Chris Mellor, 16 Nov 2016

Terror plot spy project helps Kinetica crank up database speed

HPC blog Kinetica presented its in-memory database solution at the recent OpenPOWER European Summit in Barcelona, and served up some benchmark results. You can see the entire presentation in the video below, but here are a few highlights. First, for those of you unfamiliar with Kinetica, the company came out of a US military research …

Laziness and hate drove me to invent my storage engine concept, says MariaDB's CTO

Interview Monty Widenius, the Finnish author of MySQL and now the CTO at MariaDB — a fork of MySQL — told The Register how laziness and hate drove him to add open source columnar storage engine ColumnStore, to MariaDB. Earlier this year, amid preparations for its last funding round before potentially going public, the biz released its …
shutterstock_318151469_jesus

We're great, you don't understand competition law, Google tells Europe

Google has sought to blunt the European Commission’s three-prong inquiry into its business practices – by claiming the Eurocrats don’t understand antitrust law. Writing on Google’s corporate blog, senior VP and general counsel Kent Walker disclosed that Google has responded to the Commission’s shopping and advertising concerns …
Andrew Orlowski, 04 Nov 2016
Robot looks into magnifying glass, human eye displayed. Photo by Shutterstock

Freeze ...SCADA! Flaw lets hackers peel away Human Machine Interface

Security researchers have discovered another serious vulnerability in industrial control kit from Schneider Electric. System crashing flaws in the physical HMI (Human Machine Interface) hardware, dubbed PanelShock by security researchers, follow days after the earlier disclosure of security vulnerabilities in Schneider …
John Leyden, 01 Nov 2016

Researchers tag new brace of bugs in NTP, but they're fixable

Back in January, Cisco dropped a bunch of NTP (network time protocol) patches; now, it's emerged that the research behind that round of fixes also turned up other bugs that haven't yet been fixed. This week, Ciscoans Matt Gundy and Jonathan Gardner teamed up with Boston University's Aanchal Malhotra, Mayank Varia, Haydn …

Web devs want to make the Internet of S**t worse. Much worse

Vendors including Google have spent a few years crafting an API they hope to push into browsers that will make this month's Internet of Things conflagrations pale by comparison. There's not been much noise about the Web Bluetooth API, and thankfully it's not yet accepted as a standard. It probably should never be one, if you …
cloud

DNS infrastructure sprinting to IPv6 while users lag

IPv6 might be moving slowly among the general community, but it's penetrating the Internet infrastructure at a much higher rate. In an article published at his Potaroo blog, Internet address Registry for the Asia Pacific region chief scientist Geoff Huston has published the results of a study into how many servers in the …

Mysterious algorithms, black-box AI recruiters are binning our résumés

Analysis When you submit a résumé for a position at a large company, you may or may not be contacted for further information or an interview. Either way, you probably won't know why. Applicant tracking systems (ATS), the software used by employers to manage employment applications, are not generally open to public scrutiny. "Unless …
Thomas Claburn, 17 Oct 2016
Intel's Stratix 10 ARM-base FPGA

Microsoft boffins: Who needs Intel CPUs when you've got FPGAs?

Microsoft hooks up reprogrammable chips directly to its data centers' internal networks to ramp up the performance of its web applications. The Windows giant is so impressed by the tech, it reckons the customizable hardware could eventually take on more computational work than the Intel workhorse processors that today fill its …
Shaun Nichols, 17 Oct 2016
spies_648

Adding trendy tech SIEM to a hybrid computing setup

As I write this, Security Information and Event Monitoring is considered rather hip and cool. Everyone's talking about it, and the vendors of SIEM software are promoting the life out of it. The thought process that prompts consideration of SIEM is: “No matter what I do to protect myself, an attack is possible so I need to pre- …
Dave Cartwright, 14 Oct 2016
London Underground's Holborn station, Central Line. Pic: Shutterstock

Google DeepMind 'learns' the London Underground map to find best route

Google's DeepMind has beefed up machine learning capability by coupling a neural network with external memory, using it to find the shortest path between stations on the London underground. Neural networks - a system modelled on how neurons are connected and work in the brain - are good at processing data but bad at taking on …
Katyanna Quach, 13 Oct 2016

Telnet, SSH prod of death smashes Cisco broadband boxes offline

Cisco has issued six software updates to address security vulnerabilities in its networking products, ranging from denial of service conditions to authentication bypasses. The most serious of the flaws is the authentication bypass hole in the Cisco Meeting Server. Cisco warns that, due to improper handling of XMPP messaging, a …
Shaun Nichols, 12 Oct 2016
Office 365, photo by dennizn via Shutterstock

Securing Office 365? There's always more you can do

Wherever you look there's yet another SME or enterprise migrating to Office 365. This says a lot for the attractiveness of cloud-based office suites, and perhaps it also says something about the attractiveness of letting someone else look after one's SharePoint and Exchange servers rather than having to fight with their …
Dave Cartwright, 06 Oct 2016
Binary data/big data conceptual illustration. Illustration via Shutterstock

Microsoft boasts its cloudy Hadoop big data mill's faster than yours

Microsoft has overhauled its cloud-hosted Azure HDInsight Hadoop big data mill with extra security in the shape of enhanced authentication and identity management features plus a claimed 25 times performance boost in crunching big data queries. Azure HDInsight is a service that lets users deploy and manage Apache Hadoop …
Dan Robinson, 30 Sep 2016

Google finds its G Suite spot: Renames apps, talks up AI and BigQuery

Analysis The invitation for Google's latest cloud sales pitch, dubbed "Horizon" because the company has already had its way with "Atmosphere", on Thursday directed attendees to The Mint. As San Franciscans know, and Google Search advises to those in the area, The Mint is a karaoke bar, not far from the San Francisco Mint, which began …
Thomas Claburn, 30 Sep 2016
Type arms of an old typewriter

BIND bashes bugs

The folk who maintain the ubiquitous BIND DNS server have issued a patch for two bugs, one of them serious. Most of the time, organisations treat denial-of-service bugs as less serious than, for example, information disclosure or remote code execution bugs. BIND, however, is special: it's a fundamental part of the Internet …
Cat and mouse

Oh, ALL RIGHT, says Facebook, we'll let Windows admins run osquery

Two years after it first arrives for Linux and OS X, Facebook's "osquery" developer kit is now available for Windows. Osquery is designed to let sysadmins check out system and process information by issuing SQL queries, rather than (for example) having to watch syslogs. An example (drawn from the GitHub repo) is the kind of …

Startup iguazio launches NVMe-propelled missile at enterprise analytics

iguazio’s Data-as-a-Service Enterprise Data Cloud converges different storage access protocols and use cases behind an access abstraction layer and claims to out-perform Amazon and all-flash filers at lower costs. The startup’s pitch is that Big Data analytics data, input, extraction, loading and storing is grossly complex and …
Chris Mellor, 27 Sep 2016
Laptop leaning against a stack of news papers in front of a world map illustration

Impala beats Amazon

Cloudera says Apache Impala is 10x faster than Amazon Redshift and has 275 per cent better cost efficiency. Impala is an incubatory native analytic database on Apache Hadoop that runs in the cloud. It claims Impala offers elastic scalability, better flexibility, and direct Amazon S3 query-ability that are unavailable from …
Chris Mellor, 23 Sep 2016
Ellison

Larry Ellison today said really nice things about rival Amazon's cloud

OpenWorld Oracle’s founder and CTO Larry Ellison took to the stage for his second OpenWorld keynote today, and spent the bulk of his presentation pointing out flaws in his chief cloud rival Amazon. Amazon Web Services (AWS) has three database products running on its cloud (Redshift, Aurora and DynamoDB), and in terms of features they …
Iain Thomson, 21 Sep 2016

Cooky crumbles: Apple mulls yanking profits out of Europe and into US

Apple CEO Tim Cook may pull billions of dollars in profit out of Europe and bring them home to the US, less than a month after he vowed he wouldn't. In the aftermath of the massive €13 billion ($14.5 billion) back tax claim that the European Commission landed on the electronics giant and the Irish tax authorities, Cook has …
Kieren McCarthy, 01 Sep 2016
Little girl embraces robot. Photo by Shutterstock

Huawei hugs open-sourcey Alluxio: Thanks for the memories

Huawei has announced a Big Data analytics acceleration scheme using its FusionStorage product and Alluxio open source software; which seems to be the canine genitalia du jour for speeding up lethargic analytics queries. Alluxio is the renamed Tachyon Nexus, an Andreessen Horowitz-backed startup. FusionStorage is Huawei's …
Chris Mellor, 01 Sep 2016
bomb

Windows Update borks PowerShell – Microsoft won't fix it for a week

You'd be forgiven for thinking Microsoft is actively trying to stop people using Windows 10 Anniversary Edition. A patch this week broke one of the key features of the OS: PowerShell. KB 3176934, released on Tuesday as an automatic update, addresses a good number of bugs and other oddities in the operating system, including …
Iain Thomson, 25 Aug 2016
Robots, image via Shutterstock

Microsoft buys Genee's lamp, tips it into Office 365, smashes lamp

Microsoft has bought aspiring digital assistant start-up Genee and will roll it into Office 365. Billed by Microsoft as an “artificial-intelligence-powered scheduling service,” Genee uses natural-language queries to set up tasks. In its beta phase the service was available free of charge. The service will now, however, shut …
Gavin Clarke, 22 Aug 2016

UK's mass-surveillance draft law grants spies incredible powers for no real reason – review

IPBill An independent review into bulk surveillance powers in the forthcoming Investigatory Powers Bill has warned that there is no proven case to let British snoops hack the planet. The study group examined the UK government’s Operational Case for Bulk Powers [PDF], which provided the government’s reasons for needing the most …
Google's Santa project

Google hopes to sniff out OS X badware

Google's Macintosh Operations Team has quietly been working on a whitelisting application for OS X . Code-named Santa, the software (currently described as pre-1.0) has an SQLite database holding a list of permitted and blocked applications; a userland daemon to check the database; a kernel extension to monitor for executions …
Headshot of Trojan horse

Running a DNSSec responder? Make sure it doesn't help the black hats

Sysadmins are making mistakes configuring and managing DNSSec, and it's leaving systems that should be secure open to exploitation in DNS reflection attacks. That's the conclusion of Neustar, in a study released here and which found that of more than 1,300 DNSSec-protected domains tested 80 per cent could be used in an attack …
Trainspotting

US extradition of Silk Road suspect OK'd by Irish judge

An Irish court has authorized the extradition to the US of a man accused of helping to administer the infamous Silk Road website. Gary Davis, 27, of Kilpedder, Co Wicklow, has moved one step closer to a US trial on charges of conspiracy to distribute narcotics, computer hacking and conspiracy to commit money laundering. Mr …
John Leyden, 12 Aug 2016