Databases Reference
In-Depth Information
For the best performance in SOA environments, remember the following
four guidelines when designing database applications for SOA environments:
•
Involve data experts in addition to SOA experts to ensure that your services
are designed for scalability and performance. Designing a service for 500
users is different than designing a service for 50 users.
•
Decouple data access from business logic. Building data access dependencies
into services can result in complicated deployment scenarios and reduce
scalability and performance. A better approach is to build a loosely coupled
data access service that can be called by other services to provide data access.
•
Design and tune for performance. Because reusable services typically have
many users and execute the same statements repeatedly, SOA services need
to take advantage of connection pooling and statement pooling. In addition,
some runtime performance tuning options offered by your database driver
can improve performance.
•
Consider data integration. Because most SOA architectures use XML-based
requests and responses, the XQuery language is a good choice for data inte-
gration. XQuery allows you to query any data source that you can view as
XML, including relational databases. It also provides query results as XML,
which eliminates code that would be required to transform other data for-
mats into XML.
