Get flash to fully experience Pearltrees
Try out the newest version of IBM Many Eyes! New site design and layout
Data Warehouse Overview
Entity–attribute–value model ( EAV ) is a data model to describe entities where the number of attributes (properties, parameters) that can be used to describe them is potentially vast, but the number that will actually apply to a given entity is relatively modest. In mathematics, this model is known as a sparse matrix . EAV is also known as object–attribute–value model , vertical database model and open schema .
JasperReports is an open source Java reporting tool that can write to a variety of targets, such as: screen, a printer, into PDF , HTML , Microsoft Excel , RTF , ODT , Comma-separated values or XML files. It can be used in Java-enabled applications, including Java EE or web applications , to generate dynamic content. It reads its instructions from an XML or .jasper file.
Who enjoys the fastest internet?
DSPL stands for Dataset Publishing Language.
Although this will be a simple example, it will introduce you to some of the fundamentals of PDI:
When doing ETL work every now and then the exact SQL query you want to execute depends on some input parameters determined at runtime. This requirement comes up most frequently when SELECTing data.
Dimension is a term in data management and data warehousing . It's the logical groupings of data such as geographical location, customer or product information. With Slowly Changing Dimensions (SCDs) data changes slowly, rather than changing on a time-based, regular schedule. [ 1 ]
The ETL (Extract, Transform, Load) process is comprised of several steps and its architecture depends on the specific data warehouse system. In this post, an outline of the process will be given along with choices that are/could be used for OpenMRS.
Why would we want to build a data warehouse system?
This post is going to describe the data model for the OpenMRS data warehouse. It will be edited frequently to add documentation for the model and to modify it. Star Schemas
You can create three different types of reports: a Period Indicator Report, a Row-Per-Patient Report, or a Custom Report (Advanced).
We have a great opportunity to explore how Pentaho can provide ETL, analytics, and reporting benefits to OpenMRS , an open source medical records platform and community interested in global health care.
Abstract OpenMRS has few tools in place allowing for easier analysis of concept, patient, location, encounter or visit data in an aggregated, dimensional manner.