This is actually a wide-column store but I didn't explain that term. It is starting to take the place that MySQL once did before Oracle acquired it. PostgreSQLĪ very popular open source relational database, with some document features. People often use this to build log systems, but it also makes a great custom search engine.
So it is both a search database and a document database. This is a document store that is optimized for search applications. That means it normally used just for temporary storage (because it is very fast). RedisĪn open source key-value store often used as a cache. Very popular with many newer software companies. It is commonly used in large fortune 500 companies, especially with people using a.
Microsoft SQL Server is a paid, closed source relational database. It is commonly used in large fortune 500 companies, especially with people using a Java stack. This is a paid, closed source relational database. MariaDB is a fork of MySQL and is generally compatible with the same drivers. Super popular, commonly used with WordPress. This is an open source relational database. You would use this to build a custom search engine for a website or app, typically they are very good at free-form text search on documents. SearchĪ search style database system is specifically optimized for fast search. You know certain people and some of them might know you but there are spiderweb of relationships between people in a given city. Graph databaseĪ graph database stores data as a "graph" which is a concept in computer science that gets complex fast but a good example of a graph is a social network of people in a city. Just like a PO Box at the post office, you take a key and go the wall of boxes and when you use the key on the right box, you can open it and get the "values" out of it. This is much simpler, you have a big list of things and given a key you can use that to look up a value. Think of these where each document is like a totally separate file (like a word doc), and in a given group of files (called a collection) they may or may not be all in the same format and may or may not contain different types of data. So the stuff below - Document Style, Key-Value, Graph Database, these are all NoSQL. any kind of database that is NOT a relational database. NoSQL basically just means any kind of database not using SQL, i.e. Relational databases use a language called Structured Query Language (SQL) to query (interact) with the database.īy the way, the majority of people are using relational databases (even with the rise of NoSQL). Relation Databases are like Excel workbooks - you have workbooks (databases), sheets (tables), rows (still called rows, or records), and columns (still called columns but they have strict datatypes). No, seriously! I think I can write a one or two analogy of how these types of databases work. I'm going to do these as briefly as I can.
So this candidate would probably be able to make that transition just fine. Well, these are not the same thing but you would be helped to understand that they are both the same class of database and have very similar styles of SQL. You might see MySQL on a job description but see that a candidate has done PostgreSQL. I'll give an example before we go any farther. But it is very useful to understand the general purpose of each of the top 10 databases and what categories they fall into. You probably don't care about all the gritty details of these database systems, nor should you.
0 kommentar(er)
