The tag has no wiki summary.

learn more… | top users | synonyms

2
votes
3answers
57 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 ...
6
votes
4answers
341 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
52 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 ...
0
votes
1answer
29 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 ...
3
votes
2answers
185 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
1answer
206 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 ...
1
vote
1answer
100 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: ...
25
votes
7answers
4k 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 ...
2
votes
1answer
3k 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 ...
37
votes
14answers
2k 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
980 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 ...
13
votes
1answer
263 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
946 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 ...
9
votes
2answers
6k 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 ...
12
votes
3answers
6k 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
312 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 ...
13
votes
5answers
7k 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
4answers
394 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?
4
votes
3answers
680 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. ...