Embarcadero Technologies' ER/Studio 4.0 Accelerates Database Modeling and Increases Productivity.Business/Technology Editors SAN FRANCISCO--(BUSINESS WIRE)--March 29, 2000 Upgraded Database Modeling Application Features Automation and Stored Procedures and Triggers Embarcadero Technologies Inc. today announced the availability of ER/Studio 4.0, a major upgrade to its advanced modeling environment that offers advanced parser-based support for stored procedures and triggers and an automation interface for user-customization. ER/Studio 4.0 introduces new interfaces for even easier database model browsing and editing, and the ability to create stored procedures and triggers. Users can create stored procedures and triggers in their native DBMS (DataBase Management System) Software that controls the organization, storage, retrieval, security and integrity of data in a database. It accepts requests from the application and instructs the operating system to transfer the appropriate data. languages (including PL/SQL (Procedural Language/SQL) A programming language from Oracle that is used to write triggers and stored procedures that are executed by the Oracle DBMS. It is also used to add additional processing (sorting and other manipulation) of the data that has been returned by and Transact 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. ) or they can create template versions for drag-and-drop reuse. ER/Studio 4.0 contains parser-based technology that ensures consistent and accurate stored procedure and trigger object dependency for tables, views and other procedural logic. This new version of ER/Studio also introduces the ability to expand upon its own functionality through a new automation interface. By creating Sax BASIC commands (a VBA-like language) in ER/Studio's new macro scripting UI, users can tap directly into ER/Studio's own object model to expand existing functionality and create entirely new functionality. The Automation Interface can be used to create operations internal to ER/Studio such as automating repetitive tasks, or between ER/Studio and virtually any other database or application environment with an exposed API or like automation interface. "ER/Studio's automation interface is the exact flexibility we've been requiring in data modeling tools," said Todd Palmer, developer at CallCenter Technology. "Our product interacts with multiple heterogeneous enterprise data sources, and we have a lot of complex requirements when designing our data models. We needed a way to automatically generate and enforce them through our modeling tool of choice. ER/Studio's Automation Interface not only provides us the interface to customize the tool for our specific needs, but completely automated the routine labor needed to enforce it. No other database modeling product enabled us to get this done as quickly and exactly the way we required it." "Creating ER/Studio's underlying parser A routine that analyzes a continuous flow of text-based input and breaks it into its constituent parts. See parse. (language) parser - An algorithm or program to determine the syntactic structure of a sentence or string of symbols in some language. technology was a substantial development undertaking but it will return huge productivity dividends for our user base," said Gregory Keller, ER/Studio product manager. "ER/Studio 4.0 users can not only automatically preview the impact of suggested changes to their stored procedures and triggers, but can also rely upon ER/Studio's parsers to ensure changes are propagated to any dependent objects. This delivers enormous time savings when table or column references are located in hundreds of procedures or triggers." ER/Studio System Requirements To be used efficiently, all computer software needs certain hardware components or other software resources to be present on a computer system. These pre-requisites are known as (computer) system requirements and are often used as a guideline as opposed to an absolute rule. and Database Support ER/Studio 4.0 runs on Windows 95/98/NT Refers to all 32-bit versions of Windows prior to Windows 2000. It implies Windows ME and Windows 2000. It specifically excludes Windows 3.x. See Windows. and Windows 2000. Notational and method support includes IDEF1X IDEF1X Integrated Definition for Data Modeling , James Martin's IE (crow's foot Noun 1. crow's foot - a wrinkle in the skin at the outer corner of your eyes crow's feet, laugh line crinkle, wrinkle, furrow, crease, seam, line - a slight depression in the smoothness of a surface; "his face has many lines"; "ironing gets rid of most ) and Filtered IE (designed to hide foreign keys). ER/Studio supports a variety of desktop and SQL databases including; Oracle 7.3, 8 and 8i, Sybase 11.x, Informix SE and online, 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. 6.5 and 7.0, IBM (International Business Machines Corporation, Armonk, NY, www.ibm.com) The world's largest computer company. IBM's product lines include the S/390 mainframes (zSeries), AS/400 midrange business systems (iSeries), RS/6000 workstations and servers (pSeries), Intel-based servers (xSeries) DB2 and IBM DB2 Universal Database, SQL Anywhere  This article or section is written like an .Please help [ rewrite this article] from a neutral point of view. Mark blatant advertising for , using . 5, Watcom 4, InterBase 4.x, Access 2.0, 95, 97 and 2000, and Visual FoxPro. ER/Studio 4.0 is available immediately from Embarcadero Technologies and authorized international distributors, and is priced at $2,495. Customers on annual maintenance receive the new release free of charge. About Embarcadero Technologies A privately held San Francisco-based company, Embarcadero Technologies produces an innovative Database Lifecycle Management solution that assists in simplifying and automating the design, development, and administration of critical enterprise and Web-to-database applications. Thousands of major companies, including 75 percent of the Fortune 100 and half of the 10 most-visited Web domains, rely on Embarcadero products to maximize database performance and availability. For more information, visit http://www.embarcadero.com. |
|
||||||||||||||
Printer friendly
Cite/link
Email
Feedback
Reader Opinion