In this article, we will inform you about the database which is one of the most frequently used platforms on the web and which is a must for the web sites to be easily manageable.
Database (Database): text-based websites that can be stored in text made addressing all types bilgin Un and desired structures can be used when bilgin Un in this address. Since the stored information is stored in the addresses you specify and in the shapes that you specify, you can display anywhere on your site the way you want.
Database Storage Method
Hosting – Database systems in server technologies come as a distinct feature. The area where normal files and codes are stored and the areas in which the information clusters or tables are stored in the database are generally in different positions. This process;
Think of it as C and D drives in your computer.
How your operating system and other files are located in different folders, databases are stored on different drives, different hard disks or even on different servers. Thanks to this method, both the information is more easily protected and the two different systems are clearly separated.
Information clusters stored in servers can be stored in billions or even TB, PB (TeraByte, PetaByte) sizes according to server capacities. Storing such large text information with normal files (word, excel, notepad) will take up incredible chaos and incredible dimensions.
Advantages of Database Technology
Speed: The information you store, very short code that is specifically addressed and specially grouped (php, asp, perl) with thousands or even millions of lines of information is your ability to loop processing. Instead of 1000 different files to be created for a 1000 page web site, only one page is created here, and the desired page can be displayed as desired.
Grouping: Database technology you can actually thought to as a system of statements. If you consider a table structure with row and column numbers, you can use row and column numbers as addresses. Below is an example table.
Let’s show some operations that can be done with the table above;
The codes in the explanations below do not belong to any programming language. It is a term written for users to learn the logic of work.
1) Data Selection: This process can take through the rows and columns you want the information in the database. For example, if B2 will choose the information at;
The output of the code will remove the “Server” word.
2) Cluster Selection: All information on this process with a certain range of the database will be brought to us. For example, we only wanted to retrieve information in group B;
Code output – Your response will be “Storage, Server, Server”.
3) Sequential Selection: The information in the specified row or column with this transaction, from small to large – small to large, in alphabetical order, sorted and can be brought against us by the letters size. For example, if you want to select the information in section 2 in a straight-alphabetical order;
Alphabetical Order Selection 2
4) Address Keyword Selection: This process can take with the address information in search of a word or phrase that you want in the database. For example, if you wanted to search for and print out the Server word in the database;
The code output will appear as B2.
5.) Adding, Deleting and Editing Information: If you want to add new information to your database or delete existing information or modify existing information, there are special codes to use for this. Today, there are codes that specifically deal with programming languages such as php, asp, perl, java and database software. With these codes, we can perform the operations we want on the database. For example, the information on the table C3 above was intended to be deleted;
C3 Delete Selection Process
Or all information in group C wanted to be deleted;
C Delete Selection Process
What kind of action would we follow if we wanted to add new information. Here you will enter the address where the required information should be inserted and enter the information. For example, if you want to create a new row that does not exist in the table and add “Bilge” to column 1 in this row;
Create Data D1 Sage
Finally, we wanted to change an existing knowledge. For example, if we wanted to change the name “Server” at B3 to “New Server”;
Edit Data Selection Process B3 New Server
The information in bold type in these examples is data base clients and the information written in clear color is the variables entered by the users. Platform commands and uses technical details are explained in the section.
Time Saving: this allows us a great advantage of the time while achieving incredible results when we use the database systems with short transactions codes on web pages that are dynamically designed. For example, while it may take hours or even days to design a 1000-page website as HTML, you can design a site with a PHP engine with the same interface in a few hours.
Backup Advantage: Normally designed sites that you back up all pages prepared to make the backup process, you will have to take a backup of the database is important in database technology. The total number of backup files will be extremely low because the database backup is usually made up of a single file.
Size and Capacity Advantage: Again, rather than static pages designed in HTML pages dynamically prepared and extremely little space in a container, according to a database server prune normal static system offers huge advantages.
Different database types are available according to usage types and storage formats.
Relational Databases: The most widely used database type in the world. As we have told you so far, with these databases, which have two different interfaces as addressing and information, we can reach the desired address from the desired address and perform the desired operation. MySQL, MSSQL, Oracle, etc. all of the most used databases, such as Relational Database relational database system is used.
Fixed Databases: These are the solutions used to manipulate and store small-sized data. Each line contains a single information cell. Access to the lines is very fast. Information is accessed very quickly and very fast processing is done, but as we said at first, there are solutions that can be a solution for small size systems.
Hierarchical (Folding) Databases: In this database type, the information is stored as folder-subfolder – 2.3 .. level subfolder. That is, it is done by category – subcategory method. The biggest disadvantage of these systems is that they occupy large areas and the operating speed is slower than other methods. There are many well known types such as IMS, but I have to say that the usage areas are limited.
What are Database Management Systems?
We mentioned it briefly before. Dynamic engines such as Php, ASP, and Java used in computer programs or servers have all developed different methods and interfaces to deal with databases, ie programming languages. That is called a database management system for this interface.
A dynamic code running on the hosting database is located on the remote subnet; Delete, add, sort, edit, modify, etc. can do all the features. Of course, for this to work, there must be a connection between the database and the code directory and the necessary permissions must be provided.
What is meant here is; They use special techniques to protect the information in the databases. Of these, perhaps the most important authorization technology. While multiple people can access the same database, only one or some users, depending on their permissions, have the ability to correct, delete, or reach the full contents of the database. This process is called authorization and is one of the most powerful features of the management system. Article on this subject in Hosting Guide can be accessed using the search technology.
Frequently Asked Questions and Answers about the Database
Question: Which is the most used database?
Answer: The world on the most widely used database, which is distributed free of charge and is supported by Oracle to MySQL database. At the moment there is version MySQL Cluster 7.2, which allows more than 1 billion queries in 5.6 version or minute on the market. Both versions are free and open source.
Q: What is the difference between Paid and Free Databases?
A: At the height island easily compete with MySQL capacity and power as a closed toll system, which distributed database and database-free. There is no missing feature. This is the most commonly used and hosted server in the world.
Q: How to store database information?
C: The information in your database is stored with sequential characters technology. Discrimination is made using regular expressions. In other words, addressing and information storage are performed according to the prefix and last characters. With sequential storage technology, transactions will be faster and require less storage space, since the data will take up less space.
Q: A sample MySQL home page How is it possible?
A: The photo below looks at a sample database table structure and interface.
Q: What are the basic queries used in the MySQL System?
A: We will explain the details of the script later. Briefly, basic operations such as ORDER, SELECT, DELETE, INSERT, UPDATE, DUMP, and CREATE are performed.
Q: What is the simplest meaning of a database?
C: In the simplest terms, text format information content that is a separate field in the normal server can be done very easily stored and treated. It has a tabled structure.
Q: When setting up a new Site Which interfaces require Database technolo- gy?
A: For a time, from blogs, shopping sites, article sites, discount sites, number of monitoring sites, all systems that require management interface as well as a 99% chance music sites use the database. We recommend that you do not use the system which does not use the database anyway. The source codes are like WordPress, Magento, Oscommerce, PhpBB, vBulletin, IPS Board, Joomla.
Subject description is in this way with general details. If there are dots or problems you do not understand, you can ask your questions and share your opinions in the section below.0