i want to start a Open Source Relational Database System like MS SQL Server & MYSQL. Dont know where to start?
i want to start a open source relational database system. can someonen tell me where from i should start? any Book or URL refernce link for that topic ? which programming language i should use? shoudl i go for File Handling?
Public Comments
- For Linux users out there, they'd probably suggest MySQL, however I'm a big fan of MS SQL Server. They're both based on the SQL-92 standard with a bunch of additional features added. Transact SQL is a reasonably easy instruction language to learn and with the introduction of the Management Studio Interface, 2008 Express Edition of SQL Server is easy to install and easy to play with (since for the most part, that's the best way to learn Software). As far as getting to grips with the interface and SQL, Here's a few great resources, which i use : http://www.w3schools.com : Free site that walks you though the basics of the SQL query Language. http://www.vtc.com : Ok so this is a pay site, its $30 a month however has a huge amount of instructional videos to offer. This is the best IT training site I've ever signed up to. http://www.microsoft.com/express/sql/default.aspx : The website of SQL Express 2008. http://www.microsoft.com/Sqlserver/2005/en/us/demos.aspx#express : A selection of free video tutorials (13 lessons in total) Books Online is also a great learning resource... This should get you going...Good Luck
- You're actually asking how to make your *own* DBMS, not how to use others, right? Start with finding information on ways to store data efficiently. Most DBMSes use binary files to store data, and utilize "master tables" for DB info, table info, indexes... From there, it's on to access rights, user assignments, TCP/IP binding, named pipes, setting T-SQL to work... I would say: start by visiting the Developer's Zone on the MySQL site; MySQL is Open Source, so there's your best chance of finding working, real life examples on how to do things. http://dev.mysql.com/
- Good luck with that, it will be a massive job. Maybe you would be better off spending your time making something else that 'adds value' to an existing RDMS rather than being yet another RDBMS, eg. an cross database object relational mapper tool. (although there are tonnes of those too) Anyway to answer your question, I suppose the best place to look would be at all the other open source RDBMS's themselves, I used Firebird a few years back because of its embedded mode. Programming language would be whatever you are comfortable in using.
- Start with SQL: http://www.sql-ex.ru/help/
Powered by Yahoo! Answers