Query Abstraction Layer: Difference between revisions

Revision as of 10:40, 5 November 2014

Revision as of 08:59, 6 November 2014

Line 11:

| website = {{URL|http://www.optimalbpm.se/wiki/index.php/QAL}}

}}

'''QAL''' is an open source development project that aims to create a collection of libraries for mixing, moving, merging, substituting and transforming data.<ref name="sf_project">[https://sourceforge.net/projects/qal/ Sourceforge project page]</ref>.

And in some cases, like for MongoDB, schemas.

Sources and destinations include different database backends, file formats like .csv, XML and spreadsheets. Even untidy HTML web pages can be used as both a source and destination.

For [[:Category:Relational_database_management_systemsRelational database management systems|SQL/RDBMS backends]], it has a database abstraction layer that supports basic connectivity to Postgres, MySQL, DB2, Oracle and MS SQL server.<ref name="db types">[http://optimalbpm.se/api/qal/_modules/qal/dal/types.html#db_types Database backends]</ref>.

It uses XML formats(the SQL schema is self-generated) for representation of queries, transformation and merging, making it all scriptable.

With regards to SQL, QAL uses a subset of [[SQL]] features<ref>[http://optimalbpm.se/api/qal/qal.sql.html#qal.sql.sql SQL features supported]</ref> and data types,<ref>[http://optimalbpm.se/api/qal/_modules/qal/sql/types.html#data_types SQL data types]</ref>, which while obviously not complete however is sufficient for most usages.

It is however easy to instead use backend specific SQL when the queries do not have to be backend-agnostic.

It is currently distributed as a Python Library (.egg)<ref>[https://pypi.python.org/pypi/qal PyPi repository page]</ref> and a Debian package file(.deb).<ref>[https://sourceforge.net/projects/qal/files/?source=navbar Downloadable files]</ref>.

It is related to the Optimal BPM(Business Process Management) project.<ref>[http://www.optimalbpm.se Optimal BPM site]</ref>.

In fact, the Optimal BPM sourceforge project used to be DAL/QAL.<ref name="Break out"/>

Line 35:

[[Category:Python (programming language)]]

[[Category:Python_librariesPython libraries]]

[[Category:Free software programmed in Python]]

[[Category:Python software]]