advertisement

Poles position

50 %
50 %
advertisement
Information about Poles position

Published on October 30, 2008

Author: dmoraschi

Source: slideshare.net

advertisement

Poles Position A preliminary study for a unified time-series model data warehouse Davide Moraschi Competitiveness and Sustainability

Google search on keywords Vensim AND database gives an extremely low number of results . The documentation of the software says : Database Notes The structure of the database will determine both the complexity of the statements needed to pass information back and forth with Vensim and the efficiency with which these statements can be executed. If you are passing small amounts of data then it is best to use the most convenient database structure and write very explicit queries and output statements. If you are passing a larger amount of data you may want to emulate the simple example that comes with Vensim . You can then use Triggers or other mechanisms supported by the database you are using to do any necessary internal transformations prior to Vensim’s database reads and successive to its database writes .

Google search on keywords Vensim AND database gives an extremely low number of results .

The documentation of the software says :

Simple Database Example The model odbctest.mdl along with the Microsoft Access Database odbctest.mdb provides a simple example of the ODBC connectivity. The database has a table describing variables along with a unique index for each variable subscript combination. There are no internal constraints on referential integrity in this database, but those should be included for a more complete application.

Data access from Vensim is done via ODBC and vdi/vdo files. The syntax of these files is briefly explained in the documentation: VDI files are treated as standard changes files and read when simulation starts:

Google search on keywords Gams AND database gives an acceptable number of results . Most of them refer to <Grant Application Management System>, <Guide to Available Mathematical Software>, < Geospatial Analysis and Modeling Section>, and so on. There is a very detailed article written by Erwin Kalvelagen on how to interface Gams and other applications, but there is no mention to how a database should be designed.

Google search on keywords Gams AND database gives an acceptable number of results .

Most of them refer to <Grant Application Management System>, <Guide to Available Mathematical Software>, < Geospatial Analysis and Modeling Section>, and so on.

There is a very detailed article written by Erwin Kalvelagen on how to interface Gams and other applications, but there is no mention to how a database should be designed.

Data access from GAMS is done via GDX files. This is a proprietary binary format, and several tools are available to produce such files from different sources.

In order to create a “common” database we must first create a “common” nomenclature. In Vensim we speak about Variables, Subscripts, Ranges, Subranges In GAMS we speak about Parameters, Sets, Elements

Dimension Subscript Dimension Element Element Element Vector Range, Subrange Set Variable Variable Parameter Common name Vensim name GAMS name

WOOD = Variable CATCUSTOMER = Vector [AUT,URBAN,LPETROL] = Dimension AUT = Element

TSTRAD = Variable SS = Vector ( mmpdr , aus , nzl ) = Dimension mmpdr = Element

TIME SERIES Identification TIME SERIES Value … 0.5853 0.5868 0.5875 0.5906 … 1998 1997 1996 1995 … 5 Y1995 4 Y1994 7 Y1993 5 Y1992 1 Y1976

VARIABLES EXECUTIONS DIMENSIONS VALUES ELEMENTS VECTORS Many-to-Many Many-to-Many Many-to-Many One-to-Many Many-to-Many

Visual Basic GDX File VPM File GDXIO.DLL VENDLL32.DLL OO4O GDXIO and VENDLL32 are standard windows API libraries, can be called from any DLL compliant programming language. OO4O is a COM interface, can be called from any COM aware programming language.

http://test.jrc.es/morasdaTests/Viewer.cfm

retval& = vensim_get_data( ByVal FileList(v%), ByVal VarList(i%) & SubList(ii%), ByVal &quot;time&quot;, varvals(0), timevals(0), ByVal ZERO) gdxdatareadstrstart(ap&, synr&, nrrecs&) gdxdatareadstr(ap&, astrelements, avals, afdim&)

SQL2GMS is a tool to convert data from an SQL database into GAMS readable format. The source is any data source accessible through Microsoft’s Data Access components including ADO , ODBC and OLEDB . The target is a GAMS Include File or a GAMS GDX File . SQL2GMS, Version 3.0, November 2006 Erwin Kalvelagen, GAMS Development Corp

 

Add a comment

Related pages

Pole-Position – Wikipedia

Die Pole-Position oder Poleposition, auch Pole genannt [ˈpəʊ̯l pəˌzɪʃn] (engl. pole position, pole für Pfahl, Pfosten, Stange), ist im Motorsport ...
Read more

Pole position - Wikipedia, the free encyclopedia

The pole position for the Indianapolis 500 is determined on the first day (or first full round) of time trials. Cars run four consecutive laps (10 miles ...
Read more

Pole-Position's Bobtails

herzlich willkommen bei den: start
Read more

Pole Position (Computerspiel) – Wikipedia

Pole Position ist ein Computer-bzw. Arcade-Spiel, welches eine Rennsimulation darstellt. 1982 wurde es von Namco, dem Entwicklerstudio von Pac-Man, entwickelt.
Read more

Pole Position (video game) - Wikipedia, the free encyclopedia

Pole Position (ポールポジション, Pōru Pojishon?) is an arcade racing video game which was released by Namco in 1982 and licensed to Atari, Inc ...
Read more

Pole Position Raceway

Experience the exhilaration of indoor go kart racing at Pole Position Raceway. Check out our electric go karting locations today.
Read more

recaro pole position | eBay - Elektronik, Autos, Mode ...

Tolle Angebote bei eBay für recaro pole position recaro schalensitze. Sicher einkaufen.
Read more

Pole position - Wikipedia, la enciclopedia libre

La pole position o simplemente pole (en inglés, literalmente: "posición de poste") es el término que se utiliza en ciertas modalidades de automovilismo ...
Read more

Duden | Pole­po­si­tion, Pole-Po­si­tion ...

Definition, Rechtschreibung, Synonyme und Grammatik von 'Poleposition' auf Duden online nachschlagen. Wörterbuch der deutschen Sprache.
Read more

Fahrerrekorde: Pole Position - Sportnachrichten

Fahrerrekorde Pole Position ... Lesen Sie die aktuelle kicker-Ausgabe vor allen anderen auf Ihrem Tablet oder Smartphone!
Read more