The Heap™ – Consultancy ©®

Andriy M

5:53 AM

@ypercube They have to roll a dice, right?

ConcernedOfTunbridgeWells

8:28 AM

Morning all

ConcernedOfTunbridgeWells

8:49 AM

@ypercube I got a fair way into writing a Python ORM at one point, although it uses old (pre-2.3?) style metaclasses so it won't run on modern versions of Python.

ypercube

@ConcernedOfTunbridgeWells Nice. We're using sqlalchemy at the moment. Not the ORM so much, mainly the core module.

ConcernedOfTunbridgeWells

@ypercube It used introspection to intercept instance variable access using a variant of the Borg pattern where the object's __dict__ was replaced by a proxy for the underlying database row cache. I even found a use for multiple inheritance to make a mixin for propogating events to the model object classes. It also kept track of the order in which changes were made so it could flush units of work (a fowler-ism FWIW) to the database in correct order (e.g.. parent table inserts before child).

I got dragged off it onto another project before I had finished the DB query generation layer, though.

Maybe I should re-write it using new style metaclasses and finish it in my copious free time.

ypercube

9:13 AM

Do we have a canonical question/answer for "default order of tables"?

0

Q: Mysql - MyISAM Default order

We are using Mysql V5.6. We have a MyISAM table. when we open the table, the records will be displayed in some order instead of primary key order. Even when selecting the records will not be retrieved in primary key order. I am not sure on what basis mysql is displaying the records. Is there any...

ConcernedOfTunbridgeWells

9:24 AM

@James Properly indented code gives you an at-a-glance view of the structure. It's not just fluff.

James

10:03 AM

@ConcernedOfTunbridgeWells Yep, I can reason about whether the code is doing the right thing more quickly when it's more legible. Unsurprisingly.

Andriy M

10:15 AM

@ypercube The accepted answer to this question (first in Related for me) seems to suggest that MyISAM tables do have a default order.

James

10:27 AM

cityam.com/1410915688/…

ypercube

11:21 AM

@AndriyM I'm not sure if that is correct - and even if that answer talks about MyISAM or temp tables or both.

Paul White

12:01 PM

Weird. The Connect website is actually fast today.

Emilio Gort

12:43 PM

good morning

Kermit

hello.

Emilio Gort

someone know how can I fix the those error

Kermit

did you google it?

Emilio Gort

I'm executing the sp from php, and th sp work fine insert all data, but throw the error stored procedure execution failed in php

I found that is a warning, but I didnt touch the language sentting

Kermit

did you check your php logs?

Emilio Gort

12:46 PM

thei just have the messege from the db

stored procedure execution failed

Kermit

that's terribly unhelpful

bluefeet

1:26 PM

morning all

Max Vernon

Morning, @bluefeet !

Kermit

@MaxVernon how's your google domain invite ?

Max Vernon

@Kermit I'm hoping to get a chance to use it today. Thanks, by the way!

Kermit

@MaxVernon you're welcome. If i'm ever on the street I expect you to support me and my family for this favor.

Max Vernon

@Kermit lol, I somehow doubt that will ever be the case!

Kermit

1:34 PM

@MaxVernon i do have pretty good job security

Max Vernon

what is the significance of the tags listed at the top of the right-hand column in Chat?

JNK

@MaxVernon just stuff we tagged the room with

Max Vernon

Good afternoon, @ConcernedOfTunbridgeWells

@JNK ahhhhh.

ConcernedOfTunbridgeWells

@MaxVernon Hi

JNK

@MaxVernon we can set it to whatever, typically it's to give a basic idea of the room's subject matter

Max Vernon

1:37 PM

@JNK right. Makes sense. I wasn't aware a room could be tagged - but now I know!

ConcernedOfTunbridgeWells

@JNK Which is why bollocks of various sorts makes an appearance from time to time.

Max Vernon

I'm getting close to 10k, I can just about smell it.

ConcernedOfTunbridgeWells

@MaxVernon Go edit some tag blurbs if you want a bit of extra rep.

Max Vernon

@ConcernedOfTunbridgeWells lol, my "editing-for-rep" days are pretty much over, I think.

although I guess it wouldn't hurt to look for some bad ones

:-)

<--- rep whore?

ConcernedOfTunbridgeWells

