Features

Features

• Self-service data preparation tools tap into machine learning

  Machine learning is a hot technology in analytics applications -- and it also underpins new data preparation tools that let business analysts and users integrate data for analysis.  Continue Reading

• Make the right choice between Hadoop clusters and a data warehouse

  Consultant David Loshin outlines a process for comparing specific criteria and variables to help guide decisions on deploying Hadoop or using an enterprise data warehouse.  Continue Reading

• InfiniteGraph enterprise distributed graph database overview

  InfiniteGraph can be used to build data-intensive, graph-based applications to help organizations gain insights from large amounts of information.  Continue Reading

• Big data in financial services begets chief data officer

  With big data in financial services requiring various skills, a chief data officer may be ready to step up. A Capgemini expert discusses this evolving role.  Continue Reading

• IBM DB2 relational DBMS overview

  IBM DB2 relational DBMS delivers high availability, strong performance and mission-critical support across multiple platforms.  Continue Reading

• Apache Cassandra NoSQL DBMS overview

  Apache Cassandra was designed to handle very large amounts of data and deliver high availability without a single point of failure.  Continue Reading

• Time to take your enterprise data governance plan up a notch

  Data governance is becoming more important as companies increasingly look to be more data-driven. Make sure your organization is ready to take a strategic approach to governing its data.  Continue Reading

• Amazon SimpleDB overview

  Amazon SimpleDB is a hosted database as a service that enables developers to store and query structured data items via Web services requests.  Continue Reading

• Aerospike NoSQL DBMS overview

  The Aerospike open source, in-memory NoSQL DBMS is a key-value data store that enables applications to deliver high performance and rapid data access.  Continue Reading

• Which in-memory DBMS best fits your company's needs?

  Database expert Craig S. Mullins examines some top in-memory DBMS software offerings to help you determine which is the best fit for your organization.  Continue Reading

• Oracle Database 12c relational database management system overview

  Oracle Database 12c delivers strong performance for mission-critical workloads, with features and functionality for diverse processing needs and requirements.  Continue Reading

• How to determine which NoSQL DBMS best fits your needs

  Database expert Craig S. Mullins examines top NoSQL DBMS software to help you determine which product aligns with the requirements of your organization.  Continue Reading

• Database schemas still needed, despite Hadoop and NoSQL pretensions

  Hadoop and NoSQL haven't eliminated the need for database schemas, according to one expert. Instead, consider them flexible schemas waiting to be integrated.  Continue Reading

• When building Hadoop data lakes, don't plunge in without a plan

  A data lake may seem like a clear choice -- deposit all your data in a Hadoop repository for analytics uses -- but navigating those IT waters isn't so simple, consultant Wayne Eckerson says.  Continue Reading

• SQL Server 2016, Azure SQL Data Warehouse lead Microsoft cloud hopes

  Microsoft is working on yet another computing transformation, and its SQL Server and Azure SQL products are central thereto. But the company faces stiff competition in the cloud from Amazon.  Continue Reading

• Databricks Cloud platform aims to open up Spark data processing

  Databricks Cloud is a big data platform that's based on the Apache Spark processing engine, with added features designed to simplify big data management and analytics for users.  Continue Reading

• Which relational DBMS is best for your company?

  Database expert Craig S. Mullins examines the top relational database management system software to determine which best fits your organization.  Continue Reading

• How to determine if an in-memory DBMS is right for your company

  Database expert Craig S. Mullins examines the pros and cons of the in-memory database management system, and the criteria you should consider during the request-for-proposal and evaluation period.  Continue Reading

• Can cognitive computing help users combine big data and analytics?

  In a Q&A, consultant and author Judith Hurwitz discusses the use of cognitive computing systems in big data and analytics applications The word: It's early, but there's a lot of potential.  Continue Reading

• System for diners orders up Azure big data platform in the cloud

  Ziosk is joining the tabletop tablet computers it places in restaurants with Microsoft's Azure cloud platform and big data tools to try to improve the business of casual dining through machine learning applications.  Continue Reading

