Tag: ISO/IEC 39075:2024 GQL Standard

Geode documentation tagged with ISO/IEC 39075:2024 GQL Standard. ISO/IEC 39075:2024 is the first international standard for graph query languages, providing a vendor-neutral specification for querying property graphs with full interoperability. <h3 id="introduction-to-isoiec-390752024" class="position-relative d-flex align-items-center group"> Introduction to ISO/IEC 39075:2024 <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="introduction-to-isoiec-390752024" aria-haspopup="dialog" aria-label="Share link: Introduction to ISO/IEC 39075:2024"> Share link </button> </h3><div id="headingShareModal" class="heading-share-modal" role="dialog" aria-modal="true" aria-labelledby="headingShareTitle" hidden> <div class="hsm-dialog" role="document"> <div class="hsm-header"> <h2 id="headingShareTitle" class="h6 mb-0 fw-bold">Share this section</h2> <button type="button" class="hsm-close" aria-label="Close"> </button> </div> <div class="hsm-body"> <label for="headingShareInput" class="form-label small text-muted mb-1 text-uppercase fw-bold" style="font-size: 0.7rem; letter-spacing: 0.5px;">Permalink</label> <div class="input-group mb-4 hsm-url-group"> <input id="headingShareInput" type="text" class="form-control font-monospace" readonly aria-readonly="true" style="font-size: 0.85rem;" /> <button class="btn btn-primary hsm-copy" type="button" aria-label="Copy" title="Copy"> </button> </div> <div class="small fw-bold mb-2 text-muted text-uppercase" style="font-size: 0.7rem; letter-spacing: 0.5px;">Share via</div> <div class="hsm-share-grid"> <a id="share-twitter" class="btn btn-outline-secondary w-100" target="_blank" rel="noopener noreferrer"> Twitter </a> <a id="share-linkedin" class="btn btn-outline-secondary w-100" target="_blank" rel="noopener noreferrer"> LinkedIn </a> <a id="share-facebook" class="btn btn-outline-secondary w-100" target="_blank" rel="noopener noreferrer"> Facebook </a> </div> </div> </div> </div> <style> .heading-share-modal { position: fixed; inset: 0; display: flex; justify-content: center; align-items: center; background: rgba(0, 0, 0, 0.6); z-index: 1050; padding: 1rem; backdrop-filter: blur(4px); -webkit-backdrop-filter: blur(4px); } .heading-share-modal[hidden] { display: none !important; } .hsm-dialog { max-width: 420px; width: 100%; background: var(--bs-body-bg, #fff); color: var(--bs-body-color, #212529); border: 1px solid var(--bs-border-color, rgba(0,0,0,0.1)); border-radius: 1rem; box-shadow: 0 25px 50px -12px rgba(0, 0, 0, 0.25); overflow: hidden; animation: hsm-fade-in 0.2s ease-out; } @keyframes hsm-fade-in { from { opacity: 0; transform: scale(0.95); } to { opacity: 1; transform: scale(1); } } [data-bs-theme="dark"] .hsm-dialog { background: #1e293b; border-color: rgba(255,255,255,0.1); color: #f8f9fa; } .hsm-header { display: flex; justify-content: space-between; align-items: center; padding: 1rem 1.5rem; border-bottom: 1px solid var(--bs-border-color, rgba(0,0,0,0.1)); background: rgba(0,0,0,0.02); } [data-bs-theme="dark"] .hsm-header { background: rgba(255,255,255,0.02); border-color: rgba(255,255,255,0.1); } .hsm-close { background: transparent; border: none; color: inherit; opacity: 0.5; padding: 0.25rem 0.5rem; border-radius: 0.25rem; font-size: 1.2rem; line-height: 1; transition: opacity 0.2s; } .hsm-close:hover { opacity: 1; } .hsm-body { padding: 1.5rem; } .hsm-url-group { display: flex !important; align-items: stretch; } .hsm-url-group .form-control { flex: 1; min-width: 0; margin: 0; background: var(--bs-secondary-bg, #f8f9fa); border-color: var(--bs-border-color, #dee2e6); border-top-right-radius: 0; border-bottom-right-radius: 0; height: 42px; } .hsm-url-group .btn { flex: 0 0 auto; margin: 0; margin-left: -1px; border-top-left-radius: 0; border-bottom-left-radius: 0; height: 42px; display: flex; align-items: center; justify-content: center; padding: 0 1.25rem; z-index: 2; } [data-bs-theme="dark"] .hsm-url-group .form-control { background: #0f172a; border-color: #334155; color: #e2e8f0; } .hsm-share-grid { display: flex; flex-direction: column; gap: 0.5rem; } .hsm-share-grid .btn { display: flex; align-items: center; justify-content: center; font-size: 0.9rem; padding: 0.6rem; border-color: var(--bs-border-color); width: 100%; } [data-bs-theme="dark"] .hsm-share-grid .btn { color: #e2e8f0; border-color: #475569; } [data-bs-theme="dark"] .hsm-share-grid .btn:hover { background: #334155; border-color: #cbd5e1; } </style> <script> (function(){ const modal = document.getElementById('headingShareModal'); if(!modal) return; const input = modal.querySelector('#headingShareInput'); const copyBtn = modal.querySelector('.hsm-copy'); const twitter = modal.querySelector('#share-twitter'); const linkedin = modal.querySelector('#share-linkedin'); const facebook = modal.querySelector('#share-facebook'); const closeBtn = modal.querySelector('.hsm-close'); let lastFocus=null; let trapBound=false; function buildUrl(id){ return window.location.origin + window.location.pathname + '#' + id; } function isOpen(){ return !modal.hasAttribute('hidden'); } function hydrate(id){ const url=buildUrl(id); input.value=url; const enc=encodeURIComponent(url); const text=encodeURIComponent(document.title); if(twitter) twitter.href=`https://twitter.com/intent/tweet?url=${enc}&text=${text}`; if(linkedin) linkedin.href=`https://www.linkedin.com/sharing/share-offsite/?url=${enc}`; if(facebook) facebook.href=`https://www.facebook.com/sharer/sharer.php?u=${enc}`; } function openModal(id){ lastFocus=document.activeElement; hydrate(id); if(!isOpen()){ modal.removeAttribute('hidden'); } requestAnimationFrame(()=>{ input.focus(); }); trapFocus(); } function closeModal(){ if(!isOpen()) return; modal.setAttribute('hidden',''); if(lastFocus && typeof lastFocus.focus==='function') lastFocus.focus(); } function copyCurrent(){ try{ navigator.clipboard.writeText(input.value).then(()=>feedback(true),()=>fallback()); } catch(e){ fallback(); } } function fallback(){ input.select(); try{ document.execCommand('copy'); feedback(true);}catch(e){ feedback(false);} } function feedback(ok){ if(!copyBtn) return; const icon=copyBtn.querySelector('i'); if(!icon) return; const prev=copyBtn.getAttribute('data-prev')||icon.className; if(!copyBtn.getAttribute('data-prev')) copyBtn.setAttribute('data-prev',prev); icon.className= ok ? 'fa-duotone fa-clipboard-check':'fa-duotone fa-circle-exclamation'; setTimeout(()=>{ icon.className=prev; },1800); } function handleShareClick(e){ e.preventDefault(); const btn=e.currentTarget; const id=btn.getAttribute('data-share-target'); if(id) openModal(id); } function bindShareButtons(){ document.querySelectorAll('.h-share').forEach(btn=>{ if(!btn.dataset.hShareBound){ btn.addEventListener('click', handleShareClick); btn.dataset.hShareBound='1'; } }); } bindShareButtons(); if(document.readyState==='loading'){ document.addEventListener('DOMContentLoaded', bindShareButtons); } else { requestAnimationFrame(bindShareButtons); } document.addEventListener('click', function(e){ const shareBtn=e.target.closest && e.target.closest('.h-share'); if(shareBtn && !shareBtn.dataset.hShareBound){ handleShareClick.call(shareBtn, e); } }, true); document.addEventListener('click', e=>{ if(e.target===modal) closeModal(); if(e.target.closest && e.target.closest('.hsm-close')){ e.preventDefault(); closeModal(); } if(copyBtn && (e.target===copyBtn || (e.target.closest && e.target.closest('.hsm-copy')))) { e.preventDefault(); copyCurrent(); } }); document.addEventListener('keydown', e=>{ if(e.key==='Escape' && isOpen()) closeModal(); }); function trapFocus(){ if(trapBound) return; trapBound=true; modal.addEventListener('keydown', f=>{ if(f.key==='Tab' && isOpen()){ const focusable=[...modal.querySelectorAll('a[href],button,input,textarea,select,[tabindex]:not([tabindex="-1"])')].filter(el=>!el.hasAttribute('disabled')); if(!focusable.length) return; const first=focusable[0]; const last=focusable[focusable.length-1]; if(f.shiftKey && document.activeElement===first){ f.preventDefault(); last.focus(); } else if(!f.shiftKey && document.activeElement===last){ f.preventDefault(); first.focus(); } } }); } if(closeBtn) closeBtn.addEventListener('click', e=>{ e.preventDefault(); closeModal(); }); })(); </script>ISO/IEC 39075:2024, officially titled “Information technology — Database languages — Graph Query Language (GQL),” represents a historic milestone in database standardization. Published in April 2024 after nearly a decade of development by working group ISO/IEC JTC 1/SC 32/WG 3, GQL is the first international standard specifically designed for property graph databases. The standard emerged from the need for interoperability in the rapidly growing graph database market. Prior to GQL, each vendor implemented proprietary query languages (Cypher, Gremlin, SPARQL variants), creating lock-in and limiting portability. GQL provides a common foundation that enables queries to work across compliant databases, tooling to support multiple backends, and developers to transfer skills between platforms. Geode follows the ISO/IEC 39075:2024 compliance. The profile documents scope, diagnostics, and implementation-defined behaviors to keep GQL usage portable and predictable. <h3 id="key-concepts" class="position-relative d-flex align-items-center group"> Key Concepts <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="key-concepts" aria-haspopup="dialog" aria-label="Share link: Key Concepts"> Share link </button> </h3> <h4 id="the-gql-standard-structure" class="position-relative d-flex align-items-center group"> The GQL Standard Structure <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="the-gql-standard-structure" aria-haspopup="dialog" aria-label="Share link: The GQL Standard Structure"> Share link </button> </h4>ISO/IEC 39075:2024 is organized into comprehensive sections: <ul> <li>Part 1: Framework: Core concepts, data model, and type system</li> <li>Part 2: Foundation: Basic syntax, expressions, and operations</li> <li>Part 3: Advanced Features: Subqueries, aggregations, and functions</li> <li>Part 4: Schema DDL: Graph schema definition language</li> <li>Part 5: Conformance: Test requirements and compliance levels</li> </ul> <h4 id="property-graph-model" class="position-relative d-flex align-items-center group"> Property Graph Model <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="property-graph-model" aria-haspopup="dialog" aria-label="Share link: Property Graph Model"> Share link </button> </h4>The ISO standard defines property graphs consisting of: <ul> <li>Nodes (Vertices): Entities with zero or more labels and properties</li> <li>Relationships (Edges): Directed connections between nodes with a type and properties</li> <li>Properties: Key-value pairs where keys are strings and values have defined types</li> <li>Labels: Node classification tags (e.g., <code>:Person</code>, <code>:Product</code>)</li> <li>Types: Relationship classification (e.g., <code>:PURCHASED</code>, <code>:KNOWS</code>)</li> </ul> <h4 id="data-types" class="position-relative d-flex align-items-center group"> Data Types <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="data-types" aria-haspopup="dialog" aria-label="Share link: Data Types"> Share link </button> </h4>ISO/IEC 39075:2024 specifies a rich type system: <ul> <li>Primitive Types: BOOLEAN, INTEGER, FLOAT, STRING, DATE, TIME, TIMESTAMP</li> <li>Temporal Types: DATE, TIME, LOCALDATETIME, ZONEDDATETIME, DURATION</li> <li>Spatial Types: POINT (2D/3D with coordinate reference systems)</li> <li>Collection Types: LIST, SET, MAP</li> <li>Path Types: Structured path objects for graph traversals</li> <li>NULL: Explicit null handling with three-valued logic</li> </ul> <h4 id="query-language-components" class="position-relative d-flex align-items-center group"> Query Language Components <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="query-language-components" aria-haspopup="dialog" aria-label="Share link: Query Language Components"> Share link </button> </h4>The standard defines comprehensive query capabilities: <ul> <li>Pattern Matching: ASCII-art syntax for graph patterns</li> <li>Data Manipulation: INSERT, SET, REMOVE, DELETE operations</li> <li>Aggregation: COUNT, SUM, AVG, MIN, MAX, COLLECT functions</li> <li>Subqueries: Nested queries with EXISTS, OPTIONAL, and UNION</li> <li>Path Patterns: Variable-length paths and shortest path algorithms</li> <li>Ordering and Limiting: ORDER BY, LIMIT, OFFSET clauses</li> </ul> <h4 id="conformance-levels" class="position-relative d-flex align-items-center group"> Conformance Levels <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="conformance-levels" aria-haspopup="dialog" aria-label="Share link: Conformance Levels"> Share link </button> </h4>The standard defines three conformance levels: <ol> <li>Core GQL: Basic pattern matching and simple queries</li> <li>Intermediate GQL: Aggregations, subqueries, and path operations</li> <li>Full GQL: All features including advanced functions and procedures</li> </ol> Geode implements Full GQL conformance, supporting all features defined in the standard. <h3 id="how-iso-compliance-works-in-geode" class="position-relative d-flex align-items-center group"> How ISO Compliance Works in Geode <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="how-iso-compliance-works-in-geode" aria-haspopup="dialog" aria-label="Share link: How ISO Compliance Works in Geode"> Share link </button> </h3> <h4 id="standards-first-development" class="position-relative d-flex align-items-center group"> Standards-First Development <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="standards-first-development" aria-haspopup="dialog" aria-label="Share link: Standards-First Development"> Share link </button> </h4>Geode’s development follows a standards-first approach: <ol> <li>Specification Review: New features begin with careful ISO specification analysis</li> <li>Test-Driven Implementation: Conformance tests guide implementation</li> <li>Semantic Validation: Edge cases verified against ISO-specified behavior</li> <li>Continuous Testing: Conformance profile tests run in the CI/CD pipeline</li> <li>Specification Tracking: CANARY markers link code to specification sections</li> </ol> <h4 id="conformance-testing" class="position-relative d-flex align-items-center group"> Conformance Testing <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="conformance-testing" aria-haspopup="dialog" aria-label="Share link: Conformance Testing"> Share link </button> </h4>Geode validates compliance through: <ul> <li>Conformance Test Suite: Profile-based ISO/IEC 39075:2024 tests</li> <li>Syntax Tests: Parser validates all legal GQL syntax</li> <li>Semantic Tests: Query behavior matches ISO-specified semantics</li> <li>Error Tests: Error codes and messages follow ISO conventions</li> <li>Type Tests: Type system behaves according to specification</li> </ul> <h4 id="query-semantics" class="position-relative d-flex align-items-center group"> Query Semantics <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="query-semantics" aria-haspopup="dialog" aria-label="Share link: Query Semantics"> Share link </button> </h4>Geode implements ISO-specified semantics including: <ul> <li>Three-Valued Logic: NULL handling follows ISO rules</li> <li>Operator Precedence: Expression evaluation order matches specification</li> <li>Pattern Matching: Graph pattern matching uses ISO algorithm</li> <li>Aggregation: GROUP BY and aggregation functions match ISO behavior</li> <li>Type Coercion: Implicit conversions follow ISO type compatibility rules</li> </ul> <h4 id="error-handling" class="position-relative d-flex align-items-center group"> Error Handling <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="error-handling" aria-haspopup="dialog" aria-label="Share link: Error Handling"> Share link </button> </h4>ISO compliance extends to error reporting: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Invalid syntax produces ISO-specified error codes MATCH (n:Person WHERE n.age > 30 -- Missing closing parenthesis -- Error: GQL-42601: Syntax error at line 1, column 33 -- Type errors follow ISO conventions MATCH (n:Person) SET n.age = 'not a number' -- Error: GQL-22007: Invalid type conversion: STRING to INTEGER -- Constraint violations use ISO codes INSERT (:Person {id: 12345}) -- Duplicate key -- Error: GQL-23505: Unique constraint violation on Person(id) </code></pre></div> <h3 id="use-cases" class="position-relative d-flex align-items-center group"> Use Cases <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="use-cases" aria-haspopup="dialog" aria-label="Share link: Use Cases"> Share link </button> </h3> <h4 id="portable-query-development" class="position-relative d-flex align-items-center group"> Portable Query Development <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="portable-query-development" aria-haspopup="dialog" aria-label="Share link: Portable Query Development"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- This query works identically on all ISO-compliant databases MATCH (p:Person)-[:KNOWS]->(friend:Person) WHERE p.name = 'Alice' AND friend.age > 25 RETURN friend.name, friend.city ORDER BY friend.age DESC LIMIT 10 </code></pre></div> <h4 id="cross-platform-migration" class="position-relative d-flex align-items-center group"> Cross-Platform Migration <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="cross-platform-migration" aria-haspopup="dialog" aria-label="Share link: Cross-Platform Migration"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python"># Application code is portable across GQL databases import geode_client async def get_user_friends(user_name: str): """Works with any ISO-compliant GQL database.""" query = """ MATCH (u:User {name: $name})-[:FRIEND]->(friend:User) RETURN friend.name, friend.email ORDER BY friend.name """ client = geode_client.open_database('quic://localhost:3141') async with client.connection() as conn: result, _ = await conn.query(query, {'name': user_name}) return [row for row in result.rows] </code></pre></div> <h4 id="standards-based-tooling" class="position-relative d-flex align-items-center group"> Standards-Based Tooling <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="standards-based-tooling" aria-haspopup="dialog" aria-label="Share link: Standards-Based Tooling"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python"># GQL language servers work with any compliant database from gql_language_server import GQLServer server = GQLServer( database_url='quic://localhost:3141', validate_against='ISO/IEC 39075:2024' ) # Provides syntax highlighting, auto-completion, and validation # for any ISO-compliant GQL database </code></pre></div> <h4 id="specification-driven-testing" class="position-relative d-flex align-items-center group"> Specification-Driven Testing <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="specification-driven-testing" aria-haspopup="dialog" aria-label="Share link: Specification-Driven Testing"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python">import pytest from geode_client import connect @pytest.mark.iso_compliance async def test_aggregation_semantics(): """Verify aggregation follows ISO specification.""" async with connect('quic://localhost:3141') as conn: # Create test data await conn.execute(""" INSERT (:Product {id: 1, price: 10.0}), (:Product {id: 2, price: 20.0}), (:Product {id: 3, price: NULL}) """) # ISO specifies that aggregate functions ignore NULL result, _ = await conn.query(""" MATCH (p:Product) RETURN AVG(p.price) AS avg_price, COUNT(p.price) AS count """) row = result.rows[0] if result.rows else None assert row['avg_price'] == 15.0 # (10 + 20) / 2 assert row['count'] == 2 # NULL excluded </code></pre></div> <h3 id="best-practices" class="position-relative d-flex align-items-center group"> Best Practices <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="best-practices" aria-haspopup="dialog" aria-label="Share link: Best Practices"> Share link </button> </h3> <h4 id="writing-portable-queries" class="position-relative d-flex align-items-center group"> Writing Portable Queries <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="writing-portable-queries" aria-haspopup="dialog" aria-label="Share link: Writing Portable Queries"> Share link </button> </h4><ol> <li>Use Standard Syntax: Avoid vendor-specific extensions</li> <li>Test on Multiple Databases: Validate portability with different implementations</li> <li>Follow ISO Naming Conventions: Use standard function and operator names</li> <li>Handle NULL Correctly: Use ISO three-valued logic</li> <li>Document Assumptions: Note any database-specific optimizations</li> </ol> <h4 id="leveraging-conformance" class="position-relative d-flex align-items-center group"> Leveraging Conformance <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="leveraging-conformance" aria-haspopup="dialog" aria-label="Share link: Leveraging Conformance"> Share link </button> </h4><ol> <li>Rely on Semantics: Trust ISO-specified behavior for edge cases</li> <li>Use Standard Functions: Prefer ISO functions over custom implementations</li> <li>Validate Inputs: Use ISO type system for input validation</li> <li>Error Handling: Catch and handle ISO error codes appropriately</li> </ol> <h4 id="migration-planning" class="position-relative d-flex align-items-center group"> Migration Planning <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="migration-planning" aria-haspopup="dialog" aria-label="Share link: Migration Planning"> Share link </button> </h4><ol> <li>Audit Queries: Identify vendor-specific syntax before migration</li> <li>Test Incrementally: Validate each query against target database</li> <li>Use Feature Detection: Check conformance level if using advanced features</li> <li>Plan Transitions: Migrate to ISO syntax gradually</li> </ol> <h4 id="standards-tracking" class="position-relative d-flex align-items-center group"> Standards Tracking <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="standards-tracking" aria-haspopup="dialog" aria-label="Share link: Standards Tracking"> Share link </button> </h4><ol> <li>Monitor Updates: Track ISO working group for future revisions</li> <li>Test New Features: Validate new capabilities against specification</li> <li>Report Issues: Contribute feedback to standards process</li> <li>Community Engagement: Participate in GQL community discussions</li> </ol> <h3 id="performance-considerations" class="position-relative d-flex align-items-center group"> Performance Considerations <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="performance-considerations" aria-haspopup="dialog" aria-label="Share link: Performance Considerations"> Share link </button> </h3> <h4 id="standards-overhead" class="position-relative d-flex align-items-center group"> Standards Overhead <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="standards-overhead" aria-haspopup="dialog" aria-label="Share link: Standards Overhead"> Share link </button> </h4>ISO compliance has minimal performance impact: <ul> <li>Parsing: Standards-compliant parser adds <0.1ms overhead</li> <li>Validation: Type checking and semantic validation is <0.5ms</li> <li>Execution: Standard semantics enable aggressive optimizations</li> <li>Interoperability: Portable queries may miss database-specific optimizations</li> </ul> <h4 id="optimization-within-standards" class="position-relative d-flex align-items-center group"> Optimization Within Standards <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="optimization-within-standards" aria-haspopup="dialog" aria-label="Share link: Optimization Within Standards"> Share link </button> </h4>Geode optimizes while maintaining compliance: <ul> <li>Query Planning: ISO semantics enable advanced optimization rules</li> <li>Index Usage: Standard patterns enable automatic index selection</li> <li>Parallel Execution: Deterministic semantics enable safe parallelization</li> <li>Caching: Standard query plans can be cached and reused</li> </ul> <h4 id="benchmarking" class="position-relative d-flex align-items-center group"> Benchmarking <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="benchmarking" aria-haspopup="dialog" aria-label="Share link: Benchmarking"> Share link </button> </h4>ISO compliance enables fair benchmarks: <ul> <li>Apples-to-Apples: Same queries work across databases</li> <li>Standard Workloads: ISO defines reference workloads for comparison</li> <li>Reproducibility: Standard semantics ensure reproducible results</li> <li>Vendor Neutrality: Eliminate bias from proprietary syntax</li> </ul> <h3 id="troubleshooting" class="position-relative d-flex align-items-center group"> Troubleshooting <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="troubleshooting" aria-haspopup="dialog" aria-label="Share link: Troubleshooting"> Share link </button> </h3> <h4 id="syntax-errors" class="position-relative d-flex align-items-center group"> Syntax Errors <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="syntax-errors" aria-haspopup="dialog" aria-label="Share link: Syntax Errors"> Share link </button> </h4>Symptom: Query fails with syntax error Solutions: <ul> <li>Consult ISO/IEC 39075:2024 specification</li> <li>Verify query against GQL grammar</li> <li>Use GQL-compliant syntax validator</li> <li>Check for vendor-specific extensions</li> </ul> <h4 id="semantic-differences" class="position-relative d-flex align-items-center group"> Semantic Differences <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="semantic-differences" aria-haspopup="dialog" aria-label="Share link: Semantic Differences"> Share link </button> </h4>Symptom: Query produces unexpected results Solutions: <ul> <li>Review ISO-specified semantics for operation</li> <li>Check NULL handling with three-valued logic</li> <li>Verify type coercion rules</li> <li>Test with official conformance suite</li> </ul> <h4 id="migration-issues" class="position-relative d-flex align-items-center group"> Migration Issues <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="migration-issues" aria-haspopup="dialog" aria-label="Share link: Migration Issues"> Share link </button> </h4>Symptom: Queries fail after migration Solutions: <ul> <li>Identify vendor-specific syntax</li> <li>Rewrite using ISO-standard constructs</li> <li>Test against target database conformance level</li> <li>Validate behavior with conformance tests</li> </ul> <h3 id="related-topics" class="position-relative d-flex align-items-center group"> Related Topics <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="related-topics" aria-haspopup="dialog" aria-label="Share link: Related Topics"> Share link </button> </h3><ul> <li><a href="/tags/gql/" >GQL (Graph Query Language)</a> - GQL query language fundamentals</li> <li><a href="/tags/gql-compliance/" >GQL Compliance</a> - Conformance testing and validation</li> <li><a href="/tags/gql-syntax/" >GQL Syntax</a> - Syntax reference and examples</li> <li><a href="/tags/standards/" >Standards</a> - Database standards and specifications</li> <li><a href="/tags/query-language/" >Query Language</a> - Query language concepts</li> <li><a href="/tags/specification/" >Specification</a> - Technical specifications</li> </ul> <h3 id="further-reading" class="position-relative d-flex align-items-center group"> Further Reading <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="further-reading" aria-haspopup="dialog" aria-label="Share link: Further Reading"> Share link </button> </h3> <h4 id="official-specification" class="position-relative d-flex align-items-center group"> Official Specification <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="official-specification" aria-haspopup="dialog" aria-label="Share link: Official Specification"> Share link </button> </h4><ul> <li><a href="https://www.iso.org/standard/76120.html" aria-label="ISO/IEC 39075:2024 Overview – opens in new window" target="_blank" rel="noopener noreferrer" >ISO/IEC 39075:2024 Overview ↗ </a> - Official ISO page</li> <li><a href="/docs/gql-reference/" >GQL Reference</a> - GQL language reference</li> <li><a href="/docs/gql-reference/specification/" >GQL Specification</a> - Technical specification details</li> </ul> <h4 id="implementation-guides" class="position-relative d-flex align-items-center group"> Implementation Guides <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="implementation-guides" aria-haspopup="dialog" aria-label="Share link: Implementation Guides"> Share link </button> </h4><ul> <li><a href="/docs/gql/guide/" >GQL Guide</a> - GQL language guide</li> <li><a href="/docs/gql/conformance-profile/" >GQL Conformance Profile</a> - Conformance testing</li> <li><a href="/docs/guides/migration-guide/" >Migration Guide</a> - Transitioning from other languages</li> </ul> <h4 id="standards-process" class="position-relative d-flex align-items-center group"> Standards Process <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="standards-process" aria-haspopup="dialog" aria-label="Share link: Standards Process"> Share link </button> </h4><ul> <li><a href="https://www.iso.org/committee/45342.html" aria-label="ISO/IEC JTC 1/SC 32/WG 3 – opens in new window" target="_blank" rel="noopener noreferrer" >ISO/IEC JTC 1/SC 32/WG 3 ↗ </a> - Working group</li> </ul> <h3 id="advanced-standards-compliance-features" class="position-relative d-flex align-items-center group"> Advanced Standards Compliance Features <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="advanced-standards-compliance-features" aria-haspopup="dialog" aria-label="Share link: Advanced Standards Compliance Features"> Share link </button> </h3> <h4 id="cross-platform-query-portability" class="position-relative d-flex align-items-center group"> Cross-Platform Query Portability <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="cross-platform-query-portability" aria-haspopup="dialog" aria-label="Share link: Cross-Platform Query Portability"> Share link </button> </h4>Write once, run anywhere with ISO-compliant GQL: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python"># Portable query testing across multiple databases import asyncio from geode_client import Client from neo4j import GraphDatabase from tigergraph import TigerGraphConnection async def test_query_portability(): """Verify same query works across GQL-compliant databases.""" portable_query = """ MATCH (u:User)-[:FRIEND]->(friend:User) WHERE u.age > 25 RETURN friend.name, friend.email ORDER BY friend.name LIMIT 10 """ # Test on Geode client = Client("geode-server", 3141) async with client.connection() as geode: geode_result = await geode.execute(portable_query) geode_rows = [row for row in geode_result.rows] # Test on other ISO-compliant database # (pseudo-code - actual API may differ) other_db = OtherGQLDatabase("other-server", 7687) other_result = other_db.run(portable_query) other_rows = list(other_result) # Results should be semantically equivalent assert len(geode_rows) == len(other_rows) print("✓ Query portable across databases") asyncio.run(test_query_portability()) </code></pre></div> <h4 id="iso-compliance-testing-framework" class="position-relative d-flex align-items-center group"> ISO Compliance Testing Framework <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="iso-compliance-testing-framework" aria-haspopup="dialog" aria-label="Share link: ISO Compliance Testing Framework"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python">class ISOComplianceValidator: """Validate ISO/IEC 39075:2024 compliance.""" def __init__(self, client): self.client = client self.test_results = [] async def run_compliance_suite(self): """Execute ISO conformance profile test suite.""" await self.test_pattern_matching() await self.test_data_manipulation() await self.test_aggregation() await self.test_subqueries() await self.test_null_handling() await self.test_type_system() return self.generate_report() async def test_pattern_matching(self): """Test ISO §7: Pattern Matching.""" tests = [ { 'name': 'Basic node pattern', 'query': 'MATCH (n:Person) RETURN count(n)', 'section': '7.2.1' }, { 'name': 'Relationship pattern', 'query': 'MATCH (a)-[r:KNOWS]->(b) RETURN count(r)', 'section': '7.2.2' }, { 'name': 'Variable-length path', 'query': 'MATCH (a)-[:KNOWS*1..3]->(b) RETURN count(b)', 'section': '7.2.3' } ] for test in tests: try: await self.client.execute(test['query']) self.test_results.append({ 'section': test['section'], 'name': test['name'], 'status': 'PASS' }) except Exception as e: self.test_results.append({ 'section': test['section'], 'name': test['name'], 'status': 'FAIL', 'error': str(e) }) async def test_null_handling(self): """Test ISO §6.4: NULL Handling (Three-valued logic).""" tests = [ { 'query': 'RETURN NULL = NULL AS result', 'expected': None, # NULL, not true! 'section': '6.4.1' }, { 'query': 'RETURN NULL AND true AS result', 'expected': None, 'section': '6.4.2' }, { 'query': 'RETURN NULL OR true AS result', 'expected': True, 'section': '6.4.3' } ] for test in tests: result, _ = await self.client.query(test['query']) row = result.rows[0] if result.rows else None actual = row['result'] status = 'PASS' if actual == test['expected'] else 'FAIL' self.test_results.append({ 'section': test['section'], 'name': f"NULL handling: {test['query']}", 'status': status, 'expected': test['expected'], 'actual': actual }) def generate_report(self): """Generate compliance test report.""" total = len(self.test_results) passed = sum(1 for r in self.test_results if r['status'] == 'PASS') failed = total - passed report = f""" ISO/IEC 39075:2024 Compliance Report ==================================== Total Tests: {total} Passed: {passed} ({100*passed/total:.1f}%) Failed: {failed} ({100*failed/total:.1f}%) """ if failed > 0: report += "Failed Tests:\n" for result in self.test_results: if result.rows['status'] == 'FAIL': report += f" • §{result.rows['section']}: {result.rows['name']}\n" if 'error' in result: report += f" Error: {result.rows['error']}\n" return report </code></pre></div> <h4 id="standards-based-migration-path" class="position-relative d-flex align-items-center group"> Standards-Based Migration Path <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="standards-based-migration-path" aria-haspopup="dialog" aria-label="Share link: Standards-Based Migration Path"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python">class StandardsMigrationHelper: """Help migrate from proprietary to ISO-standard GQL.""" def __init__(self): self.translations = { 'cypher': { # Neo4j Cypher → ISO GQL mappings 'DETACH DELETE': 'DELETE', # ISO includes implicit detach 'CALL {...} YIELD': 'CALL {...}', # Property existence 'exists(n.prop)': 'n.prop IS NOT NULL', }, 'gremlin': { # Gremlin → ISO GQL mappings '.hasLabel("Person")': ':Person', '.has("age", gt(25))': 'WHERE age > 25', '.values("name")': 'RETURN name', } } def translate_query(self, query, source_dialect): """Translate proprietary query to ISO GQL.""" translated = query if source_dialect in self.translations: for pattern, replacement in self.translations[source_dialect].items(): translated = translated.replace(pattern, replacement) return translated def analyze_compatibility(self, query, source_dialect): """Analyze query for ISO compatibility.""" issues = [] # Check for vendor-specific features vendor_patterns = { 'cypher': [ r'CALL apoc\.', r'CALL gds\.', # APOC, GDS libraries r'UNWIND.*WHERE.*IN', # Cypher-specific patterns ], 'gremlin': [ r'\.fold', # Gremlin step r'\.cap\(', # Gremlin cap step ] } if source_dialect in vendor_patterns: for pattern in vendor_patterns[source_dialect]: if re.search(pattern, query): issues.append({ 'type': 'vendor_specific', 'pattern': pattern, 'message': f'Vendor-specific feature: {pattern}' }) return issues # Usage example helper = StandardsMigrationHelper() # Translate Cypher query cypher_query = """ MATCH (n:Person) WHERE exists(n.email) DETACH DELETE n """ iso_query = helper.translate_query(cypher_query, 'cypher') print(iso_query) # Output: # MATCH (n:Person) # WHERE n.email IS NOT NULL # DELETE n </code></pre></div> <h3 id="iso-certification-and-validation" class="position-relative d-flex align-items-center group"> ISO Certification and Validation <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="iso-certification-and-validation" aria-haspopup="dialog" aria-label="Share link: ISO Certification and Validation"> Share link </button> </h3> <h4 id="automated-conformance-testing" class="position-relative d-flex align-items-center group"> Automated Conformance Testing <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="automated-conformance-testing" aria-haspopup="dialog" aria-label="Share link: Automated Conformance Testing"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-yaml" data-lang="yaml"># .github/workflows/iso-conformance.yml name: ISO/IEC 39075:2024 Conformance on: push: branches: [main, develop] pull_request: schedule: - cron: '0 0 * * 0' # Weekly jobs: conformance-tests: runs-on: ubuntu-latest steps: - uses: actions/checkout@v4 - name: Setup Geode run: | docker pull codepros/geode:latest docker run -d -p 3141:3141 codepros/geode:latest - name: Run ISO Test Suite run: | python scripts/iso_conformance_tests.py \ --host localhost \ --port 3141 \ --report-format json \ --output conformance-report.json - name: Upload Results uses: actions/upload-artifact@v3 with: name: iso-conformance-report path: conformance-report.json - name: Check Pass Rate run: | pass_rate=$(jq '.pass_rate' conformance-report.json) if (( $(echo "$pass_rate < 100" | bc -l) )); then echo "Conformance test failure: $pass_rate% pass rate" exit 1 fi </code></pre></div> <h4 id="compliance-documentation-generation" class="position-relative d-flex align-items-center group"> Compliance Documentation Generation <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="compliance-documentation-generation" aria-haspopup="dialog" aria-label="Share link: Compliance Documentation Generation"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python">class ComplianceDocGenerator: """Generate ISO compliance documentation.""" def __init__(self, test_results): self.results = test_results def generate_markdown_report(self): """Generate markdown compliance report.""" report = """# ISO/IEC 39075:2024 Compliance Report ## Executive Summary Geode Graph Database v0.2.18 publishes the ISO/IEC 39075:2024 compliance (Graph Query Language) international standard. ## Test Results Summary | Category | Tests | Passed | Pass Rate | |------------------------|-------|--------|-----------| """ for category, stats in self.results.items(): report += f"| {category:22} | {stats['total']:5} | {stats['passed']:6} | {stats['pass_rate']:8.1f}% |\n" report += """ ## Detailed Results """ for category, stats in self.results.items(): report += f"### {category}\n\n" for test in stats['tests']: status = '✓' if test['passed'] else '✗' report += f"{status} **{test['name']}** (§{test['section']})\n" if not test['passed']: report += f" - Error: {test['error']}\n" report += "\n" return report def generate_html_report(self): """Generate HTML compliance report with interactive features.""" # Implementation for HTML report pass </code></pre></div> <h3 id="performance-implications-of-standards-compliance" class="position-relative d-flex align-items-center group"> Performance Implications of Standards Compliance <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="performance-implications-of-standards-compliance" aria-haspopup="dialog" aria-label="Share link: Performance Implications of Standards Compliance"> Share link </button> </h3> <h4 id="benchmarking-iso-compliant-queries" class="position-relative d-flex align-items-center group"> Benchmarking ISO-Compliant Queries <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="benchmarking-iso-compliant-queries" aria-haspopup="dialog" aria-label="Share link: Benchmarking ISO-Compliant Queries"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python">import time from statistics import mean, stdev async def benchmark_iso_compliance_overhead(): """Measure performance impact of ISO compliance features.""" benchmarks = [] # Benchmark 1: Type checking overhead queries_with_types = [ "MATCH (n:Person) WHERE n.age > 25 RETURN n", "MATCH (n:Person) WHERE toInteger(n.age) > 25 RETURN n", ] for query in queries_with_types: timings = [] for _ in range(100): start = time.time() await client.execute(query) timings.append(time.time() - start) benchmarks.append({ 'query': query, 'mean_ms': mean(timings) * 1000, 'stdev_ms': stdev(timings) * 1000 }) # Benchmark 2: NULL handling overhead null_queries = [ "MATCH (n) WHERE n.optional IS NULL RETURN count(n)", "MATCH (n) WHERE NOT EXISTS(n.optional) RETURN count(n)", ] for query in null_queries: timings = [] for _ in range(100): start = time.time() await client.execute(query) timings.append(time.time() - start) benchmarks.append({ 'query': query, 'mean_ms': mean(timings) * 1000, 'stdev_ms': stdev(timings) * 1000 }) # Print results print("\nISO Compliance Performance Impact") print("=" * 60) for b in benchmarks: print(f"\nQuery: {b['query']}") print(f" Mean: {b['mean_ms']:.2f}ms (±{b['stdev_ms']:.2f}ms)") # Typical results show <2% overhead for compliance features asyncio.run(benchmark_iso_compliance_overhead()) </code></pre></div> <h4 id="optimization-while-maintaining-compliance" class="position-relative d-flex align-items-center group"> Optimization While Maintaining Compliance <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="optimization-while-maintaining-compliance" aria-haspopup="dialog" aria-label="Share link: Optimization While Maintaining Compliance"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python">class ISOCompliantOptimizer: """Optimize queries while preserving ISO semantics.""" def optimize_query(self, query): """Apply optimizations that maintain ISO compliance.""" optimizations = [] # Optimization 1: Predicate pushdown (ISO-safe) if self.can_push_predicate(query): query = self.push_predicate(query) optimizations.append('predicate_pushdown') # Optimization 2: Index hints (ISO extension) if self.should_add_index_hint(query): query = self.add_index_hint(query) optimizations.append('index_hint') # Optimization 3: Parallel execution (preserves ISO semantics) if self.can_parallelize(query): query = self.add_parallel_hint(query) optimizations.append('parallel_execution') return query, optimizations def validate_optimization(self, original, optimized): """Ensure optimization doesn't change ISO semantics.""" # Run both queries and compare results original_result = self.execute_and_hash(original) optimized_result = self.execute_and_hash(optimized) if original_result != optimized_result: raise ValueError("Optimization changed query semantics!") return True </code></pre></div>

Popular

Related Articles

GQL Conformance Profile