(Steve Callan) A previous article covered some of the features of Visio, “The Microsoft Office Business and Technical Diagramming Program.” One of Visio’s key features is its ability to reverse engineer a database, and in this article, we will take a look at doing exactly that using the sample schem
Tag: Oracle
A Brief Guide to High Availability Deployment
(Greg Sowa) High availability versus cost of implementation is a classic tradeoff when creating an effective deployment environment. Oracle Application Server 10g offers flexibility in deployment configurations, which can closely match designing goals set by system architects. To simplify the choice
Export or import with Oracle Data Pump
(Scott Stephens) In Oracle 10g, exp and imp have been redesigned as the Oracle Data Pump (although Oracle still ships and fully supports exp and imp). If you’re used to exporting exp and imp, the Data Pump command-line programs have a syntax that will look very familiar.
Configuring Java Message Service (Sample Chapter)
(Michael Wessler, Erin Mulder, Rob Harrop and Jan Machacek) In the fast-moving world of technology, in which technologies come in and out of fashion, enterprise messaging has enjoyed a long and successful life. Enterprise messaging simplifies the process of inter-application communication, especia
Database Interaction with PL/SQL, RECORD and TABLE in Sub-programs
(Jagadish Chatarji) This is part 14 of a series of articles focusing on database interactions with Oracle PL/SQL. In my previous article, we concentrated on some tips for using procedures together with the introduction to functions. In this article we will look through several examples that cove
Oracle 10g vs PostgreSQL 8 vs MySQL 5
(Lewis R Cunningham) This is my comparison of installing and getting started with Oracle 10g, PostgreSQL 8 and MySQL 5. This is what I consider the comparison of state of the art for three categories of DB: Commercial vs. Academe vs. Internet Model. This is a comparison from the view of a new us
Technical Comparison with Microsoft SQL Server 2005
The cluster database market is rife with competing marketing claims, with each vendor touting the benefits of its own architecture. The buyer has to make the choice of a mission-critical software platform while sifting through a mass of rapidly evolving benchmark results, conflicting analyst reviews
Oracle 10G Collaboration Suite Finding Its Niche
(Shelley Solheim) As Oracle Corp. prepares to launch the long-delayed update to its Collaboration Suite, early testers of the 10g version say that the package could find a strong support base in a market still dominated by IBM Lotus Software and Microsoft Corp.
Oracle Eyes Open Source Add-ons for Linux
(Vance McCarthy) Oracle is taking the lid off a list of new technologies which engineers at the company say will boost the appeal of Linux for mission-critical enterprise applications.
Part 5: Backup and Availability Features
(Arup Nanda) By now, many of you have realized the potential of RMAN and its utility as a database backup tool. You may recall that RMAN can back up data to disk or tape directly. When a tape solution is involved, RMAN uses an API called Media Management Library (MML) to manipulate the tape subsyste
