▼ Scroll to Site ▼

Newsletters




Data Warehousing

Hardware and software that support the efficient consolidation of data from multiple sources in a Data Warehouse for Reporting and Analytics include ETL (Extract, Transform, Load), EAI (Enterprise Application Integration), CDC (Change Data Capture), Data Replication, Data Deduplication, Compression, Big Data technologies such as Hadoop and MapReduce, and Data Warehouse Appliances.



Data Warehousing Articles

Although adopting advanced analytics is on the radar for most organizations these days, it is important to understand some of the problems that can occur as you implement analytics projects. Perhaps the most important obstacle to overcome is ensuring buy-in from your organization's leaders.

Posted September 16, 2019

Each year, Big Data Quarterly presents the "Big Data 50," a list of forward-thinking companies that are working to expand what's possible in terms of capturing, storing, protecting, and deriving value from data.

Posted September 11, 2019

Quest Software's Jason Hall explains the need to manage multiple platforms simultaneously has complicated the jobs of database administrators in this clip from his presentation at Data Summit 2019.

Posted September 10, 2019

In order to protect your organization, it is critical to watch over the elements that have been built, keep processes running, and be on top of change. Spend the time and resources necessary to properly maintain the solutions for which you are responsible. The amount spent in such endeavors will be less time than that spent trying to play catch up on too many changes after bad things have resulted.

Posted September 03, 2019

The big cloud vendors tout many reasons for running IT infrastructure in the cloud. A very prominent benefit is "accelerated innovation and delivery." That's a powerful selling point because every IT manager I have ever known wants to deliver better results, faster, and at lower cost. However, it seems that the less IT managers know about doing actual hands-on IT work, the more demanding they are.

Posted September 03, 2019

Oracle has identified a need for "augmented" analytics, leveraging machine learning and AI throughout the analytics process to help drive up the impact and value of data, and enable knowledge workers to uncover more insights. Recently, Bruno Aziza, group VP, Oracle Analytics, described this new phase in analytics, the role that cloud plays in making it possible, and what the capabilities will enable for customers.

Posted September 03, 2019

We've reached the point where hybrid cloud arrangements have become commonplace in enterprises, and with this trend come implications for databases and data management. The rise of both hybrid and multi-cloud platforms means data needs to be managed in new ways, industry experts point out. And, there are lingering questions about which data should go into the cloud, and which should stay on-premise.

Posted August 29, 2019

Each year, Database Trends and Applications presents the Readers' Choice Awards, providing a unique opportunity to recognize companies whose products are selected by experts whose opinions carry more weight than any others—you, the readers. Here we present the top three vote-getters in each category. Congratulations to all and thanks to everyone who submitted nominations and voted!

Posted August 29, 2019

In previous articles, we looked at creating and managing Oracle Cloud Infrastructure (OCI) database and compute instances through the web UI. The UI is ideal for a new user and occasional management of a cloud environment. When a cloud administrator is managing and automating dozens or hundreds of instances, manually clicking through the UI becomes untenable. Oracle supports and maintains a number of developer tools to solve this problem.

Posted August 21, 2019

Athena IT Solutions managing partner Richard Sherman provides a whirlwind tour of today's predominant database technologies in this clip from his presentation at Data Summit 2019.

Posted August 20, 2019

Franz Inc., an early adopter of Artificial Intelligence (AI) and provider of Semantic Graph Database technology for Knowledge Graph Solutions, is now supporting Shapes Constraint Language (SHACL), a World Wide Web Consortium (W3C) specification for validating graph-based data against a set of conditions.

Posted August 15, 2019

Social media, the Internet of Things, demands for mobile access, and real-time insights are just some of the factors that have increased the pressure on organizations to change how data is managed. And as a result there have never been so many data management choices to deal with it all.

Posted August 14, 2019

The world's largest and most innovative businesses are turning to enterprise open source databases for mission-critical applications, with the most popular open source relational databases being MariaDB, MySQL, and Postgres.

Posted August 12, 2019

An effective approach to processing and transforming large datasets is likely comprised of multiple steps. The large data will likely be split apart into several smaller sets, maybe even in a couple of differing fashions with a common and understandable theme. But there should not be too many split-apart variants; rather, as with the three bears, it should be just the right number of smaller datasets. And then, similar to solving a Rubik's Cube, a twist or two at the very end brings all the new and old datapoints together in a complete and organized fashion.

Posted August 07, 2019

Here is a list of common wait types and techniques that every DBA (or wannabe DBA) should know. While there are many more wait types than listed here, understanding these will give you a leg up when it comes to optimizing and tuning your SQL Server database performance.

Posted August 07, 2019

Richard Sherman, Athena IT Solutions managing partner, discusses data's three states—integrated, as-is, and curated/integrated—and what's required for analysis in each state in this clip from his presentation at Data Summit 2019.

Posted July 30, 2019

The need for faster and smarter data integration capabilities is growing. The proliferation of data sources, types, and stores is increasing the challenge of combining data into meaningful, valuable information. At the same time, to deliver business value, people need information they can trust to act on, so balancing governance is absolutely critical nowadays, especially with new regulations.

Posted July 29, 2019

Data Summit 2019 in Boston drew industry experts with deep knowledge spanning all areas of enterprise IT, including AI and machine learning, analytics, cloud, data warehousing, and software licensing who presented 3 days of thought-provoking sessions, keynotes, panel discussions, and hands-on workshops. Here are some key takeaways from the Data Summit 2019.

Posted July 25, 2019

