CHAPTER 18

LEADING DATABASE SYSTEMS

After reading this chapter, the reader will understand:

  • History of PostgreSQL
  • psql, a client application that facilitate user interaction with PostgreSQL server
  • Some features of PostgreSQL including the query-rewrite system
  • History of Oracle
  • Oracle’s Interface
  • Some object-relational features of Oracle
  • INSTEAD OF trigger and Data Guard feature of Oracle
  • History of Microsoft SQL Server
  • SQL Server Management Studio
  • Establishing connection with SQL Server
  • Transact-SQL that is used for data access in SQL Server
  • History of IBM DB2
  • Managing all the DB2 objects visually through Control Center
  • Some features of IBM DB2

In this chapter, we focus on the leading database systems that implement the database features ...

Get Introduction to Database Systems now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial