Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » XML/Relational Mapping (XRM) Model contribution to Eclipse DTP
XML/Relational Mapping (XRM) Model contribution to Eclipse DTP [message #371] Tue, 31 May 2005 16:37 Go to next message
Eclipse UserFriend
Originally posted by: ale.hitsw.com

Dear Eclipse Community,

we are very excited to start contributing to the Eclipse DTP project and
apply our expertise in XML/Relational Mapping, a technical area we have been
focused on for over 5 years. Here is the abstract for our contribution:

============================================================ =======

XML/Relational Mapping (XRM) Model

Giving the growing presence and importance of XML, the need for a
comprehensive mapping between XML and relational structures is vital in
data-centric application development. While there are alternatives such as
XSLT, no general solution meets all of the needs of XRM. Further, XRM should
express the mapping in terms appropriate to its problem domain, not the
underlying implementation technology. To meet these requirements, the XRM
Model component provide an EMF model with all the necessary data definitions
to fully characterize mapping elements and configurations between any XML
document and any relational database.

============================================================ ========

About HiT Software, Inc.

HiT Software is a leading developer of standards-based products for
relational database access. HiT Software products include Allora XML-RDB
run-time transformation middleware, DBMoto data replication, SQL middleware
products for IBM DB2 access, and SafeConduct for secure Internet and
intranet communications.

Founded in 1994, HiT Software is based in San Jose, California, and is a
member of the World Wide Web Consortium (W3C). HiT Software products are
sold and serviced worldwide by the HiT Software direct sales team,
international subsidiaries, and authorized channel partners. Additional
information is available at www.hitsw.com, by sending e-mail to
info@hitsw.com, or by calling (408) 345-4001.

============================================================ ========

I have also included answers to two questions that a few members have
already asked us after gathering their feedback about our proposal.

(1) If a developer created an instance of the mapping model, then how would
that data be used at run time? That is, while we could define such a map at
development time, what sorts of components are required for run time
consumption of this mapping data? Are there open source components in this
area?

Once a developer has created an instance of the mapping model as defined in
Eclipse DTP, he can use the Allora Java APIs to import or export XML from
and to a relational database in one method call. The Java Allora run-time
engine that processes the mapping model is not currently open-source however
we encourage open-source initiatives to develop APIs that are compatible
with this comprehensive data model.

(2) Can we open source the definition of the model (perhaps as an XML Schema
or UML diagram), and then review it to get community feedback?

Yes, our intention is to give the open-source Eclipse community the
definition of the XML-to-RDB mapping model and welcome any suggestions, or
improvements to this model. We have been continuously improving our data
mapping model from customers' feedback over the last 5 years and we believe
that this open-source initiative will help us perfect this model. Leading
design tools like PowerDesigner are already embracing this model and are
able to create it directly from their design modeling tool.

============================================================ ========

We are looking forward to hearing from you,

Ale Gicqueau
XML-to-RDB technical evangelist
HiT Software - http://www.hitsw.com
Tel (408) 345 4009
Cel (408) 771 4957
Re: XML/Relational Mapping (XRM) Model contribution to Eclipse DTP [message #378 is a reply to message #371] Wed, 01 June 2005 20:44 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: rgreene.versant.com

Hi Ale,

Seems like what you are wanting to do is very similar to what is being done
in the ORM proposal. Except it is mapping to XML instead of Java Objects
and the runtime is Allora instead of a JSR220 runtime. I agree that dealing
with XML is becoming increasingly important, so I think it is a great
potential addition to the DTP. As we discovered in the ORM project, you
will discover that there is a lot of what you need to do which puts you in
the consumer position. This is because Eclipse is a "platform" that needs
to be founded on common frameworks and reduce overlap as much as possible.

What we found in ORM is that to be a good citizen we needed to remove our
code that was doing database definition/connection work, query builder,
relational database meta data retrieval, etc and work with the DTP code
components that were targeted to fulfill those functions and extend them
where they did not meet our needs. When we first contributed ORM, it was
our complete commercial product that is being used by many companies. We
had the idea that we could for the most part leave it intact, but in the end
we could not just contribute it soup to nuts and had to make many changes to
fit into the platform. One of the big areas was the integration with the
WTP's ( moving to DTP) EMF model used to represent the database meta data.
I don't know if you've considered that as part of your offer to help?

Also, I am not too sure about the runtime element of this effort. The ORM
project is being built around a standard ( JSR220 ) and the tooling it being
written in a way that is independent of the runtime. So, anyone who has a
JSR220 runtime can plug it in and take advantage of the tooling. This
vendor neutral aspect of the tooling is extremely important to Eclipse. I
am not sure if there are other companies producing a runtime that would work
with your proposed XRM tooling. This may become an issue if there are other
standards based ways of achieving the goals of your proposed solution. Is
your approach based on a standard and/or are there standards based
approaches to what your tool does?

Regards,
Robert Greene, Versant Corp
Eclipse JSR220-ORM
rgreene@versant.com


"Ale Gicqueau" <ale@hitsw.com> wrote in message
news:d7i46b$nh9$1@news.eclipse.org...
> Dear Eclipse Community,
>
> we are very excited to start contributing to the Eclipse DTP project and
> apply our expertise in XML/Relational Mapping, a technical area we have
been
> focused on for over 5 years. Here is the abstract for our contribution:
>
> ============================================================ =======
>
> XML/Relational Mapping (XRM) Model
>
> Giving the growing presence and importance of XML, the need for a
> comprehensive mapping between XML and relational structures is vital in
> data-centric application development. While there are alternatives such as
> XSLT, no general solution meets all of the needs of XRM. Further, XRM
should
> express the mapping in terms appropriate to its problem domain, not the
> underlying implementation technology. To meet these requirements, the XRM
> Model component provide an EMF model with all the necessary data
definitions
> to fully characterize mapping elements and configurations between any XML
> document and any relational database.
>
> ============================================================ ========
>
> About HiT Software, Inc.
>
> HiT Software is a leading developer of standards-based products for
> relational database access. HiT Software products include Allora XML-RDB
> run-time transformation middleware, DBMoto data replication, SQL
middleware
> products for IBM DB2 access, and SafeConduct for secure Internet and
> intranet communications.
>
> Founded in 1994, HiT Software is based in San Jose, California, and is a
> member of the World Wide Web Consortium (W3C). HiT Software products are
> sold and serviced worldwide by the HiT Software direct sales team,
> international subsidiaries, and authorized channel partners. Additional
> information is available at www.hitsw.com, by sending e-mail to
> info@hitsw.com, or by calling (408) 345-4001.
>
> ============================================================ ========
>
> I have also included answers to two questions that a few members have
> already asked us after gathering their feedback about our proposal.
>
> (1) If a developer created an instance of the mapping model, then how
would
> that data be used at run time? That is, while we could define such a map
at
> development time, what sorts of components are required for run time
> consumption of this mapping data? Are there open source components in this
> area?
>
> Once a developer has created an instance of the mapping model as defined
in
> Eclipse DTP, he can use the Allora Java APIs to import or export XML from
> and to a relational database in one method call. The Java Allora run-time
> engine that processes the mapping model is not currently open-source
however
> we encourage open-source initiatives to develop APIs that are compatible
> with this comprehensive data model.
>
> (2) Can we open source the definition of the model (perhaps as an XML
Schema
> or UML diagram), and then review it to get community feedback?
>
> Yes, our intention is to give the open-source Eclipse community the
> definition of the XML-to-RDB mapping model and welcome any suggestions, or
> improvements to this model. We have been continuously improving our data
> mapping model from customers' feedback over the last 5 years and we
believe
> that this open-source initiative will help us perfect this model. Leading
> design tools like PowerDesigner are already embracing this model and are
> able to create it directly from their design modeling tool.
>
> ============================================================ ========
>
> We are looking forward to hearing from you,
>
> Ale Gicqueau
> XML-to-RDB technical evangelist
> HiT Software - http://www.hitsw.com
> Tel (408) 345 4009
> Cel (408) 771 4957
>
>
>
>
Re: XML/Relational Mapping (XRM) Model contribution to Eclipse DTP [message #383 is a reply to message #378] Mon, 06 June 2005 18:16 Go to previous message
Der Ping Chou is currently offline Der Ping ChouFriend
Messages: 36
Registered: July 2009
Member
Ale,

Inline with Robert's comment, I am very interested to learn more about the
relational model definition with Hit SW's proposal. How would this work
with existing SQL Model (based on SQL 99/2003 standard) in current DTP
project proposal?

See following link for SQLModel details:

http://www.eclipse.org/webtools/wst/components/rdb/WebPublis hedSQLModel/SQLModel.htm

Is it possible for the XML to relational mapping to use/populate SQLModel?

Thanks,

Der Ping
Re: XML/Relational Mapping (XRM) Model contribution to Eclipse DTP [message #565551 is a reply to message #371] Wed, 01 June 2005 20:44 Go to previous message
Robert Greene is currently offline Robert GreeneFriend
Messages: 4
Registered: July 2009
Junior Member
Hi Ale,

Seems like what you are wanting to do is very similar to what is being done
in the ORM proposal. Except it is mapping to XML instead of Java Objects
and the runtime is Allora instead of a JSR220 runtime. I agree that dealing
with XML is becoming increasingly important, so I think it is a great
potential addition to the DTP. As we discovered in the ORM project, you
will discover that there is a lot of what you need to do which puts you in
the consumer position. This is because Eclipse is a "platform" that needs
to be founded on common frameworks and reduce overlap as much as possible.

What we found in ORM is that to be a good citizen we needed to remove our
code that was doing database definition/connection work, query builder,
relational database meta data retrieval, etc and work with the DTP code
components that were targeted to fulfill those functions and extend them
where they did not meet our needs. When we first contributed ORM, it was
our complete commercial product that is being used by many companies. We
had the idea that we could for the most part leave it intact, but in the end
we could not just contribute it soup to nuts and had to make many changes to
fit into the platform. One of the big areas was the integration with the
WTP's ( moving to DTP) EMF model used to represent the database meta data.
I don't know if you've considered that as part of your offer to help?

Also, I am not too sure about the runtime element of this effort. The ORM
project is being built around a standard ( JSR220 ) and the tooling it being
written in a way that is independent of the runtime. So, anyone who has a
JSR220 runtime can plug it in and take advantage of the tooling. This
vendor neutral aspect of the tooling is extremely important to Eclipse. I
am not sure if there are other companies producing a runtime that would work
with your proposed XRM tooling. This may become an issue if there are other
standards based ways of achieving the goals of your proposed solution. Is
your approach based on a standard and/or are there standards based
approaches to what your tool does?

Regards,
Robert Greene, Versant Corp
Eclipse JSR220-ORM
rgreene@versant.com


"Ale Gicqueau" <ale@hitsw.com> wrote in message
news:d7i46b$nh9$1@news.eclipse.org...
> Dear Eclipse Community,
>
> we are very excited to start contributing to the Eclipse DTP project and
> apply our expertise in XML/Relational Mapping, a technical area we have
been
> focused on for over 5 years. Here is the abstract for our contribution:
>
> ============================================================ =======
>
> XML/Relational Mapping (XRM) Model
>
> Giving the growing presence and importance of XML, the need for a
> comprehensive mapping between XML and relational structures is vital in
> data-centric application development. While there are alternatives such as
> XSLT, no general solution meets all of the needs of XRM. Further, XRM
should
> express the mapping in terms appropriate to its problem domain, not the
> underlying implementation technology. To meet these requirements, the XRM
> Model component provide an EMF model with all the necessary data
definitions
> to fully characterize mapping elements and configurations between any XML
> document and any relational database.
>
> ============================================================ ========
>
> About HiT Software, Inc.
>
> HiT Software is a leading developer of standards-based products for
> relational database access. HiT Software products include Allora XML-RDB
> run-time transformation middleware, DBMoto data replication, SQL
middleware
> products for IBM DB2 access, and SafeConduct for secure Internet and
> intranet communications.
>
> Founded in 1994, HiT Software is based in San Jose, California, and is a
> member of the World Wide Web Consortium (W3C). HiT Software products are
> sold and serviced worldwide by the HiT Software direct sales team,
> international subsidiaries, and authorized channel partners. Additional
> information is available at www.hitsw.com, by sending e-mail to
> info@hitsw.com, or by calling (408) 345-4001.
>
> ============================================================ ========
>
> I have also included answers to two questions that a few members have
> already asked us after gathering their feedback about our proposal.
>
> (1) If a developer created an instance of the mapping model, then how
would
> that data be used at run time? That is, while we could define such a map
at
> development time, what sorts of components are required for run time
> consumption of this mapping data? Are there open source components in this
> area?
>
> Once a developer has created an instance of the mapping model as defined
in
> Eclipse DTP, he can use the Allora Java APIs to import or export XML from
> and to a relational database in one method call. The Java Allora run-time
> engine that processes the mapping model is not currently open-source
however
> we encourage open-source initiatives to develop APIs that are compatible
> with this comprehensive data model.
>
> (2) Can we open source the definition of the model (perhaps as an XML
Schema
> or UML diagram), and then review it to get community feedback?
>
> Yes, our intention is to give the open-source Eclipse community the
> definition of the XML-to-RDB mapping model and welcome any suggestions, or
> improvements to this model. We have been continuously improving our data
> mapping model from customers' feedback over the last 5 years and we
believe
> that this open-source initiative will help us perfect this model. Leading
> design tools like PowerDesigner are already embracing this model and are
> able to create it directly from their design modeling tool.
>
> ============================================================ ========
>
> We are looking forward to hearing from you,
>
> Ale Gicqueau
> XML-to-RDB technical evangelist
> HiT Software - http://www.hitsw.com
> Tel (408) 345 4009
> Cel (408) 771 4957
>
>
>
>
Re: XML/Relational Mapping (XRM) Model contribution to Eclipse DTP [message #565575 is a reply to message #378] Mon, 06 June 2005 18:16 Go to previous message
Der Ping Chou is currently offline Der Ping ChouFriend
Messages: 36
Registered: July 2009
Member
Ale,

Inline with Robert's comment, I am very interested to learn more about the
relational model definition with Hit SW's proposal. How would this work
with existing SQL Model (based on SQL 99/2003 standard) in current DTP
project proposal?

See following link for SQLModel details:

http://www.eclipse.org/webtools/wst/components/rdb/WebPublis hedSQLModel/SQLModel.htm

Is it possible for the XML to relational mapping to use/populate SQLModel?

Thanks,

Der Ping
Previous Topic:XML/Relational Mapping (XRM) Model contribution to Eclipse DTP
Next Topic:DTP Consolidation Notes Now Online
Goto Forum:
  


Current Time: Wed Jul 17 13:21:59 GMT 2024

Powered by FUDForum. Page generated in 0.04378 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top