• Feed information to, Query Tools, Report Writers, Business Intelligence Tools, Application Servers and Web Services;
• Use Data Auditing and Query Tools to improve data quality;
• Extract information and deliver a single result set to applications such as e-commerce, supply-chain or customer relationship management;
• Transparently integrate information from merged or acquired business entities to seamlessly provide a consolidated view of enterprise information for existing applications;
• Present customized information to different groups of user;
• Simplify IT development and lower the costs of accessing information from both legacy and state-of-the-art applications;

• Quickly generate connections to any data source allowing access to your data using JDBC, ODBC or OLE DB;
• Turn your non-relational data sources such as Text Files, COBOL, DISAM/CISAM or Berkeley DB in to a powerful SQL-99 based relation database system;
• Replicate, Merge or Compare data from one data source to another;
• Consolidate data in real-time when your existing systems are unable to without creating data-marts;

The seeMore Virtual Database Server provides users, application developers and IT managers with the ability to access, view and update multiple data sources enterprise-wide as if they were a single database of information. It allows you to create a "Virtual Database" of information by using meta data information from multiple disparate data sources across your enterprise using a corporate data dictionary.

This powerful ability to create virtual databases and tables from disparate enterprise data sources is particularly valuable in supporting modern business applications that are data driven, including:

• Supply Chain Management systems;
• Customer Relationship Management Systems;
• e-Commerce applications.

With the seeMore Virtual Database Server, enabling these mission-critical applications to have fast, easy access to all of your data sources becomes a straightforward task that your IT staff can easily perform.

The seeMore Virtual Database Server modularizes your data and dramatically simplifies data integration effort and expense. User applications transparently and instantaneously access the seeMore Virtual Database Server to obtain the information they need, whenever they need it, from any data sources as if it were a single data source. It's easy, fast and efficient!

The seeMore Virtual Database Server uses a powerful data dictionary or catalog of meta data to create a logical representation of physical information from any data sources that you choose to include. The data dictionary contains information on the following:

• Data source information
• Users and their access rights
• Access control lists for security
• User defined data types
• Table schemas
• Index information
• Views
• Information on relationships
• Synonyms for table and column aliasing
• Native stored procedures
• Java based SQLJ stored procedures
• Data replication
• Events

Once the seeMore Virtual Database Server is configured, it provides end-users and applications with the ability to transparently access any corporate-wide data they need - without knowing specifically where the data is located - and without worrying about its format. Executives, managers and users get fast, easy access to all the data they need when they need it.

Using the seeMore Virtual Database Server, it's easy for end-users to access and manage their information, easily and automatically. The process for an end-user to get their information works as follows;

seeMore Virtual Database Server provides robust capabilities to enable easy, rapid access to information:

• Access to a Broad Array of Data Sources, including:
  
  • Non-relational (Flat files, ISAM, COBOL)
  • Relational (Oracle, DB2, SQL Server)
  • Generic (ODBC, OLE DB)
  • Mainframe data (VSAM, IMS, DB2)
  • Application-based

  Application interfaces based on open standards:

  • JDBC
  • ODBC
  • OLE DB
  
  
• Complex Data Structures. Provides the capability to define tables that consist of multiple definitions and arrays.
• Ability to alias names. If the data sources you are accessing have table/view and column names that are not suitable for reporting purposes, you can alias them using synonyms.
• Access Control Security. Users can be assigned read-only or read/write privileges, and controls can be placed on data down to the field level.
• Heterogeneous Joins. The seeMore Virtual Database Server allows the ability to perform heterogeneous joins when a query needs to pull data from multiple or heterogeneous sources and integrate it into a single view of information before passing it back to the end-user application.
• Partitions. Provides the ability to partition a table's data across multiple data sources/files using index or pseudo columns.
• Mapped Virtual Tables. Provides the ability to map existing table definitions either horizontally or vertically to create a new table that is a virtual view of the existing data.
• Ability to schedule events. If you require to execute a business process at a particular point in time, you can use scheduled events.
• Snapshots. Provides the ability create snapshots of your data at a point time. All future requests are made against the snapshots and not the transactional data.
• Additional Application Interfaces. As well as providing industry standard interfaces seeMore provides interface for C++ that supports both Navigational and SQL based requests.

You can use thin clients with seeMore Virtual Database Server because it processes all requests for information and performs all of the data access and management work.

Now there's a viable way to get at and use all of your enterprise data. And it's fast, easy, and economical with the seeMore Virtual Database Server.

Build a better future with seeMore, do it today, do it before your competitors do!