The tag has no wiki summary.

learn more… | top users | synonyms

4
votes
1answer
166 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 ...
0
votes
1answer
38 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
22 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 ...
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?
3
votes
2answers
166 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 ...
24
votes
7answers
2k 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 ...
0
votes
0answers
17 views

What's the proper term for the diverse systems to which a DW connects?

The data warehouse I've built gets data from transactional databases, web services, flat files, and a few other bits and pieces. It also writes back to some of these, and to analysis tools. I'm ...
1
vote
1answer
82 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: ...
4
votes
3answers
659 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. ...
2
votes
1answer
2k 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 ...
12
votes
3answers
5k 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 ...
2
votes
1answer
621 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 ...
12
votes
4answers
5k 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 ...
4
votes
1answer
748 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 ...
8
votes
2answers
5k 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 ...
3
votes
1answer
303 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 ...
6
votes
4answers
377 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?