ODBC AND JDBC EXPLANATION

WHAT IS NOSQL?

NoSQL databases (aka "not only SQL") are non tabular, and store data differently than relational tables. NoSQL databases come in a variety of types based on their data model.

What is ODBC and JDBC?

ODBC is an SQL-based Application Programming Interface (API) created by Microsoft that is used by Windows software applications to access databases via SQL. JDBC is an SQL-based API created by Sun Microsystems to enable Java applications to use SQL for database access.

Open Database Connectivity

An ODBC driver uses the Open Database Connectivity (ODBC) interface by Microsoft that allows applications to access data in database management systems (DBMS) using SQL as a standard for accessing the data.

 

How does ODBC connection work?

 ODBC architecture has four components that work together to process and call functions, load drivers, and return results to the application. ... Driver, which processes ODBC function calls, submits SQL requests to a specific data source, and returns results to the application.

 

Java Database Connectivity(SHORT EXPLAINATION)

Java Database Connectivity is an application programming interface (API) for the programming language Java, which defines how a client may access a database. It is a Java-based data access technology used for Java database connectivity. It is part of the Java Standard Edition platform, from Oracle Corporation.