數(shù)據(jù)庫(kù)處理

前言

　　The 11th edition of Database Processing refines the organization and content of this classic textbook to reflect a new teaching and professional workplace environment. The organization and topic selection of the llth edition is designed to：　　·Present an early introduction to SQL queries.　　·Use a‘spiral approach’to database design.　　·Use a consistent，generic Information Engineering（IE）Crows Foot E-R diagram notation for data modehng and database design.　　Provide a detailed discussion of specific normal forms within a discussion of normal-ization that focuses on pragmatic normalization techniques.　　·Use current DBMS technology：Microsoft Access 2007。Microsoft SQL Server 2008，Oracle Database llg。and MySQL 5.1.　　·Create Web database applications based on widely used Web development technology.　　·Provide an introduction to business in teHigence（BI）systems.　·Discuss the dimensional database concepts used in database designs for data ware-houses and 0nLine Analytical Processing（OLAP）.

內(nèi)容概要

本書(shū)從基礎(chǔ)、設(shè)計(jì)和實(shí)現(xiàn)三個(gè)層面介紹數(shù)據(jù)庫(kù)處理技術(shù)，內(nèi)容全面翔實(shí)，既包括數(shù)據(jù)庫(kù)設(shè)計(jì)、數(shù)據(jù)庫(kù)實(shí)現(xiàn)、多用戶(hù)數(shù)據(jù)處理、數(shù)據(jù)訪問(wèn)標(biāo)準(zhǔn)等經(jīng)典理論，也包括商務(wù)智能、XML和．NET等最新技術(shù)。本書(shū)在內(nèi)容編排和寫(xiě)作風(fēng)格上新穎，強(qiáng)調(diào)學(xué)習(xí)過(guò)程中的樂(lè)趣，圍繞兩個(gè)貫穿全書(shū)的項(xiàng)目練習(xí)，讓讀者從一開(kāi)始就能把所學(xué)的知識(shí)用于解決具體的應(yīng)用實(shí)例。    本書(shū)每章都有豐富的習(xí)題，可作為高校本科生或研究生的數(shù)據(jù)庫(kù)課程的雙語(yǔ)教材，同時(shí)也是一本很好的專(zhuān)業(yè)參考書(shū)。

書(shū)籍目錄

PART 1　GETTING STARTEDPART 2　DATABASE DESIGNPART 3　DATABASE IMPLEMENTATIONPART 4　MULTIUSER DATABASE PROCESSINGPART 5　DATABASE ACCESS STANDARDSAPPENDICESBibliographyGlossaryIndex

章節(jié)摘錄

　　Wow!That was a full chapter!　　Structured Query Language （SQL） was developed by IBM and has been endorsed by the ANSI SQL-92 and following standards. SQL is a data sublanguage that can be embedded into full programming languages or submitted directly to the DBMS. Knowing SQL is critical for knowledge workers， application programmers， and database administrators.　　All DBMS products process SQL. Access hides SQL， but SQL Server， Oracle， DB2， and MySQL require that you use it　　There are basically two kinds of SQL statements： DML and DDL statements. DML statements include statements for querying data and for inserting， updating， and deleting data. This chapter addresses only DML query statements.　　The examples in this chapter are based on three tables extracted from the operational database at Cape Codd Outdoor Sports. Such database extracts are common and important. Sample data for the three tables is shown in Figure 2-4.　　The basic structure of an SQL query statement is SELECT/FROM/WHERE. The columns to be selected are listed after SELECT， the table（s） to process is listed after FROM， and any restrictions on data values are listed after WHERE. In a WHERE clause， character and date data values must be enclosed in single quotes. Numeric data need not be enclosed in quotes. You can submit SQL statements directly to Access， SQL Server， Oracle， and MySQL， as described in this chapter.

編輯推薦

　　提前介紹了SQL查詢(xún)　　使用“螺旋方法”進(jìn)行數(shù)據(jù)庫(kù)設(shè)計(jì)　　為數(shù)據(jù)建模和數(shù)據(jù)庫(kù)設(shè)計(jì)使用了一種通用的信息工程“鴉腳”E-R模型　　詳細(xì)探討了實(shí)際規(guī)范技術(shù)中的特定范式　　使用了最新的DBMS技術(shù)：Microsoft Access 2007，Microsoft SQL．Setver 2008，Oracle Database 11g，MySQI 5．1　　基于廣泛使用的Web開(kāi)發(fā)技術(shù)，創(chuàng)建了Web數(shù)據(jù)庫(kù)應(yīng)用　　簡(jiǎn)介了商務(wù)智能系統(tǒng)　　探討了數(shù)據(jù)倉(cāng)庫(kù)和聯(lián)機(jī)分析處理數(shù)據(jù)庫(kù)設(shè)計(jì)中使用的維數(shù)據(jù)庫(kù)概念

圖書(shū)封面

圖書(shū)標(biāo)簽Tags

無(wú)

評(píng)論、評(píng)分、閱讀與下載

---

    數(shù)據(jù)庫(kù)處理 PDF格式下載

---