Part 2. Database patterns

Part 2 covers three main areas: legacy database patterns (which most solution architects are familiar with), NoSQL patterns, and native XML databases.

Chapter 3 reviews legacy SQL patterns associated with relational and data warehouse databases. If you’re already familiar with online transactional processing (OLTP), online analytical processing (OLAP), and the concepts used in distributed revision control systems, you can skim this chapter.

Chapter 4 introduces and describes the new NoSQL patterns. You’ll learn about key-value stores, graph stores, column family stores, and document stores. This chapter should be read carefully, as it’ll be referenced throughout the text.

Chapter 5 looks at patterns that are unique to native XML databases and standards-driven systems. These databases are important in areas such as government, health care, finance, publishing, integration, and document search. If you’re not concerned with portability, standards, and markup languages, you can skim this chapter.