From: ghatpande@vsnl.net
To: Dann Corbit <DCorbit@connx.com>
Cc: pgsql hackers <pgsql-hackers@postgresql.org>
Subject: Re: Proposal: First step towards Intelligent, integrateddatabase
Date: Wed, 01 Dec 2010 15:46:12 +0500
Message-ID: <e4c6b847677.4cf66dc4@vsnl.net> (raw)
In-Reply-To: <87F42982BF2B434F831FCEF4C45FC33E4209B193@EXCHANGE.corporate.connx.com>
References: <e66387cf27cb.4cf66784@vsnl.net>
<87F42982BF2B434F831FCEF4C45FC33E4209B193@EXCHANGE.corporate.connx.com>
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@connx.com>
Date: Wednesday, December 1, 2010 4:04 pm
Subject: RE: [HACKERS] Proposal: First step towards Intelligent,integrateddatabase
To: "'ghatpande@vsnl.net'" <ghatpande@vsnl.net>, pgsql hackers <pgsql-hackers@postgresql.org>
> I am probably just being thick, but how is your idea different
> from create domain:
> http://www.postgresql.org/docs/current/static/sql-createdomain.html
>
>
> From: pgsql-hackers-owner@postgresql.org [mailto:pgsql-hackers-
> owner@postgresql.org] On Behalf Of ghatpande@vsnl.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.
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: ghatpande@vsnl.net, DCorbit@connx.com
Subject: Re: Proposal: First step towards Intelligent, integrateddatabase
In-Reply-To: <e4c6b847677.4cf66dc4@vsnl.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox