Chapter 13 slides - Chapter 13 An introduction to database...

Info iconThis preview shows pages 1–8. Sign up to view the full content.

View Full Document Right Arrow Icon
Murach’s Visual Basic 2008, C13 Slide 1 Chapter 13 An introduction to database programming
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Murach’s Visual Basic 2008, C13 Slide 2 Objectives Knowledge Describe the hardware components of a typical multi-user system. Describe the software components of a typical multi-user database application. Explain how a table in a relational database is organized. Explain how the tables in a relational database are related. Describe the use of these SQL statements: Select, Insert, Update, Delete. Describe the use of these ADO.NET components: data adapter, data command, connection, data reader, dataset, data table. Compare the structure of a dataset with the structure of a relational database.
Background image of page 2
Murach’s Visual Basic 2008, C13 Slide 3 Objectives (continued) Describe concurrency, optimistic concurrency control, and “last in wins.” Describe two ways that you can create ADO.NET components.
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Murach’s Visual Basic 2008, C13 Slide 4 A simple client/server system Client Database server Network Client Client
Background image of page 4
Murach’s Visual Basic 2008, C13 Slide 5 The three hardware components of a client/server system The clients are the PCs, Macintoshes, or workstations of the system. The server is a computer that stores the files and databases of the system and provides services to the clients. When it stores databases, it’s often referred to as a database server . The network consists of the cabling, communication lines, and other components that connect the clients and the servers of the system.
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Murach’s Visual Basic 2008, C13 Slide 6 Client/server system implementations In a simple client/server system , the server is typically a high- powered PC that communicates with the clients over a local area network ( LAN ). The server can also be a midrange system, like an IBM iSeries or a Unix system, or it can be a mainframe system. Then, special hardware and software components are required to make it possible for the clients to communicate with the midrange and mainframe systems. A client/server system can also consist of one or more PC-based systems, one or more midrange systems, and a mainframe system in dispersed geographical locations. This type of system is commonly referred to as an enterprise system . Individual systems and LANs can be connected and share data over larger private networks, such as a wide area network ( WAN ) or a public network like the Internet.
Background image of page 6
Murach’s Visual Basic 2008, C13 Slide 7 Client software, server software, and the SQL interface SQL queries Results Client Database server Application software Data access API Network operating system Database management system Database
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 8
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 08/14/2010 for the course BS computer p taught by Professor Smith during the Spring '10 term at Virtual University of Pakistan.

Page1 / 38

Chapter 13 slides - Chapter 13 An introduction to database...

This preview shows document pages 1 - 8. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online