Link xem tivi trực tuyến nhanh nhất xem tivi trực tuyến nhanh nhất xem phim mới 2023 hay nhất xem phim chiếu rạp mới nhất phim chiếu rạp mới xem phim chiếu rạp xem phim lẻ hay 2022, 2023 xem phim lẻ hay xem phim hay nhất trang xem phim hay xem phim hay nhất phim mới hay xem phim mới link phim mới

Link xem tivi trực tuyến nhanh nhất xem tivi trực tuyến nhanh nhất xem phim mới 2023 hay nhất xem phim chiếu rạp mới nhất phim chiếu rạp mới xem phim chiếu rạp xem phim lẻ hay 2022, 2023 xem phim lẻ hay xem phim hay nhất trang xem phim hay xem phim hay nhất phim mới hay xem phim mới link phim mới

intTypePromotion=1
ADSENSE

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

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 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.

Chủ đề:
Lưu

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

  1. DAVID M. KROENKE and DAVID J. AUER  DATABASE CONCEPTS, 3rd Edition Chapter Seven Database Processing Applications and Business Intelligence
  2. 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
  3. Heather Sweeney Designs: Database Design KROENKE and AUER - DATABASE 7-3
  4. Heather Sweeney Designs: HSD Database Diagram in SQL Server 2005 KROENKE and AUER - DATABASE 7-4
  5. 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
  6. The Database Processing Environment KROENKE and AUER - DATABASE 7-6
  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 KROENKE and AUER - DATABASE 7-7
  8. 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
  9. 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
  10. 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
  11. Internet Application Processing Environment KROENKE and AUER - DATABASE 7-11
  12. 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
  13. 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
  14. 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
  15. ODBC, OLE DB, and ADO in the Web Database Processing Environment KROENKE and AUER - DATABASE 7-15
  16. 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
  17. 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
  18. 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
  19. ODBC: Three-tier Web Server Architecture KROENKE and AUER - DATABASE 7-19
  20. 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
ADSENSE

CÓ THỂ BẠN MUỐN DOWNLOAD

 

Đồng bộ tài khoản
2=>2