Hudnall Matthew, Lewis Dwight, Parton Jason, Sellers Christopher
Information Systems, Statistics, and Management Science, University of Alabama, Tuscaloosa, Alabama, USA.
Management, University of Alabama, Tuscaloosa, Alabama, USA.
JAMIA Open. 2022 Aug 1;5(3):ooac065. doi: 10.1093/jamiaopen/ooac065. eCollection 2022 Oct.
Many states are continuing to struggle with opioids and other commonly abused drugs. Alabama, being the highest opioid prescription per-capita state since 2012, has pulled together state agencies, private companies, academia, and community organizations to form a data council and repository to provide unified insights and information to the public and partner stakeholders. The lessons learned in constructing this data environment are documented so that other states and organizations can benefit from the challenges and success that Alabama has experienced. The centralized data repository consists of almost a dozen data streams from public agencies and private companies. The data are transformed and linked within the repository to provide geo-temporal linkages between data sources. The data are stored in a secure multi-tiered environment in a Microsoft SQL Server database, de-identified, aggregated, and then published to a public web portal for open consumption. The public-facing website from the project successfully integrates multiple disparate data sources into a common platform for streamlined and cohesive data communications. Drug addiction cannot be easily quantified, viewed, or otherwise examined when only looking at a portion of society. By bringing together multiple data sources and linking them, a more clear picture of trends, influences, and metrics can be obtained. A statewide drug use data partnership between public and private entities is both possible as well as beneficial to all parties involved. Items like legal contracts can inhibit data sharing, but certain best practices can help scale and streamline multiple agreements.
许多州仍在与阿片类药物及其他常见滥用药物作斗争。自2012年以来,阿拉巴马州一直是人均阿片类药物处方量最高的州,该州已联合州政府机构、私营公司、学术界和社区组织,成立了一个数据委员会和存储库,为公众和合作伙伴利益相关者提供统一的见解和信息。构建这一数据环境过程中的经验教训已被记录下来,以便其他州和组织能够从阿拉巴马州所经历的挑战和成功中受益。这个集中式数据存储库包含来自公共机构和私营公司的近十几个数据流。数据在存储库中进行转换和链接,以提供数据源之间的地理时间联系。数据存储在Microsoft SQL Server数据库的安全多层环境中,经过去识别、汇总,然后发布到公共门户网站以供公开使用。该项目面向公众的网站成功地将多个不同的数据源集成到一个通用平台上,实现了简化且连贯的数据通信。仅观察部分社会群体时,药物成瘾情况很难进行量化、观察或以其他方式研究。通过整合多个数据源并将它们关联起来,可以更清晰地了解趋势、影响因素和指标。公共和私营实体之间建立全州范围的药物使用数据合作伙伴关系不仅是可行的,而且对所有相关方都有益。像法律合同之类的事项可能会阻碍数据共享,但某些最佳实践有助于扩大规模并简化多项协议。