Are there any examples of database design for public transport time-tables ? Or any OpenSource timetable-engine solution? Or if not, how to do it oneselfs? How do I best design the database so that a search can be reasonable fast ? I'd do it like this: For testing, I'd take an X-shaped bus network, with 5 stops (edges and vertex).. ...
I am seeking for a library of predefined models for SQLAlchemy. I think of something like you have in LDAP where you can just use an existing schema like inetOrgPerson, ipHost, ... and don't have to bother creating the structure. ...
Hello, I need to determine if user has already visited a page, for tracking unique page views. I have already implemented some HTTP header cache, but now I need to optimize the SQL queries. The visit is unique, when: pair: page_id + user_id is found in the visit table or pair: page_id + session_id is found or: page_id + [ip + userag...
What is the exact usage of OMF? How init.ora files work? ...
Hi, I'm working on a database design for a building monitoring system. It goes a bit like this: There's a building. A building has multiple areas which can contain loggers or groups of live feed sensors. A logger has a single sensor and it's data is collected by handsets which is then downloaded into the system later. So for example:...
I am creating a comparison matrix and would like it to be dynamic. Take a look at this url: http://cmsmatrix.org/matrix/cms-matrix/1work This type of database design has really challanged me and every approach that i take to this may result in serious performance or maintenance issues. if you do not recommend a relational database for ...
Currently I have laid out most of my design in MySQL Workbench. It appears I will be deploying my DB in SQL Server however. So far my experience with Microsoft SQL Server Management Studio 2008 R2 has sucked due to one flaw. When you save your DB Diagram, it creates the tables in the database. I have attempted design in SSMS which sucke...
Hello I've been wondering this for a while already. The title stands for my question. What do you prefer? I made a pic to make my question clearer. Why am I even thinking of this? Isn't one table the most obvious option? Well, kind of. It's the simpliest way, but let's think more practical. When there is a ton of data in one table a...
I'm developing a couple of media (video games, TV shows, movies) review sites and am having an issue designing the relationships between my data. Case in point: I decided that having a base Content table would be a good idea for most of the data. My Articles, News, and Reviews tables could all point to the Content table. My current s...
I have been thinking about the best way to calculate the amount of on-hand units for a given inventory item. The tables will be very large, with many transactions so it may not be realistic to calculate on-hand on demand by adding all receivings and subtracting all shipments and sales. One idea I have come across is to periodically creat...
Hello Im in the midst of creating a social networking site and I would like to know how I would go about creating the relationships between users. Many sites say that I should create a relationship/friend table, but Im looking into the future and believe that this would be ineffective. This idea could be as popular as facebook and I wan...
I'm working on a database schema that's driving me a little mad at the moment because I seem to be repeating the same tables to reproduce behaviour for different types. Basically the system consists of live sensors that are monitored over a network, and loggers that are collected via a handset. The sensors and loggers are divided up in...
I'm thinking about how to structure the database tables on my Ruby on Rails app. It's an app that will allow academic surveys to be sent to a student population. But as I haven't had a lot of experience with database design, I don't know the answer to the following: Which of the following should my tables look like? Survey ID quest...
I've checked most of the question that was display regarding my title but they were not related to what i am looking for, so i am starting my own question. The game i am trying to re-create as an online game is called Buraco not sure if most or any of you know of it. I already have the basic functions of my game such as: shuffle the ...
Hi, I have a curious question... I wanted to know how to maintain chat data in a database. I have been using a php-mysql application, that stores chat data of users in a database. Now my question is that, if the chat data increases, say, to some millions of records, how to store it? Does mysql support it, or have any limitations ? Take...
I have a collaborative app environment, where I need to store/log information on who changes what in the system. All versions of every object needs will be saved with user information, and no data can ever be deleted. What should I look at besides extending vestal_versions? ...
I want to implement one-to-many concept in my application. This is the scenario, i have two tables (i). Person(ID, NAME, AGE, DEPT) (ii). Person Responsibilities(ID, RESP'S). One person may have more than one resp's. How shall i implement 1-n Relationship here. Actually, i cant able to understand the correct concept of this. Any s...
Hello. I am considering how to structure my MySQL database in e-commerce solution. To be more specific I am looking at the product structure. These are the tables I have come up with so far. What do you think? Explanation of structure The application is multilingual. Therefore the product table are split in 2 tables. If a products h...
Good morning everyone, Please read everything before answering. I have sort of an opinion question but at the same time one that may have a right answer. I'm trying to develop a suite of products and want to make sure that since I'm doing it myself, that I do it right the first time. I've re-wrote the schema multiple times, each time...
A picture does more justice so I'll start with that. So in my Relation_Type table I have several different Types (Owner, Reviewer, Approver, etc). In my Relation_Status table I have different status' for some of the types: Reviwer: (Pending Feedback, Feedback Received) Approver: (Pending Decision, Approved, Denied) My prob...