In this assignment, you will study the need for front-end applications and data
ID: 3902853 • Letter: I
Question
In this assignment, you will study the need for front-end applications and data connectivity with these applications.
Search the Internet to find various tools and technologies that help create front-end applications, and determine the methods and technologies they use to connect to the backend database. Pay special attention to SQL and XML in your research.
Based on your research, answer the following questions:
Why are data connectivity technologies required? What are their functions?
What are the functions of SQL and XML? Describe from your research.
In your Internet search, also find information about the following:
Object Linking and Embedding, Database (OLE DB)
Open Database Connectivity (ODBC)
Java Database Connectivity (JDBC)
ActiveX Data Objects (ADO)
ADO.NET
Based on your research, answer the following questions:
What is the purpose of each of the above?
Is there any similarity among them? If yes, suggest a suitable name to group these.
Explanation / Answer
Answer)
a) Data connectivity is much needed to connect the front end with the backend. If the data's will not be populated in the front end then data sources are not well connected.
It is a mechanism which helps the application program to connect as well as communicate with that of the data sources.
There function is to optimize the vendor DBMS and provide connection interface.
b) The SQL statement does support the XML data type which helps to perform the data base related operations like the XML data adding the XML columns etc.
c) OLE or Object Linking and Embedding is the technology which is developed by Microsoft which allows the embedding as well as linking of the document as well as other objects.
d) ODBC is defined as the application programming interface meant for accessing the database management systems.