Questions tagged [database-development]
The database-development tag has no summary.
109 questions
0
votes
1
answer
303
views
How should I evaluate the Database Solution for Large Data Application
Background
I have been tasked to write an application that will be a combination of document and inventory management in VB.net which will be used to store document images in TIFF, PDF, XPS, TXT, DOC, ...
- 111
0
votes
2
answers
2k
views
SQL Server: When to use SSIS vs T-SQL for ETL Tasks [closed]
When should I use one versus the other? For instance, let's say I have 20 comma delimited, denormalized text files and I want to transform the data and load it into normalized SQL Server tables.
- 165
2
votes
1
answer
2k
views
How can I maintain a SQL schema upgrade that goes out to our users on a regular basis?
I work on a project that uses a SQL database as a back end, and a desktop app as a front end. We do releases on a regular basis, and as part of a release, our client needs to update their SQL server.
...
- 437
1
vote
3
answers
280
views
How to maintain user relationship when user un-follows another user
I have a table of user relationship which stores who follows whom, the table structure is as follows
-id
-follower
-following
when someone follows any other user, I add a record with follower user id ...
- 113
4
votes
1
answer
832
views
Database Schema Usage
I have a question regarding the appropriate use of SQL Server database schemas and was hoping that some database gurus might be able to offer some guidance around best practice.
Just to give a bit of ...
- 205
37
votes
5
answers
73k
views
What are the advantages of myBatis over Hibernate? [closed]
I've done some research on my own and understand the basic concept. But some insights can only be gained through actual experience.
What are the advantages of myBatis that would make it worth ...
- 837
2
votes
1
answer
278
views
In-memory DB to perform intersects on set slices
I have a specific programming need where I need to efficiently store large sorted sets in memory, query them for ranges, and intersect them against other sets that are also queried for ranged.
I am ...
- 151
28
votes
3
answers
18k
views
Conflict resolution for two-way sync
How do you manage two-way synchronization between a 'main' database server and many 'secondary' servers, in particular conflict resolution, assuming a connection is not always available?
For example, ...
- 4,535
1
vote
2
answers
368
views
Handle all authentication logic in database or code?
We're starting a new(ish) project at work that has been handed off to me. A lot of the database sided stuff has been fleshed out, including some stored procedures. One of the stored procedures, for ...
- 113
10
votes
3
answers
986
views
How do I Integrate Production Database Hot Fixes into Shared Database Development model? [duplicate]
We are using SQL Source Control 3, SQL Compare, SQL Data Compare from RedGate, Mercurial repositories, TeamCity and a set of 4 environments including production.
I am working on getting us to a ...
- 471
3
votes
1
answer
2k
views
Querying key/value store
I don't know whether this question is reasonably answerable (and therefore will be closed), but I will take my chances: What are the possible problems (and solutions), one might encounter, when ...
- 556
9
votes
3
answers
11k
views
What advantages do we have when creating a separate mapping table for two relational tables
In various open source CMS, I have noticed that there is a separate table for mapping two relational tables. Like for categories and products, there is a separate product_category_mapping table. This ...
- 5,080
7
votes
3
answers
501
views
Are there best practices for checking for errors in business logic for DB refreshes? [closed]
I'm working for a company with very large databases which all refresh overnight, ready for users to interrogate in the morning. These over night loads essentially truncate all the tables, and reload ...
- 273
6
votes
7
answers
2k
views
Should there be separate database schemas for each developer or should there be just one that all developers share?
During development, should developers each have their own copy of the database to work on ? Or should there be a common shared development database ?
The former will give developers more flexibility. ...
- 2,119
8
votes
12
answers
9k
views
Over normalization in database
Currently I am working on creating a new database schema as part of a major new product. Our previous customer address records (in a previous product) look something like this in our current schema (...
- 11.8k
15
votes
6
answers
10k
views
Isn't SQLite a bit underestimated? [closed]
Before I ask the question, let me first describe my thoughts about SQLite.
I happen to like tools that are small, fast and, more importantly, have only the really necessary functionality. That's why ...
user32197
12
votes
2
answers
10k
views
How can I keep my visualstudio database project in sync with my database?
I'd like to have my database schema synchronized with my Visual Studio .dbproj database project.
Right now, I'm using SSMS for most of my database development work, and I've to manually use the ...
- 656
13
votes
3
answers
11k
views
Microsoft's current best practices for building a .NET data tier? And reality?
The development team I'm working with will be moving to .NET 4.0 soon, however, the data access class library we use still uses ADO.NET "classic", meaning SqlDataReader, DataTable, and the like. ...
- 1,246
1
vote
5
answers
2k
views
What is better making a separate temporary table or inserting directly to big table?
I have a big table with 1,400,000 rows, and I need to insert 3000 rows daily in it.
When I insert 3000 rows daily should
I first insert to a temporary table than dump that temporary table to the ...
- 839
33
votes
8
answers
29k
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....
- 441
6
votes
4
answers
2k
views
Unit testing data access objects
I have recently started using test-driven development and unit testing, and it has paid off immensely in the areas where I have aplied it. One area that it has been helpful in is database access. When ...
- 15.7k
10
votes
5
answers
1k
views
Can it be a good idea to create a new table for each client of a webapp?
This is semi-hypothetical, and as I've no experience in dealing with massive database tables, I have no idea if this is horrible for some reason. On to the situation:
Imagine a web based application -...
- 281
-1
votes
1
answer
192
views
Launching web-app with database without static ip [closed]
I have created a small web-app and want to deploy it. I have used struts2 and mysql for the database. The problem is that I do not have a static ip to run the app on my machine. Can anyone suggest me ...
- 101
14
votes
3
answers
2k
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 ...
- 2,275
3
votes
6
answers
872
views
What list of database features/elements are necessary for a programmer to understand?
What database features/elements are necessary for a programmer to understand in order to create non-trivial applications?
I was once asked in a job interview (by a DBA) to rate my understanding of ...
- 2,262