Object-PL/SQL (original) (raw)
Object-PL/SQL (Object-Procedural Language/Structured Query Language or simply O-PL/SQL) is a methodology of using the Oracle Corporation's procedural extension language for SQL and the Oracle relational database. The additional features from version 7 and other improvements, lead to one of the large-scale environment implementations of the object-oriented database paradigm. Although PL/SQL's general syntax formerly used to resemble that of Ada or Pascal, there were many improvements that mainly include the Java embedding code and the object-oriented syntax inside the SQL.
| Property | Value |
|---|---|
| dbo:abstract | Object-PL/SQL (Object-Procedural Language/Structured Query Language or simply O-PL/SQL) is a methodology of using the Oracle Corporation's procedural extension language for SQL and the Oracle relational database. The additional features from version 7 and other improvements, lead to one of the large-scale environment implementations of the object-oriented database paradigm. Although PL/SQL's general syntax formerly used to resemble that of Ada or Pascal, there were many improvements that mainly include the Java embedding code and the object-oriented syntax inside the SQL. The mixing and embedding of triggers and stored procedures was one of the breakthrough points up to support the use of PL/SQL in a OO paradigm. The inclusion in the SQL syntax of statements such as [class].[object], and the implementation of the object type (like any OO language), completed the minimum requisites to a mapping approach in an extended SQL language without use of specific mapping software. (en) Object-PL/SQL (Object-Procedural Language/Structured Query Language ou tout simplement O-PL/SQL) est une méthodologie d'usage de l'extension procédurale pour le langage SQL dans la Base de Données Oracle. Les particularités additionnelles de la version 7 au-delà d'autres améliorations ultérieures sont orientées vers l'usage du paradigme de la base de données orientée objet. Bien que la syntaxe générale du langage PL/SQL ressemble à celle du Pascal et de l'Ada, il y a eu beaucoup d'améliorations, qui incluent surtout le code java intégré et la syntaxe orientée objet dans le SQL. L'intégration de déclencheurs et de procédures stockées constituent conjointement une des plus grandes percées qui ont favorisé l'usage du PL/SQL dans un paradigme orienté objet. L'inclusion pour le syntaxe SQL de déclarations comme [class].[object], et aussi l'implementation de l'objet type (similaire à presque tous les langages OO), ont complété le minimum d'articles nécessaires pour la démarche d'une extension du SQL sans l'usage d'aucun logiciel particulier de projection ou persistence framework . (fr) Object-PL/SQL (Object-Procedural Language/Structured Query Language ou simplesmente O-PL/SQL) é uma metodologia de uso da linguagem procedural estendida SQL do Oracle. Os itens adicionais a partir da versão 7 e outros upgrades levaram a um uso em larga escala deste banco de dados no paradigma orientado a objetos. Apesar de a sintaxe do PL/SQL ter sido inicialmente concebida semelhantemente à da Ada e à do Pascal, os avanços posteriores incluíram a possibilidade de uso do código java embutido e de uma sintaxe orientada a objetos no próprio código SQL. A mixagem e uso embutido de triggers e stored procedures foi um dos pontos que levaram ao limiar da concepção do PL/SQL num paradigma OO. Já a inclusão, na sintaxe SQL, de partículas no formato [classe].[objeto], bem como a implementação do objeto tipo (tipo de dado) (como nas linguagens OO em geral) completou os mínimos requisitos para um mapeamento objeto-relacional numa linguagem SQL estendida sem uso de Persistence frameworks. (pt) Object-PL/SQL (объектно-процедурный язык / структурированный язык запросов или просто O-PL/SQL) является методологией использования процедурного языка расширения Oracle для SQL и реляционной базы данных Oracle. Дополнительные возможности из версии 7 и другие улучшения приводят к одной из широкомасштабных реализаций среды объектно-ориентированной парадигмы базы данных. Несмотря на то, что общий синтаксис PL/SQL, ранее использовался для того, чтобы иметь сходство с Ada или Pascal, в нём было много улучшений, которые в основном включают код внедрения Java и объектно-ориентированный синтаксис внутри SQL. Смешивание и внедрение триггеров и хранимых процедур было одним из прорывных пунктов, чтобы поддержать использование PL/SQL в ОО парадигме. Включение в синтаксис SQL таких операторов, как [класс].[объект] и реализация типа объекта (как и любой ОО язык), завершило минимальные требования к отображению подхода на расширенном языке SQL без использования специфического отображаемого программного обеспечения. (ru) |
| dbo:wikiPageExternalLink | http://218.92.71.5:1085/trebook/book/book36/2009986047703.pdf%7Clast1=Rahayu%7Cfirst1=Wenny%7Clast2=taniar%7Cfirst2=David%7Clast3=Pardede%7Cfirst3=Eric%7Ctitle=Object-Oriented http://my.safaribooksonline.com/book/databases/oracle-pl-sql/9780596805401%7Ctitle=Oracle https://books.google.com/books%3Fid=1RwFA-vlwX8C&q=mixing+java+in+pl%2Fsql+procedures+and+triggers&pg=PA144%7Clast=Bennett%7Cfirst=Mathew%7Ctitle=Programming https://books.google.com/books%3Fid=FqUKI3MSuHYC%7Clast=Bales%7Cfirst=Donals%7Ctitle=PL/SQL https://web.archive.org/web/20120917012254/http:/elearning.algonquincollege.com/coursemat/dat2355d/oracle-oo.html https://web.archive.org/web/20160303223746/http:/218.92.71.5:1085/trebook/book/book36/2009986047703.pdf%7Carchive-date=2016-03-03%7Curl-status=dead http://docs.oracle.com/cd/B19306_01/java.102/b14187/chthree.htm%23CACFGDCI%7Ctitle=Calling |
| dbo:wikiPageID | 35557836 (xsd:integer) |
| dbo:wikiPageLength | 10360 (xsd:nonNegativeInteger) |
| dbo:wikiPageRevisionID | 1078295520 (xsd:integer) |
| dbo:wikiPageWikiLink | dbc:Oracle_software dbr:Relational_database_management_system dbr:SQL dbr:Object-oriented_programming dbr:TimesTen dbc:SQL dbr:Component-oriented_database dbr:Syntax_(programming_languages) dbr:Transact-SQL dbr:Database_trigger dbr:Ada_(programming_language) dbr:Database_management_system dbr:PL/SQL dbr:Pascal_(programming_language) dbr:Procedural_programming dbr:Relational_model dbr:Stored_procedure dbr:Java_(programming_language) dbc:Object-oriented_programming dbr:IBM_Db2 dbr:Oracle_Corporation dbr:Oracle_Database dbr:Programming_language dbr:Persistence_framework dbr:Structured_Query_Language dbr:Object-oriented_database |
| dbp:wikiPageUsesTemplate | dbt:Anchor dbt:Cite_book dbt:Cite_web dbt:Main_article dbt:Mono dbt:Reflist |
| dcterms:subject | dbc:Oracle_software dbc:SQL dbc:Object-oriented_programming |
| gold:hypernym | dbr:Methodology |
| rdf:type | dbo:Software yago:Abstraction100002137 yago:ArtificialLanguage106894544 yago:Code106355894 yago:CodingSystem106353757 yago:CommandLanguage106899446 yago:Communication100033020 yago:DatabaseManagementSystem106588785 yago:Language106282651 yago:ProgrammingLanguage106898352 yago:Writing106359877 yago:WrittenCommunication106349220 yago:Software106566077 yago:SourceLanguage106283912 yago:WikicatDatabaseManagementSystems yago:WikicatProgrammingLanguages yago:WikicatQueryLanguages |
| rdfs:comment | Object-PL/SQL (Object-Procedural Language/Structured Query Language or simply O-PL/SQL) is a methodology of using the Oracle Corporation's procedural extension language for SQL and the Oracle relational database. The additional features from version 7 and other improvements, lead to one of the large-scale environment implementations of the object-oriented database paradigm. Although PL/SQL's general syntax formerly used to resemble that of Ada or Pascal, there were many improvements that mainly include the Java embedding code and the object-oriented syntax inside the SQL. (en) Object-PL/SQL (Object-Procedural Language/Structured Query Language ou tout simplement O-PL/SQL) est une méthodologie d'usage de l'extension procédurale pour le langage SQL dans la Base de Données Oracle. Les particularités additionnelles de la version 7 au-delà d'autres améliorations ultérieures sont orientées vers l'usage du paradigme de la base de données orientée objet. Bien que la syntaxe générale du langage PL/SQL ressemble à celle du Pascal et de l'Ada, il y a eu beaucoup d'améliorations, qui incluent surtout le code java intégré et la syntaxe orientée objet dans le SQL. (fr) Object-PL/SQL (Object-Procedural Language/Structured Query Language ou simplesmente O-PL/SQL) é uma metodologia de uso da linguagem procedural estendida SQL do Oracle. Os itens adicionais a partir da versão 7 e outros upgrades levaram a um uso em larga escala deste banco de dados no paradigma orientado a objetos. Apesar de a sintaxe do PL/SQL ter sido inicialmente concebida semelhantemente à da Ada e à do Pascal, os avanços posteriores incluíram a possibilidade de uso do código java embutido e de uma sintaxe orientada a objetos no próprio código SQL. (pt) Object-PL/SQL (объектно-процедурный язык / структурированный язык запросов или просто O-PL/SQL) является методологией использования процедурного языка расширения Oracle для SQL и реляционной базы данных Oracle. Дополнительные возможности из версии 7 и другие улучшения приводят к одной из широкомасштабных реализаций среды объектно-ориентированной парадигмы базы данных. (ru) |
| rdfs:label | Object-PL/SQL (fr) Object-PL/SQL (en) Object-PL/SQL (pt) Object-PL/SQL (ru) |
| owl:sameAs | freebase:Object-PL/SQL yago-res:Object-PL/SQL wikidata:Object-PL/SQL dbpedia-fr:Object-PL/SQL dbpedia-pt:Object-PL/SQL dbpedia-ru:Object-PL/SQL https://global.dbpedia.org/id/362De |
| prov:wasDerivedFrom | wikipedia-en:Object-PL/SQL?oldid=1078295520&ns=0 |
| foaf:isPrimaryTopicOf | wikipedia-en:Object-PL/SQL |
| is dbo:wikiPageRedirects of | dbr:O-PL/SQL |
| is dbo:wikiPageWikiLink of | dbr:PL/SQL dbr:O-PL/SQL |
| is foaf:primaryTopic of | wikipedia-en:Object-PL/SQL |