Tagged Questions

Can I consider as synonyms Applications, Sessions and Connections in DB2 LUW?
In db2top, I see "Sessions". There is a command "db2 force applications", views and other stuff. And from the developer ...

I am new to database concepts and I found some sources that try to explain what is a cursor, but I can't understand what they mean. Can someone explain in a very basic manner what a cursor is and what ...

Some data is structured so there is only one piece of information that can be associated with an entity. For example, a table with columns (id, name, phone) implies that each id has one name and one ...

I feel kind of embarrassed here, I've always used the terms "column" and "field" completely interchangeably, which recently caused some confusion in a technical discussion.
I was told, though, that ...

I'm looking for a good explanation of terminology for No-SQL.
I have some colleagues that won't get the point, and for the sake of advancing i need to have definitions of the names.. Though this seems ...

I am currently unsure of the correct terminology for types of tables that exist, or indeed whether there is a term for the examples I have.
I have included my current understanding of the types that ...

I came across the term Transaction Path Analysis which I am not familiar with. A Google search resulted in only a few results, most of which seem to assume everyone knows what it means. From these my ...

There was a rather innocuous question about adding dates and times in SQL Server that set off a rather fascinating taxonomic debate.
So how do we differentiate between these related terms and how we ...

I've seen alot of talk about source tables, and target tables on the internet, but no definitions of what these things are...from what I can infer it seems to mean something about copying data from an ...

Is there a specific term to describe a relation with a cardinality of one?
I'm thinking particularly of RDBMS "special" one-row tables, for example, DUAL (Oracle), SYSIBM.SYSDUMMY1 (DB2, Derby) and ...

I realize, when talking about structures, obviously if you say "post hasMany comments" there are many records about comments relating to each post.
What I don't understand is what context these sort ...