Re: Question on Moose

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Re: Question on Moose

abergel
So far no. I have worked with databases, so I cannot recommend anything.
However, if you can extract the data "by hand" and produce a textual file (or even better, an XML file), then the battle will be easily win.

Alexandre


On 28 Apr 2011, at 07:35, Torsten Bergmann wrote:

> Hi Alexandre,
>
> short question about Moose/Mondrian: is there an adaptor
> to visualize PL/SQL (Oracles database language).
>
> Thx
> Torsten
> --
> Empfehlen Sie GMX DSL Ihren Freunden und Bekannten und wir
> belohnen Sie mit bis zu 50,- Euro! https://freundschaftswerbung.gmx.de

--
_,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:
Alexandre Bergel  http://www.bergel.eu
^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;.





_______________________________________________
Moose-dev mailing list
[hidden email]
https://www.iam.unibe.ch/mailman/listinfo/moose-dev
Reply | Threaded
Open this post in threaded view
|

Re: Question on Moose

Tudor Girba
Hi Torsten,

There is no complete out-of-the-box solution, but from what I understand you would need:
- an PL/SQL parser
- an PL/SQL meta-model
- visualizations of models

There is an SQL parser in PetitSQL project based on PetitParser:
http://www.squeaksource.com/PetitSQLParser.html

Perhaps this can be a starting point. But, then the question is what exactly you want to capture in the meta-model from these programs, and what you want to visualize.

In many cases, you only need to extract a part of the information for a specific view.

Cheers,
Doru


On 28 Apr 2011, at 14:42, Alexandre Bergel wrote:

> So far no. I have worked with databases, so I cannot recommend anything.
> However, if you can extract the data "by hand" and produce a textual file (or even better, an XML file), then the battle will be easily win.
>
> Alexandre
>
>
> On 28 Apr 2011, at 07:35, Torsten Bergmann wrote:
>
>> Hi Alexandre,
>>
>> short question about Moose/Mondrian: is there an adaptor
>> to visualize PL/SQL (Oracles database language).
>>
>> Thx
>> Torsten
>> --
>> Empfehlen Sie GMX DSL Ihren Freunden und Bekannten und wir
>> belohnen Sie mit bis zu 50,- Euro! https://freundschaftswerbung.gmx.de
>
> --
> _,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:
> Alexandre Bergel  http://www.bergel.eu
> ^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;.
>
>
>
>
>
> _______________________________________________
> Moose-dev mailing list
> [hidden email]
> https://www.iam.unibe.ch/mailman/listinfo/moose-dev

--
www.tudorgirba.com

"No matter how many recipes we know, we still value a chef."







_______________________________________________
Moose-dev mailing list
[hidden email]
https://www.iam.unibe.ch/mailman/listinfo/moose-dev
Reply | Threaded
Open this post in threaded view
|

Re: Question on Moose

Fabrizio Perin
In reply to this post by abergel
Hi Torsten,
i did not get what you mean with visualize PL/SQL but MooseJEE have some feature that might help. You can find a SQL parser based on Petit Parser and a meta-model for relational databases. So what you can do is instantiate a model of a database starting form it's creation script in sql and than you can play with the model as you like.

I don't know if this can help but if it does i can give you more details.

You can find MooseJEE here:
http://hudson.moosetechnology.org/job/moosejee-latest-dev/

The PetitSQLParser should be standard in Moose already.

Cheers,

Fabrizio

On 28 Apr 2011, at 14:42, Alexandre Bergel wrote:

> So far no. I have worked with databases, so I cannot recommend anything.
> However, if you can extract the data "by hand" and produce a textual file (or even better, an XML file), then the battle will be easily win.
>
> Alexandre
>
>
> On 28 Apr 2011, at 07:35, Torsten Bergmann wrote:
>
>> Hi Alexandre,
>>
>> short question about Moose/Mondrian: is there an adaptor
>> to visualize PL/SQL (Oracles database language).
>>
>> Thx
>> Torsten
>> --
>> Empfehlen Sie GMX DSL Ihren Freunden und Bekannten und wir
>> belohnen Sie mit bis zu 50,- Euro! https://freundschaftswerbung.gmx.de
>
> --
> _,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:
> Alexandre Bergel  http://www.bergel.eu
> ^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;.
>
>
>
>
>
> _______________________________________________
> Moose-dev mailing list
> [hidden email]
> https://www.iam.unibe.ch/mailman/listinfo/moose-dev


_______________________________________________
Moose-dev mailing list
[hidden email]
https://www.iam.unibe.ch/mailman/listinfo/moose-dev
Reply | Threaded
Open this post in threaded view
|

Fwd: Re: Question on Moose

abergel
I do not know whether or not Torsten is in the mailing list

Cheers,
Alexandre

Begin forwarded message:

> From: Fabrizio Perin <[hidden email]>
> Date: 28 April 2011 08:06:24 GMT-04:00
> To: Moose-related development <[hidden email]>
> Subject: [Moose-dev] Re: Question on Moose
> Reply-To: Moose-related development <[hidden email]>
>
> Hi Torsten,
> i did not get what you mean with visualize PL/SQL but MooseJEE have some feature that might help. You can find a SQL parser based on Petit Parser and a meta-model for relational databases. So what you can do is instantiate a model of a database starting form it's creation script in sql and than you can play with the model as you like.
>
> I don't know if this can help but if it does i can give you more details.
>
> You can find MooseJEE here:
> http://hudson.moosetechnology.org/job/moosejee-latest-dev/
>
> The PetitSQLParser should be standard in Moose already.
>
> Cheers,
>
> Fabrizio
>
> On 28 Apr 2011, at 14:42, Alexandre Bergel wrote:
>
>> So far no. I have worked with databases, so I cannot recommend anything.
>> However, if you can extract the data "by hand" and produce a textual file (or even better, an XML file), then the battle will be easily win.
>>
>> Alexandre
>>
>>
>> On 28 Apr 2011, at 07:35, Torsten Bergmann wrote:
>>
>>> Hi Alexandre,
>>>
>>> short question about Moose/Mondrian: is there an adaptor
>>> to visualize PL/SQL (Oracles database language).
>>>
>>> Thx
>>> Torsten
>>> --
>>> Empfehlen Sie GMX DSL Ihren Freunden und Bekannten und wir
>>> belohnen Sie mit bis zu 50,- Euro! https://freundschaftswerbung.gmx.de
>>
>> --
>> _,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:
>> Alexandre Bergel  http://www.bergel.eu
>> ^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;.
>>
>>
>>
>>
>>
>> _______________________________________________
>> Moose-dev mailing list
>> [hidden email]
>> https://www.iam.unibe.ch/mailman/listinfo/moose-dev
>
>
> _______________________________________________
> Moose-dev mailing list
> [hidden email]
> https://www.iam.unibe.ch/mailman/listinfo/moose-dev

--
_,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:
Alexandre Bergel  http://www.bergel.eu
^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;.





_______________________________________________
Moose-dev mailing list
[hidden email]
https://www.iam.unibe.ch/mailman/listinfo/moose-dev