how to use open-database?

[arden liu]

I found this page:

http://arelle.org/documentation/xbrl-database/open-database/

And the following two folders:

arelle-2020-03-26/lib/arelle/plugin/xbrlDB/sql/open

arelle-2020-03-26/lib/arelle/plugin/xbrlDB/sql/open2

But http://arelle.org/arelle/documentation/xbrl-database/  page does not have any information. I do not know how to use and load the data into open database.

Does anyone have related information?

Thanks.

Arden

[arden liu]

Based on Arelle/arelle/plugin/xbrlDB/XbrlOpenSqlDB.py, we should be able to use pgOpenDB parameter.

Let's try it.

[Sherif ElGamal]

Hi Arden,

Under section "xbrlDB plug-in setup" at http://arelle.org/arelle/documentation/xbrl-database/ there are instructions on how to use the plugin. Also there are more instructions in the docstring in the begining of  https://github.com/Arelle/Arelle/blob/master/arelle/plugin/xbrlDB/XbrlOpenSqlDB.py

Form command line you can use something like:

arelleCmdLine -f "<url for xbrl entry point>" -v --plugins xbrlDB --store-to-XBRL-DB "<server name>,<port>,<username>,<password>,<database name>,<timeout int>,pgOpenDB"

Or from the GUI activate the plugin then go to Tools > Store to XBRL DB > DB Type > Open Postgres SQL

[arden liu]

Hi Sherif,

Do you know what is the benefit of open database compare with other database schema?

Is XbrlOpenSqlDB.py using open or open 2?

Thanks a lot.

Arden

--

---
You received this message because you are subscribed to the Google Groups "Arelle-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to arelle-users...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/arelle-users/f1afc9b9-5d30-4aec-ad98-168f46c91efa%40googlegroups.com.

[Sherif ElGamal]

The page http://arelle.org/arelle/documentation/xbrl-database/ starts with description of the approaches used with references to the shcemas, I guess the benefit depends on what you want to accomplish.

And I don't see any reference to open2 in the code, its is not used as far as I can see, I might be wrong though.

To unsubscribe from this group and stop receiving emails from it, send an email to arelle...@googlegroups.com.

[ASing]

A few follow on questions on database differences (using Postgres as an example). The difference between Abstract and XBRL-US is clear but within Abstract, there are two options: Sematic or Open. 

1) What is the difference between these and when would you each?

FYI, the documentation states that Semantic is a "concrete realization of the Abstract Model PWD 2.0 layer. This is a semantic representation of XBRL information" and Open is a "concrete realization of the Open Information Model and Abstract Model PWD 2.0. This is a semantic representation of XBRL Open Information Model (instance) and XBRL Abstract Model (DTS) information." What does this mean?

2) The DDL for both is xbrlSemanticPostgresDB.ddl but when I import files using the GUI, using Semantic Postgres SQL and the Open Postgres SQL gives completely different tables. Is that as it should be or am I missing something?

Thank you very much in advance,

Anne