Mind Tricks for Business - Atomic Data Model makes Search Engine Dominance Possible...

March 30, 2010 19:01 by NielsenData

Atomic Data makes search engine dominance possible

Online retail is not the same as brick and mortar retail.  When a brick and mortar store launches online they fall into this biggest trap.  Take an apparel shop… when you first walk in you find a men’s department and a ladies department.  The store is physically trying to demographically segment you.

If you create a data model that matches this, you will end up with the first <xml> node being <gender> which is a highly limiting path to follow for a search engine even though it may make the most sense for a human being.  You would then add data for teams, sports, colors, sizes, variants, materials of manufacture, and many other “parameters” for this data.  To avoid 3rd normal database limitation, you would start to peel this data out into separate tables… one for colors… one for teams…one for sports.  Then you would need to create many-to-many crosslink tables.  Over time, your table count just gets larger and larger as new needs arise.

The Root Object Classification

There is certain data that “hangs” off each sub-classification.  In this example the Item class stores who the manufacturer is (because most items have manufacturers).  The Apparel class contains the style information (because style is global to all apparel objects), whereas the Shirt class contains collar styles, sleeve variants, etc.

By localizing this information to class levels, once I define a “field” for the Apparel class, all future objects that inherit from that class will inherit that field.  Any objects that do not inherit from the Apparel class will not have the field at all.

Note how different this is from a traditional 3rd normal representation of data where we would have fields like “color1” and “color2” and “color3” simply to leave enough fields available just in case we might need them for a particular product application.

Maximum Flexibility for Customer Paths

Now that our data is structured with infinite flexibility while still retaining a core hierarchy (for default navigation purposes), when a customer walks into our store, we can simply ask Google “how they sent them” to us… and what keywords they used.  Now when the customer enters our “store” we can toss all of the inventory up into the air and literally rebuild our store to match the words they used in the order they used them.  Now they can enter as “ladies yellow tank top” and we structure our product data in terms of gender first, color next and product class third… but we also can welcome customers that ask for “white womens Nike shirt” which we do by scanning for aliases of class nodes, parent classes, and other permutations of the item for maximum comfort to the customer and higher conversion rates on sales.

Know a business that would benefit from our whitepaper on how Atomic Data Modeling can make search engine optimization possible?  Download it now:

02-Atomic-Data-Enables-Search-Engine-Dominance-by-FUZION.pdf (369.99 kb)


Currently rated 5.0 by 1 people

  • Currently 5/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Jedi Mind Tricks for Business - "Luke... I am your Father" - SQL Recursion and Hierarchical Data Models

January 22, 2010 21:53 by NielsenData

Covering topics from recursion in table valued functions, hierarchical data models, and identical node naming in XML hierarchies to fifth normal notation in data structures, CLR Stored Procedures, and many more topics specific to SQL Server 2008 and XML with C#.net programming, this lecture continues the popular Jedi Mind Tricks for Business series by Jared Nielsen at the South Florida Code Camp at the following location:

South Florida Code Camp 2010 - http://www.fladotnet.com/codecamp 

Devry University
2300 SW 145th Avenue
Miramar, FL 33027


View Larger Map

Jared Nielsen is an industry veteran with several decades of experience in sports marketing venues, business to business (B2B) commerce projects, and business to consumer (B2C) e-commerce and content management systems. He has been the lead software developer for the ATP Tour (Men’s Professional Tennis and Women’s Professional Tennis), Director of Business Intelligence for Football Fanatics (TeamFanShop), technical partner to Cook Marketing and Communications (for the Jaguars and Falcons contract), and now invests in online ventures such as Sports Mania (4 brick and mortar retail store locations), Team Sports Fan (http://www.teamsportsfan.com/), and other activities. His high profile projects include large projects for Yahoo! Sports, Interline Brands, and Big O Tires. He is a frequent lecturer and is always open to seminars and speaking engagements.

Call me today!
http://www.fuzion.org/
904-638-2455


Currently rated 5.0 by 1 people

  • Currently 5/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

West Palm Beach .Net User Group

September 2, 2009 15:42 by NielsenData

iNeta .Net User Group AssociationI'm please to be speaking at the .Net user group in West Palm, my old stomping ground!  Many thanks to Scott Klein, noted .Net author and coder for having me down to the beach to spend some time with the great folks down there.  I will be giving a lecture on the Atomic Data Model, the X-Y-Z method of site expansion, and an in-depth analysis of one of their website projects live while we discuss it.

The event will be held at the following address at 6:30 for pizza and 7:30 for the lecture:

1750 North Florida Mango
Suites 302 & 303
West Palm Beach, Fl 33409
561-840-8080

Get Directions

For more information on the Atomic Data Model, please see my blog entries about that at:  Atomic Data Modeling - Part 1


Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Atomic Data Modeling and SEO Speech in Miramar Florida

June 24, 2009 19:53 by NielsenData

I'm pleased to be speaking to the Miramar group of the Florida Dot Net group at www.FlaDotNet.com.  You can register for this event at the following website:  Click here to register.  I will be discussing how proper search engine capabilities start at the database level using atomic data modeling practices.  The samples of the atomic data model will include how to layer in object inheritance at the SQL Server level, utilizing some new features in SQL Server 2008 including the intrinsic Hierarcy data type and a nice overview of search engine techniques that can benefit from a highly optimized and atomic database.  I hope to see you there!

You can get a head start by reading my blog series on the topic at:

www.NielsenData.com - Atomic Data - Best Business Practices for Product Catalog Data

There are other resources that ascribe to the Atomic Data Modeling concept which you can find at:

Zimbio.com - The Atomic Data Warehouse

Wikipedia.org - Data Warehousing and the use of Atomic Data within the Data Mart

Other announcements of this event include:


Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Mark A. Trieb, FSA, MAAA, EA, MIAA

October 29, 2008 07:48 by NielsenData

Mark A.Trieb HedCutI worked with Mark Trieb at the beginning of my career, as I was fresh out of school and full of spit and vinegar.  He was a young executive, with newly found exponential success as one of the leading principals of a retirement planning consulting organization.  His hard-charging business style drove significant growth for his actuarial offices in Dallas and subsequently Minneapolis and Salt Lake City.  Quick to adapt to software technology (this was the 80's folks), he was a visionary in his day in the realm of financial software applications and the efficiencies that he could gain from them.  This innovation drove Milliman & Robertson to become a prime merger candidate with their European sister company, Bacon & Woodrow whose merger formed the Woodrow Milliman juggernaut.  Mark is still engaged with the evolved company Milliman, Inc. which continues business to this day.

This fertile entrepreneurial ground was where I found myself at the beginning of my career path and I soaked it up with reckless abandon.  Mark taught me some critical principles like hard work, long hours, and the insatiable drive to improve, streamline, and dominate whatever project had to be done.  The work was difficult and I was forced to learn new things every day, but I quickly adapted and adopted his style of business and to this day I believe it has formed me into the man that I am today.

I worked with Mark for over eight years, including a generous sabbatical where I served a two year mission and then returned.  Mark allowed me the opportunity to grow into the rich technology sector including database development, office automation, and data-integrated forms processing systems for 5500-C forms packages.

I will always remember his precision, his driven nature, his narrow focus, and his thirst for not only a good solution, but the best solution.  That innate logic has remained with me for all of these years and I thank him for that influence.


Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5