I've been poking around the SharePoint database structure to try and
figure out how to properly change the display names listed for a
particular user. I've figured out how to make the change to the
display name in the upper right-hand corner by modifying the tp_Title
column associated with a particular user name in the UserInfo table.

However, I also want to change the display name that is shown in
"Created By" and "Modified By" columns in lists - for instance, due to
some account changes, my account currently is shown under three
separate display names - "Peter Ellis", "Person", and "P. Ellis". I
want to change all of those to read "Peter Ellis" for consistency.
The closest I've gotten to identifying where this data might be stored
is the tp_Author and tp_Editor columns in the AllUserData table, but I
can't figure out where that information is being pulled from.

Anyone know the SharePoint databases better than I do and can point me
to the proper table to modify for this?