Newsletters




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

Hershey's LLC recently deployed the Infosys Information Platform on AWS to analyze retail store data.

Posted March 31, 2016

The traditional information engineering approach advocates the placement of as much business logic as possible inside the database management system (DBMS). But, more recently, under the umbrella of service-oriented architecture (SOA), folks are arguing for placement of that business logic in a layer of code outside the DBMS. Occasionally, those who favor locating business logic outside the DBMS have even gone so far as to say that this logic "naturally" belongs in a non-DBMS-supported layer.

Posted March 31, 2016

Teradata has introduced a new "design pattern" approach for data lake deployment. The company says its concept of a data lake pattern leverages IP from its client engagements, as well as services and technology to help organizations more quickly and securely get to successful data lake deployment.

Posted March 28, 2016

The digital economy promises to redefine nearly every aspect of a company's operations—from raw material procurement through post-sale services. Yet, some of the most dramatic changes will be seen in how companies evolve their product portfolios and leverage digital capabilities.

Posted March 25, 2016

The rise of big data technologies in enterprise IT is now seen as an inevitability, but adoption has occurred at a slower pace than expected, according to Joe Caserta, president and CEO of Caserta Concepts, a firm focused on big data strategy consulting and technology implementation. Caserta recently discussed the trends in big data projects, the technologies that offer key advantages now, and why he thinks big data is reaching a turning point.

Posted March 23, 2016

SAP SE's newest in memory query engine, SAP HANA Vora, is now generally available, equipping enterprises with contextual analytics across all data stored in Hadoop, enterprise systems, and other distributed data sources.

Posted March 23, 2016

The Independent Oracle Users Group (IOUG) has represented the voice of Oracle technologists and professionals for more than 20 years, and we are so proud of how our community has not just grown but maintained its adaptive approach that centers on peer-to-peer education and know-how. We hope that you share our sense of pride as we celebrate the technology community's marquee event: COLLABORATE 16-IOUG Forum.

Posted March 23, 2016

Few of us working in the software industry would dispute that agile methodologies represent a superior approach to older waterfall-style development methods. However, many software developers would agree that older enterprise-level processes often interact poorly with the agile methodology, and long for agility at the enterprise level. The Scaled Agile Framework (SAFe) provides a recipe for adopting agile principles at the enterprise level.

Posted March 23, 2016

The OAUG volunteers planning COLLABORATE 16: Technology and Applications Forum for the Oracle Community (April 10-14 at Mandalay Bay in Las Vegas) are themselves Oracle users and technologists, understanding innately the myriad options and challenges faced by the wider user community in a period of rapid change and transformation. With participation and contributions from all corners of the user community, COLLABORATE offers the information and perspective to make sense of it all.

Posted March 21, 2016

Embarcadero Technologies, provider of database lifecycle management solutions, is enhancing its ER/Studio platform, focusing on better collaboration and communication within enterprises.

Posted March 16, 2016

In a new book titled "Next Generation Databases," Guy Harrison, an executive director of R&D at Dell, shares what every data professional needs to know about the future of databases in a world of NoSQL and big data.

Posted March 08, 2016

Every DBA should take advantage of the mechanisms provided by the DBMS to ensure data integrity. When DBMS-provided methods are used, fewer data integrity problems are likely to be found. Fewer data integrity problems mean higher quality databases and more proficient end users.

Posted March 03, 2016

When it comes to operational, third normal form approaches, too many database models today have very low levels of business veracity. This is because current IT trends work against incorporating too much truth inside the entity-relationship diagram. Instead, development teams center on the finished product and excessively worry about describing a solution rather than describing the actual organization.

Posted March 03, 2016

DBmaestro, a provider of DevOps for database solutions, has released TeamWork version 5.0 which includes a new pipeline builder that enables users to visually describe the database environment and the deployment flow. DBmaestro has also introduced stronger compliance and audit capabilities for the database.

Posted February 17, 2016

Oracle has introduced a new Big Data Preparation Cloud Service. Despite the increasing talk about the need for companies to become "data-driven," and the perception that people who work with business data spend most of their time on analytics, Oracle contends that in reality many organizations devote much more time and effort on importing, profiling, cleansing, repairing, standardizing, and enriching their data.

Posted February 10, 2016

Datical, a provider of agile database automation solutions founded in 2012, has added $8 million in Series B funding, led by S3 Ventures with participation from existing investors Mercury Fund and Austin Ventures. According to the vendor, automation at every level is a key element of DevOps, but the database is often overlooked or becomes an afterthought when companies adopt this modern approach to software delivery.

Posted January 26, 2016

MicroStrategy is releasing an updated version of its analytics platform that will make it easier than ever to build apps and dashboards, offer speedy deployment, and improve governance.

Posted January 07, 2016

Data modelers must look at the big picture of an organization's data ecosystem to ensure additions and changes fit in properly. Simultaneously, each data modeler must be focused on the minute details, adhering to naming standards, domain rules, data type practices, still remaining ever vigilant for instilling consistency across everything they do. And while focused on all of the above, their efforts must culminate in a practical model that serves the individual project's requirements while also being implementable, maintainable, and extensible.

Posted January 07, 2016

In 2015, big data, mobility, IoT, expanding requirements for security and real-time analytics and the introduction of the Cognitive Era continued to place greater pressure on IT organizations. Linux and open source technologies are at the center of many of the most innovative software and hardware solutions that are addressing emerging enterprise requirements. Here's a look back at some of the most significant announcements in Linux and open source technology of 2015.

Posted December 16, 2015

Looking ahead to 2016 David Jonker, senior director of big data at SAP, offered six key business and technology trends that will take the market by storm, including a continued interest in in-memory processing, enablement of real-time data and analytics, and an increased focus on advanced analytics and machine learning.

Posted December 16, 2015

It is often said that the only constant is change. For data executives and professionals, the coming year will only bring a lot more of it. Developments as diverse as cloud, big data, real time, NoSQL, analytics, and the Internet of Things (IoT) will continue to reshape enterprise data operations and opportunities as we know them. Here are 16 trends that will shape the enterprise data landscape in 2016.

Posted December 16, 2015

What's ahead for 2016 in terms of cloud, IoT, big data, analytics, and open source technologies? IT executives gaze into their crystal balls, and weigh in on the upcoming challenges and opportunities ahead in the next year - and beyond.

Posted December 16, 2015

Our data models, in reflecting a specific business, must accurately portray the essence of each business. The unique reality within each organization drives the shape of every data model. The logical meaning of each data element originates with what is actually done and how it is accomplished within that particular organization.

Posted December 02, 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

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

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

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

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
32
33
34
35
36
37
38
39
40
41
42
43
44

Sponsors