@MaxVernon We did a binge back around 2012 of tidying up the first few pages of the dba.se tag wiki. The order has moved since then, so a bit of janitorial work wouldn't go amiss. Also, there aren't actually that many 10k users on dba.se, so more users with idiot squashing permissions wouldn't go amiss.

bluefeet

1:41 PM

@MaxVernon I'll go upvote all your answers, trigger the serial upvote scripts and then all the votes will be reversed

Andriy M

@MaxVernon I think tag wiki suggestions are "paid" till you get 20k.

Or so I remember

Max Vernon

I just ordered the page by newest, and see page - I'm thinking that one maybe a little too specific. I can't imagine it helping describe a question.

ConcernedOfTunbridgeWells

@MaxVernon Take a look at the questions with the tag and see if they need re-tagging.

Max Vernon

@bluefeet Thanks! That would be fun.

@ConcernedOfTunbridgeWells There is only one question, but I'll look at it.

bluefeet

@MaxVernon not for me, @JNK could suspend me for voting irregularities

ConcernedOfTunbridgeWells

1:44 PM

@MaxVernon We only have 18 users with 10k rep now, so getting your rep over the line would make a material difference.

Max Vernon

@bluefeet yah, I'm certain he'd be highly inclined to do that. :-)

Mike Fal

2:01 PM

There @maxvernon, have some rep.

Max Vernon

thanks, @MikeFal

Mike Fal

Awwww....I should have done the Core tag. I has a sad.

Max Vernon

@MikeFal Feel free to switch it up!

Kermit

am i the only one that thinks the first two paragraphs are worthless?

1

Q: Problems with SQL Mail

Ok, I am running SQL Server 2008 R2 on a small environment. I currently have the data on the same drive as the backups (I know, bad idea, but I just inherited this challenge). I have several jobs setup to notify me if they fail. My boss is good with SQL and knows how to maintain the system, bu...

sql sql-server sql-agent-job sql-agent

Zane

2:22 PM

@Kermit meh.

Kermit

2:52 PM

move to Database Administrators ?

0

Q: DB Aggregation and BI Best Practices

We have a fair amount of aggregating queries in our db for use on making (sometimes real-time) business decisions. Unfortunately the pages that present these aggregates are some of the most frequently called, and the SPs are passed parameters by the page. The queries themselves have been tuned,...

sql data-warehouse business-intelligence aggregation query-performance

bluefeet

3:17 PM

please vtc

0

Q: Where to ask experts about complex queries

Where could I ask help to build a quite complex query?

sql

ypercube

@MaxVernon Regarding your tag edit: dba.stackexchange.com/review/suggested-edits/31344

SUBSTRING is a function, isn't it?

Max Vernon

sure is. I was attempting to stay away from SQL Server specifics, although I should not have used the word "keyword".

@ypercube I replaced the wording, so substring is in the edit review queue once more.

ypercube

It's probably a function in all DBMS - although it may have different name in some.

Max Vernon

@ypercube thanks for the clarification!

ypercube

Oracle calls it SUBSTR for exmaple

Max Vernon

3:27 PM

How do tags that have no questions get deleted? I assume there is simply an aging process?

any bets on this "quite complex query" being about GROUP BY?

-2

Q: Where to ask experts about complex queries

Where could I ask help to build a quite complex query?

sql

ConcernedOfTunbridgeWells

3:45 PM

@Kermit DB architecture for a system that does analytic queries on real-time data - could be on-topic.

billinkc

4:08 PM

They've updated

-2

Q: Accounting calculations for rental properties

Problems I am attempting to solve I have a SQL Server 2000 instance and I have the following accounting problems to solve related to rental property. Per each owner calculate projected income during fiscal year (jan/dec) Per each owner calculate effective earnings during fiscal year (jan/dec) ...

sql sql-server-2000

Still feels like a "what have you tried" and/or homework from a decade ago

Zane

@billinkc I hope I can hand this in 14 years late!

billinkc

You bet, now even if you get it all correct, your score is going to be negative

bluefeet

@billinkc yup

@Riccardo Have to tried to write any of these queries yourself? Just posting your requirements and table structures, isn't very helpful. It's much easier to see what you've done and why it isn't working. — bluefeet 15 secs ago

ypercube

4:28 PM

(the price above is not random - but wrong. It's per 15 min ;)

@Jack, @JNK, you around? Please delete my comment above.

Thnx @Yannis

Yannis Rizos

no problem.

ypercube

@YannisRizos Έχετε ακόμα ζέστη στη Θεσσαλονίκη ή αρχίσαν οι βροχές;

swasheck

eh?

I can't really as I'd need to say in the code is this postgres or mssql, if so call the function etc etc :( — Jon 1 min ago

Zane

@ypercube Jigga what?

ypercube

@Zane Sorry for that. I bet it looks like Greek to you.

Zane

4:39 PM

@ypercube Waka Waka!

swasheck

@Zane you have ____ heat in thessalonika or ____ the showers

Zane

Is this madlibs?

swasheck

no ... i'm translating from memory

Max Vernon

how do you answer this? I'm tempted to close the question as "opinion based"

Yes, I understand that is the point but things don't always work as advertised. I always look for the pros and cons of anything to assure that they work the way people say that they should. All I'm looking for are people like you to support the fact that these problems are not typical or don't even exist and that mirroring does improve up-time. — Joe 7 mins ago

Yannis Rizos

4:57 PM

@ypercube Έβρεχε απ'το μεσημέρι σήμερα, σταμάτησε πριν λιγο. Ευκαιρία να φύγω απ'το γραφείο πριν ξαναρχίσει :)

Zane

It's save to say that with my poor penmanship would not be able to write Greek in freehand.

Zane

5:11 PM

@MaxVernon your answer got you one of those upvotes you were looking for earlier.

Max Vernon

@Zane yeah, I noticed that. Thanks to whoever did that!

Zane

@YannisRizos Έτσι, πόσο ακριβής είναι η google σε μετάφραση από τα Αγγλικά στα Ελληνικά ;

@MaxVernon it was me!

Max Vernon

5:32 PM

@Zane thanks!

right back atcha

ypercube

@Zane Not bad.

swasheck

@ypercube google translate is awesomesauce

ypercube

5:47 PM

@swasheck Yeah, it's good. But this ^^^^^^ could not translate. Only the "is" ;)

swasheck

@ypercube i'm sure it can't quite handle regional colloquialisms as well as we'd wish. however, you can get a well-structured sentence/phrase/clause out of it

Zane

Well next code freeze we are changing our SDLC to no longer have this group by nonsense.

billinkc

22 hours ago, by Lamak

@Zane GROUP BY BAD!, NOLOCK GOOD!!!

Zane

I have proved beyond the shadow of a doubt that it is and always has been a stupid policy.

I took their example query for what you should do instead and made a group by version that accomplished the same thing faster.

billinkc

6:03 PM

That's impossible. You broke the rules so your results are invalid

And a short 20something hours after this company reached out to me on careers.so, I predict our courtship dance will be coming to a close. Pity, it was 100% remote ETL work for a healthcare company but now that I'm writing out my salary, I predict their range will be... 60% of my current

Zane

Holy shit. Rent is cheap in Kansas City.

@billinkc That would be more of a cut than just going back to Valorem.

billinkc

6:20 PM

Rent was cheap in Rolla, MO. We had a 4 bedroom duplex, 1 full bath, 2 half baths for 450 a month. That's 112.50 a person. It was an eye opener expecting similar pricing when I moved out after college. I think our 3 bedroom house was 900 something a month, but we a had a pool so it was a good bachelor's pad

@Zane That'd put me back at 2007 levels

Zane

The 3 of us are renting(a rather large) house for like 1700 and it's a steal here.

billinkc

My sphincter puckered up at that price. Sheesh. I could pay the mortgage on damn near 3 places for that

Zane

@billinkc It's a huge house.

We've had 5 adults and a child live there quite comfortably.

Kermit

@Zane that's 'spensive

My mortgage is $1100 for a 4 bed/2 bath/2 car garage

Zane

We also have a 2 car garage.

Kermit

6:25 PM

I gotta paint the shutters this weekend

bluefeet

@Kermit that's cheap

Kermit

@bluefeet be bought at the lowest point in the market.. paid 224k

Zane

@Kermit You're also out in the burbs.

Kermit

@Zane absolutely true

Zane

This is a 6 Bedroom 2 1/2 bath in the cities with 2 kitchen units.

It's also like 2 block away from the light rail which also helps.

Aaron Bertrand

6:36 PM

ugh

0

Q: SQL 2014 change from 2008

I have a piece of code that works on SQL Server 2008 without any issue, but when I try to run it on SQL 2014 Management studio, it doesn't work correctly. What it is suppose to do is take "actual_date" value (2014-09-01 00:00:00.000) and put the "begin_time" at (2014-09-01 19:00:00.000) which it...

sql-server sql-server-2008 sql-server-2014

bluefeet

What is the point of all of these converts to strings? — Aaron Bertrand 32 secs ago

^^ to drive you nuts

so generic question for y'all

if you have a function to split a string - would you rather call that function once per row or 3 times per row? :)

Zane

Date and datetime data types don't want to be converted to strings, and forcing them to be so is considered a form of abuse. — Zane 22 secs ago

@bluefeet 3, more functions = more better

Aaron Bertrand

@bluefeet why would you call it more than once per row?

Different delimiters, JSON strings, etc.?

Zane

If calling it once was great then surely calling it again will be greater... Right?

Aaron Bertrand

This looks fun too:

> CROSS JOIN personnel p

And this

bluefeet

6:41 PM

@AaronBertrand not exactly sure yet. We've got a string that is :2:45:78: that needs to be split to get each row and then do something with each one. I've written a version that splits this once, and someone wrote a different version that parses the same string 3 times to get the same result.

Aaron Bertrand

> ctual_date between Cast(@dtBeginTour as varchar(40)) and Cast(@dtEndTour as varchar(40))

@bluefeet Is yours an inline TVF?

Zane

To suggest that query is ugly would be a bit of an understatement.

bluefeet

@AaronBertrand yes, we both use the same function to split. I just call mine once

Aaron Bertrand

@bluefeet you appear to be the winner

bluefeet

@AaronBertrand thanks for confirming :D

Aaron Bertrand

6:43 PM

@bluefeet did they explain why they call it multiple times? Are they arguing that their way is better?

bluefeet

that ugly string is a hierarchy that we have to move up/down to select the correct level based on x number of rules

Aaron Bertrand

@bluefeet can't the hierarchy itself be computed and/or relational?

Zane

@bluefeet :(

bluefeet

@AaronBertrand no real discussion yet. I've just pointed out that calling that more than once is a concern

@AaronBertrand oh I wish. That will be an eventual thing.

Zane

That sounds like a job for a table.

Aaron Bertrand

6:44 PM

@bluefeet I hate storing redundant data

bluefeet

The plan is to possibly move to use hierarchyid - but that is long term because it will be incredibly messy to implement

We have a strange hierarchy that we maintain

billinkc

You only have one? You're doing it rong

Aaron Bertrand

0

A: SQL 2014 change from 2008

Sadly, this is not my code, it is just something I have to fix, but found out it is the actual data that is wrong. I don't know what the person who wrote this code before tried to accomplish with all the converts, but either way, found out the problem. Thank you though

^^^ this is an answer

allegedly

bluefeet

@AaronBertrand whoops I hit delete

on the whole thing

Kermit

@bluefeet whoops LOL

billinkc

6:47 PM

The Financial Services firm I worked at had 3. A reporting hierarchy, a pay hierarchy and then a approval hierarchy

Max Vernon

When are we having another moderator election?

billinkc

> So when someone searches for this question, says this sounds like my problem, when the scroll down to the answer they'll say "Great, you solved it, but mine's not solved. I wonder what they did"

Except it was already baleeted before I could post it

bluefeet

@MaxVernon on which site?

Aaron Bertrand

@bluefeet excellent choice

bluefeet

@billinkc thankfully we have just one. It is messy enough as it is

Max Vernon

6:49 PM

@bluefeet here

bluefeet

@MaxVernon that'd be up to the SE team if it is needed.

Zane

@MaxVernon Chat.stackexchange.com?

bluefeet

the other DBA mods would need to say that needed more help

Max Vernon

@bluefeet oh. I was wondering if it was once-a-year or something

Aaron Bertrand

I don't know that we need any more - we're busy enough but I still spend most of my time on the site commenting/answering, not moderating.

bluefeet

6:50 PM

@MaxVernon for the bigger sites, yes if needed. For the smaller sites it's based on need

Max Vernon

just curious.

bluefeet

@AaronBertrand do you want to join SO yet?

billinkc

The needs of the many, outweigh the needs of the absent mod

Max Vernon

@billinkc true, dat.

Aaron Bertrand

@bluefeet bwahahahaha you made a funny

I would quite rather jump off the Empire State Building and land on a bicycle with no seat

bluefeet

6:52 PM

@AaronBertrand there are days it's like that. But most aren't SO bad.

I had to take a break a few weeks ago but mostly it's fine

Aaron Bertrand

I think you have a much higher tolerance for stupidity than I do.

Max Vernon

I must say I'm surprised to see the SO close queue is far far lower than it was a while ago. ONLY 11.7K in the queue.

Aaron Bertrand

WTF

addictinginfo.org/2014/09/13/…

Also, does snopes.com really still use popup ads? Didn't those die like 10 years ago?

Max Vernon

That's only 6 x 8 hour days at 15 seconds(!) per review item to hit them all.

bluefeet

@MaxVernon it hides stuff

Max Vernon

6:57 PM

@bluefeet oh right... kinda like the weatherman makes the end of the week always look great.

bluefeet

@AaronBertrand maybe some days. There can be some tough days though. We get taken to town on meta and that can be a bit rough sometimes

Kermit

@AaronBertrand the right certainly has more silly things to say about everything

Ugh no

-3

Q: How to create automatic datesheet for exams using PHP and MySQL?

I am a beginner in web application. I am working on automation of final exam scheduling. Key features: Automatic datesheet creation Intimation of date sheet to all concerned via email Please guide me how to do this.

php mysql

Zane

@AaronBertrand wooooah

Kermit

@bluefeet so if i go through the review queue, that uses all my delete votes?

Max Vernon

7:14 PM

It's so much easier to just not visit SO, than it is to try to take some actual time to answer a question.

swasheck

@AaronBertrand not verified. probably a spoof account

Zane

and if I knew how to do that it would be solved. — chris 21 mins ago

You can lead a horse to water but you can't make him use his brain.

billinkc

7:30 PM

I can't believe that turd got 2 upvotes

My sole regret is that I have but one downvote to cast

swasheck

@billinkc which?

ah. nvm

billinkc

Ja

swasheck

the one i just downvoted

Zane

@billinkc I thought about answering but his obnoxious response made me think. No fuck you guy.

billinkc

I concur. I would have used my dupe hammer but I didn't like the dupe Eric H found

Paul White

7:35 PM

It's hard to know if he was intending to be obnoxious. There are different ways to read that comment.

bluefeet

@Kermit I believe so but don't quote me on that

Kermit

@bluefeet quoted

bluefeet

@billinkc now don't bust out your sock puppet account to downvote again

billinkc

Too lazy to create a sock puppet account

Paul White

1 min ago, by bluefeet

@Kermit I believe so but don't quote me on that

JNK

7:37 PM

@PaulWhite Did you just quote her despite her wishes?

Paul White

Yep. Rebel eh.

bluefeet

@PaulWhite banhammer coming!!!

JNK

Paul White, KiwiRebel™

Kermit

56 secs ago, by Paul White

1 min ago, by bluefeet

@Kermit I believe so but don't quote me on that

Paul White

Uh oh.

Kermit

7:38 PM

wonder how deep that can be nested

billinkc

He's a loner Doty, a KiwiRebel

JNK

@Kermit let's not find out

Zane

If this turns into some sort of Escher painting I'm going to be upset.

bluefeet

let's try once more

1 min ago, by Kermit

56 secs ago, by Paul White

1 min ago, by bluefeet

@Kermit I believe so but don't quote me on that

just to annoy @JNK

JNK

It's mega-man shooting a bullet that when you zoom in has a picture of mega-man shooting a bullet that when you zoom in has a picture of mega-man shooting a bullet...

billinkc

7:39 PM

I am a bag of fail

Kermit

woah

Zane

Yup Escher painting. The eternal Comment.

Paul White

> (removed)

JNK

@JNK Recursion

bluefeet

@billinkc glad to know you are too lazy to break the rules

we've got enough of that to deal. I don't want to mod-hammer the heap

billinkc

7:41 PM

I'm a firm believer in breaking rules as they apply to me, as long as it doesn't conflict with my personal rule of "be lazy"

JNK

@JNK Recursion

There we go I broke the internet

swasheck

@JNK Recursion

billinkc

@bluefeet I was mostly paraphrasing a long distant relative en.wikipedia.org/wiki/Nathan_Hale

JNK

Message A replies to Message B which is a reply to Message A

swasheck

I N C E P T I O N

billinkc

7:43 PM

INTERCEPTION!

The 20

the 15

the 10

the 5

TOUCHDOWN!

bluefeet

not

darn you were too fast

@billinkc I tried to stop you

billinkc

"You can perform this action again in 3 seconds" nearly got me

Paul White

@JNK Clever!

Zane

@JNK I just noticed what you did there.

bluefeet

@JNK did you see that posted on Meta a few days ago?

Zane

7:51 PM

@JNK I must have clicked that at least 50 times...

JNK

@bluefeet no I avoid meta

bluefeet

@JNK ah, ok

someone reported a bug that you could edit a chat message to reply to a future message

JNK

was it posted there? It just occured to me during this talk that you could probably do that using messageids

Paul White

What a nerd.

swasheck

takes one to know one

Paul White

7:53 PM

:-D

bluefeet

-10

Q: able to reply to future messages

User unihederon found a bug in chat. The word reply is present tense, not future tense. I know some will say, "but this only works if you edit your message within 2 minutes of posting it, to reply to a message that has already posted within the 1 min 59 seconds of you posting the original mes...

bug chat

@JNK nice

JNK

I'll stop playing around now

Max Vernon

8:14 PM

> Are there any clever techniques to make this more efficiënt?

Store the data in an RDBMS? — Max Vernon 57 secs ago

billinkc

Behave

I only say that because I didn't come up with it

Max Vernon

@billinkc jealous eh?! lol.

swasheck

8:31 PM

@MaxVernon in fact, my upcoming sql saturday presentation is based off of a data set of "linked words" from the extant, freely-available greek corpora

Max Vernon

@swasheck Nice!

billinkc

-1, too many big words

swasheck

yeah. not sure why cassandra is necessary

billinkc

Because she's a total hottie

swasheck

@billinkc i lost you at "upcoming", didnt i?

@billinkc she was a few years ago. now she's been exposed as all warty and misrepresented

billinkc

8:34 PM

The problem with the results from Cassandra is that no one believes her

Cassandra

In Greek mythology, Cassandra (Greek: Κασσάνδρα, pronounced [kas̚sándra͜a], also Κασάνδρα), also known as Alexandra or Kassandra, was the daughter of King Priam and Queen Hecuba of Troy. A common version of her story is that Apollo gave her the power of prophecy in order to seduce her, but when she refused him, he gave her the curse of never being believed. In an alternative version, she fell asleep in a temple, and snakes licked (or whispered in) her ears so that she was able to hear the future. Snakes as a source of knowledge is a recurring theme in Greek mythology, although sometimes the snake...

Kermit

@billinkc /r/mildyamusing

billinkc

The important thing is that I keep myself entertained and I would say I do a splendid job at it

Kermit

@billinkc /r/wtf

swasheck

8:51 PM

@billinkc wow. just. wow

billinkc

My talents are wasted here. I'm taking them to South Beach

@billinkc /r/aww

/r/n

rm -rf /

Open the pod bay doors please Hal

swasheck

8:56 PM

sudo !!

billinkc

chown 7777 is how I roll

swasheck

see ... if bowman had just said ... "sudo open the pod bay doors, HAL" then all would have been well

Kermit

@billinkc chown'd!

billinkc

I wonder if I could make that the new version of pwnd

swasheck

@billinkc you're so nerdy. i just stick with chown -R a+rwx

billinkc

8:59 PM

chmod yourself

swasheck

that too

James

9:16 PM

you guys don't know how to unix

swasheck

i clearly dont

James

neither do i anymore

i think i might make a scatterplot of sql server i/o request sizes for fun

Kermit

swasheck

@James do share, once complete

James

the one from our sql sentry server might be interesting

it has a pretty busy r/w workload, is on an availability group, and another dba runs index rebuilds and stats updates on it every day (not really sure if there was a good reason for this)

however he looks like kind of like Judge Doom from Roger Rabbit so i haven't pushed the point

which reminds me, i have another coworker who looks like the Yellow Bastard from Sin City, except he isn't yellow

ypercube

11:54 PM

Can you get what this guy means?

1

A: Relational Model vs. Database Products

Computers can't operate the real sets. In fact - nobody can. We don't know how to fetch only required items that satisfied the given conditions from the bag without iterations. Formal relational model is an abstraction. RDBMSes are just resemble it but they are built on the completely different ...

Transcript for

The Heap™ – Consultancy ©®