Tagged Questions
23
votes
10answers
2k views
How do you organize highly customized software?
I'm working on a large software project which is highly customized for various customers arround the world. This means that we have maybe 80% code which is common between the various customers, but ...
21
votes
13answers
2k views
How To Deal With Terrible Design Decisions [duplicate]
I'm a consultant at one company. There is another consultant who is a year older than me and has been here 3 months longer than I have, and a full time developer.
The full-time developer is great. ...
19
votes
6answers
4k views
Front end first or Back end first. Of the two which is a Good system design pratice?
I have a client right now requiring me to develop a school enrollment system. Now this is the first time im having this kind of challenge. Most of the past software that i created are not that ...
19
votes
4answers
2k views
Best Practices for Redesigning a Database
I'm aware of some general best practices when designing a database for an application, but what about redesigning?
I'm on a team tasked with re-designing an internal business application, though ...
15
votes
4answers
2k 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 ...
9
votes
4answers
337 views
Do these specific tables need surrogate keys?
Background
I have this tables
+-------------------------+ +------------------------+
|Airport | |Country |
|-------------------------| |------------------------|
...
8
votes
7answers
641 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 ...
4
votes
1answer
538 views
Are rollback and roll-forward transactions equivalent for fault tolerance?
I've been reading about systems that employ transactions to provide fault-tolerance -- SQLite, for instance, implements a journal that allows the database to be rolled back to a known state in case of ...
3
votes
5answers
469 views
Problems in coordination between software and database teams
This is pretty much a "software process" question:
When your organization is split into two teams: software team and database engineering team (the organization is in ETL/BI/Data mining delivering ...
3
votes
2answers
284 views
Single Responsibility principle VS KISS principle
Let's assume the modeling of User model in a context of a social network.
User concept is composed of two notions:
Authentication elements like userName/Password/Email etc...
Extra data information ...
3
votes
2answers
165 views
Is it right to persist a computed property to the DB?
I would like to know what do you think about persisting an "autocomputed property" to the database.
For example I have these properties
decimal Price {get;set;}
decimal Tax {get;set;}
decimal ...
3
votes
1answer
310 views
State pattern vs Inheritance
In the following image for the State Pattern from Applying Domain-Driven Design and Patterns: With Examples in C# and .NET
I'm trying to persist the SalesOrder entity into the database. Normally I ...
3
votes
2answers
497 views
Is there a design pattern for modelling job execution flow?
In my application I have a set of jobs to execute:
Each job goes through the states "not started", "started", "completed", "failed" etc.
Each job has a set of pre-conditions and post-conditions.
...
2
votes
2answers
210 views
how to model this relationship ? in ERD
I have three entities :
Technician
Vehicle
Repair
The question is how to model this in ERD? Knowing that a technician can repair multiple cars, and the same car can be repaired by one and only one ...
2
votes
3answers
160 views
Referencing countries via Foreign Key Constraint
To make things simple to explain: I've got two tables: Table1 and Countries.
The Countries table contains a nice flag and some information, such as DisplayName, the ISO3166 ALPHA3 code and the phone ...
2
votes
3answers
290 views
Should each app have its own database, or should small apps be merged into one? [duplicate]
Possible Duplicate:
Should I use one database per application or share a single database amongst multiple applications
We have a bunch of small to medium sized apps, each of which has its ...
2
votes
3answers
323 views
Using a database for each module in a system [duplicate]
I was reading this question:
I was trying to standardize and modularize some functions (Email
Management Module, CMS Module & etc) by implementing a 3-tier
architecture concept where each ...
2
votes
2answers
162 views
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 ...
2
votes
3answers
306 views
db design: circular references for the-one-of-many case
There are many questions about circular references around (if they are bad or not) but this one will be concrete. Consider the following case.
There are two models Image and User. Users have ...
2
votes
2answers
4k views
When should we use weak entities when modelling a database?
This is basically a question about what are weak entities? When should we use them? How should they be modeled?
What is the main difference between normal entities and weak entities? Does weak ...
2
votes
1answer
194 views
Inventory Management System Design Problem “Items Packages”
I am developing a retail management system with inventory management module, I am facing a logic design problem and I don't really know how to address the problem in an easy way, so I wrote an example ...
1
vote
4answers
368 views
Schema Design : Advice Needed
I have a distributed data collection system where I have first layer as regional Databases where all collected data is initially stored and master database where all the data is consolidated, what are ...
1
vote
2answers
377 views
Database design
I'm on the way developing an application which requires a kind of dynamic database,
So this is what I want,
This is the for reading the details of a class, the number of variables and methods ...
1
vote
1answer
348 views
Multi-user Configuration Settings design
I am designing a flexible and extensible way to store configuration settings for users.
Database Table Design:
╔═════════════════════════════╗
║ ConfigurationItemDefinition ║
...
1
vote
1answer
208 views
What's the best way to design a data and php model for a multi-account system?
I'm doing some high-level sketching of a system that will require users to register, when they do they get an account and can invite others to that account.
To be clear, an account would be similar ...
1
vote
3answers
99 views
How to design database having multiple interrelated entities
I am designing a new system which is more of a help system for core applications in banks or healthcare sector. Given the nature of the system this is not a heavy transaction oriented system but more ...
1
vote
1answer
65 views
Advice on designing a robust program to handle a large library of meta-information & programs
So this might be overly vague, but here it is anyway
I'm not really looking for a specific answer, but rather general design principles or direction towards resources that deal with problems like ...
1
vote
1answer
489 views
NoSQL (Azure Table Storage) RowKey design for ordered data
I store large quantities of GPS data in storage tables. Each partition can reach up to 1 million entities. Each GPS entity that is inserted into the table is actually sequential to the previous data ...
1
vote
1answer
80 views
Azure Storage Table design with multiple query points
I have the following Azure Storage Table.
PositionData table:
PartitionKey: ClientID + VehicleID
RowKey: GUID
Properties: ClientID, VehicleID, DriverID, Date, GPSPosition
Each vehicle will log ...
1
vote
3answers
107 views
How should I approach this from a problem-solving point of view?
I'm currently working on a project to replace some excel worksheets. There is a lot of industry specifics that change quite often and nobody really knows how things should be but every sure enough ...
0
votes
3answers
149 views
Modeling a Student Application/Committee Relationship
I'm developing an ERD for a graduate student manager program (it's for a university class, so it's a fairly trivial implementation).
In this snippet of the model, I'm trying to work out the ...
0
votes
2answers
757 views
Is it reasonable to use POCO's that inherit from DTO's?
I'm designing a tiered .NET application, and I want to use the Code First approach. I'm new to this, so I'm struggling to envision how it ought to be designed. Would the following be a reasonable ...
0
votes
2answers
325 views
The limit of Int32 for Identity Column
This is just a consideration for a site am creating and for other big sites out there.
I am using Identity Column to store the ID of some of my tables and I have classes whose Id are decorated with ...
0
votes
2answers
87 views
Multi-Branch Retail System,how to control items quantity for various branches? [closed]
Currently I am developing Multi-Branch Retail software. All branches have the same set of items. However, each one has its own stock quantity.
My question is, what is the best practice to apply in ...
0
votes
2answers
305 views
Does there exist a design-pattern for this problem?
I have a big database of data which we can consider today's system. The data has a web front-end which allows my users to update the data. Let's call this "original solution"
When new users come in ...
0
votes
1answer
152 views
Generic params table design
We have a generic parameter table whose important attributes are :
id number auto increment not null
domain varchar (200) not null
classification varchar (200) not null
param_name varchar (200) not ...
0
votes
1answer
121 views
What is a good design for a container, assignment and items
------------- 1 * -------------- * 1 --------
| Container |--------| Assignment |-----------| User |
------------- -------------- --------
^ ...
0
votes
4answers
223 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 ...
-1
votes
1answer
106 views
Should We Use Surrogate Primary Keys for Every Table? [duplicate]
We are developing a data model for a marketing database that will import transaction, customer, inventory, etc. files and the directive is ONE process that works for every client. We have been told ...
