Scalability and efficiency in multirelational