Netwise announces availability of SQL Accelerator(TM) to generate DB2 Plans from dynamic ODBC SQL; DB2/Integrator SQL Accelerator provides dynamic SQL ease of development with DB2 Plans performance and security.BOULDER, Colo.--(BUSINESS WIRE)--Mar. 10, 1995--Netwise, Inc., today announces availability of the TransAccess(TM) DB2/Integrator 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. Accelerator, a new component of DB2/Integrator that transparently generates, substitutes and executes efficient DB2 Plans (and Packages) in place of frequently used, less efficient, dynamic DB2 SQL requests. Database Administrators (DBAs) can take advantage of the performance and scalability of DB2 Plans without the requirement for desktop users and developers to change their dynamic SQL See embedded SQL. applications. TransAccess DB2/Integrator (DB2/I) provides high performance mainframe DB2 access, via ODBC (Open DataBase Connectivity) A database programming interface from Microsoft that provides a common language for Windows applications to access databases on a network. , from desktop applications built with powerful development tools like Powersoft's PowerBuilder and Microsoft's Visual Basic. The new SQL Accelerator component of DB2/I enables DBAs to determine which repetitive dynamic SQL requests should be transparently converted into DB2 Plans. Substitution is transparent to desktop applications so there is no need for desktop developers to hand code remote stored procedures. There is no need for mainframe developers to build corresponding procedural code to execute the DB2 Plans. And DBAs can use Plan, package and collection security to simplify mainframe access control. "Users, developers and DBAs view DB2 access differently," says Joe Broderick, Netwise President and Chief Operating Officer Chief Operating Officer (COO) The officer of a firm responsible for day-to-day management, usually the president or an executive vice-president. (COO). "Desktop users and developers want the high productivity that comes with the dynamic ODBC SQL capabilities of MS-Windows tools," Broderick continues. "Mainframe DBAs must balance DB2 access needs against mainframe control and resource realities. SQL Accelerator is the first product in the industry to combine the ease of use of dynamic SQL with the performance, manageability and security of DB2 Plans." DB2/Integrator provides an optimized MS-Windows ODBC driver that is used by desktop tools for SQL access to mainframe DB2. Conversions between ODBC and DB2 SQL are performed by DB2/I on the mainframe. Flexible combinations of NetWare, NetBIOS, LANServer, TCP/IP TCP/IP in full Transmission Control Protocol/Internet Protocol Standard Internet communications protocols that allow digital computers to communicate over long distances. and SNA (Systems Network Architecture) IBM's mainframe network standards introduced in 1974. Originally a centralized architecture with a host computer controlling many terminals, enhancements, such as APPN and APPC (LU 6. networking are supported for communications between MS-Windows and the mainframe. No intermediate SQL server An earlier relational DBMS from Sybase and from Microsoft. Sybase introduced SQL Server in 1988 for various Unix versions. In that same year, with help from IBM, Sybase created an OS/2 version that Microsoft licensed and branded as Microsoft SQL Server. is necessary between the desktop and the mainframe so performance is superior to DB2 "gateways." As a mainframe component of DB2/Integrator, SQL Accelerator is used by the DBA. First, the DBA utilizes an easy-to-use SQL Accelerator interface to analyze the characteristics of frequently used DB2 SQL commands that were converted from desktop ODBC SQL requests. Based on the DBA's judgment, he/she uses SQL Accelerator to select which dynamic DB2 SQL requests should be transformed into equivalent DB2 Plans. The equivalent DB2 Plans and the code necessary to execute those plans are generated, stored and prepared for use. Thereafter, at execution time, when SQL Accelerator detects one of the selected dynamic SQL commands, it substitutes and executes the equivalent generated Plan. DBAs can enhance the generated Plan(s) and/or disable To turn off; deactivate. See disabled. the substitution at their discretion. Desktop applications using ODBC are unaware of the execution time substitution. Many benefits are realized when using SQL Accelerator. Desktop users experience lower bills for mainframe access because fewer mainframe resources are spent servicing expensive dynamic DB2 requests. Neither time nor developer resources are spent converting operational dynamic SQL requests into stored procedures that must be debugged with the new DB2 Plans that are built by mainframe DBAs and developers. Performance critical applications can be prototyped and built using dynamic ODBC SQL desktop tools, and placed into production using DB2 Plans with no desktop application changes. DBAs can control DB2 access at the DB2 Plan, collection or package level as well as using table-level security for dynamic SQL activity. TransAccess TransAccess client/server middleware includes Application/Integrator for building distributed function The distribution of processing functions throughout the organization. applications, DB2/Integrator for MS-Windows-based SQL access to mainframe DB2 and soon the Legacy/Integrator for MS-Windows-based SQL access to non-DB2 data on IBM mainframes Following are the mainframe architectures used in IBM mainframes since the original System/360 introduced in 1964. Year Architecture Model numbers System/360 1964 System/360 2xxx (2020 to 2195) System/370 . Netwise, Inc., of Boulder, Colorado The City of Boulder (, Mountain Time Zone) is a home rule municipality located in Boulder County, Colorado, United States. Boulder is the 11th most populous city in the State of Colorado, as well as the most populous city and the county , has pioneered the commercial implementation of distributed applications middleware for PC, UNIX UNIX Operating system for digital computers, developed by Ken Thompson of Bell Laboratories in 1969. It was initially designed for a single user (the name was a pun on the earlier operating system Multics). and mainframe client/server applications. Founded in 1986, Netwise has software installed on nearly 100,000 computers worldwide and offers its products and services in 31 countries around the world. For pricing and other information about TransAccess products, call Netwise world headquarters at 303/442-8280, or write to Netwise, Inc., 2477 55th Street, Boulder, Colorado, 80301, USA. Internet: sales@netwise.com. CONTACT: Netwise, Inc. Jessica Catlin, 303/442-8280 |
|
||||||||||||||
Printer friendly
Cite/link
Email
Feedback
Reader Opinion