Data type NK_CURVE vs BLOB

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

After upgrade, the table INV_INVESTMENTS has the following columns with data type NK_CURVE.  

ODF_NK_LABOR_ALLOC_CURVE
ODF_NK_LABOR_HARD_ALLOC_CURVE
ODF_NK_LABOR_ETC_CURVE
ODF_NK_LABOR_ACT_CURVE
ODF_NK_LABOR_EAC_CURVE

Some other columns have BLOB data type. What is difference between BLOB and NK_CURVE

Environment

Release : Any Supported Release

Resolution

• BLOB is the legacy technology of time slices used in Classic UI. It's stored in PRJ_BLB_SLICES
• NK_CURVE is a new type of slice, which is SQL Curves, this is the new technology used in Modern UX. It's stored in the individual tables
• All per-period metrics represented in the Staff, Assignments, and Financials modules for Projects, Ideas, and Custom Investments are using the SQL curve technology which extracts data from their corresponding BLOBs.
• Currently both are used in parallel
• Note that direct select * from inv_investments and other tables containing SQL Curves may be slower - this is expected
• Broadcom Support recommends not to run open selects on those tables, and always explicitly call the columns you need as best practice, which is also done behind the scenes in the product