Hi, I have a question in designing a database for a web-CMS, I have a “Users” table to keep the user and their account information.What is the best way to arrange the user accounts which are removed. In first way, I can create a “DeletedUsers” table and keep the users information whose account has been removed or deleted. In second way ,...
I am not a database guy. My understanding of data modelling is not extensive. From that limited understanding the logical data model is an abstraction of the physical data model, not containing anything specific to the specific storage product/medium. The logical data modelling does appear to involve business subject matter experts in th...
I'm writing software to provide feedback to people across many categories. For example, I might have 30 employees and 40 standards of evaluation (e.g. "arrives on time," "is polite," "appears to brush his teeth," etc). At arbitrary times, the supervisor can submit a piece of feedback like "employee 3 gets a 5/5 for standard 8 (he smell...
WHAT is the better practice?: Keep history records in a separate history table Keep history records in the active table with different status? In my opinion I rather to keep a separate table to avoid creating one huge table with duplicate records which may cause unwanted lag time when querying the table. ...
Some co-workers and I got into a debate on the best way to store historical data. Currently, for some systems, I use a separate table to store historical data, and I keep an original table for the current, active record. So, let's say I have table FOO. Under my system, all active records will go in FOO, and all historical records will...
I am making a website where users can post 'Posts' and then users can 'Comment' on these posts. I have a database with 3 tables. One contains User Information, one contains Post Information and the final one contains Comment Information. I want to set up rules so that if a User is deleted, all of their posts and comments are deleted, an...
I have application working with SQLite DB(table with two rows) I need to recieve _ID row of the selected listview Item, but don't know how to do it. So, main activity public class Main extends ListActivity { private RecipesData recipes; private static int[] TO={0,R.id.row_text_id}; private static String[] FROM={ _ID, CATEGORY_NAME, }; /...
I'm about ready to rip my hair out on this one. I'm fairly new to MS SQL, and haven't seen a similar post anywhere. When I try to do a statement like this: INSERT INTO qcRawMatTestCharacteristic VALUES(NULL, 1,1,1,1,1,1,1,'','','', GETDATE(), 1) I get the following: Cannot insert the value NULL into column 'iRawMatTestCharacte...
Is it better to have a single primary key, or use composite primary keys (usually, they are combination of one primary key and foriegn keys). I have examples below: Composite Primary Key example: AMeta --- AMetaId - Primary Key --- AMetaText BMeta --- BMetaId - Primary Key --- AMetaID - Foreign Key to Ta...
I have a pair of tables with parent-child relationship. domain: id int not null auto_increment primary_key domain varchar(100) not null domain_url: id int not null auto_increment primary key domain_id int not null path varchar(512) Here I want to keep path unique with in one domain. Across the domain path...
With astonishment observe that: 1) that no answer to question Transactional And Reporting Databases - How? mentions SSAS databases from MS BI (Business Intelligence) platform: SSAS (SQL Server Analysis Services) databases (OLAP, datawarehouses, datamarts) + DM (DataMining). SSRS - SQL Server Reporting Services SSIS - SS Integration S ...
Ive got a database that receives links and content related to a specific football club,and the way im storing the content at the moment is in 2 seperate tables,1 that stores the links and the details,fm_sources, and another that stores club specific information,fm_club, that will be used to run queries against the fm_sources content to f...
I'm planning on building two applications using Zend Framework that are very similar but serve two different purposes that can't be part of the same application or be combined into one. However, modules are something I'm considering. The issue I'm running into is if a user registers for the first application I want that information be a...
My clients use one of the following when they sign up for my application: Foo API (requires a "auth_key", "password", "email") Acme API (requires a "secure_code", "username", "password") Bar API (requires a "xyz_code", "pass_key") (fake names, and about 15 more omitted for simplicity) I would prefer not to have 10-15 tables in my da...
Hi, I was looking at godaddy.com which says they offer up to 10 MySQL DBs, but I don't know why you would need more than 1 ever since a DB can have mutliple tables. Can't multiple DBs be integrated into a single DB? Is there an example case where its better or unfeasible to not have multiple ones? And how do you differentiate between th...
Hallo all, I have a problem to introduce a good versioning in my database design. Let's make a easy example. A little rental service. You have a table Person (P_ID, Name), table Computer (C_ID, Type) and a table Rent (R_ID, P_ID, C_ID, FromData, ToData). I want to be able to change say the user name, create a new version and still ha...
I'm curious as to what the major pros/cons are of using an object relational database over a regular relational database are? In what circumstances is it more practical, and are object relational databases the future? ...
I am working on an rfp for a company. They want to keep things high level. They asked me to describe domain model and how it can be extended to support their unique data points. What is the best way to answer it. I have a domain model diagram but I don't want to go in detail with all data fields. I found out that people reviewing it wi...
I am creating a social network and want to have a similar photo gallery to that of facebook. Im guessing I need to use AJAX but I would like to have a comments section for each photo. I was just wondering what the best way would be to design a database around this. Do I just make a table of comments? Would I run into performance issu...
Hi, I am designing a database system for a web CMS. I have added the "status" column in the "Content" table which shows the status of each content in a time. i know there are only some special values which status can accept like : 'draft', 'comment waiting', authorizing pending' and .... i want to create a check constraint to make this c...