ODBC vs JDBC Typically, software applications are written in a specific programming language (such as Java, C#, etc.), while databases accept queries in some other database specific language (such as SQL). Therefore, when a software application needs to access data in a database, an interface that can translate languages to each other (application and database) […]
Difference Between Pointer and Array
Pointer vs Array A pointer is a data type that holds a reference to a memory location (i.e. a pointer variable stores an address of a memory location in which some data is stored). Arrays are the most commonly used data structure to store a collection of elements. Most programming languages provide methods to easily […]
Difference Between Triggers and Stored Procedures
Triggers vs Stored Procedures In a database, a trigger is a procedure (code segment) that is executed automatically when some specific events occur in a table/view. Among its other uses, triggers are mainly used for maintaining integrity in a database. A stored procedure is a method that can be used by applications accessing a relational […]
Difference Between Arraylist and Vector
Arraylist vs Vector An arraylist can be seen as a dynamic array, which can grow in size. Due to this reason, the programmer does not need to know the size of the arraylist when he/she is defining it. Vector can also be seen as an array that can grow in size. Vectors can be easily […]
Difference Between Arrays and Arraylists
Arrays vs Arraylists Arrays are the most commonly used data structure to store a collection of elements. Most programming languages provide methods to easily declare arrays and access elements in the arrays. An arraylist can be seen as a dynamic array, which can grow in size. Due to this reason, the programmer does not need […]
Difference Between Indexing and Sorting
Indexing is a method that is used to improve the data retrieval speed in a table of a database. An index could be created using a single or more columns in a table and the index is stored in a separate file. Indices can be created as unique indices or non-unique indices. Sorting is the […]
Difference Between Filesystem and Database
The key difference between filesystem and database is that filesystem manages only the physical access while database manages both the physical and logical access to the data. Database and File System are two methods that help to store, retrieve, manage and manipulate data. Both systems allow the user to work with data similarly. A File […]
Difference Between Inner Join and Outer Join
Inner Join vs Outer Join Inner join and Outer join are two of the SQL joining methods used in query processing for databases. They belong to the family of join clauses (other two being Left and Right Joins). However, there is a Self Join which can be used for specialized situations. The purpose of Join […]
Difference Between Java and Oracle
Java vs Oracle Oracle database (simply referred to as Oracle) is an Object Relational Database Management System (ORDBMS) that supports a large range of platforms. Oracle DBMS is available in different versions ranging from versions for personal use and enterprise class versions. It is the most widely used database system in the world. Java is […]
Difference Between MySQL and MySQLi Extension
MySQL vs MySQLi Extension MySQL is a popular Relational Database Management System (RDBMS). It is an open source DBMS that is used widely even in large scale enterprises such as Wikipedia, Google and Facebook. PHP (stands for PHP: Hypertext Preprocessor) is a server side scripting language, especially suited for developing dynamic and interactive web pages. […]
- « Previous Page
- 1
- …
- 4
- 5
- 6
- 7
- 8
- …
- 10
- Next Page »