加入收藏 | 设为首页 | 会员中心 | 我要投稿 李大同 (https://www.lidatong.com.cn/)- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置: 首页 > 编程开发 > Python > 正文

python – poset的高效增量实现

发布时间:2020-12-20 13:23:29 所属栏目:Python 来源:网络整理
导读:我在SQLAlchemy方面实现了一个具有 Partially Ordered Set数学特性的结构,我需要能够一次添加和删除一个边. 在我目前的最佳设计中,我使用了两个邻接列表,一个是赋值列表(大约是Hass图中的边缘),因为我需要保留哪些节点对被显式设置为有序,另一个邻接列表是传
我在SQLAlchemy方面实现了一个具有 Partially Ordered Set数学特性的结构,我需要能够一次添加和删除一个边.

在我目前的最佳设计中,我使用了两个邻接列表,一个是赋值列表(大约是Hass图中的边缘),因为我需要保留哪些节点对被显式设置为有序,另一个邻接列表是传递关闭第一个,这样我就可以有效地查询一个节点是否相对于另一个节点进行了排序.现在,每次在赋值邻接列表中添加或删除边时,我都会重新计算传递闭包.

它看起来像这样:

assignment = Table('assignment',metadata,Column('parent',Integer,ForeignKey('node.id')),Column('child',ForeignKey('node.id')))

closure = Table('closure',Column('ancestor',Column('descendent',ForeignKey('node.id')))

class Node(Base):
    __tablename__ = 'node'
    id = Column(Integer,primary_key=True)

    parents = relationship(Node,secondary=assignment,backref='children',primaryjoin=id == assignment.c.parent,secondaryjoin=id == assignment.c.child)

    ancestors = relationship(Node,secondary=closure,backref='descendents',primaryjoin=id == closure.c.ancestor,secondaryjoin=id == closure.c.descendent,viewonly=True)

    @classmethod
    def recompute_ancestry(cls.conn):
        conn.execute(closure.delete())
        adjacent_values = conn.execute(assignment.select()).fetchall()
        conn.execute(closure.insert(),floyd_warshall(adjacent_values))

其中floyd_warshall()是同名的算法实现.

这让我有两个问题.第一个是它看起来效率不高,但我不确定我可以使用哪种算法.

第二个更多的是关于每次发生赋值时必须显式调用Node.recompute_ancestry()的实用性,并且只有在将赋值刷新到会话中并且具有正确的连接之后.如果我想看到ORM中反映的更改,我将不得不再次刷新会话.我认为,如果我可以用orm表达重新计算的祖先操作,那将会容易得多.

解决方法

好吧,我去解决了我自己的问题.它的原始部分是将Floyd-Warshall算法应用于父节点的祖先的后代与子节点的后代的祖先的交集,但仅将输出应用于父节点的祖先和孩子的后代.我花了很多时间在上面,我最后发布了流程 on my blog,但这里是代码.

from sqlalchemy import *
from sqlalchemy.orm import *
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()

association_table = Table('edges',Base.metadata,Column('predecessor',ForeignKey('nodes.id'),primary_key=True),Column('successor',primary_key=True))

path_table = Table('paths',primary_key=True))

class Node(Base):
    __tablename__ = 'nodes'
    id = Column(Integer,primary_key=True)
    # extra columns

    def __repr__(self):
        return '<Node #%r>' % (self.id,)

    successors = relationship('Node',backref='predecessors',secondary=association_table,primaryjoin=id == association_table.c.predecessor,secondaryjoin=id == association_table.c.successor)

    before = relationship('Node',backref='after',secondary=path_table,primaryjoin=id == path_table.c.predecessor,secondaryjoin=id == path_table.c.successor)

    def __lt__(self,other):
        return other in self.before

    def add_successor(self,other):
        if other in self.successors:
            return
        self.successors.append(other)
        self.before.append(other)
        for descendent in other.before:
            if descendent not in self.before:
                self.before.append(descendent)
        for ancestor in self.after:
            if ancestor not in other.after:
                other.after.append(ancestor)

    def del_successor(self,other):
        if not self < other:
            # nodes are not connected,do nothing!
            return
        if not other in self.successors:
            # nodes aren't adjacent,but this *could*
            # be a warning...
            return

        self.successors.remove(other)

        # we buld up a set of nodes that will be affected by the removal
        # we just did.  
        ancestors = set(other.after)
        descendents = set(self.before)

        # we also need to build up a list of nodes that will determine
        # where the paths may be.  basically,we're looking for every 
        # node that is both before some node in the descendents and
        # ALSO after the ancestors.  Such nodes might not be comparable
        # to self or other,but may still be part of a path between
        # the nodes in ancestors and the nodes in descendents.
        ancestors_descendents = set()
        for ancestor in ancestors:
            ancestors_descendents.add(ancestor)
            for descendent in ancestor.before:
                ancestors_descendents.add(descendent)

        descendents_ancestors = set()
        for descendent in descendents:
            descendents_ancestors.add(descendent)
            for ancestor in descendent.after:
                descendents_ancestors.add(ancestor)
        search_set = ancestors_descendents & descendents_ancestors

        known_good = set() # This is the 'paths' from the 
                           # original algorithm.  

        # as before,we need to initialize it with the paths we 
        # know are good.  this is just the successor edges in
        # the search set.
        for predecessor in search_set:
            for successor in search_set:
                if successor in predecessor.successors:
                    known_good.add((predecessor,successor))

        # We now can work our way through floyd_warshall to resolve
        # all adjacencies:
        for ancestor in ancestors:
            for descendent in descendents:
                if (ancestor,descendent) in known_good:
                    # already got this one,so we don't need to look for an
                    # intermediate.  
                    continue
                for intermediate in search_set:
                    if (ancestor,intermediate) in known_good 
                            and (intermediate,descendent) in known_good:
                        known_good.add((ancestor,descendent))
                        break # don't need to look any further for an
                              # intermediate,we can move on to the next
                              # descendent.  


        # sift through the bad nodes and update the links
        for ancestor in ancestors:
            for descendent in descendents:
                if descendent in ancestor.before 
                        and (ancestor,descendent) not in known_good:
                    ancestor.before.remove(descendent)

(编辑:李大同)

【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!

    推荐文章
      热点阅读