While change has always been a part of the database credo, the growing emphasis on data-driven decision making in today's economy has resulted in a dizzying plethora of technologies and methodologies entering the market. The number and scope of game-changing technologies are too numerous to mention, and one thing is certain: Database management will never be the same. We have identified some of the most promising technology initiatives, based on discussions with and input from data experts from across the industry spectrum, gathering their views on the key technologies—well-known or under the radar—that are worth watching.

Posted July 25, 2019

Data analytics is no longer the luxury of organizations with large budgets that can accommodate roving teams of analysts and data scientists. Every organization, no matter the size or industry, deserves a data analytics capability. Thanks to a convergence of technology and market forces, that's exactly what's happening.

Posted July 17, 2019

IBM has launched a data prep solution designed to help clients improve their DataOps processes so they can have data ready for AI more quickly and efficiently. Jointly developed with data prep software provider Trifacta, the new InfoSphere solution is engineered to work in conjunction with clients' existing data environments, including data lakes.

Posted July 08, 2019

Oracle has introduced the new Autonomous Database Dedicated service to provide customers with more control for their most mission-critical workloads. "Our Autonomous Database Dedicated service eliminates the concerns enterprise customers previously had about security, isolation, and operational policies when moving to cloud," said Juan Loaiza, executive vice president, Mission-Critical Database Technologies, Oracle.

Posted July 03, 2019

source{d}, a data platform for the software development life cycle (SDLC), is releasing a new Enterprise Edition with built-in visualization, management capabilities, and advanced analytic functions. source{d} enables enterprises to aggregate all SDLC data sources into one data lake where they can easily extract, load and transform source code, version control data, project tracking data, build systems data, configuration files and more.

Posted July 02, 2019

EnterpriseDB has been acquired by Great Hill Partners, a private equity firm. Financial terms of the private transaction were not disclosed. "This acquisition comes at a time when the Postgres market is exploding," said Ed Boyajian, president and CEO of EnterpriseDB. Michael Stonebraker, a pioneer in database technology and original architect of what is now Postgres, has been named technical advisor; and database expert and entrepreneur Andy Palmer has been named to the board of directors.

Posted July 01, 2019

Managing Oracle databases in the cloud may require some adjustments to the way you are used to doing things, so there is likely a learning curve when adding the additional tasks discussed in this article. In the end, database services in OCI are engineered to save time and avoid problems, among other things, so it is definitely worth the investment.

Posted June 27, 2019

IT executives and their business counterparts understand the importance of a strong data strategy and its value to their businesses, and most are starting to get the key pieces in place to drive transformation through next-generation technologies and processes. One in four enterprises now regards real-time data as critical to their ongoing operations—and another one in four is actively preparing to introduce real-time data capabilities into their infrastructures, according to a new Unisphere Research survey.

Posted June 26, 2019

Scale Computing, a provider of edge computing solutions, announced that the KVM-based hypervisor in the HC3 product family is now fully supported by Parallels Remote Application Server17 (Parallels RAS). When combined with Parallels RAS, Scale Computing HC3 enables administrators to rapidly provision and manage virtual machines (VM) thin clones centrally from Parallels RAS Console to make VDI solutions faster, more affordable, and easier to use.

Posted June 18, 2019

Time series databases are optimized for collecting, storing, retrieving, and processing time series data. It's critical that businesses use a time series database for time series data and not one of the traditional data stores. DBTA recently held a webinar with Daniella Pontes, product manager, InfluxData, who discussed how Time Series Databases are built with specific workloads and requirements in mind, including the ability to ingest millions of data points per second.

Posted June 17, 2019

AI, machine learning, and predictive analytics are used synonymously by even the most data-intensive organizations, but there are subtle, yet important, differences between them. Machine learning is a type of AI that enables machines to process data and learn on their own, without constant human supervision. Predictive analytics uses collected data to predict future outcomes based on historical data.

Posted June 10, 2019

Microsoft directly hosts a handful of big conferences every year, with the developer-oriented Build conference and infrastructure-oriented Ignite being to two that I pay the most attention to. The Microsoft Build 2019 conference just wrapped up and we have a couple important new announcements for the those of us working with the Microsoft Data Platform.

Posted June 10, 2019

What are the practices and procedures that you have found to be most helpful to automate in administering your databases? Yes, I know that automation has been a standard claim for most DBMS vendors, as well as third-party DBA tool vendors, for many years. But are you really anywhere closer to an "on demand," "lights-out," "24/7" database environment yet?

Posted June 10, 2019

CDC can greatly minimize the amount of data processed; but the cost is that the processes themselves become more complicated and overall storage may be higher. Costs are moved around, the final level of processing becomes focused on the minimal changes, and this minimization is the efficiency to be gained. Moving forward, using the data becomes standardized and ultimately straightforward.

Posted June 10, 2019

DBTA's next Data Summit conference will be held May 19-20, 2020, with pre-conference workshops on Monday, May 18. The conference will return to the Hyatt Regency Boston.

Posted June 06, 2019

Google LLC has entered into an agreement to acquire Looker, a unified platform for business intelligence, data applications, and embedded analytics, in a $2.6 billion all-cash transaction. Upon the close of the acquisition, Looker will join Google Cloud.

Posted June 06, 2019

Trifacta, a leader in data preparation, is releasing a new native integration for Snowflake, the data warehouse built for the cloud. Trifacta's visual and machine learning guided interface empowers data teams to collaboratively explore, clean, structure and enrich data at the scale and agility provided by Snowflake.

Posted June 04, 2019

DataOps is still a relatively new concept, it combines people, processes, and technology to build and enhance data analytics. At Data Summit 2019 Kevin Petrie, Senior Director of Marketing, Attunity, Inc., explored the the five key steps necessary to be successful with DataOps, including the process and cultural shift required during his session, "Five Key Requirements for DataOps Success."

Posted May 30, 2019

Pages
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31

Sponsors