Search Postgresql Archives

Re: RE: RE: How do I select composite array element that satisfy specific conditions.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Wed, May 23, 2018 at 6:50 AM, a <372660931@xxxxxx> wrote:

That is only by saying, the actual information could be much more, and all of them are not in some way, "aligned". 

​Not sure what you are getting at here - "related" is generally the better term and usually during modeling one of the tasks is to identify those relationships even if they seem to be obscure.​  In this case most everything is likely related by policy number one way or another.
 
The results would be millions(which means many) of tables lies in database and each query is hundreds of lines. It is hard to create new query that target your info and it is dangerous to modify any set query.

​I seriously doubt you'd end up with millions of tables...and hundred line queries are likely going to happen in spite of your attempts to simplify.  In fact I'd say the number of "complex" lines will end up being higher - most of the lines in a normal query against a normalized database are verbose but simple.

Now my think was to group data into structures so that I can significantly decrease the amount of table, and since it can hold array, I can actually put historical data into one table for one year, which stops query from multiple historical tables and shrink the size of database.

​An array of composites is a table - your just making things difficult by not actually creating one up front.​

However, I am new to this and do not have experience, so if you could provide any suggestion, it would be extremely grateful from me.

​The scope of this database seems to be a bit much for one's first attempt at doing something like this...​

I'd recommend learning and then applying as much technical normalization as you can to your model and assume that years of modelling theory is going to be a better guide than inexperienced gut instinct.  Starting from a normalized position you can selectively de-normalize and add abstraction layers later when you come across actual problems that you wish to solve.

David J.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux