To create an indexed file you need a Key. To create a Sorted file, you need to order the records. The typical differences between these two files are Order and Key.
AWS Glue Crawler Issue with Dynamic S3 Folder Paths? Here’s the Complete Fix
Learn how to fix AWS Glue crawler issues when S3 paths contain dynamically changing folders like hash values or UUIDs. Step-by-step beginner-friendly guide.
How to Create a Generic Stored Procedure for KPI Calculation (SQL + AWS Lambda)
In modern data engineering, building scalable and reusable systems is essential. Writing separate SQL queries for every KPI quickly becomes messy and hard to maintain. A better approach?👉 Use a Generic Stored Procedure powered by Dynamic SQL, and trigger it using AWS Lambda. In this blog, you’ll learn: What is a Generic Stored Procedure? A…
Unlocking the Power of Databricks Genie: A Comprehensive Guide
Databricks Genie is a collaborative data engineering tool built on the Databricks Unified Analytics Platform, enhancing data analytics for businesses. Key features include collaborative workspaces, efficient data processing with Apache Spark, built-in machine learning capabilities, robust data visualization, seamless integration, and strong security measures, fostering informed decision-making.
Indexed file Vs Sorted file
Indexed file
- Indexed files use a primary key field to identify the records of an original file in a database. A primary key field is a unique field. An indexed file consists of actual records sorted based on the primary key field value
- An indexed file also consists of alternate keys, which build the alternate index. Unlike primary keys, the alternate keys in an indexed file do not have actual records.
- The advantage of primary key field values is that because of the indexing of actual records, you require only one input-output operation to access records in an indexed file
Sorted file
- Sorting is like placing records either in ascending or descending order based on KEY
- For example, sorting payroll-file with an employee identification number in ascending order is called Soring. Here, employee identification is KEY.
- Sorting is possible to do on multiple keys like ID and Department
- When you sort a sequential file, its records are stored on the hard disk and you can only access them serially. It is not possible to access all the records of a file simultaneously.
Also Read
Srinimf 