Upcoming Events

Executive conference

Cloud Connect March 16-18

Comprehensive thought leadership for executives, IT professionals and developers. Topics include: the ROI, cost and economics of on-demand computing; Migration strategies to move from on-premise to cloud-based IT; Vertical cloud specialization, tailoring features and architectures to specific applications, industries, and customer ecosystems

More Events »

Subscribe to Newsletter

  • Keep up with all of the latest news and analysis on the fast-moving IT industry with Network Computing newsletters.
Sign Up




DBMS Tools for Web Intergration: Pour It On!

By Barry Nance   Assigning an expert database programmer to a Web site creation-and-maintenance project is akin to having a housepainter show up everyday to touch up nicks and scrapes on your walls. Given the variety of paint and painting methods, and the fact that learning how to wield a paintbrush is easy, bringing in a professional to handle such tasks would be a waste of his skills and your money. The same goes for hiring a programmer to create and maintain your Web site.

To view the Report card.
More flavors of database tools exist than there are shades of white housepaint. This is fortunate, because you need to assemble a range of tools for relational database management systems (RDBMSes)--query tools, schema design tools, replication tools, monitoring tools, optimization tools, security tools. A relatively new and popular category of database tools is Web-oriented. The latest versions of RDBMS products from IBM Corp., Microsoft Corp.and Oracle Corp. include software aids for incorporating database content into Web pages; many third-party software vendors also offer similar tools for your database toolbox.

We evaluated these Web-database integration tools on an intranet consisting of Pentium Pro-based NT Server 4.0 machines, an Ethernet LAN running TCP/IP and a variety of clients (Windows NT, Windows 95, OS/2 Warp and Macintosh System 7). In each case, we connected via Open Database Connectivity (ODBC) or native interface to Oracle7.3, SQL Server 6.5 and DB2 Universal Database 5.0.

Tools for accessing a database in a Web environment differ in three key aspects: database interface, Web server interface and visual design environment. In our evaluation of the current crop of da tabase and Web integration tools, we examined carefully the extent and quality of code generation, we looked closely at how the product's user interface helped build Web pages containing database content, and we tested the variety of presentation options for database material. To get top marks, a product needed to exhibit several characteristics: native connectivity to the major databases and ODBC connectivity to all other databases; NSAPI, ISAPI, WRBAPI and CGI connectivity to Web servers; production of robust, uncrashable JavaScript, VBScript and Java code; no-programming-required, drag-and-drop construction of database-oriented Web pages and associated software; and the ability to display database contents in table, list and single-entry formats.

The following eight toolsets were reviewed: Bluestone Software's Sapphire/Web 4.0; Borland International's IntraBuilder; EveryWare Development Corp.'s Tango Enterprise; IBM's Net.Data; Microsoft's Active Server Pages technology, Web Assistant and Visual Interd ev; Oracle's Developer/2000; Prolifics' Prolifics 2.0; and Sybase's NetImpact Dynamo. In addition, we reviewed two mainframe-oriented tools to help you Web-enable legacy applications--Host Publishing System from Attachmate Corp. and InfoSession from PLATINUM technology (see "Mainframe Tools for Web Database Access," on page 60).

Of the tools we evaluated, Bluestone's Sapphire/Web stood out for its clean, intuitive interface and excellent code generation, and it earns our Editor's Choice award. Not to be easily outdone, Borland's low-cost IntraBuilder exhibited a rich, yet right-to-the-point interface and comprehensive database support; we give it our Best Value commendation. However, all of the tools reviewed had strong points that merit your consideration.

Bluestone Software Sapphire/Web 4.0
Sapphire/Web connected to more databases and Web servers, generated more robust code in mo re languages, and offered easier-to-use drag-and-drop creation of Web pages containing database material than any other product we reviewed. It's a winner.

A full-featured development environment for Web-based programming, Sapphire/Web made short work of creating a complex, robust, database-oriented Web application in our testing. Particularly impressive in our lab-based workout were Sapphire/Web's code-generation wizards. Depending on whether we selected Java Framework or ActiveX Framework, these programming robots emitted Java, ActiveX components, JavaScript and VBScript for us. The generated code was the most robust of all the code produced. Additionally, Bluestone says it's continually producing new wizards and improving existing ones.



To download an Adobe Acrobat .pdf format version of DBMS Tools features charts, click here.



Side Bar 0n
Mainframe Tools For Web Database Access

For other up to date information on
Middleware
Check out these Links
Into ORBit
Is DCOM Truly The Object Of Middleware's Desire?
Web Middleware Glue Binds Web Apps
A Grand Opening For Virtual Storefronts With Middleware
Examining The Network Performance Of JDBC
State Of Middleware: Just Beyond The Limelight
Updated September 8, 1997

Best of the Web

Data deduplication: Declawing the clones

Data deduplication is emerging as a critically important new arrow in the storage administrator's quiver to answer hard questions about the increasing problem in storage growth costs.

Quick Read

Compression, Encryption, Deduplication, and Replication: Strange Bedfellows

One of the great ironies of storage technology is the inverse relationship between efficiency and security: Adding performance or reducing storage requirements almost always results in reducing the confidentiality, integrity, or availability of a system.

Quick Read

WAN Optimization Whitelists and Blacklists

Optimization is a fantastic way of saving money and creating really happy customers at the same time, but it doesn't work flawlessly for all applications.

Quick Read

WAN Optimization as a Managed Service: It's Not About the Cost

This insight examines how organizations outsourcing their WAN optimization initiatives to a third-party go about achieving their goals for application performance, reducing operational costs, and streamlining enterprise infrastructure.

Quick Read

  Sponsored Links

Premium Content

Data Centers Gone Wild
February 22, 2010

NWC


Salary

Video