Currently we store our address data like so: string suiteNumber (ie. unit number) string streetNumber (building number) string streetName string streetDirection (N/NW/S/etc.) string streetType (rd/st/ave/etc.) // ... etc. (postal code/city/province/state/country But I'm running into the (common from what I can tell) problem of pars...
Hi. I need to create an online Rss Reader(just like google reader for example) as part of a more big project. I've already done test version using MS SQL. However the problem is that i don't know how to efficiency store feed items in database: each feed item has the id (guid or just permanent link) and while i store them all in one table...
I'm a lead developer on a project which is building web applications for my companies SaaS offering. We are currently using LDAP to store user data such as IDs, passwords, contanct details, preferences and other user specific data. One of the applications we are building is a reporting service that will both collect and present managem...
What are examples of column-oriented DBMSs? Is there any difference in querying (do both use SQL?)? Performance? Data modeling? When and why should I use one over the other? ...
difference is very good to know? ...
How do i create a database for scalability? I am in the middle of http://www.slideshare.net/vishnu/livejournals-backend-a-history-of-scaling which i cant read ATM and need to leave. But i would like to know more about creating a database that scales well. Somethings that it mentioned and occur in my mind are Separate handles for reads ...
I've just started playing with Google App Engine using php via Quercus. I'm not going to be moving my complete app over to app engine, but am thinking of serving up some widgets and api stuff via app engine. At the same time, I will be maintaining my databases in mysql as I've got that running on a seperate server. I make all sorts of...
Yesterday while working on a project I came up on a peculiar 1:1 relationship which left me wondering - how to best implement this (clearly, we had done it wrong :D) The idea is that there are two types of entities, A and B. They can each exist on their own just fine, but they can also have a link between them. If there is a link, then ...
We have a client that needs to set up N local databases, each one containing one site's data, and then have a master corporate database containing the union of all N databases. Changes in an individual site database need to be propagated to the master database, and changes in the master database need to be propagated to the appropriate ...
Has anyone used the TokuDB storage engine for MySQL? The product web site claims to have a 50x performance increase over other MySQL storage engines (e.g. Innodb, MyISAM, etc). Here are the performance claims http://tokutek.com/downloads/tokudb-performance-brief.pdf Is this true? Any personal experiences with this storage engine in us...
Hey SO'ers, I'm making a C#/WPF app that needs to access a number of tables to generate some of the xaml code I will use in the app. The tables will also contain some floating point numerical data as well. The program is single-user, so the rdbms doesn't have to be very fancy, but the file does need to be encrypted as it will be "shrin...
I am working on an online survey. Most questions have a scale of 1-5 for an answer. If we need to add a question to the survey, I use a simple web form, which does an INSERT into the appropriate table, and voila! surveys are asking the new question -- no new code or change to the database structure. We are being asked to add survey ques...
Suppose you have a huge app with a data access layer bound to SQL You want to provide other non-sql DAL, for instance a GoogleAppEngine instance or XML-based backup. How would you approach this migration to a different storage paradigm but with limited flexibility, since it is legacy. I might be missing info here, but One solution I ha...
I am writing a simple app with 24 items in a hash to be persistent across program executions, so Berkeley DB (DBM) should be well suited for this task. And it is just for fun. But I wonder if using it (with Ruby), then when the user presses CTRL-C, then the execution is stopped. In this case, can't the data be all messed up? For exa...
I've always been fascinated by how these huge RDBMS servers can work for months, shuffling data all around without losing it, perform all kinds of queries and generally being very complex beasts. I understand how much effort it takes to create even something as "simple" as SQLite, but I cannot resist the desire to try and develop my own...
This question is related to this post: http://stackoverflow.com/questions/1764469/sql-design-for-survey-with-answers-of-different-data-types I have a survey app where most questions have a set of answers that are 1-5. Now we have to do questions that could have a variety of different answer types -- numeric, date, string, etc. Thanks to...
Hello All I hope you can help find an answer to a problem that will become a recurring theme at work. This involves denormalising data from RDBMS tables to flat file formats with repeating groups (sharing domain and meaning) across columns. Unfortunately this is unavoidable. Here's a very simplified example of the transformation I'd re...
I've been reading up on a lot of posts about non-relational databases, the whole NOSQL movement, and there's a lot of fresh new activity around it. It seems like a very interesting approach to building highly scalable web applications but unfortunately (but also a good thing at this nascent stage) there isn't quite a clear leader/standar...
I want to create an index on a table and I'm trying to decide the order of the columns in the index. Normally, I go by gut feeling and my knowledge of the data and of the queries the application will typically generate, but in this case looking at the data and the queries I think I need to create and index based on column selectivity. So...
I'm creating a sports statistics database. With it, I'd like to catalog game/match statistics for many types of sports. For example, this database would be able to tell you how many touchdowns the Carolina Panthers scored in the 09-10 season (football), or how many free throws were made by the Miami Heat in their last game (basketball). ...