Slashdot Mirror


Baltimore Police Department Is Still Using Lotus Notes (baltimoresun.com)

swm writes: The Baltimore police department is still using an antiquated (1996) case-management system based on Lotus notes. A recent technology assessment found "millions of records and roughly 150 databases built into the system, each designed to address different unit and personnel needs," reports Baltimore Sun. The report found that the "siloed nature of the Lotus Notes databases made it difficult for officers to match, verify or search for information. [...] Various systems may also contain 'conflicting information' about the same case, or may not reflect the most complete information."

"At the same time, detectives continue compiling and using paper case folders," the report stated. "Depending on the unit and the detective, the appropriate Lotus Notes database and/or hard copy case folder system may or may not be up-to-date, and the systems may or may not match." The consultant who is paid to maintain the system says that it is "working wonderfully for the police."
Despite these concerns that the assessment addressed, Baltimore's spending panel agreed to pay $176,800 to the consultant to help maintain the outdated system. The police department's chief spokesperson said in a statement Thursday that the agency will be moving away from Lotus Notes in the future. "However, until such time, we must manage and maintain the product that we currently use which is Lotus Notes," he said.

26 of 138 comments (clear)

  1. Anyone report a robbery by jsepeta · · Score: 4, Funny

    suspect calls himself a "consultant"

    --
    Remember kids, if you're not paying for the service, YOU ARE THE PRODUCT THAT IS BEING SOLD.
    1. Re:Anyone report a robbery by jellomizer · · Score: 3, Interesting

      $178k for a consultant is a good deal. It would be difficult to hire a full time employee at that amount (Factoring in benefits).
      It is probably the Union Employees making a fuss about ungodly consulting fees. But in truth Having this Legacy System running with a consultant keeping it running. Is probably the most financially prudent course of action that the department can do.

      Replacement systems will cost millions to replace and support contracts will be much more then $178k a year. If they are going to replace a system, if they want to be financial prudent they should join up with other departments in that state and upgrade all of them. Because for most software the price would scale better with higher number of people using it.

      Being that most programs are using under 10% of the system resources at the time, a single system can probably handle 3 or 4 times the load that are actually being used. So if the replacement system was bought and shared across multible departments they can split a lot of the costs and make it more financially responsible.

      However at this moment, I wouldn't want my tax money going to an upgrade that will not offer any real benefit or cost savings. Just because what they have is on old software.

      --
      If something is so important that you feel the need to post it on the internet... It probably isn't that important.
  2. Lotus Notes is amazing. by Anonymous Coward · · Score: 5, Insightful

    After working 20 years in IT, I can honestly say there is nothing to compare to Lotus Notes and its simplistic and powerful way it works. This is why its still there. The only reason it is not currently top dog, is because exchange came along in the late 90s and outlook was better than the Lotus Mail client. Anyone trying to tell me sharepoint is good has rocks in their head, its bloated and requires way to much training and development to make it anywhere near an out of the box Lotus Notes install.

    1. Re: Lotus Notes is amazing. by DaMattster · · Score: 2

      I loved Lotus Notes and Domino. Managing encryption keys was a snap and sending secure email was easy.

    2. Re:Lotus Notes is amazing. by Anonymous Coward · · Score: 4, Informative

      "outlook was better than the Lotus Mail client"
      ANYTHING would be better than the Lotus mail client. Kids shooting wadded-up paper notes as spitwads through straws would be better. I was forced to use Lotus Notes for about a year and still shudder. The UI was obtuse. It was feature-poor and slow, painfully slow, to deliver messages. It was unstable. It was bad in every way that software can be bad. We ended up using the telephone a lot more than a modern software operation should, because e-mail was so bad. Whoever programmed it should be shot.

      I never used Notes for anything other than e-mail, but that experience would make me run screaming from the rest of it. It's very hard to square your "nothing to compare" observation with my experience.

    3. Re:Lotus Notes is amazing. by Nethead · · Score: 5, Interesting

      I'm running 30,000 users all over the globe on IBM Domino (it hasn't been Lotus for two decades.) It is interesting but I must say there are some really cool things about it. Think of it this way, Exchange is a mail program that tries to be a database. Domino is a database program that tries to be a mail server. With Domino, email is just one way to use it. It's data replication between hosts over the WAN is like nothing Exchange could do. Domino was designed in the 90s when intermittent dial-up between hosts was the common solution. I have about 100 servers sitting in Tunisia, Brazil, Mexico, South Africa, all the EU, US and even Canada. They all talk together and share the same address book and master config.

      So yes, now that we have been bought by another larger French aerospace company, we will be moving to some form of Exchange. It will still take years to get out from under all the applications so I'm sure I'm good until retirement in about 10 years.

      But don't knock Domino until you have really looked at it. Did you know it runs on Unix and Linux? IBM supports it on the AS4000 so do you want to talk about uptime?

      --
      -- I have a private email server in my basement.
    4. Re:Lotus Notes is amazing. by Tablizer · · Score: 2

      I used Notes at a place I consulted at in the late 90's, and I thought it was pretty good, at least as a concept, for it kept losing messages for some reason. Perhaps it was configured wrong.

      I even once started an OSS project to emulate the parts of it I liked. But I got distracted and never finished.

      For example, you could pose a question, and list all pending questions, and sort or filter them by project, application, entity, etc. based on user-defined categories or lists. Most places use email or SharePoint instead, and they both suck at it. Sure, you could build a typical CRUD application to do the same, but you'd be hard-wiring in the structure more or less. Notes is more organic. It's sort of Wiki meets SharePoint meets blog meets email.

    5. Re: Lotus Notes is amazing. by Macfox · · Score: 2

      My God... The time wasted dealing with .id files. What do you mean I can't just reset my password? What is this unintuitive PoS?

      Directory (NDS/AD) integration? Huh? It's just a fad, we can ignore that...

      When it comes to technology nightmares, LN gets filed right with BB and BES. Security at the expense of everything else.

      --
      Area51 - We are watching...
  3. sounds like a bargain by albeit+unknown · · Score: 4, Insightful

    $176k to keep it working? It will cost them $176 Million to replace it, resulting a similar level of hassles, errors, and inconsistencies as before. Just different ones.

    Most or all of the problems in the article have no relationship to the fact that the software helping to support the bureaucracy is Notes. The detectives use of paper case files won't magically go away just because the software is replaced. Also, just perhaps, they Know What They're Doing, and paper has valuable or required chain-of-evidence advantages?

    Isn't almost everything else of its ilk "decades old" (never mind still in active development like Notes)

    1. Re:sounds like a bargain by drinkypoo · · Score: 2, Interesting

      $176k to keep it working?

      I think you mean "running". It's clearly not working if they are resorting to paper because the system is inadequate.

      It will cost them $176 Million to replace it, resulting a similar level of hassles, errors, and inconsistencies as before. Just different ones.

      Only because they will use a corrupt process to select a vendor for the replacement. You could literally do the kind of crap they're doing with notes now with a PHP CMS.

      Also, just perhaps, they Know What They're Doing, and paper has valuable or required chain-of-evidence advantages?

      If they knew what they were doing, they never would have used Notes. It would have made more sense to use AS/400. (I still can't remember which "Series" is which by letter.) But just their bad luck, they got the notes salesman instead of the minicomputer salesman.

      --
      "You're right," Fisheye says. "I should have set it on 'whip' or 'chop.'"
    2. Re:sounds like a bargain by Bert64 · · Score: 2

      People resort to paper because it's what they're used to, not necessarily because an electronic system is inadequate.
      That's not to say it isnt inadequate, just that fitness for its intended purpose often has very little effect on wether a system is actually deployed or used.

      --
      http://spamdecoy.net - free throwaway anonymous email - avoid spam!
  4. Re: Ewwww... by Anonymous Coward · · Score: 2, Interesting

    Painful because of Microsoft.

    Share point sucks. See, now thatâ(TM)s a technical opinion.

  5. Wait... by Anonymous Coward · · Score: 2, Insightful

    This conclusion makes me think that there are some out there that want to purge anything, people or kit older than 10 years.,,

  6. so what? by murdocj · · Score: 2

    So you guys are all ready for your taxes to go up significantly to rewrite all of the antiquated systems of all the government agencies that you deal with, right?

  7. Re:Ewwww... by 93+Escort+Wagon · · Score: 5, Insightful

    You couldn't pay me enough to manage Lotus Notes. It appears there are ways to migrate Notes apps to MS SharePoint, but you can bet it would be a painful, expensive nightmare.

    Are you referring to the migration itself, or the fact that afterward you’re stuck using Sharepoint?

    --
    #DeleteChrome
  8. Re: Ewwww... by mattyj · · Score: 2

    That is not a technical opinion, that is an undisputed, unqualified, provable fact.

  9. Really? by Alypius · · Score: 3, Funny

    Baltimore still has a police department?

  10. Re: Ewwww... by datavirtue · · Score: 3, Funny

    Microsoft rewrote Sharepoint some time ago. The modern version is viable for delivering and hosting applications and workflows. The Sharepoint name is mired in the past....which was justified.

    --
    I object to power without constructive purpose. --Spock
  11. Re: Ewwww... by JaredOfEuropa · · Score: 3, Interesting

    “Viable”. Not great, not even decent, but viable. I don’t think I have ever seen Sharepoint improve upon software it replaced, in terms of features, usability, reliability, maintenance or administration. I’ve been involved in a few migrations where we had to do a token product selection, so we simply drew up some functional requirements along the lines of “let’s look at what we have now, and write down what of that functionality is essential”. Sharepoint wasn’t even able to meet all of even the most basic requirements... but was selected every time because it was Microsoft and “we already have it for other stuff”. It’s not even cheaper than what it replaced. Users and administrators aren’t using it properly. The workflow stuff is mildly useful in small and medium companies, but other than that I’d be hard pressed to come up with something good to say about it. Even the newer version. The architecture is still the stuff of nightmares.

    --
    If construction was anything like programming, an incorrectly fitted lock would bring down the entire building...
  12. Is this a Microsoft Ad ? by martiniturbide · · Score: 5, Interesting

    Lotus Domino / Notes works fine and is supported by IBM.
    1) Latest version is Domino 9.0.1 (server) and Notes 9.01 (Client) released on 2016 . Now you can use Domino apps on cloud and IBM Collaboration cloud for mail. There is no end of support for Lotus Notes 9.0 listed yet (https://www-01.ibm.com/software/support/lifecycleapp)
    2) Notes 9.0.1 Fixpack 10IF3 was released on 2018/05/21
    3) The article does not says which version of Lotus Notes are they using.
    4) If you don't like using Lotus Notes, the same mail and nsf applications can be turned into web applications.
    5) Domino applications are very easy to create and maintain.
    6) Lotus Notes was designed by Ray Ozzie. Even Bill Gates said he was one the greatest software architects.
    7) Microsoft has done a great job thrashing everybody that uses Lotus Notes, just like they did with OS/2 users.

    1. Re:Is this a Microsoft Ad ? by thegarbz · · Score: 2

      3) The article does not says which version of Lotus Notes are they using.

      Sure they do. It says it right there in the first line of the summary: "The Baltimore police department". Given police funding in America this directly translates to Lotus Notes 2 running on a Netware network.

  13. Re:Ewwww... by jezwel · · Score: 3, Interesting

    You couldn't pay me enough to manage Lotus Notes.

    I'd take USD$176,800 annually, same as this person.

    We still have some Notes databases in use, though they're slowly being replaced. These systems typically have a bunch of group/user based security, workflow and notifications, so getting all that right can be a long process - all the simple stuff was done years ago.

    I can totally see a case management system being band-aided across the decades as an entirely new system might still be more than the cost of maintenance and licensing.

  14. Re:Ewwww... by jwhyche · · Score: 2

    My first encounter with Lotus notes went something like this, "what a piece of shit." You could pay me to manage it, but I doubt you could afford me.

    --
    I read at +2. If your post doesn't reach that level I will not see or respond to it.
  15. Re:Them And Every Other IBM-Soulsucked Company by Macfox · · Score: 2

    Don't forget Groove. The bastard child of Lotus Notes adopted by MS then euthanized.

    --
    Area51 - We are watching...
  16. Lotus Notes gets a bad rep. by kbg · · Score: 5, Interesting

    I worked with Lotus Notes for many years and although its far from perfect it was actually maybe 30 years ahead of it's time. Most of the negative comes from people who don't understand what Lotus Notes is and/or think that the included email client is Lotus Notes. Which I agree was not very good and could have been improved drastically.

    Lotus Notes is basically just a non relational database with a lot of build in core support for access control and replication. People are using NoSQL, Mongo and other non relational databasee and think that this is something new. This has been in Lotus Notes from the start. The Lotus Notes client software is basically just like the web browser is today with the app running completely in the browser.

    What is great about Lotus Notes are the included features out of the box. It's basiaclly just a rapid application development software for data. The offline synchronizing and replication of data is amazing really. Because although you can implement replication in any system the replication system is built in and can handle replication for everything. So any system you build, automatically has data replication. The security is also built in with fine grained control to individual fields built in.

    I could build for example a complete working CRM system in just one hour that had offline editing, replication and synchronization of data, fine grained access control, both fat client and web client enabled with zero code changes, Workflow integration, email integration, and much more. And this could be done without writing little or no code.

  17. Re:tf by Dr.+Evil · · Score: 3, Informative

    An ancient groupware product maintained and sold by IBM.

    It's built on replicating proprietary non-SQL databases, a PKI system for access control, encryption and digital signatures. The servers can translate the content into web pages, or fat clients can access the system using the native format.

    It's honestly an amazing bit of software which gets a bad rep due to a clunky UI, predating open standards on many of these things and a very fat, fat client.

    IBM's purchase of Lotus and subsequent poor marketing has kept it from competing with MS for decades now. It's been relegated to government use and IBM use. The concept is due for a re-invention, but cloud services like Google Docs and o365 provide the most important bits of functionality and are closest to replacing its capabilities.

    IBM is very good at supporting things for a LONG time, so I don't think it's going to disappear very soon.