Of Epic ' s three data stores, Clarity and Caboodle are relational databases. Both organize data into tables with defined columns and keys, and both are queried with SQL, which is why analysts can join tables and aggregate data. Clarity is structured to mirror the content of Chronicles in a relational form, and Caboodle is a data warehouse with a dimensional design that is optimized for analysis and that can include data from sources other than Epic. Chronicles is not relational. It is a hierarchical database in which data is organized by master files, records, contacts, items and lines, and it is accessed through Epic ' s own tools and not through SQL. This is why Chronicles is excluded from the answer. The difference explains the existence of the extract process: Chronicles is optimized for fast transactional access to individual records, whereas the relational stores are optimized for reporting on large volumes of data. Understanding which database is relational helps analysts choose the correct tool, using SQL where it is possible and Chronicles-based tools otherwise.
[Reference: Cogito Fundamentals – Epic Data Architecture: Relational Databases in the Epic Stack, ===============, ]
Submit