Oracle
Sitefinder
    WorldwideChange Country, Oracle Worldwide Web Sites
Secure Search

Glossary

[ A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | # ]

[ S ]



sandbox   In Java, a number of cooperating system components that ensure an untrusted, and possibly malicious, application cannot gain access to system resources.



scalability   The ability to increase or decrease size or capability in cost-effective increments with minimal impact.



schema   A collection of related database objects including tables, views, and other objects.



SDK—software developer's kit   A programming package enabling application development for a specific platform and typically including APIs, programming tools, and documentation.



Secure Socket Layer (SSL)   A commonly-used protocol for managing the security of a message transmission on the internet. Socket refers to the sockets method of passing data back and forth between a client and a server program in a network or between program layers in the same computer. SSL uses the public- and private-key encryption system, which includes the use of a digital certificate.



SELECT   A SQL statement (command) that specifies data retrieval operations for data in a relational database.



selection   The set of dimension values currently chosen for a dimension, or the script that contains conditions or criteria to specify those values.



selector   A set of tools used to choose dimension values to include in a report, table, graph, or dimension list box.



semi-additive   A numeric fact that can be added along some, but not all, dimensions in a fact table.



server   Software that handles the functions required for concurrent, shared access to a database, including processing of SQL and PL/SQL statements originating from client applications.



service level agreement (SLA)   Agreement between the user and a service provider that establishes the level of service to be provided.



servlet   In Java, a program that extends the functionality of a Web server, generating dynamic content and interacting with Web clients using a request-response paradigm.



servlet container   In Java, a container that provides the network services over which requests and responses are sent, decodes requests, and formats responses.



servlet container, distributed   In Java, a servlet container that can run a Web application tagged as distributable and that executes across multiple Java virtual machines running on the same or different hosts.



session   In Java, an object used by a servlet to track a user's interaction with a Web application across multiple HTTP requests.



session bean   In Java, an enterprise bean that is created by a client and that usually exists only for the duration of a single client/server session.



SGML—Standardized Generalized Markup Language   An ISO/ANSI/ECMA standard that specifies a way to annotate text documents with information about types of sections of a document.



shared-nothing architecture   IBM hardware and software architecture in which multiple databases are accessed by the same applications, but do not contain the same information, and are therefore unable to function as backups for each other. The opposite of Oracle clustering technology found in Oracle9i Real Application Clusters.



Simple Mail Transfer Protocol (SMTP)   A part of the TCP/IP Protocol Suite that describes methods for exchanging a common set of network management information.



Simple Object Access Protocol (SOAP)   Protocol that uses a combination of XML-based data structuring and the Hyper TextTransfer Protocol (HTTP) to define a standardized method for invoking methods in objects distributed in diverse operating environments across the internet.



single sign on   The ability to use one password to access many applications.



SLA—service level agreement   Agreement between the user and a service provider that establishes the level of service to be provided.



slice and dice   A mechanism whereby a query can equally analyze information along any dimension of a multidimensional model.



slowly changing dimensions   The tendency of dimension records to change gradually or occasionally over time.



SMTP—Simple Mail Transfer Protocol   A part of the TCP/IP Protocol Suite that describes methods for exchanging a common set of network management information.



snapshots   A copy of the data in a database at any given point in time.



snowflake model   A type of star schema in which the dimension tables are partly or fully normalized. See also normalize, schema, star schema.



SOAP—Simple Object Access Protocol   Protocol that uses a combination of XML-based data structuring and the Hyper Text Transfer Protocol (HTTP) to define a standardized method for invoking methods in objects distributed in diverse operating environments across the internet.



software developers kit (SDK)   A programming package enabling application development for a specific platform and typically including APIs, programming tools, and documentation.



source data   Data used as the basis of a data warehouse. Also called data source.



sparsity   A concept that refers to multidimensional data in which a relatively high percentage of the combinations of dimension values do not contain actual data and that take up storage space in a database.



SQL—Structured Query Language   The standardized relational database language for querying, manipulating, and updating information in a relational database.



SQL statement   A complete command or statement written in the SQL language.



SSL—Secure Sockets Layer   A commonly used protocol for managing the security of a message transmission on the internet. Sockets refers to the sockets method of passing data back and forth between a client and a server program in a network or between program layers in the same computer. SSL uses the public- and private-key encryption system, which includes the use of a digital certificate.



Standardized Generalized Markup Language (SGML)   An ISO/ANSI/ECMA standard that specifies a way to annotate text documents with infomration about types of sections of a document.



star model   A relational schema representing a multidimensional data model and consisting of one or more fact tables and one or more dimension tables that are related through foreign keys. See also schema.



star query   An optimization technique that enables the dimensions and fact tables in the star model to be accessed efficiently, and data returned to the user efficiently by ensuring that dimension data is visited first and fact data visited last and only once.



state  

In programming, the part of a class or object definition that describes what information is contained within the class or object.




stateful session bean   In Java, a session bean with a conversational state.



stateless session bean   In Java, a session bean with no conversational state and for which all instances are identical.



static   In Java, a language keyword used to define a variable as a class variable.



status   The list of currently accessible values for a given dimension. If the status of a given dimension is limited to a subset of its stored values, then all expressions that are based on that dimension will be limited to the corresponding subset of data.



Structured Query Language (SQL)  

The standardized relational database language for querying, manipulating, and updating information in a relational database.




subject area   A vertical portion of the business, such as Sales and Marketing, that is developed as an iteration of an enterprisewide data warehouse.



summary data   Data that is aggregated and stored in a summary fact table and made available to the user for direct and easy access.



summary table   A data structure in a data warehouse that contains summarized, or aggregated, facts.



symmetric multiprocessing (SMP)   A shared-everything hardware and software architecture where memory and disk controllers are accessible to all CPUs.



system administrator   The person responsible for configuring and administering the enterprise's computers, networks, and software systems.



systems integrator (SI)   A service organization that specializes in connecting systems, including hardware, software, and networking.



[ A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | # ]

 
CONTACT
Oracle 1.800.633.0738
email this page E-mail this page printer view Printer View
Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Subscribe | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Your Privacy Rights