• Distributed data management architecture trumps EDW on agility

  As data sources continue to increase, organizations are reconsidering enterprise data warehouses for a more flexible approach to data management.  Continue Reading

• Cloud data integration tasks require new IT approaches, tools

  In a Q&A, consultant Rick Sherman offers tips on integrating cloud and on-premises applications, and discusses potential barriers and the technologies that can help get the job done.  Continue Reading

• Key considerations for determining if a NoSQL DBMS meets your IT needs

  NoSQL represents the fastest-growing type of DBMS being adopted today. Is it right for you?  Continue Reading

• CDO jobs on the rise to help wring more business value out of data

  Chief data officers are becoming more prevalent in companies, and more necessary, consultant John Ladley said in a webinar -- so much so that he thinks 2015 could be 'the year of the CDO.'  Continue Reading

• Key criteria for deciding if a relational DBMS meets your IT needs

  For many organizations, a relational database management system will get the job done; others need to keep looking to fulfill their needs.  Continue Reading

• Western Union connects the dots to enable enterprise Hadoop use

  Building and running enterprise Hadoop applications takes more than data crunching. First, Hadoop data must be absorbed into company processes, a Western Union IT manager says.  Continue Reading

• Hadoop data lakes must get more efficient, less 'messy' to oust EDWs

  In a Q&A, Forrester analyst Mike Gualtieri said Hadoop-based data lakes can become an alternative to enterprise data warehouses. But first, faster I/O and better data governance are needed.  Continue Reading

• Dip in Hadoop data lake can be bracing for big data users

  Encouraged by the promise of cost savings and better efficiency, early adopters are wading into Hadoop as a central reservoir for their analytics data.  Continue Reading

• Apache Spark trumps MapReduce in speed, flexibility

  The processing engine’s in-memory computing layer can supposedly run batch-processing programs 100 times faster. Does the vendor hype equal user adoption?  Continue Reading

• Time to tool up on data integration software?

  The market for packaged data integration tools is expected to grow by nearly 10% annually. But a lot of holdout organizations might need convincing to move beyond manual coding.  Continue Reading

• Enterprise data warehouse architecture endures -- and evolves

  The traditional data warehouse doesn't get the hoopla that Hadoop and NoSQL systems do, but it's still a core component of most IT infrastructures. And it's even learning some new tricks.  Continue Reading

• Accenture's Dell'Anno discusses data supply chain

  Data supply chains serve to turn raw data into useful business information, says Accenture's Vincent Dell'Anno.  Continue Reading

• Data warehouse software not ready for retirement in age of big data

  Hadoop clusters, NoSQL databases and other modern technologies have roles to play in business intelligence and analytics environments. But traditional data warehouses still do, too.  Continue Reading

• DBA skills must evolve, morph to cope with big data technologies

  Big data tools are changing data architectures in many companies. The effect on the skill sets required by database administrators may be moderate, but some new IT tricks are likely to be needed.  Continue Reading

• Mullins: Changing DBA responsibilities highlight profession in flux

  Author Craig Mullins discusses the evolving responsibilities of database administrators due to NoSQL systems and a growing need for mixed database management system environments.  Continue Reading

• Hadoop fuels TrueCar's data-driven business model

  Piles of "messy" data meet inexpensive storage as e-commerce website TrueCar builds a data-driven business with the help of a Hadoop cluster and data analytics tools.  Continue Reading

• For Hadoop architecture, 'a lot of maturity' still needed

  Hadoop has yet to be as widely adopted as consultant Joe Caserta expected -- and maturity issues are a big reason, he says in a Q&A on the much-discussed big data framework.  Continue Reading

• Ten years on, master data management software market comes of age

  It has been 10 years since the master data management industry emerged. MDM technology is maturing, and project success rates are on the rise -- but there's still a long way to go.  Continue Reading

• Is it too soon for unstructured data governance?

  Data industry veteran Anne Marie Smith discusses pressing issues, including the barriers to unstructured data governance. Part one in a series on data matters.  Continue Reading

