On Wed, 22 Apr 2015 22:28:57 +0000 "Drago, William @ CSG - NARDA-MITEQ" <William.Drago at L-3com.com> wrote:
> When using SQLite the application program accesses the SQLite DBMS > via its .dll file. The DLL is a function-call library. A function is a named bit of code. To "call a function" is to jump to that named bit of code. The SQLite functions are part of your application. That means they execute in your process's virtual address space. > When using something like Oracle Express (a local DBMS) the > application program is communicating with Oracle Express via some > sort of network protocol even though there's no network involved. > What is that called? See "loopback" in wikipedia. Oracle is a separate process from yours; you application communicates with it via TCP/IP. If the Oracle process resides on a machine other than the one your process is running on, it connects to that machine with TCP/IP (probably using a hostname and a port number). If the Oracle process is running on the same machine as yours, your process connects to it, still using TCP/IP, but via the loopback network, usually by the name "localhost". >From the point of view of Oracle and your process, there *is* a "network involved" either way. In the case of the loopback address, the network is emulated by the operating system. Many parts are missing (wires, for one, at least ones you can see) but the ends look the same to both players. --jkl