answersLogoWhite
Database Programming

What is the difference between XML and SQL data storage?

313233

Top Answer
User Avatar
Wiki User
2008-01-21 05:40:57
2008-01-21 05:40:57

In XML data storage, the data is stored in a file which represents an XML Schema of the data. To read the data, you have to pull and open the entire file in memory and use technics like xpath to get the data element you want. In SQL data storage, the data is stored in a database ( usually relational database). To read the data, you simple sent an SQL query to the database. The database management engine analysis the query and get the required data elements you ask for in your query which is finally sent to you as a reply.

1

Related Questions

User Avatar

SQL is a universal query language used to access relational data. MySQL is a database storage engine which utilizes the SQL query language as the means to interface with the data stored.

User Avatar

SQL is a query based language that is used to manipulate data stored in a database while other languages process data.

User Avatar

RECORD type works only in PL/SQL. But OBJECT type gets stored in database and can be used in both SQL and PL/SQL (without redefining it in PL/SQL).

User Avatar

SQL and "File Based Databases" can't really be compared directly as they refer to two different concepts. SQL is a language for querying databases. "File Based Databases" often refer to data storage that you manage through your own methods, rather than using a language like SQL to query and manipulate the data. For example, MySQL stores its data in files on the hard drive. To store and manipulate the data and its structure, you use SQL queries. MySQL takes care of the data behind the scenes, and provides methods for sorting and arranging the data returned to queries. You never deal directly with the files that MySQL uses to store the data.

User Avatar

one of the difference is HQL does not support distinct but SQL supports the distinct in the query

User Avatar

T-SQL is Microsoft's version of the generic SQL langauge to be used with, for example, Microsoft SQL Server.

User Avatar

SQL*PLUS is a interface between user and Oracle database. It Provide an environment to use the SQL which is a query language to communicate with oracle database

User Avatar

SQL is the language itself where as SQL*Plus is a program distributed by Oracle used to run SQL Script on databases.

User Avatar

SQLSQL is a language that can communicate with Oracle server to access the data.It is based on ANSI standards.There is no continuation character.Keywords cannot be abbreviated.Use functions to manipulate the data.SQL*PLUSIt recognizes SQL statement and sends them to the server.Is an Oracle proprietary.There is a continuation character.Keywords can be abbreviated.Use commands to manipulate the data.

User Avatar

SQL (structured query Language) is standard language that is used in Mysql, Oracle, and Sql server. only difference between SQL server, Oracle, and Mysql. Sql server is micosoft product & a data Base Management System(DBMS) Oracle is also a DBMS by Oracle. mysql is open source and free by SUN also DBMS. All above used SQL in their Queries............ enjoy.........

User Avatar

There is no such thing as SQL Server 2003. Microft released SQL Server 2005 as the next version of SQL Server 2000.

User Avatar

SELECT aFieldName, someOtherFieldName, yetAnotherFieldName FROM aTableName WHERE fieldNameWithDateInIt BETWEEN date1 and date2

User Avatar

In database management system to access or modify data query is generated. SQL is strutured query language used to retrieve or modify data. While PL/SQL is programming language of SQL to create applications.

User Avatar

sql exception which provides information on database access errors where as sql warning provides inforamation on database access warnings.

User Avatar

One can find data storage solutions with solid state technology at 'Pure Storage'. One can choose Oracle or Microsoft SQL server options and use Virtual Desktop Infrastructure software.

User Avatar

The difference between Pervasive SQL and MS SQL are slight and of a rather technical nature. To the typical consumer the functionality is very much the same, though performance may vary depending upon the use.

User Avatar

Which SQL statement is used to update data in a database

User Avatar

Data Store in Citrix is a storage used for storing static information of the farm. Data Store could be of MS Access, SQL, Oracle or DB2. Regards Amit Joshi

User Avatar

SQL is an abbreviation for Structured Query Language. SQL is a means to request data from a database. SQL is a standards based langage that has many versions approved by the American National Standards Institute (ANSI). There are many versions of ANSI-SQL and most databases support specific versions of ANSI-SQL. SQL Server is a database management system that was originally created by Sybase. Microsoft bought the rights from Sybase to market their own version of SQL Server on the Microsoft Windows operating system. Sybase still has versions of SQL Server on other operating systems. When people refer to SQL Server, they typically mean "Microsoft SQL Server." Microsoft SQL Server is a database management system (DBMS) that utilizes SQL (or more specifically Transact-SQL, or T-SQL) as a means to extract data from it's database tables.

User Avatar

SQL (Structured Query Language) is a language used in a SQL server to manage data (Query the data, insert, Update, Delete) as well as perform data manipulation (calculations, etc)

User Avatar

Structured Query Language, SQL, is used for retrieving and managing data in databases.

User Avatar

MySQL is a relational database storage engine that can be used to store relational data which can be accessed and updated via the SQL query language.

User Avatar

ADO is active x data object. It is used to access database with the help of data controls and objects as well. it is an extended form of RDO and DAO. RDO is remote data object which is used to access server site data. data in this case reside on the sql server. and we use sql queries to access data. in this we write a sql command and then squ server processes it and gives back the result. DAO is data access object. it is used to access data with the help of program and some data controls. it provides an extention to data controls and data bound controls. DAO helps in accessing data with various conditions or quries.


Copyright © 2020 Multiply Media, LLC. All Rights Reserved. The material on this site can not be reproduced, distributed, transmitted, cached or otherwise used, except with prior written permission of Multiply.