“Research reports indicate that employees spend roughly 25 to 35 percent of their time searching for the information they need to do their jobs. That’s approximately one week of each month spent looking for data, which translates into billions of dollars in lost productivity time for employers.” Elizibeth Lipp, Database Trends and Applications magazine.
MetaTrieve is a revolutionary, enterprise-wide search engine and query tool for relational databases and mainframe legacy files**. MetaTrieve achieves its data-discovery capability by means of a unique, natural-language metadata search functionality. This metadata search functionality and easy-to-use data query features combine to create a powerful desktop tool to help IT personnel, consultants and business users find where data is located throughout the company.
A sales clerk or manager may need to know where customer “John Smith” lives, but unlike a web search engine where one can simply enter “John Smith” and hope the results are useful, a relational database requires first that the searcher know where the customer addresses are stored; in what table and what column, or even what database. And it is important to note that this need to know where data is stored constitutes a severe, but little-recognized, limitation with all other existing query tools - rather than finding the data for you, you must first locate WHERE the data is before any existing tool can effectively be used to actually query the data.
Yet finding where information is stored in databases is not an easy task for IT professionals, let alone business users, consultants and auditors. Because data is stored on many servers in multiple databases in countless tables and columns under widely varied names and labels, the problem of locating information before retrieval is huge and only growing worse as the size of databases explode. But with MetaTrieve! this problem of enterprise data-discovery is finally solved, and solved intuitively and quickly by searching throughout all of an organization’s relational databases and mainframe legacy files**.
Click On Image To View Enlargement
Three of the most common questions in business and consulting are: “Do we have this information in the company?”, “Where is the data stored?” and “How can I see it?” MetaTrieve answers these questions by tracking down the location of business data elements and providing an easy method for seeing the data once located. MetaTrieve is a powerful tool for queries, reports, data mining, ETL, EAI, Business Intelligence, Data Warehousing, Data Mapping, Metadata Management and B2B processes.
MetaTrieve is also a stand-alone query tool with the ability to perform cross-database table joins (e.g. join Oracle® and DB2® data into one display sheet) with an easy Google®-like find feature requiring no SQL knowledge. View Demo!
MetaTrieve also has a unique XML-to-Database matching feature that allows you to easily correlate B2B XML data elements with internal database equivalents. Matching custom or standard XML document elements with in-house metadata has always been a task--now made easier with MetaTrieve. View Demo!
Data discovery (the what, where and wherefore of data) is one of the most time-consuming processes for information consumers and consultants. This is increasingly corroborated in the pages of major IT trade publications. In an InfoWorld magazine feature article (November 3, 2003) entitled, Search Gets Serious, Cathleen Moore writes: “The explosion of corporate content . . . has pressed companies into a crisis . . . Because it is increasingly viewed as a way to link users to content and to bolster the ROI of existing applications and systems, search is emerging as a critical link in the IT infrastructure.” She then quotes Jupiter Research Director, Matthew Berk: “If you look inside a large corporation, anywhere you swing a stick you can find something that can be made better by search. We are dependent on information technology for everything employees do. Within an explosion of information, the ability of workers to find the information they need to do their jobs is vital.”
With both search and query features, MetaTrieve frees you of the requirement to know where information is located throughout your company and of the dependency on IT personnel and database administrators to help you find data. MetaTrieve closes the loop on the entire data-discovery and query process.
** Mainframe legacy search requires ODBC driver for IBM VSAM, IMS and flat files.
