Oracle update to Data Modeler gives access to Subversion
February 1, 2011 —
Developers are familiar with refactoring code, but when it comes time to optimize the database, that's typically someone else's job. But Oracle is hoping to liberate developers through the Jan. 31 release of version 3.0 of its Oracle SQL Developer Data Modeler. The new version offers developers a quick and graphical way to inspect and redesign their databases.
Sue Harper, senior principal product manager at Oracle, said that the Oracle SQL Developer Data Modeler is designed to be lightweight and easy to use. With it, developers can view the models that make up their databases, regardless of whether or not those databases are from Oracle. She said that the Data Modeler is aimed at both high-level and lower-level users alike.
“Some folk are architects, and they like to build high-level, abstract models," she said. "They really are discussing what the business is about and what's the specific focus of the data. You can start with a high-level model, then forward-engineer it, then generate your DDL, which you then use to create the database."
Version 3.0 remains available in the same manner as its predecessor: Oracle database customers will be able to download the tool from the Oracle Technology Network. New to this version, however, is support for Subversion.
Harper said existing users of the Data Modeler were typically sending their models to the internal version-control servers as a method of keeping a history of database changes. In version 3.0, the Data Modeler is now aware of Subversion, and these models can be uploaded to SVN servers without having to close the application.
Also new to version 3.0 is the ability to open multiple models at once, allowing developers to compare existing models on screen at the same time. Oracle has also included a new set of reports and design rules that can be used alongside data models.
As for the rules, Harper said many users want to enforce policies on their databases. Before, developers could write their own rules to be enforced against the database by the data modeler. These rules could be anything from “Do all of my tables have columns?” to “Do all my columns have certain data types?” said Harper. While enforcing rules upon data is nothing new, the Data Modeler makes the task fast and easy for developers.
In previous versions, developers had to write their own rules, but version 3.0 adds some standard rules for use by developers.
Related Search Term(s): databases, Oracle, SQL Developer Data Modeler
Share this link: http://sdt.bz/35232
Most Read
Latest News
Resources
SAP unveils SAP HANA platform innovations for Big Data and spatial processing
Features include smart data access and expanded cloud deployment options
|
|
|
Alteryx raises $12 million to put Big Data analytics in the hands of all business analysts
Quest founder's firm, Toba Capital, selects Alteryx as its first analytics investment
|
|
|
Google I/O kicks off
Developers get new APIs and tools, and the Go language hits version 1.1
|
|
|
Jelastic launches new version of its Java and PHP hosting platform
Jelastic today announced the launch of a new version of its ultra-scalable cloud hosting platform
|
Telerik adds back-end services to Icenium mobile tool suite
Icenium Everlive makes the suite a complete app development platform, the company says
|
|
|
CollabNet fuses CloudForge, TeamForge
New pricing structure and integration gives developers an enterprise-grade choice for dist...
|
|
|
Eclipse release train for Kepler arrives June 26
New version of Eclipse includes Stardust for business process management, and Orion 3.0 fo...
|
|
|
Google I/O kicks off
Developers get new APIs and tools, and the Go language hits version 1.1
|
IDC MarketScape: Worldwide Cloud Testing and ASQ SaaS
Demand for solutions to test applications on the cloud and for the cloud is rising signifi...
|
|
|
Get to Know the Database Decision Factors
What should you look for when choosing a relational database system? This informative arti...
|
|
|
Exploring the Database Forest
Today’s database technology landscape is more dynamic and varied than ever before. What’s...
|
|
|
Data Management Resource Guide
Today’s data is generated by more than just applications. Data is generated by trillions o...
|