0
голосов
1ответов
151 просмотров

Biological Taxonomy Data Model

Looking for industry/standard data model for biological classification. Wikipedia

2
голосов
2ответов
72 просмотров

Queries or methods in Rails?

I'm creating a Rails app and would like to know which of these is better: Store default data, like categories names, in a DB and get the data with queries; or create a method in ApplicationController that, with the category_id as argument, returns info about the desired category? Obs: The val...

0
голосов
4ответов
1933 просмотров

When designing a new CMS database, what would be the most important features to add?

While this question asked something similar too, I'm interested in this from another angle. I'm not interested in the GUI part but in the database/domain part. (My preference is SQL Server with C#/ASP.NET but this Q should be language agnostic.) When designing a CMS system, data needs to be sto...

0
голосов
2ответов
88 просмотров

Building a map simulation system

I'm currently working on a project that simulates a map with routes on it that allows users to decide their destination, and the system will calculate the shortest path to it. The map should receives real-time traffic data in which the traffic flow changes along the way while the vehicle is trave...

2
голосов
3ответов
452 просмотров

Simple DB design question -- sets of measurements

I have multiple sets of measurements. Each set has multiple values in it. The data is currently in a spreadsheet, and I'd like to move it to a real database. In the spreadsheet, each set of measurements is in its own column, i.e., 1 | 2 | 3 | ... 0.5 | 0.7 | 0.2 | ... 0.3 | 0.6 | 0.4 | ...

0
голосов
3ответов
364 просмотров

Should I use multiple fields or JSON?

I'm designing a DB and would like to know the best way to store this: I have an user table and let's say it can have 100 item slots, and I store an ID. Should I use JSON ({slot1:123232,slot20:123123123,slot82:23123}) or create 100+ fields (slot1, slot2, slotn)? Thank you.

5
голосов
6ответов
258 просмотров

Are there useful static analysis tools for databases?

Is there a tool for examining the configuration and schema of a database for dubious fields, relationships and configuration, similar to how static analysis tools like lint will flag dubious lines of code? I'm not necessarily asking for normalization, but surely there's stupid stuff that can be ...

1
голосов
3ответов
1460 просмотров

trying to figure out the best database schema

I want to come up with a generic schema (if possible) to use for a number of different events that I am managing. These events can be weddings, birthday parties, etc. So far I have 3 main tables: Contact Table - the usual info like address, phone, etc. Events Table - a list of events with s...

0
голосов
1ответов
50 просмотров

How to deal with .1 & .10 with MySQL & Rails

I currently have a MySQL database with a table that has a field that is typed as a decimal. Currently there are values that range from *.1 through *.9 but we now need to be able to handle the following: I need to be able to add *.10 to this field and sort it accordingly. In this use-case .10 D...

1
голосов
9ответов
3850 просмотров

Database "pointers" to rows?

Is there a way to have "pointers to rows" in a database? for example I have X product rows, all these rows represent distinct products but many have the same field values except their "id" and "color_id" are different. I thought of just duplicating the rows but this could be error prone, plus m...

3
голосов
5ответов
560 просмотров

Can you provide some advice on setting up my database?

I'm working on a MUD (Multi User Dungeon) in Python and am just now getting around to the point where I need to add some rooms, enemies, items, etc. I could hardcode all this in, but it seems like this is more of a job for a database. However, I've never really done any work with databases befor...

1
голосов
3ответов
130 просмотров

Three potential db designs

I've been considering three similar database designs, but haven't come up with a very strong for or against regarding any of them. One huge table for content content: int id, enum type, int parent_id, varchar title, text body, text data This would assign each row a type (news, blog, etc), a...

1
голосов
4ответов
82 просмотров

Is there a general term for a pairing of tables where one has header information and the other has detail lines?

Is there a general term for a pairing of tables where one has header information and the other has detail lines? For example, a pair of tables describing sales orders, or a pair storing bill of materials data.

2
голосов
5ответов
1177 просмотров

SQL Server 2008: N small databases VS 1 database with N schemas

I have a database server with few main databases, and few dozens of small ones. These small databases are kind of intermediary/staging databases for data import from various sources into main database. Data import is a daily task. They are all quite similar in structure as the implementation of ...

3
голосов
4ответов
295 просмотров

MYSQL table structure

I am trying to decide whether to create a global view table or 1 for each section. for example, Lets say I have products, categories and pages. Do I have 3 tables e.g: CREATE TABLE `tbl_products` ( `p_id` INT NOT NULL , `p_views` INT NOT NULL , INDEX ( `p_id` ) ) ENGINE = MYISAM CREATE TABLE...

7
голосов
2ответов
1841 просмотров

Storing OpenID information in database

This is a database question. I have an openid library already installed and working. I want to use OpenID on a website I'm working on. There are three types of users. Named accounts using email/password to authenticate Named accounts using OpenID to authenticate Anonymous account using OpenID ...

0
голосов
4ответов
612 просмотров

How to design a database where employee can belong to either department or division

I have a database where employees, departments and divisions are stored. Each employee can belong to either a division or a department (1-to-1 relationship). To store that data I have created three tables: Employees, Departments, Divisions. How do I correctly wire them to store such relationship....

3
голосов
1ответов
8076 просмотров

How to handle foreign key while partitioning

I am working on fleet management. I am having large amount of writes on a location table with following columns date time vehicle no. long latitude speed userid (which is foreign key...) Here this table is going to have write operation every 3 sec. Hence there will be millions of record ...

18
голосов
5ответов
9187 просмотров

Asking for opinions : One sequence for all tables

Here's another one I've been thinking about lately. We have concluded in earlier discussions : 'natural primary keys are bad, artificial primary keys are good.' Working with Hibernate earlier I have seen that Hibernate default creates one sequence for all tables. At first I was puzzled by this, ...

1
голосов
6ответов
424 просмотров

Database design software for a student?

I am taking a database class and have to draw a bunch of different kinds of diagrams. Specifically, I need to draw ERD and dependency diagrams. The instructor does not want any hand drawn diagrams but does not offer any clue as to what software to use. Does anybody have any suggestions?

3
голосов
3ответов
1392 просмотров

Database Design: Alternate to composite keys?

I am building a database system and having trouble with the design of one of my tables. In this system there is a users table, an object table, an item table and cost table. A unique record in the cost table is determine by the user, object, item and year. However, there can be multiple records...

2
голосов
3ответов
196 просмотров

OO data model - can I ignore Object Relational Mapper constraints?

I am just starting to model the data for a new C# project, which must be persistable. Looks like the most natural OO model will have lots of nested .Net generics. Lists of objects, and these objects will also contain Lists of other generic types, and so on, nested at least three levels deep. I...

4
голосов
5ответов
1073 просмотров

lots of columns in a table

A table in our schema is already having 100 columns.We need to add some 600 more columns if we follow horizontal data storage method. If we go for vertical data storage which means creating new table and creating referential integrity with table having 100 columns, there will be issue with joinin...

2
голосов
3ответов
116 просмотров

Performance enhancements for tables

With MySQL I often overlook some options like 'signed/unsigned' ints and 'allow null' but I'm wondering if these details could slow a web application down. Are there any notable performance differences in these situations? using a low/high range of Integer primary key 5000 rows with ids from...

0
голосов
4ответов
1192 просмотров

Database Design for Document Library

We are attempting to built the Document Library (File Management) as apart of our core apps. It starts with simple one obviously. I need a feed back regarding the database design for this particular module. Initial Design: File table: FileID FileGUID TenantID FileName FileDescription FileIma...

1
голосов
2ответов
714 просмотров

SQL Server 2008 data types

What are the different SQL Server 2008 data types? I am specifically trying to find the equivalent of a long int.

4
голосов
17ответов
982 просмотров

5 separate database or 5 tables in 1 database?

Let's say I want to build a gaming website and I have many game sections. They ALL have a lot of data that needs to be stored. Is it better to make one database with a table representing each game or have a database represent each section of the game? I'm pretty much expecting a "depends" kind of...

2
голосов
6ответов
359 просмотров

Asking for opinions : Accent marks / diacritics in primary key

I have this application that uses natural primary keys. The database uses the WE8ISO8859P15 character set. So in my table City whe have primary keys like 'MEDELLÍN' and 'MÜNCHEN'. I have a hunch we are going to have a lot of trouble with this. The problems I see Interfacing this data to data...

2
голосов
6ответов
1507 просмотров

What are good candidates for creating indexes on beside pk and unique columns?

I'm always asking myself should I create an index or not in my Oracle tables, what criteria in a table makes the index worth creating? And is it also a criteria in the query? And are there (with respect to Oracle) different kinds of indexes you can create based on some factor(s)?

4
голосов
2ответов
417 просмотров

Database design: Keeping track of tag changes between revisions

I'm building a revision system similar to the one Stack Overflow has and there's one thing I can't get my head around, what's the best way to the differences in tags between multiple revisions? The simplest way I can think of is we have 3 tables, revisions, tags and another to link the two. Eac...