Lecture Database concepts (3rd Edition): Chapter 7 - David M. Kroenke, David J. Auer

Chia sẻ: 8255652125 8255652125 | Ngày: | Loại File: PPT | Số trang:61

Thêm vào BST

Báo xấu

33
lượt xem 1
download

Download Vui lòng tải xuống để xem tài liệu đầy đủ

Chapter 7 - Database processing applications andbusiness intelligence. In this chapter, you will learn: Understand and be able to set up Web database processing, learn the basic concepts of Extensible Markup Language (XML), learn the basic concepts of business intelligence (BI) systems, learn the basic concepts of OLAP and data mining.

Chủ đề:

Bình luận(0) Đăng nhập để gửi bình luận!

Lưu

Nội dung Text: Lecture Database concepts (3rd Edition): Chapter 7 - David M. Kroenke, David J. Auer

DAVID M. KROENKE and DAVID J. AUER DATABASE CONCEPTS, 3rd Edition Chapter Seven Database Processing Applications and Business Intelligence
Chapter Objectives • Understand and be able to set up Web database processing • Learn the basic concepts of Extensible Markup Language (XML) • Learn the basic concepts of business intelligence (BI) systems • Learn the basic concepts of OLAP and data mining KROENKE and AUER - DATABASE 7-2
Heather Sweeney Designs: Database Design KROENKE and AUER - DATABASE 7-3
Heather Sweeney Designs: HSD Database Diagram in SQL Server 2005 KROENKE and AUER - DATABASE 7-4
Database Processing Environment • A database processing environment is complicated and multi-faceted – Multiple users – Multiple queries – Multiple forms – Multiple reports – Multiple application programs KROENKE and AUER - DATABASE 7-5
The Database Processing Environment KROENKE and AUER - DATABASE 7-6
Queries, Forms, and Reports Microsoft Access is being used to create forms and reports for a database running in SQL Server 2005 Express Edition KROENKE and AUER - DATABASE 7-7
Processing Constraints • Enforcing referential integrity • Cascading deletion • Cascading modifications • Data type constraints • Data size constraints • Data value constraints • Null constraints • Uniqueness constraints KROENKE and AUER - DATABASE 7-8
Triggers and Stored Procedures • A trigger is a stored procedure that is automatically invoked by the DBMS when a specified activity occurs – BEFORE, AFTER and INSTEAD OF • A stored procedure is a module similar to subroutine or function that performs database actions – Stored in the database itself KROENKE and AUER - DATABASE 7-9
Internet Application Processing • Internet Application Processing is more complicated than traditional application processing • Specifically, with Internet Application Processing … – The network becomes an integral part of the application KROENKE and AUER - DATABASE 7-10
Internet Application Processing Environment KROENKE and AUER - DATABASE 7-11
APIs • Every DBMS product has an application program interface (API) – An API is a collection of objects, methods, and properties for executing DBMS functions from program code – Each DBMS has its own API, and APIs vary from one DBMS product to another. • To simplify this situation, the computer industry has developed standards for database access • API interface standards are used to make it easier for programmers – they write to the interface standard instead of the DBMS API – ODBC – Open Database Connectivity – JDBC – Java Database Connectivity KROENKE and AUER - DATABASE 7-12
OBDC and OLE DB • The Open Database Connectivity (ODBC) standard was developed in the early 1990s – Provides a DBMS-independent means for processing relational database data • OLE DB was created by Microsoft in the mid- 1990s – An object-oriented interface – Encapsulates data-server functionality – Designed not just for access to relational databases, but also for accessing many other types of data as well – Readily accessible to programming languages such as C, C#, and Java – Not as accessible to Visual Basic and scripting languages KROENKE and AUER - DATABASE 7-13
ADO and ADO.NET • Microsoft developed Active Data Objects (ADO) – A set of objects for utilizing OLE DB – Designed for use by any language, including VB, VBScript, and Jscript • ADO has been followed by ADO.NET – An improved version of ADO developed as part of Microsoft’s .NET initiative KROENKE and AUER - DATABASE 7-14
ODBC, OLE DB, and ADO in the Web Database Processing Environment KROENKE and AUER - DATABASE 7-15
N-Tier Architecture • Tiers refers to the number of computers involved in the Web database application – The workstation with Web browser is the first tier – Two-tier architecture means that the Web server and the DBMS are on the same server – Three-tier architecture means that the Web server and the DBMS are on separate servers KROENKE and AUER - DATABASE 7-16
Typical Web Server Setups Microsoft Linux or Unix Windows Web Server Internet Information Apache Server (IIS) Scripting ASP Pages with PHP Languages VBScript or JScript (Interpreted (PHP also works) Object Oriented ASP.NET pages JSP pages with Languages with Java (Complied) VisualBasic.Net, (Also see the Mono C#.Net or others project) KROENKE and AUER - DATABASE 7-17
Typical Web DBMS Servers Microsoft Linux or Unix Windows Web Server Internet Information Apache Server (IIS) DBMSs Microsoft Oracle SQL Server MySQL API Interface ODBC JDBC Standard KROENKE and AUER - DATABASE 7-18
ODBC: Three-tier Web Server Architecture KROENKE and AUER - DATABASE 7-19
ODBC Architecture • The application program, the ODBC driver manager, and the ODBC DBMS driver all reside on the Web server • The DBMS driver sends requests to data sources on the database server – A data source is the database, its associated DBMS, operating system, and network platform KROENKE and AUER - DATABASE 7-20