InsightsIDENIFE

Progress, recorded.Perspectives, shared.

Updates, technical thinking and industry perspectives from IDENIFE. Following technology as it becomes part of everyday work.

Technical articles

Why Imported 3D Models Become Oversized or Mirrored: Units, Coordinates and Transform-Chain Tests

Opening a 3D file with a plausible appearance does not establish correct dimensions, orientation or component placement. For static mesh delivery, this article separates unit interpretation, coordinate-basis conversion and object transforms. A constructed millimeter-to-meter, Z-up-to-Y-up example supports hierarchy, normal and destination checks, with explicit limits for engineering use.

Technical articles

Why API Updates Overwrite Other Changes: ETag, If-Match and Concurrent-Write Acceptance Tests

When people and agents modify the same object, valid parameters, successful requests and even idempotency do not prevent stale content from overwriting newer changes. A constructed order example explains conditional updates with ETag and If-Match, atomic server-side checks, conflict recovery and concurrency tests, while separating object versions from cross-object constraints and unknown write outcomes.

Technical articles

Why Organizational Rollups Double Count or Omit Data: Recursive SQL, Cycles and Subtree Acceptance

Expanding a department and its descendants can fail through orphan nodes, cycles, overlapping roots and multiple parents. Constructed organization and order data separate node, path and fact grains, then support traversal checks, reconciliation and versioned publication. The article also explains why organizational deduplication must not be applied blindly to bill-of-materials quantities.

Technical articles

Enterprise Text Normalization: Unicode, Search Keys and Identifier-Collision Tests

Similar-looking names can contain different characters, while width, case or punctuation transformations can collapse distinct codes into one value. This article separates raw text, display values, search keys and identity keys. Constructed part numbers illustrate normalization and confusable-character limits, followed by collision handling, database comparison, version migration and counterexample tests.

Technical articles

Why RAG Access Revocation Is Not Immediate: In-Flight Requests, Caches, and Authorization Consistency

After an employee leaves a project, a RAG system can still return information through an old cache, a request that already passed authorization, or an answer being generated. This article separates revocation commits, authorization snapshots, and output release. Drawing on official Zanzibar, SpiceDB, and OpenFGA sources, it develops an event timeline, achievable revocation guarantees, and deterministic race tests that explain why another permission check is not the same as recalling data.

Technical articles

Deploying Data Pipeline Field Changes Safely: Schema Compatibility, Semantic Contracts and Versioned Migration

A source column addition, type change or revised monetary definition can distort reports and AI analytics while pipelines still report success. This article separates read/write compatibility, business meaning and operational cutover. A constructed order migration explains version isolation, historical replay, consumer upgrades and recovery, with counterexample tests that go beyond passing schema validation.

Technical articles

Historical Attribution in AI Analytics: Slowly Changing Dimensions, Corrections and Temporal Join Validation

Should last year's revenue move when a customer changes sales regions? The answer depends on whether the question concerns transaction-time ownership, today's organization or information known when a report was released. This article explains effective-dated joins, snapshot limitations and practical tests for corrections, missing history, overlapping versions and group-level reconciliation.

Technical articles

Resampling Industrial Sensor Data Without Turning Missing Signals into Normal Readings

A sensor table with one row per minute is not automatically ready for modeling. Bucket boundaries, sampling density, imputation spans and future observations can change what the signal means. Using constructed temperature sequences, this article separates aggregation from interpolation and develops an implementation and acceptance process that preserves evidence, limits filling, and distinguishes real-time inputs from revised offline views.

Technical articles

Hybrid Search for Enterprise Knowledge Bases: Testing Evidence Retrieval for Model Numbers, Acronyms, and Technical Terms

A knowledge base may answer conceptual questions yet miss an exact model number or confuse neighboring part numbers. The fault can lie in field design, candidate truncation, or reranking. Using a constructed equipment-manual scenario, this article explains lexical and vector retrieval, the limits of RRF, and a practical evaluation method that traces evidence through the pipeline and compares results by query type.

Technical articles

Enterprise Customer Deduplication: Avoid Merging Similar Names into the Wrong Entity

Customer deduplication across systems requires more than name similarity. This article develops a verifiable, reversible mapping process covering entity definitions, candidate recall, evidence, human review and cluster conflicts. It explains why a high match rate can hide false merges and how independent samples reveal missed and incorrect links. Examples are constructed; thresholds require calibration to business losses.

Technical articles

RAG Incremental Updates and Deletion Consistency: Activating Complete Revisions and Excluding Obsolete Evidence

A successful vector write does not complete a RAG knowledge-base update. Chunks, lexical and vector indexes, and answer caches may represent different revisions, while deleting a source file may leave retrieval copies intact. This article separates acknowledgment, visibility and activation, then develops a revision manifest, a prepare–validate–activate protocol and a deletion high-water mark, with failure scenarios and measurable acceptance criteria.

Technical articles

Validating LLM Structured Outputs Before Database Entry: Four Layers Beyond JSON Schema

Valid JSON can still turn unknown values into zeros, confuse monetary units or copy a field from the wrong document. Using a constructed quotation-extraction task, this article distinguishes response completion, structural constraints, business consistency and source evidence. It develops exception routing, controlled repair and acceptance metrics for traceable, reviewable candidate records.

Technical articles

Accepting Industrial Visual Anomaly Detection: Translate AUROC into Missed Defects and Review Workload

A high AUROC does not establish that an industrial vision model will miss few defects or produce a manageable number of false alarms on a production line. This article develops an acceptance method around fixed thresholds, part-level statistics, lighting and batch changes, evidence for rare defects, and human review capacity. Explicitly constructed data illustrate the operational workload.

Technical articles

Acceptance Criteria for Training Datasets: Deduplication, Evaluation Independence, and Version Traceability

A dataset can load successfully and contain every required field yet still be unsuitable for training. Using a constructed support-ticket classification example, this article explains how to define acceptance boundaries and check exact and near duplicates, temporal and entity leakage, label quality, and version traceability. Acceptance should establish fitness for the agreed task, rather than impose one universal pass rate on every dataset.

鲁ICP备2024109755号-2
Drag to move. Right-click, touch and hold, or press Shift+F10 to choose a corner.