Table of Contents 5 About the Author 13 About the Technical Reviewer 14 Acknowledgments 15 Introduction 16 Chapter 1: Introducing the MySQL Shell 20 Getting To Know the MySQL Shell 21 Overview 21 Features 24 Old Features New Again 28 JSON Data Type 28 X Plugin, X Protocol, and X DevAPI 34 InnoDB Improvements 35 New Features 36 Data Dictionary 37 Account Management 38 Roles 39 User Account Limits 39 Password Management 40 User Account Locking 40 Removed Options, Variables, and Features 40 Paradigm Shifting Features 42 Document Store 42 Group Replication 43 InnoDB Cluster 44 Summary 45 Chapter 2: Installing the MySQL Shell 47 Preparing to Install the MySQL Shell 47 Prerequisites 47 How to Get the MySQL Shell 48 Installing on Windows with the MySQL Installer 50 Installing on macOS 67 Installing MySQL Server 69 Installing the MySQL Shell 75 Installing on Linux (Ubuntu) with the APT Repository 80 Downloading the APT Repository 81 Installing the APT Repository 83 Installing MySQL Server 84 Installing MySQL Shell 88 Summary 91 Chapter 3: MySQL Shell Tutorial 92 Commands and Options 92 Starting the MySQL Shell 93 Commands 94 Options 97 Getting Started with the MySQL Shell 100 Sessions and Modes 102 Session Objects 102 Modes Supported 104 Using Connections 105 Using a URI 105 Using Individual Options 107 Using Connections in Scripts 107 Using SSL Connections 108 Working with the MySQL Shell 110 Installing the Sample Database 110 Working with Data 113 Using Formatting Modes 121 Code/Command History 125 Saving Passwords 126 Customizing the Shell 128 Using the \option Command 128 Using the shell.option Object 130 Using the Configuration File 131 Working with Saved Passwords 132 Changing the Prompt 133 Summary 135 Chapter 4: Using the Shell with SQL Databases 136 Revisiting Relational Databases 136 Working with MySQL Commands and Functions 141 Terminology 141 Creating Users and Granting Access 142 Creating Databases and Tables 143 Creating a Database 143 Creating a Table 144 Storing Data 146 Updating Data 147 Deleting Data 148 Selecting Data (Results) 149 Creating Indexes 156 Creating Views 157 Simple Joins 158 Additional Advanced Concepts 161 Managing Your Database with Python 163 MySQL X Module 164 Session Class 166 Schema Class 167 Transaction Methods 168 Connection Methods 170 Miscellaneous Methods 170 CRUD Operations (Relational Data) 171 Schema Class 172 Table Class 173 Creating Data 178 Reading Data 179 Updating Data 180 Deleting Data 181 Working with Results 182 Getting Started Writing Python Scripts 187 Summary 192 Chapter 5: Example: SQL Database Development 193 Getting Started 193 Sample Application Concept 194 Database Design 197 Vendor Table 199 Organizer Table 200 Storage Place Table 201 Storage Equipment Table 202 Handtool Table 203 Powertool Table 204 Location View 205 Code Design 206 Setup and Configuration 208 Demonstration 210 MyGarage Class 211 Writing the Source Code 212 Testing the Class 215 Location Class 218 Writing the Source Code 219 Testing the Class 223 Vendor Class 225 Create 225 Read 227 Update 230 Delete 232 Handtool Class 234 Organizer Class 236 Place Class 237 Powertool Class 237 Storage Class 238 Testing the Class Modules 238 Summary 246 Chapter 6: Using the Shell with a Document Store 247 Overview 247 Origins: Key, Value Mechanisms 248 Application Programming Interface 250 NoSQL Interface 250 Document Store 251 JSON 251 Introducing JSON Documents in MySQL 252 Quick Start 253 Combining SQL and JSON 255 Formatting JSON Strings in MySQL 256 Using JSON Strings in SQL Statements 257 Path Expressions 260 JSON Functions 265 Creating JSON Data 267 Modifying JSON Data 271 Searching JSON Data 274 Utility Functions 280 Summary 288 Chapter 7: Example: Document Store Development 290 Getting Started 290 Sample Application Concept 291 Schema Design 296 Cabinets Collection 298 Locations Collection 300 Organizers Collection 301 Shelving Units Collection 302 Toolchests Collection 303 Tools Collection 304 Vendors Collection 305 Workbenches Collection 305 Code Design 306 Setup and Configuration 307 Converting Relational Data to a Document Store 308 Step 1: Conversion Setup Code 309 Step 2: Helper Functions 310 Step 3: Populate Collections 314 Step 4: Add Locations 320 Importing Data to a Document Store 323 Demonstration 325 MyGarage Class 326 Writing the Source Code 327 Testing the Class 331 Collection Base Class 334 Writing the Source Code 335 Testing the Class Modules 343 Summary 349 Chapter 8: Using the Shell with Group Replication 351 Overview 352 What is High Availability? 352 MySQL High Availability Features 355 What is MySQL Replication? 356 What is Group Replication? 358 Setup and Configuration 362 Tutorial 363 Initialize the Data Directories 364 Configure the Master 365 Configure the Slaves 367 Start the MySQL Instances 369 Create the Replication User Account 371 Connect the Slaves to the Master 372 Connect with Log File and Position 372 Connect with GTIDs 373 Start Replication 374 Verify Replication Status 377 Shutting Down Replication 379 Summary 380 Chapter 9: Example: Group Replication Setup and Administration 381 Getting Started 381 Concepts, Terms, and Lingo 382 Group Replication Fault Tolerance 384 Setup and Configuration 385 Tutorial 385 Initialize the Data Directories 387 Configure the Primary 388 Primary Configuration File 390 Secondary Configuration File 391 Start the MySQL Instances 393 Create the Replication User Account 395 Start Group Replication on the Primary 396 Connect the Secondaries to the Primary 396 Start Group Replication on the Secondaries 397 Verify Group Replication Status 397 Shutting Down Group Replication 402 Demonstration of Failover 402 Summary 405 Chapter 10: Using the Shell with InnoDB Cluster 406 Overview 406 InnoDB Storage Engine 410 Archive 412 Blackhole 412 CSV 413 Federated 413 Memory 413 MyISAM 414 Merge (MyISAM) 414 Performance Schema 415 Group Replication 415 MySQL Shell 416 X DevAPI 416 AdminAPI 416 MySQL Router 417 Using InnoDB with Applications 418 Setup and Configuration 420 Upgrade Checker 420 Overview of Installing InnoDB Cluster 424 Summary 425 Chapter 11: Example: InnoDB Cluster Setup and Administration 426 Getting Started 426 dba 427 cluster 432 Setup and Configuration 434 Create and Deploy Instances in the Sandbox 436 Create the Cluster 439 Failure to Create Cluster 440 Add the Instances to the Cluster 441 Check the Status of the Cluster 443 Failover Demonstration 445 Using MySQL Router 450 Bootstrapping the Router 450 Starting the Router 453 Sample Application 453 Application Failover Demonstration 456 Administration 458 Common Tasks 459 Example Tasks 460 Shutting Down the Cluster 460 Restarting the Cluster 461 Summary 463 Chapter 12: Appendix 464 Setup Your Environment 464 Installing Flask 466 Installing Flask-Script 467 Installing Flask-Bootstrap 468 Installing Flask-WTF 469 Installing WTForms 470 Installing Connector/Python 470 Flask Primer 471 Terminology 472 Initialization and the Application Instance 474 Flask-Script 474 Flask-Bootstrap 477 WTForms 478 Flask-WTF 478 Form Classes 478 Cross-Site Request Forgery (CSRF) Protection 481 Message Flashing 482 HTML Files and Templates 483 Jinja2 Templates Overview 483 HTML Files Using Templates 486 Error Handlers 490 Not Found (404) Errors 490 Application (500) Errors 491 Redirects 492 Additional Features 493 Flask Review: Sample Application 493 Preparing Your PC 494 Running the Sample Application 496 How to Use the Application 502 CRUD Operations in the Application 503 Shutting Down the Sample Application 504 Index 505

The primary purpose of this book is to bridge the gap be tween the practice of clinical medicine and diagnostic radi ology. It is intended primarily for utilization by medical students in training and by nonradiologist physicians. In this world of rapidly expanding knowledge in the many specialties of medicine, it is becoming increasingly difficult for many physicians to stay abreast of the newer and constantly changing modalities of diagnosis as well as the therapeutic regimens of the common as well as the less common disease processes within their realm of practice. This book will enable the busy clinician to utilize the consultative services offered by his or her colleagues in diagnostic radiology with maximum effectiveness. The most common clinical applications of the more recent imag ing modalities (i. e. , nuclear medicine, ultrasound, comput erized tomography, and magnetic resonance imaging) have been categorized and condensed into a format that will be both comprehensible and useful on a daily basis for those physicians routinely requesting these diagnostic examina tions for their patients. For simplicity, the book is divided, whenever feasible, into organ systems and subdivided into the multiple classifications of pathologic states (i. e. , con genital, trauma or iatrogenic, inflammatory, and neo plasm). In addition, there are brief comments related to the vii specific advantages and disadvantages as well as the cost effectiveness of each modality. Erscheinungsdatum: 02.04.2012

__Uncertain Decisions: Bridging Theory and Experiments__ presents advanced directions of thinking on decision theory - in particular the more recent contributions on non-expected utility theory, fuzzy decision theory and case-based theory. This work also provides theoretical insights on measures of risk aversion and on new problems for general equilibrium analysis. It analyzes how the thinking that underlies the theories described above spills over into real decisions, and how the thinking that underlies these real decisions can explain the discrepancies between theoretical approaches and actual behavior. This work elaborates on how the most recent laboratory experiments have become an important source both for evaluating the leading theory of choice and decision, and for contributing to the formation of new models regarding the subject.

Issue for 1946 called Sexennial report; 1955- called 15th- Anniversary report