A Storage Method for XML Document Based on Relational Database

Started by aruljothi, Apr 12, 2009, 12:36 AM

previous topic - next topic
Go Down

aruljothi

At present, storing XML document in a relational database is a hot topic because relational databases are mature and scale well. In this paper, a novel relational database storage structure that can store XML document is proposed. An algorithm that translates XML document to relational database is given according to the proposed storing structure and algorithms that translate XPath Query to SQL Query which runs on SQL Server 2000 is also given. The steps and algorithms are given in detail to describe how to use the storing structure to storage and query XML document in relational database. Then, an example is presented to show how to use this method and approve the correct of the proposed storing structure and given algorithms. Compared with other methods, the method in this paper has advantage in compact translated SQL, lesser relational database space and quicker query speed.

Go Up
 

Quick Reply

With Quick-Reply you can write a post when viewing a topic without loading a new page. You can still use bulletin board code and smileys as you would in a normal post.

Warning: this topic has not been posted in for at least 120 days.
Unless you're sure you want to reply, please consider starting a new topic.

Note: this post will not display until it's been approved by a moderator.
Name:
Email:
Verification:
Please leave this box empty:

Type the letters shown in the picture
Listen to the letters / Request another image

Type the letters shown in the picture:

shortcuts: alt+s submit/post or alt+p preview
IT Acumens | GinGly :: SMS Backup | Acumen :: Discussion Board | AshokPillar :: Hosting | CineBuzz :: Latest Cinema News | My Kids Diary :: Capture your kids magical moment
Copyright 2005 - 2017 :: IT Acumens :: All Rights Reserved.
ITAcumens Forum with 2 lakhs post running for 10 years - Powered by HostGator Dedicated Server