• Varied NoSQL technologies need careful weighing and sorting

  The number of NoSQL database options is vast, and distinct product categories occupy separate niches. That makes it imperative to understand what works best for specific applications when evaluating NoSQL software.  Continue Reading

• MongoDB founder on dynamic schemas and caching as a crutch

  The train to NoSQL rode the rails of agility and scalability, according to Dwight Merriman, MongoDB co-founder.  Continue Reading

• Perspective and preparation: Data modeling concepts still vital in business

  In this book excerpt, data modeling instructor Steve Hoberman discusses the importance of using modeling for business success and the variety of implementations for data models.  Continue Reading

• Keep best practices in place for data-intensive cloud apps

  Today's breed of NewSQL database can help master data-intensive cloud applications. But development processes should still adhere to best practices, said one CTO.  Continue Reading

• Conversation with Monash: On horses for courses and parallelism

  Data industry viewer Curt Monash discusses parallelism and more as new databases gain attention. Part 1 in a series.  Continue Reading

• Former shadow IT worker helps bring analytics data into the light

  Ryan Fenner worked in a shadow IT unit at Union Bank for years. Now he's helping lead an IT effort to better manage BI data created in those shadows.  Continue Reading

• Supermarket co-op stocks up on big data platform to help spur sales

  Co-operative Allegiance Retail Services is deploying a cloud-based big data stack to replace a homegrown system that fell short on analytics power.  Continue Reading

• Think Big Analytics' Bodkin: Big data adoption means breaking silos

  Hadoop has the ability ultimately to break down siloed data stores, Ron Bodkin says in a Q&A.  Continue Reading

• NewSQL database sends NoSQL technology packing at logistics exchange

  DropShip Commerce went from SQL to NoSQL to NewSQL software to run its B2B platform, settling on a NuoDB database to help support its business growth.  Continue Reading

• NoSQL databases dent relational software's data processing dominance

  NoSQL software has broken the IT monopoly of relational databases, but it isn't likely to completely break the bonds between users and SQL technology.  Continue Reading

• Chief information architect: A compass for information management

  In a Q&A, author William McKnight discusses the importance of building a robust information architecture -- and having the right person in the lead.  Continue Reading

• Hadoop YARN adds more application threads for big data users

  Hadoop 2's new YARN resource manager ends the distributed processing framework's marriage to MapReduce. And that broadens what Hadoop systems can do.  Continue Reading

• Finding the right big data tools often a multiple-choice question

  Big data applications add a variety of technology options to consider. And for many companies, one big data horse won't be enough to carry the load.  Continue Reading

• Data quality assessment requires business ties -- and a human touch

  In an interview, author and data quality architect Laura Sebastian-Coleman discusses steps organizations should take to improve data quality levels.  Continue Reading

• Identifying data quality issues via data profiling, reasonability

  In a book excerpt, author Laura Sebastian-Coleman explores data profiling, data issue management and using reasonability checks in assessing quality.  Continue Reading

• Dissecting data measurement: Key metrics for assessing data quality

  In a book excerpt, data quality architect Laura Sebastian-Coleman explains data assessment terminology and details a framework for measuring quality.  Continue Reading

• Hadoop 2 FAQ: Upgrade spins new YARN, breaks MapReduce bonds

  Hadoop 2 is a big step forward for the distributed processing framework, now freed from its reliance on MapReduce. Get details on its key features.  Continue Reading

• Integrating data warehouse architecture with big data technology

  This book excerpt discusses considerations for the physical integration of big data technologies into the data warehouse architecture.  Continue Reading

• Ancestry.com teams work together to use Hadoop framework for DNA app

  A CTO sits data scientists and software engineers together to successfully employ the Hadoop framework for a DNA app that finds family tree limbs.  Continue Reading

• In relational database design, don't shortchange requirements stage

  Requirements gathering shouldn't get short shrift in the database rush, says Michael J. Hernandez, author of 'Database Design for Mere Mortals.'  Continue Reading

