Your Privacy

This site uses cookies to enhance your browsing experience and deliver personalized content. By continuing to use this site, you consent to our use of cookies.
COOKIE POLICY

State Government

Courts System Receives Database Migration Assessment

Courts System Receives Database Migration Assessment

UDig assisted a court system with assessing their technical architecture and migration plans to replace IBM Informix. The client can now confidently move forward with the Informix to PostgreSQL migration. With the help of UDig consultants, they will migrate to PostgreSQL and save more than $1M in licensing costs over the following five years.

How We Went from Ideas to Impact

  • The Idea

    Determine whether enterprise architecture modernization and open-sourced solution was appropriate for organization.

  • The Process

    Assess technical architecture, migration feasibility, business environment and risks to save on licensing costs.

  • The Impact

    Postgre SQL POC developed to determine feasability of solution; detailed analysis and roadmap for implementation yielding > $1M in cost savings within 5 years.

  • With the help of UDig consultants, they will migrate to PostgreSQL and save more than $1M in licensing costs over the following five years.

The Idea

Our client has been using IBM Informix databases for 20 years to store and manage official court documents. Due to high and increasing licensing costs, they were considering modernizing their Enterprise Architecture by migrating from Informix to an open sourced solution.

Prior to performing any large scale migration efforts, our client engaged UDig to perform an assessment on the overall migration feasibility, business environment and risks, and the recent PostgreSQL proof of concept (POC) completed by our client’s developers.

The Impact

UDig conducted stakeholder interviews to get a full understanding of the business requirements, risks and concerns, and the POC lessons learned. Additionally, UDig performed further industry research on other Open Source solutions that could serve as viable alternatives to Informix.

UDig consultants delivered interview summaries, POC analysis and a technical solution recommendation.  Based on the research conducted, a roadmap was developed recommending the selection and implementation of PostgreSQL. The roadmap consists of migration rationalization, project timeline with recommended activities and a risk analysis addressing potential challenges.

  • How We Did It
    Data Strategy & Roadmap DesignMaturity AssessmentPlatform Analysis & Selection
  • Tech Stack
    IBM InformixPostgreSQL

Digging In

  • State Government

    UDig Welcomes David Allen as State Government Lead for Georgia

    UDig, a technology consulting company, is excited to announce the latest addition to our team, David Allen, who will take on the role of State Government Lead in Georgia. With two decades of technology experience in both the public and private sectors, David brings a wealth of experience and a deep understanding of the market […]

  • State Government

    NASCIO Midyear Conference | 4 Key Takeaways

    I attended the National Association of State CIO (NASCIO)’s Midyear Conference for the first time in National Harbor, Maryland. It was my first time at a NASCIO event, and what struck me most was how collaborative the NASCIO community is and how passionate these leaders are about serving their state’s constituents and employees.   Each […]

  • State Government

    AI in State Government | Observations from Tech Summit

    The Georgia Emerging Technology Summit: AI 2023 offered valuable insights into the current state and future of artificial intelligence in state government. While many states are still grappling with the policy and ethical considerations surrounding AI, the potential for transformative applications across various departments is undeniable. Key Takeaways | AI in State Government Policy & […]

  • State Government

    Predicting Student Performance Through Machine Learning

    With the level of data collection in modern education, there is a growing interest in using this data to identify students who are potentially falling behind and pinpoint areas in which they can improve. With the extensive data collected by educational institutions, we can leverage machine learning to help educators by flagging if a student […]

  • State Government

    Best Practices for Building an Engaging Digital Citizen Experience

    Whether renewing their car’s registration, paying a fine, or applying for social services, citizens expect to be able to interact with state agencies digitally to find the information they need and efficiently address their needs. Embracing your agency’s digital ecosystem will not only improve your constituents’ perception of your agency but can also enhance service […]

  • State Government

    VA Academic RPA CoP Releases Paper to Accelerate RPA in VA Higher Education

    The VA Academic Robotic Process Automation (RPA) Community of Practice (CoP) released its first primer designed to help universities on opening steps in the automation journey to bring greater effectiveness and efficiency to academic institutions. The CoP co-authored the paper with Jessa Barnes, Advisor of the CoP and Practice Lead, Intelligent Automation for UDig, a […]

  • State Government

    Streamlined Business Processes and Improved User Experience for Legislation Management

    Drafting and tracking bills through the state legislative process is multifaceted, requiring many steps of collaboration and review from government leaders, lawmakers, and drafters. Historically, this process has been cumbersome as it has relied on manual tasks and paper-driven reporting to meet each legislative element. Any software used to track the bills has typically become outdated, needing extensive upgrades. So, when a legislative technology company had a vision for helping a state government modernize its business processes and systems, they contacted UDig. As strategic partners, we worked together to design and build a flexible, collaborative tool that transforms how state governments manage the legislative process.