Technical_Specifications_Worksheet.xlsx
XLSX spreadsheet 26 KB Posted
- Solicitation number
- AHRQ-19-10005
About this file
Technical Specifications Worksheet
View the file
Other files
| File | Type | Posted |
|---|---|---|
| AHRQ-19-10005_Amendment_1.pdf | ||
| AHRQ-19-10005_Solicitation_Questions_Responses.pdf | ||
| AHRQ-19-10005.pdf | ||
| DRAFT_Statement_of_Work.docx | DOCX document |
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Tech_Specs
| Notes | FastStats: Provides easy access to the latest HCUP-based visual statistical displays and tables for health care information topics | HCUPnet: online query system based on the Healthcare Cost and Utilization Project (HCUP) data | MEPS Summary Tables – Household Component (HC) | MEPSnet - HC | |||||
| (Enables users with no programming skills to analyze MEPS FYC file) | MEPS Summary Tables – Insurance Component (IC) | MEPSnet - IC | |||||||
| (An interface to navigate IC Summary Tables) | QDR-NHQRnet: Generate Reports, used as a Query Data Tool, generates State Snapshots and Dashboard, National Benchmark researching tool | ||||||||
| QDR / NHQRnet | |||||||||
| Technical Specifications | |||||||||
| Software Requirements | |||||||||
| Operating System | Current operating system for the tool | Red Hat Enterprise Linux | Windows 2012 | CentOS 6 Operating System | CentOS 6/Windows 12 | CentOS 6 Operating System | CentOS 6 Operating System | CentOS Operating System | |
| Software Component/Programming Language | Language that the current tool operates in for both front and back end (e.g., CGI, ASP, Java, Connection Wizard) | Java, Apache HTTPD, Tomcat, SimpleMaps, JSP, JSTL, XML, HTML | Front-End: Backbone (Marionette) |
API: Dot net
| Back-End: SQL Server 2014 | CSS, HTML, JavaScript, R | Java, SAS (SAS/IntrNet to create estimates in real time) | CSS, HTML, Static HTML and PDF files | Java | Java: J2EE Technologies (Java, Groovy, Groovy Server Pages, Grails, Spring, Hibernate, JQuery), ForeSee survey | |
| Web Server | ||||||
| Server Type | Server type that's required to host the tool | Virtual Machine | IIS Server 8.0 | Shiny Server Pro | IIS Server, SAS, Apache web server, Tomcat servlet container |
Apache manages the static content and Tomcat manages the dynamic content. The IIS server uses SAS/IntRnet to run SAS.
| Note: The Apache and Tomcat servers are used by MEPSnet – HC, MEPS Summary Tables (IC), and MEPnet – IC as well as the remainder of the MEPS website. | Apache web server, Tomcat servlet container | Apache web server, Tomcat servlet container | Apache web server, Tomcat servlet container | |||
| Server Storage Size | Current memory capacity for the tool | 90 GB | 85GB | Storage 40 GB | Apache Web Server: |
Storage: 90 GB Memory: 7 GB
Tomcat Server:
Storage: 140 GB Memory: 9 GB
IIS Server (SAS Server):
Storage: 120 GB Memory: 4 GB Apache Web Server: Apache Web Server: Web application uses two different servers. Apache manages the static content and Tomcat manages the dynamic content. Here are the storage and memory requirements for the two servers.
Apache Web Server:
Storage: 40 GB Memory: 3 GB
Tomcat Server:
Storage: 200 GB Memory: 9 GB
| Transaction Volume/Size | Estimated number of transactions the tool has on average | N/A - There is no actual transactions or real-time data processing happening on the server. Web server is simply displaying HTML, XML, images, and spreadsheets that were prepared offline and copied on to the Web server for display purposes. Source data is stored separately and analyzed offline (i.e. not connected to the Internet). The installed third-party software (SimpleMaps) utilize aggregated results in a spreadsheet uploaded to the Web server to generate maps. | 264,668 hits/month | Memory 4 GB | 5,678 hits/month | Storage: 90 GB | Storage: 90 GB | 120,000 hits/month |
| Memory Requirements | Any additional requirements for memory storage or RAM that are needed for the web app | 8 GB | 4GB | 35,774 hits/month | None | Memory: 7 GB | Memory: 7 GB | None |
| Database Server | ||||||||
| Server Type | Server type that's required to store the tool's data | N/A - There is no actual transactions or real-time data processing happening on the server. Web server is simply displaying HTML, XML, images, and spreadsheets that were prepared offline and copied on to the Web server for display purposes. Source data is stored separately and analyzed offline (i.e. not connected to the Internet). The installed third-party software (SimpleMaps) utilize aggregated results in a spreadsheet uploaded to the Web server to generate maps. | SQL Server | None | Oracle |
Note: One server is used by MEPSnet – HC, MEPS Summary Tables (IC), and MEPSnet – IC, as well as the remainder of the MEPS website, NHQRnet, and PSO
| Oracle | Oracle | Oracle (Note that one server is used by three web sites. MEPS, NHQRnet and PSO) | ||||||
| Server Version | Version of server if available | N/A | 2014 SP2 | N/A | 12c Database | 12c Database | 12c Database | 12c Database |
| Sever Needs | Any requirements needed to store the web apps memory | N/A | 2 CPU | N/A | None | None | None | None |
| Storage Type | Local or cloud storage | N/A | VM Ware (Cloud) | N/A | VMWare (Cloud) | VMWare (Cloud) | VMWare (Cloud) | VMWare (Cloud) |
| Memory Requirements in RAM | Required memory space | N/A | 16 GB | N/A | 13 GB | 13GB | 13 GB | 13 GB |
| Disk Space/Storage Requirement | Required disk space | N/A | 4.5TB | N/A | 550 GB | 550 GB | 550 GB | 550 GB |
| Data Preservation Requirements (in years) | Any purging requirements for storage | N/A | None | No | No | No | No | None |
| Dependencies | ||||||||
| System/Technical Dependencies | The technical steps required to extract, transform, load (ETL) external data into the database | None. Web server is air gapped from data source. Web server is hosted in a different physical facility 1500 miles apart. | Data Prep in SAS is done by Social & Scientific Systems (SSS) before it can begin the ETL process into the HCUPnet database application | Summary tables are created from AHRQ public use files (that includes Microdata, .ssp datasets, ASCII datasets, and FYC file) |
Creation of summary tables is done using 'R' (open-source programing language) to produce .csv files (intermediate) and then JSON files (summary tables)
HC summary tables are updated on the website using the JSON files Queries FYC micro-data file directly, calculates estimates in SAS, displays SAS output None Queries, Oracle Tables IQDnet - this tool depends on IQDnet as the main repository for its data, which stores the about 40 microdata from national healthcare surveys administered by AHRQ, CDC, HRSA, IHS, NIH, SAMHSA, AHA, NHPCO and FEHCS SAS-DDE macro programs formats tables, process and builds the data into Oracle data
| Staff/Manual Dependencies | The manual steps required to ETL external data into the database | Contractor staff manually transfer files authorized for posting from offline data source to Production Web server for display. | Data Prep in SAS is done by Social & Scientific Systems (SSS) before it can begin the ETL process into the HCUPnet database application | Data needs to be downloaded, packaged and sent to SSS | SSS produces a subset of the FYC file (single micro-data table for each data year) as a SAS dataset | Census conducts survey and compiles data into Microdata (not available to AHRQ) and creates the Summary Tables (for public) as SAS datasets. SAS is used to generate HTML files and Apache FOP is used to generate PDF files. Staff run queries to add information into Oracle tables about new IC summary tables | Census conducts survey and compiles data into Microdata (not available to AHRQ) and creates the Summary Tables (for public) as SAS datasets. SAS is used to generate HTML files and Apache FOP is used to generate PDF files. Staff run queries to add information into Oracle tables about new IC summary tables | Unstructured/scattered data needs formatting, filtering and mapping to become usable to users, Social & Scientific Systems (SSS) complete these steps after receiving the data |
| Interfaces | ||||||||
| External | ||||||||
| Input System (Supply Data) | Interfaces outside of AHRQ that feed data into this tool | No actual data is inputted from external sources on to the system (Web server). | None | None | None | None | None | None |
| Output Systems (Extract Data) | Interfaces outside of AHRQ that this tool feeds into | Images, spreadsheets, and site content text approved by AHRQ for posting to Website is available for public download. Source data is not stored on the system. | User driven action, not a system feed: Facebook, Twitter, and Email “share” options on HCUPnet | None | None | None | None | None |
| Internal | ||||||||
| Input System (Supply Data) | Interfaces inside of AHRQ that feed data into this tool | Images, spreadsheets, and site content text approved by AHRQ for posting to Website is available for public download. Source data is not stored on the system. | AHRQ supplies SSS the data from HCUP partners | None | None | None | None | IQDnet, which is sourced from AHRQ, CDC, HRSA, IHS, NIH, SAMHSA, AHA, MHPCO and FEHCS |
| Output Systems (Extract Data) | interfaces inside of AHRQ that this tool feeds data into | Images, spreadsheets, and site content text approved by AHRQ for posting to Website is available for public download. Source data is not stored on the system. | None | None | None | None | None | Not Provided |
| Data/Deployment | ||||||||
| Data Type | Description of the data (e.g., aggregated, microdata) | HTML, java script, images, and spreadsheets | Aggregated statistics | HC summary tables are updated on the website using the JSON files | SAS is run to produce the SAS datasets needed from a new FYC file. Metadata are created using SAS and uploaded into the Oracle database. | SAS datasets – summary tables | SAS datasets from summary tables are standardized by SSS into Master SAS dataset, which is uploaded into an Oracle database | Raw aggregated statistics from diverse microdata |
| Runtime (duration) | Length of time to upload the data | Website is running 24x7 except for monthly system maintenance downtime (approx. 1 hour). | Avg 3-5 mins. to load a dataset (CSV file) to SQL Server | 4 hrs. | 30 min | 15 min | 15 min | 15 min to load SAS datasets to Oracle |
| Run Schedule | Frequency of uploading data | N/A - There is no actual transactions or real-time data processing happening on the server. Web server is simply displaying HTML, XML, images, and spreadsheets that were prepared offline and copied on to the Web server for display purposes. Source data is stored separately and analyzed offline (i.e. not connected to the Internet). The installed third party software (SimpleMaps) utilize aggregated results in a spreadsheet uploaded to the Web server to generate maps. | 7-8 updates/year | Once per year | Once per year | 2x per year (Jan, Jun) | 2x per year (Jan, Jun) | Once a year |
| File Size requirements | Maximum size allowed for the data source file | Files sizes are not specified, but typically file sizes do not exceed 5 MB each. | 4-5 large updates, up to 40 GB, and 3 smaller updates, less than 5 GB | 150 MB | 1 GB | 60 MB | 60 MB | Not Provided |
| Data Sources | Name of source organizations or entities where data for this data tool comes from | HCUP and State Data Partners | HCUP NIS (1993-2015), NEDS (2006-2014), NRD (2009-2014), SID (1997-2014), SEDD (2000-2014), and SASD (2012-2014) databases | AHRQ Public Use Files | AHRQ Public Use Files | Census: Summary Tables | Census: Summary Tables | External: CDC, NIH, AHRQ, HRSA, IHS, SAMHSA, AHA, HHS, NHPCO, FEHCS (unstructured and scattered data) |
Internal: IQDnet (main repository, updates annually)
| File Types Received | In what format does the source organization send the data to AHRQ | Hypertext markup language - HTML | CSV files | .ssp file (FYC File, Conditions File) converted into JSON file | .ssp file | SAS dataset | SAS dataset | SAS dataset and Excel, Word, PDF, Web tools |
| File Types Available to Users | In what format can the user download the data (e.g., .csv) | Extensible markup language - XML | Excel/CSV Exports from public site | .csv files, .png plot, .R code, .SAS code | None | Excel, HTML, and PDF | Not Provided | |
| Format displayed to users | In what format is the information displayed to the user (e.g., web display) | JavaServer Pages - JSP | Tables, Graphs | web display | Web display | Web display | Plot graphs with statistical Z-tests; web display, including view over time | Excel table, Plot graphs, Web Tables |
| System downtime | Any downtime needed to load data into the data tool | Image files - PNG | None | None | None | None | None | No |
| Method of Data Transfer | How does AHRQ receive the data from the data source (e.g., email, direct interface) | SSH upload for posting content. HTTPS/SSL for viewing/downloading content by users. | Export function via user interface on hcupnet.ahrq.gov | Secure FTP | SAS files are uploaded to the SAS server using Secure FTP. Metadata are uploaded using SAS/Access | Secure FTP | Secure FTP | Tables are uploaded using SAS/Access |
Static content is uploaded using Secure FTP
| Security Specification | |||||||
| Can any user pull all available data? | Information posted to Website is publicly available. Underlying source data is not stored on this system (Web server). | Yes | Yes | Yes | Yes | Yes | Yes |
| Are there any type of security restrictions on this tool? | There is no security restriction on the Fast Stat tool hosted on the HCUP-US Website. It is publicly available. The underlying system (HCUP Web Services) hosting the Website has a FISMA Low ATO. | None | FISMA Compliance (Low) | FISMA Compliance (Low) | FISMA Compliance (Low) | FISMA Compliance (Low) | Not Provided |
As of December 14, 2018
AHRQ Data Tools Project - Technical Specifications Template www.atlasresearch.us https://meps.ahrq.gov/mepstrends/hc_use/https://meps.ahrq.gov/mepsweb/data_stats/meps_query.jspmailto:jgruber@atlasresearch.ushttps://meps.ahrq.gov/mepsweb/data_stats/quick_tables_search.jsp?component=2&subcomponent=1https://meps.ahrq.gov/mepsweb/data_stats/MEPSnetIC/startuphttps://www.hcup-us.ahrq.gov/faststats/landing.jsphttps://nhqrnet.ahrq.gov/inhqrdr/https://hcupnet.ahrq.gov/ image1.png
File details come from the government source that posted it.