2ndQuadrant | PostgreSQL
Bases de Datos de Misión Crítica
  • Contacto
  • ES
    • EN
    • FR
    • IT
    • DE
    • PT
  • Soporte & Servicios
  • Descargas
    • Instaladores
      • Postgres Installer
      • 2UDA – Unified Data Analytics
    • Whitepapers
      • Caso de Negocio para Soporte PostgreSQL
      • Mejores Prácticas de Seguridad
    • Casos de Estudio
      • Migración de Bases de Datos
        • International Game Technology (IGT)
        • Healthcare Software Solutions (HSS)
        • Navionics
      • Ajustes de Rendimiento
        • BenchPrep
        • tastyworks
      • Clústeres de Bases de Datos Distribuidas
        • ClickUp
        • Agencia Espacial Europea (ESA)
        • Animal Logic
        • Telefónica del Sur
      • Actualizaciones de Bases de Datos
        • Instituto Alfred Wegener (AWI)
      • Soporte & Administración de Bases de Datos
        • Met Office
        • Agilis Systems
        • London & Partners
  • Centro de Aprendizaje Postgres
    • Webinars
      • Próximos Webinars
      • Biblioteca de Webinar
    • Whitepapers
      • Caso de Negocio para Soporte PostgreSQL
      • Mejores Prácticas de Seguridad
    • Blog
    • Formación
      • Catálogo de los Cursos
    • Casos de Estudio
      • Ajustes de Rendimiento
        • BenchPrep
        • tastyworks
      • Clústeres Distribuidos
        • ClickUp
        • Agencia Espacial Europea (ESA)
        • Telefónica del Sur
        • Animal Logic
      • Administración de Bases de Datos
        • Agilis Systems
      • Formación Profesional
        • Met Office
        • London Partners
      • Actualizaciones de Bases de Datos
        • Instituto Alfred Wegener (AWI)
      • Migración de Bases de Datos
        • International Game Technology (IGT)
        • Healthcare Software Solutions (HSS)
        • Navionics
    • Libros
      • PostgreSQL 11 Administration Cookbook
      • PostgreSQL 10 Administration Cookbook
      • PostgreSQL High Availability Cookbook – 2a Edición
      • PostgreSQL 9 Administration Cookbook – 3a Edición
      • PostgreSQL Server Programming Cookbook – 2a Edición
      • PostgreSQL 9 Cookbook – Edición en Chino
    • Videos
    • PostgreSQL
      • PostgreSQL – La historia
      • ¿Quién usa PostgreSQL?
      • Preguntas Frecuentes sobre PostgreSQL
      • PostgreSQL VS MySQL
      • Caso de Negocio para PostgreSQL
      • Información de Seguridad
      • Documentación
  • Sobre nosotros
    • Sobre 2ndQuadrant
    • La Pasión de 2ndQuadrant por PostgreSQL
    • Noticias
    • Trabaje con Nosotros
  • Blog
  • Instaladores
  • Menú Menú
Usted está aquí: Inicio1 / Think Research

Think Research

Revolutionary Healthcare Company Chooses 2ndQuadrant for Database Migration, Support, and Remote Dba Services

Think Research is a leading healthcare process optimization company in North America. They develop knowledge-based tools which empower clinicians to deliver the best evidence-based care, thereby driving a better outcome for patients. Think Research connects clinicians, facilities, and entire health care systems with the highest quality clinical content and the technologies to put it into practice.

Health care organizations are facing a growing number of complex challenges including quality improvement policies, constrained funding, disconnected systems, and a constantly expanding base of medical knowledge and information. Navigating and adapting to all this complexity requires new ways of thinking. Think Research provides practical and cost-effective solutions that approach health care industry challenges in new and creative ways. Their health care applications make leading clinical practices more accessible and actionable right at the point of care.

Due to the sensitive nature of the data in the healthcare industry, data security and optimization is critical. A sound database infrastructure provides a solid foundation for the constant innovation and development of patient care applications.

The Challenge

Think Research originally deployed a proprietary fork of PostgreSQL as a solution to their integrated data management needs. However, they lacked a  dedicated team for database administration, maintenance, and troubleshooting.

