Web hosted databases
Author
Discussion

parakitaMol.

Original Poster:

11,876 posts

282 months

Wednesday 18th July 2007
quotequote all
This might be better in the business area - not sure??

I’m managing (6 weeks in only) a new product - a large web database with 4 levels of login / accessibility.

It has a number of levels of administration and viewing access.

The function of it is to house, categorise and manage a large amount personal information in the form of a) uploading personal ‘reports’ from an external supplier (which has to match report to user via a unique number) and manually inputted text as well as attaching files such as word and jpg - and it also comprises a number of decision making tools, options, check boxes, choices and external list feeds as well as user note keeping.

I would like to look at making some improvements to the look and feel of the site, simplifying the layout, improving the visual design, navigation and functionality and to do this I would like to benchmark it against some other online databases that manage similar types of data.

I guess I need people who manage/program databases as well as those involved in complex web design that incorporates database functionality.

Database around 100.000 members + 1000 general admins + 10 content management / senior admins.

I am making a recommendation to my CEO that we do some product benchmarking & carry out some basic housekeeping upgrades before I carry out a tranche of new technical developments & marketing activity as I think it's unweildy & over complicated as it stands - and NOT currently a very good user experience – so, I would like to identify some similar web database products to benchmark against before I raise this with him (it's going to change the brand strategy I've just inherited, quite significantly!!).

One of my biggest challenges is a 2 level login which I’d like to change to 1. There are reasons for this (grouped & sub grouped users) but it’s a pain in the ass for the users.

The other is the functionality of the decision making support tools - ie prompted questions with a user input answer/note area.

Any ideas/ links/ suggestion gratefully received.

Thanks for reading.

Anna

Plotloss

67,280 posts

301 months

Wednesday 18th July 2007
quotequote all
Sounds like presentation layer modifications, all very simple as long as you dont want to capture or retrieve data that isnt currently stored. Most complex part will be modifying the user login prodcedure to do away with this 2 layer business.

All sounds like bread and butter work on the face of it.

Engaging an interface specialist will yield better results than saying to a development team 'I want it like that one'

Edited by Plotloss on Wednesday 18th July 11:47

cyberface

12,214 posts

288 months

Wednesday 18th July 2007
quotequote all
If the 2 level login process is designed into the database schema (badly) then moving to a single login may require data model changes - if this is the case then, depending on how the original code was written, much of the database-access code will need to be rewritten.

Regarding exactly what you want done w.r.t. changing 2-level to 1-level, get a data architect to check the existing model and see whether major changes would be required to accommodate your new requirement. You may be able to get away with not changing the DB model but without seeing the model and the user login use cases, I wouldn't be able to comment.

parakitaMol.

Original Poster:

11,876 posts

282 months

Wednesday 18th July 2007
quotequote all
Plotloss said:
Sounds like presentation layer modifications, all very simple as long as you dont want to capture or retrieve data that isnt currently stored. Most complex part will be modifying the user login prodcedure to do away with this 2 layer business.

All sounds like bread and butter work on the face of it.

Engaging an interface specialist will yield better results than saying to a development team 'I want it like that one'

Edited by Plotloss on Wednesday 18th July 11:47
Thanks Plotloss...

I wasn't intending to do a Little Britain on the developers - currently we have one agency who then outsource a Russian technical team - experience huge communication issues with them during the bug testing of new functions. The difficulty is we don't have effective creative input - it's all very basic & NOT user friendly. That is because of the original brief..... it's only been live for 1 year.

It's not really the challenge of changing / improving it that I face - it's getting the internal support to allow me to change it and improve it before we start adding a whole load of new tools - which will result in it being even more unweildy and dull.

I've worked on several web projects in different sectors and always considered my customers/ audience's needs first - whereas I'm having to now consider the sensitivity of making huge amends to someones relatively recent work wink

To do this I need to find similar examples to champion my cause wink


Plotloss

67,280 posts

301 months

Wednesday 18th July 2007
quotequote all
Ahh I see, well in that case Jakob Nielsen will witter on near endlessly about how poor interface design can cost companies vast sums of money.

www.useit.com is a good resource from that angle.

