- Subscribe to this page:
- RSS
- Email Alert
database applications
(763 results)-
White Papers
MODA: Automated Test Generation for Database Applications Via Mock Objects
Sep 2010
Software testing has been commonly used in assuring the quality of database applications. It is often prohibitively expensive to manually write quality tests for complex database applications....
Provided by Association for Computing Machinery
-
White Papers
A Static Analysis Framework for Database Applications
Nov 2008
Database developers today use data access APIs such as ADO.NET to execute SQL queries from their application. These applications often have security problems such as SQL injection vulnerabilities...
Provided by Microsoft
-
White Papers
Supporting Database Applications as a Service
Jul 2009
Multi-tenant data management is a form of Software as a Service (SaaS), whereby a third party service provider hosts databases as a service and provides its customers with seamless mechanisms to...
Provided by Institute of Electrical and Electronics Engineers
-
White Papers
Database Applications to Integrate Beam Line Optics Changes With Engineering Databases
Jun 2007
The LCLS project databases provide key nomenclature information while integrating many engineering and physics processes in the building of an accelerator. Starting with the elements existing in...
Provided by Stanford University
-
Whitepapers
The Top Five Reasons to Choose Toad® Over SQL Developer
Nov 2010
Can you actually save more money using Toad® rather than SQL Developer - a free product? The answer is "yes!" In this surprising Quest technical brief, learn how Toad's revolutionary new...
Provided by Quest Software, now a part of Dell
-
Whitepapers
Gartner Report: Consider Oracle Standard Edition to Reduce Database Management Systems Costs
Mar 2010
Is your company overspending on Oracle database management licensing and maintenance solutions? In a tough economy you need to stretch every cent to the breaking point to deliver optimum service...
Provided by Quest Software, now a part of Dell
-
Podcasts
Podcast: Introducing Oracle Fusion Governance, Risk, and Compliance AppCast (MP3, 13 min.)
Dec 2010
Oracle provides a secure path for customers to benefit from the latest technology advances to drive better business performance. Oracle Application Unlimited is Oracle's commitment to customer...
Provided by Oracle
-
Podcasts
Podcast: Leveraging Blueprints to Easily Extend the Value of Your Investment in Oracle GRC Applications (MP3, 12 min.)
Dec 2010
Hundreds of customers globally have invested in Oracle GRC Applications to help solve mission-critical compliance and risk management challenges. To further extend the value of these investments,...
Provided by Oracle
-
Podcasts
How Do I: Add Branding to a Visual Studio Integration Package?
Dec 2010
Add branding for the VSPackage and have the branding appear in the Help...About screen and the Microsoft Visual Studio start-up splash screen. The speaker explains Add Branding to a Visual Studio...
Provided by Microsoft
-
White Papers
Oracle Database Smart Flash Cache
Sep 2010
Available at no additional cost, Database Smart Flash Cache on Oracle Solaris and Oracle Enterprise Linux has the potential to offer considerable benefit to users of Oracle Database 11g Release 2...
Provided by Oracle
-
White Papers
Information for Success: Customer Experiences with Oracle Enterprise Manager
Jan 2011
Managing IT is no longer just about managing discrete IT components. Business users demand faster transactions, highly available business processes, and other similar business-centric results that...
Provided by Oracle
-
White Papers
On the Application of Data Mining to Official Data
Jan 2009
Retrieving valuable knowledge and statistical patterns from official data has a great potential in supporting strategic policy making. Data Mining (DM) techniques are well-known for providing...
Provided by Cardiff University
-
White Papers
Semantic Focused Crawling for Retrieving ECommerce Information
Jun 2009
Focused crawling is proposed to selectively seek out pages that are relevant to a predefined set of topics without downloading all pages of the Web. With the rapid growth of the E-commerce, how to...
Provided by Academy Publisher
-
Whitepapers
Ensure High Availability for Critical Systems and Apps With SharePlex
Jan 2011
Your business counts on the availability of your Oracle databases 24/7/365 - so ANY downtime impacts your company and results in loss of business. How can you make sure your databases are...
Provided by Quest Software, now a part of Dell
-
Whitepapers
Achieving Oracle Database Scalability With or Without RAC
Jan 2011
Oracle Real Application Clusters (RAC) allows organizations to scale databases horizontally by load balancing across multiple servers. But RAC has limitations in availability, performance,...
Provided by Quest Software, now a part of Dell
-
Whitepapers
Getting Started with Master Data Services
Feb 2011
Master Data Services in SQL Server 2008 R2 allows an organization to define a "single source of truth" about its enterprise data using a purpose-built centralized database and a predefined Web...
Provided by Global Knowledge
-
White Papers
Information Governs: Run Your Business Better-and Prove It.
Feb 2011
In the past, organizations have chosen to tackle governance, risk, and compliance (GRC) projects among different departments and business units. As a result, this myopic strategy can be costly,...
Provided by Oracle
-
White Papers
Planning a Microsoft Access Database Application
Sep 2006
To design a Microsoft Access Database application, one will first need to define the purpose of the application by determining how it will be used and what are the results that it must produce. A...
Provided by databasedev.co.uk
-
White Papers
Guide to Advanced Linux Command Mastery
Aug 2006
In this four-part series, the reader will learn some not-so-well-known tricks about various routine Linux commands as well as variations in usage that make them more useful. As the series...
Provided by Oracle
-
Webcasts
Create an Access Database From an Excel Workbook
Oct 2006
Is one a long-time user of Excel, with data that is growing in complexity or that changes frequently? Is one wasting time trying to remember where he has stored specific information, or is he...
Provided by Microsoft
-
White Papers
Using PHP to Create Custom SSO Login and Sign-Off Pages
Oct 2004
If a person has installed Oracle Application Server 10g Enterprise Edition and are ready to create custom SSO login and sign-off pages, then he or she might want to consider using PHP over the...
Provided by Oracle
-
White Papers
NetQoS to IM and APM whitepaper
Mar 2011
IT professionals tasked with managing today's dynamic and increasingly complex local- and wide-area networks are often judged by how well they can optimize availability and performance to provide...
Provided by CA
-
White Papers
CADS: Continuous Authentication on Data Streams
Sep 2007
The authors study processing and authentication of long-running queries on outsourced data streams. In this scenario, a Data Owner (DO) constantly transmits its data to a Service Provider (SP),...
Provided by Association for Computing Machinery
-
White Papers
Identifying Biologically Relevant Genes Via Multiple Heterogeneous Data Sources
Aug 2008
Selection of genes that are differentially expressed and critical to a particular biological process has been a major challenge in post-array analysis. Recent development in bioinformatics has...
Provided by Association for Computing Machinery
-
White Papers
BibBase Triplified
Sep 2010
The authors present BibBase, a system for publishing and managing bibliographic data available in BibTeX files. BibBase uses a powerful yet light-weight approach to transform BibTeX les into rich...
Provided by Association for Computing Machinery
-
White Papers
Linkage Query Writer
Aug 2009
The authors present Linkage Query Writer (LinQuer), a system for generating SQL queries for semantic link discovery over relational data. The LinQuer framework consists of LinQL, a language for...
Provided by VLDB Endowment
-
White Papers
SAFELI ? SQL Injection Scanner Using Symbolic Execution
Jul 2008
This paper presents the current progress, main algorithm, and the open problems of a tool set called "SAFELI," for detecting SQL Injection vulnerabilities resident in Web applications. SAFELI...
Provided by Association for Computing Machinery
-
White Papers
Building Highly Scalable Web Applications With XStream
Aug 2010
Web applications with a very large number of users place an enormous load on the back-end databases for queries as well as transaction processing. As the underlying workload grows, web companies...
Provided by Oracle
-
White Papers
Oracle Streams for Near Real Time Asynchronous Replication
Jun 2007
Replication users typically have two very conflicting needs. They require the online transaction workload to proceed seamlessly, as if there was no replication. At the same time, they need the...
Provided by Oracle USA
-
White Papers
Oracle Streams: A High Performance Implementation for Near Real Time Asynchronous Replication
Jun 2008
The authors present the architectural design and recent performance optimizations of a state of the art commercial database replication technology provided in Oracle Streams. The underlying design...
Provided by Oracle USA
-
White Papers
XTOLS: Cross-Tier Oracle Label Security
Apr 2009
SELINKS allows cross-tier security enforcement between the application tier and the database tier by compiling policy functions and database queries into User-Defined Functions (UDFs) and SQL...
Provided by University of Maryland
-
White Papers
Depth Estimation for Ranking Query Optimization
Jul 2007
A relational ranking query uses a scoring function to limit the results of a conventional query to a small number of the most relevant answers. The increasing popularity of this query paradigm has...
Provided by BEA Systems
-
White Papers
Index Interactions in Physical Design Tuning: Modeling, Analysis, and Applications
Aug 2009
One of the key tasks of a database administrator is to optimize the set of materialized indices with respect to the current workload. To aid administrators in this challenging task, commercial...
Provided by VLDB Endowment
-
White Papers
Answering Queries Using Humans, Algorithms and Databases
Jan 2011
For some problems, human assistance is needed in addition to automated (algorithmic) computation. In sharp contrast to existing data management approaches, where human input is either ad-hoc or is...
Provided by Stanford University
-
White Papers
An Abstract Semantics and Concrete Language for Continuous Queries Over Streams and Relations
Jan 2011
Despite the recent surge of research in query processing over data streams, little attention has been devoted to defining precise semantics for continuous queries over streams. The authors first...
Provided by Stanford University
-
White Papers
From Regular Expressions to Nested Words: Unifying Languages and Query Execution for Relational and XML Sequences
Oct 2009
There is growing interest in query language extensions for pattern matching over event streams and stored database sequences, due to the many important applications that such extensions make...
Provided by VLDB Endowment
-
White Papers
A Data Stream Mining System
Oct 2008
On-line data stream mining has attracted much research interest, but systems that can be used as a workbench for online mining have not been researched, since they pose many difficult research...
Provided by University of California
-
White Papers
Improving the Accuracy of Continuous Aggregates and Mining Queries on Data Streams Under Load Shedding
Mar 2008
Random samples are common in data streams applications due to limitations in data sources and transmission lines, or to load-shedding policies. Here the authors introduce a formal error model and...
Provided by Inderscience Enterprises
-
White Papers
Mining Databases and Data Streams With Query Languages and Rules
Jan 2011
Among data-intensive applications that are beyond the reach of traditional Data Base Management Systems (DBMS), data mining stands out because of practical importance and the complexity of the...
Provided by UCLA
-
White Papers
Event-Oriented Data Models and Temporal Queries in Transaction-Time Databases
May 2009
Past research on temporal databases has primarily focused on state-based representations and on relational query language extensions for such representations. This led to many different proposals...
Provided by University of California
-
White Papers
InfiniBand Software and Protocols Enable Seamless Off-The Shelf Applications Deployment
Dec 2007
InfiniBand architecture defines a high-bandwidth, low-latency clustering interconnect that is used for High-Performance Computing (HPC) and Enterprise Data Center (EDC) class applications. It is...
Provided by Mellanox Technologies
-
White Papers
XStream: A Signal-Oriented Data Stream Management System
Nov 2007
Sensors capable of sensing phenomena at high data rates on the order of tens to hundreds of thousands of samples per second are now widely deployed in many industrial, civil engineering,...
Provided by Massachusetts Institute of Technology
-
Podcasts
How Do I: The SQL Server 2008 Resource Governor?
Jul 2008
In this podcast, the speaker explores the SQL Server 2008 resource governor. The resource governor can help people allocate one CPU and memory effectively and ensure that rougue queries do not...
Provided by Microsoft Corporation
-
Podcasts
How Do I: Use Policy Based Management Features of SQL Server 2008 to Manage SQL Servers?
Jul 2010
In this podcast, the speaker tells about how to use the new policy based management features of SQL Server 2008 to manage the SQL Servers. Scott shows one how to use facets, create conditions, and...
Provided by Microsoft Corporation
-
Podcasts
How Do I: The New SQL Audit Feature of SQL Server 2008?
Jul 2010
In this podcast, the speaker tells about one new SQL Audit feature of SQL Server 2008. Scott shows one how to set up a server audit using Transact SQL. He also shows one how to create a database...
Provided by Microsoft Corporation
-
Podcasts
How Do I: Synchronizing Remote SQL Server Databases With the Sync Framework?
Jul 2010
In this podcast, the speaker tells about shows how to install the synchronization framework and then how to use it in conjunction with SQL Server 2008 change tracking to update remote,...
Provided by Microsoft Corporation
-
Podcasts
How Do I: Streamline an Upgrade From SQL Server 2005 to SQL Server 2008?
Jul 2010
In this podcast the speaker introduces the SQL Server Upgrade Advisor. He then shows two methods for using the command line to upgrade a SQL server without having to wait for dialog boxes or...
Provided by Microsoft Corporation
-
Podcasts
How Do I: Manage SQL Server 2008 Spatial Data?
Jul 2010
In this podcast, the speaker tells about an overview of spatial data in SQL Server 2008. Using the geometry data type Scott looks at some of the functions that a DBA might have to know to properly...
Provided by Microsoft Corporation
-
Podcasts
How Do I: Create and Modify Reports Using the Report Builder Tool?
Jul 2010
In this podcast, the speaker tells about how to use SQL Server 2008 Business Intelligence Studio to create a report model. The people then use the report model and the Report Builder tool to...
Provided by Microsoft Corporation
-
Podcasts
How Do I: Setting Up a Maintenance Plan to Backup Databases?
Jul 2010
In this podcast, the speaker tells about how to create database maintenance plans using the Maintenance Plan wizard and SQL Server Integration Services (SSIS). The speaker also shows how to...
Provided by Microsoft Corporation
-
Podcasts
How Do I: Automate Report Delivery in SQL Server Reporting Services Using Subscriptions?
Jul 2010
The speaker tells about how to create report subscriptions to au This demo shows how to: configure a shared data source to store credentials (required for subscriptions), configure SSRS for SMTP...
Provided by Microsoft Corporation
-
Podcasts
How Do I: Provide an Up-to-Date Data Warehouse With Change Data Capture?
Jul 2010
In this podcast, the speaker introduces one to the Change Data Capture feature of SQL Server 2008. After showing how to configure Change Data Capture on a database Scott shows a sample SSIS...
Provided by Microsoft Corporation
-
Podcasts
How Do I: Create and Publish a Data Cube for SQL Server Analysis Server 2008?
Jul 2010
This podcast, the speaker tells about how to use Business Intelligence Development Studio (BIDS) to create an data cube for SQL Server Analysis Server 2008. This demo shows how to: Use BIDS to...
Provided by Microsoft Corporation
-
Podcasts
How Do I: Use PowerShell to Transfer Data?
Jul 2010
PowerShell can be used to export or import data. By creating a simple script one can easily move data between databases. This can be given to developers or testers to allow them to refresh data in...
Provided by Microsoft Corporation
-
Podcasts
How Do I: Block Connections to SQL Server by IP Address Using Logon Triggers?
Jul 2010
This podcast, the speaker tells about how to restrict access to SQL Server 2005 SP 2 (Or Above) based on IP Address. This demo shows how to:- Retrieve the IP Address of the client using the...
Provided by Microsoft Corporation
-
Podcasts
How Do I: Configure Database Mail in SQL Server 2008?
Jul 2010
Database Mail is useful for sending e-mail to administrators and end users. Database mail can contain data from queries or from files or other resources on one's network. In this podcast, the...
Provided by Microsoft Corporation
-
Podcasts
How Do I: Import Data From Oracle Databases?
Jul 2010
Many organizations have both Oracle and SQL Server databases. In this video speaker shows how easy it is to use the import data wizard and SQL Server Integration Services to import data from a...
Provided by Microsoft Corporation
-
Podcasts
How Do I: Use the Service Audit Object in SQL Server 2008?
Jul 2010
In this podcast, the speaker tells about how to use the Service Audit Object to record events within SQL Server 2008 Enterprise Edition. This demo shows how to Create a Server Audit Object-Create...
Provided by Microsoft Corporation
-
Podcasts
How Do I: Use the Row Value Constructor to Insert Data Into a SQL Server 2008 Table?
Jul 2010
In this podcast, the speaker tells about how to insert data into a SQL Server 2008 table using the Row Value Constructor. This demo shows how to Insert data into a SQL Server 2008 table-Four...
Provided by Microsoft Corporation
-
Podcasts
How Do I: Import Text Files With SQL Server Integration Services?
Jul 2008
Many programs produce logs as plain text files. Sometimes these log files need to be imported into SQL Server to allow further analysis of the data. In this podcast, the speaker tells about shows...
Provided by Microsoft Corporation
-
Podcasts
How Do I: Profile Data With the Data Profiling Task and Viewer?
Jul 2010
Data quality is important to every business. Using the SQL Server 2008 Data Profiling task computes statistics about the data in a database to spot incorrect values. The Data Profiling viewer...
Provided by Microsoft Corporation
-
Podcasts
How Do I: Using the HierarchyID Data Type in SQL Server 2008 to Manage Data Hierarchies?
Jul 2010
Managing hierarchies in Information Systems has long been a challenge to most information systems professionals. The issues are simple, but the implementation of hierarchies within databases is...
Provided by Microsoft Corporation
-
Podcasts
How Do I: Setup Snapshot Replication With SQL Server 2008?
Jul 2010
This podcast, the speaker tells about how to configure Snapshot Replication between two instances of SQL Server 2008. This video demonstrates the following: Creating a Publisher database, Creating...
Provided by Microsoft Corporation
-
Podcasts
How Do I: Use SQL Profiler With SQL Server 2008?
Jul 2010
This podcast, the speaker tells about how use SQL Profiler to perform the following tasks: - Create and Edit Traces-Create Trace Templates-Watch Trace results-Start, Pause, and Stop a Trace-Replay...
Provided by Microsoft Corporation
-
Podcasts
How Do I: Forecast Table Analysis Tool?
Jul 2010
In this tutorial one will learn how to use the Forecast Table Analysis Tool for Excel. The Forecast tool uses the Microsoft time series algorithm to predict future values based on trends in...
Provided by Microsoft Corporation
-
Podcasts
How Do I: Highlight Exceptions Table Analysis Tool for Data Mining?
Jul 2010
In this podcast, the speaker tells will learn how to use the Highlight Exceptions Table Analysis Tool for Excel. The Highlight Exceptions tool uses the Microsoft clustering algorithm and pattern...
Provided by Microsoft Corporation
-
Podcasts
How Do I: Integrate a Map With SQL Server Reporting Services?
Jul 2010
This podcast, the speaker tells about how to insert a map into a report using SQL Server 2008 R2 Reporting Services. The map utilizes spatial data within a SQL Server database. This video...
Provided by Microsoft Corporation
-
Podcasts
The Value of Business Intelligence With SQL 2008 R2, Office 2010 and SharePoint 2010
Aug 2010
In a challenging economic environment, businesses must be even more agile and responsive to changes in the marketplace. From the chief executive to the marketing analyst, users need relevant...
Provided by Microsoft Corporation
-
White Papers
JReq: Database Queries in Imperative Languages
Jan 2010
Instead of writing SQL queries directly, programmers often prefer writing all their code in a general purpose programming language like Java and having their programs be automatically rewritten to...
Provided by University of Massachusetts
-
White Papers
Automatic Generation of XSS and SQL Injection Attacks With Goal-Directed Model Checking
May 2008
Cross-site scripting (XSS) and SQL injection errors are two prominent examples of taint-based vulnerabilities that have been responsible for a large number of security breaches in recent years....
Provided by Stanford University
-
White Papers
Efficient Index Compression in DB2 LUW
Aug 2009
In database systems, the cost of data storage and retrieval are important components of the total cost and response time of the system. A popular mechanism to reduce the storage footprint is by...
Provided by Association for Computing Machinery
-
White Papers
Optimizing Content Freshness of Relations Extracted From the Web Using Keyword Search
Jun 2010
An increasing number of applications operate on data obtained from the Web. These applications typically maintain local copies of the web data to avoid network latency in data accesses. As the...
Provided by Association for Computing Machinery
-
White Papers
Event-Oriented Data Models and Temporal Queries in Transaction-Time Databases
May 2009
Past research on temporal databases has primarily focused on state-based representations and on relational query language extensions for such representations. This led to many different proposals...
Provided by University of California
-
White Papers
Mining Databases and Data Streams With Query Languages and Rules
Jan 2011
Among data-intensive applications that are beyond the reach of traditional Data Base Management Systems (DBMS), data mining stands out because of practical importance and the complexity of the...
Provided by UCLA
-
White Papers
Improving the Accuracy of Continuous Aggregates and Mining Queries on Data Streams Under Load Shedding
Mar 2008
Random samples are common in data streams applications due to limitations in data sources and transmission lines, or to load-shedding policies. Here the authors introduce a formal error model and...
Provided by Inderscience Enterprises
-
White Papers
A Data Stream Mining System
Oct 2008
On-line data stream mining has attracted much research interest, but systems that can be used as a workbench for online mining have not been researched, since they pose many difficult research...
Provided by University of California
-
White Papers
From Regular Expressions to Nested Words: Unifying Languages and Query Execution for Relational and XML Sequences
Oct 2009
There is growing interest in query language extensions for pattern matching over event streams and stored database sequences, due to the many important applications that such extensions make...
Provided by VLDB Endowment
-
White Papers
An Abstract Semantics and Concrete Language for Continuous Queries Over Streams and Relations
Jan 2011
Despite the recent surge of research in query processing over data streams, little attention has been devoted to defining precise semantics for continuous queries over streams. The authors first...
Provided by Stanford University
-
White Papers
Answering Queries Using Humans, Algorithms and Databases
Jan 2011
For some problems, human assistance is needed in addition to automated (algorithmic) computation. In sharp contrast to existing data management approaches, where human input is either ad-hoc or is...
Provided by Stanford University
-
White Papers
Index Interactions in Physical Design Tuning: Modeling, Analysis, and Applications
Aug 2009
One of the key tasks of a database administrator is to optimize the set of materialized indices with respect to the current workload. To aid administrators in this challenging task, commercial...
Provided by VLDB Endowment
-
White Papers
Oracle Streams for Near Real Time Asynchronous Replication
Jun 2007
Replication users typically have two very conflicting needs. They require the online transaction workload to proceed seamlessly, as if there was no replication. At the same time, they need the...
Provided by Oracle USA
-
White Papers
Oracle Streams: A High Performance Implementation for Near Real Time Asynchronous Replication
Jun 2008
The authors present the architectural design and recent performance optimizations of a state of the art commercial database replication technology provided in Oracle Streams. The underlying design...
Provided by Oracle USA
-
White Papers
XTOLS: Cross-Tier Oracle Label Security
Apr 2009
SELINKS allows cross-tier security enforcement between the application tier and the database tier by compiling policy functions and database queries into User-Defined Functions (UDFs) and SQL...
Provided by University of Maryland
-
White Papers
Depth Estimation for Ranking Query Optimization
Jul 2007
A relational ranking query uses a scoring function to limit the results of a conventional query to a small number of the most relevant answers. The increasing popularity of this query paradigm has...
Provided by BEA Systems
-
White Papers
Index Interactions in Physical Design Tuning: Modeling, Analysis, and Applications
Aug 2009
One of the key tasks of a database administrator is to optimize the set of materialized indices with respect to the current workload. To aid administrators in this challenging task, commercial...
Provided by VLDB Endowment
-
White Papers
Answering Queries Using Humans, Algorithms and Databases
Jan 2011
For some problems, human assistance is needed in addition to automated (algorithmic) computation. In sharp contrast to existing data management approaches, where human input is either ad-hoc or is...
Provided by Stanford University
-
White Papers
An Abstract Semantics and Concrete Language for Continuous Queries Over Streams and Relations
Jan 2011
Despite the recent surge of research in query processing over data streams, little attention has been devoted to defining precise semantics for continuous queries over streams. The authors first...
Provided by Stanford University
-
White Papers
From Regular Expressions to Nested Words: Unifying Languages and Query Execution for Relational and XML Sequences
Oct 2009
There is growing interest in query language extensions for pattern matching over event streams and stored database sequences, due to the many important applications that such extensions make...
Provided by VLDB Endowment
-
White Papers
A Data Stream Mining System
Oct 2008
On-line data stream mining has attracted much research interest, but systems that can be used as a workbench for online mining have not been researched, since they pose many difficult research...
Provided by University of California
-
White Papers
Improving the Accuracy of Continuous Aggregates and Mining Queries on Data Streams Under Load Shedding
Mar 2008
Random samples are common in data streams applications due to limitations in data sources and transmission lines, or to load-shedding policies. Here the authors introduce a formal error model and...
Provided by Inderscience Enterprises
-
White Papers
Mining Databases and Data Streams With Query Languages and Rules
Jan 2011
Among data-intensive applications that are beyond the reach of traditional Data Base Management Systems (DBMS), data mining stands out because of practical importance and the complexity of the...
Provided by UCLA
-
White Papers
Event-Oriented Data Models and Temporal Queries in Transaction-Time Databases
May 2009
Past research on temporal databases has primarily focused on state-based representations and on relational query language extensions for such representations. This led to many different proposals...
Provided by University of California
-
White Papers
Optimizing Content Freshness of Relations Extracted From the Web Using Keyword Search
Jun 2010
An increasing number of applications operate on data obtained from the Web. These applications typically maintain local copies of the web data to avoid network latency in data accesses. As the...
Provided by Association for Computing Machinery
-
White Papers
Efficient Index Compression in DB2 LUW
Aug 2009
In database systems, the cost of data storage and retrieval are important components of the total cost and response time of the system. A popular mechanism to reduce the storage footprint is by...
Provided by Association for Computing Machinery
-
White Papers
Automatic Generation of XSS and SQL Injection Attacks With Goal-Directed Model Checking
May 2008
Cross-site scripting (XSS) and SQL injection errors are two prominent examples of taint-based vulnerabilities that have been responsible for a large number of security breaches in recent years....
Provided by Stanford University
-
White Papers
JReq: Database Queries in Imperative Languages
Jan 2010
Instead of writing SQL queries directly, programmers often prefer writing all their code in a general purpose programming language like Java and having their programs be automatically rewritten to...
Provided by University of Massachusetts
-
Podcasts
The Value of Business Intelligence With SQL 2008 R2, Office 2010 and SharePoint 2010
Aug 2010
In a challenging economic environment, businesses must be even more agile and responsive to changes in the marketplace. From the chief executive to the marketing analyst, users need relevant...
Provided by Microsoft Corporation
-
Podcasts
How Do I: Integrate a Map With SQL Server Reporting Services?
Jul 2010
This podcast, the speaker tells about how to insert a map into a report using SQL Server 2008 R2 Reporting Services. The map utilizes spatial data within a SQL Server database. This video...
Provided by Microsoft Corporation
-
Podcasts
How Do I: Highlight Exceptions Table Analysis Tool for Data Mining?
Jul 2010
In this podcast, the speaker tells will learn how to use the Highlight Exceptions Table Analysis Tool for Excel. The Highlight Exceptions tool uses the Microsoft clustering algorithm and pattern...
Provided by Microsoft Corporation
-
Podcasts
How Do I: Forecast Table Analysis Tool?
Jul 2010
In this tutorial one will learn how to use the Forecast Table Analysis Tool for Excel. The Forecast tool uses the Microsoft time series algorithm to predict future values based on trends in...
Provided by Microsoft Corporation
-
Podcasts
How Do I: Use SQL Profiler With SQL Server 2008?
Jul 2010
This podcast, the speaker tells about how use SQL Profiler to perform the following tasks: - Create and Edit Traces-Create Trace Templates-Watch Trace results-Start, Pause, and Stop a Trace-Replay...
Provided by Microsoft Corporation
-
Podcasts
How Do I: Setup Snapshot Replication With SQL Server 2008?
Jul 2010
This podcast, the speaker tells about how to configure Snapshot Replication between two instances of SQL Server 2008. This video demonstrates the following: Creating a Publisher database, Creating...
Provided by Microsoft Corporation
-
Podcasts
How Do I: Profile Data With the Data Profiling Task and Viewer?
Jul 2010
Data quality is important to every business. Using the SQL Server 2008 Data Profiling task computes statistics about the data in a database to spot incorrect values. The Data Profiling viewer...
Provided by Microsoft Corporation
-
Podcasts
How Do I: Import Text Files With SQL Server Integration Services?
Jul 2008
Many programs produce logs as plain text files. Sometimes these log files need to be imported into SQL Server to allow further analysis of the data. In this podcast, the speaker tells about shows...
Provided by Microsoft Corporation
-
Podcasts
How Do I: Use the Row Value Constructor to Insert Data Into a SQL Server 2008 Table?
Jul 2010
In this podcast, the speaker tells about how to insert data into a SQL Server 2008 table using the Row Value Constructor. This demo shows how to Insert data into a SQL Server 2008 table-Four...
Provided by Microsoft Corporation
-
Podcasts
How Do I: Use the Service Audit Object in SQL Server 2008?
Jul 2010
In this podcast, the speaker tells about how to use the Service Audit Object to record events within SQL Server 2008 Enterprise Edition. This demo shows how to Create a Server Audit Object-Create...
Provided by Microsoft Corporation
-
Podcasts
How Do I: Import Data From Oracle Databases?
Jul 2010
Many organizations have both Oracle and SQL Server databases. In this video speaker shows how easy it is to use the import data wizard and SQL Server Integration Services to import data from a...
Provided by Microsoft Corporation
-
Podcasts
How Do I: Configure Database Mail in SQL Server 2008?
Jul 2010
Database Mail is useful for sending e-mail to administrators and end users. Database mail can contain data from queries or from files or other resources on one's network. In this podcast, the...
Provided by Microsoft Corporation
-
Podcasts
How Do I: Block Connections to SQL Server by IP Address Using Logon Triggers?
Jul 2010
This podcast, the speaker tells about how to restrict access to SQL Server 2005 SP 2 (Or Above) based on IP Address. This demo shows how to:- Retrieve the IP Address of the client using the...
Provided by Microsoft Corporation
-
Podcasts
How Do I: Use PowerShell to Transfer Data?
Jul 2010
PowerShell can be used to export or import data. By creating a simple script one can easily move data between databases. This can be given to developers or testers to allow them to refresh data in...
Provided by Microsoft Corporation
-
Podcasts
How Do I: Create and Publish a Data Cube for SQL Server Analysis Server 2008?
Jul 2010
This podcast, the speaker tells about how to use Business Intelligence Development Studio (BIDS) to create an data cube for SQL Server Analysis Server 2008. This demo shows how to: Use BIDS to...
Provided by Microsoft Corporation
-
Podcasts
How Do I: Provide an Up-to-Date Data Warehouse With Change Data Capture?
Jul 2010
In this podcast, the speaker introduces one to the Change Data Capture feature of SQL Server 2008. After showing how to configure Change Data Capture on a database Scott shows a sample SSIS...
Provided by Microsoft Corporation
-
Podcasts
How Do I: Automate Report Delivery in SQL Server Reporting Services Using Subscriptions?
Jul 2010
The speaker tells about how to create report subscriptions to au This demo shows how to: configure a shared data source to store credentials (required for subscriptions), configure SSRS for SMTP...
Provided by Microsoft Corporation
-
Podcasts
How Do I: Setting Up a Maintenance Plan to Backup Databases?
Jul 2010
In this podcast, the speaker tells about how to create database maintenance plans using the Maintenance Plan wizard and SQL Server Integration Services (SSIS). The speaker also shows how to...
Provided by Microsoft Corporation
-
Podcasts
How Do I: Create and Modify Reports Using the Report Builder Tool?
Jul 2010
In this podcast, the speaker tells about how to use SQL Server 2008 Business Intelligence Studio to create a report model. The people then use the report model and the Report Builder tool to...
Provided by Microsoft Corporation
-
Podcasts
How Do I: Manage SQL Server 2008 Spatial Data?
Jul 2010
In this podcast, the speaker tells about an overview of spatial data in SQL Server 2008. Using the geometry data type Scott looks at some of the functions that a DBA might have to know to properly...
Provided by Microsoft Corporation
-
Podcasts
How Do I: Streamline an Upgrade From SQL Server 2005 to SQL Server 2008?
Jul 2010
In this podcast the speaker introduces the SQL Server Upgrade Advisor. He then shows two methods for using the command line to upgrade a SQL server without having to wait for dialog boxes or...
Provided by Microsoft Corporation
-
Podcasts
How Do I: Synchronizing Remote SQL Server Databases With the Sync Framework?
Jul 2010
In this podcast, the speaker tells about shows how to install the synchronization framework and then how to use it in conjunction with SQL Server 2008 change tracking to update remote,...
Provided by Microsoft Corporation
-
Podcasts
How Do I: The New SQL Audit Feature of SQL Server 2008?
Jul 2010
In this podcast, the speaker tells about one new SQL Audit feature of SQL Server 2008. Scott shows one how to set up a server audit using Transact SQL. He also shows one how to create a database...
Provided by Microsoft Corporation
-
Podcasts
How Do I: Use Policy Based Management Features of SQL Server 2008 to Manage SQL Servers?
Jul 2010
In this podcast, the speaker tells about how to use the new policy based management features of SQL Server 2008 to manage the SQL Servers. Scott shows one how to use facets, create conditions, and...
Provided by Microsoft Corporation
