| CHANNEL: Data Modeling |
 |
Rocket Software Unveils SB/XA Personal Edition
Rocket Software has announced that a new version of the SystemBuilder Extensible Architecture (SB/XA) Personal Edition is available for customers now using Personal Editions of UniData or UniVerse. This new version incorporates all the features and benefits provided in SB/XA 6.0.1. SB/XA 6.0.1, released in November 2009, is designed to maximize its customers' investments in U2 technology. SB/XA is a Rapid Application Development (RAD) and deployment environment that delivers up-to-the-minute interface design and portable reporting capabilities. Existing SB+ applications can automatically convert without requiring changes to the underlying code.
MV Community,
DBTA E-Edition -
February 2010 Issue
|
|
 |
|
|
 |
Creating Analytical Data Models
Designing a data model that supports the reporting and analytical functions is no different, initially, than any other modeling effort. Understanding the data is crucial. The data architect or modeler needs to feel comfortable with dimensional modeling techniques and needs to obtain a working knowledge of the universe of discourse for the subject-at-hand. A good start in gathering this knowledge begins by reviewing the operational data structures containing the identified source elements. The challenge in designing analytical solutions is found in applying best practices for analytics simply and effectively.
Database Elaborations,
DBTA E-Edition -
February 2010 Issue
|
|
 |
|
|
 |
Progress Software Buying Savvion
Progress Software Corporation, a provider of enterprise operations software, announced yesterday at its Global Field Operations Conference the acquisition of Savvion Inc., a privately held business enterprise software company based in Santa Clara, Calif., for approximately $49 million, net of cash acquired.
News Flashes,
5MB: Information Management -
January 12, 2010 Issue
|
|
 |
Creating Operational Data Models
The process for designing a database that supports the operational functions of an organization begins with simple understanding. The data architect or modeler needs to obtain a working knowledge of the language comprising the universe of discourse for the solution. This awareness is gathered through many activities, such as talking with the people currently doing the work, sitting with them and watching how they do their tasks, reading over existing training manuals or standard operation procedures. The designer is best served when figuratively walking a mile in the shoes of the future application users. The more that the designer knows about the user needs and goals, the better able the designer is to definitively craft a data model supporting user tasks.
Database Elaborations,
DBTA E-Edition -
January 2010 Issue
|
|
 |
Oracle SQL Developer 2.1 Increases DB Developer Productivity
To further enhance developer productivity and simplify Oracle Database development, Oracle announced the availability of Oracle SQL Developer Release 2.1, the latest release of the free database development and migration tool. Oracle SQL Developer Release 2.1 introduces two key capabilities—PL/SQL Unit Testing and Data Modeler Viewer — in addition to enhancements to the software overall.
News Flashes,
5MB: Oracle -
January 6, 2010 Issue
|
|
 |
IBM Linux Developer and Test Cloud Webcast on December 17
Looking for an easier way to develop and test applications? Join IBM on Thursday, December 17, 2009, at 12pm ET to hear how Linux and IBM software can expedite the development and test of applications in the cloud More than just a presentation, this webcast will take you from the theory of cloud computing to practice in a few simple steps and give you the confidence to explore cloud computing further with the IBM Smart Business Development and Test on the IBM Cloud.
Inside Linux at IBM,
Linux Executive Report from IBM -
December 16, 2009 Issue
|
|
 |
Yes, Data Modeling Matters
In composing a data model, the structures are put together thoughtfully and with intention. Data structures emerge from the application of semantics germane to the universe-of-discourse and filtered through the rules of normalization. Each table expresses meaning, with columns that are self-evident. The best models reduce the data items within the covered subject area into obvious arrangements. However, this simplicity often confuses observers, persuading many that modeling itself must therefore be a simple task. DBMS tools often incorporate wizards that facilitate the quick definition of tables which are then immediately created within the chosen database. These tools enable the developer to build tables in the blink of an eye. At times some prototypes are approached in this fashion, and while this provides for placeholders, such slapped-up table structures are insufficient for an industrial strength solution. Under these instant-table setups, developers often have no problem reworking large sections of code for minor changes, or misusing data elements to mean many things while making the determination of meanings at a specific point-in-time less clear. Unaware of these less-than-stellar consequences, users become confused; they often wonder why modeling tasks should ever need to be done because the proof of concept worked, didn't it?
Database Elaborations,
DBTA E-Edition -
December 2009 Issue
|
|
 |
IBM Introduces New Offerings for Software Development in the Cloud
Underlining the value of a leveraged development model and a growing appreciation of the fact that it is not necessary for all applications and products to be built from the ground up, a new study finds that businesses and organizations implementing multi-source development with open source software benefit from significant cost savings and improved application development efficiencies. The survey of enterprise development organizations was conducted by Black Duck Software, a global provider of products and services for accelerating software development through the managed use of open source software.
Linux News,
Linux Executive Report from IBM -
November 18, 2009 Issue
|
|
 |
Altova Releases Version 2010 of its MissionKit Development Tools Suite
Altova has announced the availability of Version 2010 of the Altova MissionKit, an integrated suite of XML, database, and UML tools. Version 2010 delivers a large number of new features across the product line for XML editing, data mapping, visual stylesheet designing, UML modeling, database schema analysis, and comparing and merging XML and database content.
News Flashes,
5MB: Sybase -
November 18, 2009 Issue
|
|
 |
|
|
 |
Smart Business Development and Test on the IBM Cloud Now Available in Public Beta
In June of this year, IBM unveiled its cross-company strategy to capture the enterprise cloud computing market, helping clients attack rising costs and complexity by workload. Since then many products and services from the portfolio have entered the market, including Smart Business Development and Test on the IBM Cloud, which began its public beta on October 1, 2009. Smart Business Development and Test on the IBM Cloud includes Software Delivery Services from Rational Software and is designed to accelerate organizations' development and test cycles.
Linux News,
Linux Executive Report from IBM -
October 21, 2009 Issue
|
|
 |
Breaking News—BMC to Acquire Provider of IT Discovery Solutions
BMC Software announced today that it has entered into a definitive agreement to acquire privately-held Tideway Systems Limited, a provider of IT discovery solutions. The acquisition is intended to enhance BMC's Business Service Management (BSM) platform and help organizations minimize the risks associated with business-critical initiatives such as data center consolidation, virtualization and compliance. BMC expects the transaction to close within the week.
News Flashes,
5MB: Data Center -
October 19, 2009 Issue
|
|
 |
|
|
 |
|
|
 |
Wanting to Believe
New data modelers often see things as black and white. But rather than being concrete flooring beneath our feet, knowledge is more like a gossamer web that builds up layer upon layer to provide the effect of a solid foundation. We may think we know facts, such as one plus one equals two, or Columbus discovered America in 1492. What we have come to know about our world comprises our own internal knowledge base. We gain much of this knowledge because it has been passed onto us by others, people with experience, parents, educators, clever friends, verbally or in print. But how do we know such items are real, actual, absolute bona fide beyond-a-shadow-of-a-doubt truths?
Database Elaborations,
DBTA E-Edition -
August 2009 Issue
|
|
 |
Quest Software Announces Open Betas for Toad for Oracle 10 and DSP for Oracle
Quest Software recently announced the forthcoming release of Toad for Oracle version 10, the de-facto standard tool for Oracle database development and administration. Toad for Oracle 10 will offer new functionality enhancements that the Toad community has been asking for, providing improved productivity, better database manageability and easier access to educational resources. Toad for Oracle 10 is the culmination of suggestions gathered from the Toad community's "wish list," incorporating many enhancements in the areas of usability, automation, education, and flexibility.
News Flashes,
5MB: Information Management -
July 28, 2009 Issue
|
|
 |
The Escalating Necessity for Good Database Design
While good database design is always necessary, the value of good design is reinforced by such endeavors as service-oriented architecture. The semantics-laden engineering of service-oriented tactics used in creating solutions melds seamlessly into the semantics-laden world of data modeling. Although one aspect does not necessarily build on top of the other, each works as part of a team in braiding solutions that grow in usefulness as they emerge. The processes surface as a method to further define the meaning of an object, and the object serves as a harbinger of the processes that must exist. Business rules much more advanced than today's simple constraints may one day reside within the database itself as a built-in function of a some future DBMS. Therefore, data architects should never try to wall themselves behind a veneer of thinking only in terms of data without a thought regarding the processes that touch the data. As a database designer, working within projects that use service-oriented architecture approaches can be exhilarating.
Database Elaborations,
DBTA E-Edition -
July 2009 Issue
|
|
 |
|
|
 |
|
|
 |
Data Virtualization: An End-to-End Process Approach

Enormous data volumes in complex systems exacting high total cost of ownership (TCO) are endemic in today's enterprises. Must this always be the case? Not for enterprises and agencies using today's advanced data virtualization to simplify data complexity and reduce costs, time to solution and risk.
Trends and Applications,
DBTA E-Edition -
June 2009 Issue
|
|
 |
|
|
 |
Digging Deeper into Many-To-Many Relationships
An inherent awkwardness exists in every many-to-many relationship between entities. Ambiguity causes this persistent awkwardness, primarily because a many-to-many relationship is such a fuzzy thing. In data discovery, encountering many-to-many relationships may actually expose a level of disregard about details by the subject matter experts.
Database Elaborations,
DBTA E-Edition -
May 2009 Issue
|
|
 |
Foreign Keys to the Kingdom
In a relational database approach, regardless of whether one is considering persisted data or transitory query results, almost everything is viewed as a logical table. Associations between these envisioned tables are based on data values, versus the alternative to the pre-relational idea of linking multiple data structures via "hidden" pointers maintained by the system. Relationships among objects are ultimately derived from the semantics of a situation.
Database Elaborations,
DBTA E-Edition -
April 2009 Issue
|
|
 |
Embarcadero Finds DataRage Virtual Event Answers Real Need
Embarcadero Technologies recently held DataRage, three days of online technical sessions and a virtual trade show targeted at DBAs, data architects, database developers, security experts, and other database professionals, and found that the virtual approach was the right one for the times, according Greg Keller, chief evangelist, at the company. The online event was held March 17 through March 19.
News Flashes,
5MB: Information Management -
March 31, 2009 Issue
|
|
 |
The Future of Coding for SQL Server, Part 2
In my last column (published in the February e-edition and the March print edition of DBTA), I reviewed the overall coding landscape for SQL Server with special focus on LINQ to SQL, a new technology introduced by Microsoft in late 2008. LINQ to SQL promised to make developers' lives much easier by allowing them to focus on writing programs in their favorite Visual Studio language and letting LINQ to SQL write all the Transact-SQL code. The problem is that LINQ to SQL writes very bad Transact-SQL code.
SQL Server Drill Down,
DBTA E-Edition -
March 2009 Issue
|
|
 |
The Mysteriously Hidden Order of the Database
In formulating the tenets of relational theory, issues anent to order were explicitly addressed. These relational theory tenets included defining a relational database so that it need have no concern with the order of columns in a row, or with the order of rows in a table. And yet, such a stance seems counter-intuitive since the database brings structure and organization to content. Chaos is the primordial soup from which all things originated. Thus it seems only reasonable that a relational database, being the best and brightest of its kind, should abhor such chaos and bring ever more order instead, right?
Database Elaborations,
DBTA E-Edition -
March 2009 Issue
|
|
 |
|
|
 |
| Pages: 1 2
Next >> |
 |
|
|