مدل‌سازی SQL Server برای مبتدیان: توسعه برنامه‌های مدل‌محور در SQL Server 2008

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. Title Page Copyright Page Contents at a Glance Table of Contents About the Author About the Technical Reviewer Acknowledgments Introduction CHAPTER 1 Installing and Setting Up SQL Server Modeling Software Pre-Requisites Hardware and Operating System Requirements Configuring SQL Server Downloading and Installing Checking the Installation If Something Goes Wrong... The Repair Option The Uninstall Option Summary CHAPTER 2 Introduction to Intellipad Getting Started with Intellipad The File Menu The Edit Menu The Find Commands The Replace Command The Go to Line Command Behaviors Disable External Changes The View Menu Full Screen Zoom Split Windows The Mini-Buffer The Help Menu Commands List Intellipad Primer View Title Banner Functions View Modes CHAPTER 3 Domain-Specific Languages 101: Lola’s Lunch Counter Some Caveats A Simple Exercise: The Sandwich Language Where You Want to End Up Getting Started with the Intellipad DSL Grammar Mode Interface Broadening the Choices Interleaving (Ignoring) Whitespace Defining Tokens Enabling Multiple DSL Statements Tightening Up the Syntax Moving Toward Structured Data Testing the Syntax Making the Syntax More Flexible The SandwichLanguage DSL MGraph Extending SandwichOrders to More Than One Main Ingredient Deployment Thinking Ahead Concluding Thoughts CHAPTER 4 Introduction to Quadrant My Car: Creating a Simple Model in Quadrant Building the Car Model in Quadrant Deploying the Model to SQL Server Viewing the Model and Adding Data in the Explorer Customizing Column Views in Quadrant Viewing and Editing the Model in SQL Server Managing Changes to the Data in Quadrant Managing Conflicts in Quadrant Using the Quadrant Explorer Query Bar More on Customizing the View Summary CHAPTER 5 M – The Modeling Language Why M? Getting Started with M Modules The Four Basic Constructs of M Types Intrinsic and Derived Types M’s Built-Ins: The Intrinsic Types The Collection Type Multiplicity Constraints Collection Operators The Entity Type Entity Value Initializers Member Names Entity Values Entity Value Operators Modules Revisited: Import and Export Directives Extents Generating T-SQL Code for the Car Model Computed Values Overloading Languages Summary CHAPTER 6 SQL Server Modeling Services – The Folder Pattern The Modeling Services Folder Pattern Example: A Quality Control System for CarModel CHAPTER 7 SQL Server Modeling Services – Security Using Security to Limit Data Visibility Setting Up – Installing the PatternApplication Sample Building on the CarModel Building the MfgComponentModel Project in Visual Studio Refining the Model to Include Security HasFolderAndAutoId Adding the PatternApplication Module Building the Project Deploying to the Database Creating the QC Folders Building the Sample Data Setting Up the QC Manager Test Users Configuring Test-User Permissions in SQL Server Management Studio Testing Summary APPENDIX A Intellipad Primer Intellipad Basics Buffers Views Modes The Mini-Buffer Working with M in Intellipad SQL Preview Basic DSL Authoring Configuration Customizing Intellipad Changing the Menus Changing the Colors Adding New Modes Customizing Commands Intellipad Components Compiled Components Declarative Components Script Components List of Available Modes Command-Line Options APPENDIX B Intellipad Mini-Buffer Commands APPENDIX C Intellipad Commands and Gestures APPENDIX D The Quadrant Menu Tree APPENDIX E Generated T-SQL for the Car Model Example Index The author includes all the information one needs to be successful with designing and implementing workflow modeling using the Microsoft Oslo platform. Original.