RSS

Database

Oracle SQL Developer 3.0 Launched

By Adrian Bridgwater, April 14, 2011

Support for Oracle Data Mining and Oracle Spatial and Upgraded Migration Workbench

In a product announcement bid aimed at improving Oracle Database developer productivity, the company has this week announced the availability of Oracle SQL Developer 3.0. This graphical tool for database development has been augmented with new migration functionalities designed to appeal to development and database administrator (DBA) tasks. It also introduces support for Oracle Data Mining and Oracle Spatial -- a tool to manage all geospatial data including vector and raster data, topology, and network models.

The company says that for developers looking to access the Oracle TimesTen In-Memory Database, Oracle SQL Developer 3.0 delivers enhancements over the previous version by providing a convenient interface for some basic administration tasks like statistics updates, adding and removing users, and manipulating cache groups, among other features.

The new Oracle Data Miner extension for Oracle SQL Developer 3.0 is a workflow-based graphical user interface for data mining that enables data analysts to build and evaluate multiple data mining models, apply models to new data, and enable predictive insights across the enterprise.

"Leveraging the popularity of Oracle SQL Developer, we are releasing our new Oracle Data Miner 11g Release 2," said Cetin Ozbutun, VP of data warehousing at Oracle. "With Oracle Data Mining, the data, models, and predictive analytics never leave the database enabling significantly more functionality, security, performance, and scalability at a lower total cost of ownership. In addition, when used with Oracle Exadata, data mining models built with Oracle Data Miner are pushed to storage for execution, providing even better scalability."

Oracle SQL Developer 3.0's new features include:

  • Database Navigator -- offers DBAs and developers a simple entry point to browse and update a database, including configuration and storage files, security for profiles, roles, and users.
  • SQL Tuning Advisor -- this code advisor analyzes high-volume SQL statements and offers tuning recommendations to developers writing queries.
  • Explain Plan Diff -- enables developers to run and compare queries and review Explain Plans side-by-side.
  • Query Builder -- offers developers a simple-to-use drag and drop interface for building queries.

Oracle SQL Developer is supported through My Oracle Support with any Oracle Database license and runs on Windows, Linux, and Mac OS X.


Related Reading

News

Most Popular

Commentary

On the Web

Video

Slideshow

More Insights

White Papers

More >>

Reports

More >>

Webcasts

More >>
INFO-LINK




Currently we allow the following HTML tags in comments:

Single tags

These tags can be used alone and don't need an ending tag.

<br> Defines a single line break

<hr> Defines a horizontal line

Matching tags

These require an ending tag - e.g. <i>italic text</i>

<a> Defines an anchor

<b> Defines bold text

<big> Defines big text

<blockquote> Defines a long quotation

<caption> Defines a table caption

<cite> Defines a citation

<code> Defines computer code text

<em> Defines emphasized text

<fieldset> Defines a border around elements in a form

<h1> This is heading 1

<h2> This is heading 2

<h3> This is heading 3

<h4> This is heading 4

<h5> This is heading 5

<h6> This is heading 6

<i> Defines italic text

<p> Defines a paragraph

<pre> Defines preformatted text

<q> Defines a short quotation

<samp> Defines sample computer code text

<small> Defines small text

<span> Defines a section in a document

<s> Defines strikethrough text

<strike> Defines strikethrough text

<strong> Defines strong text

<sub> Defines subscripted text

<sup> Defines superscripted text

<u> Defines underlined text

DrDobbs encourages readers to engage in spirited, healthy debate, including taking us to task. However, DrDobbs moderates all comments posted to our site, and reserves the right to modify or remove any content that it determines to be derogatory, offensive, inflammatory, vulgar, irrelevant/off-topic, racist or obvious marketing/SPAM. DrDobbs further reserves the right to disable the profile of any commenter participating in said activities.

 
Disqus Tips To upload an avatar photo, first complete your Disqus profile. | View the list of supported HTML tags you can use to style comments. | Please read our commenting policy.
 

Best of the Web

What the New iPad and iOS 5.1 Mean for Developers

The new display is gorgeous. But local storage for HMTL5 is currently broken on the new iPad and performance of some apps is slower. Here's a deep dive into the issues, including benchmarks and analysis.

Quick Read

Triple Buffering as A Concurrency Mechanism

Triple Buffering is a way of passing data between a producer and a consumer running at different rates. It ensures that the consumer sees only complete data with minimal lag.

Quick Read

Embedding GDB Breakpoints in C Source Code

Have you ever wanted to embed GDB breakpoints in C source code? Something like this:
printf("Hello,\n");
EMBED_BREAKPOINT;
printf("world!\n");

Quick Read

Writing Kernel Exploits

Why attack the kernel? Because it has a huge attack surface with potential for very interesting bugs. This presentation (pdf) takes a code-level dive into recently reported Linux-kernel exploits.

Quick Read


More "Best of the Web" >>

Database Recent Articles

Most Popular

Stories Blogs

Video

View All Videos

Featured Reports

Featured Whitepapers

Featured Webcasts

Most Recent Premium Content

Digital Issues

Enabling People and Organizations to Harness the Transformative Power of Technology