|
PowerBuilder, sometimes abbreviated PB, is a computer application development system created by Powersoft, which was later purchased by Sybase. Touted as a Rapid Application Development (RAD) system, it includes tools for drawing the user interface and reports, and accessing database content. The tools are provided in an integrated development environment that is the application developer's interface to the capabilities of the system. In software engineering, software maintenance is the process of enhancing and optimizing deployed software (software release), as well as remedying defects. ...
Sybase Inc. ...
A software release refers to the creation and availability of a new version of a computer software product. ...
August is the eighth month of the year in the Gregorian Calendar and one of seven Gregorian months with the length of 31 days. ...
For the Manfred Mann album, see 2006 (album). ...
A software release refers to the creation and availability of a new version of a computer software product. ...
August is the eighth month of the year in the Gregorian Calendar and one of seven Gregorian months with the length of 31 days. ...
For the Manfred Mann album, see 2006 (album). ...
An operating system (OS) is a set of computer programs that manage the hardware and software resources of a computer. ...
Microsoft Windows is the name of several families of proprietary software operating systems by Microsoft. ...
An integrated development environment (IDE), also known as integrated design environment and integrated debugging environment, is a type of computer software that assists computer programmers in developing software. ...
A software license is a legal agreement which may take the form of a proprietary or gratuitous license as well as a memorandum of contract between a producer and a user of computer software. ...
This article or section does not adequately cite its references or sources. ...
A website (or Web site) is a collection of web pages, images, videos and other digital assets and hosted on a particular domain or subdomain on the World Wide Web. ...
Sybase Inc. ...
// [edit] History Application Development refers to the developing of programming applications and differs from programming itself in that it has a higher level of responsibility, including for requirement capturing and testing. ...
An integrated development environment (IDE), also known as integrated design environment and integrated debugging environment, is a type of computer software that assists computer programmers in developing software. ...
Features
PowerBuilder has a native data-handling object called a DataWindow, which can be used to create, edit, and display data from the database. This object gives the programmer a number of tools for specifying and controlling user interface appearance and behavior, and also provides simplified access to database content. To some extent, the DataWindow frees the programmer from considering the differences between Database Management Systems from different vendors. A database management system (DBMS) is a computer program (or more typically, a suite of them) designed to manage a database, a large set of structured data, and run operations on the data requested by numerous users. ...
PowerBuilder also includes a scripting language, PowerScript, which is used to specify the application behavior when events occur. Events usually correspond to user actions, such as clicking on an element of the user interface, or closing a window.
As of July 2006, the latest release of PowerBuilder is version 10.5. It includes DataWindow.NET, which is a .NET-enabled version of PB's DataWindow control. PowerBuilder 11.0 is expected in the first quarter of 2007, and is planned to include ASP.NET 2.0 Web Forms application capability.[1] July is the seventh month of the year in the Gregorian Calendar and one of seven Gregorian months with the length of 31 days. ...
For the Manfred Mann album, see 2006 (album). ...
Microsoft . ...
Active Server Pages (ASP) is Microsofts Server-side script engine for dynamically-generated web pages. ...
Usage PowerBuilder is used primarily for building business applications. There are also versions of PowerBuilder that can be used to build applications to run on mobile devices such as cell phones or PDAs.
PowerBuilder is used commonly by companies in the financial sector, in the United States, Canada, and the United Kingdom. It is also used by many government agencies. Although PowerBuilder's day as a major development tool has passed, it remains in use at hundreds of organizations around the world.
Language advantages The PowerScript language supports Object-Oriented features of Inheritance, Polymorphism, and Encapsulation, but it doesn't let you inherit from DataWindow, which is the main window that applications use. Powerscript do not force you to use them. This gives developers the power of OO with the flexibility to develop using your own strategy. Some developers use a framework, such as PowerBuilder Foundation Classes (PFC) [2], and inherit all their objects, such as windows, from it. In computer science, object-oriented programming, OOP for short, is a computer programming paradigm. ...
In object-oriented programming, inheritance is a way to form new classes (instances of which are called objects) using classes that have already been defined. ...
In simple terms, polymorphism lets you treat derived class members just like their parent classs members. ...
In computer science, the principle of information hiding is the hiding of design decisions in a computer program that are most likely to change, thus protecting other parts of the program from change if the design decision is changed. ...
The DataWindow is the key component which makes PowerBuilder so powerful. The DataWindow offers a powerful, visual SQL painter which supports Outer Joins, Unions and subqueries. It can convert SQL to Visual representation and back, so the developer can use native SQL if desired. DataWindow updates are automatic -- it produces the proper SQL at runtime based on the DBMS to which you are currently connected. This feature saves the developer from a very tedious chore. SQL (commonly expanded to Structured Query Language — see History for the terms derivation) is the most popular computer language used to create, retrieve, update and delete (see also: CRUD) data from relational database management systems. ...
The DataWindow also has the built-in ability to both retrieve data and update data via Stored Procedures. The user picks the Stored Procedure from a visual list.
In fact, the Datawindow itself is so powerful, many PowerBuilder applications have no framework, or only use inheritance in a limited way, because it is not necessary.
Another key strength is its database connectivity. PowerBuilder offers native interfaces to all major databases, as well as ODBC and OLE-DB, in the Enterprise version. PowerBuilder applications tend to support multiple databases with relative ease. There are many sophisticated connectivity options, such as: Open Database Connectivity (ODBC) is a standard software API for connecting to database management systems (DBMS). ...
OLE DB (sometimes written as OLEDB or OLE-DB), Object Linking and Embedding for Databases, is a means Microsoft use for accessing different types of data stores in a uniform manner. ...
1. Asynchronous operations (so a long-running query won't "lock up" the application) 2. Static Binding on or off 3. Integrated Security 4. Tracing of all SQL 5. Isolation Level 6. Password Expiration Dialog 7. Blocking Factor 8. Number of SQL statements to Cache 9. Use Connection Pool 10. Thread Safe 11. Trace ODBC API Calls As a result of its sophisticated connectivity, and the efficiency of the DataWindow, PowerBuilder applications have been observed to outperform many other competing applications in terms of the number of seconds it takes to retrieve data from a database and display it to the user.[citation needed] Updates are also trivial to code in most cases (1 to 4 lines of code), and run extremely quickly. Here is a sample PowerBuilder update script:
dw_1.AcceptText() dw_1.Update()
PowerBuilder supports the following ways of interacting with a database:
1. DataWindow This is the simplest, most powerful, and usually the fastest at runtime.
2. "Embedded SQL" This is a standard which, surprisingly, is not supported by some big-name development environments. Embedded SQL supports SELECT, INSERT, UPDATE, DELETE and cursors. It is a convenient way to do a simple update. Example:
UPDATE my_employee SET STATUS = 'A'; IF sqlca.sqlcode<>0 THEN ...
3. "Dynamic SQL" This is offered in 4 formats. The user builds a string which may optionally have bind variables. You may use Dynamic SQL to create cursors as well.
PowerBuilder supports Active-X and OCX controls, both visible and non-visible. It also can use OLE Automation as a client. However, PowerBuilder supports only late binding, not early binding. Therefore, when using OLE Automation, you don't get a dropdown of possible actions. PowerBuilder can be a DDE client or server. This allows it to interoperate with other applications. Object Linking and Embedding (OLE) is a distributed object system and protocol developed by Microsoft. ...
PowerBuilder can make Windows and third-party API calls, and, in general, works well with third-party libraries in DLL files, however it does not directly support callback functions.
PowerBuilder offers a "/pbdebug" runtime switch, which creates a log file. This can help track down a bug "in the field", as the user simply emails this log file to the developer. It has another feature which can log all SQL statements to a file. It also has built-in performance profiling, an integrated debugger, context-sensitive help, and an active newsgroup to provide support.
PowerBuilder applications are typically compiled to p-code, which is then interpreted by the PowerBuilder runtime. Although it can be compiled to machine code (called c-code), a typical business application does not run any faster. Only applications which do an unusually large amount of computations with little I/O are likely to benefit from compiling to machine code.
Critique Although PowerBuilder can work well for quickly developing very large applications with enterprise-level databases, the deployment to machine code (c-code) for such application might take a considerable amount of compilation time by the developer. However, there is rarely a need for a developer to compile a PowerBuilder application to machine code, as PowerBuilder applications are typically deployed as interpreted code (p-code). The developer will ordinarily choose to deploy compiled p-code libraries (.pbd files) as separate files from the executable. Much like .dll's, this allows for application updates to consist of migrating only a single affected library. Even if it is desired to deploy an application to machine code, the compile only needs to be done once right before deployment and will not affect the development lifecycle of the application. Machine code or machine language is a system of instructions and data directly understandable by a computers central processing unit. ...
Extensibility of the language is also rather limited. The technologies provided to overcome this (ex. PowerBuilder Native Interface, or PBNI) are still rather tricky and buggy. To develop a solution that includes external C++ code may not only require a competent C++ developer, but also a PowerBuilder expert to guide the developer through the myriad of subtleties of the language and the PowerBuilder Virtual Machine. C++ (pronounced see plus plus, IPA: ) is a general-purpose, high-level programming language with low-level facilities. ...
In computer science, a virtual machine is software that creates a virtualized environment between the computer platform and its operating system, so that the end user can operate software on an abstract machine. ...
PowerBuilder does not support reuse of compiled libraries. Reusable Powerbuilder components must be distributed with source code.
Footnotes - ^ PB11.0 beta description
- ^ PowerBuilder Foundation Class Help page, from Ascension Labs
External links |
Feeds |
Contact