Application
paradigm has evolved rapidly – new programming and scripting
languages geared towards Web and Mobile spring up regularly. DB2 has
embraced new
developments in the application space and continues to be the
database of
choice for application developers. It has kept up with new
programming trends - whenever
a new programming language or framework gets adopted by the developer
community, DB2 steps up and adds or enhances support. Selection of
programming language by developers depends upon several factors such
as skills, performance, usage
scenario, whether libraries are available for desired functionality
etc.
Primary
APIs for DB2 include C and C++, Visual Basic and Visual C# (for .NET
applications),and Java (JDBC and SQLJ). DB2's CLI/ODBC and JDBC
drivers serve as the base for several open source wrappers provided
by DB2 – such as Perl, PhP, Python, Ruby and Node.js Advantage
of using the JDBC and ODBC/CLI drivers as the foundation is that they
not only implement standard API,
but also provide advanced features such as workload balancing,
failover, security, connection management, monitoring etc. that the
wrappers can take advantage of to build robust enterprise
applications. DB2 also contributes actively to the open source
communities to keep them up-to-date. We are also seeing adoption of
frameworks and Object-Relational Mapping tools such as Hibernate,
JPA, iBatis and Spring for enterprise applications that take
advantage of accelerators provided by DB2 for ease of use and
improved performance.
Expect
to see below diagram grow fast over time as application developers
experiment with new APIs and DB2 continues down the path of
supporting those application developers, further strengthening its
position as an ideal database server for Cloud, Analytics and Mobile.
