Oracle Unveils SQL Developer 3.0

Oracle (News - Alert) has announced the availability of Oracle SQL Developer 3.0, to ease and enhance Oracle Database developer productivity, the company has announced.

Oracle offers a wide range of options to extend the power of Oracle Database 11g Enterprise Edition to meet specific requirements in the areas of performance and availability, security and compliance, data warehousing, and manageability.

This new release focuses on ease of migration, improving development and database administrator (DBA) tasks, and introduces support for Oracle Data Mining and Oracle Spatial based on customer feedback. Oracle SQL Developer Release 3.0 is downloadable today from the Oracle Technology Network (OTN) and is a free graphical tool for database development.

“Leveraging the mass popularity of Oracle SQL Developer, we are releasing our new Oracle Data Miner 11g Release 2,” said Cetin Ozbutun, vice president of data warehouse 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. Data mining models built with Oracle Data Miner are pushed to storage for execution, providing even better scalability.”

Facilitating data analysts to build and evaluate multiple data mining models, apply models to new data and enable predictive insights across the enterprise, the new Oracle Data Miner extension for Oracle SQL Developer 3.0 is a workflow based graphical user interface for data mining. Enabling users to visualize query results in a map view, the new spatial data management feature provides an SQL schema and functions that facilitate the storage, retrieval, update, and query of collections of spatial features in Oracle Database 11g.

In July 2009, the company introduced the SQL Developer Data Modeler that enables data modeling, design and development for the Oracle Database. This standalone tool supports logical, relational, multi-dimensional, and data type modeling, while featuring multi-layered design and generation capabilities to produce conceptual entity relationship diagrams (ERDs) and transform them to relational models. Users can build, extend and modify a model as well as compare with existing designs.