Database Connectivity Methods

This article discusses the three forms of database connectivity methods - ODBC, JDBC and SQLJ and how they facilitate data exchange functionality in a cloud service environment. It also explains the components of an XML document and how XML extensions enable e-Commerce integration among system stakeholders. The article is relevant for students studying computer science, information technology or related courses.

Running head: DATABASE CONNECTIVITY METHODS
Database Connectivity Methods
Name of the Student
Name of the University
Author’s note

1DATABASE CONNECTIVITY METHODS
 Database solutions today must be able to adapt and integrate among various
computing applications. Determine at least three forms of database connectivity
methods that can be used as an interface between applications. For each method you
have chosen, create an example that demonstrates how each could facilitate data
exchange functionality in a cloud service environment.
A database solution could be defined as the various types of solutions for various
business processes and organizations. The various forms of database servers help in
organizing the stored data within their various forms of distributed servers (Chang, 2016).
The designers of the database systems help in designing the various forms of database
models. The three forms of database connectivity methods are: ODBC, JDBC and SQLJ.
 ODBC – It is abbreviated as Open Database Connectivity. It is defined as the standards
or application programming interface (API), which could be majorly used for accessing
the database. Any form of application that would be written within ODBC could be easily
portable to different platforms based on client as well as server side (Miller &
Mork, 2013). ODBC helps in facilitating the functionality of data exchange within an
environment of cloud service as the web based server make use of ODBC for
communicating the database systems. The supported softwares by ODBC are Microsoft
SQL Server and IBM Db2.
 JDBC – The Java Database Connectivity could be defined as an API based on the Java
programming language that would be able to define the ways in which a client system
might access database systems. The JDBC is a platform based on Java Standard Edition,
which is a subsidiary of Oracle Corporation (Keith & Schincariol, 2013). The API of
JDBC makes use of the Java programming language for accessing the database.

2DATABASE CONNECTIVITY METHODS
 SQLJ – The abbreviation of SQLJ is Structured Query Language and Java EE. It is a
form of structured query language that is mainly used for transactions within the database
systems. It thus produces static and embedded SQLJ. This form of extension is static as
the statements based on SQL would be executed during the runtime at the time when the
program would be assembled (Ferstl & Sinz, 2013).
 Suggest at least two software solutions that offer the connectivity methods you have
determined in Part 1 of this discussion to interface with other systems.
The Java applications makes use of DriverManager.getConnection( ) methods in order
to create a connection within the cloud service environment. JDBC is supported by
Oracle Databases and Netbeans.
In order to facilitate the management based on connections with the help of various
sources of data and connection, the Oracle based SQLJ would be able to implement a
wide number of APIs within the runtime12ee library. The various software applications
supported by SQLJ are IBM databases and Oracle Databases. The database connectivity
would be majorly used for retrieval of data from the internet based database servers. It
would also be used for development of dynamic form of web pages and developing them.
The various forms of connectivity methods would be necessary for connecting the
database servers to the cloud computing environment.

3DATABASE CONNECTIVITY METHODS
 XML provides a method for data to be transferred between systems. Specify at least
three components of an XML document. Analyze how each component ensures data
reliability and validation.
The three major components of an XML document are:
 1. An XML Declaration – The validation within an XML document could be defined as
the process of checking a particular document that would be written in XML in order to
ensure that it would be valid within the defined structure.
 2. A declaration based on document type that would refer to a Document Type
Definition (DTD) – The validation within the DTD could be performed with the help of
schema validation.
 3. A Document or body instance – The XMLDocument class would be able to validate
the XML data when it would be loaded into the Document Object Model (DOM). The
XMLReader would be passed to the Load method within the XMLDocument class
(Gandomi & Haider, 2015).
 Identify at least two e-Commerce systems that provide XML data integration. For
each system, describe how XML extensions could enable e-Commerce integration
among system stakeholders such as vendors, resellers, suppliers, and customers.
E-Commerce Systems that provide Integration of XML Data
 Integration of XML Data within Business-to-Business and Business-to-Consumer e-
commerce applications. The traditional form of methods used within B2B e-commerce
applications occurs with the help of Electronic Data Interchange (EDI) that would be

4DATABASE CONNECTIVITY METHODS
expensive, complex and would provide solution based on customer integration (Nicolaou,
Ibrahim & Van Heck, 2013). The query based system makes use of XML data for a
common format within the integration of enterprise. This would make the operations to
be simple than the traditional EDI systems. A complete form of B2B systems would
make use of metadata in order to map the local schema into a form of integrated view and
a server for the purpose of processing XML documents. The B2C mode of e-commerce
provides a mode of standardization within the systems. The conduction of e-commerce
would require the communication within other companies with the help of XML data in
order to simplify communications within businesses. These systems would be used for
mapping in order to transform the XML documents.
 The XML provides the e-commerce business systems for building a standardized
framework for the purpose of creation of business-oriented markup. Based on the
perspective of vendors, suppliers, resellers and customers, it could be discussed that the
use of XML data within B2B and B2C e-commerce systems would be used for accessing
the information within stock based data, catalogs and many others. This would also help
the presentation of the information for the purpose of end use. As the XML based data
are independent of platform, hence they would be used to scale the processing of
information without the needs of the users for making various kinds of adjustments
within the systems (Hsu, 2013).
XML could be able to offer tremendous forms of potential for various kinds of software
developers, consumers, stakeholders and various forms of small and large scale of
businesses. The XML could help in provide a standardized foundation based on the
various solutions within the leveraging of the XML technology (Turban et al., 2017).

5DATABASE CONNECTIVITY METHODS
5. References
Chang, J. F. (2016). Business process management systems: strategy and implementation.
Auerbach Publications.
Ferstl, O. K., & Sinz, E. J. (2013). Grundlagen der Wirtschaftsinformatik. Walter de Gruyter
GmbH & Co KG.
Gandomi, A., & Haider, M. (2015). Beyond the hype: Big data concepts, methods, and
analytics. International Journal of Information Management, 35(2), 137-144.
Hsu, P. F. (2013). Integrating ERP and e-business: Resource complementarity in business value
creation. Decision Support Systems, 56, 334-347.
Keith, M., & Schincariol, M. (2013). Introduction. In Pro JPA 2(pp. 1-14). Apress, Berkeley,
CA.
Miller, H. G., & Mork, P. (2013). From data to decisions: a value chain for big data. It
Professional, 15(1), 57-59.
Nicolaou, A. I., Ibrahim, M., & Van Heck, E. (2013). Information quality, trust, and risk
perceptions in electronic data exchanges. Decision support systems, 54(2), 986-996.
Turban, E., Outland, J., King, D., Lee, J. K., Liang, T. P., & Turban, D. C. (2017). Electronic
commerce 2018: a managerial and social networks perspective. Springer.