seeMore makes order out of data chaos
Virtual Database Server gathers multiple databases under one relational roof, accessible via standard interfaces
You choose which objects (tables, stored procedures, files, etc.) are imported, so you can limit access to parts of a data source by simply not importing the database objects to be guarded; as such, they are unavailable to seeMore clients. Best of all, seeMore does all that without interfering with current applications that need continued access to those database objects.
Next, seeMore can craft whole new data sources from bits and pieces of existing ones. You could, for example, define a database that includes a customer table from an Oracle database in Ohio, an orders table from a Cobol database in Tennessee, and a shipments table from a MySQL database in Vermont. Although those three tables are hosted in three completely different database environments, a client calling into seeMore will see them as three plain old, ordinary relational tables that can be manipulated by standard ODBC, JDBC, or OLEDB calls.
Finally, seeMore supports the notion of "synonyms," or the renaming of database objects. Suppose one of your corporation's database developers has an acute bent toward the opaque and gives tables names such as "cst001" and "ortab" instead of "customers" and "orders." Import that database into seeMore, and you can create synonyms for those tables so that seeMore clients now see "customers" and "orders" rather than the more cryptic original names. And because seeMore simply renames on the fly, programs that use the original names will continue to work. This renaming capability extends across entities such as table names, column names, data types, and so on.
Virtual Database Server is steeply priced, starting at a little less than $20,000. But this is a tool for large enterprises whose squads of dissimilar databases beg for the imposition of a unifying order. And Virtual Database Server does just that: One server to rule them all, and in the darkness bind them.
OK, maybe not the "rule them all" part, but it does do a grand job of binding them, darkness or no.
Read more about data management in InfoWorld's Data Management Channel.