Data Junction Boasts Better Benchmarks on Oracle -- Redmondmag.com

Data Junction Boasts Better Benchmarks on Oracle

By Scott Bekker
07/27/2000

Data Junction Corp. recently released benchmark results using its Data Integration Engine on the Oracle 8i database. Tests were performed on an NT server with a single processor.

According to Data Junction, the results indicated that the Data Junction GUI product increased Oracle load speed by about 300 percent. The performance gains were also achieved when the Data Junction was used to transform and integrate data between Oracle and other applications in heterogeneous environments. These other applications and data formats include SQL, XML, ERP, Legacy, and EDI.

For example, Data Junction would be used if a company already had a Web application build on top of its Oracle database. Data Junction could then integrate more information -- from either an ERP or CRM system – into the Oracle database. Data Junction also says its product can be used as a data warehouse.

To achieve the tests results, Data Junction (www.datajunction.com) ran a 100 MB file with 100,000 records that were 100 bytes per record. The benchmark the company used was not a standardized one, but Data Junction uses the same internal benchmark for all its tests – testing the same size and amount of files each time. The conversion tests were done using three different methods. Via the standard Oracle call interface (OCI) the conversion took 138 seconds; via the array insert in the OCI interface it took 34 seconds; and through the direct path load the conversion took 18 seconds. - Alicia Costanza

About the Author

Scott Bekker is editor in chief of Redmond Channel Partner magazine.

Featured

Cisco Warns of Brute Force Attacks Targeting VPNs and Firewalls

Cisco has revealed that a global increase in brute force attacks targeting Virtual Private Networks (VPNs) and other devices is currently taking place.
What's Inside Microsoft 365's Security Toolbox?

Microsoft provides plenty of native tools to secure Microsoft 365. IT pros just have to know where to look.
Microsoft Kills 30-Day Data Retention Policy for Copilot in Fabric

Microsoft this week announced several usability improvements coming to Copilot in Fabric in preparation of its general availability release later this year.
Using Microsoft Office to Build a Network Diagram 2

Now that we've set up our process, let's dig in with the actual execution.
Microsoft Graph 'Activity Logs' Feature Goes Live

Microsoft announced the general availability of the "activity logs" capability in Microsoft Graph, giving administrators more options to track user activity and identify patterns of potential misuse.