Printer Friendly

IXOS SOFTWARE'S NEW GRAPHICAL QUERY TOOL UNLOCKS CORPORATE RELATIONAL DATABASES FOR NON-PROGRAMMERS

IXOS SOFTWARE'S NEW GRAPHICAL QUERY TOOL UNLOCKS CORPORATE RELATIONAL
 DATABASES FOR NON-PROGRAMMERS
 SAN FRANCISCO, Jan. 22 /PRNewswire/ -- A new graphical query tool that enables non-programmers to easily manipulate UNIX relational databases was announced and demonstrated at UniForum in San Francisco today by iXOS Software GmbH, a leading commercial UNIX software developer in Germany.
 The new product, which is called iXVIEW(R)/SQL, is an interactive, graphical query generator for distributed relational database systems running under UNIX. iXVIEW/SQL supports multiple data types, and permits output in the form of tables, charts and scanned images.
 According to the market research firm Gartner Group, the worldwide market for UNIX-based relational database management systems is expected to grow from $585 million in 1991 to $1.4 billion by 1995.
 iXVIEW/SQL is based on OSF/Motif, the Open Software Foundation's graphical user interface (GUI) for UNIX software. iXVIEW/SQL, new in the United States, has been available for several months in Germany, where it has been adopted by several large users, including the German federal government.
 By removing the barriers between real people and real information, iXVIEW/SQL supports the distributed decision-making process that drives today's successful companies, iXOS said.
 "During the last several years, large organizations have built enormous relational databases in order to make corporate information more accessible to all knowledge workers," said iXOS President Hans W. Strack-Zimmermann. "However, accessing these databases requires detailed knowledge of complex access mechanisms such as Structured Query Language (SQL). As a result, most knowledge workers can't make their own queries because it's just too difficult.
 "As an alternative, they can ask the MIS department to set up database queries for them, but the lead times are usually too long to make such requests worthwhile. In other words, this is a problem that frustrates both the end-user and the MIS department."
 With iXVIEW/SQL, end-users can quickly and easily create their own personal subsets of corporate databases to meet individual or departmental needs -- without knowing SQL or programming, and without pestering MIS for technical support or training.
 iXVIEW/SQL represents databases graphically. With mouse in hand, users point-and-click their way through data, using pull-down menus, scroll bars, and dialog boxes. Results appear immediately and are arranged logically on their screens. Prompts and visual cues help ensure success. The typical non-programmer can learn to use iXVIEW/SQL productively in one hour.
 Because iXVIEW/SQL adheres to the OSF/Motif standard, users will find the tool easy to learn and productive to use with their other applications. iXVIEW/SQL exploits Motif standards and conventions to provide easy, visual access to corporate data. These features include mouse support; point-and-click/drag-and-drop commands; multiple, resizable windows; icons and graphical on-line HELP.
 iXVIEW/SQL shields users from having to know the location or type of the databases they are working with. Once iXVIEW/SQL is installed on a workstation or server, it automatically recognizes all SQL data structures.
 iXVIEW/SQL allows the system administrator to set global and user-specific configurations in a system configuration file, and it maintains all access authorizations and restrictions defined under UNIX and the database management system. Individual VIEWs for Fast, Focused Data Access
 iXVIEW/SQL works on the concept of "VIEWs," which are graphical ways of looking at subsets of a database or multiple databases. Using standard logical functions such as "JOIN," "AND," "OR" and "NOT," the user creates a VIEW that meets his or her specific criteria. Selection of data fields and logical functions is done via pointing-and- clicking with the mouse and with simple English-language or numerical entries in dialog boxes.
 In a typical application, an accounting clerk might want a VIEW of all customers who are overdue in payment by more than 30 days, and whose balance exceeds $2,000. From a window representing the customer and accounts receivable databases, the clerk first defines the fields he wants represented in this VIEW from a list on the menu -- in this case, customer name, street address, city, state, ZIP code, telephone number, contact person, balance, and days past due.
 To tailor the VIEW, the clerk then specifies "balance > $2,000" AND "days past due > 30." iXVIEW/SQL then creates a custom VIEW containing all those fields he requested, but only for customers who meet his two criteria.
 In another example, the manager of a sporting goods chain wants to determine the fastest-selling tennis articles. She suspects that the information she needs is contained in two existing VIEWs of the company's database. From the initial iXVIEW/SQL menu, representing ting to iXVIEW/SQL that she wishes to set up a query that involves joining two existing VIEWs.
 iXVIEW/SQL automatically lists available fields for the "articles" VIEW and the "items" VIEW. From these two lists, she selects "article number," "description" and "purchase price." Shen then creates a new column, "turnover," which she defines as the aggregrate of "purchase price" from the "articles" VIEW and "quantity" from the "items" VIEW.
 Finally, by clicking on the MATCH context-sensitive search function, she narrows her VIEW by searching for only those items that have to do with tennis. She then specifies that she wants her information sorted in descending order, by turnover. When she gets her table of results, she can reformat it for clarity and impact, by swapping columns and using color highlighting. She can even convert the information to a color-coded pie chart showing the best-selling articles at a glance. In addition, because the company's database contains pointers to scanned images of product photographs, she can show a picture of each of the best-selling tennis articles.
 Using SQL alone, these two basic business problems would require knowledge of the database architecture, a mastery of SQL syntax, and a much greater number of steps. Flexible Data Formatting, Variety of Output Choices
 Once created, VIEWs can be browsed. Users can sort VIEWS using multiple sort criteria, in ascending or descending order. Obtaining information from any database record in the VIEW is as easy as pointing-and-clicking.
 Retrieved data can be analyzed and immediately manipulated or reformatted on the screen using simple point-and-click commands. Users can produce reports, create custom tables or graphics, fade out or highlight partial information, assign color-coding, and perform other custom formatting.
 iXVIEW/SQL includes a number of basic formats, ranging from tables to pie charts. Built-in formatting tools allow a wide range of formats for both tables and charts. In addition, the user can export the information to other software applications, such as popular word processing, spreadsheet, graphics, and desktop publishing programs, as well as to statistical programs.
 iXVIEW/SQL information can be printed on dot-matrix and PostScript printers. VIEWs can be saved for reuse or editing, merged with other VIEWs to create totally new VIEWs, and be distributed among users to enhance workgroup productivity. A project leader or department head could thus create VIEWs and distribute them to team or department members, for their immediate use in looking up data.
 "This ability to create, save, share and reuse VIEWs is the kind of productivity-enhancing power that was envisioned by the database pioneers," said Strack-Zimmermann. "If teams of knowledge workers can use relational databases as they were intended to be used, the entire organization continually benefits because its intellectual assets are continually growing. The relational database gave us the potential to do this, but it took iXVIEW/SQL to make it a practical reality for most organizations." Pricing and Availability
 iXVIEW/SQL is available immediately in the United States, at $995 for a single-user copy. A five-seat network package is available at $4,500 (a 10 percent savings over the multiple-copy, single-unit price); a 10-seat network package costs $6,995 (a 30 percent savings). Site licensing is available for larger networks upon request.
 The software includes a comprehensive, context-sensitive HELP facility, a tutorial, a practice database, an administrator's manual, a user's guide, and other necessary documentation.
 iXVIEW/SQL is available for IBM RS/6000 workstations running AIX 3.1, for Sun SPARCservers/stations running SunOS 4.1, for 386/486 CPUs with SCO 3.2, and for 386/486 CPUs with UNIX 5.4. System requirements are: 8 MB RAM; 10 MB free hard disk space; X Window runtime system, Release 11.3 or higher; OSF/Motif runtime system, Release 1.0 or higher; and an X-Window-compatible terminal, keyboard and graphics accellerator. A mouse is recommended.
 iXVIEW/SQL supports the following relational databases: ORACLE 6.0 (on RS/6000 and SPARCservers/stations) and Informix 4.0 (on RS/6000, SPARCservers/stations, 386/486 CPUs with SCO 3.2, and 386/486 CPUs with Unix 5.4). From a Leader in Commerical UNIX Software
 iXVIEW/SQL is a product of iXOS Software GmbH, an international provider of solutions that help people use UNIX to solve common but critical business problems. The company was founded in 1988 by two UNIX pioneers, Eberhard Faerber and Hans W. Strack-Zimmermann. iXOS offers a variety of products and services, including UNIX commercial software, UNIX software for specialized applications, UNIX operating system software and product development for OEMs and for major projects, training, customer support, and consultation.
 iXOS is committed to open systems and industry standards, and has participated in driving the evolution of software standards through its work with X/OPEN, the IEEE POSIX Committee, the Open Software Foundation, and other international standards organizations.
 Customer inquiries can be directed to iXOS Software, 1030 West Maude Ave., Suite 512, Sunnyvale, Calif., 94086, telephone 408-732-2315, fax 408-749-9278.
 ----
 NOTE: iXVIEW/SQL and iXOS are registered trademarks of iXOS Software GmbH. UNIX is a trademark of UNIX Systems Laboratories, Inc. Sun Microsystems is a trademark of Sun Microsystems, Inc. SPARC is a trademark of SPARC International. OSF and Motif are trademarks of the Open Software Foundation Inc. X Window System is a trademark of the Massachusetts Institute of Technology. X/Open is a trademark of X/Open Company Limited. ORACLE is a trademark of Oracle Corporation. Informix is a trademark of Informix Software, Inc.
 -0- 1/22/92
 /CONTACT: Janice Brown, 617-332-8066, or Joseph Roy, 617-965-1846, of Janice Brown and Associates Inc., for iXOS Software/ CO: iXOS Software GmbH ST: California IN: CPR SU: PDT


