libs/Data/README.html

<HTML>
<HEAD>
<TITLE>Data::Storage</TITLE>
<LINK REV="made" HREF="mailto:">
</HEAD>

<BODY>

<A NAME="__index__"></A>
<!-- INDEX BEGIN -->

<UL>

        <LI><A HREF="#name">NAME</A></LI>
        <LI><A HREF="#aims">AIMS</A></LI>
        <LI><A HREF="#synopsis">SYNOPSIS</A></LI>
        <UL>

                <LI><A HREF="#basic access">BASIC ACCESS</A></LI>
                <LI><A HREF="#advanced access">ADVANCED ACCESS</A></LI>
                <LI><A HREF="#synchronization">SYNCHRONIZATION</A></LI>
                <LI><A HREF="#note">NOTE</A></LI>
        </UL>

        <LI><A HREF="#requirements">REQUIREMENTS</A></LI>
        <LI><A HREF="#description">DESCRIPTION</A></LI>
        <LI><A HREF="#authors / copyright">AUTHORS / COPYRIGHT</A></LI>
        <LI><A HREF="#acknowledgements">ACKNOWLEDGEMENTS</A></LI>
        <LI><A HREF="#support / warranty">SUPPORT / WARRANTY</A></LI>
        <LI><A HREF="#todo">TODO</A></LI>
        <UL>

                <LI><A HREF="#bugs">BUGS</A></LI>
                <LI><A HREF="#features">FEATURES</A></LI>
                <UL>

                        <LI><A HREF="#links / references">LINKS / REFERENCES</A></LI>
                </UL>

        </UL>

</UL>
<!-- INDEX END -->

