Sending Many Database Rows with XML

Question:

Is there a way to select a structure of a database row and send it once from a server to a client and after that send thousands of rows? Doesn’t repeating the same metadata for each row create huge overhead?

Answer:

Typically, depending upon the server that you’re working with, the metadata is sent independently of the data itself. For example, if you look at the metadata that’s produced from SQL Server’s XML export, the metadata block for the XML appears first, then the row information is presented as a series of attributes for each row, with one attribute corresponding to a field representation in the initial metadata block. This cuts down considerably on the overhead.

Once the XML Schema architecture is finalized, that will provide another level of abstraction. When you make a request from a database that supports that architecture, you will get a schema representation and a data representation, possibly within the same document, possibly not (depending upon the server). Either way, the actual information that is contained within the records themselves is minimal, but you can reconstruct type and parametric information easily from the schema.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

The Latest

microsoft careers

Top Careers at Microsoft

Microsoft has gained its position as one of the top companies in the world, and Microsoft careers are flourishing. This multinational company is efficiently developing popular software and computers with other consumer electronics. It is a dream come true for so many people to acquire a high paid, high-prestige job

your company's audio

4 Areas of Your Company Where Your Audio Really Matters

Your company probably relies on audio more than you realize. Whether you’re creating a spoken text message to a colleague or giving a speech, you want your audio to shine. Otherwise, you could cause avoidable friction points and potentially hurt your brand reputation. For example, let’s say you create a

chrome os developer mode

How to Turn on Chrome OS Developer Mode

Google’s Chrome OS is a popular operating system that is widely used on Chromebooks and other devices. While it is designed to be simple and user-friendly, there are times when users may want to access additional features and functionality. One way to do this is by turning on Chrome OS