Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Guest Editorial: Improving Northwind


Guest Editorial: Improving Northwind

Author
Message
Phil Factor
Phil Factor
SSC Eights!
SSC Eights! (961 reputation)SSC Eights! (961 reputation)SSC Eights! (961 reputation)SSC Eights! (961 reputation)SSC Eights! (961 reputation)SSC Eights! (961 reputation)SSC Eights! (961 reputation)SSC Eights! (961 reputation)

Group: General Forum Members
Points: 961 Visits: 2953
Comments posted to this topic are about the item Guest Editorial: Improving Northwind


Best wishes,

Phil Factor
Simple Talk
Helen Trim-836693
Helen Trim-836693
SSC Veteran
SSC Veteran (284 reputation)SSC Veteran (284 reputation)SSC Veteran (284 reputation)SSC Veteran (284 reputation)SSC Veteran (284 reputation)SSC Veteran (284 reputation)SSC Veteran (284 reputation)SSC Veteran (284 reputation)

Group: General Forum Members
Points: 284 Visits: 70
I used to be a software trainer specialising in Access from beginner to VBA, so I have a great fondness for Northwind - Nancy Davolio, Alfreds Futterkiste, Laughing Lumberjack Lager.....

I especially liked the version that shipped with Access 95, where the photo of Nancy had been replaced but they had left her date of birth the same, so it appeared that the attractive young blonde lady was in her 50s.

As you say, it is an excellent way to learn about databases and part of it's strength is it's simplicity. I vote for leaving it as it is.
archie flockhart
archie flockhart
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1263 Visits: 1150
A generation of learners, since 1997


Longer than that, surely. I think it was available in Access 2.0 ( around 1993 ?), maybe earlier.

I wonder where Nancy Davolio is now ?
Open Minded
Open Minded
SSC-Enthusiastic
SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)

Group: General Forum Members
Points: 190 Visits: 567
you should have seen the visual foxpro version of it. it was quite a complex OOP example, which i could take off a few pieces at a time to use.

i am quite proud to have my db lineage start from DBaseIII+ and VFP. later on, i didn't have much problem about taking care of indexes, relational keys and the need for normalization of tables to reduce disk usage.

even at this time when there are affordable, 400GB servers, a well-normalized database still provides better speed. before anyone debates on normalization, i agree to all your points provided performance is better.
Ray Hastie
Ray Hastie
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1268 Visits: 142
Let's have fun and try to improve it.

Count me in.
blandry
blandry
Old Hand
Old Hand (371 reputation)Old Hand (371 reputation)Old Hand (371 reputation)Old Hand (371 reputation)Old Hand (371 reputation)Old Hand (371 reputation)Old Hand (371 reputation)Old Hand (371 reputation)

Group: General Forum Members
Points: 371 Visits: 723
Geospatial data? Taxonomic data? Temporal data? Geez Phil, isn't the Northwind database supposed to be a learning database used to bring people interested in becoming SQL Gurus up through the ranks? When you ask the question; "Can't we as a community, do better?" - are you asking this only for the Obi Wan Kenobis of SQL Server? Or does the "community" also include the people who just getting wet behind the ears with SQL? Does it include the people just tracking your average mundane business data? After all, thats the greater part of the SQL population - not everyone NEEDS a geospatial record of the widgets their business keeps track of.

In the late 90's I worked for a small company where almost everyone knew a little SQL - enough to run a query and get the answers they needed. Seems over the last 10 years as SQL has become more and more complex, with new often confusing features to newbies, SQL expertise is harder to define and we seem to be approaching a place where only the "few Wizards" will be "in the know". Is this really a good thing?

Maybe what we need are two databases - one with good 'basics' use, like Northwind, and then another with the kind of data that Phil, you are talking about. As an old-timer, at this game for decades, I am of course impressed with SQL these days - but I am also aware that fewer and fewer people are interested in it because of its complexity. Again I ask, is this a good thing?

Well, to be topical... The financial industry just collapsed on the back of complexity and it's confusion that even the people selling the instruments could not decipher. In fact today, we don't even know how big a mess we're in because it will take years to figure out these complex financial inventions that only a very few people even understand. Is THAT a good thing? Nope - and maybe we should all take that as a warning.

