Database management system (DBMS) architecture, design and strategy

Email Alerts

Register now to receive SearchDataManagement.com-related news, tips and more, delivered to your inbox.
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

  • Advanced analytics, in-memory technology push information limits

    The information explosion is in need of a cleanup crew, and this one comes equipped with advanced analytics and in-memory technology to pick up the slivers, piece them together and glean business insight. In this issue of Business Information, learn ...  E-Zine

  • XQuery and XML data: DB2 helps manage the era of unstructured data

    The arrival of IBM XQuery and XML data is simplifying users' decisions in this era of unstructured data, just as the arrival of the relational database and SQL simplified IT buyers' decisions twenty years ago.  Tip

  • SQL Server freebie: TOAD for SQL Server

    When you use SQL Server's built-in tools for database development, you may find that each has its imperfections. Contributor Serdar Yegulalp spotlights a 90-day free SQL Server tool that can act as your development environment, object explorer, depen...  Tip

  • Saving lives with Oracle

    Thanks to rapidly falling disk costs, companies can now afford to store trillions of bytes of valuable information. However, data professionals know that the real challenge is making sense from these huge data stores and mining them for statisticall...  Tip

  • Hacker's-eye view of SQL Server

    Hackers can devastate your SQL Server workflow and cripple your company's business. Contributor Hilary Cotter outlines the four primary methods used to hack into SQL Server and offers defenses to prevent security breach.  Tip

  • Worst practices for SQL Server backup and recovery

    In the event of a SQL Server failure, wouldn't it feel good knowing you have a well-tested and reliable backup and restore process to protect your data? The success of your efforts depends more on seemingly small oversights or mistakes you make than ...  Tip

  • MetaBase scripting for the Oracle data warehousing DBA

    The OMB scripting language is a extension of TCL and is an attractive alternative to the do-it-yourself approach to ETL management for the Oracle data warehousing DBA.  Tip

  • SQL Server and business intelligence: Plan ahead

    Here are some key planning concepts to keep in mind whenever you use SQL Server as a solution to a particular business problem.  Tip

  • A simple way to reorganize a table and release the unused space

    A simple way to reorganize a table and release the unused space is by using the following simple command.  Tip

  • When managing database environments, integration is key

    When managing complex database environments, IT vendors and buyers agree on the three top priorities.  Tip

  • Amazon Dynamo Database (DDB)

    Amazon Dynamo Database (DDB) is a fully-managed NoSQL database service. Dynamo Database is known for extremely low latencies and scalability.  Definition

  • in-memory database

    An in-memory database is a type of analytic database designed to streamline the work involved in processing queries.  Definition

  • Cassandra (Apache Cassandra)

    Apache Cassandra is an open source distributed database system for storing and managing large amounts of data across commodity servers without a single point of failure (SPoF). Cassandra, which can handle hundreds of thousands of requests per second...  Definition

  • virtual cube

    A virtual cube is a subset of one or two existing cubes in a database. Database administrators create virtual cubes for security purposes and/or to enable analysis of the shared data.  Definition

  • sparsity and density

    Sparsity and density are terms used to describe the percentage of cells in a database table that are not populated and populated, respectively. The sum of the sparsity and density should equal 100%.  Definition

  • NoSQL (Not Only SQL)

    NoSQL database, also called Not Only SQL, is an approach to data management and database design that's useful for very large sets of distributed data.    Definition

  • denormalization

    In a relational database, denormalization is an approach to optimizing performance in which the administrator selectively adds back specific instances of duplicate data after the data structure has been normalized.  Definition

  • columnar database

    A columnar database is a database management system (DBMS) that stores data in columns instead of rows.  Definition

  • OLAP (online analytical processing)

    OLAP (online analytical processing) enables a user to easily and selectively extract and view data from different points-of-view.  Definition

  • data classification

    Data classification is the categorization of data for its most effective and efficient use...  Definition

  • Top six data management software stories of 2011

    From the rise of "big data" to office politics hampering MDM projects to Hewlett-Packard giving Neoview the ax, and more, there were plenty of notable data management stories in 2011.  Photo Story

  • Why you should keep your 'big data' technology small -- for now

    In a video interview at the Strata Conference 2011, Forrester Research analyst James Kobielus explains why it’s important for companies with big-data installations to optimize their storage systems.  Video

  • Data warehouse architecture: Beyond hub-and-spoke

    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.  Podcast

About Database management system (DBMS) architecture, design and strategy

If you’re deploying or updating database management systems and DBMS software, you need to be current on the latest trends and issues involving database architecture, design and strategy. In this section, you’ll find news and other information resources on creating a DBMS architecture and developing a database strategy for your organization. Also, get tips and expert advice on database design and development and managing a database implementation project. Stay up to date on database design tools and DBMS design methodologies, and read DBMS tutorials and guides on DBMS concepts and database best practices.

Back to top