下载 >  课程资源 >  专业指导 > database design 数据库设计书

database design 数据库设计书

database design 数据库设计书,英文版。很好的学习资料!
2009-06-13 上传大小:10.65MB
想读
分享
收藏 举报
Database Design and Relational Theory

What makes this book different from others on database design? Many resources on design practice do little to explain the underlying theory, and books on design theory are aimed primarily at theoreticians. In this book, renowned expert Chris Date bridges the gap by introducing design theory in ways practitioners can understand—drawing on lessons learned over four decades of experience to demonstrate why proper database design is so critical in the first place. Every chapter includes a set of exercises that show how to apply the theoretical ideas in practice, provide additional information, or ask you to prove some simple theoretical result. If you’re a database professional familiar with the relational model, and have more than a passing interest in database design, this book is for you. Questions this book answers include: Why is Heath’s Theorem so important? What is The Principle of Orthogonal Design? What makes some JDs reducible and others irreducible? Why does dependency preservation matter? Should data redundancy always be avoided? Can it be? Databases often stay in production for decades, and careful design is critical for avoiding subtle errors and processing problems over time. If they’re badly designed, the negative impacts can be incredibly widespread. This gentle introduction shows you how to use important theoretical results to create good database designs. Book Details Series: Theory in Practice Paperback: 278 pages Publisher: O’Reilly Media; 1 edition (April 24, 2012) Language: English ISBN-10: 1449328016 ISBN-13: 978-1449328016

立即下载
Database Design

Database Design 数据库设计

立即下载
beginning_database_design_2nd_edition

beginning database design 2nd edition, 数据库设计

立即下载
Relational_Database_Index_Design_and_the_Optimizers

Relational databases have been around now for more than 20 years. In their early days, performance problems were widespread due to limited hardware resources and immature optimizers, and so performance was a priority consideration. The situation is very different nowadays; hardware and software have advanced beyond all recognition. It’s hardly surprising that performance is now assumed to be able to take care of itself! But the reality is that despite the huge growth in resources, even greater growth has been seen in the amount of information that is now available and what needs to be done with this information. Additionally, one crucial aspect of the hardware has not kept pace with the times: Disks have certainly become larger and incredibly cheap, but they are still relatively slow with regards to their ability to directly access data. Consequently many of the old problems haven’t actually gone away—they have just changed their appearance. Some of these problems can have enormous implications— stories abound of “simple” queries that might have been expected to take a fraction of a second appear to be quite happy to take several minutes or even longer; this despite all the books that tell us how to code queries properly and how to organize the tables and what rules to follow to put the right columns into the indexes. So it is abundantly clear that there is a need for a book that goes beyond the usual boundaries and really starts to think about why so many people are still having so many problems today.

立即下载
database design courseware

很不错的数据库设计课件database design courseware,推荐给大家

立即下载
Beginning Database Design Solutions

Beginning Database Design Solutions 数据库设计解决方案入门经典

立即下载
数据库设计凡人入门

数据库设计凡人入门 Database Design For Mere Mortals 2nd

立即下载
Database Systems Design, Implementation and Management

Database Systems: Design, Implementation, and Management, Ninth Edition Carlos Coronel, Steven Morris, and Peter Rob

立即下载
SQLite Database System Design and Implementation

SQLite数据库系统设计与实现 英文原版PDF,非常好的SQLite源码学习文档

立即下载
Database Systems Design, Implementation & Management, 13th-Carlos Coronel(2018)

这本书是最新的第十三版,要的小伙伴赶紧拉。 高清全彩的pdf

立即下载
Database Systems:A Practical Approach to Design, Implementation and Management

Over 200,000 people have been grounded in good database design practice by reading Database Systems. The new edition of this bestseller brings it up to date with the latest developments in database technology and builds on the clear, accessible approach that has contributed to the success of previous editions. A clear introduction to design, implementation and management issues, as well as an extensive treatment of database languages and standards, make this book an indispensable complete reference for database students and professionals alike

立即下载
Thomas Kyte 汤姆三本orace著作中文\英文版合集\全集

内容包括: Effective_Oracle_by_Design 英文 Expert One-on-One Oracle 中文 Expert One-on-One Oracle 英文 Expert_Oracle_Database_Architecture 中文 Expert_Oracle_Database_Architecture 英文

立即下载
database.design.for.mere.mortals.3rd

数据库设计 People designing database systems at that time needed to have a solid educational background because most of the systems they created were meant to be used companywide. Even when creating databases for single departments within a company or for small businesses, database designers still required extensive formal training because of the complexity of the programming languages and database application programs they were using. As technology advanced, however, those educational requirements evolved.

立即下载
database design

《Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel》第八章 数据库设计部分(英文)

立即下载
[Apress] Beginning Database Design From Novice to Professional

☆ 资料说明:☆ [Apress] Beginning Database Design From Novice to Professional (E-Book)

