Advanced Query Tool - Architecture

Architecture

AQT is a Windows application that uses ODBC to access the data, but is aware of the catalog structures of most common databases. This sets it apart from most software tools that use ODBC. The ODBC catalog is very slow on large systems, but AQT directly queries the catalog meta data of well known data base management systems, which makes it very fast for exploring the data structures of enterprise size data bases.

Catalog awareness is accomplished by using configuration files for each flavor of DBMS to define the queries to run against the data base catalog meta data. There are also separate configuration files for the administration component.

Data Base Management Systems of which AQT is aware of the catalog structure include IBM DB2, Oracle, Microsoft SQL Server, Postgres, MySQL, Sybase, and Informix.

Read more about this topic:  Advanced Query Tool

Famous quotes containing the word architecture:

    For it is not metres, but a metre-making argument, that makes a poem,—a thought so passionate and alive, that, like the spirit of a plant or an animal, it has an architecture of its own, and adorns nature with a new thing.
    Ralph Waldo Emerson (1803–1882)

    It seems a fantastic paradox, but it is nevertheless a most important truth, that no architecture can be truly noble which is not imperfect.
    John Ruskin (1819–1900)

    Art is a jealous mistress, and if a man have a genius for painting, poetry, music, architecture or philosophy, he makes a bad husband and an ill provider, and should be wise in season and not fetter himself with duties which will embitter his days and spoil him for his proper work.
    Ralph Waldo Emerson (1803–1882)