integration and implementation of technology-focused business solutions

April 2015

LSG is keeping Oklahoma safe

April 21st, 2015

Handcuffs on keyboardData is key to preventing criminal activity. Whether it's a background check before hiring teachers that spend all day with children, or looking up someone's information when they get pulled over, early detection relies on data.

We were called in to work on a project with the Oklahoma State Bureau of Investigation (OSBI). They maintain a database that, in layman's terms, is the master database of all bad people. And the system was old enough that it needed to be modernized.

CCH is the Computerized Criminal History System. By far, it's the most proactive crime prevention system, as well as crime data collection system.

The system is used in Oklahoma when people apply for a handgun license, when they apply for any government or public sector job, when they try to rent an apartment, and in many other situations as well. The system is also utilized when other states request data from Oklahoma. So its impact is huge.

The old system was over twenty years old. It was very complex, with a number of different interfaces. As is the case with many systems that are that old and large, it had grown to the point where there were many band-aids and tourniquets in place for issues that really needed to be fixed the correct way.

The system was cumbersome, slow, and subject to many issues. It wasn't made to handle the stress being placed on it, and was on its last leg.

In preparation for the modernization, the internal team spent over two years researching, documenting, and generally gaining a better understanding of the existing system. The team then put together a prototype so they would know what they needed from their provider.

At that point, our team here at LSG Solutions was brought into the project.

The new system we developed has many advantages. It's built on a modern platform that's far better. It has an Oracle backend, and is easy to integrate with web services and Java applications, utilizing a system that's easily skinned and portable.

There's also a huge improvement in performance. It is typically seven to eight times faster than the old system. This obviously reduces the overall wait time for background checks.

And even though there was a lot of user input on the original prototype, our team at LSG took it to the next level by utilizing our user interface expertise to improve upon that prototype.

While the public doesn't directly interface with the new system, you should be glad to know that your tax dollars have been put to use on modernizing this system, making Oklahoma a safer place for you and your family.

Comments: None

More money with data presentation – Final Part of BI Series

April 7th, 2015

businessman hand working with new modern computer and business sAs far as data integration goes, once you have all the data centralized in a primary data source, it's time to actually present that data to those that need it to make business decisions. And of course, we ideally want there to be minimal effort on our client's programmers, to make the process easier.

Obviously, there's a plethora of tools available. Two that we use to solve real world problems in the business world are Oracle Business Intelligence (OBI) and Multipeers.

Oracle Business Intelligence

OBI is primarily for the medium to large organizations, based on both pricing and capabilities. They can be organizations in the commercial sector, or the public sector.

The OBI dashboard has extensive features. Many people in medium and large organizations need to generate reports in Microsoft Word or Excel formats, so that is one of the features available.

OBI is all about going to the data source and pulling in the information needed. It's great for people and organizations that have prefer paper reports.


Of course, we've discussed Multipeers in past articles. It's definitely for the small and medium sized market.

Multipeers is very visual. It's all about showing the results on the screen, rather than printing. In addition to mobile device interfaces, it also has the capability to be viewed on a larger screen, in a slideshow-type format. It could be used at trade shows, or in a lobby.

Multipeers uses push technology for real time data.

Using these two tools, we're able to appeal to both the visual types that love to really drill down into a report, as well as those that prefer paper reports. Best of all, there's typically minimal effort in programming, while the presentation of the business information can result in both saving and making a lot of money for the organization.

Comments: None


501 E. 15th St., Suite 200B
Edmond, OK 73013