The ROI of Data Modeling Whitepaper
Businesses rely on data for important decision-making, but may need to justify the Return on Investment (ROI) of data modeling within their organization. In this whitepaper, Tom Haughey discusses how to calculate the return on investment (ROI) of data modeling by assessing the economic value of real data modeling benefits, such as improved requirements definition, reduced maintenance, accelerated development, improved data quality and reuse of existing data assets.
ERwin Migration Guide
Migrating from one data modeling tool to another doesn’t have to be difficult or painful. Use this migration guide to take you through the steps for importing your ERwin data models into ER/Studio.
Data Modeling and Collaboration: Insights for Business and Data Professionals
Corporate data is dramatically increasing in importance. It is imperative to have trustworthy data that correctly represents all aspects of the business environment. Data modeling can be a useful way to improve data quality and integrity and establish the foundation for a business-driven data architecture. This Dimensional Research report contains a summary of survey results from 402 business and data stakeholders, covering current trends in corporate data and data modeling.
Modern Data Architecture
The data warehouse is an established concept and discipline that is discussed in many books, conferences and seminars. Into this world comes a new technology – Big Data. In this paper, William Inmon describes the differences and similarities between data warehouse architectures and Big Data technologies.
Ensuring a Sustainable Architecture for Data Analytics
In this paper, Claudia Imhoff, Ph.D., describes an analytical architecture that expands on the existing Enterprise Data Warehouse (EDW) to include new data sources, storage mechanisms, and data handling techniques needed to support both conventional sources of data and those supplying Big Data.
Insights into Modeling NoSQL: A DATAVERSITY(R) 2015 Report
This DATAVERSITY report consolidates the findings of their NoSQL survey, which examined a number of crucial issues within the NoSQL world today, with a focus on data modeling in particular.
Is your Data Modeling Workflow Agile or Fragile?
Is your organization working on Agile or Scrum development projects? Many companies are moving to these methodologies for applications and databases, but haven’t taken them all the way back to the data models. In this whitepaper, Karen Lopez provides 10 tips and discusses ways for data modelers to work with sprint-focused agile development projects.
IDC Technology Spotlight: Enabling Enterprise Agility through Model-Driven Data Design
This analyst report examines the growing importance of model-driven processes for database design and management. The paper specifically focuses on the role and common use cases for business-driven metadata in database modeling, design, and development tools and how Embarcadero’s ER/Studio solution addresses the needs of today’s enterprise data landscapes.
Top 6 Essential Data Architecture Insights
Whether you’re working with relational data, schema-less data, or model metadata, you face challenges in providing the right access and context for your enterprise data assets. Read this eBook for essential insights on important data architecture topics.
Top 5 Data Architecture Challenges
Data architects face many challenges on a day-to-day basis which have made data modeling and metadata management more important than ever. The models and associated metadata are the only means by which complex data environments can truly be understood and managed. This whitepaper highlights five major challenge areas, and provide insights regarding how to address them with data modeling.
Agile Data Modeling: Not an Option, but Essential
Everything about data has changed, but that only means that data models are even more essential to understanding that data so that businesses can know what it means. As development methodologies change to incorporate Agile workflows, data architects must adapt to ensure models stay relevant and accurate. This whitepaper describes key requirements for Agile data modeling and shows how ER/Studio supports this methodology.
Make the Most of Your Metadata
There are multiple considerations for collaborating on metadata within an organization, and you need a good metadata strategy to define and manage the right processes for a successful implementation. In this white paper, David Loshin describes how to enhance enterprise knowledge sharing by using collaborative metadata for structure, content, and semantics.
Top 10 Reasons I Switched to ER/Studio
As an independent consultant, Ron Huizenga used both ERwin and ER/Studio with a wide range of customers. Based on his experience and evaluation, he concluded that ER/Studio had the right features and capabilities to address the complex enterprise data architecture needs of his clients. Read this paper to learn why he made the switch to ER/Studio.
IDC Analyst Connection: How to Map Complex Data Landscapes
In today’s enterprise data environment, businesses are dealing with a larger volume of data that has expanded in its variety and velocity, and must assess how to integrate the new ‘big data’ with their existing relational assets. In this analyst report, Carl Olofson shares his insights on the challenges, strategies, and benefits of working with complex data landscapes.
Metadata needs to be organized and managed if it is to be leveraged effectively. Published in the DBTA Best Practices Series, this article describes metadata and its value, outlines the importance of integrating metadata in an enterprise data environment, and reviews approaches to implementation.
Metadata Overview: ER/Studio and Team Server
As a modeling and collaboration platform, ER/Studio is a very capable environment to define, manage and organize metadata effectively. This allows business and data consumers understand how data is used across the organization. This Tech Note documents some of the features that make ER/Studio Data Architect and ER/Studio Team Server particularly well-suited for handling metadata.
In this white paper, Robin Bloor and Rebecca Jowiak from The Bloor Group discuss the value of metadata and the importance of organizing it well. Learn about the benefits of the ER/Studio Team Server, which lets you:
- Collaborate on metadata across your organization
- Manage disparate data sources and definitions
- Establish an enterprise glossary of business definitions and data elements
- Improve communication between teams
7 Steps Every Successful Data Architect Follows to Build Stronger Teams
Your data models are brilliant... but only if the DBAs and developers are on the same page. Get more value through collaboration. How? In this white paper, Karen Lopez from InfoAdvisors, Inc. discusses strategies on how to build a little more teamwork and collaboration and get a lot more value from data modeling.
How Meaningful Use Impacts Healthcare Data Management
In this paper, you’ll learn:
- What ARRA, HITECH, Meaningful Use (MU), and Certification mean.
- How technical personnel such as data architects, DBAs and developers will be affected by MU.
- The best ways to determine the MU gaps that might be found in existing systems.
- Additional expertise technical personnel may need to meet MU.
- How quickly systems will need to be modified and deployed to meet MU rules.
Seven Deadly Sins of Database Design
To learn all you can about data modeling for your data warehouse and what to look out for, you need to know how to identify the primary issues that surface. This awareness can help when you run into a scenario where you find architecture that is not fully documented and different from the rest of your database designs.
In this whitepaper we’ll focus on seven common database design “sins” that can be easily avoided and suggest ways to correct them.
Enterprise Data Modeling: 7 Mistakes You Can’t Afford to Make
To help you avoid pitfalls in your data architecture, Karen López describes how to: understand the benefits of an effective enterprise data modeling effort; identify seven common mistakes that organizations can make in developing enterprise data models; and establish a plan to address those issues with ER/Studio
Use these strategies to define and deploy a successful enterprise data model in your company.
The Five Things Data Architects Need to Know About Collaborating with their Business Users
While data architects like to collaborate amongst themselves using their own procedures and language, they need to consider improving our interaction with our business clients. This paper discusses five things you can do right now to improve collaboration with business users.
Creating a Sustainable Data Governance Program
In this whitepaper, data management expert Kelle O’Neal leads you through the process of creating a sustainable data governance program:
- Managing the expansion of data governance
- Embedding the program
- Identifying the difficulties of creating sustainable governance
- Assessing the current state of your data governance
Getting Started with Guerilla Governance
Guerilla governance speeds up the process and reduces costs by focusing scarce resources on projects that add the most value to your organization.
In this whitepaper, data management expert Kelle O’Neal shows you how to:
- Spot key differences between guerilla and enterprise governance
- Develop, quantify, and justify your data governance program
- Create your own plan of action you can execute right now
Making the Business Case for Data Governance
To help you make a business case for data governance within your own organization, we’ve teamed up with Kelle O’Neal on a whitepaper called “Making the Business Case for Data Governance” that walks you through a step-by-step process to:
- Quantify the benefits of data governance in your own organization
- Establish the scope of a data governance program
- Show a clear connection between data governance and the ability to meet business objectives
5 Data Governance Pitfalls to Avoid
Download the whitepaper “How NOT to Govern Data: 5 Pitfalls to Avoid” to discover:
- The top 5 mistakes you can make in your data governance program that will virtually guarantee failure
- Concrete strategies to avoid these pitfalls from the beginning, or correct them once you’ve got them
- How to incorporate best practices into your broader data governance framework
The Business Case for ER/Studio
This expert whitepaper will show you the true, cascading costs of using tools such as Visio or Excel for data modeling. You’ll learn how using tools built specifically for data modeling can help you achieve up to a 387% ROI in year one.
Does Data Modeling Still Matter, Amid the Market Shift to XML, NoSQL, Big Data, and the Cloud?
During the last few years, several database market dynamics have led many people to question the utility of data modeling. In particular, the advent of XML information management, growing frustration with traditional relational database management system (RDBMS) capabilities and vendor relationships, and the expanding influence of cloud platforms have led many organizations to reconsider their commitments to the practice of data modeling. Read this paper for perspectives on why data modeling is more important than ever before, and that organizations that seek to fully leverage database market dynamics must redouble their focus on data modeling.
Mini-eBook - The Data Model Resource Sample Collection
Almost all business applications track information about people and organizations, recording information about customers, suppliers, subsidiaries, departments, employees, and contractors redundantly in many different systems. For this reason, it is very difficult to keep key information such as client contact data consistent and accurate. Examples of applications that store information about people and organizations include sales, marketing, purchasing, order entry, invoicing, project management, and accounting.
White Paper: The 5 Things You Must Do Before Starting Any Data Governance Program
Summary: We need data governance in our organizations and we need it to be done correctly. We as data professionals cannot solve this problem alone. In fact, we can’t solve it at all. This is a business issue. We cannot force compliance into systems after the fact, nor can we engineer it into solutions without business ownership of their governance and compliance processes. This paper lays out 5 things we must do to ensure our data governance, stewardship and compliance programs are successful.
Creating an Enterprise Data Strategy: Managing Data as a Corporate Asset
ER/Studio 9.0 vs. ERwin r8: An Independent Comparative Study
Deciphering the ACORD XML Standards Finding the Model Within
Considerations: Mastering Data Modeling for Master Data Domains
A Comparative Study of Database Design Tools: Embarcadero ER/Studio and Sybase PowerDesigner
Data Warehousing 2.0 Modeling and Metadata Strategies for Next Generation Architectures
Achieving the Goals of the DoD Netcentric Data Strategy Using Embarcadero® All-Access™
Fast-Tracking Data Warehousing & BI Projects via Intelligent Data Modeling
More and more organizations are recognizing the benefits of data warehouses and their ability to support critical business intelligence initiatives. Yet many DW/BI projects fail due to poor collaboration on business requirements, faulty designs, and lack of solid metadata. Many of these challenges can be overcome through effective data modeling practices and data modeling tools.
White Paper: Building an Enterprise Metadata Repository
Tech Notes: Role-Based Benefits of Buying and Using ER/Studio® Enterprise Portal
Viewpoint: Top Five Reasons to Migrate from CA AllFusion ERwin Data Modeler to Embarcadero ER/Studio
Tech Notes: Migrating from Erwin to ER/Studio Data Modeling Solutions
The dictionary definition of a heuristic is “Computers, Mathematics: pertaining to a trial-and-error method of problem solving used when an algorithmic approach is impractical.” which means this is what you do when you do not know what to do next. The term “normalization” comes from Dr. Codd, who borrowed it from the thencurrent political climate in which we were trying to normalize relations with the Soviet block. The goal is to remove redundancy from a database schema and to have the schema maintain some data integrity without procedural code.
I Do Declare
Most of us began programming in procedural languages. But SQL is a declarative language. Chris Date described the difference as “What, not How” in one of his books. SQL has three sub-languages; the DDL or Data Declaration Language, the DML or Data Manipulation Language and the DCL or Data Control Language.
SQL Syntax Performance.
The 2000 book Me Talk Pretty One Day (ISBN 978-0316777728) is a collection of essays by American humorist David Sedaris. He moved to a rural part of Normandy, France, and had no idea how to speak or read French at the time. The humor comes from his frustrated attempts to learn the language and culture. The locals knew him as the American idiot who scares their animals by screaming. The warning on electrified fences was in French and a great source of amusement for the neighbors
Dr. Codd’s original relational algebra had eight basic operations. Since RDBMS is based on set theory the first four are traditional set operations: intersection, set difference, union and product These operations are available in SQL, respectively, as INTERSECT, EXCEPT, UNION, and CROSS JOIN respectively.
Making Time Using Temporal Data
SQL is the first programming language to have temporal data types in it. If COBOL had done this, we would never have had the "Y2K Crisis" we survived a few years ago. SQL- 92 added temporal data to the language, acknowledging most of what was already in most SQL product by that time. The problem is that each vendor made a trade-off internally. We will get into SQL code later, but since this is an area where people do not have a good understanding, it is better to start with foundations.
EAV of Destruction
If you cruise SQL programming newsgroups, you will eventually find a post for what is called EAV (“Entity-Attribute-Value”) tables. It is a very common schema design error for programmers who started with an OO, work with NoSQL (attribute, value) pairs or a loosely typed programming language.
Cardinality is Not for the Birds
Cardinality has nothing to do with song birds or Catholic church officials. It is a term from set theory that deals with the size of a set. Originally, Georg Cantor invented the term, so that he could talk about infinite sets like integers, real numbers, irrationals, power sets and so forth.
All skewed up
Pick any two positive integers. Add them and get a third number. Then use the last two numbers and do it again. And again, for a long time. Finally, take the ratio of the last two numbers. Without any other information I am sure that ratio will be ~1.618033988749894848204586834. This is called the Golden Ratio or φ, and it works out to (1 + √5)/2. It occurs as a law of nature. Nobody programmed it, per-arranged it or used a magic trick on you.
Demystifying Debugging Techniques with SQL Server
Debugging, though a tough option inside SQL Server, has come a long way with the integration with Visual Studio to make SQL Server Management Studio much more powerful. These additions to SSMS have increased the productivity of Developers and DBA’s alike. This whitepaper introduces you to the debugger techniques introduced with SQL Server 2012.
The DBA and Developer Career Tips eBook
Whether you are preparing for an interview for a new job or vying for the next level within an organization, sometimes it’s hard to know where or how to get started. This eBook provides career tips that are helpful to database professionals that are looking to move their career to the next level.
SQL Server in Simple Words
DBAs face many challenges working with SQL Server. A lot of time is spent managing and troubleshooting this tool and there is not enough time to appreciate or explore what the tool has to offer. In this whitepaper, Pinal Dave shares some of his tips and techniques that utilize some of the capabilities available with SQL Server Management Studio (SSMS) that can help you enhance your productivity.
Avoiding the Top DBA Mistakes
Linchpin People makes a business of performing WellDBA™ exams to help clients troubleshoot and optimize their SQL Server environments. This whitepaper summarizes a few of the top mistakes that they find organizations making. In most cases they are really things that DBAs just may not be aware of.
Nuts and Bolts of Permissions and Security
Security is often an afterthought when it comes to working with Software. In this whitepaper, we will take a tour of some of the basic fundamental blocks that define security inside SQL Server — permissions. We will also look at some of the enhancements introduced from a security point of view with SQL Server.
Zero to Hero with SQL Server Management Studio
Developers or DBA have an natural inclination to work with SQL Server Management studio day-in day-out. Lesser known to then is the fact, how cool and productive their tool can be. This white paper will show some of the top 12 cool tips for working with a SQL Server management studio that you always wanted to know.
SQL Server Security Practices
This paper outlines the security features introduced with SQL Server 2014. Have you ever wanted to keep an Administrator locked out? Did you have a scenario where you wanted to give only limited read access to the whole server for people like Auditors? This whitepaper fill focus on these topics extensively.
Blocking and Locking - Troubleshooting in SQL Server
Locking and blocking are fundamental to any database to maintain consistency. In this paper we will look at the various ways to identify potential problems of locking and blocking, how they are different and what options SQL Server gives to resolve them.
The High Performance Sybase ASE DBA - Managing Multiple Database Platforms for Performance & Availability
Sybase ASE DBAs have always tackled complex tasks amidst shifting priorities, and pressures only continue to mount. This paper outlines trends impacting Sybase ASE DBAs and teaches techniques critical to streamline and automate database management.
High Performance DB2 DBA
As a DB2 DBA, you are expected to keep key database systems available and optimized for high performance. This paper details techniques to streamline and automate the management of critical areas required for high database performance and availability -- regardless of the database type or version.
Top 10 Considerations for Choosing Database Tools – Beyond the Feature Matrix
Learn how considering just the feature matrix for a database tool is a mistake. This top 10 guide provides valuable insights that can directly impact your personal productivity (and sanity).
The Changing Role of the DBA
Data is everywhere. Databases are growing at exponential rates across the globe, and someone has to manage the chaos. This is happening as new competitive pressures are forcing companies to continually streamline workforces.
But what does this mean for today’s DBAs? Find out in this whitepaper on The Changing Role of the DBA.
Ten Question to Consider When Choosing an Embedded Database
This paper examines some of the features that are crucial to the success of developing with and deploying an embedded database. It will highlight key features of InterBase® and contrast InterBase with other database alternatives for embedded applications. While large enterprises require complex database management systems that can support thousands of users, manage terabytes of data, and need a highly trained support staff, The requirements for an embedded database are quite different from those of an enterprise DBMS.
5 Steps to Effective SQL Load Testing
This technical paper from Embarcadero will help you develop application code that is production ready by exploring best practices in a five-step load testing workflow.
Top Data Management Trends to Watch in 2012
A new year brings with it a new set of business challenges as wellas fresh opportunity for forward-thinking companies to navigate anincreasingly complex data management landscape.
Maximizing Oracle Database Performance and Minimizing Licensing Costs in Virtualized Environments
The High Performance DBA Series Best Practices for Managing Multiple Database Platforms for Performance & Availability
Writing Optimal SQL
In this whitepaper, Jonathan Lewis shows you his highly-evolved strategy for writing more efficient SQL.
Viewpoint: Performance Optimization: Extending the IT Infrastructure
Optimizing System Performance Using Prevent, Find, and Fix Methodologies Embarcadero Technologies
Tech Notes: Reducing the Time and Costs Associated with Sarbanes-Oxley Compliance
Using Modern Database Management Tools to Simplify and Streamline SOX Compliance
White Paper: Ringing the Changes for Change Management
As modern database change management techniques for the Sybase DBA become more sophisticated, there is an inherent need for practitioners to be aware of the increasingly powerful tools available to them.
Tech Notes: The High-Performance DBA Optimizing you Database and Your Time for Higher Performance
White Paper: Java Development Productivity and Quality using Eclipse: A Comparative Study of Commercial Eclipse-based IDEs
The productivity benefits of using commercial Eclipse-based Java IDE products from IBM (IBM Rational Application Developer), Genuitec (MyEclipse), and CodeGear (JBuilder) compared to the freely downloadable baseline Eclipse configuration.
Tech Notes: InterBase® SMP: Proven, Low-Cost Database for Your Business
InterBase® SMP: Safeguarding Your Data from Disaster
2020 Top 5 Market Trends Impacting Software Development Companies
The first requirement for any software house is to build the internal capabilities that allow them to rapidly reach the customer with the user experience expected. Once they can target their customers devices, they can then plan and develop the applications and architectures to base their business upon.
To be clear, this paper isn’t here to talk about internal development practices, because regardless of your approach to development, the aim is the same: To ensure your apps compile, are secure, run and look good on your customers systems. Instead, this paper will look at the market trends that are important to maintaining the internal capabilities for delivering software to end users.
Discovering the Best Developer Framework
This whitepaper evaluates three frameworks for Windows application development - Delphi, Windows Presentation Foundation (WPF) with the .NET Framework, and Electron.
Object Pascal Handbuch von Marco Cantù
This newly updated 500-page e-book is a complete guide to the current, modern Object Pascal programming language by best-selling Delphi books author and Delphi Senior Product Manager, Marco Cantú.
Microservices als Basis moderne Anwendungsarchitekturen
API-Services sind die Grundlage moderner verteilter Applikationen.Microservices gelten heute als Basis moderner Anwendungsarchitekturen. Statt einer monolithischen und schwerfälligen Software wird die gesamte Funktionalität auf überschaubare Teilsysteme verteilt. Die entstandenen Services werden dann üblicherweise über das Internet und RESTful APIs zur Verfügung gestellt.
In diesem Whitepaper erfahren Sie wie Sie mit RAD Studio und dem RAD Server vom Client bis zum Backend mit einer technologischen Basis arbeiten. Das ist effizient und bedeutet Wettbewerbsvorteile durch eine Verringerung der Time-To-Market.
Breathe New Life Into Applications with These Modernization Tips
Erfahrene Entwickler wissen, dass die Bindung von Benutzern an ihr Produkt eine Herausforderung sein kann. Deshalb investieren sie kontinuierlich in ihre Anwendungen, um sie schneller, funktionaler und benutzerfreundlicher zu machen. Vom dafür erforderlichen Aufwand profitiert nicht nur der Benutzer. Die Bereinigung von nicht benutztem und ineffizientem Programmcode vereinfacht auch die Weiterentwicklung von Anwendungen für jeden Entwickler.
Read this whitepaper to learn how modern market trends are putting pressure on stable legacy applications, and what you can do to stay relevant and future-proof your applications.
Teamzusammenarbeit in den Vorgehensmodellen der Softwareentwicklung
Optimieren Sie Ihre Entwicklung durch verschiedene Vorgehensmodelle bei der Zusammenarbeit im Team
Sie lernen die verschiedenen Methoden und die verfügbaren Tools kennen, die für die Zusammenarbeit zwischen Entwicklungsteams, Designern, Fachabteilung und QA-Teams sinnvoll sind, um schnellere Release-Zyklen ohne Qualitätseinbußen zu erzielen.
- Verkürzen Sie die Software-Release-Zyklen
- Verbessern Sie die Kommunikation zwischen Design und Entwicklung
- Integrieren Sie Test und Qualitätssicherung in den Entwicklungszyklus
- Erfahren Sie, mit welchen Tools die Kommunikation zwischen Teams verbessert werden kann
Smart Cross-platform App Development: Single Codebase And Native Apps
Enter the mobile world with less development work
The use of smartphones and tablets has become more popular over the years. This applies both to the private sector and the corporate environment. The typical target platforms, which differ considerably in technical terms, are iOS and Android. Learn in this whitepaper how the mobile worlds are already growing together in design and development.
Windows 10: The Big New Opportunity for Developers
Learn why Windows 10, the most significant PC release in many years, is a big opportunity for software developers. Gain an understanding of how RAD Studio developers are ideally placed to take advantage of Windows 10 and why now is the time to prepare for new ways of developing and deploying Windows applications.
Einfache Rückverfolgung von Datenänderungen mit InterBase Change Views
The new InterBase® patent pending feature “Change Views” introduces a new approach to tracking data changes (with field level granularity) in server as well as personal computer/tablet/mobile databases. It is designed for today’s mobile centric world. Furthermore, Change Views offer developers a way to break traditional constraints in their thinking about data change tracking and the life span of data in briefcase models. Through its Change Views technology, InterBase provides easy access to a highly scalable change-tracking engine that developers can easily mold to fit their requirements, regardless of whether they need to keep 1 or 100,000 destinations up-to-date.
Mobilität für Ihr Unternehmen mit Enterprise Mobility Services Middleware
Enterprise Mobility Services (EMS) is a multi-tier framework that first shipped with RAD Studio XE7. This white paper is designed to provide you, the software professional, with the information you need to get started with EMS today. You will learn how EMS interfaces with the various technologies necessary to support your applications, and why this approach is so valuable in today's distributed computing landscape. The paper continues by showing you how to get started with your EMS development including how to install EMS and make basic calls into this service. Importantly, these calls are standard REST REpresentational State Transfer) calls, which can be emitted by any language or framework that understands HTTP (HyperText Transfer Protocol). After a brief discussion of REST, you will learn how to make some of these basic calls using a browser, RAD Studio's REST Debugger, and a Delphi application.
Developer Survey Reveals Shift Toward Internet of Things Business Solutions in 2015
A global survey, sponsored by Embarcadero Technologies, reveals 2015 will be a big year for developing business solutions with integrated “Things” – such as industrial sensors, drones, health monitors and smart buildings. The majority (84%) of software developers building IoT solutions in 2015 are targeting business markets, while only 16% are exclusively targeting consumers.
Checklist: 5 Essential BaaS Features Every Mobile App Needs
Today, apps are connected with an expectation to easily store information across multiple platforms and devices while still providing immediate and instant access to the user’s data and files. Whether you’re building a new app or updating an existing one, add these 5 BaaS features to your app and you will drive an increase in user engagement and retention.
Filtern nach Tool
- RAD Studio