AQL: Querying a nosql database the elegant & comfortable way

Query Language Tags: 7 Comments

Having a long history with relational databases and having worked for a lot of years with SQL some people find it a bit inconvenient querying nosql databases e.g. via REST. Others have rather complex data models and need nevertheless an elegant and convenient way for querying. And we all love clean and simple interfaces.

ArangoDB comes with a couple of options for querying the data, among offer it implements the “ArangoDB Query Language” (AQL).

AQL is a declarative query language for simple and also very complex queries. Unless like in other nosql databases you can also query across collections, aggregate results, do some geo location stuff and even iterate over graphs.

So if you like the comfort of SQL but also the freedom of a schema free database, AQL is for you.

If you are interested in learning more about the concepts of ArangoDB checkout Jan’s talk and slides.

But let’s stop beating around the bush and rather have a look at specific examples.

Find the 5 regions in state CA with the most inhabitants:

Find the other top 5 hobbies of male users that also like running

Find the 10 nearest larger airports around Cologne

Find some users with their friends.

Tweet about this on TwitterShare on Google+Share on RedditShare on LinkedInBuffer this page

About Jan Steemann

Jan is an expert in data modeling with NoSQL & relational databases and writing high performance web applications. For ArangoDB, he wrote most of AQL (ArangoDB’s query language).
  • khurram

    excellent thread!!
    i need to know that is there any windows based tool for arangoDB?

    • http://www.triagens.de/ Claudius Weinberger

      Sorry, I did not know any windows based tools, but have you tried the admin interface.

  • khurram

    Thank you for your reply. Yes i tried the web interface, but it is not that easy as SQL Management Studio or WorkBench or Navicat. I am desperate to learn “noSQL” and i found by my R&D “ArangoDB” best among “mongoDB”, “Neo4j” etc. Please help me out here. Thank you.

    • http://www.triagens.de/ Claudius Weinberger

      I’m so sorry, but at the moment, I didn’t know such a tool.
      What exactly did you miss at the web interface?

      • khurram

        Thanks for your reply. It is not easy for me to create a database,documents,graph,nodes with the web interface. I want to integrate my recent project with Arango but how can I do it? and there is no help on the internet (as far as I have searched). You are an expert with modelling Data. I am very desperate in learning Arango.

        • http://www.triagens.de/ Claudius Weinberger

          All this things are possible with the web interface.
          If you need i’m so sorry but I can’t help you.

          • khurram

            would you please provide me some good learning stuff for ArangoDB? thank you in advance.