Category: Datawarehousing

Feed: MemSQL Blog. Author: Floyd Smith. MemSQL CEO Nikita Shamgunov was featured recently on the Data Engineering Podcast with host Tobias Macey. Tobias drew out Nikita on MemSQL’s origins, our exciting present, and where we’re going in the future. We share a few highlights here, but we also urge you to listen to the full episode. The podcast covered a wide variety of topics. In this blog post, we’ll highlight Nikita’s comments on MemSQL’s origins; setting up and running the MemSQL database; typical use cases; and the future of MemSQL. How MemSQL Started Nikita grew up and was educated in ... Read More

Feed: Actian. Author: Pradeep Bhanot. How quickly does your business environment changes? Are your leaders using outdated information, and do they know it? Do you find your data is slowing your decision-making processes and preventing you from being truly agile? Imagine what you could do if you were to harness the power of real-time data.Modern businesses operate in a constantly changing, intensely complex and data-rich environment. The term “dynamic” doesn’t come close to expressing how fast things are changing. Business environments are fluid – as soon as one thing moves, everything else shifts to adapt to the change. Just because ... Read More

Feed: Actian. Author: Nidhi Rai. People, products, processes and systems may come and go, but, regardless, of the structural components of your business, data is the one thing that brings all the pieces together, so you can perform as a cohesive unit.There is no question modern businesses are evolving quickly. Market opportunities are short-lived, technology advancements are happening at a startling pace and customer preferences are constantly shifting –requiring companies to become more agile in how they identify and respond to both opportunities and threats. Business strategies, supply-chain relationships, organizational structures and business processes must all be nimble to adapt ... Read More

Feed: Actian. Author: Pradeep Bhanot. The previous blogs in this series discussed the top 5 pitfalls of traditional data warehouses and defined the Operational Data Warehouse (ODW) as a potential solution.  Below is a list of my Top 10 desirable benefits of an effective ODW:Current: Having the data being continuously updated by micro batches or streamed singleton updates throughout the day provides the most current information for analytics-based decision making. Fast: Changes to an ODW data need to be made with the lowest performance penalty. Columnar data blocks that maintain their min-max value metadata eliminate the overhead of creating indexes ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. You can take advantage of a free download of key chapters from the exciting e-book, Designing Data-Intensive Applications. The chapters included in the free download cover two areas of vital concern to most MemSQL users, and indeed most developers and architects: transactions and streaming data. Designing Data-Intensive Applications, as a complete book, is more than 500 pages long. It takes as its premise that data is at the center of many of the challenges in system design today. (This is not a premise that is a surprise to us at MemSQL.) Designing Data-Intensive Applications ... Read More

Feed: MemSQL Blog. Author: Mike Boyarski. AWS re:Invent, which ended yesterday, was a very busy and energetic trade show, with an estimated 50,000-plus people in attendance. There were a few highlights and some new news that I can share from spending the week at the show. AWS spent a lot of time on AI and machine learning. The main focus was on tooling for delivering advanced analytics easily. While most of the tooling is software, Amazon also announced hardware: a new processor, Inferentia, that is promised to run AI applications with high performance and at low cost. This follows a ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. In this webinar, Eric Hanson, Principal Product Manager at MemSQL, describes the key features of MemSQL 6.7, which is focused on usability, compatibility, and (as with every release) performance. View the webinar now, download the slides, or read all about it below. Highlights of MemSQL 6.7 include the new, and very popular free tier for MemSQL, which ZDNet describes as having “full functionality to support real-world use cases”. Also included in MemSQL 6.7 are improved ease of use, faster queries, and new tools for monitoring and monitoring MemSQL. The new release also includes an ... Read More

Feed: Cloud Data Integration Software | Matillion. Author: Guest Author; Editor note: Today’s blog post is brought to you by Lana Naumova at Rock Your Data, a fast-growing consulting and technology innovation firm focus on cloud analytics solutions. ‘Best Practices for Matillion ETL and Tableau‘ was originally published November 23, 2018 by Rock Your Data. IntroductionNowadays, analytics is a strong asset of any organization. It drives business insights and adds value to the business. As a result, organizations should deploy analytics solutions for collecting, transforming and storing data. They are choosing powerful and reliable tools in order to deliver actionable insights ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. Scaling distributed systems is hard. Scaling a distributed database is really hard. Databases are particularly hard to scale because there are so many different aspects you have to consider. For example, which dimension is growing, and how fast, will dictate what resources you need to increase in order to handle the workload and maintain your service level agreements (SLAs). Some problems require more CPU, some more RAM, and some more storage. Many times, you need a combination. Knowing how much you need up front is tough to determine. In addition, requirements change over time ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. Epigen Technology depends heavily on MemSQL as part of its core toolkit. “Without MemSQL, I can’t do what I do,” says Terry Rice, founder of Epigen. Visit MemSQL at AWS re:Invent booth #1905 in Las Vegas, November 27-30. Epigen Technology uses software to innovate in many fast-changing areas of technology, including cybersecurity, analytics, machine learning, artificial intelligence (AI), and the emerging area of cognitive computing. Now, Epigen has developed a framework for facial recognition in the cloud that combines AWS S3, MemSQL, machine learning, AI, and visualization. Terry Rice, founder of Epigen, is a ... Read More