The relational-database tag has no wiki summary.
5
votes
4answers
236 views
I want a trivial example of where MongoDB can scale but a relational database will have trouble
I'm just learning to use MongoDB, and when discussing with other programmers would like a quick example of why NoSQL can be a good choice compared to a traditional RDBMS - however the scenarios I come ...
0
votes
0answers
37 views
Database model for keeping track of likes/shares/comments on blog posts over time
My goal is to keep track of the popular posts on different blog sites based on social network activity at any given time. The goal is not to simply get the most popular now, but instead find posts ...
0
votes
0answers
7 views
How to manage primary key while updating [closed]
In the following table primaryKeyColumn is primary key.
To maintain the data history I always uses the values with WHERE condition(WHERE StatusColumn=1) And will set the StatusColumn to 0 if the data ...
3
votes
1answer
136 views
At what point does caching become necessary for a web application?
I'm considering the architecture for a web application. It's going to be a single page application that updates itself whenever the user selects different information on several forms that are ...
0
votes
0answers
55 views
Best way to implement database design for a set of entities
Lets say I have a scenario like so:
I have many claims to get money from another entity and this claim has to go through two gateways. This claim is sent from an origin system and can possibly be ...
1
vote
1answer
67 views
Storing donor addresses in a relational database
I am building a donor database for a non-profit organization and one issue I'm mulling over is how to store some of the donor data. There are some families for whom we capture the names of both ...
15
votes
4answers
1k views
Why many designs ignore normalization in RDBMS?
I got to see many designs that normalization wasn't the first consideration in decision making phase.
In many cases those designs included more than 30 columns, and the main approach was "to put ...
1
vote
1answer
46 views
How can I find all connections in a mesh network/graph?
Suppose I have a mesh of relationships, such as
Friends who trust some friends and not others
A IPv6 router that needs to locate peers across the Internet
A PGP Web Of Trust that needs two people ...
2
votes
2answers
211 views
Using Autoincrement Primary keys as Foreign Keys
When creating a table, there is an option for us to set the numeric primary key as autoincrement where it's value increases whenever a new data in inserted.
This primary number can be used for ...
2
votes
5answers
327 views
Planning relational database - one or two tables?
I'm currently planning the database structure of a used car's advertisements site. Each advert contains information about a vehicle, and a vehicle can be advertised multiple times over its lifespan ...
1
vote
1answer
30 views
How is data integrity maintained in a clustered environment when schema changes?
Scenario
A clustered environment running N identical application nodes interacting with a single relational database.
Problem
Is it possible to upgrade the nodes to a new application version, which ...
2
votes
1answer
142 views
Data integrity in NoSQL situations
Background
To start off, at work I work with a legacy system that, in its day, was quite spectacular, but now is ...interesting... to work with. It uses IBM (now Rocket) UniVerse as its backing ...
7
votes
7answers
380 views
Should a surrogate key ever be exposed to a user?
Often in a table that has no natural key, it is still useful for users to be able to have a uniquely generated identifier. If the table has a surrogate primary key (and in such a case you would ...
9
votes
4answers
270 views
Do these specific tables need surrogate keys?
Background
I have this tables
+-------------------------+ +------------------------+
|Airport | |Country |
|-------------------------| |------------------------|
...
5
votes
7answers
466 views
Is there value denoting a key as “Primary”?
Question: Is there value in denoting a key as "Primary"?
This question is not about the definition of a primary key. It is not about the fact primary's aren't nullable. It is not about ...
1
vote
2answers
165 views
External id for every relational table
Should I add an external id for every table?
For example if I have these tables :
Customer
=======================================
Id Name Gender
---------------------------------------
...
3
votes
1answer
195 views
Suitable algorithm for joining records from multiple databases
I am in the process of writing a library that is used to be able to access data from a database. The library requires the initial definition of all the tables that the application will be using in the ...
3
votes
2answers
372 views
Handling subscriptions, balances and pricing plan changes
Preamble
My aim is to create reusable code for multiple projects (and also publish it on github) to manage subscriptions. I know about stripe and recurring billing providers, but that's not what this ...
0
votes
4answers
199 views
Create a database for database tables
I'm working on a project where I have to give users the ability to build their own tables,
each user can create more than one table.
(the type of all data is string).
The user can create a table and ...
12
votes
6answers
1k views
In plain English, what is a database index most similar to?
Setup: Suppose you are teaching an introduction to Databases class, the students are CS students that have a working knowledge of tree structures, how they can speed up searches, and have probably ...
0
votes
3answers
399 views
Should lookup tables enumerating strings have an integer primary key?
When I learned relational databases, the prof said that one would "almost always" want an artificial int as the primary key in a table, but did not specify what the exceptions are. At some time I ...
5
votes
1answer
121 views
What is the common approach to component template databases?
My Project:
I have employees who are required to go through a checklist when they encounter a duck, a cat, and a human. In our business, we have a set number of ducks, cats, and humans that come in ...
0
votes
1answer
461 views
Retrieving hierarchy of tree-nodes stored in relational database
I have a hierarchical ADT that I want to store in a database.
Nodes have exactly one parent element that is a node as well. Multiple nodes can have the same parent node.
My current approach uses an ...
1
vote
2answers
162 views
Referential integrity in a database where tuples are not physically deleted
Many modern Relational Database Management Systems automatically support referential integrity, i.e. when you try to delete a tuple which has a reference (in the form of foreign key, for example), the ...
3
votes
3answers
222 views
How should I represent an enumerated type in a relational database?
I am working on developing a relational database that tracks transactions that occur on a device I'm working on for my company. There are different types of transactions that could occur on the ...
2
votes
2answers
161 views
Should database-models (conceptual or physical) be reviewed by DBAs?
Where I work, new applications that are being developed that will use their own relational database, must have their database-models (conceptual, then physical ) reviewed and aproved by DBAs.
Things ...
2
votes
1answer
187 views
Designing persistence schema for BigTable on AppEngine
I have tried to design the datastore schema for a very small application. That schema would have been very simple, if not trivial, using a relational database with foreign keys, many-to-many ...
6
votes
5answers
334 views
Type of AI to tackle this problem?
I posted this on stackoverflow but want to get your recommendations as well as a user on overflow recommended I post it here.
I'm going to say from the beginning that I am not a programmer, I have a ...
0
votes
3answers
75 views
On merging database records, constraint violation in the intermediate table of M2M
If you are merging two or more database records from table X, that have a many-to-many relationship with table Y, how should you solve the problem of records in intermediate table Z that would violate ...
7
votes
5answers
825 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 ...
5
votes
4answers
909 views
Should I create an Enum mapping to my database table
I have a database table containing a list of systems relevant to the tool I am building, mostly in-house applications, or third-party systems we receive data from. This table is added to infrequently, ...
1
vote
1answer
440 views
How can I implement a database TableView like thing in C++?
How can I implement a TableView like thing in C++?
I want to emulating a tiny relation database like thing in C++. I have data tables, and I want to transform it somehow, so I need a TableView like ...
1
vote
5answers
2k views
Externalising SQL Queries in Java
What are the advantages and disadvantages of externalising SQL queries in Java (or similar general-purpose object-oriented programming language. Externalizing means storing all SQL in a separate ...
9
votes
2answers
542 views
Data Quality in Relational Database Regression Tests
I have been working on an open source Museum Collections Management web application that is to be used to keep track of a museum's accessioned, donated, loaned or otherwise acquired artefacts.
This ...
4
votes
3answers
421 views
Which aspect of normal forms do entity-attribute-value tables violate, if any?
I'm not asking if EAV tables are good or bad. I'm wondering if they are considered "normalized", and if not, why? If they aren't normalized, which normal form are they violating and why?
0
votes
1answer
479 views
Design Pattern for Complex Data Modeling
I'm developing a program that has a SQL database as a backing store. As a very broad description, the program itself allows a user to generate records in any number of user-defined tables and make ...
1
vote
2answers
387 views
SQL language drawbacks, The Third Manifesto
Sometime ago I read about SQL language drawbacks
(the basic language specification, not vendor specific),
and one of the drawbacks was that the language does not allow to create a set of tuples that ...
1
vote
6answers
341 views
when should a database table be broken into multiple tables with relations?
I have an application that needs to store client data, and part of that is some data about their employer as well. Assuming that a client can only have one employer, and that the chance of people ...
3
votes
1answer
362 views
How would one build a relational database on a key-value store, a-la Berkeley DB's SQL interface?
I've been checking out Berkeley DB and was impressed to find that it supported a SQL interface that is "nearly identical" to SQLite.
...
12
votes
1answer
3k views
When should you use a document vs relational vs graph database? [closed]
For the purposes of discussion let's consider a FourSquare scenario.
Scenario
Entities:
Users
Places
Relationships:
Checkins: users <-> places, many to many
Friends: users <-> users, ...
-3
votes
3answers
671 views
Is there really Object-relational impedance mismatch?
It is always stated that it is hard to store applications objects in relational databases - the object-relational impedance mismatch - and that is why Document databases are better.
However, is there ...
2
votes
2answers
756 views
Storing translation data as JSON column
We're deciding on how to store translations of some descriptions of database items.
We could go the traditional way and keep a translations table (and a language table and an object_translation ...
1
vote
1answer
640 views
Cheat notes for telephone interview (.NET /DBs, OO)
I am preparing for a telephone interview. I am thinking that instead of trying to memorize SOLID or ACID for example I could have some cheat notes ready.
So:
Any tips on how to organize them?
Where ...
2
votes
1answer
440 views
Sanity of design for my in-memory object representations of database rows
I've been trying to revise the structural design of the C#.NET-based system I'm currently working on. The new design involves a rather light-weight object-relational mapping framework (we're trying ...
5
votes
1answer
161 views
What are graph datastores better at doing than other datastores and why?
Where previously there was only relational databases, the data store world is now rife with options like Key-Value, Document, and Graph datastores. Unfortunately, every datastore likes to show how it ...
7
votes
5answers
541 views
Why is SQL known as a relation-based / functional language?
We're learning that most languages are classified as either of the two, "relation based" or "high level". I've never used SQL before, but from reading its syntax it seems more like the ...
1
vote
1answer
1k views
Books that every software system architect/data modeller must read
I hope I'm not confusing the term system architecture with the data model/database.
Is there a book out there that's the standard for describing best practices, design methodologies, and other ...
6
votes
2answers
327 views
What are some useful resources for learning tuple calculus?
I've been trying to go over my tuple calculus over and over again. What's worse is that my professor and tutors are not much help during their hours.
Does anyone know a good place to learn about ...
2
votes
1answer
698 views
Database of words and related words for search engine [closed]
I need to be able to search for a word in the English language and have a list of related words be displayed. Let's say I have a list of 100 words that the user should be able to search through. For ...
1
vote
2answers
101 views
NoSQL Modify operations performance
I am working on the application which in near future (hopefully) will have to process tens or hundreds of thousands of items (item is currently one row in relational database table) per second.
If I ...