Shortly after implementing the proprietary fork of PostgreSQL as the backend database, Think Research’s management recognized the limitations of vendor lock-in. In order to maintain a sound database infrastructure, it became critical for Think Research to find a company with working knowledge of PostgreSQL for remote DBA services.

In addition to these challenges, being permanently tied to a single vendor resulted in upgrade complications due to lack of binary compatibility with open source PostgreSQL. Without binary compatibility, it became impossible for Think Research to upgrade to the latest version of PostgreSQL according to their schedule, as they were dependent on the vendor’s release cycle. Think Research opts for the most cutting-edge technologies in the development of their applications, so it was of utmost importance to be able to keep up to date with the PostgreSQL releases.

The Solution

Implementing Open Source PostgreSQL eliminates issues related to upgrades, vendor lock-in, and high costs. It also opens up the users to a world of flexibility for professional support & administration.

Think Research reached out to 2ndQuadrant, after receiving a strong recommendation, to help them migrate their database away from the proprietary fork. 2ndQuadrant consultants worked closely with Think Research to examine their database environment and suggest a migration & upgrade process that would reliably move them to open source PostgreSQL. Before the migration could take place, 2ndQuadrant’s consultants also performed a Supportability and Architectural Health Check.

The suggested migration was a two-pronged process, running in parallel, that required the team to:

  • Synchronize the data between the proprietary and the community versions with minimal downtime.
  • Upgrade PostgreSQL to the current major version (9.6).

Due to the sensitive nature of their data, Think Research chose to have their own system administration team complete the upgrade. 2ndQuadrant consultants provided constant support to help ensure their applications worked flawlessly during and after the migration.

Darace Rose, CIO & Vice President of Information Technology says:

«Working with 2ndQuadrant allowed the team time to focus on our strategic database initiatives while their Remote DBA services delivered the planned operational changes all the while maintaining our highly secure & available system.»

In addition to consultancy and migration services, 2ndQuadrant also initiated a long-term partnership by providing 24/7 Support and Remote DBA services.

About 2ndQuadrant

2ndQuadrant provides PostgreSQL solutions for the Enterprise. Our support engineers have over 100 years of combined code contributions to the PostgreSQL project, making us the only company to contribute enterprise features to all of the last 13 releases. This is paired with 17+ years of hands-on experience through client engagements and allows us to integrate customized solutions with our customers – making 2ndQuadrant the Gold Standard for PostgreSQL products & services.

Recent Posts

  • PG Phriday: 10 cosas que Postgres podría mejorar – Parte 3 noviembre 8, 2020
  • Búsqueda de texto completo desde PostgreSQL 8.3 noviembre 5, 2020
  • Webinar: Mejores prácticas para la carga masiva de datos en PostgreSQL [continuación] noviembre 4, 2020
  • Números aleatorios noviembre 4, 2020
  • ¿Qué partición de mi base de datos PostgreSQL contiene una fila determinada? noviembre 1, 2020
  • Twitter
  • Linkedin
  • Facebook
  • Youtube
  • Mail

Soporte y Servicios

Soporte de producción 24/7

Soporte para desarrolladores

DBA remoto para PostgreSQL

Monitoreo para bases de datos PostgreSQL

Health Check para PostgreSQL

Ajustes de Rendimiento para PostgreSQL

Auditoría de seguridad para bases de datos

Actualice PostgreSQL

Evaluación de Migración hacia PostgreSQL

Migre desde Oracle

Productos

PostgreSQL de alta disponibilidad

BDR

2ndQPostgres

pglogical

repmgr

Barman

Postgres Cloud Manager

Firewall SQL

Postgres-XL

OmniDB

Postgres Installer

2UDA

Centro de Aprendizaje Postgres

PostgreSQL

Blog

Webinars

Libros

Videos

Formación

Casos de Estudio

Eventos

Sobre nosotros

Sobre 2ndQuadrant

¿Qué significa «2ndQuadrant»?

Noticias

Trabaje con nosotros

Nuestro equipo

© 2ndQuadrant Ltd. All rights reserved | Privacy Policy
  • Twitter
  • LinkedIn
  • Facebook
  • Youtube
  • Mail
Desplazarse hacia arriba
×