Thanks all. Alternate data stores are an intriguing idea - I already switched
away from using PostgreSQL to implement SNOMED_CT in favour of Lucene as the
free text searching was too slow with PostgreSQL. That said, it is nice that
some of the data collection forms have relational constraints to
Might be worth checking a Graph Database such as Neo4j as a possible solution
for your domain model requirements.
The book: http://amzn.com/1449356265
Free PDF Version of the book: http://graphdatabases.com
On Oct 6, 2013, at 2:08 PM, Ramsey Gurley wrote:
> You need a schema-less approach if
You need a schema-less approach if you need to create these things at
runtime. Relational databases really aren't such a good fit in these cases.
You can shoe horn something into a RDBMS with EAV or datablobs, but it
won't scale well.
If you're using Postgres 9.2.x or better, there is built in JSO
Thanks both,
This advice is all very helpful. I might do some performance measurement to see
whether keeping horizontal inheritance is actually causing problems. I think
I'm batch fetching which should mean joining on multiple tables and not a
SELECT on each and every entity.
The problem is t
On 2013-10-04 11:06 AM, "Ramsey Gurley" wrote:
Not to contradict Chuck (he is always right),
Will someone PLEASE tell my wife?
--
Chuck Hill
Executive Managing Partner, VP Development and Technical Services
Practical WebObjects - for developers who want to increase their overall
knowledge of
On Oct 4, 2013, at 10:01 AM, Chuck Hill wrote:
Hi Mark,
On 2013-10-04 9:09 AM, "Mark Wardle" wrote:
Hi all,
When I originally planned the schema used for our clinical application, I used horizontal inheritance. As use has increased, I perceive that horizontal inheritance will
Hi Mark,
On 2013-10-04 9:09 AM, "Mark Wardle" wrote:
Hi all,
When I originally planned the schema used for our clinical application, I used
horizontal inheritance. As use has increased, I perceive that horizontal
inheritance will not scale for more and more entities. Perhaps I should spend
t
Hi all,
When I originally planned the schema used for our clinical application, I used
horizontal inheritance. As use has increased, I perceive that horizontal
inheritance will not scale for more and more entities. Perhaps I should spend
time measuring the performance impact, but I am planning
