Analytical methods and software product for automated health care information systems

A method of facilitating analysis of clinically relevant information contained in a clinical database, comprising the steps of:

• performing a backup step including creating a backup to the clinical database to thereby provide a source database for a data extraction program;
• performing an extract step including executing the data extraction program and responsively creating a set of metadata tables and extracted source tables;
• performing a load step including executing a plurality of procedures to move data from the extracted source tables into a plurality of tables of an analytics database;
• wherein the procedures further include procedures applying clinically related logical rules to the data in the extracted source tables and storing flags associated with the logical rules in one or more of the plurality of tables of the analytics database.

A system for medical records management comprising:

• a computer system including a computing platform executing a medical records information application maintaining a clinical database;
• software stored on a machine readable medium accessible to the computing platform creating an analytics database separate from the clinical database;
• wherein the analytics database is configured in accordance with a data model optimized for business intelligence reporting tools, and
• wherein the analytics database further comprises a plurality of flags set by the application of clinically related logical rules to the clinical data.