The relational-database tag has no wiki summary.
3
votes
1answer
90 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
66 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
109 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
117 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
73 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
85 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
236 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
55 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
364 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
296 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
283 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
869 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 ...
8
votes
2answers
230 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 ...
3
votes
3answers
299 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
337 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
313 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
250 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
239 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.
...
10
votes
1answer
1k 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
346 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 ...
1
vote
2answers
464 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
491 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
320 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
139 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 ...
6
votes
5answers
383 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
707 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
268 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
326 views
Database of words and related words for search engine
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
94 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 ...
4
votes
3answers
795 views
Would a NoSQL DB be more efficient than a relational DB for storing JSON objects?
I am using a library that returns a JSON object (as a string, but I think that's standard), and I would like to store the contents of this object into a local database.
I'm fairly fresh-faced in ...
5
votes
4answers
943 views
Are database schema migrations a problem in production environments?
In discussions about NoSQL vs SQL databases, I sometimes hear that companies prefer to use schemaless NoSQL databases because it is problematic to migrate the schema to a new version. But is that ...
1
vote
2answers
244 views
Basic Database Relationship Advice?
I am finding it difficult to get together in a single place the different types of relationships used for different things and would like to find out which I have correct and incorrect and the proper ...
5
votes
2answers
835 views
B Tree compared to an R tree - Isn't it just a bunch of linked lists linked together?
I'm pretty familiar with a B Tree, mainly having to keep the databases well fed with electricity, air conditioning, and harddrive space. I associate with a double (doubl[ie,ey]?) linked list.
Today, ...
3
votes
1answer
129 views
Equality between arity and degree concepts in relational theory
I've been reading the book "SQL and Relational Theory: How to Write Accurate SQL Code" by C. J. Date. I have no formal background in CS, much less relational theory. Combined with the fact English is ...
4
votes
3answers
1k views
Document Database versus Relational Database : how to choose?
I'm a SQL guy, but I know there is Not Only SQL databases - document-database mostly. As with most technologies there are pro and cons for each technology.
I've read some articles, but they were too ...
11
votes
10answers
792 views
How could RDBMSes be considered a fad?
Completing my Computing A-level in 2003 and getting a degree in Computing in 2007, and learning my trade in a company with a lot of SQL usage, I was brought up on the idea of Relational Databases ...
0
votes
1answer
145 views
Technology Selection for a dynamic product
We are building a product for Procurement Domain in JAVA.
Following are the main technical requirements.
Platform Independent
Database Independent
Browser Independent
In functional requirements ...
9
votes
3answers
491 views
How do I know my data is relational or object oriented in nature?
Just read these lines-
If your data is object in nature, then use object stores ("NoSQL"). They'll be much faster than a relational database.
If your data is relational in nature, the ...
3
votes
3answers
468 views
What does the word Relational in “Relational Database” imply?
I tried searching but didn't get any useful information.
What does the word "Relational" mean here? Is it tables being related to each other just like the real life entities, or does it mean ...
