Proper Data Structure for Commentable Comments
Been struggling with this on an architectural level.
Using XML as data storage [closed]
Closed 8 years ago.
Configuration data: single-row table vs. name-value-pair table
Let’s say you write an application that can be configured by the user. For storing this “configuration data” into a database, two patterns are commonly used.
Breaking 1NF to model subset constraints. Does this sound sane?
My first question here. Appologize if it is in the wrong forum but this seems pretty conceptual. I am looking at doing something that goes against conventional wisdom and want to get some feedback as to whether this is totally insane or will result in problems, so critique away! I am on PostgreSQL 9.1 but may be moving to 9.2 for this part of this project.
Fitting it together, database, reporting, applications in C#
Introduction Preamble I was hesitant to post this, since it’s an application whose intricate details are defined elsewhere, and answers may not be helpful to others. Within the past few weeks (I was actually going to write a blog post about this after I finished) I’ve discovered that the barrier I’m encountering is one that’s […]
Architecture for Social Graph data that has a Time Frame Associated?
I am adding some “social” type features to an existing application. There are a limited # of node & edge types. Overall the data itself is relatively small (50,000 – 70,000 for each type of node) there will be a number of edges (relationships) between them (almost all directional).
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 normalize your database, knowing that fields can be modified while retaining consistency.
Classless tables possible with Datamapper?
I have an Item class with the following attributes:
Best approach for saving highlighted areas on geographical map
I am designing an application that allow users to highlight areas of a geographical map using a tool that is like brush or a pen. The tool basically draw a circle with a single click and continue drawing those circles with mouse move.
Where ORMs blur the lines between code and data, how do you decide what logic should be a stored procedure, and what should be coded?
Take the following pseudocode: