Category: Commerce Data Model

0

VARCHAR: Friend or Foe

I read an article from Craig Mullins on “Working with variable data“. The rest of this post is going to assume you’ve read it, so click through and then come back. I’ve seen performance issues caused by VARCHAR before, and Craig makes some interesting points. VARCHARs are actually one of the big reasons to Reorg frequently. His post is geared...

0

Categories of tables in E-commerce databases

Whether you’re using WebSphere Commerce or some other vended application or using a custom application, there are four basic categories that your tables will fall into. Keep in mind that there WILL be relationships between tables in different categories, but it’s good to know the category of the table for a number of reasons. There could also be hundreds of...

0

Naming Standards in WebSphere Commerce Databases

So this is a good page in the Commerce info center. It sets forth naming standards for custom objects in WebSphere Commerce databases. I know for a fact that other naming standards work in daily operation. I wonder if using these naming standards makes upgrades go more smoothly (or like some Commerce features that is an intended future use of...

0

The WebSphere Commerce Data Model

So I have several posts already on this topic. It’s a big topic, and I imagine I’ll write many more posts on it. But I thought something kind of general would be good. I’ve talked about 10 Commerce Tables You Should Be Familiar With, and about making alterations to Commerce objects, and about general observations about Commerce databases. The main...

0

The basics of Index Design for DB2

The keyword in the title of this post is “basics”. I spend some time training SQL Server or Oracle DBAs on DB2, and so this is the answer on the most basic level to how to identify indexes to add. There are certainly greater experts on this topic than me, so I don’t claim to have a comprehensive view on...

0

Commerce Database Facts

So these are miscellaneous things that I sometimes note about Commerce databases. Though some of the details here may reference DB2, the basic facts are RDBMS-independent, so they would be true for Oracle Commerce databases as well as DB2 ones. Most tables have generated primary keys Commerce tends to use sequential numbers for most primary keys, or as a component...

1

Altering database objects in Commerce databases

Like many vended applications, Commerce creates the whole schema of it’s database and this is largely something you don’t mess with. There are, however, some changes that developers or administrators may make. My suggestion is that if you don’t know if a particular modification is supported by Commerce, you call IBM support and ask them. Then if you end up...

2

Mass Cleanup of Guest Users

By special request, I’m going to share some details on how to do a one-time offline clean up of guest users. PLEASE NOTE: Following are suggestions only – it is critical to thoroughly test this before doing  this in production. This is one of the most tested and still most failed changes I do. First off, check out the entry on...

23

10 Commerce Tables you should be familiar with

UPDATE: An updated version of this post is available – Updated: 10 WebSphere Commerce Tables You Should Be Familiar With   So there are 800+ tables in the typical Commerce database – you’re never going to know them all. And getting a start on understanding the data model – even in the more limited way needed when you’re playing primarily...