立即下载
Carlos Coronel, Steven Morris-Database Systems_ Design, Implementation, & Management-Cengage Learning (2016)

Carlos Coronel, Steven Morris-Database Systems_ Design, Implementation, & Management-Cengage Learning (2016)

立即下载
UML for Database Design

UML for Database Design,UML for Database Design,UML for Database Design

立即下载
Pro SQL Server 2012 Relational Database Design and Implementation

《SQL Server 2008数据库设计与实现》的升级版,针对SQL SERVER 2012。英文版的,还没出中文版。

立即下载
UML for Database Design UML数据库设计应用

书的中英文版合集,解开zip文件,中文版是pdf,英文版是chm

立即下载
Database Processing Fundamentals, Design, and Implementation (12th Edition).rar

内容简介 《数据库处理:基础、设计与实现(第11版)(英文版)》从基础、设计和实现三个层面介绍数据库处理技术,内容全面翔实,既包括数据库设计、数据库实现、多用户数据处理、数据访问标准等经典理论,也包括商务智能、XML和NET等最新技术。《数据库处理:基础、设计与实现(第11版)(英文版)》在内容编排和写作风格上新颖,强调学习过程中的乐趣,围绕两个贯穿全书的项目练习,让读者从一开始就能把所学的知识用于解决具体的应用实例。 《数据库处理:基础、设计与实现(第11版)(英文版)》每章都有丰富的习题,可作为高校本科生或研究生的数据库课程的双语教材,同时也是一本很好的专业参考书。 编辑推荐 《数据库处理:基础、设计与实现(第11版)(英文版)》:提前介绍了SQL查询 使用“螺旋方法”进行数据库设计 为数据建模和数据库设计使用了一种通用的信息工程“鸦脚”E-R模型 详细探讨了实际规范技术中的特定范式 使用了最新的DBMS技术:Microsoft Access 2007,Microsoft SQL.Setver 2008,Oracle Database 11g,MySQI 5.1 基于广泛使用的Web开发技术,创建了Web数据库应用 简介了商务智能系统 探讨了数据仓库和联机分析处理数据库设计中使用的维数据库概念 作者简介 作者:(美国)克罗恩克(David M.Kroenke) (美国)奥尔(David Auer) 目录 Preface xvii PART 1 GETTING STARTED Chapter 1:Introduction Chapter Objectives The Characteristics of Databases A Note on Naming Conventions A Database Has Data and Relationships Databases Create Information Database Examples Single-User Database Applications Multiuser Database Applications E-Commerce Database Applications Reporting and Data Mining Database Applications The Components of a Database System Database Applications and SQL The DBMS The Database Personal Versus Enterprise-Class Database Systems What Is Microsoft Access? What Is an Enterprise-Class Database System? Database Design Database Design from Existing Data Database Design for New Systems Development Database Redesign What You Need to Learn A Brief History of Database Processing The Early Years The Emergence and Dominance of the Relational Model Post-Relational Developments Summary Key Terms Review Questions Project Questions Chapter 2:Introduction to Structured Query Language Chapter Objectives Cape Codd Outdoor Sports The Retail Sales Data Extraction RETAIL_ORDER Data ORDER ITEM Data SKU_DATA Table Data Extracts Are Common SQL Background The SQL SELECT/FROM/WHERE Framework Reading Specified Columns from a Single Table Reading Specified Rows from a Single Table Reading Specified Columns and Rows from a Single Table Submitting SQL Statements to the DBMS Using SQL in Microsoft Access 2007 Using SQL in Microsoft SQL Server 2008 Using SQL in Oracle Database 11g Using SQL in Sun Microsystems MySQL 5.1 SQL Enhancements for Querying a Single Table Sorting the Results SQL WHERE Clause Options Combing the SQL WHERE Clause and the SQL ORDER BY Clause Performing Calculations in SQL Queries Using SQL Built-in Functions SQL Expressions in SQL SELECT Statements Grouping in SQL SELECT Statements Looking for Patterns in NASDAQ Trading Investigating the Characteristics of the Data Searching for Patterns in Trading by Day of Week Querying Two or More Tables with SQL Querying Multiple Tables with Subqueries Querying Multiple Tables with Joins Comparing Subqueries and Joins Summary Key Terms Review Questions Project Questions Marcia's Dry Cleaning Morgan Importing PART 2 DATABASE DESIGN Chapter 3:The Eelational Model and Normalization Chapter Objectives Relational Model Terminology Relations Characteristics of Relations Alternative Terminology Functional Dependencies Finding Functional Dependencies Keys Normal Forms Modification Anomalies A Short History of Normal Forms Normalization Categories From First Normal Form to Boyce-Codd Normal Form Eliminating Anomalies from Functional Dependencies Eliminating Anomalies from Multivalued Dependencies Fifth Normal Form Domain/Key Normal Form Summary Key Terms Review Questions Project Questions Marcia's Dry Cleaning Morgan Importing Chapter 4:Database Design Using Normalization Chapter Objectives Assess Table Structure Designing Updatable Databases Advantages and Disadvantages of Normalization Functional Dependencies Normalizing with Choosing Not to Use BCNF Multivalued Dependencies Designing Read-Only Databases Denormalization Customized Duplicated Tables Common Design Problems The Multivalue, Multicolumn Problem Inconsistent Values Missing Values The General-Purpose Remarks Column Summary Key Terms Review Questions Project Questions Marcia's Dry Cleaning Morgan Importing Chapter 5:Data Modeling with the Entity-Relationship Model Chapter Objectives The Purpose of a Data Model The Entity-Relationship Model Entities Attributes Identifiers Relationships Maximum Cardinality Minimum Cardinality Entity-Relationship Diagrams and Their Versions Variations of the E-R Model E-R Diagrams Using the IE Crow's Foot Model Strong Entities and Weak Entities ID-Dependent Entities Non-ID-Dependent Weak Entities Subtype Entities Patterns in Forms, Reports, and E-R Models Strong Entity Patterns ID-Dependent Relationships Mixed Identifying and Nonidentifying Patterns The For-Use-By Pattern Recursive Patterns The Data Modeling Process The College Report The Department Report The Department/Major Report The Student Acceptance Letter Summary Key Terms Review Questions Project Questions Marcia's Dry Cleaning Morgan Importing Chapter 6:Transforming Data Models into Database Designs Chapter Objectives Create a Table for Each Entity Selecting the Primary Key Specifying Candidate (Alternate) Keys Specify Column Properties Verify Normalization Create Relationships Relationships Between Strong Entities Relationships Using ID-Dependent Entities Relationships with a Weak Non-ID-Dependent Entiy Relationships in Mixed Entity Designs Relationships Between Supertype and Subtype Entities Recursive Relationships Representing Ternary and Higher-Order Relationships Relational Representation of the Highline University Data Model Design for Minimum Cardinality Actions When the Parent Is Required Actions When the Child Is Required Implementing Actions for M-O Relationships Implementing Actions for O-M Relationships Implementing Actions for M-M Relationships Designing Special Case M-M Relationships Documenting the Minimum Cardinality Design An Additional Complication Summary of Minimum Cardinality Design The View Ridge Gallery Database Summary of Requirements The View Ridge Data Model Database Design with Data Keys Minimum Cardinality Enforcement for Required Parents Minimum Cardinality Enforcement for the Required Child Column Properties for the View Ridge Database Design Tables Summary Key Terms Review Questions Project Questions Marcia's Dry Cleaning Morgan Importing PART 3 DATABASE IMPLEMENTATION Chapter 7:SQL for Database Construction and Application Processing Chapter Objectives The View Ridge Gallery Database SQL DDL, DML, and a New Type of Join …… PART 4 MULTIUSER DATABASE PROCESSING PART 5 DATABASE ACCESS STANDARDS APPENDICES Bibliography Glossary Index 序言 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)Crow's 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).

