Data Modeling

Data Modeling and Database Design and Development – including popular approaches such as Agile and Waterfall design - provide the basis for the Visualization, and Management of, Business Data in support of initiatives such a Big Data Analytics, Business Intelligence, Data Governance, Data Security, and other enterprise-wide data-driven objectives.

Data Modeling Articles

Traditionally, the cardinal rule has been to model data first and load it later. But with new technologies and repositories such as Hadoop, NoSQL, and data lakes, and big data itself, the rule is being flipped to load first and model later. And, with SQL remaining an effective and widely embraced query language, companies have to balance working with traditional methods against the need for some of the newer methods as well.

Posted December 01, 2015

With increased demand for mass customization and personalization, the emergence of Web 2.0, and one-to-one marketing, and the need for better risk management and timely fraud detection, the pressure is on for organizations to improve their ability to extract, understand, and exploit analytical patterns of customer behavior and strategic intelligence.

Posted November 12, 2015

Many neophyte data modelers have trouble distinguishing between logical and physical data models. These novices likely cannot explain why each model exists, or the differences expressed between them. Sadly, such confusion also exists in the realm of the experienced data modeler. Not to say an experienced data modeler can't express the difference between a logical and a physical data model; but across a group of experienced data modelers one would not get a consistent answer.

Posted November 09, 2015

Organizations are getting squeezed, said Mark Hurd, Oracle CEO, in his Monday morning keynote at Oracle OpenWorld 2015. They have old infrastructure; there is the need for innovation but also great pressure to do things such as increase security and adhere to governance mandates which are not innovative; and also pressure to keep costs flat, without increasing IT costs. "This is why the cloud is such a big deal," said Hurd, sharing his list of top 5 predictions for 2025.

Posted November 04, 2015

The Agile methodology is great for getting turgid development teams to start working faster and more coherently. With Agile, which focuses on more rapid, incremental deliverables and cross-departmental collaboration, the bureaucratic plaque is flushed from the information technology groups' arteries. But there is a dark side to Agile approaches.

Posted October 21, 2015

In what is being hailed as the biggest tech merger ever, Dell Inc. and EMC Corp. today formally announced they have signed a definitive agreement under which Dell will acquire EMC. The total transaction is valued at $67 billion. The deal is expected to close in the second or third quarter of Dell's fiscal year which ends February 3, 2017 (within the months of May to October 2016). The industry is going through a "tremendous transformation," with the old style of IT being "pretty quickly disrupted" yet this rapid change is also presenting "incredibly rich" opportunities, said Joe Tucci, chairman and chief executive officer of EMC, during a conference call with media and industry analysts.

Posted October 12, 2015

Compuware Corporation, a mainframe software company, delivered its fourth major release of Topaz—a solution suite intended to help enterprise customers to tap the potential business value of their IBM z Systems. The latest release features Topaz Runtime Visualizer (Topaz RV), which provides visibility into the often-complex interactions between mainframe programs. This visibility helps developers understand, modify and troubleshoot older or poorly documented mainframe code.

Posted October 12, 2015

Looker, which provides a data discovery and analytics platform, has announced a new offering. According to the vendor, Looker Blocks, which are reusable and customizable, are apps that are components of business logic, such as churn prediction or lifetime value metrics, that can be put together and customized to address data needs company-wide as well as any industry-specific requirements.

Posted September 22, 2015

Embarcadero Technologies, a provider of software solutions for application and database development, has unveiled the Embarcadero RAD Solution Pack, a collection of VCL and FMX tools and components aimed at enhancing applications and boosting productivity for developers using RAD Studio, Delphi, and C++Builder. The RAD Solution Pack delivers charting, reporting, grids, UI controls, debugging, analytics, Internet of Things (IoT) components and tools in a single solution.

Posted September 18, 2015

Data modelers face a choice when encountering multiple variations of a data item. Designers must focus on the longer term appropriateness of their decisions when choosing how their designs will play out; and going vertical or horizontal does have an impact over time.

Posted September 09, 2015

It's no secret that the world of information technology is changing fast. Data is being created in ways not possible a few years ago. It is now feasible to collect and analyze data from a wide range of sources, including mobile devices, machines, social media, documents, and emails. To help organizations navigate the rapidly changing big data landscape, Big Data Quarterly presents the "Big Data 50," a list of companies driving innovation.

Posted September 09, 2015

There are fundamental differences in priorities and approaches in building operational solutions and in constructing analytical supporting solutions. However, these differences can produce a gap in understanding that occasionally results in minor battles and skirmishes between these groups along the path of getting work done. A critical area of conflict is access to production data. When building an operationally focused solution such as a website, the application is supreme.

