SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Architecture Principles


Architecture Principles

Author
Message
Steve Jones
Steve Jones
SSC Guru
SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)

Group: Administrators
Points: 139888 Visits: 19413
Comments posted to this topic are about the item Architecture Principles

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Carlos Bossy
Carlos Bossy
SSC Journeyman
SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)

Group: General Forum Members
Points: 91 Visits: 1583
You make some interesting points Steve. As a consultant I take those architecture principles to my clients, and often it's the only way to maintain control of a big BI project. But there's always a need for vision and creativity. Those who only go by the book tend to produce a lesser result, even if it's a really good book. I would say that a consultant or employee who is 25% visionary but abides by a strong methodology 75% of the time has an ideal approach for the type of work we do.

LinkedIn - http://www.linkedin.com/in/carlosbossy
Blog - http://www.carlosbossy.com
Follow me - @carlosbossy
Andy Leonard
Andy Leonard
SSCrazy
SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)

Group: General Forum Members
Points: 2253 Visits: 1101
Ooooo - Principle-Based Architecture and Values-Based Design... have you been reading my unpublished posts again? ;-)

Great editorial Steve - again!

:{> Andy

Andy Leonard
Data Philosopher, Enterprise Data & Analytics
Steve Jones
Steve Jones
SSC Guru
SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)

Group: Administrators
Points: 139888 Visits: 19413
Thanks, and you two are probably two of those "successful" people because of your principles.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Bob Lee
Bob Lee
SSC Veteran
SSC Veteran (259 reputation)SSC Veteran (259 reputation)SSC Veteran (259 reputation)SSC Veteran (259 reputation)SSC Veteran (259 reputation)SSC Veteran (259 reputation)SSC Veteran (259 reputation)SSC Veteran (259 reputation)

Group: General Forum Members
Points: 259 Visits: 356
Steve,

I don't often find time to post but I noticed you used Wright's falling water as your graphic for today's post. There are two great analogies that your image invites.

1. Wright was a minimalist, or the functionality of the tool or the space was the least required to accomplish the task. SSMS would not be a "Usonian" tool. Each room or piece of furniture that he designed had and met a specific purpose and nothing more.

2. The home "Falling Water" sprung multiple leaks because it was not funded or maintained after the family moved out. As a location its beauty began to diminish the day it became a museum. The deterioration took time but it was constant.
Falling Water has recently been repaired and reworked to bring it to modern standards and here is the basis of my analogy. Every tool that exists today can be outdated tomorrow. It is by consistent and diligent maintenance of databases and the tools associated with them that we avoid costly repairs later. If we ever get to the point where we have delivered the database product and move on without ensuring constant maintenance it will deteriorate into obsolescence. If a consultant or architect doesn’t architect the long term care and feeding of the product they are, in my opinion, more of a slash and burn architect.
Falling Water is a great tribute to Frank Lloyd Wright in Western PA but it’s also a great analogy for building a super product and handing it off to a customer who is enamored with the architect but not cognizant of the requirements to maintain the product.
Sustainability isn’t just a requirement for global energy products. It should be part and parcel of everything we do.
John M Dennis
John M Dennis
Valued Member
Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)

Group: General Forum Members
Points: 60 Visits: 432
Love the analogies Bob.
So very true regarding your second analogy. Not that I could find it in my heart to tear down a Wright building--that is another option a business is sometimes very hesitant to do. When it costs more to maintain, just let go of the past and rebuild it to meet today's needs.
Steve Jones
Steve Jones
SSC Guru
SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)

Group: Administrators
Points: 139888 Visits: 19413
I had the chance to tour Falling Water in 98, and heard about a number of the issues that came about over time. It is an amazing structure and this topic made me think about that piece and about how Wright designed things.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Miles Neale
Miles Neale
SSCarpal Tunnel
SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)

Group: General Forum Members
Points: 4184 Visits: 1695
Steve,

Here we have as team of architects who review all proposals and new system development project proposals. This review is for a series of areas from data, data integrity, application security, conformity to standards, use of enterprise components and more.

This review is done as early as possible and in a way to not kill creativity, but to insure that those creative objects are able to fit into the architecture and direction of the business.

It has been going on for years and is working well.

Good article, and as usual we all out here appreciate your work!

M.

Not all gray hairs are Dinosaurs!
Vivien Xing
Vivien Xing
Hall of Fame
Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)

Group: General Forum Members
Points: 3532 Visits: 2204
Steve, you always brings us great editorials. An excellent resource for knowledge, ideas and trends.

I am your loyal reader and your editorials make me stay with SSC. Keep posting.
GSquared
GSquared
SSC Guru
SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)

Group: General Forum Members
Points: 54729 Visits: 9730
I can't say that I have well-articulated architectural principles, but I do have policies that I follow. I just haven't taken the time to write very many of them down. Should probably do so.

My key principle is simply, "don't build something I'll be stuck with for the rest of eternity". Lots of implications and corollaries to that one. First corollary is, "don't build something I won't understand a year from now".

Plenty of other rules. Just not articulated.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search