Writing data to an AWS data lake and retrieving it to populate an AWS RDS MS SQL database involves several AWS services and a sequence of steps for data transfer and transformation. This process leverages AWS S3 for the data lake storage, AWS Glue for ETL operations, and AWS Lambda for orchestration. Here’s a detailed […]
Graph Database Use Cases
One of the primary advantages of using a graph database is the ability to present the relationships that exist between datasets and files. Much of the data is connected, and graph database use cases are increasingly helping to find and explore these relationships and develop new conclusions. Additionally, graph databases are designed for quick data […]
Learning from Complex Data Modeling Practices
Click to learn more about author Thomas Frisendal. Now is a good point in time to look at best practices in database design for SQL databases. Are there things that could have been easier to do if the SQL designers had had absolute foresight? Of course, the answer is yes. But what is most important […]
Connecting SQL and NoSQL into One Platform
Merging the comfortable familiarity and efficiency of SQL with the flexibility and scalability of a non-relational systems is no easy task. CrateDB, offered by Crate.io, is a “distributed SQL database that is built on top of a NoSQL foundation.” It allows users who are comfortable using and SQL database to save and query machine data, […]
Artificial Intelligence Takes on Large-Scale Database Management
Artificial Intelligence (AI) is having a clear impact on databases. Among the major players, Microsoft is applying AI to continuously monitor Azure SQL database workload patterns and apply automatic tuning when it recognizes opportunities to improve the database performance, for example. And Oracle has unveiled the Oracle Autonomous Database Cloud, which uses Machine Learning to […]
Ways to Optimize your SQL Database
Click to learn more about author Chirag Thumar. Structured Query Language or SQL is considered the standard language for database management systems used to correspond with a database, either to update on or retrieve data from a database. The SQL is very simple to run and user-efficient, as the commands have a simple syntax. But then, the efficiency of the SQL […]
Case Study: CauseSquare and NuoDB’s Elastic SQL Database Partner for Non-Profit Generosity
CauseSquare started in 2015, when co-founder and CTO, Walid Darwish and four of his friends, all developers, were volunteering their time with non-profit organizations and discovered that, “This sector, in terms of technology, still has a long way to go.” They also suspected that these organizations were heading for trouble in the long term. Their […]
Surrogate Keys: Paving the Way for Graph / NoSQL Data Models
Click to learn more about video blogger Thomas Frisendal. Since the mid-seventies many SQL-databases have been modeled using the concept of surrogate keys: Non-information bearing primary keys Used for join purposes (inter-table relationships) System generated (integer) values Not to be shown to end-users The advantage of using surrogate keys is guaranteed persistence, even across changes in […]
Infographic: Digital Transformation Efforts Hinge on the Database Finds NuoDB Survey
by Angela Guess A new press release reports, “75% of business product owners consider business agility to be the number one driver for strategic technology initiatives and 92% believe the database has a pivotal role to play in supporting such modernization efforts according to a new survey from NuoDB, the elastic SQL database for cloud […]
CrateDB SQL Database Puts IoT and Machine Data to Work
by Angela Guess A new press release reports, “Crate.io today announced general availability of CrateDB 1.0, an open source SQL database that enables real-time analytics for machine data applications. CrateDB makes machine data applications that were previously only possible using NoSQL solutions available to mainstream SQL developers. The company also announced today that it has […]