Posted September 08, 2015

Embarcadero Technologies, a provider of software solutions for cross-platform application and database development, has released its largest release of RAD Studio in a decade, "RAD Studio 10 Seattle." A primary goal of the new release is to help Embarcadero's community of three million C++ and Delphi developers easily get new and existing applications on Windows 10, plus OS X, and mobile platforms.

Posted August 31, 2015

The Independent Oracle Users Group is headed to San Francisco this October to join the Oracle technology community at Oracle OpenWorld 2015. Representing the voice of Oracle technology professionals, IOUG members will present more than 35 sessions on critical Oracle technology topics, including big data, cloud, Oracle Enterprise Manager 12c, and more. There is a lot to discuss with the Oracle database and technology community, and I am looking forward to connecting with Oracle professionals with similar interests to address challenges and solutions face-to-face.

Posted August 19, 2015

To support developers and operations professionals in their push to implement DevOps principles for their infrastructure environments, ProfitBricks, a provider of cloud infrastructure, is adding support for DevOps tools Ansible and Chef. Ansible is a platform for configuring and managing data center infrastructure that combines multi-node software deployment, ad hoc task execution, and configuration management, and is used by DevOps professionals as they use its playbooks functionality to automate cloud infrastructure. Chef, which is written in the Ruby programming language, makes it easier to manage complex infrastructure and the applications running on it.

Posted August 18, 2015

Google, whose name became synonymous with internet search, is reorganizing to maintain its innovation and competitiveness. The company is creating a new public holding company called Alphabet, with Google as well as other companies, housed within the new structure. According to Larry Page, CEO of Google, the reorganization is part of an effort to avoid getting "too comfortable," observing in a blog post that in the tech industry, "where revolutionary ideas drive the next big growth areas, you need to be a bit uncomfortable to stay relevant.

Posted August 11, 2015

Addressing the need for more big data skills training, Apache Hadoop distribution provider MapR Technologies has announced availability of a complete Apache HBase design and development curriculum on its free Hadoop On-Demand Training program.

Posted August 06, 2015

A typical organization loses 5% of its revenues to fraud each year, and in the U.S. alone the total cost of (non-health) insurance fraud is estimated at more than $40 billion per year, according to Bart Baesens, one of the authors of a new book on data science techniques for fraud detection. While opportunities for fraud are continuously evolving, fraud detection always has the biggest impact if it is done quickly. Fortunately, says Baesens, big data analytics can help to make early fraud detection possible.

Posted August 05, 2015

Following up on the April 2014 announcement of Solaris 11.2, a modern cloud platform including a full OpenStack distribution, Oracle now plans to integrate Docker into Oracle Solaris.

Posted August 05, 2015

Connect with Quest at Oracle OpenWorld, Oct. 25-29, 2015, and learn more about how you could get the answers and solutions you need to solve ERP challenges facing your business. At OpenWorld, you will have many opportunities to connect with the Quest team; from breakout sessions to SIG meetings to various networking opportunities, you'll be able to discover how Quest members leverage the community to achieve a higher satisfaction with their ERP.

Posted August 05, 2015

Each year during Oracle OpenWorld, OAUG Geos and SIGs present more than 50 sessions on Sunday. The user-led SIG sessions feature users and expert consultants sharing their firsthand knowledge and problem-solving tips and suggestions on a range of topics including EBS, Hyperion EPM, OBIEE, BI, and more. In addition, many Geos host Sunday sessions that offer attendees the opportunity to meet peers from their local community.

Posted August 05, 2015

"Big Data," "Cloud," "Mobile," "IoT," "Social," "Real Time"—the stream of buzzwords seems unending. Helping Oracle customers stay on top of the latest technologies, deal with new challenges, and make the most of emerging opportunities, each fall Oracle presents OpenWorld, an event spanning the entirety of Oracle's offerings. The conference attracts tens of thousands of influential attendees who converge in San Francisco to learn about current and future technologies and trends from Oracle and the surrounding ecosystem.

Posted August 05, 2015

The IT industry continues to expand at a brisk pace with a steady influx of innovative products and technologies to help organizations extract value from data, integrate it with new and traditional sources, as well as ensure quality and security.

Posted August 04, 2015

Serena Software, a provider of application development and delivery solutions, announced new application definition and development solutions designed to speed application delivery. These include new versions of requirements management and software change and configuration management solutions in use today: Dimensions RM version 12.3 and Dimensions CM 14.2.

