blm@6sigma.UUCP (Brian Matthews) (12/19/89)
After many months of hard work we're glad to let you know that we are
shipping our new software product which is called the Canonizer and is
used to design and implement databases. We built the Canonizer to take
input in a simple spreadsheet like format and use the mathematical
process known as normalization to produce a stable database model.
As many of you probably know, a properly normalized database is more
reliable and stable than a database which is not normalized. Most of the
advantages of a relational database are lost if you don't normalize.
Some of the benefits of normalization include:
* No data redundancy - each data item is stored in only one place.
This increases data integrity and makes it easier to change
information in the database.
* It is to modify and expand a database design. The likelihood of
having to redesign your database and associated applications is
reduced.
* Records are simplified and made easier to read and understand.
* The integrity of database queries is increased. Databases not in
third normal form may get anomalous results.
One of the drawbacks of normalization has been that it is a time
consuming and error-prone task when done by hand. With the Canonizer the
process of normalization becomes very simple. All you have to do is
enter the data items and information about their relationships with other
data items. This is the only tool of it's type on UNIX.
The Canonizer outputs the normalized database in an SQL file which can be
read by any of the popular DBMSs. The SQL file is ANSI standard and
makes it simple to create your database with your DBMS (such as Informix,
Ingres, Oracle, Unify and Sybase). We have the Canonizer running on a
number of machines and UNIX based operating systems (such as Sun, 386,
VAX, BELL Tech, NCR, Xenix, 4.3 BSD, System V, Sunos, etc.) and we are
porting to more machines as you read this.
We think we've come up with a pretty straight forward, easy to use
interface. You can also generate a data dictionary from the information
you entered into the Canonizer.
We have an introductory offer which includes a reduced price of $995 and
accessory software tool, called the SQL Converter, which aids in
converting an existing SQL schema file to files that are used with
Canonizer. This can save time by automatically capturing information
about a existing database, especially if your database is quite large.
The introductory offer is good through December 31, 1989. After that
time the price of the Canonizer is $1295 and the SQL Converter is $295.
If you are interested in the Canonizer or have questions, you can contact
us at canon@6sigma.UUCP, or call us at 1-800-827-4462.
Hunter Zuker Six Sigma CASE, Inc. 14405 SE 36th, Suite 210
zuker@6sigma.UUCP (206) 643-6911 Bellevue, WA 98006-1515