DD -- NE001 -- 2109 01/22/92 09:19 EST
COPYRIGHT 1992 PR Newswire Association LLC
No portion of this article can be reproduced without the express written permission from the copyright holder.
Copyright 1992 Gale, Cengage Learning. All rights reserved.

Article Details
Printer friendly Cite/link Email Feedback
Publication:PR Newswire
Date:Jan 22, 1992
Words:1697
Previous Article:MMS INTERNATIONAL PROJECTS GDP UP 0.8 PERCENT IN Q4
Next Article:ASHLAND OIL, INC. COMPLETES ACQUISITION OF THE PERMIAN CORPORATION
Topics:


Related Articles
SPINNAKER SOFTWARE TO SHIP 'PERSONAL ACCESS' DATABASE QUERY AND REPORTING TOOL; ACCESS AND REPORT TOOL CUTS QUERY TIME, PROCESS, EXPENSE (Product...
SPINNAKER SOFTWARE TO SHIP 'PERSONAL ACCESS' ORACLE AND PARADOX DATABASE VERSIONS
NEW PRODUCT SET FOR COST-EFFECTIVE INFORMATION MANAGEMENT IBM DATAHUB ENHANCES DISTRIBUTED DATA ADMINISTRATION
HARBOR SOFTWARE ANNOUNCES HARBORVIEW VISUAL APPLICATION BUILDER
POWERCERV ANNOUNCES CLIENT/SERVER FINANCIAL/ACCOUNTING SUITE BASED ON POWERBUILDER
ORACLE USHERS IN NEW AGE IN INFORMATION MANAGEMENT; SHIPS ORACLE(R) UNIVERSAL SERVER(R), THE WORLD'S FIRST ALL-PURPOSE SERVER
SELECTSTAR ANNOUNCES SUPPORT FOR SYBASE IQ COMBINATION OFFERS HIGH SPEED RELATIONAL OLAP FOR DATA WAREHOUSES
Liant Software Corporation Releases Relativity v2.1
Rogue Wave's Object Factory 4.0 Integrates GUI Development and Database Access With Open Source Code Generation
Novera Software Aids Corporations to Develop, Deploy Java Applications Faster at Lower Cost

Terms of use | Copyright © 2016 Farlex, Inc. | Feedback | For webmasters