Skip site navigation (1) Skip section navigation (2)

Re: Proposal: First step towards Intelligent, integrateddatabase

From: ghatpande(at)vsnl(dot)net
To: Dann Corbit <DCorbit(at)connx(dot)com>
Cc: pgsql hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Proposal: First step towards Intelligent, integrateddatabase
Date: 2010-12-01 10:46:12
Message-ID: (view raw or whole thread)
Lists: pgsql-hackers
Create domain is only useful for abstracting common constraints on fields into single location for maintenance. It may not be useful to link tables.

----- Original Message -----
From: Dann Corbit <DCorbit(at)connx(dot)com>
Date: Wednesday, December 1, 2010 4:04 pm
Subject: RE: [HACKERS] Proposal: First step towards Intelligent,integrateddatabase
To: "'ghatpande(at)vsnl(dot)net'" <ghatpande(at)vsnl(dot)net>, pgsql hackers <pgsql-hackers(at)postgresql(dot)org>

> I am probably just being thick, but how is your idea different 
> from create domain:
> From: pgsql-hackers-owner(at)postgresql(dot)org [mailto:pgsql-hackers-
> owner(at)postgresql(dot)org] On Behalf Of ghatpande(at)vsnl(dot)net
> Sent: Wednesday, December 01, 2010 2:20 AM
> To: pgsql hackers
> Subject: [HACKERS] Proposal: First step towards 
> Intelligent,integrated database
> Importance: High
> Hello,
> Here is the proposal:  My 1st step towards Intelligent, Integrated 
> database. I am explaining the proposal with the use of example.
> Example: We will have a master table say CustMast and a 
> transaction table say salesOrder table.
> View of CustMast:
> CustCode    Number(5),
> CustName  Varchar(30),
> CustAdrsLine1   Varchar,
> CustAdrsLine2   varchar  etc.
> View of SalesOrder:
> Sordno    Number(8),
> Sorddt     date,
> CustCode  Number(5)  -  present way of defining.
> Proposed way is:
> CustCode Object CustMast.     --- New data type to be introduced 
> called "O" Object and create table definition to be modified 
> whenever data type is 'O', it will accept object name (in this 
> case table name). Here I want to inform data definition that field 
> and its data type is already defined in master table and use the 
> same data type here and both tables are linked with this field.
> We will be using same field name in both tables if not along with 
> table name field name is to be accepted in create table definition.
> Advantages:
> 1.       Now database knows that custcode in salesorder is a 
> foreign key, a table constraint can be created. It also knows that 
> index to be created on this field.
> 2.       In present situation select statement for selecting 
> values from join of both tables will be
> Select sordno, sorddt, custcode, custname, custadrsline1
> from salesorder, custmast
> where salesorder.custcode=custmast.custcode.
> 3.       In proposed way we can write this statement as:
> Select sordno, sorddt, custcode, custname, custadrsline1
> from salesorder  (with proper changes in program which pickup 
> values from select statement.
> 4.       Field can be from another table in same database or from 
> Excel sheet column.
> 5.       Views need not be created as all tables are properly 
> linked with each other in an application.
> 6.       This is only first step and many advantages can be a 
> result of brainstorm.
> 7.    This will change RDBMS, Tools and ERP to next generation.
> For any clarifications pl contact. Pl give your feedback.
> Regards Many,
> Vijay Ghatpande.
> Cell: +91 9822456142.

In response to


pgsql-hackers by date

Next:From: Daniel LoureiroDate: 2010-12-01 11:01:04
Subject: Re: DELETE with LIMIT (or my first hack)
Previous:From: Dimitri FontaineDate: 2010-12-01 10:35:50
Subject: Re: We really ought to do something about O_DIRECT and data=journalled on ext4

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group