SHARE
Follow this article on Twitter Facebook LinkedIn Bookmark and Share
Home >> Information Architecture >> Databases

HRSDC: We spent $70M on mainframes last year

HRSDC: We spent $70M on mainframes last year

By:  Shane Schick  On: 27 Jul 2009 For: CIO Canada Creator

Federal IT executives are trying to set up an enterprise architecture that will make the public sector more responsive and accountable to citizens, but there’s a lot of legacy work to do first

The government’s enterprise architecture is intended to ensure Canadians only have to submit their personal information once, so that they could receive the same level of service across all channels, Bystrzycki said. Ideally, Service Canada would not request more information from a citizen unless it involved providing a new service of some kind. Getting to this point means mapping out how the government will deal with structured data in databases, messaging data such as e-mail, documents or other content, and media such as images or video. There has been some progress on adopting a workable approach to metadata, he added, such as shared descriptions for names, addresses and other personal information.

From an IT standpoint, the enterprise architecture involves considerable efforts to reduce duplication, shut down obsolete products and bring down costs, Bystrzycki said. The databases are an example. Bystrzycki said the government runs about 450 Oracle databases, about 115 SQL Server databases and another 50 or more proprietary systems. “Whenever you have that many databases, you know you have a problem,” he said. “They’re massive.”

Even once it has dealt with these areas, however, the government has to address the Personal Information Protection and Electronic Documents Act (PIPEDA) and the federal Privacy Act, Bystrzycki said. For instance, reusing client information means figuring out which version of a citizen’s name and address is the correct one, and how it should be shared and protected. “It’s killing us,” he said.

While data integration might seem like an appropriate goal, Bystrzycki said the government is more focused on data federation -- a single instance of data integration in that the metadata it uses can be employed in the integration processes.










Sign up for our Newsletters












Print |  Views: 3819   |   Rating:offoffoffoffoff  (0 votes)
Rate this article on a scale of
1 to 5 stars,5 being the best.




Shane Schick Shane Schick is the Editor-in-Chief of IT World Canada. Follow him at Twitter.com/shaneschick, Facebook.com/Shane.Schick.Media or myi.tw/ShaneSchickGoogle.
blog comments powered by Disqus