Comments
yourfanat wrote: I am using another tool for Oracle developers - dbForge Studio for Oracle. This IDE has lots of usefull features, among them: oracle designer, code competion and formatter, query builder, debugger, profiler, erxport/import, reports and many others. The latest version supports Oracle 12C. More information here.
Cloud Expo on Google News
SYS-CON.TV
Cloud Expo & Virtualization 2009 East
PLATINUM SPONSORS:
IBM
Smarter Business Solutions Through Dynamic Infrastructure
IBM
Smarter Insights: How the CIO Becomes a Hero Again
Microsoft
Windows Azure
GOLD SPONSORS:
Appsense
Why VDI?
CA
Maximizing the Business Value of Virtualization in Enterprise and Cloud Computing Environments
ExactTarget
Messaging in the Cloud - Email, SMS and Voice
Freedom OSS
Stairway to the Cloud
Sun
Sun's Incubation Platform: Helping Startups Serve the Enterprise
POWER PANELS:
Cloud Computing & Enterprise IT: Cost & Operational Benefits
How and Why is a Flexible IT Infrastructure the Key To the Future?
Click For 2008 West
Event Webcasts
Oracle Adds Zest to SQL Developer with Standalone Data Modeling Tool
Oracle Offers Better SQL Modeling

Oracle has paved the way for developers to more easily build data models that create and update existing databases. The Oracle SQL Developer Data Modeler, which integrates with Oracle SQL Developer, arrived today as a standalone tool that supports logical, relational, multi-dimensional and data type modeling.

Oracle, Redwood Shores, Calif., had originally released a free version of the tool as an "early adopter" release. The full version is now available for $3,000 per named user. The new tool features 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.

The whole SQL databases and associated tools and modeling ecosystem is ripe for tumult. My best guess is that Oracle's pending Sun Microsystems purchase will provide offense via MySQL, and the associated community, to target the Microsoft SQL Server franchise.

Oracle can both keep tabs on the MySQL evolution while under-cutting Microsoft. Good work, if you can get it. Oh, and they can attract more middleware sales as they seduce the developers and deeply snare the operations folks.

On the other big future directon, to the cloud, modeling and managing data become the points of the arrow to attacting more sticky data into your cloud. We're ready seeing this in business process modeling as IBM is giving away such tools via BlueWorks. The enticement? To bring more process meta data and rules execution to Big Blue's cloud.

My expectation is that Oracle, HP, IBM, Red Hat, Amazon, Google, and Microsoft will begin to offer more "free" cloud-based enticements to enterprise developers and archirects that 1) hurt their competition whenever possible, and 2) solidify their respective advantages to create long-term cloud customers. Then repeat, extend, and solidify. [Disclosure: HP is a sponsor of BriefingsDirect podcasts.]

Remember when free and open source software began to disrupt the staus quo, and the large enterprise vendors could no longer ignore it? They played the same way. IBM, for example, embraced Linux (to hurt Microsoft and also sell more commodity hardware) and Apache web servers (ditto). But IBM did not open source DB2 or WebSphere.

We'll see the same picking and choosing -- tactical and strategic -- of what is "free" or not, cloud-based or not, rationalized on a similar pattern of combined offense and defense. The good news is that the enterprise architects and developers will have more good choices, lowering costs, and be able to play the beheamoths off of one another -- just like with open source.

Perhaps we need to call the cloud thing ... Any Source.

Back to Oracle and its maneuvers in the SQL space ... The capabilities of the new data modeler include:

  • Visual entity relationship modeling, which supports both Barker and Bachman notations so developers can switch between models to suit the audience’s needs or create and save different visual displays
  • Forwarding of engineering ERDs to relational models, transforming all rules and decisions made at the conceptual level to the relational model, where details are further refined and updated
  • Separate relational and physical models that enable users to develop a single relational model for different database versions or different databases.
  • A full spectrum of physical database definitions, supporting physical definitions such as partitions, roles, and tablespaces for specific database versions for multi-database, multi-vendor support

Oracle SQL Developer Data Modeler is generally available today and can be downloaded from the Oracle Technology Network (OTN).

About Dana Gardner
At Interarbor Solutions, we create the analysis and in-depth podcasts on enterprise software and cloud trends that help fuel the social media revolution. As a veteran IT analyst, Dana Gardner moderates discussions and interviews get to the meat of the hottest technology topics. We define and forecast the business productivity effects of enterprise infrastructure, SOA and cloud advances. Our social media vehicles become conversational platforms, powerfully distributed via the BriefingsDirect Network of online media partners like ZDNet and IT-Director.com. As founder and principal analyst at Interarbor Solutions, Dana Gardner created BriefingsDirect to give online readers and listeners in-depth and direct access to the brightest thought leaders on IT. Our twice-monthly BriefingsDirect Analyst Insights Edition podcasts examine the latest IT news with a panel of analysts and guests. Our sponsored discussions provide a unique, deep-dive focus on specific industry problems and the latest solutions. This podcast equivalent of an analyst briefing session -- made available as a podcast/transcript/blog to any interested viewer and search engine seeker -- breaks the mold on closed knowledge. These informational podcasts jump-start conversational evangelism, drive traffic to lead generation campaigns, and produce strong SEO returns. Interarbor Solutions provides fresh and creative thinking on IT, SOA, cloud and social media strategies based on the power of thoughtful content, made freely and easily available to proactive seekers of insights and information. As a result, marketers and branding professionals can communicate inexpensively with self-qualifiying readers/listeners in discreet market segments. BriefingsDirect podcasts hosted by Dana Gardner: Full turnkey planning, moderatiing, producing, hosting, and distribution via blogs and IT media partners of essential IT knowledge and understanding.

Latest Cloud Developer Stories
Nicolas Fierro is CEO of MIMIR Blockchain Solutions. He is a programmer, technologist, and operations dev who has worked with Ethereum and blockchain since 2014. His knowledge in blockchain dates to when he performed dev ops services to the Ethereum Foundation as one the privileg...
It cannot be overseen or regulated by any one administrator, like a government or bank. Currently, there is no government regulation on them which also means there is no government safeguards over them. Although many are looking at Bitcoin to put money into, it would be wise to p...
Andrew Keys is Co-Founder of ConsenSys Enterprise. He comes to ConsenSys Enterprise with capital markets, technology and entrepreneurial experience. Previously, he worked for UBS investment bank in equities analysis. Later, he was responsible for the creation and distribution of ...
René Bostic is the Technical VP of the IBM Cloud Unit in North America. Enjoying her career with IBM during the modern millennial technological era, she is an expert in cloud computing, DevOps and emerging cloud technologies such as Blockchain. Her strengths and core competencies...
Sanjeev Sharma Joins November 11-13, 2018 @DevOpsSummit at @CloudEXPO New York Faculty. Sanjeev Sharma is an internationally known DevOps and Cloud Transformation thought leader, technology executive, and author. Sanjeev's industry experience includes tenures as CTO, Technical Sa...
Subscribe to the World's Most Powerful Newsletters
Subscribe to Our Rss Feeds & Get Your SYS-CON News Live!
Click to Add our RSS Feeds to the Service of Your Choice:
Google Reader or Homepage Add to My Yahoo! Subscribe with Bloglines Subscribe in NewsGator Online
myFeedster Add to My AOL Subscribe in Rojo Add 'Hugg' to Newsburst from CNET News.com Kinja Digest View Additional SYS-CON Feeds
Publish Your Article! Please send it to editorial(at)sys-con.com!

Advertise on this site! Contact advertising(at)sys-con.com! 201 802-3021



SYS-CON Featured Whitepapers
Most Read This Week
ADS BY GOOGLE