Re: [netmod] [CCAMP][TEAS][NETMOD] Efficiency issues with YANG model data in integration

Randy Presuhn <randy_presuhn@alumni.stanford.edu> Thu, 17 March 2022 17:29 UTC

Return-Path: <randy_presuhn@alumni.stanford.edu>
X-Original-To: netmod@ietfa.amsl.com
Delivered-To: netmod@ietfa.amsl.com
Received: from localhost (localhost [127.0.0.1]) by ietfa.amsl.com (Postfix) with ESMTP id 3C3A13A13F6 for <netmod@ietfa.amsl.com>; Thu, 17 Mar 2022 10:29:50 -0700 (PDT)
X-Virus-Scanned: amavisd-new at amsl.com
X-Spam-Flag: NO
X-Spam-Score: -1.908
X-Spam-Level:
X-Spam-Status: No, score=-1.908 tagged_above=-999 required=5 tests=[BAYES_00=-1.9, NICE_REPLY_A=-0.001, RCVD_IN_MSPIKE_H3=0.001, RCVD_IN_MSPIKE_WL=0.001, SPF_HELO_NONE=0.001, SPF_PASS=-0.001, T_SCC_BODY_TEXT_LINE=-0.01, URIBL_BLOCKED=0.001] autolearn=ham autolearn_force=no
Received: from mail.ietf.org ([4.31.198.44]) by localhost (ietfa.amsl.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 1zij3XsQyy_4 for <netmod@ietfa.amsl.com>; Thu, 17 Mar 2022 10:29:49 -0700 (PDT)
Received: from mail-pg1-f181.google.com (mail-pg1-f181.google.com [209.85.215.181]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) by ietfa.amsl.com (Postfix) with ESMTPS id F19903A13EC for <netmod@ietf.org>; Thu, 17 Mar 2022 10:29:48 -0700 (PDT)
Received: by mail-pg1-f181.google.com with SMTP id t187so3162030pgb.1 for <netmod@ietf.org>; Thu, 17 Mar 2022 10:29:48 -0700 (PDT)
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:message-id:date:mime-version:user-agent:subject :content-language:to:references:from:in-reply-to :content-transfer-encoding; bh=9HwAYs+bZQDiQrZpqzA30xDc4w1mQFr+hO69Z4JYUjs=; b=OCA6rIW/5wyHWMrtjDSFmtZWYUIGmnJedyqLPAz+3/S0QCxzqwFmWqrXhMJeL2bh/u MGl0ifvd7G7mz8HsXcNi8MdYNxZ+Dn6yMr2LsklNW+2d38QXSWlNQTX16Y3+EJtJ9rOW D/43vxyOSqdeftXAKhnAhLIkFW7koiFxWBBXL0QJBt1xcLBw+MimVHypvwPpbpa9Dn3K NlwmaeQi/xSN7CNojOB1qibiCjOJ03BRg3j/5Gx1J2/0k599zBBHsEF7b/hfmH9z2ipF Cm3AQzXcRmhM0EF5fd3rEvGHWrjEDCR3QzHU4ewWKarZNhmbwGm3krQc+7y16bU2BLFy 0CHg==
X-Gm-Message-State: AOAM531j0I1KC9m8mMVh6rZ+uJyys38NGvWPx2uM1xdS44l5QXxCVNDe ywJ4fhzrgXM5tpl7nzprLR1FoFyvtc0Esg==
X-Google-Smtp-Source: ABdhPJwZoVCuA28Z7/p0Yxal1+73x61zUMU+6NBbrp6nsLhJA8t4py5+EinjeCDHTvk+jCdOhCgkzw==
X-Received: by 2002:a65:6410:0:b0:381:7aad:59ea with SMTP id a16-20020a656410000000b003817aad59eamr4616607pgv.302.1647538188248; Thu, 17 Mar 2022 10:29:48 -0700 (PDT)
Received: from ?IPV6:2601:646:9300:607:c916:3b6:d61:a5c1? ([2601:646:9300:607:c916:3b6:d61:a5c1]) by smtp.gmail.com with ESMTPSA id f13-20020a056a001acd00b004f76d35c1dcsm7135083pfv.104.2022.03.17.10.29.47 for <netmod@ietf.org> (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 17 Mar 2022 10:29:47 -0700 (PDT)
Message-ID: <a25e4bfe-9f1f-61c0-c857-da5355b8909b@alumni.stanford.edu>
Date: Thu, 17 Mar 2022 10:29:46 -0700
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:91.0) Gecko/20100101 Thunderbird/91.7.0
Content-Language: en-US
To: netmod@ietf.org
References: <67664d6fff3e4125a1ac026030ef067c@huawei.com> <AM7PR07MB62483C667188F5EBBE26F6B4A0129@AM7PR07MB6248.eurprd07.prod.outlook.com>
From: Randy Presuhn <randy_presuhn@alumni.stanford.edu>
In-Reply-To: <AM7PR07MB62483C667188F5EBBE26F6B4A0129@AM7PR07MB6248.eurprd07.prod.outlook.com>
Content-Type: text/plain; charset="UTF-8"; format="flowed"
Content-Transfer-Encoding: 7bit
Archived-At: <https://mailarchive.ietf.org/arch/msg/netmod/_qzT9fMIIWNTgfwdPWqPiCZNjuU>
Subject: Re: [netmod] [CCAMP][TEAS][NETMOD] Efficiency issues with YANG model data in integration
X-BeenThere: netmod@ietf.org
X-Mailman-Version: 2.1.29
Precedence: list
List-Id: NETMOD WG list <netmod.ietf.org>
List-Unsubscribe: <https://www.ietf.org/mailman/options/netmod>, <mailto:netmod-request@ietf.org?subject=unsubscribe>
List-Archive: <https://mailarchive.ietf.org/arch/browse/netmod/>
List-Post: <mailto:netmod@ietf.org>
List-Help: <mailto:netmod-request@ietf.org?subject=help>
List-Subscribe: <https://www.ietf.org/mailman/listinfo/netmod>, <mailto:netmod-request@ietf.org?subject=subscribe>
X-List-Received-Date: Thu, 17 Mar 2022 17:29:50 -0000

Hi -

On 2022-03-17 9:32 AM, tom petch wrote:
...
> From: netmod <netmod-bounces@ietf.org> on behalf of yuchaode <yuchaode=40huawei.com@dmarc.ietf.org>
> Sent: 15 March 2022 01:30
> To: 'ccamp@ietf.org'; 'teas@ietf.org'; 'netmod@ietf.org'
> Cc: Fatai Zhang
> 
> I have a question about YANG data model efficiency issues discovered during integration with OSS.
...
>  From the point of view of data model definition, it is convenient to define objects and their relationship using a tree structure.
> 
> However, from a practical perspective, relational databases, in which these objects are saved in different tables, are widely used by network controllers and OSS/BSS. In this type of implementations, the model data need to be cut into several pieces of small object data for management and this is causing some efficiency issues with the integration between systems.
> 
> <tp>
> When the data definition language that we know as YANG was being specified, the question did arise of how object-oriented it should be and the consensus was that it should not be.  Seeking to retrofit such a concept might be a bit like finding late in the day that the class definitions that have been chosen do not go high up enough the tree:-(
> 
> An interesting idea but I am not sure how feasible it will prove to be.
...

The efficiency issue (mapping an object-oriented model to a relational
implementation) occurs even with slightly object-oriented modeling
techniques like SNMP's SMI, and doesn't get substantially worse with
full-on object-oriented ones like GDMO.  (I think the problem is
actually easier if one starts from the GDMO perspective.)  Our
experience over 30 years ago was that it is tractable, but it
requires careful thought about the representation of fully distinguished
names and of values of types with complex syntax.  If you think about
it in the right way, the depth of nesting doesn't really matter.

Randy