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.
Ein weit verbreitetes Missverständnis steht hinter dem Mythos, dass dynamische SQL langsam ist. Für bedingte WHERE-Klauseln kann eben dieser Mythos zu Performanceproblemen fürhen.
Apache Sqoop(TM) is a tool designed for efficiently transferring bulk data between Apache Hadoop and structured datastores such as relational databases.
Recorded version of a vision talk presented at VLDB 2011 (37th International Conference on Very Large Data Bases). PowerPoint slides, paper, and online demo ...
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.
The Chinook data model represents a digital media store, including tables for artists, albums, media tracks, invoices and customers. You can see the Chinook data model here.
B. Howe, G. Cole, N. Khoussainova, und L. Battle. Proceedings of the 2011 ACM SIGMOD International Conference on Management of data, Seite 1319--1322. New York, NY, USA, ACM, (2011)