KISS - Keep it simple, stupid - its not all that bad an idea, and before anyone starts producing some new demo data, I sure would like them to consider the BIG picture for a change - not just the "boy thats cool" picture. After all, though some companies are doing very cool stuff, most are just trying to keep track of things and do business. We should not lose site of that. Its not a dishonorable thing.

There's no such thing as dumb questions, only poorly thought-out answers...
Steve S.-542474
Steve S.-542474
SSC-Enthusiastic
SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)

Group: General Forum Members
Points: 109 Visits: 70
I think that there is plenty of room in NorthWind for both simple and complex tables. A well designed database should include simple tables as well as complex relationships, data types, etc. When you are learning basic table structure, you don't need to know about stored procedures - but they can still be in the database, waiting patiently for you to get around to them. Viva complexity! - as long as we keep the simple stuff. I would love to have samples available for some of the medium to heavy-duty concepts that SS supports!
mhaskins
mhaskins
SSC-Enthusiastic
SSC-Enthusiastic (107 reputation)SSC-Enthusiastic (107 reputation)SSC-Enthusiastic (107 reputation)SSC-Enthusiastic (107 reputation)SSC-Enthusiastic (107 reputation)SSC-Enthusiastic (107 reputation)SSC-Enthusiastic (107 reputation)SSC-Enthusiastic (107 reputation)

Group: General Forum Members
Points: 107 Visits: 323
Why not still keep it simple with multiple training databases. So, keep Northwind as a general database. Then you can have one simple database that shows how to use analysis services - and it would be built with just SSAS in mind. Then have another one for spatial data, etc. They could still be small, simple and concise - and used for specific training purposes. Why does it have to be one huge database that covers everything?

Mia

I have come to the conclusion that the top man has one principle responsibility: to provide an atmosphere in which creative mavericks can do useful work.
-- David M. Ogilvy
Someguy
Someguy
SSC-Enthusiastic
SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)

Group: General Forum Members
Points: 165 Visits: 579
Improving Northwind is a good idea. However, let's remember that databases are used in a lot of diverse ways. So, let's not make the mistake of thinking that there can be one database that best demonstrates all of the recent developments in db technology and theory. For example, we may need a database for "Voyager Transportation" to show the power of geospatial data.

Having said that, I recall a number of debates on this forum with topics like "why bother with CLR?" (stated in more polite terms) and "why bother with XML in a database" (I think the editorial writer for that one was a little more blatent in his dislike for XML). If Microsoft is going to put the resources into adding features like these and more to SQL Server, perhaps it would behoove them to come up with some examples of how these technologies can shine in a proper setting?

If it's possible to put multiple developments into one database, then great. Let's just be careful as Database "experts" to avoid the mistakes that we always criticize others for doing, such as creating a swiss army knife database that contains a lot of technology, but which doesn't really make any sense in the real world.

___________________________________________________
“Politicians are like diapers. They both need changing regularly and for the same reason.”
GSquared
GSquared
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16331 Visits: 9729
I like the idea of a database that gradually increases in complexity as you progress through various training exercises in it.

Start out with a table of customers, a table of salespeople, a table of products, and a table of orders, and perhaps a many-to-many join between orders and products. Very simple structure, just enough to get an idea of what a relation (table) is, what normal forms mean, and how simple foreign keys work. Something a real business could use as a starting place for replacing a file cabinet of paper order forms. Start out with contact data in the customers table, to illustrate the weaknesses of that violation of normal form, but still make the database human-understandable.

Then, with a script that encompasses the necessary DDL and insert tasks, add in inventory and a running totals problem, maybe add in employee hierarchies, and perhaps a more complex way to track customer contact data, such as a table of addresses with customer ID and address type, separation of address and phone and e-mail, and so on. Lesson covers running totals, adjacency hierarchies, and higher normal forms.

Another script with necessary DDL and DML, and you morph the database to include billing data including encrypted credit card numbers, more employee data including encrypted SSNs (or whatever), more complex database security access including logins and groups. Lesson is on security and encryption.

And so on, one script per set of lessons, with the database getting more and more complex each time. It would be easy enough to build that way, and would progressively increase SQL skill and knowledge. Would be slightly more complex to make sure that no script was dependent on any other script having already been run, unless it is a more advanced lesson specifically building on the prior lesson. E.g.: Security 2 could be dependent on Security 1, but independent of Normal Forms 1.

Does that sound like a good compromise between starting out simple and still being able to get the most complex and advanced subjects in there?

- 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