Pages

▼
Showing posts with label database objects. Show all posts
Showing posts with label database objects. Show all posts
17 March 2024

🧭Business Intelligence: Data Products (Part II: The Complexity Challenge)

›
Business Intelligence Series Creating data products within a data mesh resumes in "partitioning" a given set of inputs, outputs an...
30 March 2011

🔹SQL Server: Filegroup (Definitions)

›
"A named collection of one or more database files that forms a single unit of allocation and administration. Filegroups enable the crea...
01 January 2011

🔖Book Review: Lynn Beighley's "Head First SQL" (2011)

›
I love the Head First O’Reilly book series which besides the book on SQL , has acquired over its short existence several other titles like ...
07 August 2010

Database Design: Object Dependencies (Part I - An Introduction)

›
Data Management Series Introduction Around the various data islands existing in the blue and the models that support them are created a wh...
04 November 2009

Database Management: Views II

›
Database Management Series Apart from the various versions of SQL ANSI standards, each RDBMS vendor takes the liberty to implement its own s...
25 May 2009

🛢DBMS: Object Permissions (Definitions)

›
"These are permissions that enable a user to work with data in an object. For example, SELECT is the object permission that enables a u...

🛢DBMS: Permissions (Definitions)

›
"A permission is a right to do something in a database. Examples include performing a database function (such as creating table) or wor...
15 April 2009

🛢DBMS: Transactional Replication (Definitions)

›
"A type of replication that marks selected transactions in the Publisher's database transaction log for replication and then distri...
04 April 2009

🛢DBMS: Role (Definitions)

›
"Provide individual accountability for users performing system administration and security-related tasks in SQL Server. The System Admi...
12 March 2009

🛢DBMS: Object (Definitions)

›
"Conceptually a container that holds data in the database. Objects have various properties including an access control list." (Owe...
20 February 2009

🛢DBMS: Database Objects [DBO] (Definitions)

›
"One of the components of a database: table, view, index, procedure, trigger, column, default, or rule." (Karen Paulsell et al, ...
25 January 2009

🛢DBMS: Materialized View (Definitions)

›
"A view whose rows take up space. When you select from a view, the DBMS can elect to do one of two things: (a) it can get the rows from...
04 January 2009

🛢DBMS: User-defined Functions [UDFs] (Definitions)

›
"A Transact- SQL function defined by a user. Functions encapsulate frequently performed logic in a named entity that can be called by T...
03 January 2009

🛢DBMS: Stored Procedures [SP] (Definitions)

›
"A collection of SQL statements and optional control-of-flow statements stored under a name. SQL Server-supplied stored procedures are ...
02 January 2009

🛢DBMS: Views (Definitions)

›
"An alternative way of looking at the data in one or more tables. Usually created as a subset of columns from one or more tables."...
01 January 2009

🛢DBMS: Database Object (Definitions)

›
"One of the components of a database: table, view, index, procedure, trigger, column, default, or rule." (Karen Paulsell et al, ...