Path: csiph.com!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From: Robert Klemme <shortcutter@googlemail.com>
Newsgroups: comp.lang.java.programmer
Subject: Re: Is there a SQL hashmap?
Date: Fri, 29 Jun 2018 23:20:10 +0200
Lines: 29
Message-ID: <fpnm4bFpcidU1@mid.individual.net>
References: <031dadbc-3c27-4021-9b1d-8cb860c5e9f6@googlegroups.com> <fpfmegF9ol2U1@mid.individual.net> <34af17f0-0d59-4b87-8af0-01ce37deb5cb@googlegroups.com> <ph19nj$126q$1@gioia.aioe.org> <1d1add22-1fd4-45b1-964f-9501db447c91@googlegroups.com> <dc101d7c-a259-4364-b905-9c1346420149@googlegroups.com> <448e760f-e34d-4129-8ca6-5a699023789f@googlegroups.com> <slrnpja12m.abg.avl@logic.at> <ph3e0o$tu6$2@news.albasani.net> <ph3nqc$12e1$2@gioia.aioe.org> <ph3qfc$67p$2@news.albasani.net> <76690c5f-8ceb-46ce-ba14-9d14d3c4608d@googlegroups.com> <ph58oq$md4$1@news.albasani.net> <1efce28f-d38a-4a42-b5c8-c69a0753fdd3@googlegroups.com> <ph5d1k$md4$2@news.albasani.net>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
X-Trace: individual.net fnzkJclpdnB8FkpSZtiWdQQD70vk26a+R7Z0JTN0Z7qWSCOnU=
Cancel-Lock: sha1:0rWlGj1hxscpxUWHJs2L+QgDg6g=
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.8.0
In-Reply-To: <ph5d1k$md4$2@news.albasani.net>
Content-Language: en-US
Xref: csiph.com comp.lang.java.programmer:38459

On 29.06.2018 15:43, Martin Gregorie wrote:
> On Fri, 29 Jun 2018 06:11:02 -0700, Eric Douglas wrote:
> 
>> On Friday, June 29, 2018 at 8:30:27 AM UTC-4, Martin Gregorie wrote:
>>> Yes, I'm not sure why I said 'parallel'. What I meant was that, if I
>>> understood you correctly, you could do what you need by building a new
>>> table and populating it by joining existing tables. All I was
>>> suggesting that, rather than creating the new table, you use a view
>>> instead. For your purpose it can be treated as another table. However,
>>> it does not carry any maintenance overheads because its best thought of
>>> as being a virtual table that only exists when its queried.
>>>
>>>
>> as in you can create a 'table' in a database as a view to a table in a
>> different database?
> 
> As in 'Add a view to the existing database'.

As far as I understood Eric he does not want to modify the existing 
database in _any_ way.  If you can create a view there then you can also 
add a table with the mapping against which you can join.

Cheers

	robert

-- 
remember.guy do |as, often| as.you_can - without end
http://blog.rubybestpractices.com/