| 查看: 184 | 回复: 1 | ||
| 【奖励】 本帖被评价1次，作者wangye增加金币 0.25 个 | ||
| 当前主题已经存档。 | ||
[资源]
【转贴】】Applied Mathematics for Database Professionals 【已搜无重复】
|
||
|
By Lex de Haan, Toon Koppelaars, Publisher: Apress Number Of Pages: 376 Publication Date: 2007-06-21 Sales Rank: 321675 ISBN / ASIN: 1590597451 EAN: 9781590597453 Binding: Hardcover Manufacturer: Apress Studio: Apress Average Rating: 4 Relational databases hold data, right? They indeed do, but to think of a database as nothing more than a container for data is to miss out on the profound power that underlies relational technology. A far more powerful way of thinking lies in relational technology's foundation in the mathematical disciplines of logic and set theory. Databases contain truths or propositions describing some area of interest such as a business. Those truths are organized into sets. Operations from logic and set theory can be applied to existing sets of truths to derive new sets of truths. Applied Mathematics for Database Professionals introduces you to this way of thinking, to the logic and set theory that underlies relational database technology. All this may sound abstract now, but there are profound benefits from the deeper understanding you'll gain from this book. You'll learn to Become a better database designer. You'll make fewer mistakes, and your designs will be more flexible in response to changing data needs. Use the expressive power of mathematics to precisely specify designs and business rules. Communicate effectively about design using the universal language of mathematics. Develop and write complex SQL statements with confidence. Avoid pitfalls and problems from common relational bugaboos such as null values and duplicate rows. The math that you learn in this book will put you above the level of understanding of most database professionals today. You'll better understand the technology and be able to apply it more effectively. You'll avoid data anomalies like redundancy and inconsistency. Understanding what's in this book will take your mastery of relational technology to heights you may not have thought possible. This book is reviewed and endorsed by C. J. Date and features a foreword by the same. Review: Only for those who want to master the database Finally, a book has come along that is not a simple restating of the manual. This is not a book that will tell you how to install a database or how to write RMAN scripts. This book deconstructs all of what it is to be a database. This book is like a vivsection on the "brain" of an RDBMS (specifically, but not exclusively, Oracle). Why this book succeeds is because it walks you, step-by-step, through the simple (yes simple) and well defined (yes, you don't really have to guess) logic that the database uses for EVERY request made of it. It is a must-have for anyone serious about truly understanding why databases work the way they do. Have you sat in any of those meetings where people guessed or even voted on how they thought the database worked? It's so silly. This book will not help you get certified with any database. Certifications are vendor specific and cover a lot more than the narrow focus of this book. So you'll be disappointed if you expect a broad database education. The narrow focus of this book is laying out the internal rules of the database's "thought process." If you understand the power of that narrow focus, this book is for you. If not, keep it on your wish list and I'll bet you'll come back to it someday. I have made this book mandatory reading for my Oracle and SQL Server DBA's (the only databases I currently have DBA's for). While it is in no way a complete database education, I think no database education can be complete without it. Review: Formal Database Specification Writing a book is no easy task. Completing a book when your co-author and friend passes away early in the process, must be a monumental task, this is what Toon Koppelaars achieved with this work. I ordered this book expecting it to contain examples of using statistics, probability and data mining algorithms as applied to databases. In retrospect, I am not sure why I made that assumption. It is actually about formally specifying database designs using logic and set theory. This book is reviewed and endorsed by C. J. Date and features a foreword by him, which would be high praise for any book on the subject of databases. It is split into 3 parts and 12 chapters as follows: 1. Logic: Introduction 2. Set Theory: Introduction 3. Some More Logic 4. Relations and Functions 5. Tables and Database States 6. Tuple, Table, and Database Predicates 7. Specifying Database Designs 8. Specifying State Transition Constraints 9. Data Retrieval 10. Data Manipulation 11. Implementing Database Designs in Oracle 12. Summary and Conclusions If you've studied mathematics (or a tertiary subject with a mathematics element to it) you will most probably be familiar with the sections on set theory and logic. If you have not then they provide an as excellent introduction to these topics that you are likely to find anywhere. This book makes the following claims and I have made my comments against each one: "This book will help you": * "Become a better database designer. You'll make fewer mistakes, and your designs will be more flexible in response to changing data needs." I agree 100% that having a good, if not intuitive, grasp of logic and basic set theory will help you to create better DB schemas. * "Use the expressive power of mathematics to precisely specify designs and business rules." I am not sure how useful this is, and I have a mathematics background. I personally feel that having another notation to express the database design seems to break the DRY (Don't Repeat Yourself) principle. * "Communicate effectively about design using the universal language of mathematics." Personally, I do not think this applies unless you are at the top of your game and/or have a theoretical bias and you are communicating with someone similar. * "Develop and write complex SQL statements with confidence." Absolutely agree. I am often surprised at the number of software developers that do not have a thorough grasp of logic. * "Avoid pitfalls and problems from common relational bugaboos such as null values and duplicate rows". Probably, but then 3NF will go a long way to achieving that. I would be the first to agree that a good, basic mathematics grounding is desirable if you want to confidently design databases that scale well and are modelled correctly. The mathematics that you learn in this book will certainly put you above the level of understanding of most database professionals. But I am not convinced that alone will enable you to better understand the technology and be able to apply it more effectively. It will help you to avoid data anomalies like redundancy and inconsistency, which are not uncommon problems in the world of databases! On the whole, I enjoyed reading this book, but I'm not sure if I learnt anything I could immediately put to use when designing and refactoring databases. I did not put a great deal of effort into learning and understanding the formal database specification language described in this book purely because I could not see an immediate benefit when balanced against the effort required to learn a new notation, and I may well have overlooked something crucial that would indeed enable me to create better database designs. http://mitch-wheat.blogspot.com Disclosure: The Perth .NET User Group is a member of the Apress User Group Program. Apress make copies of their books available for user group libraries, and the copy reviewed here was kindly donated by them. PDF 2.7 Mb with bookmarks and page links in Contents & Index ; RAR 2.5 Mb pass: tFAPMAFODAP.rar http://rapidshare.com/files/65069690/1590597451.rar http://rapidshare.com/files/6508 ... _1590597451_.pdf.7z http://rapidshare.com/files/65142962/APMAFODAP.rar |
回复此楼» 猜你喜欢
孩子确诊有中度注意力缺陷
已经有13人回复
-
三甲基碘化亚砜的氧化反应
已经有4人回复
-
请问下大家为什么这个铃木偶联几乎不反应呢
已经有5人回复
-
请问有评职称，把科研教学业绩算分排序的高校吗
已经有5人回复
-
2025冷门绝学什么时候出结果
已经有3人回复
-
天津工业大学郑柳春团队欢迎化学化工、高分子化学或有机合成方向的博士生和硕士生加入
已经有4人回复
-
康复大学泰山学者周祺惠团队招收博士研究生
已经有6人回复
-
AI论文写作工具：是科研加速器还是学术作弊器？
已经有3人回复
-
论文投稿，期刊推荐
已经有4人回复
-
硕士和导师闹得不愉快
已经有13人回复
★ 一星级,一般
|
谢谢共享 看见好多人询问怎么有密码，我怎么下载不了。其实这些都是共享站点，很容易使用，但你要知道他的规则，比如Rapidshare不支持多线程，你就不能使用迅雷多线程下载等。 所以只要你知道他们的下载规则，你就知道怎么下载了。 我做了一个Rapidshare、Mihd、Live-share等网盘的下载图解教程，不知道怎么下载的朋友可以到那里学习 http://muchong.com/bbs/viewthread.php?tid=591515&fpage=1 |
2楼2007-10-26 11:59:58