Question

Discuss how you interact with databases in your daily routine. How often do you access your own personal info and stored data, enter your personal information into new databases, browse content in a database etc?

Answer 1

How you interact with databases in your daily routine:

We might not realize it, but databases are everywhere. We dont know very much about them, their effect on our daily lives is extensive. From weather applications to the movies we watch online, databases are responsible for many of the services we use daily.

Here there are few of the more well-known examples of how databases enhance your day-to-day life below. The most popular database server in our industry is, MySQL, is common in virtually every example listed below:

1. Online Television Streaming:

Any online streaming service, such as Hulu or Netflix, uses databases to create a list of TV shows and movies to watch. The database tracks an individual’s show preferences, and provide a list of suggested viewing or to watch. The capability required to analyze such an huge amount of data is done through highly specialized database management technology, such as Cassandra database. In fact, Hulu has recently been depending heavily on Apache Cassandra.

2. Social Gaming:

Gaming done across social networks is extremely data concentrated. Assembling individual player information from around the world and serving it to players on demand requires a high availability database software.

3. Personal Cloud Storage:

If you save your photos or documents to your smartphone or tablet, it is likely your data is stored in the cloud, a large, central storage environment with a small portion or section dedicated just to you. Syncing or coordinating this data across your devices requires powerful databases able to call up your data at a moment’s notice, wherever you are.

4. Sports:

Fan participation in national sports does not just use the ability of the database, it depends upon it. From fantasy football leagues to March Madness brackets, they all depend on vast databases full of player statistics. This involves game performances, injury reports, and more, all calculating the odds of a win on a weekly basis.

5. Finances:

From the stock market to your local bank, databases are generous across the financial world. Tracking the huge amount of information behind the world’s daily transactions requires extremely high powerful databases. This includes financial models that analyzes the data to predict future activity.

7. Social Media:

Every social media platform stores stacks of user information in databases used to recommend friends, businesses, products, and topics to the end user. This cross referencing of data is extremely difficult and uses highly reliable and capable database software. For example like, MySQL is used in Facebook data centers.

Some of the other fields where we use databases in our daily routine are:

• Government organizations
• eCommerce
• Healthcare
• Weather etc

How to store access the content stored in the database:

There are various types of database systems and many different storage schemes or structures. Many relational systems store data rows in pages and then provide various indexes within the page. There are many different schemes for linking pages to the table to which they belong.

Separate structures, based on B-trees are similar algorithms, that may be used to index frequently accessed columns, especially primary and foreign keys. Hashing technique may also be used for this purpose. Page data may be compressed to reduce storage needs but also to reduce the number of pages that have to be fetched to resolve or set on a query. Fast searching of a text column may be executed using an inverted index.

One of the important concepts of a relational database system is that the query language is independent of any particular implementation of primary storage and navigation structures. This allows the database itself to adjust to queries by either automatically building the structures it needs for query performance, or to provide statistics and recommendations to the database administrator to add such structures.

Data can be retrieved from the database in many ways like, once you’ve created the database table, you can begin storing binary data there using PHP. All that is required by the PHP script is a standard INSERT query, using the binary data for the file column value. To grab or hold the data in the file to be used in the query, you must call the PHP file_get_contents() method, which reads a file into a string.

We can also access the data by using SQL queries then by giving SQL commands based on our requirement of the data we want to access.

How to enter personal information into the new database:

1.Create a blank database

2. Add a table

3. Copy data from another source into an Access table

4. Import, append, or link to data from another source

How the contents are browsed in the database:

• open terminal
• type: mysql -u root -p
• provide password when prompted
• run: show databases [check if there is multiple database and identify which one you want to work with]
• run: use your_database_name
• run: show tables;
• now run or check table entries however you like to check like describe table-name , select queries or anyway you choose.