Database management system DBMS architecture design and strategy
- October 25, 2011
The growing volumes of "big data" that organizations are looking to store pose a variety of potential problems and issues for data warehousing teams.
- October 25, 2011
Successfully managing "big data" as part of a data warehousing strategy requires careful planning and a clear understanding of the various technology choices, according to industry analysts.
- October 20, 2011
Businesses need to lose the "batch mentality" and focus instead on real-time data processing, according to one Bank of America IT executive.
- September 21, 2011
Data modeling experts offer tips on building effective models and dealing with the tendency of data modelers to get overly attached to their work.
- August 25, 2011
Analyst Tony Iams explains the choice of scaling up or scaling out systems and offers tips on matching database workloads with the right architecture.
- August 09, 2011
The flood of "big data," particularly unstructured information, is pushing organizations to look beyond traditional data warehousing. That creates new opportunities but also new challenges.
- July 28, 2011
IT pros and analysts offer guidance on how to cope with the complexities of "big data" installations in data warehouses and alternative data stores.
- July 21, 2011
The UPMC health network faced several data replication software challenges when ramping up its disaster recovery site.
- July 12, 2011
For many data management professionals, the summer months likely will include thoughts – and some worries – about data integration issues and future career paths. Find out what’s driving that.
- May 26, 2011
Software makers will increasingly add "big data" processing technology to their data management portfolios in the near future, according to Forrester Research Inc.
- April 13, 2011
If you’re thinking about embarking on a database consolidation or standardization project, make sure you know the technical, cultural and skill-set issues that can arise.
- March 07, 2011
Enterprises that consolidate on a single database standard can reduce IT complexity and improve data quality, but there are some potential drawbacks, experts say.
- March 03, 2011
Database standardization projects require special attention to internal skill sets, cultural issues and technical factors such as database semantics, according to analysts.
- January 26, 2011
Get consultant Rick Sherman’s advice on deploying analytical databases, and learn about the challenges that organizations can face on analytical database projects.
- January 19, 2011
Get advice from consultant Rick Sherman on using technologies such as columnar databases and in-database analytics to boost the performance of advanced analytics applications.
- December 15, 2010
Find out why Cognitive Match decided to replace Oracle’s MySQL with Calpont Corporation’s InfiniDB columnar database software.
- December 14, 2010
Salesforce.com has a solid reputation when it comes to CRM, but the company will have to prove itself again if it wants its new cloud-based database to be a success, according to experts.
- December 06, 2010
Learn about key issues to consider as part of the database planning process, and get advice from consultant Mark Whitehorn on developing a successful database strategy.
- December 01, 2010
Get advice from consultant Rick Sherman on how to build a business case for database projects, from creating a database project plan to getting executive approval and funding.
- November 30, 2010
Learn about database system software developments and trends, and get expert insight on how new technologies are affecting database planning and DBMS strategy development.
- November 26, 2010
Crafting a successful database strategy requires technology flexibility, the right skill sets and a strong focus on application requirements, according to IT pros and analysts.
- November 22, 2010
Database as a Service (DaaS) technology is becoming a more viable alternative to on-premises databases. Get guidance on the pros and cons of using cloud database software.
- November 19, 2010
Get consultant Mark Whitehorn’s take on how NoSQL databases and other emerging alternatives to relational databases could affect the evaluation and selection of database engines.
- November 10, 2010
Emerging database technologies such as column-based database software, NoSQL databases and Database as a Service (DaaS) platforms are starting to make a splash in the IT market.
- October 12, 2010
Column-oriented database software is helping one law enforcement technology firm keep track of lawbreakers and predict criminal behavior.
- August 31, 2010
Data modeling techniques are more important than ever, despite the claims of some database vendors, according to data modeling guru and author Len Silverston.
- August 20, 2010
SAP and Sybase are making a big play for Oracle database and business applications customers, according to industry experts.
- August 12, 2010
The new version of Sybase Replication Server aims to greatly reduce the time it takes to move huge volumes of data between enterprise information stores.
- July 22, 2010
Columnar database technology is helping a Nashville firm create new revenue streams. But the implementation process wasn’t that easy.
- July 06, 2010
EMC’s plan to buy analytical database provider Greenplum Software has a lot of ramifications for the software industry, according to one analyst.
- June 24, 2010
A U.K. firm created an electricity monitoring system for 3 million households using a highly customized time series processing database.
- June 08, 2010
SAP could have some difficult choices to make regarding the future of its data integration and analytics products following its Sybase acquisition.
- April 13, 2010
Workload management tools can help keep overtaxed data warehouses running smoothly. Find out how they work and how they can help your business.
- April 13, 2010
Decisions around workload management can present political challenges, but the result could be a better return on your DW investment.
- June 09, 2009
Hear a hub-and-spoke definition and learn about challenges surrounding hub-and-spoke architecture. Know all the issues and details before implementing a hub-and-spoke design and hear how data governance plays a role in the hub-and-spoke model.
- January 21, 2009
Some analysts call Teradata's 2550 data warehouse appliance "entry-level." Don't tell that to IHG, which is in the process of replacing its Oracle data warehouse with the Teradata appliance.
- November 24, 2008
Macy's Thanksgiving Day Parade sacks Microsoft Access, taps FileMaker Pro database for the march down Broadway.
- September 11, 2008
Lou Agosta looks at three events that are driving data warehousing trends: column-oriented analytic databases, the maturing appliance market and open source databases.
- July 30, 2008
Open source databases have largely caught up in functionality and support. Companies should consider them for new, smaller applications, Forrester says.
- July 14, 2008
Selecting a new database? Don't base choices on outdated preconceptions or superfluous criteria. Learn how to avoid common "worst practices" when choosing a database engine.
- July 14, 2008
Database selection isn't easy -- from determining requirements to navigating the market to overcoming biases. Find out how to choose a database from expert Mark Whitehorn.
- February 28, 2008
In an interview, IDC database analyst Carl Olofson offers his analysis of recent developments involving IBM's DB2 software along with predictions of what's coming next.
- December 11, 2007
Putting together a comprehensive data migration plan now can help firms avoid serious downtime later, according to experts.
- December 04, 2007
Data migration processes are slowly evolving from hand-coded scripts toward packaged applications. Find out why more companies are using tools for data migration.
- October 23, 2007
Gartner's data warehouse DBMS Magic Quadrant 2007 includes familiar names offering new technologies that meet the demands of old IT mantras.
- August 03, 2007
IBM today announced plans to buy Princeton Softech -- which makes data management, archiving and classification software -- to bolster its Information on Demand initiative.
- May 30, 2007
IBM's DB2 9 Viper can manage XML and relational data in one database. An analyst says IBM's architecture is unique -- and that other vendors might not appreciate the challenge.
- December 19, 2006
Data management skills are in demand, but inconsistent job titles and descriptions can make finding data management jobs tough. Learn what employers seek and how DAMA may help.
- December 14, 2006
Oracle's Database 11g enhancements focus on XML DB and include a new binary XML data type, a new XML index and enhanced support for XQuery and other emerging standards
- September 25, 2006
Gartner's new Magic Quadrant for data warehouse software and DBMS systems finds that mixed workloads, new appliances and pricing pressures are all affecting the market.
- August 02, 2006
Discover syntax differences between SQL Server and MySQL, code for a timestamp automation workaround and why it's important to keep your version of MySQL current.
- July 17, 2006
Confusion over the DBA's job description and their role in business often results in misusing their DBA job skills.
- July 14, 2006
Database management best practices involve optimizing people, processes and products. Get specific actions and expert tips.
- June 08, 2006
The bus architecture does not address the issues of data granularity and history.
- May 25, 2006
Bus technology is no substitute for data integration.
- May 18, 2006
DW2.0 is the perfect background architecture to make service-oriented architectures successful.
- April 27, 2006
DW 2.0, the architecture for the next generation of data warehousing, is designed to meet the information needs of the entire corporation.
- March 30, 2006
"DW2.0 - an architecture for the next generation of data warehousing - acknowledges that both structured data and unstructured data belong in a data warehouse and that a bridge must be built between the two environments for integrated decision"
- March 15, 2006
SAP is defending itself against a research note released last week that is said to debunk the statistics used in a high profile SAP advertising campaign.
- March 14, 2006
Oracle's newly released free SQL Developer could spell trouble for Quest Software Inc.'s popular Toad for Oracle software.
- February 22, 2006
Is the clout of open source databases, expected to grow to a $1 billion market by 2008, going to lead to their demise by acquisition? This columnist ponders the meaning of Oracle's Sleepycat and Innobase acquisitions, and MySQL's anti-acquisition ...
- February 09, 2006
Database pros responding to a recent column express serious reservations about one venture capitalist's plan to market open source Ingres to SAP users.
- February 02, 2006
SAP would love to change the fact that the Oracle database is highly used among its customers, explains Joshua Greenbaum, principal analyst at Enterprise Applications Consulting.
- January 05, 2006
There are different approaches that need to be taken in evaluating a vendor-led or a consumer marketplace for data warehousing.
- December 20, 2005
You must regularly test SQL Server security if you hope to identify security weaknesses before an intruder does. Contributor Kevin Beaver offers SQL Server security testing methods, tools and a checklist to help you find and fix vulnerabilities.
- December 15, 2005
Enterprise Manager's standard tools aren't much help in examining SQL Agent jobs. To get details about jobs currently running, try this sp_ListJobInformation routine instead.
- December 08, 2005
No matter what type of company you work for, chances are you have to prepare for spikes in SQL Server activity throughout the year. (Online retailers are in the midst of one right now.) Learn how to maintain highly available, fast-performing SQL ...
- November 28, 2005
Early adopters tend to pay the price for kinks not yet worked out of new technology products. But SQL Server 2005 is not entirely new and may not need to be treated as such, says Edgewood Solutions' Greg Robidoux. He explains the benefits and risks ...
- November 22, 2005
For many long-time SQL Server 2000 DBAs, firing up Query Analyzer or Enterprise Manager is like coming home after a long day. But SQL Server MVP Adam Machanic says it's time to step out of your comfort zone -- or you'll be envying everyone who's ...
- November 15, 2005
SQL Server 2005 embodies Microsoft's ambitions toward the larger enterprise database management market. Sybase, Oracle and IBM have traditionally required more highly trained -- and higher priced -- administrators. Will SQL Server now need them, too?
- November 07, 2005
SQL Server 2005 is ready to go, but applications that make the most of its new features may take some time to reach the market.
- November 07, 2005
Microsoft CEO Steve Ballmer called the launch of SQL Server 2005, Visual Studio 2005 and BizTalk 2006 the start of the next generation of "broad applications platform."
- November 03, 2005
Step 1 of our data integrity guides explains how to develop your data integrity strategy.
- November 02, 2005
The sudden uptick in big deals reported by Siebel made Oracle look good, but it's unlikely a Siebel acquisition will alter the competition between SAP and Oracle.
- October 19, 2005
Large users want the security enhancements and will upgrade sooner; smaller shops worry about new-release glitches, and many say they'll wait for the first service pack.
- June 01, 2005
Jeremy Kadlec explores the components for properly leveraging people, processes and technology for performance tuning.
- February 15, 2005
Craig Mullins contemplates the role of open source database systems in the enterprise.