Help：about the generation of concepts for MIMIC-IV-2.2

[washingtonwuyi]

Hello everyone! It's me agian.Today I tried to generate concepts for my local MIMIC-IV-2.2 build.Following the README instructions,I executed the SQL files on the SQL Shell,and every steps seemed to go normal.However,after the generation of the concepts,I found that the views or the materialized views were under the category of "tables" but not the "views" or "materialized views",no matter the GUI I used was "pgAdmin 4" or "Navicat".Why's that?Any solutions or suggestions?Thank you!

[alistairewj]

This is because... they are tables!

More specifically, these used to be materialized views, but somewhere along the way I realized it would be better to simply create tables on a separate schema, rather than materialized views in the same schema. It also makes the code more portable as some database systems don't support materialized views.

You can see here where we echo "creating materialized views":

mimic-code/mimic-iv/concepts_postgres/postgres-make-concepts.sql

Line 3 in 78f7b6e

\echo 'Beginning to create materialized views for MIMIC database.'

But then all the scripts actually make tables:

mimic-code/mimic-iv/concepts_postgres/demographics/icustay_detail.sql

Lines 1 to 2 in 78f7b6e

	-- THIS SCRIPT IS AUTOMATICALLY GENERATED. DO NOT EDIT IT DIRECTLY.
	DROP TABLE IF EXISTS icustay_detail; CREATE TABLE icustay_detail AS

So this is just a typo/bug in the SQL script.

[washingtonwuyi]

Wow，thank you for your answer! My confusion has gone after reading your explanation.Thank you for your time and patience.Have a nice day!