The tag has no usage guidance.

learn more… | top users | synonyms

1
vote
1answer
45 views

What's the term that describes our data processes [closed]

We provide an online subscription product that allows our users to research and analyze financial data of their interested industries. As such, we have various tools for loading data from various ...
0
votes
2answers
20 views

Application == session == connection in DB2?

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 ...
1
vote
1answer
45 views

Changes to the database schema are called migrations, what are data changes called?

Not sure where to ask this but here it is anyway. I understand that changes to the database schema are called migrations from a certain version to another. What do DBAs call changes to the ...
1
vote
1answer
47 views

What is a cursor?

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 ...
2
votes
1answer
111 views

Is there any name for common sense / knowledge integrity constraints?

The Wikipedia page on data integrity lists 4 types of integrity constraints: entity integrity, referential integrity, domain integrity, and user-defined integrity. Is there a name for integrity ...
0
votes
0answers
32 views

What is the graveyard compaction in cassandra?

Cassandra noob here. While going through the documentation etc, I'm repetitevely finding references to graveyard compaction (and occasionally tombstones), example: $ cassandra-cli [default@unknown] ...
1
vote
0answers
25 views

Terminology for one-to-one, many-to-one relationships concepts?

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 ...
2
votes
3answers
116 views

Best table name instead of “user”, if the DB doesn't like that [closed]

Yes, I know, it is possible to quote the name of the table, but it is sometimes improper. If there is no alternative, I name this table as "users", although this semantically unneeded plural makes ...
8
votes
4answers
2k views

Column vs Field: have I been using these terms incorrectly?

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 ...
0
votes
1answer
94 views

Terminology No-SQL Database [closed]

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 ...
1
vote
1answer
34 views

What is the term that describes the use of OFFSET and LIMIT in a query

I am looking for a technical term (or phrase, or something concise) that describes the process of limiting the number of records returned from a query through the use of OFFSET and LIMIT. For ...
4
votes
2answers
214 views

Terminology for table types

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 ...
4
votes
2answers
324 views

What is Transaction Path Analysis?

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 ...
3
votes
2answers
152 views

Is there a term for a table that has an “effective date” column?

I work with a system which uses a lot of tables whose primary keys include a foreign key to another table and a column indicating the date that record became/becomes "active". Example tables: ...
29
votes
7answers
8k views

What is the difference between a “record” and a “row” in SQL Server?

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 ...
3
votes
1answer
6k views

What are SQL Server Securables?

I migrated two applications to the new server. One of the them works without any issues but the other ran into back end sql permission problems like The EXECUTE permission was denied on the ...
44
votes
14answers
3k views

Commonly Used Acronyms by Database Administrators

What are the most commonly used acronyms among database administrators and what are their correlated meanings?
2
votes
1answer
2k views

What is a source table, and a target table?

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 ...
14
votes
1answer
288 views

Term for a one-row table?

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 ...
4
votes
1answer
1k views

What is Sql Server Clustered Index in Oracle terminology

A clustered index in sql server like a dictionary or telephone directory. A,B,C,D it goes on. If you look up with a name Ozgur you start O then z etc. I would like a simple explaination for this ...
11
votes
2answers
8k views

What is a heterogeneous query?

I got the following error message regarding a SQL query I'm running in a program. SQL Server 2005 T-SQL. Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the ...
14
votes
3answers
8k views

What does horizontal scaling mean?

In database context, I have come across horizontal scalability as one of the advantages of the NOSQL databases. What does the term mean? http://en.wikipedia.org/wiki/CouchDB ...
3
votes
1answer
322 views

What scope(s) is “hasMany” a part of?

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 ...
17
votes
5answers
12k views

In SQL, is it composite or compound keys?

About SQL (Computing/Databases): When we have two or more fields in a table that, together, identify its records uniquely, what's the proper way of calling them? Composite or compound keys? I've ...
6
votes
2answers
450 views

Is a Junction Table the same as a Weak Entity?

Is a Junction-Table basically just the table that sits between two entities that have a M-M relationship?
5
votes
3answers
727 views

What do you call something that's not the primary key?

I've been working with a group who have built a system where they've coined a few new terms in the process, and I wanted to know if there's something more standardized they should be calling it. ...