Presumably this software was written with an audience in mind and if that audience arent engaging in the software then the software is worthless and the money dead.

parakitaMol.

Original Poster:

11,876 posts

282 months

Wednesday 18th July 2007
quotequote all
Plotloss said:
Ahh I see, well in that case Jakob Nielsen will witter on near endlessly about how poor interface design can cost companies vast sums of money.

www.useit.com is a good resource from that angle.

Presumably this software was written with an audience in mind and if that audience arent engaging in the software then the software is worthless and the money dead.
Yarp.... that's what I am saying and in an un-Parakitamol way I am trying to be diplomatic.... wink

Too many presumptions made about what the user wants - when in fact its what the org wants to tell the user.... hate hate hate that approach - I have a massive challenge here - can you feel my pain?

Thanks - & any other good websites for me toto look at please add!



Plotloss

67,280 posts

301 months

Wednesday 18th July 2007
quotequote all
Sounds like they modelled the data and the built in the interface to the logical data structure rather than the use case.

Good for development teams and project managers, this approach doesnt even have to invoke the PRINCE2 'its his fault' card but remarkably bad for users.

I feel your pain.

parakitaMol.

Original Poster:

11,876 posts

282 months

Wednesday 18th July 2007
quotequote all
Plotloss said:
Sounds like they modelled the data and the built in the interface to the logical data structure rather than the use case.

Good for development teams and project managers, this approach doesnt even have to invoke the PRINCE2 'its his fault' card but remarkably bad for users.

I feel your pain.
Bang on... everything revolves around a core product component - it's actually the main really exciting/interesting thing we do.

That primary product/report drives the first time user login.

As the Product Manager I want to make the whole experience better and address the horrendous communication, useability and unweildy dryness of what I've adopted....

Sadly an external web review that was carried out could have been done by a child and missed a number of critical flaws... ultimately did not raise the major concerns I have and therefore do not lead my CEO to brief me with an update - instead he wants me to create new tools - like adding an extension onto a house that needs re-wiring & decorating - it still has Avocado bathroom suites!! biggrin

The way I see it is that I need a new Creative + Programming/Database team with a better understanding of how to communicate & perhaps some youth marketing backtground!


parakitaMol.

Original Poster:

11,876 posts

282 months

Wednesday 18th July 2007
quotequote all
I've looked at that link - some good stuff on there but I really need some good examples of how to manage this kind of info in practise.... if you know of any please let me know.

Thanks!
A

Plotloss

67,280 posts

301 months

Wednesday 18th July 2007
quotequote all
When I was in the US we had a team come and sit with a special bit of software that timed mouse clicking and movements to measure the effectiveness of the software and where time was being wasted (it was a system that bought and cut wood in real time from sales generated by the salesmen so was time critical). They sited a camera behind the user and made recommendations about how the interface could be made more user friendly.

No doubt there are similar companies operating in the UK but that, thinking about it, may not address the unmanagability of it from a user perspective.

What I guesss you are facing is a unwillingness to spend more on 'new' software from a top down level so the way forward would perhaps be to prove that an unweildy interface is directly losing the company money. Its then when the shitstorm and finger pointing usually starts.

parakitaMol.

Original Poster:

11,876 posts

282 months

Wednesday 18th July 2007
quotequote all
Plotloss said:
When I was in the US we had a team come and sit with a special bit of software that timed mouse clicking and movements to measure the effectiveness of the software and where time was being wasted (it was a system that bought and cut wood in real time from sales generated by the salesmen so was time critical). They sited a camera behind the user and made recommendations about how the interface could be made more user friendly.

No doubt there are similar companies operating in the UK but that, thinking about it, may not address the unmanagability of it from a user perspective.

What I guesss you are facing is a unwillingness to spend more on 'new' software from a top down level so the way forward would perhaps be to prove that an unweildy interface is directly losing the company money. Its then when the shitstorm and finger pointing usually starts.
Sort of - my product is the key revenue generator so it's critical, but if I can prove anything or make better recommendations then I will get the budget - but I need to show something similar as he has no idea of what else might be possible - he's not a big internet consumer (whore) lol - my previous web responsiblilties have been with big FMCG products and very creative / stylised tools designed to serve a specific group.

