Database Questions

Jul 20, 2005

We are negotiating with a vendor and we have a few questions:

1) From a licensing point of view, what is a database? Can we install
multiple copies of SQLServer on one box? In that case, would each
copy be a different database?

2) Within a single SQL Server installation, I can create multiple
databases, as listed in the Enterprise Manager. I can switch among
them using "use ..." commands. Would these be treated as different
databases?

3) We have copies of our transactional database in identical
development, QC, and production environments. Is this a single
database, or 3 databases?

View 3 Replies

Database Design Questions

May 17, 2008

Hey guys, this is my first post here. I just joined recently and I am loving the videos as they've really helped me step into ASP.NET and VB. Just some background, I used to be a CS major several years ago and programmed in Java and C, though I only went through 2 years before I moved majors. I didn't like the focus of my universities program, and decided to pursue other options. Ironically, I am now delving back into programming, but with a focus on web development, hence learning VB and ASP.NET. Anyways I am developing my first web application and I needed some help.Basically, what the program does is allow users to login to this web site and then store private information, which they can then access at a later time from any computer that is connected to the web. I have already setup user membership by following the video (lesson 8 of the ASP.NET series - Securing your Web site with Membership and Login Controls) from the Learnvisualstudio.net series. I can login to my site just fine, as well as creating a new user etc. The next step is designing the SQL database, and setting up the page that retrieves a users data, allowing them to view the private information they've stored, as well as to edit, create, and delete information.Unfortunately, while I can see the broad method of doing this, I am a bit lost in actually implementing it. The first stumbling block I am coming across is the SQL database itself. I have attached an image of how I have the database designed so far. Note that the aspnet_user table is the one that ASP.NET creates automatically when you enable membership controls and such.So basically, a user logs in, and they are greeted with a list of all of the "stickies" they have created. Each sticky has a title, as well as up to 4 fields, and you can enter the name of the field, as well as enter the actual data. It's foreign key ties back to the UserId that ASP.NET already created. The user can also organize their stickies into categories, hence that table. The Settings table will be where a users settings will be saved, such as which view mode they prefer etc. At this stage of development, that table is un-important and un-developed.So on to some of my questions. As it is designed now, there will be one table with every users stickies, as well as categories, and when a user logs in, the program will look at the category and stickies tables, and grab the ones that are associated to the users UserId. So one of my first questions is; is this a good design? I ask this from a security standpoint as well as a speed and efficiency standpoint. I want this site to be able to support at least 50,000 to 100,000 users, each with any number of "stickies" and "categories" With that size of a user base, would each user be looking at massive load times because the program would have to go through a very large table to grab only the ones that are linked with the users UserId? Say I have 50,000 users, and each user has 5 "stickies", that means that my user_stickies table would have 250,000 rows of data, and the program would be trying to find only 5 of those. Is this a really inefficient way of doing this? Should each user have their own category and stickies table? If so, how would I go about doing this? And in that case, instead of having a couple giant tables, my SQL DB would instead have a ton of tables, is this even any better?I have other questions, but I guess I'll start with this. What are your guys' thoughts? I am a newbie, so this may be a silly set of questions. I try to read up and research as much myself as I can, but sometimes you have so much information thrown at you at once its hard to grab out the specific answers you need.

View 4 Replies View Related

Database Design Questions

Dec 6, 2004

I’m trying to design a database that allows the users to give each individual client/company unlimited addresses and salutations. I can build the design that accommodates this, but I cannot figure out how to handle them knowing which salutation to use with a mailing they might do to the clients.

I have put the Company Name and Position (title) in the address table so that when doing a mailing the company name and title are associated with the company address being mailed too. But again, I’m not sure how they would choose a salutation if they have many choices.

Looking for any of your thoughts or suggestions.

Thank you,