Posted August 03, 2015

Embarcadero Technologies, a provider of software solutions for application and database development, has acquired Raize Components. Along with the acquisition, Embarcadero is introducing new releases of CodeSite and Konopka Signature VCL Controls, as Embarcadero add-on products for developers. "With the release of Windows 10 tomorrow, it's the perfect time for developers to be thinking about new and expanded Windows development as Microsoft brings Windows to more form factors and extends it with Bluetooth LE, IoT, and mobile support," said John "JT" Thomas, senior director of application development products at Embarcadero.

Posted July 28, 2015

MariaDB has released updates in the latest version of its enterprise platform that are designed to accelerate deployment of open source DBMS applications and improve reliability and security for DevOps. The MariaDB Enterprise Summer 2015 Release includes support for developer enablement and DevOps productivity tools such as Docker Containers, Chef Recipes and Cookbooks, adds the ability to launch email notifications and external scripts via MaxScale event triggers and hardened and curated MariaDB Enterprise server binaries.

Posted July 28, 2015

Dell is releasing a series of updates to its Toad family of database solutions that will continue to prioritize managing data across a variety of platforms. The latest round of updates to the Toad family of solutions enables customers to automate agile development practices, improve data preparation for analytics and reporting, and gain flexibility in selecting database platforms, according to Dell.

Posted July 22, 2015

Many developers are familiar with the relational way to model data but may not be as familiar with modeling data in a document database. There are three main things developers need to know about modeling data in a document database: document design, key design, and querying.

Posted July 21, 2015

Before enterprises create data architecture for business intelligence and analytics, there are a few key components they need to consider.

Posted July 21, 2015

New additions to the Oracle Cloud Platform were introduced in June. A critical piece of the updated suite, according to Amit Zavery, senior vice president of Cloud Platform at Oracle, is the Oracle Integration Cloud Service, which aims to simplify integration between cloud and on-premises Oracle and third-party applications.

Posted July 15, 2015

Oracle has taken the wraps off Oracle VM VirtualBox 5.0, the latest release of the free and open source, cross-platform virtualization software. Now generally available, Oracle VM VirtualBox runs on standard x86 desktop and laptop computers, and enables developers and users to create cloud and local applications without the overhead of using a full server environment.

Posted July 15, 2015

As Agile development increases in popularity, companies have achieved faster time to market, reduced risk, and increased ability to manage changing priorities in their projects. However, what Agile means for the DBA team is more database deployments more often.

Posted July 08, 2015

What matters most in data management in 2015? There are a lot of moving parts that data managers and professionals need to attend to in today's enterprises. Databases need to be wide open and accessible to all parts of the business, but at the same time, secure and free of tampering. Unstructured forms of data—such as log data, documents, graphics, video, and social data—need to be prepared and ready for analysis in the same way structured files have been ready for years.

Posted June 25, 2015

MapR Technologies, Inc., a provider of a distribution for Apache Hadoop, is including Apache Drill 1.0 in the MapR Distribution. Drill is a schema-free SQL query engine for Hadoop, NoSQL, and cloud storage. According to MapR, the partner ecosystem is embracing Apache Drill, and a range of companies, including SAP, are working closely with MapR and the Drill community to interoperate BI tools with Drill through standard ODBC/JDBC connectivity.

Posted June 24, 2015

IOUG offers webcasts on a range of topics including cloud computing, best practices, database security and many more.

Posted June 17, 2015

Petabytes, and more, of data are meaningless without guides to what it all is. Future data users need to know where it came from, how it was filtered, and how it was transformed. Without some functional level of governance we are headed toward a "datapocalypse"—having lots of content but little of value.

Posted June 09, 2015

CA Technologies has signed a definitive agreement to acquire Rally Software Development Corp. a provider of Agile development software and services, for approximately $480 million, net of cash acquired.

Posted June 08, 2015

New and emerging companies are taking aim at data management challenges to help customers get more value from their data. Here, DBTA showcases the approaches of 10 companies we think are worth watching.

Posted June 01, 2015

The world of information technology is often described as an ecosystem. And just like an ecosystem that exists in nature, IT is affected by internal and external factors. In this issue of Database Trends and Applications magazine, we introduce the third annual list of companies that matter in data, a reflection of the IT ecosystem as it exists now.

Posted June 01, 2015

Embarcadero Technologies, a provider of software solutions for application and database development, has unveiled the new XE7 version of ER/Studio, its flagship data architecture suite.

Posted May 28, 2015