Patterns of Enterprise Application Architecture by Martin Fowler is one the most famous book about the patterns and software architecture. I've read this book and it's still one the best source for me when I'm going to choose the best patterns and architecture for my solutions. It's a book for designing the multi-tiered object-oriented platforms, such as Java and Microsoft Dot Net. It's too important to design your application based on standard architectures and patterns.
If you want to be a real software architect I recommend to complete this book. each section in this book contains a detailed discussion of trade-offs and pitfalls and provides a consistent vocabulary and visual notation to describe large-scale integration solutions across many implementation technologies. The patterns in the book are technology-agnostic and come to life with examples implemented in different messaging technologies, such as SOAP, JMS, MSMQ, .NET, TIBCO and other EAI Tools.
The book is available to purchase here.
You can see the books short summary below (more information)
Domain Logic Patterns: Transaction Script, Domain Mode Table Module, Service Layer.
Data Source Architectural Patterns: Table Data Gateway, Row Data Gateway, Active Record, Data Mapper.
Object-Relational Behavioral Patterns: Unit of Work, Identity Map, Lazy Load
Object-Relational Structural Patterns: Identity Field, Foreign Key Mapping, Association Table Mapping, Dependent Mapping, Embedded Value, Serialized LOB, Single Table Inheritance, Class Table Inheritance, Concrete Table Inheritance, Inheritance Mappers.
Object-Relational Metadata Mapping Patterns: Metadata Mapping, Query Object, Repository.
Web Presentation Patterns: Model View Controller, Page Controller, Front Controller, Template View, Transform View, Two-Step View, Application Controller.
Distribution Patterns: Remote Facade, Data Transfer Object
Offline Concurrency Patterns: Optimistic Offline Lock, Pessimistic Offline Lock, Coarse Grained Lock, Implicit Lock.
Session State Patterns: Client Session State, Server Session State,Database Session State.
Base Patterns: Gateway, Mapper, Layer Supertype, Separated Interface, Registry, Value Object, Money, Special Case,Plugin, Service Stub , Record Set