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

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.
Nội dung trích xuất từ tài liệu:
Lecture Database concepts (3rd Edition): Chapter 7 - David M. Kroenke, David J. Auer DAVIDM.KROENKEandDAVIDJ.AUER DATABASECONCEPTS,3rdEdition Chapter SevenDatabase 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 miningKROENKE and AUER - DATABASE 7-2 Heather Sweeney Designs: Database DesignKROENKE and AUER - DATABASE 7-3 Heather Sweeney Designs:HSD Database Diagram in SQL Server 2005KROENKE and AUER - DATABASE 7-4Database Processing Environment• A database processing environment is complicated and multi-faceted – Multiple users – Multiple queries – Multiple forms – Multiple reports – Multiple application programsKROENKE and AUER - DATABASE 7-5 The Database Processing EnvironmentKROENKE and AUER - DATABASE 7-6 Queries, Forms, and ReportsMicrosoft Access is being used tocreate forms and reports for adatabase running in SQL Server2005 Express EditionKROENKE 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 constraintsKROENKE 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 itselfKROENKE and AUER - DATABASE 7-9Internet 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 applicationKROENKE and AUER - DATABASE 7-10 Internet Application Processing EnvironmentKROENKE 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 ConnectivityKROENKE 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 languagesKROENKE 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 initiativeKROENKE and AUER - DATABASE 7-14 ODBC, OLE DB, and ADO in the Web Database Processing EnvironmentKROENKE 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 serversKROENKE and AUER - DATABASE 7-16 Typical Web Server Setups Microsoft Linux or Unix WindowsWeb Server Internet Information Apache Server (IIS)Scripting ASP Pages with PHPLanguages VBScript or JScript(Interpreted (PHP also works)Object Oriented ASP.NET pages ...