Feeds

Amazon's flash-backed database gets EVEN FASTER

Relational features for the non-relational DB

Security for virtualized datacentres

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 more of the work traditionally done by administrators.

"LSI will now give you the ability to perform fast queries against other attributes (or columns) in your table," Amazon CTO Werner Vogels wrote. "This gives you the ability to perform richer queries while still meeting the low-latency demands of responsive, scalable applications."

A DynamoDB repository consists of a data table with a number of attributes. The first and second attributes form the hash key and range key out of which Amazon builds the primary index.

Prior to the launch of LSI, Amazon let you run queries either just across the hash (Show us everything by Team Register [hash]), or across a hash key with a range key (Show me the ten most recent articles [range] by Team Register [hash]).

However, running queries more complex than this was difficult, which meant that although DynamoDB is blisteringly fast and scalable, it couldn't fit as many workloads as administrators would perhaps like.

With LSI, admins can query across up to five additional indexes, so you could ask it questions such as Show us the ten most recent [range] articles by Team Register [hash] with above 10 comments [range1] that reference LOHAN [range2].

To do this before, LSI would require using a secondary application to query the database and winnow down the results. With LSI, you can perform this query within the application, so Amazon has done its typical thing of taking work off administrators' hands by increasing the sophistication of its own services [Can we please just start calling this outsourcing?—Ed.].

"By using LSI, you can now push that work to DynamoDB. Crucially, it does so while protecting the scalability and performance that our customers demand. Tables with one or more LSI's will exhibit the same latency and throughput performance as those without any indexes," Vogels wrote.

Though LSI can reduce the number of queries needed, and the time it takes to perform some of them, it can also lead to a rise in the cost of running DynamoD. "Every secondary index means more work for DynamoDB," the company wrote in a separate blog post.

The feature became available on Thursday from Amazon's data center hubs in Northern Virginia (US East), Oregon and Northern California (US West), São Paulo (South America), Ireland (Europe), and Singapore, Tokyo, and Sidney (Asia Pacific).

By adding these features to DynamoDB, Amazon has taken some of the features of the old traditional SQL world such as flexible queries, and brought them across to its scalable and fast DynamoDB. This is representative of an overall philosophical shift within Amazon, Vogels wrote, that sees Bezos & Co. take a NoSQL-first policy, build apps around DynamoDB as much as possible, and avoid use of MySQL or other typical relational databases unless their queries absolutely demand it. ®

Providing a secure and efficient Helpdesk

More from The Register

next story
Docker's app containers are coming to Windows Server, says Microsoft
MS chases app deployment speeds already enjoyed by Linux devs
IBM storage revenues sink: 'We are disappointed,' says CEO
Time to put the storage biz up for sale?
'Hmm, why CAN'T I run a water pipe through that rack of media servers?'
Leaving Las Vegas for Armenia kludging and Dubai dune bashing
Facebook slurps 'paste sites' for STOLEN passwords, sprinkles on hash and salt
Zuck's ad empire DOESN'T see details in plain text. Phew!
Windows 10: Forget Cloudobile, put Security and Privacy First
But - dammit - It would be insane to say 'don't collect, because NSA'
Symantec backs out of Backup Exec: Plans to can appliance in Jan
Will still provide support to existing customers
prev story

Whitepapers

Forging a new future with identity relationship management
Learn about ForgeRock's next generation IRM platform and how it is designed to empower CEOS's and enterprises to engage with consumers.
Why and how to choose the right cloud vendor
The benefits of cloud-based storage in your processes. Eliminate onsite, disk-based backup and archiving in favor of cloud-based data protection.
Three 1TB solid state scorchers up for grabs
Big SSDs can be expensive but think big and think free because you could be the lucky winner of one of three 1TB Samsung SSD 840 EVO drives that we’re giving away worth over £300 apiece.
Reg Reader Research: SaaS based Email and Office Productivity Tools
Read this Reg reader report which provides advice and guidance for SMBs towards the use of SaaS based email and Office productivity tools.
Security for virtualized datacentres
Legacy security solutions are inefficient due to the architectural differences between physical and virtual environments.