Database with query capability [Archive]

View Full Version : Database with query capability

jmaghen

05-04-2009, 02:16 AM

So I've been playing around for over 10 days and reading different tutorials about MS access, mySQL, and MS SQL server to no avail. I've asked everywhere and nobody have been able to answer and from my research it seems this forum is filled with the most advance users so I am hoping I may finally get the answer I need here.

I work for an investment company and we use sharepoint. Trying to add a webpart to sharepoint that has access to the database I have made in excel of investor companies and the range in which they will be interested in investing in another company, like a prequalification or minimum or maximum in the case of some fields. For example, I want to have a query with many drop down bars or boxes with the fields of my database (minus the contact people and address and bs stuff) and when I want to make a query search I can pick >$4 million, california and new york... or all, for example and then it will give me all the companies in my database that will invest more than $4 million and in a CA or NY company. Although, I will have more fields so I can narrow results down. I think I have come to the conclusion that Sharepoint can't do this, but I want to make sure and if it can't does anyone know what type of software I would need. Is it access or SLQ and if so what exactly is the term of what I am looking to do? I was hoping I create the program through SQL or access and use Sharepoint as the shell, if possible.

There is a similar thread posted in here about kinda doing the same thing but have the query on a website and it searching the database. That wouldn't be a bad idea if I can integrate the query as a web part in Sharepoint and it searching my database in excel or whatever program I need to use for it to search it. One thing I forgot to say is I will be updating the database bi-monthly if that makes a difference.

Thank you so much in advance for any response :)

forum_amnesiac

05-04-2009, 08:48 AM

If you use MS SQL, MYSQL etc you will be able to build a database that can be interrogated easily and powerfully.

Once you get the 'hang' of these databases they are also easy to maintain.

I would have a look at them and choose whichever you prefer.

I don't know whether you'll be able to access and query these databases with Sharepoint, but a lot of people use PHP for this.

jmaghen

05-04-2009, 08:30 PM

boogyman

05-05-2009, 01:25 AM

So how is it that for example job websites like monster or careerbuilder you can pick specific fields etc. and then it searches their database depending on your preferences. I guess that's kinda what I am looking for. Is that done through PHP and SQL or through another mechanism?

I think you need to read up on databases and searching. Fields (individual bits of info) and Records (unique collection of fields) can be stored, searched, and manipulated through various commands.

It's fruitless for us to tell you something here on the forums, when there are multitudes of resources (including tutorials) on the internet.

So do ya "homework" and if you have a specific question, we shall be glad to help you understand not only the issue, but the concept behind it.

jmaghen

05-06-2009, 09:07 AM

thanks for the input... what I do want from you is what exactly it is called that i need to research on. Like I have started reading the sql for dummies and i want to know what to look at on google to figure this out as fast as possible nad learn on the way.

Thanks

forum_amnesiac

05-06-2009, 09:45 AM

If you search for MYSQL, MS SQL, etc you will find tutorials, examples and documentation of just what these databases do.

There is also another that seems to be popular, because it is portable, and that is SQlite.

If you are planning on having your database hosted on the web you also need to consider what database system your host provides. This would be your first port of call, find this out.