I'm creating a user-based website. For each user, I'll need a few MySQL tables to store different types of information (that is, userInfo, quotesSubmitted, and ratesSubmitted). Is it a better idea to: a) Create one database for the site (that is, "mySite") and then hundreds or thousands of tables inside this (that is, "userInfo_bob", "...
any tool to generate incremental release script for oracle database. like Redgate DBComparer for SQLServer. ...
I have one table that saves comments for a varied set of content types. These are saved in other tables (news, articles, users). I wonder what's the best way to connect these tables? In previous projects I used a second table for each kind of content. They held the id of the certain content mapped to ids of the comments table. So for ea...
I want to write a new application that will use a DBMS. In the design stages of this application and weighing the options I found out that the there will be a lot of database accessing which means many queries. My biggest concern with developing this system is the unwieldy nature of SQL select, update, and delete statements scattered aro...
I'm about to pick one of these programmes. I've done prerequirements for both and really enjoyed them. By software engineering I mean designing, coding, testing, managing and all related stuff. Getting more advanced in what most undergraduates do. Databases narrow to relational databases, data mining, data warehousing, queries optimiz...
Hi folks, I'm trying to see if anyone knows how to cluster some Lat/Long results, using a database, to reduce the number of results sent over the wire to the application. There are a number of resources about how to cluster, either on the client side OR in the server (application) side .. but not in the database side :( This is a simi...
From my code (Java) I want to ensure that a row exists in the database (DB2) after my code is executed. My code now does a select and if no result is returned it does an insert. I really don't like this code since it exposes me to concurrency issuses when running in a multi-threaded environment. What I would like to do is to put this l...
I've been a web developer for some time now, and have recently started learning some functional programming. Like others, I've had some significant trouble apply many of these concepts to my professional work. For me, the primary reason for this is I see a conflict between between FP's goal of remaining stateless seems quite at odds wi...
Hi, I was wondering if anyone has a good solution to a problem I've encountered numerous times during the last years. I have a shopping cart and my customer explicitly requests that it's order is significant. So I need to persist the order to the DB. The obvious way would be to simply insert some OrderField where I would assign the n...
I have written a database application using a binary file as storage. it is accessed via powershell cmdlets. You can put information into the database using the put- and you can read information using get-. The problem is synchronisation. What is the best way to ensure that the cmdlets don't access the file at the same time? The put- ...
I have create a form class for editing deleting and add users to a database. If I want to edit a user how can I simply supply the information of the user to the form. I use a Zend_Db_Table to get the data from the database. This is the userForm class: class UsersForm extends Zend_Form { public function init () { $username...
I'm interested in getting certified for SQL Server. Since you can either be certified for SQL Server 2005 or 2008, I'm not sure which one to pursue. It seems that there are more training materials for SQL Server 2005 certification and more companies use it. However, getting certified for SQL Server 2008 would mean that I'd be current ...
Hi folks, I know this is probably on the Internet somewhere but I can't find the answer here on Stackoverflow so I thought I may boost up the knowledge base here a little. I'm a newbie to Ruby and Rails but my company is getting pretty invested in it so I'm trying to get to know it in a little more detail. It's been difficult for me t...
Hello, I am building a "document storage" system for storing text files on my server. I was wondering if anybody has any recommendations or best practices on the best way to store text files remotely. The system will be user-based, each user can upload multiple text files. I want the text files to be stored in some fashion which is e...
I am trying to work out the best database model for the current setup: An administrator can create "customer products". This means services/products which customer can attach/subscribe to. The simple cases where the product simply costs a price, or the product subscription should send an e-mail is easy to model in the database. But how...
Many databases I've encountered (Like SQL Server) use a single file to store the entire database. This seems to be a pretty common approach. What are the advantages to storing the entire database in a single file, as opposed to breaking up the data into more logical units, such as a single table per file. Also, how does a database wo...
Informed options needed about the merits of flat file database. I'm considering using a flat file database scheme to manage data for a custom blog. It would be deployed on Linux OS variant and written in Java. What are the possible negatives or positives regarding performance for reading and writing of both articles and comments? W...
Hi everyone! Long time listener, first time caller. I'm a full time SE during the day and a full time data mining student at night. I've taken the courses, and heard what our professors think. Now, I come to you - the stackoverflowers, to bring out the real truth. What is your favorite data mining algorithm and why? Are there any s...
I am using CODBCRecordset (a class found on CodeProject) to find a single record in a table with 39 columns. If no record is found then the call to CRecordset::Open is fine. If a record matches the conditions then I get an Out of Memory exception when CRecordset::Open is called. I am selecting all the columns in the query (if I change th...
How would you model these relationships in a db? You have a Page entity that can contain PageElements. A PageElement can for instance be an Article, or a Picture. An Article table obviously has other members / columns than a Picture. An article could have ie. "Title", "Lead", "Body" columns that are all of type nvarchar, while a Pictur...