Keywords:-
Article Content:-
Abstract
XML has become a standard for data exchange on the Web. These data, after interchange among different sites, are often to exploit, share by applications designed for data stored in databases using the relational model and recently the object-relational model. The latter imposed itself due to its benefits in terms of reuse and sharing that improve productivity for both the developer and end user. In addition, the object-relational model that's an extension of the relational model has benefited greatly from the advantages of relational model in terms of access performance and security. To fully exploit XML data with the benefits of the object-relational model, we propose in this paper a methodology to convert data written in XML format respecting a DTD (Document Type Definition) into a schema of object-relational model.
References:-
References
L. Al-Jadir and F. El-Moukaddem, "F2/XML: Storing
XML Documents in Object Databases," International
Conference on Object Oriented Infomation Systems,
Montpellier, France, 2002.
Alfred V. Aho, Monica S. Lam, Ravi Sethi, and J. D.
Ullman, "Compilers Principles, Techniques, & Tools,"
nd ed, 2007, pp. 116-122,159-163.
Alfred V. Aho, Monica S. Lam, Ravi Sethi, and J. D.
Ullman, "Compilers Principles, Techniques, & Tools,"
nd ed, 2007, pp. 42-50, 197-199, 204-205.
V. Bisova and K. Richta, "Transformation of UML
Models into XML," ADBIS-DASFAA Symposium on
Advances in Databases and Information Systems,
Prague, Czech Republic, 2000.
A. Boccalatte, D. Giglio, and M. Paolucci, "An Object-
Oriented Modeling Approach Based on Entity-
Relationship Diagrams and Petri Nets," IEEE Internal
conference on Systems, Man and Cybernetics,San Diego,
CA, 1998.
T. Bray, Paoli, J., Sperberg-McQueen, and a. M. C. M.,
E., "Extensible Markup Language (XML) 1.0 (Second
Edition)," W3C Recommendation.
http://www.w3.orglTR2OOOlREC- XML-20001006l,
/10.E. Castro, D. Cuadra, and M. Velasco, "From XML to
Relational Models," Informatica, vol. 21(4), pp. 505-519,
/12.
T. M. Connolly and C. E. Begg, Database Systems: A
Practical Approach to Design, Implementation, and
Management, 4 ed., 2005.
R. Conrad, D. Scheffner, and J. C. Freytag, "XML
Conceptual Modeling using UML," International
Conference on Conceptual Modeling, Salt Lake City, UT
C. Coronel, S. Morris, and P. Rob, Database Systems:
Design, Implementation, and Management, 10 ed.:
Cengage Learninig, 2012.
H. Darwen and C. J. Date, "The Third Manfesto,"
SigMOD Record 24(1), pp. 39-49, 1995.
C. J. Date, "Preview of The Third Manifesto," Database
Programming & Design Journal (San Francisco, CA:
Miller Freeman Publications), vol. 11(8), 1998(8).
C. J. Date and H. Darwen, Databases, Types And the
Relational Model: The Third Manifesto, 3 ed.: Addison-
Wesley, 2007.
A. Deutsch, M. Fernandez, and D. Suciu, "Storing
Semistructured Data with STORED," In Proc. of ACM
SIGMOD, Philadelphia, PN, 1999.
A. Duta, B. K., and R. Alhajj, "ConvRel: Relationship
conversion to XML nested structures," in Proceedings of
ACM SIG Symposium on Applied Computing, pp. 698-
, 2004.
A. Eisenberg and J. Melton, "SQL:1999, formerly
known as SQL3," SIGMOD Record, vol. 28(1), March
A. Eisenberg, J. Melton, K. G. Kulkarni, J.-E. Michels,
and F. Zemke, "SQL: 2003," SIGMOD Record, vol.
(1), pp. 119-126, 2004.
A. A. A. El-Aziz and A. Kannan., "Mapping XML
DTDs to Relational Schemas," In Proceedings of the 2nd
International Conference on Computer Communication
and Informatics (ICCCI), pp. 1–7, 10-12, Jan 2012.
H. García-Molina, J. D. Ullman, and J. Widom,
Database Systems :The Complete Book: Prentice Hall,
G. Gardarin, "Databases," in Databases, Eyrolles, Ed.,
ed, 2001, pp. 442-443.
M. Gogolla, A. K. Huge, and B. Randt, "Stepwise Re-
Engineering and Development of Object-Oriented
Database Schemata," International Workshop on
Database and Expert Systems Applications, Vienna,
Austria, 1998.
J. Hou, Y. Zhang, and Y. Kambayashi, "Object-Oriented
Representation for XML Data," International
Symposium on Cooperative Database Systems for
Advanced Applications, Beijing, China, 2001.
S. Kanagaraj and D. S. Abburu, "Converting Relational
Database Into Xml Document " IJCSI International
Journal of Computer Science Issues, vol. 9(2), pp. 127-
, 2012/3.
J. Kim, D. Jeong, and D.-K. Baik, "A Translation
Algorithm for Effective RDB-to-XML Schema
Conversion Considering Referential Integrity
Information," Journal of Information Science and
Engineering, vol. 25, pp. 137-166, 2009/1.
D. Lee, M. Mani, and W. W. Chu, "Schema Conversion
Methods between XML and Relational Models,"
Knowledge Transformation for the Semantic Web, IOS
Press, pp. 245-252, 12 2003.
Y. E. Lien, "On the Equivalence of Database Models,"
Journal of the ACM 29, pp. 333–362, 1982.
J. Madhavan, P. A. Berstein, and E. Rahm, "Generic
Schema Matching with Cupid," International Conference
on Very Large Data Bases, Roma, Italy, 2001.
J. Melton, Advanced SQL:1999: Understanding Object-
Relational and Other Advanced Features (The Morgan
Kaufmann Series in Data Management Systems), 2003.
R. J. Miller, L. Haas, and M. A. Hernandez, "Schema
Mapping as Query Discovery," International Conference
on Very Large Data Bases, Cairo, Egypt, 2000.
S. Navathe and R. Elmasri, "Fundamentals of Database
Systems," ed: Addison-Wesley, 2011, pp. 353-413.
S. B. Navathe, "An Intuitive Approach to Normalize
Network Structured Data," International Conference on
Very Large Data Bases, Montreal, Quebec, Canada,
OPENXML, "Retrieving and Writing XML Data.,"
http://msdn.microsoft.com/library/default.asp?url=/librar
y/en-us/xmlsql/ac_openxml_759d.asp, 2004.
J. Price, "Oracle Database 11g SQL," ed: McGraw -Hill,
, pp. 379-473.
J. W. Rahayu, D. Taniar, and E. Pardede, Object-
Oriented Oracle: IRM Press, 2006.
A. Schmit, M. L. Kersten, M. Windhouwer, and F. Wass,
"Efficient Relational Storage and Retrieval of XML
documents," In WebDB (Informal Proceedings), pp. 47-
, 2000.
J. Shanmugasundaram, I. Tatarinov, E. Shekita, J.
Kiernan, E. Viglas, and J. Naughton, "A General
Technique for Querying XML Documents using a
Relational Database System," SIGMOD, 2001.
J. Shanmugasundaram, K. Tufte, G. He, X. C., D. D.,
and N. J., "Relational databases for querying XML
documents: limitations and opportunities," in: VLDB,
Edinburgh, Scotland, 1999/9.
M. Stonebraker, L. A. Rowe, and M. Hirohama, "The
Implementation of PostGres," IEEE on Knowledge and
Data Engineering, vol. 2, pp. 125-142, Mars 1990.
I. Tatarinov, S. Iglas, D., and V., "Storing and Quering
Ordered XML Using a Relational Database System,"
ACM SIGMOD, Wisconsin, USA, 2002.
M. YoshiKawa and T. Amagasa, "XRel: A Path -based
approach to storage and retrieval of XML documents
using relational databases," ACM Trans. on Internet
Technology 2001.