• Home
  • News
  • Reviews
  • Digital technology
  • Cloud
  • Data analytics
  • Digital leaders
  • IoT
  • Opinion
  • Events
  • Whitepapers
  • Newsletters
  • Sign in
  • Events
    • Follow V3 Events

      Sign up to receive email alerts about our events

      Sign up
  • Whitepapers
    • V3resources 120x194
      Network Security Forensics For GDPR Compliance

      An effective network security forensics strategy can assist an organization in providing key compliance-related details as part of any post-incident GDPR investigation.

      Download
      V3resources 120x194
      10 ways to increase productivity with managed Office 365

      For businesses large and small, relying on a cloud-based collaboration and productivity suite such as Microsoft Office 365 is becoming the norm. Enhancing productivity in your organisation is vital to get ahead in 2017 - and using Office 365 can help, if it's used right...

      Download
      Find whitepapers
      Search by title or subject area
      View all whitepapers
  • Data Strategy Spotlight
  • Sign in
  •  
    •  

      You are currently accessing V3 .co.uk via your Enterprise account.

      Personalise your on site experience

      Download and use the apps

      Access your subscription from outside of the office

      Get relevant news and insight straight to your inbox

      • Sign in
     
      • Newsletters
      • Account details
      • Contact support
      • Sign out
     
  • Follow us
    • RSS
    • Twitter
    • Newsletters
    • Facebook
    • YouTube
  • Register
  • News
  • Reviews
  • Digital technology
  • Cloud
  • Data analytics
  • Digital leaders
  • IoT
  • Opinion
 
  •  

    You are currently accessing V3 .co.uk via your Enterprise account.

    Personalise your on site experience

    Download and use the apps

    Access your subscription from outside of the office

    Get relevant news and insight straight to your inbox

    • Sign in
 
    • Newsletters
    • Account details
    • Contact support
    • Sign out
 
V3.co.uk
  • Databases

Couchbase brings SQL to JSON with N1QL query language in Couchbase 4.0 beta

New tool brings the familiarity of SQL to NoSQL databases using JSON

Big data image
Bringing SQL constructs to unstructured data
  • Daniel Robinson
  • Daniel Robinson
  • @TheDanRobinson
  • 04 June 2015
  • Tweet  
  • Facebook  
  •  
  •  
  • Send to  
0 Comments

NoSQL database firm Couchbase has unveiled a beta release of the upcoming Couchbase Server 4.0 platform, including a new query language called N1QL that is claimed to offer the familiarity of SQL for querying document-oriented databases.

Announced at the firm's Couchbase Connect user conference, Couchbase Server 4.0 is slated for release in the coming months and is set to offer a number of enhancements, including N1QL, multi-dimensional scaling and a new storage engine called ForestDB.

N1QL appears to be the feature that Couchbase itself considers the most significant. The name derives from First normal form (N1) Query Language, but is pronounced 'nickel'.

It has been designed to be similar to the standard SQL language for relational databases, but includes additional features suited for NoSQL databases structured around documents instead of tables, and specifically for JavaScript Object Notation in Couchbase's case.

The advantage of this is that it makes it easier for developers to build applications on top of a NoSQL database such as Couchbase Server, according to the firm, which said it expects N1QL to accelerate adoption of NoSQL as the standard database technology for enterprises to build web, mobile and Internet of Things applications.

"With the introduction of N1QL, we are the first NoSQL vendor to offer a query language for NoSQL databases that is based on SQL," said Couchbase chief executive Bob Wiederhold.

"This makes it easy for enterprises to leverage their workforce knowledge and existing investments in the massive SQL ecosystem, against the performance and scale of NoSQL."

N1QL has full compatibility with the SQL ecosystem via connectors and standard JDBC/ODBC drivers. This allows enterprises to connect existing extract, transform and load reporting and BI tools to Couchbase Server for the first time, the firm said.

Other features of Couchbase Server 4.0 include multi-dimensional scaling, which is described as a new way to improve performance in distributed database by allowing individual services such as query, index and data to be scaled separately.

This will enable users to optimise hardware by allocating resources based on the workload of a specific service, and to avoid resource contention by performing queries, maintaining indices and writing data with different nodes, the firm said.

Also with scalability in mind, Couchbase Server 4.0 is set to come with ForestDB, a storage engine said to be engineered to take full advantage of infrastructure based on multi-core processors and solid state drives (SSDs).

ForestDB takes advantage of multi-core processors by executing multiple reads and writes concurrently, while SSD optimisations offer improved read and write performance.

  • Tweet  
  • Facebook  
  •  
  •  
  • Send to  
  • Topics
  • Databases
  • Datacentre
  • SQL
  • Internet of Things

V3 Latest

First plant to grow on the Moon, err, dies
First plant to grow on the Moon, err, dies

Cotton seedling freezes to death as Chang'e-4 shuts down for the Moon's 14-day lunar night

  • Communications
  • 18 January 2019
Fortnite news and updates: Fortnite made $2.4bn in 2018, according to SuperData
Fortnite news and updates: Fortnite made $2.4bn in 2018, according to SuperData

Fortnite easily out-earns PUBG, Assassin's Creed Odyssey and Red Dead Redemption 2 in 2018

  • Software
  • 18 January 2019
Japanese firm sends micro-satellites into space to deliver artificial meteor showers on demand
Japanese firm sends micro-satellites into space to deliver artificial meteor showers on demand

Meteor showers as a service will be visible for about 100 kilometres in all directions

  • Communications
  • 18 January 2019
Saturn's rings only formed in the past 100 million years, suggests analysis of Cassini space probe data
Saturn's rings only formed in the past 100 million years, suggests analysis of Cassini space probe data

New findings contradict conventional belief that Saturn's rings were formed along with the planet about 4.5 billion years ago

  • Communications
  • 18 January 2019
Back to Top
  • Contact
  • Marketing solutions
  • Enterprise IT Events
  • About
  • Terms & conditions
  • Privacy policy
  • RSS
  • Twitter
  • Newsletters
  • Facebook
  • YouTube

© Incisive Business Media (IP) Limited, Published by Incisive Business Media Limited, New London House, 172 Drury Lane, London WC2B 5QR, registered in England and Wales with company registration numbers 09177174 & 09178013

Digital publisher of the year
Digital publisher of the year 2010, 2013, 2016 & 2017