How does a database work?

Asked By osman gany 0 points N/A Posted on - 01/21/2013

I am a starter in MySQL Database. I find it very usual and most databases I tried works just the same like MySQL database but I want to clearly know how does really a database works?

• Status: Open
• Question Views: 863
• Answer Count: 3
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: DB Reporting Tools

Best Answer by Steele Ney

Go To Solution

Answered By Luker Malcom 5 points N/A #169878

How does a database work?

In programming world, database is an important factor in creating any kind of software or website. SQL (Structured Query Language) is a programming language that is used to query the stored information in database. When you type

Select * from table where name=’Harry’

The database will interpret this query and looks for the table that has the data named as “Harry”. To display it, you need to incorporate SQL code with another programming code such as PHP or Java. All the information that you have stored in the database will be simply managed using your system’s virtual memory.

If you want to know other database platform aside from MySQL, you might want to try MSSQL. This is the short version for Microsoft SQL server. Like MySQL, it can store any type of data but unlike it, MSSQL is not for free.

About Luker Malcom

Questions
0

Answers
173

Best Answers
108

• Vote Up 0 Vote Down

• Posted on - 01/22/2013
• Question Category: DB Reporting Tools

Answered By Abbot Nimrod 0 points N/A #169880

How does a database work?

Hi there,

now a days relational databases are prevalent. By relational we mean, these databases keep their data in the forms of tables that have rows and columns of data and a key field which is used to identify the specific rows or columns. MySql is a relational database. In order to get data out from the database, we need to give specific instructions which comprise a specific language called SQL or structured query language. An example is “Select * from table_A where age > 25” this query will look in table table_A and bring out all the rows where age filed value is greater than 25. Similarly there is a whole plethora of statements that are used to manipulate data in a database. Some very common industry databases are Oracle, MS SQL Server, Sybase, DB2 etc. 

About Abbot Nimrod

Questions
1

Answers
30

Best Answers
23

• Vote Up 0 Vote Down

• Posted on - 01/23/2013
• Question Category: DB Reporting Tools

Best Answer

Best Answer

Answered By Steele Ney 0 points N/A #169879

How does a database work?

Additional Information: If you are running DOS program in XP, It will probably works in 32-bit version of windows 7. Caution: Do not run DOS program in a 64-bit version of windows 7. It will never happen to work on 64-bit version of windows 7. To create Virtual (VM) inside Windows you will need to have Software. Many IT Specialists, have tried VMware Player because it is possible to run a lot different OS inside Windows. Whereas, if you would like to run DOS programs try DOSBox, a free program that will give you DOS VM. About MySQL, One thing you need to know is the independent attribute. MySQL is very independent in a way that it will survive without having an extra attention to Oracle does, MySQL won’t give it a dumb. The MySQL inventor Michael “Monty”Widenius, have created offshoots of the database’s code base. This will include the forking trend that even Oracle ending the new MySQL features to the open-source community. This won’t be a problem for customer’s because of their wide options. Furthermore, MySQL is the best website support for Linux, Apache, MySQL and PHP.

About Steele Ney

Questions
3

Answers
122

Best Answers
31

• Vote Up 0 Vote Down

• Posted on - 01/24/2013
• Question Category: DB Reporting Tools