Groups > comp.lang.java.programmer > #38461

Re: Is there a SQL hashmap?

Path	csiph.com!news.swapon.de!news.albasani.net!.POSTED!not-for-mail
From	Martin Gregorie <martin@mydomain.invalid>
Newsgroups	comp.lang.java.programmer
Subject	Re: Is there a SQL hashmap?
Date	Fri, 29 Jun 2018 22:34:33 +0000 (UTC)
Organization	albasani.net
Lines	37
Message-ID	<ph6c5p$81o$1@news.albasani.net> (permalink)
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> <fpnm4bFpcidU1@mid.individual.net>
Mime-Version	1.0
Content-Type	text/plain; charset=UTF-8
Content-Transfer-Encoding	8bit
X-Trace	news.albasani.net +pnHxOz75fAqqOYH7P1GvR7YieNdo6NPBqnGW3EuiO+Nq64H4jLTHrTdfDVCHIg4EUU1QQp5F/PEkmUTjvE1YA==
NNTP-Posting-Date	Fri, 29 Jun 2018 22:34:33 +0000 (UTC)
Injection-Info	news.albasani.net; logging-data="ZM4RZn8OOJmj3HwVc1IPFQXh1/TKMXYqvPCcdwmozKVKQ8TRvdtPhjJjk9CZmHYpAGH7CslenWe4ETq0sPO0reXMkIoHjbfuy99N7WlDTjkCT+fVzS0TtME6RUn3Vy9e"; mail-complaints-to="abuse@albasani.net"
User-Agent	Pan/0.145 (Duplicitous mercenary valetism; d7e168a git.gnome.org/pan2)
Cancel-Lock	sha1:OCOhe+YQW/QpWYYc21Q8LoHgLF4=
Xref	csiph.com comp.lang.java.programmer:38461

Show key headers only | View raw

On Fri, 29 Jun 2018 23:20:10 +0200, Robert Klemme wrote:

> 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.
>
I know, but I think its worthwhile letting him know what a view is, its 
likely impact and how I understand it to work on at least one DB 
(PosgreSQL). At least it gives him more information to work with.

Although I haven't used SQLServer, I did do a fair bit of work 
programming and doing DBA stuff with Sybase, though I don't recall using 
views on it. SQL Server was forked from the Sybase RDBMS.


-- 
Martin    | martin at
Gregorie  | gregorie dot org

Thread

Is there a SQL hashmap? Eric Douglas <e.d.programmer@gmail.com> - 2018-06-26 09:03 -0700
  Re: Is there a SQL hashmap? Arne Vajhøj <arne@vajhoej.dk> - 2018-06-26 12:23 -0400
  Re: Is there a SQL hashmap? Robert Klemme <shortcutter@googlemail.com> - 2018-06-26 22:36 +0200
    Re: Is there a SQL hashmap? Eric Douglas <e.d.programmer@gmail.com> - 2018-06-26 14:02 -0700
      Re: Is there a SQL hashmap? Arne Vajhøj <arne@vajhoej.dk> - 2018-06-27 20:22 -0400
        Re: Is there a SQL hashmap? firstsql@gmail.com - 2018-06-27 20:53 -0700
        Re: Is there a SQL hashmap? Eric Douglas <e.d.programmer@gmail.com> - 2018-06-28 05:03 -0700
          Re: Is there a SQL hashmap? Eric Douglas <e.d.programmer@gmail.com> - 2018-06-28 06:49 -0700
            Re: Is there a SQL hashmap? Eric Douglas <e.d.programmer@gmail.com> - 2018-06-28 07:38 -0700
              Re: Is there a SQL hashmap? Andreas Leitgeb <avl@logic.at> - 2018-06-28 15:52 +0000
                Re: Is there a SQL hashmap? Martin Gregorie <martin@mydomain.invalid> - 2018-06-28 19:47 +0000
                Re: Is there a SQL hashmap? Arne Vajhøj <arne@vajhoej.dk> - 2018-06-28 18:34 -0400
                Re: Is there a SQL hashmap? Martin Gregorie <martin@mydomain.invalid> - 2018-06-28 23:20 +0000
                Re: Is there a SQL hashmap? Arne Vajhøj <arne@vajhoej.dk> - 2018-06-28 20:07 -0400
                Re: Is there a SQL hashmap? Eric Douglas <e.d.programmer@gmail.com> - 2018-06-29 05:11 -0700
                Re: Is there a SQL hashmap? Martin Gregorie <martin@mydomain.invalid> - 2018-06-29 12:30 +0000
                Re: Is there a SQL hashmap? Eric Douglas <e.d.programmer@gmail.com> - 2018-06-29 06:11 -0700
                Re: Is there a SQL hashmap? Martin Gregorie <martin@mydomain.invalid> - 2018-06-29 13:43 +0000
                Re: Is there a SQL hashmap? Robert Klemme <shortcutter@googlemail.com> - 2018-06-29 23:20 +0200
                Re: Is there a SQL hashmap? Martin Gregorie <martin@mydomain.invalid> - 2018-06-29 22:34 +0000
                Re: Is there a SQL hashmap? Arne Vajhøj <arne@vajhoej.dk> - 2018-06-30 16:36 -0400
                Re: Is there a SQL hashmap? Martin Gregorie <martin@mydomain.invalid> - 2018-06-30 23:00 +0000
              Re: Is there a SQL hashmap? Robert Klemme <shortcutter@googlemail.com> - 2018-06-29 23:34 +0200
            Re: Is there a SQL hashmap? Arne Vajhøj <arne@vajhoej.dk> - 2018-06-30 17:51 -0400
              Re: Is there a SQL hashmap? Eric Douglas <e.d.programmer@gmail.com> - 2018-07-03 07:13 -0700

csiph-web