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

  • People

    Digging in with David Allen, State Government Lead

    Digging In is a regular series of blog posts profiling UDig employees. We hope this series helps you get to know our team and understand why we dig what we do! Today, we are sitting down with David Allen, State Government Lead. UDig: Tell us a little bit about your background and your role at […]

  • State Government

    Exploring the Future of State Technology: Takeaways from the NASTD 2024 Annual Conference

    Last week, I attended the National Association of State Technology Directors (NASTD) 2024 Annual Conference in Minneapolis, MN. This premier event brings together state technology directors, industry experts, and vendors to discuss the latest trends, challenges, and innovations in state technology. The conference fosters the exchange of ideas and best practices essential for addressing shared […]

  • 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

    Improving the Process and Accuracy of State Permits and Inspections

    A custom, user-centered application that supports existing business processes, allows for function-wide automation, and converts data from a legacy system while meeting state compliance requirements.

  • State Government

    Unlocking Data Insights for a State Education Agency

    A data-enabled agency that can leverage predictive analytics to provide its school districts, students, and parents with data-driven information that fosters informed decisions.

  • 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 […]