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

Re: Is there a SQL hashmap?

From	Martin Gregorie <martin@mydomain.invalid>
Newsgroups	comp.lang.java.programmer
Subject	Re: Is there a SQL hashmap?
Date	2018-06-28 23:20 +0000
Organization	albasani.net
Message-ID	<ph3qfc$67p$2@news.albasani.net> (permalink)
References	(5 earlier) <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>

Show all headers | View raw

On Thu, 28 Jun 2018 18:34:53 -0400, Arne Vajhøj wrote:

> On 6/28/2018 3:47 PM, Martin Gregorie wrote:
>> On Thu, 28 Jun 2018 15:52:54 +0000, Andreas Leitgeb wrote:
>>> Eric Douglas <e.d.programmer@gmail.com> wrote:
>>>> So JDBC can access both but as far as I know cannot join both in the
>>>> same select statement.
>>>
>>> Further approaches:
>>>
>>> - adding another table to a database shouldn't really interfere much
>>>      with the 3rd party software accessing it.
>>>
>>> - maybe the database already has a simple table of two string columns,
>>>      where you could add the key-value pairs as extra rows, maybe aug-
>>>      menting the keys to not interfere with other entries of that
>>>      table
>>>
>>> - maybe it is possible to create temporary tables and fill them with
>>>      your mappings just when you need it...
>> 
>> ...or use a view (if SQL Server supports views)
> 
> It does.
> 
> But the view need to be on something.
> 
I thought Eric was saying that the stuff he needed to join was in two or 
more parallel tables, in which case a view should solve his problem with 
little impact on the existing database.


-- 
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