• Graph database powers Onefinestay's room accommodation platform

  Onefinestay CTO Jackson Hull led a team that used a graph database to help make vacationers feel at home with its online house-booking service.  Continue Reading

• Big data, fast: Avoiding Hadoop performance bottlenecks

  A variety of performance issues can bog down Hadoop clusters. But there are ways to sidestep the pitfalls and keep your big data environment humming.  Continue Reading

• Big data architecture adds integration options -- and tool needs

  Mixing data warehousing and big data technologies creates new opportunities for data integration, but also calls for new types of integration tools.  Continue Reading

• Big data adds new complications for data stewards

  In order to accommodate big data and the needs of data scientists, data stewards will need to adjust to a more short-term view of data stewardship.  Continue Reading

• Big data systems shine light on neglected 'dark data'

  The processing power of Hadoop and other big data tools is making it more feasible for companies to tap into dark data, information that previously was left untouched in IT systems.  Continue Reading

• It takes more than technology to achieve big data success

  Organizations mulling a big data initiative should forget the hype, come up with a solid business case and put the right team together.  Continue Reading

• Gartner describes the building blocks for a strong MDM program

  MDM teams should consider these seven building blocks, outlined by Saul Judah, research director on the information management team at Gartner Inc.  Continue Reading

• Data virtualization technology speeds up decision making at Pfizer

  Data virtualization technology is quickening the pace of drug development at pharmaceutical giant Pfizer.  Continue Reading

• As big data use explodes, Verizon strategist explores the 'data self'

  More data on the Web may spawn the idea of 'a data self,' says Verizon strategist and big data security specialist Wilco van Ginkel.  Continue Reading

• MDM program needs business sense to be successful

  It is essential that project teams engage the support of business executives to ensure the success of a master data management program.  Continue Reading

• Enterprise master data management and big data: A well-matched pair?

  While the relationship between enterprise MDM and big data is uncertain now, analysts predict that they may be more closely linked down the road.  Continue Reading

• Business data quality measures need to reach a higher plane

  Consultant Andy Hayler says survey results show that data quality levels haven't improved in recent years, despite increased efforts by companies.  Continue Reading

• Data warehousing architect helps Pfizer make better business decisions

  Pat Saucier, a data warehousing and information architecture manager at Pfizer Inc., talks about how the relationship between data and business operations has changed during his career.  Continue Reading

• IT as a Service transforming traditional IT departments

  Today, end users can easily sidestep IT to get the app they need. This new competition is prompting IT to take action -- delivering IT as a Service -- to stay relevant.  Continue Reading

• Enterprise data quality efforts in good company with MDM, governance

  Combining data quality initiatives with master data management and data governance programs can help ensure that data remains accurate and consistent.  Continue Reading

• Better data quality process begins with business processes, not tools

  Efforts to improve data quality should start with procedural changes to help avoid data errors, then the possible addition of data quality software.  Continue Reading

• Pfizer swaps out ETL for data virtualization tools

  When a research and development division of pharmaceutical maker Pfizer Inc. ran into data integration struggles, it decided to go virtual.  Continue Reading

• Successful data stewardship framework needs solid plan, firm focus

  Stewarding data can be a tough nut to crack: lots of effort for a reward that isn't always apparent. To succeed, strong project management is needed.  Continue Reading

• Pella opens window of opportunity with database virtualization software

  Window maker Pella uses virtual databases for testing and development. Its advice: IT pros eyeing the technology should get elevator pitches ready.  Continue Reading

• Data stewardship program: Quality booster, but a hard step for many

  While data stewardship can help improve the quality of corporate data, analysts say there's more talk than action when it comes to adopting the concept.  Continue Reading

• Make communication, purpose priorities in a data governance program

  Data governance can be all bureaucracy and no benefit. To avoid that, managing the process effectively is a must, says consultant Danette McGilvray.  Continue Reading

