The rdbms tag has no wiki summary.
-5
votes
0answers
47 views
Deep concepts in database [closed]
I am a student. And preparing myself for an interview. Following are some questions regarding databases, which are confusing me and i am unable to get an appropriate answer of these. please answer ...
-1
votes
1answer
106 views
Use of file processing system like NTFS for file system of Operating System [duplicate]
While reading the advantages of RDBMS,over a file processing system(like NTFS,FAT 32),I had a question in mind:
The popular operating systems(like Windows) continue to use file processing systems(like ...
0
votes
1answer
223 views
Will SSD make the distinction between column oriented DB and row oriented DB obsolete? [closed]
I had a discussion with a friend about row vs column oriented RDBMS.
From my understanding, these things are closely linked with the fact that there's a concrete drive head reading and writing the ...
6
votes
3answers
1k views
Why aren't Object Oriented databases used as much as Relational Databases? [closed]
I have come across many relational database management systems (RDBMS). But recently I used hibernate which made me start wondering why Object Oriented databases aren't more popular.
If object ...
4
votes
1answer
206 views
What's a good scheme for multi-user database synchronization?
I'm working on a system to allow multiple users to collaborate on an online project. Everything is fairly straightforward, except for keeping the users in sync. Each user has their own local copy of ...
7
votes
5answers
540 views
Predicting advantages of database denormalization
I was always taught to strive for the highest Normal Form of database normalization, and we were taught Bernstein's Synthesis algorithm to achieve 3NF. This is all very well and it feels nice to ...
3
votes
6answers
682 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 ...
0
votes
1answer
149 views
RDBMS same type of optional data for multiple tables
I have an embedded database (SQLite), it stores information about events and page views, its purpose is to track the user journey inside my application. I need to provide support for optional custom ...
1
vote
6answers
767 views
flat files vs. RDBMS database, few read/writes, few changes
I have to handle data from long term (years, decades) climate monitoring stations. The data flow usually starts with raw data (voltages, etc.) plus quality check information (pressure, temperature, ...
4
votes
3answers
309 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 ...
-2
votes
1answer
2k views
How to draw an E-R diagram?
I am learning DBMS in my college. Recently I was given an assignment to draw a E-R Model of a Bus Reservation system which handles Reservations, Ticketing and cancellations.
I understand the theory ...
7
votes
5answers
2k views
When not to use ORM and prefer stored procedures?
I am using PetaPoco micro-ORM. It is indeed very easy and secure to work with databases using ORM tools, but the only thing I hate is extra code. I used to put most of the code in the database itself ...
7
votes
3answers
310 views
choosing a functional language platform for a new project
I have been writing code for a few years now and I don't believe I can claim to have a complete knowledge in this job yet.
My experience primarily rolls around C# related areas with a decent ...
1
vote
2answers
202 views
Are there any advantages of using separate RDBMS for reports?
My production database is SQL Server 2008 R2 Express. It has limited features and I am testing it in a production environment. To better handle reporting queries in a highly concurrent environment, I ...
0
votes
2answers
697 views
Why is the Unit of Work pattern considered fast and efficient when working with an ORM?
In working with Doctrine 2 I came across the following paragraph.
In fact, since Doctrine is aware of all your managed entities, when
you call theflush() method, it calculates an overall ...
6
votes
3answers
165 views
Are there best practices for checking for errors in business logic for DB refreshes?
I'm working for a company with very large databases which all refresh overnight, ready for users to interrogate in the morning. These over night loads essentially truncate all the tables, and reload ...
8
votes
5answers
489 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 ...
4
votes
2answers
432 views
ORM domain design pitfalls
Are there any patterns which seem sensible when designing an object oriented domain, but do not translate nicely onto a relational database schema? If so, are there standard patterns that can be used ...
