The Lost Art of ETL
Extract, transform and load is a lost art among developers and coders. The process needs to be revitalized for proper database use. … Read more
Tag Archives: Datastore
The Importance of Proper Database Use
Proper use of databases ensures the safety of your data and decreases fragility. It is best to use varying types of databases in conjunction. … Read more
Geospatial Datastores Know Where Your Data Lives
Geospatial datastores are specialized for locating where data lives. It can sub-specialize in different forms of data storage as well. … Read more
Search Appliances Are Not Datastores
Search appliances are not datastores, but are sometimes used as one. Using it this way makes it inefficient and slow, it should be used as a search index. … Read more
Caches and Queue Stores Are Short-Term
Caches and queue stores each have a specific use, but neither are ideal for long-term storage. Caches are highly ephemeral, queue stores are semi-ephemeral. … Read more
Time Series and Flat File Databases
Time series and flat file databases are specialized for specific use. You must stick to that appropriate use or efficiency fails. … Read more
Log Stores Are Specialized Databases
Log stores are meant for one thing: To log events and specific information. Using a log store for anything else renders it inefficient and slow. … Read more
Object-Oriented and Edge Databases
Object-oriented databases work differently than relational DBs. Edge databases are a type of object DB, but IoT advancements make it pertinent. … Read more
SQL vs. NoSQL Databases
SQL databases are relational while NoSQL databases are object-oriented. Both are good at different things, learn what those differences are to optimize use. … Read more
Datastores: An Overview of Common Types
Databases and datastores are not interchangeable terms. Learn definitions for the most common datastores in this first installment of a new series. … Read more