Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 9. Database Connectivity > Understanding the Relational Model

9.2. Understanding the Relational Model

Understanding how data is organized in a relational database is the first step in connecting database information to a JSP page. All data in a database is stored in a two-dimensional format called a table. Most databases are made up of many tables, each holding particular sets of data. All tables are made up of a fixed number of rows and columns, very much like a spreadsheet. Each column has a particular name and data type. Each row is called an entry, as it holds a set of data for each column. It is sometimes helpful to think of columns as fields and rows as records. A cell is where a row meets a column to store a particular piece of data.

An address book is a good analogy to a database table. Each set of names and addresses is an entry, and the categories (or fields) for each entry is a column. Take a look at Figure 9.1 to see an address book in table format.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint