| CHANNEL: Data Modeling |
 |
Oracle Application Express Release 4.0 Now Available
Aimed at further streamlining the development of database-centric web applications, Oracle has introduced Oracle Application Express Release 4.0. The new release helps reduce the time and complexity of building opportunistic Web 2.0 applications and reports. Oracle Application Express (APEX) is a feature included at no additional cost with all editions and releases of Oracle Database 11g. The 4.0 release helps reduce the time and complexity of building opportunistic Web 2.0 applications and reports, and is available now for download from the Oracle Technology Network (OTN).
News Flashes,
5MB: Information Management -
June 29, 2010 Issue
|
|
|
Embarcadero Unveils Rapid SQL XE
Embarcadero Technologies has released Rapid SQL XE, the latest version of its integrated development environment (IDE) that enables developers and database administrators (DBAs) to produce high quality SQL code faster. Rapid SQL XE includes direct native support for heterogeneous database environments from a single user interface, and debuts support for Embarcadero InterBase and the open source Firebird database, in addition to full Unicode support.
News Flashes,
5MB: Oracle -
May 19, 2010 Issue
|
|
|
Embarcadero Releases Rapid SQL XE
Embarcadero Technologies has released Rapid SQL XE, the latest version of its integrated development environment (IDE) that enables developers and database administrators (DBAs) to produce high quality SQL code faster. Rapid SQL XE includes direct native support for heterogeneous database environments from a single user interface, and debuts support for Embarcadero InterBase and the open source Firebird database, in addition to full Unicode support.
News Flashes,
5MB: Information Management -
May 11, 2010 Issue
|
|
|
The Simple and Ubiquitous Reference Table
It is rare to find an implemented database devoid of reference tables. Reference tables provide valid values for drop-down lists and in a slightly obtuse way, also allow for expression of a domain or user-defined data type within the database design. Nominally a reference list is but a list of values to be referenced. In practice, the implemented structure of a reference table is driven by small nuances regarding how each list is used. The signifiers may consist of a code or number that creates a short-hand way of expressing a state or value. Yet in addition to such simple codes, a "medium length" name column or even a column to contain a lengthy text description should exist in support of these codes. The names may be used in drop-down lists so that people need not memorize many code values, and the descriptions can assist help-functions by providing users with more understanding of a value's meaning or intended use. For operational applications it may be worthwhile to have an attribute expressing the order in which items should be displayed, unless alphabetical display is a preference. If codes are maintained via online screens, an indicator may be helpful in flagging values that are part of the system and not to be removed or deactivated via those online screens.
Database Elaborations,
DBTA E-Edition -
May 2010 Issue
|
|
|
Sybase Delivers Record First Quarter Results
Sybase reported financial results for the first quarter ended March 31, 2010. "We are off to a very good start this year," stated John Chen, chairman, CEO and president of Sybase, during a conference call last week. "We are very pleased to report our 10th consecutive record quarter. The highlights include historical first quarter highs in revenue, operating margin, earnings and cash flow. We also have double digit growth in total revenue as well as license growth and message revenue growth."
News Flashes,
5MB: Sybase -
April 28, 2010 Issue
|
|
|
Developer Days Seminars Coming Up in May
Sybase technical experts are planning a series of Developer Days throughout the United States and Europe to showcase the latest releases of its industry-leading development software. All seminars are free and run from 8:30am - 2pm local time (timing may vary slightly by location) with breakfast and lunch included.
News Flashes,
5MB: Sybase -
April 28, 2010 Issue
|
|
|
Oracle AIA Foundation Pack 11gR1 Now Available
Oracle also announced Oracle Application Integration Architecture (AIA) Foundation Pack 11gR1. Oracle AIA provides an open, standards-based approach for organizations to integrate cross-application business processes, leveraging a broad range of custom, Oracle or third-party applications, while gaining efficiencies, increasing competitive edge and enabling lower total cost of ownership.
News Flashes,
5MB: Oracle -
April 21, 2010 Issue
|
|
|
Toad for Oracle Offers New Automation Capabilities
At COLLABORATE 10 this week, Quest Software has been showcasing a new release of Toad for Oracle that provides greater automation in Oracle development, administration, and query and reporting. Toad for Oracle 10.5 builds upon the next-generation enhancements of Toad 10, saving money for the organization and time for the end user.
News Flashes,
5MB: Oracle -
April 21, 2010 Issue
|
|
|
Quest Software Announces Toad Extension for Visual Studio
Quest Software, Inc., a Visual Studio Industry Partner and maker of Toad for Oracle, has announced the launch of Toad Extension for Visual Studio. Toad Extension for Visual Studio is a database schema provider that will support complete application lifecycle management (ALM) for Oracle in Visual Studio 2010, unifying Oracle developers with the rest of the Visual Studio development team.
News Flashes,
5MB: Oracle -
April 21, 2010 Issue
|
|
|
Breaking News — Sybase Announces GA of PowerBuilder 12
Sybase today announced the availability of Sybase PowerBuilder 12. The new release of Sybase's rapid application development tool enables developers to easily and cost effectively create or migrate their business applications on the Microsoft .NET Framework, for modern and visually appealing application user experiences. Sybase today announced the availability of Sybase PowerBuilder 12. The new release of Sybase's rapid application development tool enables developers to easily and cost effectively create or migrate their business applications on the Microsoft .NET Framework, for modern and visually appealing application user experiences.
News Flashes,
5MB: Information Management -
April 20, 2010 Issue
|
|
|
|
|
|
Clarity is Harder than it Seems
Far too often we all talk past one another. This cross talking, while not always drastic, remains perceived as an understood fuzziness. Much of the time we ignore these minor miscommunications because precision and clarity are not necessarily critical in all situations. If the general gist is effectively understood between those communicating, that generality may be all that is necessary. Those involved in the communication may feel comfortable that assumptions made to "fill in the gaps" will fall within an acceptable range. Although the lack of clarity in the message communicated may be acceptable, in other circumstances it may not be acceptable.
Database Elaborations,
DBTA E-Edition -
April 2010 Issue
|
|
|
Oracle Unveils Oracle’s AutoVue 20.0
Oracle has announced AutoVue 20.0, the first release of the product planned from day-one under Oracle ownership. AutoVue joined Oracle as part of the Agile acquisition in 2007 and solves one central challenge, Thierry Bonfante, director product strategy for Oracle's AutoVue solutions, tells 5 Minute Briefing. "What we provide is a way to open any files, any documents that have been generated by any applications whether it is very simple applications like Microsoft Office or TIFF [Tagged Image File Format] or JPEG [Joint Photographic Experts Group] up to the very advanced 2D and 3D CADs [computer aided designs] that are used in aerospace and defense, construction, utilities, oil and gas."
News Flashes,
5MB: Oracle -
April 7, 2010 Issue
|
|
|
|
|
|
|
|
|
Software AG Introduces NaturalONE
Software AG has introduced NaturalONE, a new Eclipse-based toolset for enterprise application development. NaturalONE is an IDE that lets developers code and test applications (using the Natural language), expose Natural objects as web services, and create rich web interfaces for their applications. In this way, NaturalONE lets the developer produce applications that not only support enterprise SOA and BPM, but also appeal to business users outside the IT group.
News Flashes,
5MB: Oracle -
March 17, 2010 Issue
|
|
|
Progress Software Launches Progress Responsive Process Management Suite
Progress Software Corporation yesterday announced the launch of a new business solution intended to enable enterprises to improve business performance. The solution, Progress Responsive Process Management suite (RPM), combines comprehensive visibility, business event processing and business process management (BPM) capabilities on a single, unified platform. "The reason we've created this suite is in response to what we have been seeing in our customer base. Our customers want to gain what we call ‘operational responsiveness.' In other words, to have a business that is highly adaptive, can anticipate opportunities and threats, and respond before they have been missed, or before it is too late," Dr. John Bates, Progress Software CTO, tells 5 Minute Briefing.
News Flashes,
5MB: Information Management -
March 16, 2010 Issue
|
|
|
IBM Extends Development and Test to the IBM Cloud
IBM today announced plans to go online with its commercial cloud service for software development and testing. IBM, which already delivers a test and development cloud, is now allowing enterprise and government clients to test and develop on an IBM Cloud. According to IBM, the average enterprise devotes up to 50% of its entire technology infrastructure to development and test, but typically up to 90% of it remains idle. IBM's approach to cloud is intended to complement clients' current data centers and traditional development efforts.
News Flashes,
5MB: Information Management -
March 16, 2010 Issue
|
|
|
Pegasystems to Acquire Chordiant Software
Pegasystems Inc., a provider of business process management (BPM) software solutions, and Chordiant Software, Inc., a provider of customer relationship management (CRM) software and services, have announced they have entered into a definitive agreement for Pegasystems to acquire Chordiant. Under the terms of the agreement, Pegasystems will make a cash tender offer of $5.00 per share for all outstanding shares of Chordiant common stock for a total purchase price of up to approximately $161.5 million, assuming all outstanding shares are tendered. The transaction is subject to customary closing conditions, including regulatory approvals, and is expected to close in Q2 2010.
News Flashes,
5MB: Information Management -
March 16, 2010 Issue
|
|
|
RocketU2 Offers Webinars for SB/XA Product
Rocket Software is planning a complimentary webcast series focused on the latest release of RocketU2 SystemBuilder Extensible Architecture (SB/XA). SB/XA is a Rapid Application Development (RAD) and deployment environment delivering 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 -
March 2010 Issue
|
|
|
Keys Are Keys and Indexes Are Indexes
Primary keys come from candidate keys. Each candidate key consists of the attribute or attributes used to label a distinct row in a table. Every candidate key should contain the fewest number of attributes possible to identify rows individually and uniquely. Every entity within a design requires at least one candidate key.
Database Elaborations,
DBTA E-Edition -
March 2010 Issue
|
|
|
|
|
|
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
|
|
|
| Pages: 1 2
Next >> |
|
|
|