Database engine that share a row among multiple tables

0 votes

1 answer

56 views

database-design database-engine virtual-columns

                          I'm wondering whether exists any database engine that can share cells or rows amongst many tables. For example:

    TABLE Customer (
       CID: int
       Fullname: nvarchar(50)
       Age: int
    )
    
    TABLE Group (
       GID: int
       Name: nvarchar(50)
    )
    
    TABLE Customer_Group (
       CusName: nvarchar(50)
       GrpName: nvarchar(50)
    )

In which, Customer_Group is designated for a certain query, like a column family in Cassandra. Now I want to insert to Customer_Group table a row whose CusName cell references to Fullname cell of a row in table Customer. Similar to GrpName.

As a result, when I update Fullname in Customer table, I don't have to update Customer_Group table, because it references to same cell address. And Customer_Group table itself doesn't have to store actual data for CusName but in fact is a pointer.

Does anyone know what database engine supports this idea? And is it a good idea though?
                        

Asked by hirikarate (103 rep)

Mar 26, 2014, 04:46 AM
Last activity: Mar 26, 2014, 07:06 AM

Database engine that share a row among multiple tables

Related Questions