Go Back   Team-BHP > Around the Corner > Shifting gears > Gadgets, Computers & Software


Reply
 
Thread Tools Search this Thread
Old 28th August 2008, 17:14   #1
Senior - BHPian
 
sammyboy's Avatar
 
Join Date: Jul 2006
Location: Gurgaon/Doon
Posts: 1,711
Thanked: 290 Times
Default Information Database Creation and hosting- Need Help please

Hi All,

A friend of mine wants to set up database where data can be uploaded and people will be provided with paid licenses to pull the data reports from it.

Giving you an example: Lets assume there is a database which has information about all the diff car manufacturers all across the world, car models, prices,sales reports etc.

Now if someone wants access to, lets say, all maruti 800's sold in india he will be given access only to that particular data and will not be able to access any other information through a front end.
He will purchase a license and charged Rs 100 for a year.

On the other hand if someone wants info about all Honda models in all countries he will have a separate license with that permission and will be charged accordingly.

Please suggest how to get this done.
Hosting and space would also be a requirement.

Can anyone suggest an IT firm you know of which can help us with this ?
Also if possible please also shed some light on what kind of charges can be associated with a database setup of this kind.

THanks for your help. Please feel free to let me know if you require any information which you might need to suggest a solution.
sammyboy is online now   Reply With Quote
Old 28th August 2008, 18:09   #2
Senior - BHPian
 
sammyboy's Avatar
 
Join Date: Jul 2006
Location: Gurgaon/Doon
Posts: 1,711
Thanked: 290 Times
Default

Bump , where are the IT wizards of the team. Help please?
sammyboy is online now   Reply With Quote
Old 29th August 2008, 13:52   #3
BHPian
 
sk456's Avatar
 
Join Date: Jun 2006
Location: @Noida/Gurgaon
Posts: 570
Thanked: 7 Times
Default

What you need is a web application with authorized access to different reports that one could access based on his access level ( which could be defined as per payments made ). There would be also be a separate interface where data on different topics could be fed into the application database.
India has a zillion IT firms. Howver charges would depend on the total Man-hours required to build the application. You would need to contact any IT services firm to analyze your requirements ( which could be chargeable ). They would then give you a quote/estimate for the solutuon based on an inital analysis. On go ahead from you they would have a detailed analysis followed by design, development and testing. The application would then be release to you for a user acceptance testing . after your go ahead it would be deployed on a LIVE server.
Hope that helps !
sk456 is offline   Reply With Quote
Old 1st September 2008, 15:10   #4
Senior - BHPian
 
sammyboy's Avatar
 
Join Date: Jul 2006
Location: Gurgaon/Doon
Posts: 1,711
Thanked: 290 Times
Default

THanks a lot sk456. It has helped us build a path to follow.
Was wondering if anyone of our friends here know of any firm that could do this. It will be helpful to get someone who is recommended by the team.
sammyboy is online now   Reply With Quote
Old 1st September 2008, 15:13   #5
Team-BHP Support
 
bblost's Avatar
 
Join Date: Jul 2007
Location: Hyderabad
Posts: 9,552
Thanked: 6,310 Times
Default

Ask him to check out on Virtual Private Database from Oracle.
VPD
bblost is offline   Reply With Quote
Old 1st September 2008, 15:14   #6
BHPian
 
rmonie's Avatar
 
Join Date: Jul 2007
Location: Gurgaon
Posts: 214
Thanked: 41 Times
Default

Another option is to detail out the specifications and use a site which is a freelance coders marketplace. The ones I have used are elance.com & getafreelancer.com A Google search on "freelance coders" should get you decent results. You will find a number of local companies as well on these & other sites.
rmonie is offline   Reply With Quote
Old 1st September 2008, 15:19   #7
Senior - BHPian
 
sammyboy's Avatar
 
Join Date: Jul 2006
Location: Gurgaon/Doon
Posts: 1,711
Thanked: 290 Times
Default

Thanks bblost, unfortunately my friend is all finance n stuff n zero tech. I know a lil bit but am more of a proj mgmt kinda person so were looking for someone to build, host and manage the application and database.
Let me go thru the link and will get back to you with questions
@ rmonie - Good suggestion, have been working with guru, elance and getafreelancer for about a year n a half now but never struck me. Will check it out as well.
sammyboy is online now   Reply With Quote
Old 1st September 2008, 15:44   #8
BHPian
 
rapideffect's Avatar
 
Join Date: Jun 2005
Location: mumbai
Posts: 147
Thanked: 4 Times
Default

Check with ww.znetindia.com for the same. I believe they will provide you cost effective hosting, building and maintenance of your portal.
rapideffect is offline   Reply With Quote
Old 1st September 2008, 15:53   #9
Team-BHP Support
 
bblost's Avatar
 
Join Date: Jul 2007
Location: Hyderabad
Posts: 9,552
Thanked: 6,310 Times
Default