<HR>
<P>
<H1><A NAME="name">NAME</A></H1>
<P>Data::Storage - Interface for accessing various Storage implementations for Perl in an independent way</P>
<P>
<HR>
<H1><A NAME="aims">AIMS</A></H1>
<PRE>
  - should encapsulate Tangram, DBI, DBD::CSV and LWP:: to access them in an unordinary (more convenient) way ;)
  - introduce a generic layered structure, refactor *SUBLAYER*-stuff, make (e.g.) this possible:
    Perl Data::Storage[DBD::CSV]  -&gt;  Perl LWP::  -&gt;  Internet HTTP/FTP/*  -&gt;  Host Daemon  -&gt;  csv-file
  - provide generic synchronization mechanisms across arbitrary/multiple storages based on ident/checksum
    maybe it's possible to have schema-, structural- and semantical modifications synchronized???</PRE>
<P>
<HR>
<H1><A NAME="synopsis">SYNOPSIS</A></H1>
<P>
<H2><A NAME="basic access">BASIC ACCESS</A></H2>
<P>
<H2><A NAME="advanced access">ADVANCED ACCESS</A></H2>
<PRE>
  ... via inheritance:
</PRE>
<PRE>

    use Data::Storage;
    my $proxyObj = new HttpProxy;
    $proxyObj-&gt;{url} = $url;
    $proxyObj-&gt;{payload} = $content;
    $self-&gt;{storage}-&gt;insert($proxyObj);</PRE>
<PRE>

    use Data::Storage;
    my $proxyObj = HttpProxy-&gt;new(
      url =&gt; $url,
      payload =&gt; $content,
    );
    $self-&gt;{storage}-&gt;insert($proxyObj);</PRE>
<P>
<H2><A NAME="synchronization">SYNCHRONIZATION</A></H2>
<PRE>
  my $nodemapping = {
    'LangText' =&gt; 'langtexts.csv',
    'Currency' =&gt; 'currencies.csv',
    'Country'  =&gt; 'countries.csv',
  };</PRE>
<PRE>
  my $propmapping = {
    'LangText' =&gt; [
      [ 'source:lcountrykey'  =&gt;  'target:country' ],
      [ 'source:lkey'         =&gt;  'target:key' ],
      [ 'source:lvalue'       =&gt;  'target:text' ],
    ],
    'Currency' =&gt; [
      [ 'source:ckey'         =&gt;  'target:key' ],
      [ 'source:cname'        =&gt;  'target:text' ],
    ],
    'Country' =&gt; [
      [ 'source:ckey'         =&gt;  'target:key' ],
      [ 'source:cname'        =&gt;  'target:text' ],
    ],
  };</PRE>
<PRE>
  sub syncResource {</PRE>
<PRE>
    my $self = shift;
    my $node_source = shift;
    my $mode = shift;
    my $opts = shift;
</PRE>
<PRE>

    $mode ||= '';
    $opts-&gt;{erase} ||= 0;</PRE>
<PRE>

    $logger-&gt;info( __PACKAGE__ . &quot;-&gt;syncResource( node_source $node_source mode $mode erase $opts-&gt;{erase} )&quot;);</PRE>
<PRE>

    # resolve metadata for syncing requested resource
    my $node_target = $nodemapping-&gt;{$node_source};
    my $mapping = $propmapping-&gt;{$node_source};</PRE>
<PRE>

    if (!$node_target || !$mapping) {
      # loggger.... &quot;no target, sorry!&quot;
      print &quot;error while resolving resource metadata&quot;, &quot;\n&quot;;
      return;
    }</PRE>
<PRE>

    if ($opts-&gt;{erase}) {
      $self-&gt;_erase_all($node_source);
    }</PRE>
<PRE>

    # create new sync object
    my $sync = Data::Transfer::Sync-&gt;new( 
      storages =&gt; {
        L =&gt; $self-&gt;{bizWorks}-&gt;{backend},
        R =&gt; $self-&gt;{bizWorks}-&gt;{resources},
      },
      id_authorities        =&gt;  [qw( L ) ],
      checksum_authorities  =&gt;  [qw( L ) ],
      write_protected       =&gt;  [qw( R ) ],
      verbose               =&gt;  1,
    );</PRE>
<PRE>

    # sync
    # todo: filter!?
    $sync-&gt;syncNodes( {
      direction       =&gt;  $mode,                 # | +PUSH | +PULL | -FULL | +IMPORT | -EXPORT
      method          =&gt;  'checksum',            # | -timestamp | -manual
      source          =&gt;  &quot;L:$node_source&quot;,
      source_ident    =&gt;  'storage_method:id',
      source_exclude  =&gt;  [qw( id cs )],
      target          =&gt;  &quot;R:$node_target&quot;,
      target_ident    =&gt;  'property:oid',
      mapping         =&gt;  $mapping,
    } );</PRE>
<PRE>
  }</PRE>
<P>
<H2><A NAME="note">NOTE</A></H2>
<P>This module heavily relies on DBI and Tangram, but adds a lot of additional bugs and quirks. 
Please look at their documentation and/or this code for additional information.</P>
<P>
<HR>
<H1><A NAME="requirements">REQUIREMENTS</A></H1>
<PRE>
  For full functionality:
    DBI              from CPAN
    DBD::mysql       from CPAN
    Tangram 2.04     from CPAN         (hmmm, 2.04 won't do in some cases)
    Tangram 2.05     from <A HREF="http://">http://</A>...   (2.05 seems okay but there are also additional patches from our side)
    Class::Tangram   from CPAN
    DBD::CSV         from CPAN
    MySQL::Diff      from <A HREF="http://adamspiers.org/computing/mysqldiff/">http://adamspiers.org/computing/mysqldiff/</A>
    ... and all their dependencies</PRE>
<P>
<HR>
<H1><A NAME="description">DESCRIPTION</A></H1>
<P>Data::Storage is a module for accessing various ``data structures'' stored inside
various ``data containers''. It sits on top of DBI and/or Tangram.</P>
<P>
<HR>
<H1><A NAME="authors / copyright">AUTHORS / COPYRIGHT</A></H1>
<P>The Data::Storage module is Copyright (c) 2002 Andreas Motl.
All rights reserved.</P>
<P>You may distribute it under the terms of either the GNU General Public
License or the Artistic License, as specified in the Perl README file.</P>
<P>
<HR>
<H1><A NAME="acknowledgements">ACKNOWLEDGEMENTS</A></H1>
<P>Larry Wall for Perl, Tim Bunce for DBI, Jean-Louis Leroy for Tangram and Set::Object, 
Sam Vilain for Class::Tangram, Jochen Wiedmann and Jeff Zucker for DBD::CSV and related,
Adam Spiers for MySQL::Diff and all contributors.</P>
<P>
<HR>
<H1><A NAME="support / warranty">SUPPORT / WARRANTY</A></H1>
<P>Data::Storage is free software. IT COMES WITHOUT WARRANTY OF ANY KIND.</P>
<P>
<HR>
<H1><A NAME="todo">TODO</A></H1>
<P>
<H2><A NAME="bugs">BUGS</A></H2>
<P>``DBI-Error [Tangram]: DBD::mysql::st execute failed: Unknown column 't1.requestdump' in 'field list'''</P>
<PRE>
  ... occours when operating on object-attributes not introduced yet:
  this should be detected and appended/replaced through:
  &quot;Schema-Error detected, maybe (just) an inconsistency. 
  Please check if your declaration in schema-module &quot;a&quot; matches structure in database &quot;b&quot; or try to run&quot;
  db_setup.pl --dbkey=import --action=deploy</PRE>
<P>Compare schema (structure diff) with database ...</P>
<PRE>
  ... when issuing &quot;db_setup.pl --dbkey=import --action=deploy&quot;
  on a database with an already deployed schema, use an additional &quot;--update&quot; then
  to lift the schema inside the database to the current declared schema.
  You will have to approve removals and changes on field-level while
  new objects and new fields are introduced silently without any interaction needed.
  In future versions there may be additional options to control silent processing of
  removals and changes.
  See this CRUD-table applying to the actions occouring on Classes and Class variables when deploying schemas,
  don't mix this up with CRUD-actions on Objects, these are already handled by (e.g.) Tangram itself.
  Classes:
    C create    -&gt;  yes, handled automatically
    R retrieve  -&gt;  no, not subject of this aspect since it is about deployment only
    U update    -&gt;  yes, automatically for Class meta-attributes, yes/no for Class variables (look at the rules down here)
    D delete    -&gt;  yes, just by user-interaction
  Class variables:
    C create    -&gt;  yes, handled automatically
    R retrieve  -&gt;  no, not subject of this aspect since it is about deployment only
    U update    -&gt;  yes, just by user-interaction; maybe automatically if it can be determined that data wouldn't be lost
    D delete    -&gt;  yes, just by user-interaction
</PRE>
<PRE>

  It's all about not to be able to loose data simply while this is in pre-alpha stage.
  And loosing data by being able to modify and redeploy schemas easily is definitely quite easy.</PRE>
<PRE>

  As we can see, creations of Classes and new Class variables is handled 
  automatically and this is believed to be the most common case under normal circumstances.</PRE>
<P>
<H2><A NAME="features">FEATURES</A></H2>
<PRE>
  - Get this stuff together with UML (Unified Modeling Language) and/or standards from ODMG.
  - Make it possible to load/save schemas in XMI (XML Metadata Interchange), 
    which seems to be most commonly used today, perhaps handle objects with OIFML.
    Integrate/bundle this with a web-/html-based UML modeling tool or 
    some other interesting stuff like the &quot;Co-operative UML Editor&quot; from Uni Darmstadt. (web-/java-based)
  - Enable Round Trip Engineering. Keep code and diagrams in sync. Don't annoy/bother the programmers.
  - Add support for some more handlers/locators to be able to 
     access the following standards/protocols/interfaces/programs/apis transparently:
    +  DBD::CSV (via Data::Storage::Handler::DBI)
   (-) Text::CSV, XML::CSV, XML::Excel
    -  MAPI
    -  LDAP
    -  DAV (look at PerlDAV: <A HREF="http://www.webdav.org/perldav/">http://www.webdav.org/perldav/</A>)
    -  Mbox (use formail for seperating/splitting entries/nodes)
    -  Cyrus (cyrdeliver - what about cyrretrieve (export)???)
    -  use File::DiffTree, use File::Compare
    -  Hibernate
    -  &quot;Win32::UserAccountDb&quot;
    -  &quot;*nix::UserAccountDb&quot;
    -  .wab - files (Windows Address Book)
    -  .pst - files (Outlook Post Storage?)
    -  XML (e.g. via XML::Simple?)
  - Move to t3, look at InCASE</PRE>
<P>
<H3><A NAME="links / references">LINKS / REFERENCES</A></H3>
<PRE>
  Specs:
    UML 1.3 Spec: <A HREF="http://cgi.omg.org/cgi-bin/doc?ad/99-06-08.pdf">http://cgi.omg.org/cgi-bin/doc?ad/99-06-08.pdf</A>
    XMI 1.1 Spec: <A HREF="http://cgi.omg.org/cgi-bin/doc?ad/99-10-02.pdf">http://cgi.omg.org/cgi-bin/doc?ad/99-10-02.pdf</A>
    XMI 2.0 Spec: <A HREF="http://cgi.omg.org/docs/ad/01-06-12.pdf">http://cgi.omg.org/docs/ad/01-06-12.pdf</A>
    ODMG: <A HREF="http://odmg.org/">http://odmg.org/</A>
    OIFML: <A HREF="http://odmg.org/library/readingroom/oifml.pdf">http://odmg.org/library/readingroom/oifml.pdf</A></PRE>
<PRE>
  CASE Tools:
    Rational Rose (commercial): <A HREF="http://www.rational.com/products/rose/">http://www.rational.com/products/rose/</A>
    Together (commercial): <A HREF="http://www.oi.com/products/controlcenter/index.jsp">http://www.oi.com/products/controlcenter/index.jsp</A>
    InCASE - Tangram-based Universal Object Editor 
    Sybase PowerDesigner: <A HREF="http://www.sybase.com/powerdesigner">http://www.sybase.com/powerdesigner</A>
</PRE>
<PRE>

  UML Editors:
    Fujaba (free, university): <A HREF="http://www.fujaba.de/">http://www.fujaba.de/</A>
    ArgoUML (free): <A HREF="http://argouml.tigris.org/">http://argouml.tigris.org/</A>
    Poseidon (commercial): <A HREF="http://www.gentleware.com/products/poseidonDE.php3">http://www.gentleware.com/products/poseidonDE.php3</A>
    Co-operative UML Editor (research): <A HREF="http://www.darmstadt.gmd.de/concert/activities/internal/umledit.html">http://www.darmstadt.gmd.de/concert/activities/internal/umledit.html</A>
    Metamill (commercial): <A HREF="http://www.metamill.com/">http://www.metamill.com/</A>
    Violet (university, research, education): <A HREF="http://www.horstmann.com/violet/">http://www.horstmann.com/violet/</A>
    PyUt (free): <A HREF="http://pyut.sourceforge.net/">http://pyut.sourceforge.net/</A>
    (Dia (free): <A HREF="http://www.lysator.liu.se/~alla/dia/">http://www.lysator.liu.se/~alla/dia/</A>)
    UMLet (free, university): <A HREF="http://www.swt.tuwien.ac.at/umlet/index.html">http://www.swt.tuwien.ac.at/umlet/index.html</A>
    Voodoo (free): <A HREF="http://voodoo.sourceforge.net/">http://voodoo.sourceforge.net/</A>
    Umbrello UML Modeller: <A HREF="http://uml.sourceforge.net/">http://uml.sourceforge.net/</A></PRE>
<PRE>
  UML Tools:
    <A HREF="http://www.objectsbydesign.com/tools/umltools_byPrice.html">http://www.objectsbydesign.com/tools/umltools_byPrice.html</A></PRE>
<PRE>
  Further readings:
    <A HREF="http://www.google.com/search?q=web+based+uml+editor&amp">http://www.google.com/search?q=web+based+uml+editor&amp</A>;hl=en&amp;lr=&amp;ie=UTF-8&amp;oe=UTF-8&amp;start=10&amp;sa=N
    <A HREF="http://www.fernuni-hagen.de/DVT/Aktuelles/01FHHeidelberg.pdf">http://www.fernuni-hagen.de/DVT/Aktuelles/01FHHeidelberg.pdf</A>
    <A HREF="http://www.enhyper.com/src/documentation/">http://www.enhyper.com/src/documentation/</A>
    <A HREF="http://cis.cs.tu-berlin.de/Dokumente/Diplomarbeiten/2001/skinner.pdf">http://cis.cs.tu-berlin.de/Dokumente/Diplomarbeiten/2001/skinner.pdf</A>
    <A HREF="http://citeseer.nj.nec.com/vilain00diagrammatic.html">http://citeseer.nj.nec.com/vilain00diagrammatic.html</A>
    <A HREF="http://archive.devx.com/uml/articles/Smith01/Smith01-3.asp">http://archive.devx.com/uml/articles/Smith01/Smith01-3.asp</A></PRE>

</BODY>

</HTML>
1	joko	1.1	<HTML>
2			<HEAD>
3			<TITLE>Data::Storage</TITLE>
4			<LINK REV="made" HREF="mailto:">
5			</HEAD>
6
7			<BODY>
8
9			<A NAME="__index__"></A>
10			<!-- INDEX BEGIN -->
11
12			<UL>
13
14			<LI><A HREF="#name">NAME</A></LI>
15	joko	1.4	<LI><A HREF="#aims">AIMS</A></LI>
16	joko	1.1	<LI><A HREF="#synopsis">SYNOPSIS</A></LI>
17			<UL>
18
19	joko	1.4	<LI><A HREF="#basic access">BASIC ACCESS</A></LI>
20			<LI><A HREF="#advanced access">ADVANCED ACCESS</A></LI>
21			<LI><A HREF="#synchronization">SYNCHRONIZATION</A></LI>
22	joko	1.1	<LI><A HREF="#note">NOTE</A></LI>
23			</UL>
24
25	joko	1.3	<LI><A HREF="#requirements">REQUIREMENTS</A></LI>
26	joko	1.1	<LI><A HREF="#description">DESCRIPTION</A></LI>
27			<LI><A HREF="#authors / copyright">AUTHORS / COPYRIGHT</A></LI>
28			<LI><A HREF="#acknowledgements">ACKNOWLEDGEMENTS</A></LI>
29			<LI><A HREF="#support / warranty">SUPPORT / WARRANTY</A></LI>
30			<LI><A HREF="#todo">TODO</A></LI>
31			<UL>
32
33	joko	1.4	<LI><A HREF="#bugs">BUGS</A></LI>
34			<LI><A HREF="#features">FEATURES</A></LI>
35	joko	1.1	<UL>
36
37	joko	1.4	<LI><A HREF="#links / references">LINKS / REFERENCES</A></LI>
38	joko	1.1	</UL>
39
40			</UL>
41
42			</UL>
43			<!-- INDEX END -->
44
45			<HR>
46			<P>
47			<H1><A NAME="name">NAME</A></H1>
48			<P>Data::Storage - Interface for accessing various Storage implementations for Perl in an independent way</P>
49			<P>
50			<HR>
51	joko	1.4	<H1><A NAME="aims">AIMS</A></H1>
52			<PRE>
53			- should encapsulate Tangram, DBI, DBD::CSV and LWP:: to access them in an unordinary (more convenient) way ;)
54			- introduce a generic layered structure, refactor SUBLAYER-stuff, make (e.g.) this possible:
55			Perl Data::Storage[DBD::CSV] -> Perl LWP:: -> Internet HTTP/FTP/* -> Host Daemon -> csv-file
56			- provide generic synchronization mechanisms across arbitrary/multiple storages based on ident/checksum
57			maybe it's possible to have schema-, structural- and semantical modifications synchronized???</PRE>
58			<P>
59			<HR>
60	joko	1.1	<H1><A NAME="synopsis">SYNOPSIS</A></H1>
61	joko	1.4	<P>
62			<H2><A NAME="basic access">BASIC ACCESS</A></H2>
63			<P>
64			<H2><A NAME="advanced access">ADVANCED ACCESS</A></H2>
65	joko	1.1	<PRE>
66			... via inheritance:
67			</PRE>
68			<PRE>
69
70			use Data::Storage;
71			my $proxyObj = new HttpProxy;
72			$proxyObj->{url} = $url;
73			$proxyObj->{payload} = $content;
74			$self->{storage}->insert($proxyObj);</PRE>
75			<PRE>
76
77			use Data::Storage;
78			my $proxyObj = HttpProxy->new(
79			url => $url,
80			payload => $content,
81			);
82			$self->{storage}->insert($proxyObj);</PRE>
83			<P>
84	joko	1.4	<H2><A NAME="synchronization">SYNCHRONIZATION</A></H2>
85			<PRE>
86			my $nodemapping = {
87			'LangText' => 'langtexts.csv',
88			'Currency' => 'currencies.csv',
89			'Country' => 'countries.csv',
90			};</PRE>
91			<PRE>
92			my $propmapping = {
93			'LangText' => [
94			[ 'source:lcountrykey' => 'target:country' ],
95			[ 'source:lkey' => 'target:key' ],
96			[ 'source:lvalue' => 'target:text' ],
97			],
98			'Currency' => [
99			[ 'source:ckey' => 'target:key' ],
100			[ 'source:cname' => 'target:text' ],
101			],
102			'Country' => [
103			[ 'source:ckey' => 'target:key' ],
104			[ 'source:cname' => 'target:text' ],
105			],
106			};</PRE>
107			<PRE>
108			sub syncResource {</PRE>
109			<PRE>
110			my $self = shift;
111			my $node_source = shift;
112			my $mode = shift;
113			my $opts = shift;
114			</PRE>
115			<PRE>
116
117			$mode \|\|= '';
118			$opts->{erase} \|\|= 0;</PRE>
119			<PRE>
120
121			$logger->info( __PACKAGE__ . "->syncResource( node_source $node_source mode $mode erase $opts->{erase} )");</PRE>
122			<PRE>
123
124			# resolve metadata for syncing requested resource
125			my $node_target = $nodemapping->{$node_source};
126			my $mapping = $propmapping->{$node_source};</PRE>
127			<PRE>
128
129			if (!$node_target \|\| !$mapping) {
130			# loggger.... "no target, sorry!"
131			print "error while resolving resource metadata", "\n";
132			return;
133			}</PRE>
134			<PRE>
135
136			if ($opts->{erase}) {
137			$self->_erase_all($node_source);
138			}</PRE>
139			<PRE>
140
141			# create new sync object
142			my $sync = Data::Transfer::Sync->new(
143			storages => {
144			L => $self->{bizWorks}->{backend},
145			R => $self->{bizWorks}->{resources},
146			},
147			id_authorities => [qw( L ) ],
148			checksum_authorities => [qw( L ) ],
149			write_protected => [qw( R ) ],
150			verbose => 1,
151			);</PRE>
152			<PRE>
153
154			# sync
155			# todo: filter!?
156			$sync->syncNodes( {
157			direction => $mode, # \| +PUSH \| +PULL \| -FULL \| +IMPORT \| -EXPORT
158			method => 'checksum', # \| -timestamp \| -manual
159			source => "L:$node_source",
160			source_ident => 'storage_method:id',
161			source_exclude => [qw( id cs )],
162			target => "R:$node_target",
163			target_ident => 'property:oid',
164			mapping => $mapping,
165			} );</PRE>
166			<PRE>
167			}</PRE>
168			<P>
169	joko	1.1	<H2><A NAME="note">NOTE</A></H2>
170			<P>This module heavily relies on DBI and Tangram, but adds a lot of additional bugs and quirks.
171	joko	1.3	Please look at their documentation and/or this code for additional information.</P>
172			<P>
173			<HR>
174			<H1><A NAME="requirements">REQUIREMENTS</A></H1>
175	joko	1.4	<PRE>
176			For full functionality:
177			DBI from CPAN
178			DBD::mysql from CPAN
179			Tangram 2.04 from CPAN (hmmm, 2.04 won't do in some cases)
180			Tangram 2.05 from <A HREF="http://">http://</A>... (2.05 seems okay but there are also additional patches from our side)
181			Class::Tangram from CPAN
182			DBD::CSV from CPAN
183			MySQL::Diff from <A HREF="http://adamspiers.org/computing/mysqldiff/">http://adamspiers.org/computing/mysqldiff/</A>
184			... and all their dependencies</PRE>
185	joko	1.1	<P>
186			<HR>
187			<H1><A NAME="description">DESCRIPTION</A></H1>
188	joko	1.4	<P>Data::Storage is a module for accessing various ``data structures'' stored inside
189	joko	1.1	various ``data containers''. It sits on top of DBI and/or Tangram.</P>
190			<P>
191			<HR>
192			<H1><A NAME="authors / copyright">AUTHORS / COPYRIGHT</A></H1>
193			<P>The Data::Storage module is Copyright (c) 2002 Andreas Motl.
194			All rights reserved.</P>
195			<P>You may distribute it under the terms of either the GNU General Public
196			License or the Artistic License, as specified in the Perl README file.</P>
197			<P>
198			<HR>
199			<H1><A NAME="acknowledgements">ACKNOWLEDGEMENTS</A></H1>
200	joko	1.3	<P>Larry Wall for Perl, Tim Bunce for DBI, Jean-Louis Leroy for Tangram and Set::Object,
201	joko	1.4	Sam Vilain for Class::Tangram, Jochen Wiedmann and Jeff Zucker for DBD::CSV and related,
202			Adam Spiers for MySQL::Diff and all contributors.</P>
203	joko	1.1	<P>
204			<HR>
205			<H1><A NAME="support / warranty">SUPPORT / WARRANTY</A></H1>
206			<P>Data::Storage is free software. IT COMES WITHOUT WARRANTY OF ANY KIND.</P>
207			<P>
208			<HR>
209			<H1><A NAME="todo">TODO</A></H1>
210			<P>
211	joko	1.4	<H2><A NAME="bugs">BUGS</A></H2>
212			<P>``DBI-Error [Tangram]: DBD::mysql::st execute failed: Unknown column 't1.requestdump' in 'field list'''</P>
213	joko	1.1	<PRE>
214	joko	1.4	... occours when operating on object-attributes not introduced yet:
215			this should be detected and appended/replaced through:
216			"Schema-Error detected, maybe (just) an inconsistency.
217			Please check if your declaration in schema-module "a" matches structure in database "b" or try to run"
218			db_setup.pl --dbkey=import --action=deploy</PRE>
219			<P>Compare schema (structure diff) with database ...</P>
220	joko	1.1	<PRE>
221			... when issuing "db_setup.pl --dbkey=import --action=deploy"
222			on a database with an already deployed schema, use an additional "--update" then
223			to lift the schema inside the database to the current declared schema.
224			You will have to approve removals and changes on field-level while
225			new objects and new fields are introduced silently without any interaction needed.
226			In future versions there may be additional options to control silent processing of
227			removals and changes.
228			See this CRUD-table applying to the actions occouring on Classes and Class variables when deploying schemas,
229			don't mix this up with CRUD-actions on Objects, these are already handled by (e.g.) Tangram itself.
230			Classes:
231			C create -> yes, handled automatically
232			R retrieve -> no, not subject of this aspect since it is about deployment only
233			U update -> yes, automatically for Class meta-attributes, yes/no for Class variables (look at the rules down here)
234			D delete -> yes, just by user-interaction
235			Class variables:
236			C create -> yes, handled automatically
237			R retrieve -> no, not subject of this aspect since it is about deployment only
238			U update -> yes, just by user-interaction; maybe automatically if it can be determined that data wouldn't be lost
239			D delete -> yes, just by user-interaction
240	joko	1.2	</PRE>
241			<PRE>
242
243			It's all about not to be able to loose data simply while this is in pre-alpha stage.
244			And loosing data by being able to modify and redeploy schemas easily is definitely quite easy.</PRE>
245			<PRE>
246
247			As we can see, creations of Classes and new Class variables is handled
248			automatically and this is believed to be the most common case under normal circumstances.</PRE>
249	joko	1.1	<P>
250	joko	1.4	<H2><A NAME="features">FEATURES</A></H2>
251	joko	1.1	<PRE>
252	joko	1.2	- Get this stuff together with UML (Unified Modeling Language) and/or standards from ODMG.
253			- Make it possible to load/save schemas in XMI (XML Metadata Interchange),
254			which seems to be most commonly used today, perhaps handle objects with OIFML.
255			Integrate/bundle this with a web-/html-based UML modeling tool or
256			some other interesting stuff like the "Co-operative UML Editor" from Uni Darmstadt. (web-/java-based)
257			- Enable Round Trip Engineering. Keep code and diagrams in sync. Don't annoy/bother the programmers.
258	joko	1.4	- Add support for some more handlers/locators to be able to
259			access the following standards/protocols/interfaces/programs/apis transparently:
260			+ DBD::CSV (via Data::Storage::Handler::DBI)
261			(-) Text::CSV, XML::CSV, XML::Excel
262			- MAPI
263			- LDAP
264			- DAV (look at PerlDAV: <A HREF="http://www.webdav.org/perldav/">http://www.webdav.org/perldav/</A>)
265			- Mbox (use formail for seperating/splitting entries/nodes)
266			- Cyrus (cyrdeliver - what about cyrretrieve (export)???)
267			- use File::DiffTree, use File::Compare
268			- Hibernate
269			- "Win32::UserAccountDb"
270			- "*nix::UserAccountDb"
271			- .wab - files (Windows Address Book)
272			- .pst - files (Outlook Post Storage?)
273			- XML (e.g. via XML::Simple?)
274			- Move to t3, look at InCASE</PRE>
275	joko	1.1	<P>
276	joko	1.4	<H3><A NAME="links / references">LINKS / REFERENCES</A></H3>
277	joko	1.1	<PRE>
278	joko	1.2	Specs:
279	joko	1.1	UML 1.3 Spec: <A HREF="http://cgi.omg.org/cgi-bin/doc?ad/99-06-08.pdf">http://cgi.omg.org/cgi-bin/doc?ad/99-06-08.pdf</A>
280			XMI 1.1 Spec: <A HREF="http://cgi.omg.org/cgi-bin/doc?ad/99-10-02.pdf">http://cgi.omg.org/cgi-bin/doc?ad/99-10-02.pdf</A>
281			XMI 2.0 Spec: <A HREF="http://cgi.omg.org/docs/ad/01-06-12.pdf">http://cgi.omg.org/docs/ad/01-06-12.pdf</A>
282			ODMG: <A HREF="http://odmg.org/">http://odmg.org/</A>
283	joko	1.2	OIFML: <A HREF="http://odmg.org/library/readingroom/oifml.pdf">http://odmg.org/library/readingroom/oifml.pdf</A></PRE>
284			<PRE>
285			CASE Tools:
286			Rational Rose (commercial): <A HREF="http://www.rational.com/products/rose/">http://www.rational.com/products/rose/</A>
287			Together (commercial): <A HREF="http://www.oi.com/products/controlcenter/index.jsp">http://www.oi.com/products/controlcenter/index.jsp</A>
288			InCASE - Tangram-based Universal Object Editor
289			Sybase PowerDesigner: <A HREF="http://www.sybase.com/powerdesigner">http://www.sybase.com/powerdesigner</A>
290			</PRE>
291	joko	1.1	<PRE>
292	joko	1.2
293			UML Editors:
294			Fujaba (free, university): <A HREF="http://www.fujaba.de/">http://www.fujaba.de/</A>
295			ArgoUML (free): <A HREF="http://argouml.tigris.org/">http://argouml.tigris.org/</A>
296			Poseidon (commercial): <A HREF="http://www.gentleware.com/products/poseidonDE.php3">http://www.gentleware.com/products/poseidonDE.php3</A>
297			Co-operative UML Editor (research): <A HREF="http://www.darmstadt.gmd.de/concert/activities/internal/umledit.html">http://www.darmstadt.gmd.de/concert/activities/internal/umledit.html</A>
298			Metamill (commercial): <A HREF="http://www.metamill.com/">http://www.metamill.com/</A>
299			Violet (university, research, education): <A HREF="http://www.horstmann.com/violet/">http://www.horstmann.com/violet/</A>
300			PyUt (free): <A HREF="http://pyut.sourceforge.net/">http://pyut.sourceforge.net/</A>
301			(Dia (free): <A HREF="http://www.lysator.liu.se/~alla/dia/">http://www.lysator.liu.se/~alla/dia/</A>)
302			UMLet (free, university): <A HREF="http://www.swt.tuwien.ac.at/umlet/index.html">http://www.swt.tuwien.ac.at/umlet/index.html</A>
303	joko	1.3	Voodoo (free): <A HREF="http://voodoo.sourceforge.net/">http://voodoo.sourceforge.net/</A>
304			Umbrello UML Modeller: <A HREF="http://uml.sourceforge.net/">http://uml.sourceforge.net/</A></PRE>
305	joko	1.2	<PRE>
306			UML Tools:
307			<A HREF="http://www.objectsbydesign.com/tools/umltools_byPrice.html">http://www.objectsbydesign.com/tools/umltools_byPrice.html</A></PRE>
308			<PRE>
309			Further readings:
310	joko	1.1	<A HREF="http://www.google.com/search?q=web+based+uml+editor&amp">http://www.google.com/search?q=web+based+uml+editor&amp</A>;hl=en&lr=&ie=UTF-8&oe=UTF-8&start=10&sa=N
311			<A HREF="http://www.fernuni-hagen.de/DVT/Aktuelles/01FHHeidelberg.pdf">http://www.fernuni-hagen.de/DVT/Aktuelles/01FHHeidelberg.pdf</A>
312			<A HREF="http://www.enhyper.com/src/documentation/">http://www.enhyper.com/src/documentation/</A>
313			<A HREF="http://cis.cs.tu-berlin.de/Dokumente/Diplomarbeiten/2001/skinner.pdf">http://cis.cs.tu-berlin.de/Dokumente/Diplomarbeiten/2001/skinner.pdf</A>
314			<A HREF="http://citeseer.nj.nec.com/vilain00diagrammatic.html">http://citeseer.nj.nec.com/vilain00diagrammatic.html</A>
315			<A HREF="http://archive.devx.com/uml/articles/Smith01/Smith01-3.asp">http://archive.devx.com/uml/articles/Smith01/Smith01-3.asp</A></PRE>
316
317			</BODY>
318
319			</HTML>
MailToCvsAdmin">MailToCvsAdmin	ViewVC Help
Powered by ViewVC 1.1.26