Oracle Networking and Connectivity Conclusion
The purpose of this module has been to provide a high-level overview of Oracle networking and to place Oracle connectivity within an historical and conceptual framework.
The main points of this module include:
- Oracle Networking has evolved to meet the changing demands of the 1990s.
- The purpose of Net8 was to hide the complexity of the database connection. Oracle Net8 has since been replaced with Oracle Network Services since Oracle 9i.
- The tnsnames.ora file supplies the host name, protocol, and database name to outgoing database requests.
- Net8 facilitates configuration as a client (TNS names), a server (listener), or both.
- Database links add USER ID and password information to the TNS service names.
- Database links can be hidden from programmers by creating public synonyms.
- The listener process waits for incoming requests and creates a process for the request to establish connectivity with Oracle.
This module introduced you to the following terms:
- Distributed transaction management : A feature of an Oracle database that enables it to manage an update, insert, or delete to multiple databases from a single query. Distributed transaction management
- Fragmentation independence
- Horizontal partitioning:Horizontal partitioning divides a table into multiple tables. Each table then contains the same number of columns, but fewer rows.
For example, a table that contains 1 billion rows could be partitioned horizontally into 12 tables, with each smaller table representing one month of data for a specific year. Any queries requiring data for a specific month only reference the appropriate table.
- packet : A packet is the unit of data that is routed between an origin and a destination on the Internet or any other packet-switched network.
- Replication: The Oracle database provides key data replication and integration features critical to the success and well being of all enterprises in today's fast moving economy.
- Vertical partitioning: Vertical partitioning involves creating tables with fewer columns and using additional tables to store the remaining columns.
Vertical partitioning goes beyond normalization and partitions columns even when already normalized.
Different physical storage might be used to realize vertical partitioning as well.
Done explicitly or implicitly, this type of partitioning is called "row splitting" (the row is split by its columns).
A common form of vertical partitioning is to split (slow to find) dynamic data from (fast to find) static data in a table where the dynamic data is not used as often as the static.
In the coming modules, we will explore the internal details of the Oracle networking engine, taking a close look at the Oracle listener, the multi-threaded server, the Oracle connectivity GUI tools, and a host of other topics.
TNS Names - Quiz
Before moving on to the next module, click the Quiz link below to check your knowledge of the material covered in this module with a short multiple-choice quiz.
TNS Names - Quiz