文件名称：Microsoft SQL Server 2008 - T-SQL Querying
文件大小：4.24MB
文件格式：RAR
更新时间：2014-10-03 01:08:02
SQL QUARY LOGIC BI
Databases and database theory have been around for a long time. Early renditions of databases centered around a single database serving every purpose known to the information processing community—from transaction to batch processing to analytical processing. In most cases, the primary focus of the early database systems was operational—usually transactional—processing. In recent years, a more sophisticated notion of the database has emerged—one that serves operational needs and another that serves informational or analytical needs. To some extent, this more enlightened notion of the database is due to the advent of PCs, 4GL technology, and the empowerment of the end user. The split of operational and informational databases occurs for many reasons: ■■ The data serving operational needs is physically different data from that serving informational or analytic needs. ■■ The supporting technology for operational processing is fundamentally different from the technology used to support informational or analytical needs. ■■ The user community for operational data is different from the one served by informational or analytical data. ■■ The processing characteristics for the operational environment and the informational environment are fundamentally different. Because of these reasons (and many more), the modern way to build systems is to separate the operational from the informational or analytical processing and data. This book is about the analytical [or the decision support systems (DSS)] environment and the structuring of data in that environment. The focus of the book is on what is termed the “data warehouse” (or “information warehouse”), which is at the heart of informational, DSS processing. The discussions in this book are geared to the manager and the developer. Where appropriate, some level of discussion will be at the technical level. But, for the most part, the book is about issues and techniques. This book is meant to serve as a guideline for the designer and the developer
【文件预览】：
Microsoft SQL Server 2008 - T-SQL Querying
----Inside Microsoft SQL Server 2008 - T-SQL Querying March 2009.pdf(3.75MB)
----Logical%20Query%20Processing%20Poster.pdf(1.04MB)