Intergraph PDS model interface

Sajit, the MDP as written earlier, is a seperate database schema in PDS
where the complete model data is replicated by means of running a seperate
batch process by the admin. Pl. refer the PDS manual which has a graphical
layout of all the tables and field names and the relationship between
them. The MDP has been provided so that the user can generate any kind of
report they may require of the model, including mto, tonnage, linelists,
valve lists, etc. anything you may like to report.

In simple terms...the other DB schema contains all the live graphical data
of the model in encrypted form which is the graphical technology of
intergraph. For developers access to this data the MDL language was
created to talk with this DB and to extract information and to create
graphical components. For eg. if you want to place a pipe, you can write
in MDL language and can see in it in the 3D model space. PDS has objects
written in MDL language, where all the basic elements like, pipe, elbow
etc...have been made available ready made which are variable driven, so
when the length and dia is defined by the modeler the system runs the MDL
objects and creates the 3D component and user places the labels like line
no. area code etc.. Same for any other objects modeled. All these
graphical information is stored in the DB in encrypted form which is
another important technogy. User can also access these info using MDL
language to report the same. As specialist of MDL are not many in the
market, MDP batch was made available for broader userbase, which is simple
to query and report.

Now coming to your question of being a simple task,.....the DB records of
a simple 2000 line project goes nearly a million all put together. Which
is why MDP is not online but a need based batch processing. However there
is possibility to run the batch for a partial data, sections etc. Consult
your admin to know more on MDP batching options.

So you have two choice, either to write a MDL procedure and dump ascii and
compile in ms-access or to access from MDP directly thro' ms-access. As
nowadays companies are growingly standardising the so called assemblies( I
know few companies who call a complete system of lines as an assembly and
other companies a pressure tap as an assembly) to more broader level,
like the 'modular piping', there should be people who create these
assemblies...which is possible only by MDL experts.

With regards,
Kannan.
----------------------------------------------------------

sviswan@technip.com
Sent by: PipingDesign@yahoogroups.com
03/06/2008 11:15
Please respond to
PipingDesign@yahoogroups.com

To
PipingDesign@yahoogroups.com
cc

Subject
Re: [PipingDesign] Intergraph PDS model interface

Kannan,

I understand general Databases Access, SQL server or Oracle, how they
work.
I do not know how the MDP works. Therefore it is hard for me to imagine
why
such an update is required at all. Since this is a seemingly simple task
and one that is not so resource intensive.

Sajit

kannan.sundaram@l
inde-le.com
Sent by: To
PipingDesign@yaho PipingDesign@yahoogroups.com
ogroups.com cc
Sandiveloo@technip.com
Subject
02/06/08 07:09 PM Re: [PipingDesign] Intergraph PDS
model interface

Please respond to
PipingDesign@yaho
ogroups.com

One additional point. The MDP is not an online info, but is a procedure
option of PDS.
In the beginning phase of a project the process takes few minutes to
generate/populate the
MDP databank. As the project data size grows, it has to be schedule by the
admin for overnight
process. Especially when multiple big projects are on....then the server
power will be sucked
by the system and sometimes the MDP batch may crash... So depending on the
server
resource limitation and real project needs like yours the pds admin may
have to manage
the MDP creating batch.

But in overall the daily batch is not really required as the modeling
progress of one day
is insignificant in a one year project schedule, but may have significance
during the IFC.

With regards,
Kannan

sviswan@technip.com
Sent by: PipingDesign@yahoogroups.com
02/06/2008 16:47
Please respond to
PipingDesign@yahoogroups.com

To
PipingDesign@yahoogroups.com
cc
sandiveloo@technip.com
Subject
Re: [PipingDesign] Intergraph PDS model interface

Kannan,

Thanks for your input, Pls. see my replies within your mail below.

Siddharthan,

Can you pls. provide an input to this discussion.

Sajit

kannan.sundaram@l
inde-le.com
Sent by: To
PipingDesign@yaho PipingDesign@yahoogroups.com
ogroups.com cc

Subject
02/06/08 04:04 PM Re: [PipingDesign] Intergraph PDS
model interface

Please respond to
PipingDesign@yaho
ogroups.com

The DB is not hidden by Intergraph but restricted by your PDS admin to
prevent people accessing
the information and possible damage the data cause model corruption and
etc. which is a nightmare
to them.

Sajit-----------------
I hope it is so. I am talking of only a read only link, which is the view
as I have said. This cannot do any corruption.
Anyway I will ask again.
-----------------------

Only the graphical information is encrypted in the DB. Even that can be
exploited if you know MDL language.
So nothing is really hidden in PDS for the right person.

The MDP-Material data publisher chart of PDS gives the complete data model
of the model. If you have
simple SQL (Query language) knowledge, and having simple read only access
of this MDP, you can
have any kind of reports generated where only your imagination is your
limits. Sometimes MS Access may
be slow due to the size of model data in projects having higher than
10,000 lines.

Sajit----------------

That is very encouraging.
I should be able to manage the SQL and Access, if this link was available.
---------------------
Another solution is to ask your PDS admin to make some standard queries
made available to you
to have on-line reports.

Another point to mention. You cannot have real status of lines being
modeled. Reason being, even if a
pipe is placed with the attributes, the MDP will account the line is
modeled. The completion of the line
cannot be known unless the modeler does maintain a modeling status
personal log.

Sajit----------------
There is an application called PPMS within PDS to which the designer
enters
the modelling progress %. Nevertheless that is also, as you say, not much
reliable.
--------------------

With regards,
Kannan
Linde, Germany.

sviswan@technip.com
Sent by: PipingDesign@yahoogroups.com
01/06/2008 17:19
Please respond to
PipingDesign@yahoogroups.com

To
PipingDesign@yahoogroups.com
cc

Subject
[PipingDesign] Intergraph PDS model interface

I was wanting to extract information regarding the modelling status of
lines from PDS. This is for use with an Access database to do Isometric
production tracking.

This is currently done by exporting the information as a text file and
then
reading it from the text file into Access table. This is a static method
requiring an export each time one wants an update.

In Oracle / SQL Server database parlance, this is done by creating a view
(query in Access).

I am told by the PDS Admin group that such external links to the model
data
are hidden, intentionally. The reason is that Intergraph does not want
someone to figure out how the data flow happens within and come up with a
competing application.

Sajit

.

__,_._,___