QueryBuilder can be used on advanced search engine pages, administration backends, etc. to build complex queries or filters. It is highly customisable and can be used with many jQuery widgets like autocompleters and sliders.
It outputs a structured JSON of rules which can be easily parsed to create SQL/NoSQL/whatever queries.
"Nesting performs a join across two buckets. But instead of producing a cross-product of the left and right hand inputs, a single result is produced for each left hand input, while the corresponding right hand inputs are collected into an array and nested as a single array-valued field in the result object."
The Doctrine Project is the home to several PHP libraries primarily focused on database storage and object mapping. The core projects are a Object Relational Mapper (ORM) and the Database Abstraction Layer (DBAL) it is built upon.
Couchbase Query Language, known as N1QL and pronounced "Nickel", is a query language for finding data in Couchbase Server. N1QL is designed to be human readable and writable. It is a language designed for ad-hoc querying. The query language is a standard semantic used to build querying ability in other databases.
Espresso provides an API as soon as you register your database. It introspects the database schema and populates the repository with the required metadata. Each table becomes a REST endpoint with services such as pagination, filtering, and optimistic locking out-of-the-box.
he LUPOSDATE SPARQL system supports various approaches to manage RDF data and process SPARQL queries: Index, RDF3X, Stream, Jena and Sesame. Jena [21] and Sesame [3] refer to third-party SPARQL engines. Index is our in-memory Engine presented in [6]. Stream is our stream-based implementation (see [10]). RDF3X is a re-implementation of [14], but is further enhanced with additional optimization strategies.
Dataclips allow the results of SQL queries on a Heroku Postgres database to be easily shared. Simply create a query on dataclips.heroku.com, and then share the resulting URL with co-workers, colleagues, or the world. The recipients of a dataclip are able to view the data in their browser or download it in JSON, CSV, XML, or Microsoft Excel formats
The Visual Query Builder helps you construct complex database queries without you having to know the syntax of SQL statements. A rich set of visual options are available to let you combine SQL clauses like JOINs, GROUP BY with properties like Indexes, Operators, Aliases, Sort Type, Sort Order and Criteria. Based on your selections, the Visual Query Builder will generate a complete SQL statement that can be executed. Features like Quick Criteria Mode, Quick Filtering, Index Assistant, flexible layouts, and drag and drop to include JOINs save you time and make the process of building queries more powerful and intuitive.
Apache Drill provides low latency ad-hoc queries to many different data sources, including nested data. Inspired by Google's Dremel, Drill is designed to scale to 10,000 servers and query petabytes of data in seconds.
Korma is a domain specific language for Clojure that takes the pain out of working with your favorite RDBMS. Built for speed and designed for flexibility, Korma provides a simple and intuitive interface to your data that won't leave a bad taste in your mouth.
DB2 NoSQL JSON enables developers to write applications using a popular JSON-oriented query language created by MongoDB to interact with data stored in IBM DB2 for Linux, UNIX, and Windows. This driver-based solution embraces the flexibility of the JSON data representation within the context of a RDBMS, which provides established enterprise features and quality of service.
We present the DataMeadow, a visual canvas providing rich interaction for constructing visual queries using graphical set representations called DataRoses. A...
http://www.cse.chalmers.se/~tsigas/papers/DataMeadow-InfoVis.pdf
DbVisualizer offers features for database developers, analysts and DBAs. Read more about Database Object Management, SQL Script Management, Query Builder and more.
Learn how to use LINQ in your applications with these code samples, covering the entire range of LINQ functionality and demonstrating LINQ with SQL, DataSets, and XML.
MRQL (the Map-Reduce Query Language) is an SQL-like query language for map-reduce computations. It is implemented on top of Apache's Hadoop. MRQL is powerful enough to express most common data analysis tasks over many different kinds of raw data, including hierarchical data and nested collections, such as XML data. It is more powerful than other current languages, such as Hive and Pig Latin, since it can operate on more complex data and supports more powerful query constructs, thus eliminating the need for using explicit map-reduce code.
HTSQL was created in 2005 to provide an XPath-like HTTP interface to PostgreSQL for client-side XSLT screens and reports. HTSQL found its audience when analysts and researchers bypassed the user interface and started to use URLs directly. The language has evolved since then.
The Query Representation and Understanding (QRU) data set contains a set of similar queries that can be used in web research such as query transformation and relevance ranking. QRU contains similar queries that are related to existing benchmark data sets, such as TREC query sets. The QRU data set was created by extracting 100 TREC queries, training a query-generation model and a commercial search engine, generating similar queries from TREC queries with the model, and removal of mistakenly generated queries.
C. Batini, T. Catarci, M. Costabile, and S. Levialdi. Proceedings of the IFIP TC2/WG 2.6 Second Working Conference on Visual Database Systems II, page 153--168. Amsterdam, The Netherlands, The Netherlands, North-Holland Publishing Co., (1992)
B. Howe, G. Cole, N. Khoussainova, and L. Battle. Proceedings of the 2011 ACM SIGMOD International Conference on Management of data, page 1319--1322. New York, NY, USA, ACM, (2011)
K. Rohloff, and R. Schantz. Proceedings of the fourth international workshop on Data-intensive distributed computing, page 35--44. New York, NY, USA, ACM, (2011)