立即下载
关闭
img

spring mvc+mybatis+mysql+maven+bootstrap 整合实现增删查改简单实例.zip

资源所需积分/C币 当前拥有积分 当前拥有C币
5 0 0
点击完成任务获取下载码
输入下载码
为了良好体验,不建议使用迅雷下载
img

database design 数据库设计书

会员到期时间: 剩余下载个数: 剩余C币: 剩余积分:0
为了良好体验,不建议使用迅雷下载
VIP下载
您今日下载次数已达上限(为了良好下载体验及使用,每位用户24小时之内最多可下载20个资源)

积分不足!

资源所需积分/C币 当前拥有积分
您可以选择
开通VIP
4000万
程序员的必选
600万
绿色安全资源
现在开通
立省522元
或者
购买C币兑换积分 C币抽奖
img

资源所需积分/C币 当前拥有积分 当前拥有C币
5 4 45
为了良好体验,不建议使用迅雷下载
确认下载
img

资源所需积分/C币 当前拥有积分 当前拥有C币
5 0 0
为了良好体验,不建议使用迅雷下载
VIP和C币套餐优惠
img

资源所需积分/C币 当前拥有积分 当前拥有C币
5 4 45
您的积分不足,将扣除 10 C币
为了良好体验,不建议使用迅雷下载
确认下载
下载
您还未下载过该资源
无法举报自己的资源

兑换成功

你当前的下载分为234开始下载资源
你还不是VIP会员
开通VIP会员权限,免积分下载
立即开通

你下载资源过于频繁,请输入验证码

您因违反CSDN下载频道规则而被锁定帐户,如有疑问,请联络:webmaster@csdn.net!

举报

若举报审核通过,可返还被扣除的积分

  • 举报人:
  • 被举报人:
  • *类型:
    • *投诉人姓名:
    • *投诉人联系方式:
    • *版权证明:
  • *详细原因: