|
You have omitted the keyword meaningfully from the quote.
An ID is a substitute key. It should not have a meaning.
It's usually an incremented integer for practical reasons, which is sortable per definition but the order has no meaning, it could just as well be a GUID.
<edit>my bad, I see the quote has been edited
|
|
|
|
|
"It's usually an incremented integer for practical reasons" ... which is also the badest thing for an index (usually implemented as somtehing like a binary tree) because each increment does need to reorganice the tree.
Anyway: Everything is sortable, either because we can do it on a binary representation or if not possible (what most probably will never be the case) one can introduce our self defined sorting.
modified 9-Oct-21 21:01pm.
|
|
|
|
|
If by "badest", you mean "worst", then I agree, integers are a poor choice for IDs.
Member 15353828 wrote: Everything is sortable
Nope.
|
|
|
|
|
'If by "badest", you mean "worst", then I agree, integers are a poor choice for IDs'
On this I think we come closer, more I think we are on the same line.
"Everything is sortable": Nope
Please give me an idea what is not sortable.
Minor: And sorry I have no idea about how to responde something 'quoted'. Thats why I put the quotes in italic. And also pay attention, I'm not native English therefore the chance of missunderstanding is always present 
modified 9-Oct-21 21:01pm.
|
|
|
|
|
Crayons are enumerable, cows are enumerable, photographs are enumerable, grains of sand on a beach are enumerable, are they sortable?
|
|
|
|
|
Sorry, only intersting on facts.
modified 9-Oct-21 21:01pm.
|
|
|
|
|
These are facts. Not everything is sortable.
|
|
|
|
|
Everything -any data you catch with a computer- ends in a stream of bits which is sortable. Please explain whehre I'm wrong in case I'm wrong, which is not the case....
modified 9-Oct-21 21:01pm.
|
|
|
|
|
Yes, but that's not "everything" -- it's only representations of things and labels for things within a computer. It also meets the criteria of not being meaningfully sortable.
|
|
|
|
|
I give up, but I like to mention again you did not show an example which is 'not sortable'
So it be
modified 9-Oct-21 21:01pm.
|
|
|
|
|
I have given a few examples twice now. I'm done too.
|
|
|
|
|
Jörgen Andersson wrote: which is sortable per definitio
Exactly.
Jörgen Andersson wrote: but the order has no meaning,
Ah, I see. So you are saying that the order of IDs have no meaning.
They do tell you when a record was created relative to another, but otherwise, sure, I think I get what you are saying.
|
|
|
|
|
If that is the way IDs are allocated. In other words: A special case. Such special cases do exist - but are special cases nevertheless.
In a de-duplicating file system, a page or file (depending on which level de-duplication is done) usually have an ID given by the hash of the page/file contents. In other systems, partial series of IDs may be reserved by sub-authorities - this is common for ISDN reservations by book publishers, or phone number series allocated to different phone companies. The sub-authority may split the reservation into sub-series: I know of phone companies allocating numbers from different series to business or private customers. In many regions, an alphatbetic prefix on the car registration plate indicate home town or county; the numeric part is not unique, and cars from different locations cannot be ordered in age by it. Within the lowest level sub-sub-sub series, IDs might be allocated in order, but maybe not. Eg. IDs used earlier (like phone numbers or car license plates) may, after a quarantine period of non-usage, be allocated to another object.
|
|
|
|
|
Nope 
Enumarable is also A,B,C and also chinese characters are also kind of sortable.
And btw. A,B,C was invented before ascii code
Sorry, I think you can't explain where I'm wrong. I case you can then please: Do it and do it with math background. Thanks, and I'm not interested in fights, I'm only interested on facts.
modified 9-Oct-21 21:01pm.
|
|
|
|
|
Crayons are enumerable, cows are enumerable, photographs are enumerable, grains of sand on a beach are enumerable, are they sortable?
|
|
|
|
|
Any answer with facts?
modified 9-Oct-21 21:01pm.
|
|
|
|
|
How do you sort images of cows or complex numbers?
|
|
|
|
|
This is a very trivial case, before post that q think about it
modified 9-Oct-21 21:01pm.
|
|
|
|
|
No please explain and then tell me factually, since you like facts so much, how it's meaningful.
|
|
|
|
|
You are lazy like some of the q/a. And you lean back while asking 'clever' q here?
Your words: "How do you ort images of cows or complex numbers?"
Images: e.g. a hash (a very special one, it is up to you to learn more about that)
Complex numbers: any other special things? What about sorting not only a 2.dim, but also 3, 4, .. dim?
Sorry, that are the so 'trivial' things one expect here.... at least when I'm reading Q/A. So go and do your homework
[Edit]
And no, no, no I do not google for you "sorting N dimensions". It is simply a level more than the very simple questions in qa, but I excpect from you that you are able to do it
[/Edit]
modified 9-Oct-21 21:01pm.
|
|
|
|
|
So tell me what's the meaning behind the hash? Not even going to argue hash collisions. And please what the math is saying about such sorting of complex numbers?
|
|
|
|
|
Still missing an answer to "Ok, then please explain how to index a thing you can't enumerate. Please ...
modified 9-Oct-21 21:01pm.
|
|
|
|
|
|
|
Now, I think I'm pretty aware about the differences ...
modified 9-Oct-21 21:01pm.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