This time it's more of a service brand. The timing analysis thing would be good and I can get reports from my admin team *except* that there are many areas where the user is researching information and then capturing it progressively like a log or a journal over a number of years in order to inform decision making in the future - as well as being a complex database! - I've done video focus groups with re brands & packaging & re launch & I'd like to do a similar thing with my users or actually new users so I can capture their undoubted frustrations with the bad titles (not giving clues as to what lies within) etc. That's why I need to unearth good examples of this in practise - really so I can brainstorm - as I say particularly in the Youth market.

smile

Plotloss

67,280 posts

301 months

Wednesday 18th July 2007
quotequote all
A random google reveals:

http://www.otal.umd.edu/guse/metrics.html
http://www.kaushik.net/avinash/2007/04/web-analyti...

And loads more thrown up by the term 'user interface metrics'

One or other may include an example thats broadly synonymous to your product/system.

Bloody developers - I'm well pleased to be out of that game.

Plotloss

67,280 posts

301 months

Wednesday 18th July 2007
quotequote all
Bit more from Mad Jakob about how iterative design is absolutely required in user interfaces to improve usability.

http://www.useit.com/papers/iterative_design/

parakitaMol.

Original Poster:

11,876 posts

282 months

Wednesday 18th July 2007
quotequote all
Thanks - I'm not being a lameass but I wasn't actually sure what to google for, be good if anyone has acually worked on something like this in the past & researched the market.

smile

Plotloss

67,280 posts

301 months

Wednesday 18th July 2007
quotequote all
Podie may be able to help, he studied Ergonomics as I remember.

Usability tuning is not something that is done as a matter of course sadly, its usually a reactive requirement which is why most things you find discuss it from a theoretical rather than practical point of view.

Famous Graham

26,553 posts

256 months

Wednesday 18th July 2007
quotequote all
Yell.com's personalisation stuff used to contain varied information for quite a substantial number of users when I was there (2000-2004). Although the front end's changed a bit, I don't imagine they've changed much of the core functionality since. Might be worth a butchers.

The actual directory data should be ignored though, it's all XML-fed rather than directly database driven.

Edited by Famous Graham on Wednesday 18th July 17:22

parakitaMol.

Original Poster:

11,876 posts

282 months

Wednesday 18th July 2007
quotequote all
Famous Graham said:
Yell.com's personalisation stuff used to contain varied information for quite a substantial number of users when I was there (2000-2004). Although the front end's changed a bit, I don't imagine they've changed much of the core functionality since. Might be worth a butchers.

The actual directory data should be ignored though, it's all XML-fed rather than directly database driven.

Edited by Famous Graham on Wednesday 18th July 17:22
Thanks but I don't think it's really stuctured like Yell - IE the vast amount of user contribution, personalised webspace and decision making tools as well as housing reports & contributions & advice from others commenting on user 1's information. Thanks though!

Famous Graham

26,553 posts

256 months

Thursday 19th July 2007
quotequote all
parakitaMol. said:
Famous Graham said:
Yell.com's personalisation stuff used to contain varied information for quite a substantial number of users when I was there (2000-2004). Although the front end's changed a bit, I don't imagine they've changed much of the core functionality since. Might be worth a butchers.

The actual directory data should be ignored though, it's all XML-fed rather than directly database driven.

Edited by Famous Graham on Wednesday 18th July 17:22
Thanks but I don't think it's really stuctured like Yell - IE the vast amount of user contribution, personalised webspace and decision making tools as well as housing reports & contributions & advice from others commenting on user 1's information. Thanks though!
There is but it's further "in" - now that I think about it though, you might have to be an advertiser to have access to that (you can customise your directory entry - despite the actual directory content being xml at the front end, the customisations are held in an Oracle db - create your business's website, submit it for critique to their designers etc etc).

Anyway, how about Facebook? That's massively inter-relational but intuitive with it.

parakitaMol.

Original Poster:

11,876 posts

282 months

Thursday 19th July 2007
quotequote all
Famous Graham said:
Anyway, how about Facebook? That's massively inter-relational but intuitive with it.
Thanks - I know all the obvious sites where people enter their profiles - I needed something more specific and similar to what I am working with.

Cheers though