Logic Works announces ERwin/OPEN.SAN FRANCISCO San Francisco (săn frănsĭs`kō), city (1990 pop. 723,959), coextensive with San Francisco co., W Calif., on the tip of a peninsula between the Pacific Ocean and San Francisco Bay, which are connected by the strait known as the Golden , DB/Expo--(BUSINESS WIRE)--May 2, 1995--Logic Works Inc., developer of the industry's leading database design tool, ERwin(R), Tuesday announced ERwin/OPEN and their OPEN MODEL development strategy. ERwin/OPEN will allow developers to synchronize their database design with all three of today's most popular client/server tools -- Powersoft's PowerBuilder, Gupta's SQL Windows See SQLWindows. and Microsoft's Visual Basic. In addition to speeding development with each individual tool, ERwin/OPEN will facilitate cross-platform development as well as client-side platform migration. ERwin/OPEN will include an open SQL SQL in full Structured Query Language. Computer programming language used for retrieving records or parts of records in databases and performing various calculations before displaying the results. dictionary and powerful forward and reverse-engineering, including triggers and stored procedures. ERwin/OPEN targets 18 different SQL and desktop databases, including Oracle, Sybase, Microsoft SQL Server A relational DBMS from Microsoft that is a major component of the Windows Server System. It is Microsoft's high-end client/server database and is closely integrated with Microsoft Visual Studio and the Microsoft Office System. , Watcom SQL A relational DBMS for DOS, Windows, NetWare and OS/2 developed by Watcom International Corporation, Waterloo, Ontario. Watcom SQL evolved into Sybase SQL Anywhere when it was acquired by Powersoft and then Sybase. , dBASE, Foxpro and Microsoft Access A database program for Windows, available separately or included in the Microsoft Office suite. Access is programmable using Visual Basic for Applications (VBA). Access can read Paradox, dBASE and Btrieve files, and using ODBC, Microsoft SQL Server, SYBASE SQL Server and Oracle data. . "Many development shops use several different application development tools, often including PowerBuilder and Visual Basic," said Curt Monash, Ph.D., president of Monash Information Services See Information Systems. . "Integrated database design -- and especially stored procedure generation -- is important no matter which tool you use. ERwin/OPEN makes it easier to achieve these objectives." ERwin is a powerful application modeling tool that allows developers to create a graphical Entity-Relationship diagram entity-relationship diagram - entity-relationship model of their data. Through a direct Server FRE FRE French FRE Freddie Mac (stock symbol) FRE Federal Rules of Evidence FRE Freedom Realty Exchange FRE Freedom Party FRE Food and Resource Economics FRE Free Range Eggs FRE French Real Estate (Server Forward and Reverse-Engineering) connection to the database catalog The database catalog of a database instance consists of metadata in which definitions of database objects such as Basis tables, view tables, synonyms, value ranges, indexes, users, and user groups are stored. ≈°220.227.88. , ERwin automatically generates the physical database schema The definition of a database. It defines the structure and content in each data element within the structure. Schemas are often designed with visual modeling tools that automatically create the SQL code necessary to define the table structures. See subschema and XML schema. code as well as stored procedures and triggers that enforce referential integrity. ERwin can use the same connection to reverse-engineer an existing database into a logical data model. ERwin/OPEN's dictionary architecture speeds client/server development. Taking database design a step further, ERwin/OPEN will let developers define PowerBuilder, SQL Windows or Microsoft Visual Basic extended attributes (such as class style, client-side validation, initial value, height, width, label, description, font, color, prompt, etc.) that indicate how column values should be displayed and edited as well as server-side values (datatype, column name, server-side validation, default, etc.) for database columns. Additionally, ERwin generates SQL Windows forms using QuickObjects and Visual Basic forms using a Form Wizard. "Database design is an important part of client/server development," said Dr. Benjamin Cohen, president and CEO (1) (Chief Executive Officer) The highest individual in command of an organization. Typically the president of the company, the CEO reports to the Chairman of the Board. of Logic Works. "PowerBuilder, SQL Windows or Visual Basic can now use the same ERwin data model to build cross-platform applications, and because ERwin is tightly integrated with these tools, it can fully exploit their leading-edge features. "ERwin adds tremendous value to SQL Windows and Visual Basic by supplying the dictionary critical to their data management components." As opposed to database design tools that merely pass values to client-side tools, ERwin/OPEN drives client-side development from an open dictionary. This allows ERwin to effectively connect the client and server, keeping values synchronized throughout prototyping and development. "Without ERwin, client/server development can be a slow process of matching up client and server-side definitions. Changing the database, for example, requires that PowerBuilder extended attributes be completely re-entered. However, because ERwin stores PowerBuilder's extended attributes, they're preserved even if the database changes," noted Cohen cohen or kohen (Hebrew: “priest”) Jewish priest descended from Zadok (a descendant of Aaron), priest at the First Temple of Jerusalem. The biblical priesthood was hereditary and male. . In PowerBuilder's case, ERwin/OPEN includes a bi-directional link to PowerBuilder's extended attribute dictionary. For SQL Windows and Visual Basic, ERwin/OPEN provides a dictionary at development time. The dictionary objects are instantiated through form creation. ERwin can, for example, encapsulate en·cap·su·late v. 1. To form a capsule or sheath around. 2. To become encapsulated. en·cap a database design into SQL Windows as an ERwin QuickObject, which generates ready-to-run "data aware" forms. Cross platform development and migration. Using ERwin/OPEN, PowerBuilder, SQL Windows and Microsoft Visual Basic developers will each be able to generate client-side forms from the same database design, facilitating the development of consistent applications across multiple development platforms. ERwin/OPEN will also be able to migrate extended attributes from one development platform to another. This migration will make it easy to port the definitions from an existing PowerBuilder application, for example, to Visual Basic. ERwin/OPEN will include a two-way link to PowerBuilder 4.0 and a one-way link to both SQL Windows 5.01 and Visual Basic 3.0 and 4.0. A two-way link for these products is planned for the end of 1995. Future releases of ERwin/OPEN will also contain support for Oracle PowerObjects and Oracle Forms as well as other emerging technology "best of breed" leaders. Specific versions of ERwin have been introduced previously for PowerBuilder (4/94) and more recently, SQL Windows (3/95). Logic Works has joint marketing agreements with both Powersoft and Gupta, and currently offers ERwin bundled with either PowerBuilder or SQL Windows. ERwin/OPEN will include the first release of ERwin for Visual Basic. ERwin/OPEN will ship in Q3 at a price of $3,495. Current ERwin for PowerBuilder, ERwin for SQL Windows and ERwin for Visual Basic customers may pay a small upgrade charge to receive ERwin/OPEN. For more information on how to purchase the product, call Lina Page at Logic Works, 609/252-1177 (phone) or 609/252-1175 (fax). Logic Works Inc., founded in 1988, develops and markets low-cost, high-performance database and application design and business process modeling tools. The company's products enhance the development of desktop and client/server applications and business process re-engineering See reengineering. (business) Business Process Re-engineering - (BPR) Any radical change in the way in which an organisation performs its business activities. BPR involves a fundamental re-think of the business processes followed by a redesign of business activities to . Both ERwin and BPwin provide an intuitive way to design, maintain and migrate database applications from the desktop to the enterprise level. The company's headquarters are in Princeton with operations in Switzerland. -0- ERwin is a registered trademark of Logic Works Inc. All other brand and product names are trademarks or registered trademarks of their holders. CONTACT: Logic Works Inc., Princeton Lina Page, 609/252-1177 or The Garfield Group, Trenton Brigitte Davis, 609/396-0946, ext. 15 |
|
||||||||||||||
Printer friendly
Cite/link
Email
Feedback
Reader Opinion