Partner Article

Couchbase Develop Breakthrough Query Language N1QL

Extends Familiar Constructs of SQL to Flexibility of JSON Making it Easier for Relational and NoSQL Developers to Build Web, Mobile and IoT Applications

Couchbase, Inc. is adding fuel to the NoSQL fire. At its user conference, Couchbase Connect, happening now at Levi’s Stadium, the company announced beta for Couchbase Server 4.0 and provided thousands of attendees a glimpse into its breakthrough query language: N1QL: SQL for JSON. N1QL (pronounced Nickel) is the world’s first comprehensive declarative query language that combines the power of SQL with the flexibility of JSON. This makes it faster and easier for developers to build enterprise Web, mobile and IoT applications on top of the world’s most scalable NoSQL database: Couchbase Server.

“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 Bob Wiederhold, CEO at Couchbase. “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 will accelerate adoption of NoSQL as the standard database for enterprise Web, mobile and IoT applications.”

“N1QL brings the power of SQL to the document data model, which removes one of the biggest barriers to broader enterprise adoption of NoSQL. Until now, developers have had to make a choice when picking a database,” said Ravi Mayuram, senior vice president, products and engineering, Couchbase. “They could leverage the power of standard SQL, but be constrained by a rigid relational model, or develop on a flexible JSON data model, but accept query limitations that hinder development of rich applications. N1QL eliminates that compromise. With N1QL, Couchbase Server adds ease of application development to its proven scalability and performance leadership.”

Why SQL for NoSQL?

SQL has been the database industry’s standard query language for more than 40 years. Millions of developers around the world building scalable, enterprise applications today are using SQL either directly or indirectly through application development frameworks. By leveraging existing SQL constructs, N1QL will be familiar and easy for developers to adopt.

While SQL delivers strong query power, the rigid schema requirements of traditional databases have been a roadblock to releasing fast, scalable and responsive Web and mobile applications. JSON data models remove these limitations, but until now, NoSQL databases have lacked a standard rich query language that is familiar and easy to use. N1QL changes all that by extending SQL, recognised by virtually every developer in the world, to JSON, the industry standard data model for Web, mobile and IoT applications.

“NoSQL systems have proven their value in the enterprise with ease of development, performance and scalability, but developers still need a query language that lets them build applications that require complex queries on semi-structured data,” said University of California, San Diego computer science and engineering professor Yannis Papakonstantinou. “UCSD defined SQL++ to provide the industry with specifications for a SQL backwards-compatible declarative language that works on semi-structured data. N1QL is consistent with our specification – it gives developers a fully declarative and SQL-compatible query language to build applications that leverage the agility of JSON. We think N1QL will propel NoSQL adoption just as SQL originally propelled Relational Database Management System adoption.”

N1QL Improves Developer Agility

Developers need agility. They want to build rich applications that utilise a wide variety of data without the rigid limitations of relational databases, but they also want to query the data in ways that SQL has traditionally enabled.

N1QL gives developers access to the full power of SQL to query and transform semi-structured JSON data in anyway the application requires. This includes the ability to build a flexible JSON data model consisting of multiple documents that can be queried via JOINS, and can NEST or UNNEST documents to leverage the relationships among data. There is no longer a need to create a single document to query JSON data.

Additionally, N1QL is accessible via a developer’s preferred development framework, whether that is Spring, LINQ, Ottoman or something else. Since the application processes query results directly as streams of JSON documents, there is no longer an impedance mismatch and no need for a complex translation layer.

“Roomlia has been testing Couchbase N1QL and we’ve already noticed many advantages – especially with the ability to use ODBC connector for real-time data access,” said Vince Valenti, CTO, Roomlia. “We do reporting and BI with Microsoft Excel and Bi360, and N1QL makes it fast and easy to access data stored in Couchbase Server. That is just the beginning - N1QL has created the perfect marriage of Couchbase NoSQL databases and traditional RDBMS SQL queries to create the proverbial “paradigm shift” in way companies think of NoSQL databases.”

N1QL Drives Couchbase Ecosystem

N1QL will further accelerate adoption of NoSQL in the enterprise by making access to data stored in Couchbase Server easy and efficient. N1QL has full compatibility with the SQL ecosystem via connectors and standard JDBC / ODBC drivers. This allows enterprises for the first time ever to connect popular ETL, reporting and BI tools to Couchbase Server, and in turn is building massive momentum in the Couchbase ISV ecosystem as companies like Avalon LLC., Informatica, Looker, Metanautix, Simba Technologies and Tableau partner with Couchbase to provide deeper, supported integrations.

Resources:

· N1QL Ecosystem Release

· N1QL and Couchbase Server Getting Started

· Avalon, LLC. Querying JSON with N1QL: Couchbase Reimagines SQL

· Informatica Connect-a-Thon Event Winners

· Couchbase Partners with Metanautix to Integrate NoSQL and SQL

· Multi-Dimensional Scaling Release

About Couchbase

Couchbase delivers the world’s highest performing NoSQL distributed database platform. Developers around the world use the Couchbase platform to build enterprise web, mobile, and IoT applications that support massive data volumes in real time. The Couchbase platform includes Couchbase Server, Couchbase Lite - the first mobile NoSQL database, and Couchbase Sync Gateway. Couchbase is designed for global deployments, with configurable cross data center replication to increase data locality and availability. All Couchbase products are open source projects.

Couchbase customers include industry leaders like AOL, AT&T, Bally’s, Beats Music, BSkyB, Cisco, Comcast, Concur, Disney, eBay, KDDI, Nordstrom, Neiman Marcus, Orbitz, PayPal, Rakuten / Viber, Tencent, Verizon, Wells Fargo, Willis Group, as well as hundreds of other household names.

Couchbase investors include Accel Partners, Adams Street Partners, Ignition Partners, Mayfield Fund, North Bridge Venture Partners, and West Summit.

This was posted in Bdaily's Members' News section by Moorepay .