Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [database]

This tag is for general database questions; if you question is specific to SQL use that tag instead.

1
vote
1answer
2k views

How to show levels of User Roles in ERD?

I felt this is the best place to ask this, rather than Stackoverflow as it is not related to programming. Ok. The thing is I need to draw an ERD of a leave management system. Suppose there are three ...
1
vote
4answers
459 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 ...
4
votes
5answers
1k views

Reverse engineering airline reservations systems

I saw an interesting conversation on here about airline reservation systems and the services that connect them (like Sabre). This is an almost identical analog to a problem I've been trying to figure ...
7
votes
5answers
3k views

How do you off load work from the database?

In at least the web development field, web servers are everywhere but are backed by very few database servers. As web servers get hit with requests they execute large queries on the database, putting ...
1
vote
4answers
1k views

Database in the cloud?

Some of my recent clients are asking for remote connections to the office server, for standalone work, etc, in winForm applications. Since the concept of the web is remote connection to a server both ...
7
votes
6answers
1k views

Is the “One Description Table to rule them all” approch good?

Long ago, I worked (as a client) with a software which use a centralized table for it's codified element. Here, as far as I remember, how the table look like : Table_Name (PK) Field_Name (PK) Code (...
26
votes
3answers
15k views

Is there a list of common usernames to reserve in a new system?

I need to reserve usernames in my new website. These generally fall into three categories 1) usernames no-one should have (eg: admin, user, service, help, root, etc) 2) names of super famous people ...
0
votes
1answer
439 views

How Data Transfers differ on Smart Phones: Iphone vs. Android vs. Windows Phone [closed]

I am interested in how each individual smart phone is allowed to handle data transfers within a third-party app. I am interested in designing apps that allow customers to update, transfer, download, ...
1
vote
1answer
1k views

DB Schema for ACL involving 3 subdomains

I am trying to design a database schema for a web app which has 3 subdomains: a) internal employees b) clients c) contractors. The users will be able to communicate with each other to some degree, ...
1
vote
1answer
252 views

Programming language and database concurrent locking primitives

I am writing an article about both programming language locking primitives (which are really wrappers for OS primitives) and database locking primitives. Are there any short wide-spread titles for ...
30
votes
8answers
15k 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 complex....
1
vote
1answer
83 views

What things should be considered in the license etc when you're using some open source projects/ tools in your application

What things should be considered in the license etc when you're using some open source projects/ tools in your application(in my case, specifically a web application/website) ? What are the ...
129
votes
9answers
96k views

When would someone use MongoDB (or similar) over a Relational DBMS?

I'm a bit confused about the whole NoSQL thing and such. When would you choose to use something like MongoDB over something like Oracle or MySQL? I don't really understand the "difference" as far as ...
2
votes
2answers
172 views

Transitioning from Oracle based CMS to MySQL based CMS

We're looking at a replacement for our CMS which runs on Oracle. The new CMSes that we've looked at can in theory run on Oracle, but most of the vendor's installs run off of MySQL vendor supports ...
5
votes
4answers
19k views

What is the best way to work with large databases in Java depending on context?

We are trying to figure out the best practice for working with very large DBs in Java. What we do is a kind of BI (business Intelligence), i.e analyzing very large DBs, and using them to create ...
4
votes
3answers
439 views

Does the programming language or database you use have any effect on the selling of your site?

I was just wondering if the programming language or database you use has any effect on selling your site to another company? I mean is it easier to sell PHP site than other language? How about ...
1
vote
3answers
2k views

Is OrientDB document-database? or graph-database?

Some document says OrientDB is document-database, some others talks it's graph-database. What's right?
0
votes
1answer
601 views

Parallel programming against a database: managing locks and transactions

I have first experience of parallel programming of code which actively works with relational database. I find it interesting to combine .NET parallel programming primitives with database locks/...
8
votes
2answers
435 views

Databases and the CI server

I have a CI server (Hudson) which merrily builds, runs unit tests and deploys to the development environment but I'd now like to get it running the integration tests. The integration tests will hit a ...
3
votes
6answers
18k views

Database GUI Programming - .Net vs MS Access [closed]

MS Access gets pooped on a lot because A) many newbies use it B) people use it as a database backend which is not a good idea. I'd like to see some reasonable discussion on why you might choose VB....
6
votes
3answers
588 views

Are two database trips reasonable for a login system?

I am designing a login system for a project, and have an issue about it requiring two trips to the database when a user logs in. User types in username and password Database is polled and password ...
7
votes
3answers
460 views

Does it make sense to develop open source python library for database inspection? [closed]

Some time ago I came up with an idea for a library for database inspection. I started developing it and got some very basic functionality, just to check if that's possible. Recently however, I get ...
3
votes
4answers
2k views

Best practices when creating/modeling databases?

I learned at the University some steps to model a database: Model the problem using the Extended Entity-Relationship Model. Extract the functional dependencies Apply some algorithms to normalize ...
10
votes
22answers
8k views

Software Developer Interview Question - Fair or Unfair [closed]

I just phone interviewed with a company for a graduate software developer position and was asked the following questions. I should add that the company concerned are not a database vendor. How does a ...
14
votes
4answers
7k views

