No preference or requirements to answer for a particular database platform.
6
votes
3answers
114 views
Arbitrarily ordering records in a table
A common need when using a database is to access records in order. For example, if I have a blog, I want to be able to reorder my blog posts in arbitrary order. These entries often have lots of ...
1
vote
2answers
66 views
Extensible Asset Database Schema
Background
I work for a decent sized company in the hardware sector. Currently, we have a number of varying assets that need to be tracked. Until recently, this was done by hand as was an ...
1
vote
1answer
120 views
Database design with different user roles connected by different relationships to one organizaiton table
An user is connected to an organization by some role. Lets say there are 2 roles freelancer and employee.
One employee can only be a part of one organization and if he is an employee then he can't be ...
1
vote
1answer
140 views
One address table for many types of addresses
I have an application where I have to store adresses of multiple types of location.
For example, my app requires addresses of people, hotels and event venues.
Should I create separate tables for ...
1
vote
1answer
85 views
Is it possible to query “NOT IN” in NO SQL?
I asked the same thing about a specific NoSql engine (Big Table) on SO.
It seems that Big Table doesn't support NOT IN queries?
Is that possible in any other NoSQL databases?
Will it ever be possible ...
0
votes
0answers
123 views
Is like '%text%' faster than like ('%text' or 'text%') [closed]
A lot of programming language when you use an OR, he will check the first condition to be true and won't check the rest of the condition.
for example
true OR (false) OR (1) OR (false) OR ....... OR ...
2
votes
1answer
85 views
Group_by and having vs Joins when table is self joined 5-6 times
Now the situation due to which this question came to me.
Schema is
Table User_Read_Book
user_id | book_id
Now I want to get users who have read certain books. Say give me users who ...
2
votes
1answer
251 views
Pros and Cons of having additional columns in join table of many to many relationship
I searched but did not find any discussions on this topic.
Are there any pros and cons on creating many extra columns on joined table?
Does it affect speed of data retrieval because we are joining 3 ...
5
votes
1answer
588 views
Password hashes: Fixed-length binary fields or single string field?
I'm currently having am amusing debate with a friend, and we simply can't agree on the best method to store salted passwords in a database. The two options on the table are:
Storing the hash and the ...
12
votes
5answers
436 views
Indexing from start or when performance problem arises?
My question is regarding use of indexes.
Should I start indexing right from the start or when performance problem arises?
We can also create temporary index while executing a query. What are the ...
9
votes
2answers
303 views
Which areas of a DBA's knowledge should a developer delve into? [closed]
I must admit the question is quite broad, so I'll try narrowing it down a bit. In our company we are 3-4 developers and have some SQL Server based installations running at our customer's sites ...
19
votes
13answers
2k views
How to implement a 'default' flag that can only be set on a single row
For example, with a table similar to this:
create table foo(bar int identity, chk char(1) check (chk in('Y', 'N')));
It doesn't matter if the flag is implemented as a char(1), a bit or whatever. I ...
11
votes
2answers
1k views
Open Source Business Intelligence/DWH solutions
I wonder that this question hasn't already been asked. Google only has very few results for me that don't show a high quality tool
What are some Open Source (also free is ok) solutions for Data ...
11
votes
4answers
979 views
Why won't some DBMS's allow rollback for certain DDL statements?
Recently I found out that MySQL doesn't support rollback of DDL such as "alter table"... Being used to PostgreSQL, that struck me as odd, but a friend of mine told me that even Oracle doesn't allow ...
