The database-development tag has no wiki summary.
1
vote
1answer
45 views
What's the best approach to building a db schema for profile, but to track changes?
I'm working on a site where companies can create a profile then add locations for each profile.
Those first two tables are simple enough.
But any changes to their profiles or locations have to go ...
-1
votes
2answers
105 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.
1
vote
1answer
133 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.
...
1
vote
1answer
75 views
Visual Studio DBProjects and problem with it running post-build SQL (file too big)
What I am doing is creating a DBProject.. importing a DB.. then creating scripts in the PostBuild that are DATA scripts for each table (so that the post build can populate the tables after the schema ...
0
votes
3answers
169 views
How to maintain user relationship when user unfollows 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 ...
3
votes
3answers
166 views
Are database developers considered under DBA jobs?
This isn't career advice, this is more of a question of logistics.
When looking at job market and such there is a lower than what I think would be out there of database admins but I'm curious if ...
3
votes
1answer
182 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 ...
-1
votes
2answers
663 views
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 ...
8
votes
5answers
5k views
What are the advantages of myBatis over Hibernate?
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 ...
5
votes
4answers
426 views
How do you keep track of the meaning of your SQL fields?
The more SQL fields I add to my tables and the more primary/foreign keys I add the more I lose the overview for specific fields for certain scenarios like Get/Add/Delete/Update data.
I use SQL ...
2
votes
1answer
157 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 ...
2
votes
2answers
856 views
Development environment to manage multiple Oracle databases
I am in an enterprise environment where we have applications that need to run against multiple Oracle databases. Developers may need to manage multiple vintages of these databases to support ...
10
votes
2answers
2k 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, ...
2
votes
5answers
219 views
Organizing my products database
I’m developing a web-based store in MVC (very closely based on the SportsStore example in Pro ASP.Net MVC 3 Framework http://www.powells.com/biblio/61-9781430234043-0).
I’m using a SQL database and ...
1
vote
2answers
341 views
How can I avoid concurrent access in PostgreSQL?
I would like to have your opinion, how I can handle the case when PDO engine and Hibernate engine "talk" to the same db? There is a PHP application as frontend, and a Java doing some job after user ...
1
vote
2answers
241 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 ...
14
votes
2answers
4k views
Best practice/Patterns for two way data synchronisation
Quite often in my work the idea of 2-way data synchronisation between database systems crops up. The classic example is two slightly different CRM systems (say, Raiser's Edge and Salesforce) and the ...
9
votes
4answers
503 views
How do I Integrate Production Database Hot Fixes into Shared Database Development model?
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 ...
0
votes
3answers
202 views
database migration: upgrade schema deployed on client machines
I'm working on an application, which when deployed is installed locally on client machines, and uses a local database server. Stupidly, I didn't plan for schema changes -- and now it needs to change.
...
2
votes
1answer
378 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 ...
21
votes
8answers
5k views
Create my own database system [closed]
I need to learn how databases work in order to use them more efficiently, and my way of learning is by doing.
I want to create my own database system. I am not referring to creating a pseudo-database ...
2
votes
3answers
412 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 ...
2
votes
3answers
1k views
How to design a database wherein multiple tags(string) are to be associated with an id?
I have to design a database wherein I have to associate an audio_id with multiple tags(words). I am considering following approaches to select one from these:
1) To have multiple fields for multiple ...
6
votes
3answers
168 views
Are there best practices for checking for errors in business logic for DB refreshes?
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 ...
5
votes
5answers
411 views
Should I use a relational datamodel or Cassandra with ColumnFamily based indexes?
Currently we are working on some storage problems for log data from various servers and communication message logs (HTTP(S), XMPP). There will be many write operations and for read operations we will ...
5
votes
7answers
431 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. ...
5
votes
4answers
265 views
Constant database calls or store in objects?
I'm creating a pretty simple database driven application. Whenever I create a db app, I create classes that mimic the data in the db. Is this good practice?
Am I better off making one big call to the ...
5
votes
12answers
2k 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 ...
3
votes
1answer
674 views
Database Application Design Best Practices [duplicate]
Once upon a time it was common practice for both the business logic and database logic to be written in the same language (eg PL/SQL, Transact SQL, etc), more recently the practice is to separate the ...
9
votes
6answers
2k 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 ...
13
votes
8answers
2k views
Is writing your own Data Access / Data Mapping Layer a “good” idea?
We're currently in a situation where we have a choice between using an out-of-the-box object-relational mapper or rolling our own
We have a legacy application (ASP.NET + SQL Server) where the ...
8
votes
2answers
3k 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 ...
2
votes
5answers
2k views
Real-time stock market application
I'm an amateur programmer. I'd like to develop a software application (like Tradestation), to analyse real-time market data. Please teach me if the following approach is correct, ie the procedures, ...
11
votes
3answers
4k 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. ...
4
votes
2answers
250 views
What kind of open source projects can a database developer get involved in? [closed]
I recently began a new job as a database developer on a medical enterprise data warehouse in an effort to steer my professional focus toward database modeling and development. My goal in asking this ...
8
votes
6answers
11k views
what do database programmers do?
Every time I read about Oracle programmers etc, I get confused. I don't know what exactly they do.
From my understanding, application programmers need to develop the core functionality. The libraries ...
1
vote
5answers
765 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 ...
0
votes
1answer
60 views
what should i use running cron or getting by query
I have a table which has the amount,entrydate and amtperday field , which is to decrease daily.
so what is better running the cron job daily to decrease amount.
or
or at the time of fetching data ...
19
votes
6answers
2k 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 ...
5
votes
5answers
340 views
What are the standard practices for database access in .net?
I have seen weird database access practices in .net. I have seen stored procedures for every database tasks. I have seen every database property name is preceded by it's table name. I have seen fully ...
4
votes
4answers
624 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 ...
9
votes
4answers
427 views
Stored procedure Naming conventions?
One of our senior developers has stated that we should be using a naming convention for stored procedures with an "objectVerb" style of naming such as ("MemberGetById") instead of a "verbObject" type ...
2
votes
4answers
390 views
Visual Database Design Application [closed]
I'm getting to the point where the applications I write need a little more structure during the planning phase. So I'd like to use some sort of visual tool to design the tables and relationships. ...
10
votes
5answers
281 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 ...
4
votes
1answer
325 views
Database design and performance impact
I have a database design issue that I'm not quite sure how to approach, nor if the benefits out weigh the costs. I'm hoping some P.SE members can give some feedback on my suggested design, as well as ...
0
votes
1answer
154 views
Launching web-app with database without static ip
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 ...
8
votes
3answers
308 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 ...
11
votes
3answers
547 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 ...
1
vote
1answer
144 views
Database strategy for connected but disparate applications
I'm working on a series of inter-related but separate web applications, all situated on the same host:
Super Admin
|
---Site Network Admin
| |
| ---Site
| |
| ---Site
| |
| ---Site
|
...
3
votes
6answers
464 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 ...
