Menu
Oracle data modeler tool gets collaborative

Oracle data modeler tool gets collaborative

SQL Developer Data Modeler 3.0 users can link to Subversion version control system; Microsoft, IBM databases supported too

Oracle will release on Monday Oracle SQL Developer Data Modeler 3.0, an upgrade to its relational database modeling tool that accommodates collaborative development via links to the open source Subversion version control system.

Integrating with Oracle SQL Developer, the tool performs logical relational multidimensional modeling for the Oracle database as well as for Microsoft SQL Server and IBM DB2 databases. The tool "lets developers lay out their database ahead of time," enforcing rules and constraints, said Kris Rice, senior director of database tools at Oracle. The tool features multilayered design and generation capabilities, producing conceptual entity relationship diagrams and transforming them to relational models, Oracle said.

[ With its newly announced WebCenter Suite 11g, Oracle is making a run at Microsoft's SharePoint collaboration platform. | Keep up with the latest developer news with InfoWorld's Developer World newsletter. ]

With Subversion support, a team of developers can work together on a single model and track which persons made specific changes, Rice said. While only Subversion is supported now, Rice indicated that Oracle may at some point add backing for other version control systems.

Also featured in version 3.0 is an extensible design rules engine. "[Users] can write custom rules they apply to the entire model," such as rules about updating records, said Rice.

Additionally, version 3.0 lets users work on multiple models instead of only one model. A reporting capability enables publishing of models to a relational schema and tracking of changes. Through a normal SQL query, users can enforce best practices via the reporting feature, Rice said.

The upgrade adds support for Microsoft SQL Server 2005, DB2 8, and Oracle 11g. But to get the tool, users still need an Oracle database license. Oracle views the tool as being of use in heterogeneous database environments as it offers tight integration with the Oracle database and multiplatform support, working with Linux, Mac, and Windows systems. Data models can be imported from other tools.

The tool is available for download on the Oracle Technology Network.

This article, "Oracle data modeler tool gets collaborative," was originally published at InfoWorld.com. Follow the latest developments in business technology news and get a digest of the key stories each day in the InfoWorld Daily newsletter. For the latest business technology news, follow InfoWorld.com on Twitter.

Read more about data management in InfoWorld's Data Management Channel.


Follow Us

Join the newsletter!

Or

Sign up to gain exclusive access to email subscriptions, event invitations, competitions, giveaways, and much more.

Membership is free, and your security and privacy remain protected. View our privacy policy before signing up.

Error: Please check your email address.

Tags MicrosoftOracleData managementIBMsoftwareapplicationsapplication developmentDeveloper WorldData Modeling

Brand Post

What to expect from your IT Distributor

Whether you’re just starting out or you’ve been around since before the dot com rollercoaster, choosing the right distribution partner can be a pivotal factor in your success. This definitive guide outlines the traits that every IT partner needs to look for in their IT Distributor.

Featured

Slideshows

Channel gathers to celebrate the Reseller News Innovation Awards 2020 winners

Channel gathers to celebrate the Reseller News Innovation Awards 2020 winners

More than 500 channel leaders gathered in Auckland on 21 October at the ​Reseller News Innovation Awards ​2020 to celebrate the achievements of the New Zealand technology industry's top partners, start-ups, vendors, distributors and individuals.

Channel gathers to celebrate the Reseller News Innovation Awards 2020 winners
Meet the winners of the 2020 Reseller News Innovation Awards

Meet the winners of the 2020 Reseller News Innovation Awards

Reseller News honoured the standout players of the New Zealand channel in front of more than 500 technology leaders in Auckland on 21 October, recognising the achievements of top partners, start-ups, vendors, distributors and individuals.

Meet the winners of the 2020 Reseller News Innovation Awards
Meet the Reseller News 30 Under 30 Tech Awards 2020 winners

Meet the Reseller News 30 Under 30 Tech Awards 2020 winners

This year’s Reseller News 30 Under 30 Tech Awards were held as an integral part of the first entirely virtual Emerging Leaders​ forum, an annual event dedicated to identifying, educating and showcasing the New Zealand technology market’s rising stars. The 30 Under 30 Tech Awards 2020 recognised the outstanding achievements and business excellence of 30 talented individuals​, across both young leaders and those just starting out. In this slideshow, Reseller News honours this year's winners and captures their thoughts about how their ideas of leadership have changed over time.​

Meet the Reseller News 30 Under 30 Tech Awards 2020 winners
Show Comments