The Heap™ – Consultancy ©®

7:01 AM

1 hour later…

8:06 AM

Morning

1 hour later…

Mathematics

9:22 AM

Morning All...

for those who remember me talking about database of databases....
I thought about it further, I want to create a database of world
Think about it whatever we humans store in brian in regards to entities and relationship between them
e.g. we know what a order is, what attributes are related to it and what relationship it has with other objects...
I want to start a generic open database of such objects, there properties and there relationships with each other
use cases could be enormous but one of them could be generating SIMPLE CRUD applications just by selecting your objects or entities and…

I would be surprised if there isn't one already

It sounds very ambitious, and I personally think it would be the first one of this kind. I'm still not sure I understand how it could be used, though.

Faheem Mitha

I came across this book review, and just wondering if people had an opinion about this book.

julien.danjou.info/the-art-of-postgresql-is-out

10:12 AM

@Mathematics But do we really know what an order is or what attributes are related? I mean doesn't that change with personal interpretation and cultural background and what not?

Maybe I'm just not following where you are going

but a database of "everything" probably doesn't exist yet

1 hour later…

11:38 AM

@FaheemMitha should be good. It's on my to-buy list ;)

Faheem Mitha

@ypercubeᵀᴹ Ok. So DBA do buy DB books?

yeah, sure they do

We have shelves full of unread books

Literally

George.Palacios

@Johnakahot2use that word has no meaning anymore :(

https://www.google.com/search?{google:acceptedSuggestion}}oq=define%3A+literally&sourceid=chrome&ie=UTF-8&q=define%3A+literally

11:57 AM

12:16 PM

@Johnakahot2use Those are definitely all unread (by me at least)

@Johnakahot2use that looks like a shelf from the 200x decade ;)

If you know the basics....

It's sooooo 2007

Let's deploy to production

12:47 PM

current status

►

Cade Roux

1:33 PM

@AndriyM That's what I'm thinking. So it seems like it's only specifiable in the RDLs or it falls back to 30s. I have some queries that take a couple minutes to run and they need indexes I have designed, but service updates to the app have to go through potentially months of approval for release because of FDA and other process restrictions, so I has hoping there was an overriding setting in SSRS, but it looks like we could just update affected RDLs until people get the indexes.

1:47 PM

@CadeRoux Sorry, I'm totally new to all this, but I'm guessing an RDL is a piece of source code you can change easily enough? I mean, more easily than the application(s) affected by this issue (assuming timeout can be set in the application code as well, that is)? With what we are using here, if a query starts timing out and we need to increase the timeout until we sort out the problem with it, we have to change the application code.

2:02 PM

@TomV-trytopanswers.xyz subtitles has nothing to do with what he is saying!!

@AndriyM RDL is the standard file extension for SSRS report object source code. it's XML under the hood. IIRC, there's a whole bunch of different places to set timeouts for various granularities based on various conditions

both in the report / RDL itself, in various dependent objects ( embedded datasources / datasets / nested reports ), and above that at the service level & config

all the options

I like flexibility in general but this sounds a little maintenance-unfriendly on the surface, to be honest

lol, it is what it is. my experience was that it's too easy to use, so you do end up shooting yourself in the foot a lot

Yes, that's the right metaphor

but it's got a lot of self-service support, so that's kind of the price of entry

2:21 PM

@McNets I think it's the demeanour, not the spoken language, that sells the message in the subtitles to the non-Spanish speaking world

Cade Roux

@AndriyM This particular system is an analytics database related to an operational database with some SSRS reports as well as some ETL-style processes managed by a DLL that the operational data calls when a physician signs a cardiovascular study. One of the things I'm trying to do is improve the performance of a variety of queries.

Unfortunately, most schema changes are tightly controlled due to the healthcare environment, and I'm hoping to get the index improvements treated a little bit more streamlined and leniently. Changes to the RDL are less strictly controlled - BUT each RDL file would have to have a <Timeout> element added to the <Query> element.

As far as I can tell, there is no fallback to a higher level of timeout if you leave it out of the RDL. That's the query timeout - because reports can have quite complex pagination and logic, there is also report overall "processing" timeouts - and I think this IS settable at a few different levels.

2:36 PM

@CadeRoux Even though I don't understand quite all the details, I've understood enough to get my answer, thanks.

> Thank you for reviewing 20 close votes today; come back in 9 hours to continue reviewing.

@AndriyM yes I know, just pointing it out

Can moderators interact with users? This user might want to read the "Help Center" a bit. His questions are, .... well how do I put it without being unwelcoming?

2:59 PM

@McNets It's something about the cucina and the playa

@TomV-trytopanswers.xyz He was a peculiar character time ago, he appeared in some TV shows for a while. And yes he is talking about something that happened in a restaurant in front of the beach between low and high tied.

I can see why they wanted to put him on shows

I can think of less funny people on TV

@TomV-trytopanswers.xyz in fact, as @AndriyM has pointed out, it's all about his demeanour, He used to explain things in a funny way.

el risitas y su cuñao.

►

He was known as the-brother-in-law

Mast

3:34 PM

@McNets His clips got famous all over the world with incorrect subtitles.

2 hours later…

5:43 PM

@TomV-trytopanswers.xyz this deserves 11 stars! At least.

1 hour later…

DRP

7:07 PM

Hi Team, a table Person has an attribute of gender. So for the gender table my thought is that it is a strong relation (non-dashed) , because without the person there can be no gender, is this train of thought correct?

Mast

7:28 PM

@DRP If the gender is in the same table, is there even a relationship?

DRP

8:12 PM

I get your point, in that case there is no purpose for a gender relationship. I guess PHYSICAL_CHARACTERISTICS would represent more a relationship, which in that case would be strong right?

Because for example my understanding is that the attribute i.e Gender, come with the Person when the person is born, and for example an email is something that the person can decide to obtain later on and hence a separate table would be represented

Physical characteristics do tend to change over time

Obviously I'm learner here...

mustaccio

Gender, come with the Person when the person is born You risk running afoul of the new code of conduct here

@DRP Relationships are between entities. If gender or physical characteristic are proper entities in your model of the world, then you can immediately decide what kind of relationship they have. If they are attributes, they don't have a relationship.

1 hour later…