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 completely 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)
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 .