Spatial Eye depends on Oracle Data Provider for . NE T for integration with Oracle
databases, says Patrick van Dijk, lead developer and architect.
replicas of the production database let us run sophisticated reports
without affecting the performance of the core application.” This
approach also provides Lyris with higher availability, because one of
the many replicas can take over processing automatically if necessary, allowing marketers rock-solid application reliability and access
to up-to-the-minute reports that measure the impact of their digital
Singh also points out how much information and support is available to the MySQL developer and DBA communities, not only from
Oracle but also from MySQL internet support channels, newsgroups,
community forums, and the like. “MySQL is really easy to monitor,
manage, and maintain. And, you don’t necessarily need high-end
hardware,” says Singh.
Singh doesn’t foresee any future problems scaling his MySQL
solution to meet his company’s evolving needs. “It’s pretty simple.
Our product wouldn’t function without MySQL,” says Singh. “No
matter how our business evolves in the future, I’m certain MySQL
will be a part of it, especially given how well it plays with emerging big
The Spatial Eye product portfolio includes a spatial data ware-
house application and an application called Call Before You Dig.
Spatial Eye Call Before You Dig is an off-the-shelf solution that can
be configured and customized for various communication processes
(phone, fax, e-mail) and datasources.
TOOLS FOR TOMORROW
Regardless of which tools developers use to create the next generation of applications, development will still revolve around the data
held in relational databases, such as Oracle Database and MySQL.
“SQL is still the backbone of the industry,” says Oracle’s Hichwa. It’s
still a very effective way to manipulate data, he adds, noting Oracle’s
goal is to make sure “developers have the best experience possible
when creating applications that target Oracle databases.”
DIGGING DEEPER WI TH ORACLE DATA PROVIDER FOR .NET
Although Web-based delivery is the wave of the future for many applications, the approach is not a one-size-fits-all solution. For example,
independent software vendor and Oracle partner Spatial Eye, located
in the Netherlands, uses Microsoft tools and technologies such as
Microsoft . NE T to develop Microsoft Windows–based applications for
For integration with Oracle databases, Spatial Eye’s Windows-
based solutions rely on Oracle Data Provider for . NE T (ODP. NET) to
move data. “From a developer perspective, ODP.NET is very easy to
use,” says Patrick van Dijk, lead developer and architect at Spatial
Eye. “ ODP.NET integrates very well with our environments.”
Users of Spatial Eye software include utility companies, such as
power, water, and telecom, and also municipalities and other agen-
cies that may have underground physical assets that need to be iden-
tified and managed.
David A. Kelly ( davidakelly.com) is a business, technology, and travel
writer who lives in West Newton, Massachusetts.
READ more about
Oracle Database 11g Release 2
Oracle Application Express
Oracle SQL Developer
Oracle Data Provider for . NE T
dynamic scripting languages
JULY/AUGUS T 2012 ORACLE. COM/ORACLEMAGAZINE