answersLogoWhite

0

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.

User Avatar

Wiki User

17y ago

What else can I help you with?

Continue Learning about Information Science

What is the difference between SQL and file based databases?

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.


What database is a collection of data organized in a way that allows of data?

A relational database is a collection of data organized in a way that allows for data retrieval, storage, and manipulation based on predefined relationships between the data. SQL is commonly used to query and manage the data stored in a relational database.


Difference between Object-based Data Model and Record-based Data Model?

Object-based data model represents data as objects with attributes and methods, providing a way to model real-world entities in a programming language like Java. On the other hand, record-based data model organizes data into fixed-format records or tuples, typically used in databases like SQL to store and retrieve structured information. Object-based data model offers a more dynamic and flexible way to represent data compared to the rigid structure of record-based models.


What is the difference between sql and an sql server?

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.


What are the advantages of SQL?

SQL allows for easy access and retrieval of large amounts of data, provides a standardized language for interacting with databases, and offers powerful tools for data manipulation and analysis. Additionally, SQL supports data integrity and security features to ensure reliable and secure data management.

Related Questions

Tell you very clearly what is the difference between sql and mysql?

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.


What is the difference between SQL and the other programming languages?

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


What is the difference between T-sql and sql?

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


What is the difference between hql and sql?

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


Difference between sql and sql plus?

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


What is a recent breakthrough in the development of a universal language to aid storage and transmission of Web-based data is?

SQL


What is the difference between SQL and file based databases?

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.


What is the difference between a stored database procedure and a batch of SQL statements submitted by a client application?

Stored procedures prevent unauthorized access to data


Difference between sql server 2003 sql server 2005?

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


What database is a collection of data organized in a way that allows of data?

A relational database is a collection of data organized in a way that allows for data retrieval, storage, and manipulation based on predefined relationships between the data. SQL is commonly used to query and manage the data stored in a relational database.


What is the difference between quel SQL and qbe?

gand maro...is the answer


Sql statement for retrieving data between two dates in SQL Server?

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