Details
Major Description
Working implementation of shared scans capable of supporting both single-table scan, and synchronized multi-table scans. Demonstration involves:
- run simultaneously 5 full-table-scan queries on Object table and demonstrate they all complete in approx the time it takes to do a single pass through the table.
- run simultaneously 5 full-table-join queries (Object joined with Source) and demonstrate they all complete in approx the time it takes to do a single pass through the Source table plus the Object table.
Scale: 10% of DR1.
Details of shared scans can be found in ยง8.10 of LDM-135.
Attachments
Issue Links
Activity
| Fix Version/s | S16 [ 10906 ] |
| Description |
Demonstrate shared scanning for two types of queries:
# full table scan (single table) # full table scan (a join between two tables, for example, Object and Source) Demonstration involves running # 5 full-table-scan queries and showing each of them can complete in approx the time it takes to do a single scan. For example, if a single scan through the table takes 50 minutes, 5 queries run simultaneously should complete in ~ 50 min each, not 250 minutes. |
# run simultaneously 5 full-table-scan queries on Object table and demonstrate they complete in approx the time it takes to do a single pass through the table.
# run simultaneously 5 full-table-join queries (Object joined with Source) and demonstrate they complete in approx the time it takes to do a single pass through the Source table. |
| Description |
# run simultaneously 5 full-table-scan queries on Object table and demonstrate they complete in approx the time it takes to do a single pass through the table.
# run simultaneously 5 full-table-join queries (Object joined with Source) and demonstrate they complete in approx the time it takes to do a single pass through the Source table. |
# run simultaneously 5 full-table-scan queries on Object table and demonstrate they all complete in approx the time it takes to do a single pass through the table.
# run simultaneously 5 full-table-join queries (Object joined with Source) and demonstrate they all complete in approx the time it takes to do a single pass through the Source table plus the Object table. |
| Description |
# run simultaneously 5 full-table-scan queries on Object table and demonstrate they all complete in approx the time it takes to do a single pass through the table.
# run simultaneously 5 full-table-join queries (Object joined with Source) and demonstrate they all complete in approx the time it takes to do a single pass through the Source table plus the Object table. |
# run simultaneously 5 full-table-scan queries on Object table and demonstrate they all complete in approx the time it takes to do a single pass through the table.
# run simultaneously 5 full-table-join queries (Object joined with Source) and demonstrate they all complete in approx the time it takes to do a single pass through the Source table plus the Object table. Scale: 10% of DR1. |
| Summary | S16 Shared Scans | Shared Scans |
| Description |
# run simultaneously 5 full-table-scan queries on Object table and demonstrate they all complete in approx the time it takes to do a single pass through the table.
# run simultaneously 5 full-table-join queries (Object joined with Source) and demonstrate they all complete in approx the time it takes to do a single pass through the Source table plus the Object table. Scale: 10% of DR1. |
Working implementation of shared scans capable of supporting both single-table scan, and synchronized multi-table scans. Demonstration involves:
# # run simultaneously 5 full-table-scan queries on Object table and demonstrate they all complete in approx the time it takes to do a single pass through the table. # run simultaneously 5 full-table-join queries (Object joined with Source) and demonstrate they all complete in approx the time it takes to do a single pass through the Source table plus the Object table. Scale: 10% of DR1. |
| Description |
Working implementation of shared scans capable of supporting both single-table scan, and synchronized multi-table scans. Demonstration involves:
# # run simultaneously 5 full-table-scan queries on Object table and demonstrate they all complete in approx the time it takes to do a single pass through the table. # run simultaneously 5 full-table-join queries (Object joined with Source) and demonstrate they all complete in approx the time it takes to do a single pass through the Source table plus the Object table. Scale: 10% of DR1. |
Working implementation of shared scans capable of supporting both single-table scan, and synchronized multi-table scans. Demonstration involves:
# run simultaneously 5 full-table-scan queries on Object table and demonstrate they all complete in approx the time it takes to do a single pass through the table. # run simultaneously 5 full-table-join queries (Object joined with Source) and demonstrate they all complete in approx the time it takes to do a single pass through the Source table plus the Object table. Scale: 10% of DR1. |
| Description |
Working implementation of shared scans capable of supporting both single-table scan, and synchronized multi-table scans. Demonstration involves:
# run simultaneously 5 full-table-scan queries on Object table and demonstrate they all complete in approx the time it takes to do a single pass through the table. # run simultaneously 5 full-table-join queries (Object joined with Source) and demonstrate they all complete in approx the time it takes to do a single pass through the Source table plus the Object table. Scale: 10% of DR1. |
Working implementation of shared scans capable of supporting both single-table scan, and synchronized multi-table scans. Demonstration involves:
# run simultaneously 5 full-table-scan queries on Object table and demonstrate they all complete in approx the time it takes to do a single pass through the table. # run simultaneously 5 full-table-join queries (Object joined with Source) and demonstrate they all complete in approx the time it takes to do a single pass through the Source table plus the Object table. Scale: 10% of DR1. Details of shared scans can be found in §8.10 of [LDM-135|http://ls.st/LDM-135*]. |
| Workflow | jira [ 22031 ] | DM Long-range Planning Workflow [ 24571 ] |
| Remote Link | This issue links to "Page (Confluence)" [ 13512 ] |
| Remote Link | This issue links to "Page (Confluence)" [ 13512 ] | This issue links to "Page (Confluence)" [ 13512 ] |
| Remote Link | This issue links to "Page (Confluence)" [ 13512 ] | This issue links to "Page (Confluence)" [ 13512 ] |
| Remote Link | This issue links to "Page (Confluence)" [ 13512 ] | This issue links to "Page (Confluence)" [ 13512 ] |
| Assignee | Jacek Becla [ jbecla ] | Fritz Mueller [ fritzm ] |
| Labels | L3Milestone |
| Milestone Level | 3 [ 11502 ] |
| Resolution | Done [ 10000 ] | |
| Status | Open [ 1 ] | Resolved [ 5 ] |