Databases Reference
In-Depth Information
Figure 2-4.
Direct connection pattern
As simple as it is, this may be one of the most widely used patterns, because it requires no special configuration
or advanced integration technique. For example, a Software as a Service (SaaS) application may use this pattern; in
this case, the consumer is the web site hosted in Azure (or on any other hosting provider). Alternatively, the consumer
may be a smart device or a phone accessing records in SQL Database.
Smart Branching
The
smart branching pattern
(see Figure
2-5
) describes an application that contains sufficient logic to determine
whether the data it needs to load is located in the cloud or in a local database. The logic to make this determination is
either hardcoded in the application or driven from a configuration file. It may also be provided by a data access layer
(DAL) engine that contains logic that fetches data from either a local or a cloud database.
Figure 2-5.
Smart branching pattern
