Tagged Questions
-4
votes
0answers
60 views
Is it advisable for a beginner to choose Oracle Database 10g/PL-SQL as his first RDBMS & query language to learn? [closed]
I am new to the subject of databases and after some theoretical knowledge about RDBMS,SQL,ER Model,transactions,indexing & hashing,concurrency etc I needed a RDBMS to practice the SQL commands.I ...
3
votes
6answers
619 views
Light-weight RDBMS for basic amateur use
I need a free RDBMS to install in my Windows 7 machine.
Following are the required features
Light-weight
Works on 32-bit operating system
No need to install Microsoft.Net framework
Easy to connect ...
4
votes
3answers
306 views
Rule of thumb for field sizes
What VARCHAR sizes should be used for first and last names, phone numbers (preferably international), email adresses, urls, dictionary words and file names?
Edit: Zapped the introductory phrase to ...
8
votes
5answers
426 views
Why is filesystem preferred for logs instead of RDBMS?
Question should be clear from its title. For example Apache saves its access and error logs in files instead of RDBMS no matter on how large or small scale it is being utilized.
For RDMS we just have ...
27
votes
11answers
1k views
Why don't relational databases support returning information in a nested format?
Suppose I'm building a blog that I want to have posts and comments. So I create two tables, a 'posts' table with an autoincrementing integer 'id' column, and a 'comments' table that has a foreign key ...
