Web hosted databases
Discussion
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
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
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'
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
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.
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.
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'
Thanks Plotloss...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
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

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

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.
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.
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.... 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.

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!
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.
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.
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.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.
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!!

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!
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.
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.
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. 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.
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.

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.
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.
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/
http://www.useit.com/papers/iterative_design/
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.
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
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.
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!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. 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.
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!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
Anyway, how about Facebook? That's massively inter-relational but intuitive with it.
Gassing Station | Computers, Gadgets & Stuff | Top of Page | What's New | My Stuff


