i would like to create a database like oracle,my sql?

Question

hi this is mohan
i am doing my3rd year B-tech in IT stream
i would like to create a new database like oracle,mysql
can any one help me in explain what languages to be used to create a database

Answer 1

First you install DB software, like mysql or oracle. Go with mysql, as it is much easier to install and easier in general easier to use for most. Now you will use the SQL language to create a database and create tables within the DB. For more information on SQL see reference [1] below



1. Connect to your sql instance using the provided client. For mysql this will be something like '/usr/bin/mysql' or just 'mysql'.



2. Run the create database command. Example: "CREATE DATABASE baseball;".



3. Create tables within your database. Example:

CREATE TABLE baseball.team

(id int,

name char(50),

city char(50));

Answer 2

Guess it depends on your application. If the application is only run on the mobile device (no web component) then a full database is overkill for storing the scores. You wouldn't want a full database running on the mobile client. Now if you are making a web based application, then your server could certainly use a database (SQL Server if you have the appropriate license for an Internet deployment). For the text file to track the scores, depends again on how your game model is setup. If you are keeping say the top 10 scores, your file could simply be a comma delimited file with 10 lines that you update. ,, ,, ... ... ,, You would read the values when you plan to display the high scores and/or after a game completes to see if the current game beats a high score. If the current score beats one, insert at the appropriate location in the array holding the read in values and have a chunk of code that simply outputs the new high score file. Alternatively to a text file, consider a simple XML file (not sure if the phone SDKs tend to include a parser or not). ** Edit ** @Semper VI - I wouldn't be surprised if MySQL ran on Android. Probably not an ideal setup, but I'm sure someone with a bit of free time and some curiosity has ported it. ** Edit 2 ** I agree that a database in this case isn't necessary. People have done some pretty odd things though, just to prove it could be done. I did forget about HSQLDB, which probably would be better if a database was absolutely needed. I'm wondering what method Android/iPhone/WinPhone use for storing contact information. I know Android syncs up with gmail contacts, but I'm guessing they cache it local to the phone as well.

Answer 3

The language you primarily use is SQL (Structured Query Language), which is at the core of most (if not all) relational databases currently in use today...the basic syntax is identical regardless of which DMBS (database management system) you use (Oracle, SQL Server, MySQL, etc.) Additionally, you will probably also use a scripting language - either one built-in to the DBMS (e.g., PL/SQL for Oracle, T-SQL for SQL Server) or an external one (for example, MySQL doesn't have a built-in scripting language but often is paired externally with PHP.)