Solved

Database utilisation on websites.

Posted on 2007-03-23
5
222 Views
Last Modified: 2013-11-19
I am looking to create some 'easy to edit' databases that can be kept on a server in our office. We want to be able to use this to display information on a website, we need 2 different databases. One that if changed would just change information displayed on the website, like recent news etc so that other employees in the company can change the information very easily.

The other database would have to be a secured database that would store peoples personal details, including a username and password, i need to make this database as secured as possible but still be quick to work with. We need this database so people can log onto a site, and perhaps make secure payments online (does any one have a guide on this also).

Would be very grateful if some one could help me with these problems or give me alternative ways to accomplish the same task.
0
Comment
Question by:CaptainGiblets
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 11

Accepted Solution

by:
ethoths earned 250 total points
ID: 18778506
Wow. That's a BIG topic. You should start to design the system and then identify specific areas where you need help. Then post questions on those specific areas.

As a guide though. I'd uase ASP.Net 2.0 with SQL Server. Put all your db logic into stored procedures and use datasource controls to connect your UI to the Biz tier.

You need to think very carefully about what people will be allowed to change and how you will audit this. You can use the ASP.Net 2.0 Membership provider to authenticate and authorise your users. If you do this then you don't need 2 databases as the security can be controlled using roles.

Hope that gets you started.
0
 
LVL 6

Author Comment

by:CaptainGiblets
ID: 18779092
I may have misread, but from what i got your saying you can set it up so when some one makes changes to the database, it has to be accepted by say an admin before it becomes live?
0
 
LVL 11

Expert Comment

by:ethoths
ID: 18779565
If you write the code yourself, then you can apply any business logic that you want. What you are describing is a common business requirement and can be acheived in many ways depending on your situation. The simplist would be to store the new data with a version number and status against it. If a new version is added (version number incremented) it status is set to pending. The Administrator simply searchs for all status pending documents and sets their status to released if they aprove. Your live system then only shows documents where the status is set to released. Of course you will need to set up the Administrator as the only person with the ability to change a status to released.

0
 
LVL 2

Assisted Solution

by:forrest321
forrest321 earned 250 total points
ID: 18812837
You might be better off using a third party solution, considering the requirements.  There are tons of content management systems freely available, and several of them have secure payment plugins pre-written.  

I have a few questions:  Is it a requirement for this to run on your local servers, or is remote hosting feasible?  If it is to run locally, what type of server and internet connection do you have?  Who would be running the site?  How soon do you need the system operational?
0
 
LVL 6

Author Comment

by:CaptainGiblets
ID: 18834966
it would be preferable for the databases to be ran on our local system, however remote hosting could be considered.

we have a cable connection in the head office with a decent dl/ul speed, i would be building and maintaining the site, and it would be hosted through iomart, and there is no exact date of when it needs to be up as it is just ideas we are throwing around at the moment.
0

Featured Post

Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
The viewer will get a basic understanding of what section 508 compliance can entail, learn about skip navigation links, alt text, transcripts, and font size controls.
The is a quite short video tutorial. In this video, I'm going to show you how to create self-host WordPress blog with free hosting service.

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question