Sammy as you know a lil bit more
I am trying to explain VPD in simple terms.

Consider the following:
EMP
----------------------
eno sal
1 10000
2 20000
3 30000
4 15000
5 16000
6 10080
7 10700
8 15000
9 12000

Users
------------------------
Users Options
abc A1
xyz A2
lmn A1 and A2
opq A1 or A2

Pridicates
------------------------
Condition_name Conditions
A1 Eno < 10
A2 Eno > 5 and Eno < 8

Now when any user runs a query
select * from emp
Internally its executed as
select * from (select * from emp ) where (attach predicate)
here the sql will fire for
abc as
select * from (select * from emp ) where ()
xyz as
select * from (select * from emp ) where (Eno > 5 and Eno < 8)
lmn as
select * from (select * from emp ) where ((eno <10) and (Eno > 5 and Eno < 8))
and so on.
bblost is offline   Reply With Quote
Old 1st September 2008, 15:58   #10
Senior - BHPian
 
sammyboy's Avatar
 
Join Date: Jul 2006
Location: Gurgaon/Doon
Posts: 1,711
Thanked: 290 Times
Default

Thanks rapideffect. Will contact them.
@bblost - Makes sense to me Will be useful when I try explaining stuff to the people who will work on this . Thanks man.
sammyboy is online now   Reply With Quote
Old 2nd September 2008, 06:39   #11
Team-BHP Support
 
bblost's Avatar
 
Join Date: Jul 2007
Location: Hyderabad
Posts: 9,552
Thanked: 6,310 Times
Default This topic is quite interesting

Some points that came to my mind.
1. Identify the tables that need to be secured.
2. Setup tables may not even be exposed to an open UI.
3. Name all secured tables with a trailing _S.
4. Create views on all the Secured tables.
5. Application developers can only use the views.
6. A simple string search for _S will catch all violations.
7. Identify the columns that can be used to determine user access levels.
8. This way you can sell access rights based on multiple factors.
For Example: If your car table has information like
Body Type:Cubic Capacity:Manufacturer and so on.
You can set up access rights based on these colums.
i.e a user will buy access to cc 1000 to 1600.
or Manufacturer or Body Type and so on.
9. Your developers will need to create UI screens where these conditions can be entered.
10. Conditions can be either static text or dynamic sqls.
11. Default access behaviour needs to be taken care off.
12. Validate the code againts security issues.
13. No point putting in a fancy system but google showing all the results.
14. Enable and disable security context based on the UI being accessed.
15. These kind of programs can be time consuming. So validate every thing for performance.

Do ping back if you have any questions
bblost is offline   Reply With Quote
Old 2nd September 2008, 10:56   #12
Senior - BHPian
 
NetfreakBombay's Avatar
 
Join Date: Jan 2008
Location: Bombay
Posts: 1,375
Thanked: 315 Times
Default

Consider "Build vs Buy" for this.

I think most off-the-shelf reporting solutions will do this for you. "Business Objects" is the king but will cost a lot.

Free product "Pentaho" will do the job here, unless you are planning to add advanced visualization/dashboards from day 1.

Showing data on the web and being able to select who can see what, is one of the common requirements for any data.

Sugar coated marketing name for such products is "Business Intelligence"

Pentaho Commercial Open Source Business Intelligence: Home
Business Intelligence from Business Objects

EDIT : Some marketing blurb for pantaho Pentaho Commercial Open Source Business Intelligence: Product Demos

Last edited by NetfreakBombay : 2nd September 2008 at 11:01.
NetfreakBombay is offline   Reply With Quote
Old 2nd September 2008, 10:59   #13
BHPian
 
ajitkommini's Avatar
 
Join Date: Sep 2006
Location: Bangalore
Posts: 483
Thanked: 109 Times
Default

I work with an excellent application called Oracle APEX (Application Express) that is really good for stuff like this. You can create a very professional-looking database-driven application in a relatively short time, with minimal coding skills (basic PL/SQL, HTML etc.) Check it out at: Oracle Application Express

Oh and the best part? the application itself is free once you buy the database license!

Last edited by ajitkommini : 2nd September 2008 at 11:01.
ajitkommini is offline   Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads
Thread Thread Starter Forum Replies Last Post
Effective Resume/CV creation ,dos and donts ,suggestions . black12rr Shifting gears 29 26th April 2011 00:55
Secure file hosting site. johy Gadgets, Computers & Software 0 9th March 2007 18:10
Help me Name Her!!(my new creation).. SRK Shifting gears 18 21st December 2006 12:55
Team Banzai's Creation: Dora, no human driver. no remote control Technocrat The International Automotive Scene 1 1st August 2005 19:51


All times are GMT +5.5. The time now is 10:19.

Copyright 2000 - 2017, Team-BHP.com
Proudly powered by E2E Networks