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

Chapter 7 - Database processing applications and business 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. | Database Processing Applications and Business Intelligence Chapter Seven DAVID M. KROENKE and DAVID J. AUER DATABASE CONCEPTS, 3rd Edition 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 7- Heather Sweeney Designs: Database Design 7- Heather Sweeney Designs: HSD Database Diagram in SQL Server 2005 7- Database Processing Environment A database processing environment is complicated and multi-faceted Multiple users Multiple queries Multiple forms Multiple reports Multiple application programs 7- The Database Processing Environment 7- Queries, Forms, and Reports Microsoft Access is being used to create forms and reports for a database running in SQL Server 2005 Express Edition 7- Processing Constraints Enforcing referential integrity Cascading deletion Cascading modifications Data type constraints Data size constraints Data value constraints Null constraints Uniqueness constraints 7- 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 7- 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 7- Internet Application Processing Environment 7- 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 . | Database Processing Applications and Business Intelligence Chapter Seven DAVID M. KROENKE and DAVID J. AUER DATABASE CONCEPTS, 3rd Edition 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 7- Heather Sweeney Designs: Database Design 7- Heather Sweeney Designs: HSD Database Diagram in SQL Server 2005 7- Database Processing Environment A database processing environment is complicated and multi-faceted Multiple users Multiple queries Multiple forms Multiple reports Multiple application programs 7- The Database Processing Environment 7- Queries, Forms, and Reports Microsoft Access is being used to create forms and reports for a database running in SQL Server 2005 Express Edition 7- Processing Constraints Enforcing referential integrity Cascading deletion Cascading .