Topic profile page for Database design.
This page has aggregated data from forum posts, threads, listings, online discussions, newsgroups, messageboards, and other online sources which contain user generated content for the term: Database design.
Topic "Database design" was discussed 0 times on 0 sites in last 3 months
Started 1 day, 15 hours ago (2009-12-10 14:59:00)
by n4kw4z
Physical Database Design: the database professional's guide to exploiting indexes, views, storage, and more Morgan Kaufmann; 4Rev Ed edition | ISBN: 0123693896 | 448 pages | March 21, 2007 | PDF | 7 Mb The rapidly increasing volume of information contained in relational databases places a strain on databases, performance, and maintainability: DBAs are under greater pressure than ...
Started 2 days, 9 hours ago (2009-12-09 21:34:00)
by vinod.alva@orac...
Our Project has a huge Fact (F1) with 38 GB data (75 Millions records) associated with three other dimensions D1 (with 7 million records) D2 (with 0.5 million records) D3 (with o.3 M records On these dimensions, we have few discrete valued attributes on which analysis are done (like Status, Type, Type Group, Flags) We also have Complete refresh ...
Started 5 days, 10 hours ago (2009-12-06 20:06:00)
by RJweb
I am fairly new to db, can do a single table, but now need to expand to connecting tables. Was wondering what tool do you use to design mysql db's? or even any tutorials, thx in advance, RJ
Started 1 week ago (2009-12-04 19:32:00)
by Wedgetail
Hi all who can be of assistance. I am at the start of designing a database for an engineering consultancy firm who has both corporate and private clients, and undertakes design and investigation projects. The database will ultimately contain information on: - various companies and individuals the firm has worked / dealt with. - project information. - a document control system ...
Hello, I am designing a large database and I was looking for some opinions on how to go about the design of one of the tables. I have the entire database design completed in Visio and ended up with about 50 or so tables. Overall the database has a very good design but I ran into one problem on the permissions table. I have one table (related to usergroup) which controls the ...
We are planning in the near future to offer our software as SaaS (software as a service) it is written in Java and uses Oracle 10g. We have 3 options: 1- one database per customer. 2- one schema per customer. 3- One database and one schema using VPD. of course there is advantage and disadvantage for each approach. I would like to know if you are ...
Started 1 week, 1 day ago (2009-12-03 10:09:00)
by AndyInUK
Hi, We have got hundreds of tables and SPs but no diagram. Basically we just keep on adding new tables as per requirement or delete table and there is no info. What i want to implement now is - a whole database diagram - So what would be the best way keeping in mind that database is big if not huge. Thank You Andyyy
Started 1 week, 2 days ago (2009-12-02 11:57:00)
by malcolm.reed
I'm hoping someone can get me back on track with this db design. This is a database to record and track documents and CDs at my company. I have separate tables for documents (objects) and CDs. Both objects and CDs are revised from time to time and this is recorded using related revision tables for both of these. The contents of a specific revision CD are held in tblCDContents which joins ...
Started 1 week ago (2009-12-04 12:54:00)
by Justin Cave
I'd be much more comfortable with VPD-based security rather than application security. - If you set out with the idea of securing data access via VPD, the data model tends to be far more amenable to tying data elements to particular groups of users. While nothing stops you from, for example, putting a CLIENT_ID field in most/ all tables in the schema even...
Started 1 week, 1 day ago (2009-12-04 00:31:00)
by d@nish
Mycroft Holmes wrote: I would opt to clean up the database Although it would be a bit of pain while cleaning the mess but the in the long run, it is going to be very helpful.
Started 1 week ago (2009-12-04 16:53:00)
by felgall
Your option 1 ought to be normalised to get rid of the repeating group. That will give you a table with three columns. User Group Permission Type (eg. canCreateCustomers) Permission Value (yes or no)
Started 5 days, 6 hours ago (2009-12-07 00:04:00)
by AnanthaP AnanthaP is offline Registered User
Project contacts could ideally become part of a single generic contacts list. Linked to their present employer and status and also separately searchable in case they change dzobs or assignments. End
Started 1 week, 1 day ago (2009-12-03 10:09:00)
by ShiftyDev
Travis - I think I'm following you now. Thanks for the explanation! Do you think breaking out the databases and stuff will work with fail-over clusters? I guess I would need a cluster for each database level. From the sounds of it, this system needs to have 100% Availability. Maybe I'll pitch that we get a consultant to come in and give us some advice for a few hours....
Started 6 days, 20 hours ago (2009-12-05 10:33:00)
by Pat Phelan
Quote: Originally Posted by advancetina My special interests or skills are: - HTML - SEO - Web design - Internet business Welcome, but I'm afraid that you're in the worng place! DBForums is a database forum, and databases are a critical part of web sites, but are only indirectly related to your interests...
Started 6 days, 17 hours ago (2009-12-05 13:01:00)
by Marcus_A
Sounds like a good high school. I assume you need to develop a data model to handle this. You can download a trial version or freeware version of some simple modeling tools to come up with the design of the database that will handle the business requirements stated. Are you supposed to turn in a data model, or do you have to actually create a real database as part of the assignment? ...