How to handle Real Time Data from a database perspective?

I have an idea in mind, but it still confuses me the database area. Imagine that I want to show real time data, and using one of the latest browser technologies (web sockets - even using older ...
3
votes
3answers
851 views

Breaking into database administration

I am brand new on this site and look forward to interacting with each of you. I am graduating in June with my Bachelors Degree in Computer Information Systems with hopes of become a DBA in the future. ...
5
votes
2answers
2k views

Types of ER Diagrams

I'm currently taking a class for database design, and we're using the ER diagram style designed by Peter Chen. I have a couple of problems with this style: Keys in relationships don't seem realistic....
16
votes
4answers
2k views

Staying OO and Testable while working with a database

What are some OOP strategies for working with a database but keeping things unit testable? Say I have a User class and my production environment works against MySQL. I see a couple possible approaches,...
1
vote
2answers
352 views

How does an agile process deal with ORM?

This question was prompted by this answer, where I quote,"agile + ORM on a large constantly changing database is brutal". So, how can an agile process deal with a constantly changing database? I am ...
23
votes
12answers
11k views

What are the advantages of storing xml in a relational database?

I was poking around the AdventureWorks database today and I noticed that a number of tables (HumanResources.JobCandidate and Sales.Individual for example) have a column which is storing xml data. ...
4
votes
1answer
1k views

Dependency analysis from C# code through to database tables/columns [closed]

I'm looking for a tool to do system wide dependency analysis in C# code and SQL Server databases. It's looking like the only tool available that does this might be CAST (CAST software), which is ...
4
votes
8answers
4k views

How will you handle NULL values in your application?

At what level do you prefer to handle Null values in your application? My personal preference at the moment is the DB. When I build a view, I ensure that I return a value in place of a NULL value. So ...
0
votes
4answers
2k views

How to obtain GPS Coordinates for local businesses? [closed]

Is anybody aware of a database that consists of businesses, addresses and GPS location information, preferably searchable by city at a minimum? I have an application in mind that I'd like to develop ...
25
votes
5answers
21k views

What is the difference between all-static-methods and applying a singleton pattern? [duplicate]

I am making a database to store information about the users of my website (I am using stuts2 and hence Java EE technology). For the database I'll be making a DBManager. Should I apply singleton ...
3
votes
5answers
2k views

Do you test your SQL/HQL/Criteria?

Do you test your SQL or SQL generated by your database framework? There are frameworks like DbUnit that allow you to create real in-memory database and execute real SQL. But its very hard to use(not ...
72
votes
12answers
119k views

SQL: empty string vs NULL value

I know this subject is a bit controversial and there are a lot of various articles/opinions floating around the internet. Unfortunatelly, most of them assume the person doesn't know what the ...
3
votes
8answers
315 views

Is it necessary to discuss database changes

I am working on a project with a team of 4-5 people. Is it necessary to discuss the database changes with the team before implementing? I am working on the database api's. Is it better to discuss ...
2
votes
10answers
1k views

How do I determine if customers have already received a newsletter?

The problem: When we were sending newsletters to customers, there was no way to confirm if the customer already received the mail. We have come up with two different approaches: (Boss's Idea) Each ...
11
votes
8answers
2k views

Best way to model a singleton in a relational database

When designing relational database schema for web applications, I often find a case where I end up creating a table just to contain one row, and only one row. It feels like that is the wrong way to ...
14
votes
3answers
1k views

Does ORM promote database de-normalisation?

Doctrine and Propel both make use of single and concrete table inheritance to map object relationships. The former sees all possible fields in the class tree mapped to a single table - whereas the ...
4
votes
2answers
282 views

Best way to work easily with a database in remote programs?

In Database 101 you learned never to distribute the sensitive database password along with your program, since all a person has to do is reverse engineer the program, find where you actually need the ...
32
votes
4answers
13k views

How do you decide what kind of database to use?

I really dislike the name "NoSQL", because it isn't very descriptive. It tells me what the databases aren't where I'm more interested in what the databases are. I really think that this category ...
12
votes
4answers
2k views

What would you think about a new Java persistence tool, that's not really an ORM? [closed]

Persistence in Java Over the past years, I have gathered experience in the field of persistence abstraction in Java, using concepts such as EJB 2.0, Hibernate, JPA and home-grown ones. They seemed to ...
11
votes
3answers
2k views

Best Practices: Database app programming patterns

I have written many database (MySQL) web apps so far but I always think my structure is kinda clumsy. I want to improve the programming/design pattern I use, hoping for some advice here. Particularly, ...
25
votes
13answers
4k views

Why aren't databases integrated as a language feature?

Are there any programming languages that have a built-in database as a first-class language feature rather than connecting to an external SQL (or other) database? What would be the drawbacks and ...
5
votes
4answers
2k views

What's stopping Oracle from supporting identity (auto-numeric) columns? [closed]

EDIT: As gavenkoa's answer points out, Oracle Database 12c (released a couple of years after this question was asked) has support for Identity Columns. As far as I know, Oracle's RDBMS is one of the ...