Weller Beginning SQL Server Modeling

Model-Driven Application Development in SQL Server 2008
1. ed
ISBN: 978-1-4302-2752-6
Verlag: Apress
Format: PDF
Kopierschutz: 1 - PDF Watermark

E-Book, Englisch, 256 Seiten

Get ready for model-driven application development with SQL Server Modeling! This book covers Microsoft's SQL Server Modeling (formerly known under the code name 'Oslo') in detail and contains the information you need to be successful with designing and implementing workflow modeling. Beginning SQL Server Modeling will help you gain a comprehensive understanding of how to apply DSLs and other modeling components in the development of SQL Server implementations. Most importantly, after reading the book and working through the examples, you will have considerable experience using SQL Modeling components, because the book and accompanying source code take you through the steps of actually building solutions using the platform.  Beginning SQL Server Modeling is the only book that comprehensively covers .NET application development using SQL Modeling. This book explains the critical concepts of SQL Server Modeling and model-driven development that every SQL Server developer should know. The book is simple and concise, giving readers an immediate return on their investment. After learning the lessons of this book, business process analysts and developers will be prepared to use SQL modeling for model-based design, development, and implementations.

Bart Weller is a software developer and writer. He lives in the Central Rockies of Colorado with his wife, two country cats, six misanthropic llamas, and dog Duffey (named in honor of the late John Duffey, former lead tenor with the Seldom Scene bluegrass band). He loves all kinds of music except for Heavy Metal and is a volunteer DJ at the local community radio station. His hobbies are clearing deadfall and fixing things. Among the people he admires are Albert Einstein, Alan Kay, Abraham Lincoln, George Carlin, Richard Feynman, and J.J. Cale.

Autoren/Hrsg.

Weller, Bart

Inhaltsverzeichnis

1;Title Page;1
2;Copyright Page;2
3;Contents at a Glance;4
4;Table of Contents;5
5;About the Author;10
6;About the Technical Reviewer;11
7;Acknowledgments;12
8;Introduction;13
9;CHAPTER 1 Installing and Setting Up SQL Server Modeling;15
9.1;Software Pre-Requisites;15
9.2;Hardware and Operating System Requirements;16
9.3;Configuring SQL Server;16
9.4;Downloading and Installing;18
9.4.1;Checking the Installation;21
9.5;If Something Goes Wrong…;22
9.5.1;The Repair Option;23
9.5.2;The Uninstall Option;23
9.6;Summary;26
10;CHAPTER 2 Introduction to Intellipad;27
10.1;Getting Started with Intellipad;27
10.1.1;The File Menu;28
10.1.2;The Edit Menu;30
10.1.2.1;The Find Commands;31
10.1.2.2;The Replace Command;32
10.1.2.3;The Go to Line Command;33
10.1.2.4;Behaviors;33
10.1.2.5;Disable External Changes;34
10.2;The View Menu;34
10.2.1;Full Screen;35
10.2.2;Zoom;37
10.2.3;Split Windows;37
10.2.4;The Mini-Buffer;38
10.3;The Help Menu;39
10.3.1;Commands List;39
10.3.2;Intellipad Primer;40
10.4;View Title Banner Functions;40
10.4.1;View Modes;41
11;CHAPTER 3 Domain-Specific Languages 101: Lola’s Lunch Counter;47
11.1;Some Caveats;47
11.2;A Simple Exercise: The Sandwich Language;48
11.2.1;Where You Want to End Up;48
11.2.2;Getting Started with the Intellipad DSL Grammar Mode Interface;50
11.2.3;Broadening the Choices;53
11.2.4;Interleaving (Ignoring) Whitespace;54
11.2.5;Defining Tokens;55
11.2.6;Enabling Multiple DSL Statements;56
11.2.7;Tightening Up the Syntax;59
11.2.8;Moving Toward Structured Data;59
11.2.9;Testing the Syntax;62
11.2.10;Making the Syntax More Flexible;66
11.2.10.1;The SandwichLanguage DSL MGraph;67
11.2.11;Extending SandwichOrders to More Than One Main Ingredient;68
11.2.12;Deployment;70
11.2.13;Thinking Ahead;92
11.3;Concluding Thoughts;93
12;CHAPTER 4 Introduction to Quadrant;94
12.1;My Car: Creating a Simple Model in Quadrant;94
12.1.1;Building the Car Model in Quadrant;95
12.1.2;Deploying the Model to SQL Server;98
12.1.3;Viewing the Model and Adding Data in the Explorer;100
12.1.4;Customizing Column Views in Quadrant;106
12.1.5;Viewing and Editing the Model in SQL Server;108
12.1.6;Managing Changes to the Data in Quadrant;110
12.1.7;Managing Conflicts in Quadrant;112
12.1.8;Using the Quadrant Explorer Query Bar;115
12.1.9;More on Customizing the View;118
12.2;Summary;127
13;CHAPTER 5 M – The Modeling Language;128
13.1;Why M?;128
13.2;Getting Started with M;128
13.2.1;Modules;129
13.2.1.1;The Four Basic Constructs of M;130
13.2.2;Types;130
13.2.3;Intrinsic and Derived Types;131
13.2.3.1;M’s Built-Ins: The Intrinsic Types;133
13.2.3.2;The Collection Type;135
13.2.3.2.1;Multiplicity Constraints;136
13.2.3.2.2;Collection Operators;136
13.2.3.3;The Entity Type;138
13.2.3.3.1;Entity Value Initializers;139
13.2.3.3.2;Member Names;139
13.2.3.3.3;Entity Values;139
13.2.3.3.4;Entity Value Operators;140
13.3;Modules Revisited: Import and Export Directives;140
13.4;Extents;142
13.4.1;Generating T-SQL Code for the Car Model;144
13.5;Computed Values;146
13.5.1;Overloading;148
13.6;Languages;149
13.7;Summary;149
14;CHAPTER 6 SQL Server Modeling Services – The Folder Pattern;150
14.1;The Modeling Services Folder Pattern;151
14.2;Example: A Quality Control System for CarModel ;152
15;CHAPTER 7 SQL Server Modeling Services – Security;175
15.1;Using Security to Limit Data Visibility;176
15.2;Setting Up – Installing the PatternApplication Sample;176
15.3;Building on the CarModel;177
15.4;Building the MfgComponentModel Project in Visual Studio;180
15.5;Refining the Model to Include Security;182
15.5.1;HasFolderAndAutoId;187
15.5.2;Adding the PatternApplication Module;188
15.5.3;Building the Project;193
15.5.4;Deploying to the Database;194
15.5.5;Creating the QC Folders;199
15.5.6;Building the Sample Data;202
15.5.7;Setting Up the QC Manager Test Users;207
15.5.7.1;Configuring Test-User Permissions in SQL Server Management Studio;210
15.5.7.2;Testing;213
15.6;Summary;217
16;APPENDIX A Intellipad Primer;218
16.1;Intellipad Basics;218
16.1.1;Buffers;218
16.1.2;Views;219
16.1.3;Modes;219
16.1.4;The Mini-Buffer;219
16.2;Working with M in Intellipad;220
16.2.1;SQL Preview;220
16.2.2;Basic DSL Authoring Configuration;220
16.3;Customizing Intellipad;220
16.3.1;Changing the Menus;221
16.3.2;Changing the Colors;221
16.3.3;Adding New Modes;221
16.3.4;Customizing Commands;222
16.4;Intellipad Components;222
16.4.1;Compiled Components;222
16.4.2;Declarative Components;223
16.4.3;Script Components;223
16.5;List of Available Modes;223
16.6;Command-Line Options;224
17;APPENDIX B Intellipad Mini-Buffer Commands;226
18;APPENDIX C Intellipad Commands and Gestures;227
19;APPENDIX D The Quadrant Menu Tree;235
20;APPENDIX E Generated T-SQL for the Car Model Example;238
21;Index;244