Re: [HACKERS] Proposal: First step towards Intelligent, integrated database

2010-12-01 Thread ghatpande
The aim of HTSQL is only to avoid joins. Need to setup HTSQL server. On startup introspects table relationships. Relationships are edges in a graph model. Processor translates graph requests into SQL. Some limitations: No custom commands, primitive formatters. Query results are not streaming.

Re: [HACKERS] Proposal: First step towards Intelligent,integrated database

2010-12-01 Thread David Fetter
On Wed, Dec 01, 2010 at 03:19:32PM +0500, ghatpa...@vsnl.net wrote: > Hello, > > Here is the proposal: My 1st step towards Intelligent, Integrated database. You're implying that databases are stupid and incoherent. This is *not* a great way to start. Cheers, David. -- David Fetter http://fet

Re: [HACKERS] Proposal: First step towards Intelligent,integrated database

2010-12-01 Thread Pavel Stehule
Hello there was a very similar design in ANSI SQL 99. I have documentation only in Czech, but probably you can find a sources about OOP part in ANSI/SQL. CREATE TABLE children( id int primary key, parent ref(parents) name .. ... and you can write queries like SELECT name, parent->name F

Re: [HACKERS] Proposal: First step towards Intelligent,integrated database

2010-12-01 Thread Dann Corbit
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

[HACKERS] Proposal: First step towards Intelligent,integrated database

2010-12-01 Thread ghatpande
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: CustCodeNumber(5), CustName Varchar(30