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

2008 West
DIAMOND SPONSOR:
Data Direct
SOA, WOA and Cloud Computing: The New Frontier for Data Services
PLATINUM SPONSORS:
Red Hat
The Opening of Virtualization
GOLD SPONSORS:
Appsense
User Environment Management – The Third Layer of the Desktop
Cordys
Cloud Computing for Business Agility
EMC
CMIS: A Multi-Vendor Proposal for a Service-Based Content Management Interoperability Standard
Freedom OSS
Practical SOA” Max Yankelevich
Intel
Architecting an Enterprise Service Router (ESR) – A Cost-Effective Way to Scale SOA Across the Enterprise
Sensedia
Return on Assests: Bringing Visibility to your SOA Strategy
Symantec
Managing Hybrid Endpoint Environments
VMWare
Game-Changing Technology for Enterprise Clouds and Applications
Click For 2008 West
Event Webcasts

2008 West
PLATINUM SPONSORS:
Appcelerator
Get ‘Rich’ Quick: Rapid Prototyping for RIA with ZERO Server Code
Keynote Systems
Designing for and Managing Performance in the New Frontier of Rich Internet Applications
GOLD SPONSORS:
ICEsoft
How Can AJAX Improve Homeland Security?
Isomorphic
Beyond Widgets: What a RIA Platform Should Offer
Oracle
REAs: Rich Enterprise Applications
Click For 2008 Event Webcasts
The Advantages of a Model-Based Approach
A Safer, Faster, and More Transparent Method of Managing Schema

The vast majority of schema management today is handled through the generation, review, and execution of SQL scripts.  These scripts can be tiny or huge; they can encapsulate the creation and relationships of several objects or they can describe a one-time alteration to a single object.  Once executed they generally leave no history of their passing other than the presence of the pieces they create, delete or modify; you can be dependent on hundreds of small scripts or on one giant script to build out new environments or evaluate existing ones.  You’re left with a schema that is a massive collection of individual parts applied in an order you can’t reproduce.

Assessing the compatibility of the schema you develop against in relation to what’s in production is a time consuming and error prone process. When you craft new changes, ferreting out the possible impact on other objects in your schema is not intuitive. The specific business needs associated with the individual parts of your schema get murky over time and it’s harder for you to design to your future instead of accommodating your past. There is no traceable history of who did what and why from environment to environment.  Application issues caused by database errors become hard to troubleshoot because there is no easily digestible standard to use as measuring stick in evaluating a malfunctioning environment.

At Datical, we talk a lot about the model-based approach we take to database schema management and how it’s superior to the scenario described above.  When you use Datical DB to employ a model of your database schema, everyone in your organization is working with a transparent and comprehensive representation of your entire schema. There’s no more wandering off into the weeds of individual changes with no sense of history or relationship when trying to make sense of your schema. The model enables a faster, safer, and more transparent method of managing your schema.  Here are some of the perks:

No need for SQL
Instead of writing SQL, the model powers a series of graphical form-based wizards that take the guess work out of change authoring.

Reliable change design based on what your database is, not what you think it should be.
When you need to update the schema, relationships between objects are clearly mapped out in the model and their purposes and history are fully documented and easily accessible.

Forecast: Impact Assessment on a Representative Model
Prior to execution the model can be used to simulate proposed changes in memory without touching your database allowing you to deploy with confidence in sensitive environments.

Traceable History of the Evolution of your Schema
Managing schema change with the model becomes an exercise in incrementally updating a single historical document. Changes are described in a simple, readable format.  The application features and business initiatives the changes support are tied to the changes themselves giving data architects and developers insight into why a change was made. The reliance on tribal knowledge disappears because everything you need to know about the “why” of a database change is tied to the change itself.

Easy Comparison of Models
Every database instance is now an instance of the same model.  The model provides the structure you need to quickly ascertain what’s missing, what’s wrong, and what needs to be done to bring your disparate environments into synchronization.

Clear View of Completeness
The operations personnel that deploy and monitor your applications can easily establish the database schema is everything it should be and detect drift more easily than they could previously by eyeballing diagrams or reviewing batches of deployment script.  If reality doesn’t match the model, the path to remediation is clear.

About Pete Pickerill
Pete Pickerill is Vice President of Products and Co-founder of Datical. Pete is a software industry veteran who has built his career in Austin’s technology sector. Prior to co-founding Datical, he was employee number one at Phurnace Software and helped lead the company to a high profile acquisition by BMC Software, Inc. Pete has spent the majority of his career in successful startups and the companies that acquired them including Loop One (acquired by NeoPost Solutions), WholeSecurity (acquired by Symantec, Inc.) and Phurnace Software.

Latest AJAXWorld RIA Stories
"We work around really protecting the confidentiality of information, and by doing so we've developed implementations of encryption through a patented process that is known as superencipherment," explained Richard Blech, CEO of Secure Channels Inc., in this SYS-CON.tv interview a...
"Our strategy is to focus on the hyperscale providers - AWS, Azure, and Google. Over the last year we saw that a lot of developers need to learn how to do their job in the cloud and we see this DevOps movement that we are catering to with our content," stated Alessandro Fasan, He...
Data is the fuel that drives the machine learning algorithmic engines and ultimately provides the business value. In his session at Cloud Expo, Ed Featherston, a director and senior enterprise architect at Collaborative Consulting, discussed the key considerations around qualit...
Andi Mann, Chief Technology Advocate at Splunk, is an accomplished digital business executive with extensive global expertise as a strategist, technologist, innovator, marketer, and communicator. For over 30 years across five continents, he has built success with Fortune 500 corp...
DXWorldEXPO LLC announced today that the upcoming DXWorldEXPO | CloudEXPO New York event will feature 10 companies from Poland to participate at the "Poland Digital Transformation Pavilion" on November 12-13, 2018.
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
ADS BY GOOGLE