• Decision time: Automated data integration tools versus manual coding

  In many companies, data integration remains a manual task -- by choice. But it might be time to automate that process, says consultant Rick Sherman.  Continue Reading

• Mission impossible? Data governance process takes on 'big data'

  Effective governance can help companies get the most out of their "big data" environments. But at this point, there's no formula for how to do that.  Continue Reading

• Internal data quality standards not just a game for business users

  Ensuring that business users follow corporate standards when entering and updating data is vital to the success of data quality improvement efforts.  Continue Reading

• Data quality process needs all hands on deck

  Data accuracy is critical in technology-driven business processes, making it a must to involve business users in data quality efforts, analysts say.  Continue Reading

• A must to avoid: Worst practices in enterprise data governance

  Consultant Rick Sherman details 10 common data governance mistakes that can send governance initiatives down the wrong path – the one to failure.  Continue Reading

• Making business transaction processing and applications work

  Learn about making business transaction processing work in your company, find tips on transaction processing applications and get transaction processing definitions.  Continue Reading

• Transaction processing system examples and SOA approaches

  Learn about transaction processing systems, processing systems components, and different service-oriented architecture approaches including representational state transfer.  Continue Reading

• Key benchmarks for measuring transaction processing performance

  Find key benchmarks for measuring transaction processing performance at your company, and learn about XA two-phase commit and types of transaction processing.  Continue Reading

• Understanding and comparing six types of data processing systems

  Learn about six types of processing systems and how transaction processing systems compare with batch processing, real-time, data warehouse, timesharing and client/server systems.  Continue Reading

• William McKnight's contributions to SearchDataManagement.com

  Access all of William McKnight's data warehouse and business intelligence advice and best practices.  Continue Reading

• Top eight data and application integration definitions and buzzwords

  Get the top data and application integration definitions, terms, buzzwords and concepts in this guide. Also, find links to helpful integration tutorials, training, articles and expert advice.  Continue Reading

• Master Data Management (MDM) Platform Product Directory

  This MDM software product directory provides information about major MDM, PIM and CDI vendors that can help improve MDM in your organization, as well as expertise advice on choosing the right MDM tool.  Continue Reading

• Data modeling concepts: How settings can increase application success

  In this book excerpt, learn how four camera settings translate directly to the data model, and how understanding these data modeling concepts can increase the chances of a successful application.  Continue Reading

• How to shred XML with the DB2 XMLTABLE function

  In this XML guide, learn how to shred XML using the DB2 XMLTABLE function with detailed examples. Find out when you should store XML in a hybrid fashion and how to create relational views over XML data.  Continue Reading

• Shredding XML docs into relational tables with annotated XML schemas

  In this XML tutorial, find out how to shred XML documents into relational tables with annotated XML schemas with 14 examples. Plus, learn how to define schemas visually in IBM Data Studio.  Continue Reading

• Advantages and disadvantages of XML shredding

  Learn about the advantages and disadvantages of XML shredding and different shredding methods, plus find out when shredding is and isn't a good option for your company.  Continue Reading

• Guidelines for managing data updates to optimize ODBC performance

  Looking to optimize your ODBC applications and functions? Find guidelines for updating data and managing your data updates efficiently and how to improve ODBC performance.  Continue Reading

• Selecting ODBC functions for optimized SQL statements

  In this book excerpt, you'll find best practices guidelines for deciding what ODBC function to use when executing SQL statements and how to use bound columns.  Continue Reading

• How to capture metadata information, ETL rules with CA Erwin Data Modeler

  Learn how to capture and retrieve metadata information such as extract, transform, load (ETL) rules by using CA Erwin Data Modeler. This data modeling excerpt also covers step by step of how to capture the ETL information using and the generating of...  Continue Reading

• Static SQL vs. dynamic SQL for database application performance

  Learn the difference between static SQL vs. dynamic SQL and the benefits and drawbacks of each for database application performance. Get a definition of stored procedure, find out about database drivers and wire protocol database drivers and how the...  Continue Reading