How do databases operate on compressed data?

Tags:
Data
Database
I read that in columnar databases, query execution is done on compressed data without decompressing data to acquire speed in query execution. How can people operate on compressed data?
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

When you are running a database that utilizes compressed data, the database is able to efficiently store all of the fixed length variables in a way that adjusts the data type by the amount of space it requires. You can choose from row compression or page compression. Whatever option you select, the database automatically creates a sort of index and then inventories it. A pointer is set to the stored data on the actual, uncompressed page.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Brijesh
    Here check this Data Compression which may get you more information.
    14,450 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: