P. Samuel

Publications (2)0 Total impact

• Source

  Available from: edu.cn

  Conference Proceeding: Insert queries in XML database

  P.M. Vidhya, P. Samuel
  [show abstract] [hide abstract]
  ABSTRACT: The need for interoperation and data exchange through the Internet has made Extensible Markup Language (XML) a dominant standard for data representation, while relational databases are widely used in enterprises to support critical business operations. XML querying language (XUpdate) is used to modify XML documents where as structured query language (SQL) for retrieving and manipulating data in relational databases. It may not be possible for users and developers to be familiar with both the query languages easily and quickly. Here, we examine how XML data can be modified using INSERT and UPDATE. In this paper, we propose a new concept and framework where SQL (INSERT, UPDATE) can be easily transformed to XUpdate expressions. We use SQL, as it has long been the standard language. Users can manipulate XML database through the query language SQL using our framework. We present algorithms for translating INSERT and UPDATE queries expressed in SQL to XUpdate and the experimental results validate the proposed approach.
  Computer Science and Information Technology (ICCSIT), 2010 3rd IEEE International Conference on; 08/2010
• Conference Proceeding: Query translation from SQL to XPath

  P.M. Vidhya, P. Samuel
  [show abstract] [hide abstract]
  ABSTRACT: Today XML is the de facto standard of data exchange format for the information on the Web. At the same time, database systems are well known for consistent storage, retrieval and manipulation of data. XML querying language (XPath) is used to access XML documents whereas Structured Query Language (SQL) for retrieving and manipulating data in relational database. It may not be possible for users and developers to be familiar with both the query languages easily and quickly. Here, we examine how XML data can be queried using SQL. In this paper, we propose a new concept and framework where SQL statements can be easily transformed to XPath expressions. We use SQL, as it has long been the standard language. Users can access XML database and relational database through the query language SQL using our framework. We present algorithms for translating queries expressed in SQL (SELECT, DELETE, RENAME) to XPath. The procedure provides relational interface to XML database and the experimental results validate the proposed approach.
  Nature & Biologically Inspired Computing, 2009. NaBIC 2009. World Congress on; 01/2010